push_v1_ethereum

Tables

EPNS_Transfer_event

Token transfer events from the Ethereum Push Notification Service (EPNS) protocol on Ethereum. Used for tracking PUSH token movements and analyzing holder distribution, liquidity flows, and protocol participation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xaf31fd9c3b0350424bf96e551d2d1264d8466205	0xf418588522d5dd018b425e472991e52ebbeeeeee	0x00000000a991c429ee2ec6df19d40fe0c80088b8	false	20893321246139702293215	44	16603089	2023-02-11T04:19:35.000Z	0x1d713885f6947161caabc78603b56790dcc9e0e051553c07cafd9f846da6ee85
0x0d0707963952f2fba59dd06f2b425ace40b492fe	0xf418588522d5dd018b425e472991e52ebbeeeeee	0x0e06b096b4004c35e7b2f45bbdfae538838c3231	false	4741000000000000000000	112	16602507	2023-02-11T02:21:59.000Z	0x84a603abddceae36b0bba2274ae55f62164220b7ea04dcb664eb3d76d550b44c
0x0d0707963952f2fba59dd06f2b425ace40b492fe	0xf418588522d5dd018b425e472991e52ebbeeeeee	0x0e06b096b4004c35e7b2f45bbdfae538838c3231	false	3576000000000000000000	86	16605486	2023-02-11T12:22:11.000Z	0x9317bcde9a7693b87302299671ca75b5b9ee0cb229af336d78f28654d0182f3c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNS_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EPNSCoreV1_5_AddChannel_event

Channel registration events from EPNS (Ethereum Push Notification Service) protocol showing when notification channels are created on Ethereum. Contains channel addresses, IPFS metadata identifiers, and channel types for tracking notification service onboarding.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_channel`	`STRING`	Address of the notification channel in the EPNS protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_channelType`	`INT64`	Numeric identifier specifying the channel category within the Push Protocol notification system. Common value is 2, representing a specific channel type classification.
`in_identity`	`STRING`	IPFS content identifier (CID) for the channel’s metadata, stored as hex-encoded bytes. This identifier points to off-chain channel information like name, description, and icon in IPFS or similar decentralized storage.

Sample Data

address	removed	log_index	in_channel	in_identity	block_number	in_channelType	block_timestamp	transaction_hash
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	94	0x1a9ddef485674fc60a269cf97fabc6b8728a3497	0x312b516d515242756b445a4a6966446870317479364e7333624c54546655554c50687252755454473467785444623433	16628786	2	2023-02-14T18:30:23.000Z	0x9930c84c2aedec3d1455ab8a3717798df3dbd0eed0293b9f1e87f32e6cd3db72
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	103	0x59aad2c81b86df6e4a0dae51c5c5bd45ba451875	0x312b516d577257435346334458756a413866706557655247736e65486b4745743961423541385a474c56387853563371	16625722	2	2023-02-14T08:13:11.000Z	0x405b517dafbbc1b9aa4143e74281b52b9547f81c752ede28ad58cc1ab7175158
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	386	0x81960034a827649a24f243cf370e38a7aac1adac	0x312b516d51674c65313348724a55615877644e7a55755a327147475144366b794763565966636f343753624e52766355	18231082	2	2023-09-28T01:50:35.000Z	0x5ec6d652c94a56ea24a72c7e4ccd88c8e8f7f264fdc0f66baccb6dce15a31257

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNSCoreV1_5_AddChannel_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EPNSCoreV1_5_ChannelNotifcationSettingsAdded_event

Channel notification preference configuration events from EPNS (Ethereum Push Notification Service) Core V1.5 contract on Ethereum. Records when channels add customizable notification settings like price alerts, health factor ranges, and delivery frequency options for subscriber notifications.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in__channel`	`STRING`	Contract address of the Push Protocol notification channel that added these notification settings. Represents the publisher/sender configuring customizable alert options for their subscribers.
`in_totalNotifOptions`	`STRING`	Total number of configurable notification options available for the channel. Always represented as a string-encoded integer (e.g., “1”, “3”, “11”).
`in__notifSettings`	`STRING`	Encoded notification settings configuration that defines user-customizable alert parameters for the Push Protocol channel. The string uses a delimiter-based format (e.g., “3+1-1+1-0+2-1-50-20-100”) representing option counts and parameter ranges for notifications like price alerts or event triggers.
`in__notifDescription`	`STRING`	Human-readable description of the notification setting or category being configured for a Push Protocol channel. Text explains what the notification option controls, such as price alerts, event updates, or communication preferences.

Sample Data

address	removed	log_index	in__channel	block_number	block_timestamp	transaction_hash	in__notifSettings	in__notifDescription	in_totalNotifOptions
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	230	0x07075c33e1ecc58e2e0540296a0db48ab0e00707	18384489	2023-10-19T12:51:23.000Z	0x8828b1e689b8d23953fc6fdbc58632bed7aff9e0ff2e126759d8313c9ca01476	1+1-1	Received 5,000 USDC from Сircle.	1
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	152	0x72f569de6d77b1d4c3810767865fc706a1c39915	18367821	2023-10-17T04:50:23.000Z	0x59fb1556e4f4f640219492a96df408b48ed35ad62ab2da9048a0cfc8d35e7044	3+1-1+1-0+2-1-50-20-100	Dev Connect Schedule Updates+Marketing Updates+Ticket Price	3
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	555	0xb88460bb2696cab9d66013a05dff29a28330689d	18378346	2023-10-18T16:12:11.000Z	0x3820e184894a38770dce2419578b98d847068c996a70b647e61a525e4144c54a	4+1-1+1-1+1-0+1-0	Product and Feature Updates+Push DAO Alerts+Partnership Alerts+Push Hackathons & Events	4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNSCoreV1_5_ChannelNotifcationSettingsAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EPNSCoreV1_5_ChannelVerificationRevoked_event

Events recording verification revocations for Push Protocol (formerly EPNS) notification channels on Ethereum, tracking when channel verifications are removed by authorized revokers.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_channel`	`STRING`	Address of the notification channel in the EPNS protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_revoker`	`STRING`	Ethereum address of the entity that revoked verification status for the EPNS (Ethereum Push Notification Service) channel. This is the actor who initiated the verification revocation transaction.

Sample Data

address	removed	log_index	in_channel	in_revoker	block_number	block_timestamp	transaction_hash
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	154	0x983110309620d911731ac0932219af06091b6744	0xb88460bb2696cab9d66013a05dff29a28330689d	15716234	2022-10-10T07:32:47.000Z	0x82d74491197b62ff185fc09518efb0193e59eb9415b1b98d9c563c09d79e43e1
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	275	0x187a34c86aa6378333ce9033aa34718d2ceded2c	0xb88460bb2696cab9d66013a05dff29a28330689d	17483686	2023-06-15T07:03:59.000Z	0x1e7bdb6269676444977cf6639fdbadf88156f7481311b62e3c91bde91a552c85

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNSCoreV1_5_ChannelVerificationRevoked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EPNSCoreV1_5_ChannelVerified_event

Channel verification events from EPNS (Ethereum Push Notification Service) Core v1.5 protocol on Ethereum. Records when notification channels receive verification status from authorized verifier addresses, useful for tracking channel approval workflows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_channel`	`STRING`	Address of the notification channel in the EPNS protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_verifier`	`STRING`	Contract address of the entity that verified the Push Protocol notification channel. Hex-encoded, 0x-prefixed 40-character Ethereum address that authorized the channel’s verification status.

Sample Data

address	removed	log_index	in_channel	in_verifier	block_number	block_timestamp	transaction_hash
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	123	0xd32908f63713f514addbe3962a2de7112fdcd4a7	0xb88460bb2696cab9d66013a05dff29a28330689d	14037152	2022-01-19T16:56:58.000Z	0x4ed6b0486ba0e173ba07a87f670a88f0aae99b69333429f77e94978971fe6477
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	122	0xb4f88ad000a53638f203dca2c39828a58057d53c	0xb88460bb2696cab9d66013a05dff29a28330689d	14037152	2022-01-19T16:56:58.000Z	0x4ed6b0486ba0e173ba07a87f670a88f0aae99b69333429f77e94978971fe6477
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	120	0x9b43a385e08ee3e4b402d4312dabd11296d09e93	0xb88460bb2696cab9d66013a05dff29a28330689d	14037152	2022-01-19T16:56:58.000Z	0x4ed6b0486ba0e173ba07a87f670a88f0aae99b69333429f77e94978971fe6477

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNSCoreV1_5_ChannelVerified_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EPNSCoreV1_5_DeactivateChannel_event

Channel deactivation events from EPNS (Ethereum Push Notification Service) Core v1.5 protocol on Ethereum, recording when notification channels are shut down and their staked tokens refunded. Used for analyzing channel lifecycle and staking pool dynamics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_channel`	`STRING`	Address of the notification channel in the EPNS protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountRefunded`	`STRING`	Amount of tokens refunded to the channel owner upon deactivation, denominated in the smallest token unit (wei). Values typically range from 39-192 ETH (in wei), representing the staked deposit returned when closing a Push Protocol notification channel.

Sample Data

address	removed	log_index	in_channel	block_number	block_timestamp	transaction_hash	in_amountRefunded
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	79	0x187a34c86aa6378333ce9033aa34718d2ceded2c	17441261	2023-06-09T07:40:47.000Z	0x9afe00bb26c04249296d1f39467a23fbbe397532b585bbbb972e79b3deec7045	191965480000000000000
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	263	0x58754d9b3dbb4ddf5ac3502acb963743b15e6398	16099205	2022-12-02T19:26:47.000Z	0x43f53e5d3a2bb0ead6b5f4706dc01d047c64f757ffd4fd13a7d6a3eddef82156	40000000000000000000
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	406	0xf01603e1ce9916ba7446b57b8fa975ae9f1c1143	18063830	2023-09-04T14:52:11.000Z	0x7c2bb000035005cebc7d2fa9a2383cb7e583269da66d8f512fd4e59cd21b386f	39000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNSCoreV1_5_DeactivateChannel_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EPNSCoreV1_5_Paused_event

Protocol pause events from EPNS (Ethereum Push Notification Service) Core V1.5 contract on Ethereum. Records when the protocol is paused by authorized accounts, useful for monitoring protocol security actions and operational status changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	transaction_hash
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	144	0xb88460bb2696cab9d66013a05dff29a28330689d	16377283	2023-01-10T15:24:23.000Z	0x4ad88f928087b1a5ef4fea364cdad17520ecf8c01ab78cda8eaa61c253f7728d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNSCoreV1_5_Paused_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EPNSCoreV1_5_ReactivateChannel_event

Channel reactivation events from Push Protocol (formerly EPNS) on Ethereum, recording when previously deactivated notification channels are restored with their deposited stake amounts. Used for tracking channel lifecycle management and protocol participation patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_channel`	`STRING`	Address of the notification channel in the EPNS protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountDeposited`	`STRING`	Quantity of tokens deposited into the contract. Integer string representation of token amount in smallest divisible unit.

Sample Data

address	removed	log_index	in_channel	block_number	block_timestamp	transaction_hash	in_amountDeposited
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	198	0x46e6c2aadbb7c37a38a583fa2136444085dfd322	16442394	2023-01-19T17:38:23.000Z	0x688d71a3ca07ea26b73479041e69b64800bebec7f36550c4262d2526fa8d899e	50000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNSCoreV1_5_ReactivateChannel_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EPNSCoreV1_5_Unpaused_event

Protocol unpause events from EPNS (Ethereum Push Notification Service) Core V1.5 contract on Ethereum. Records when the protocol resumes operations after being paused, including the account that triggered the unpause action.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	transaction_hash
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	93	0xb88460bb2696cab9d66013a05dff29a28330689d	16377899	2023-01-10T17:27:47.000Z	0x6f4cd1bb808a1b3aa945acf8bdc1ab21a3b2415b79b137b4783c5ffd4a4d9fbf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNSCoreV1_5_Unpaused_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

EPNSCoreV1_5_UpdateChannel_event

Channel metadata update events from EPNS (Ethereum Push Notification Service) Core V1.5 contract on Ethereum. Tracks changes to notification channel configurations including updated IPFS identity hashes for analyzing channel activity and content modifications.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_channel`	`STRING`	Address of the notification channel in the EPNS protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_identity`	`STRING`	IPFS content identifier (CID) for the updated channel metadata, stored as hex-encoded bytes. Contains the hash reference to the channel’s information stored on IPFS.

Sample Data

address	removed	log_index	in_channel	in_identity	block_number	block_timestamp	transaction_hash
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	239	0x03eaaaa48ea78d1e66ea3458364d553ad981871e	0x312b516d4e6a315661615052456b6d6f37635135455a664e5342314d416d335a68454c70327435737535423334797442	17341131	2023-05-26T05:14:59.000Z	0x685ef306fd493e92eebf78335c3dc736a0030426ca2a3915b5bc1a90f35db6f0
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	258	0x2b8ffb4460550dbe8ec1cea9c1b61322db56b082	0x312b516d56666a646f70317433426b376a6d436f437658393962687a72507072727048474c31635044486f43395a6133	17341163	2023-05-26T05:21:23.000Z	0x1299606a8f22144070d31ce49cc55fef6ea42e3b03fddedd331a152b4474b966
0x66329fdd4042928bfcab60b179e1538d56eeeeee	false	232	0xd21e17e4c0a41f8ce95d2b6364946f5fb9783085	0x312b516d59565a696f5345693853383577626e75727879764257365955547274346a726b4c504b634d31544737577057	17797489	2023-07-29T08:24:47.000Z	0x29bf26934e40484c6ac88e5103e3a5b52ae213f29c6c1a4795d59a9bca73d3eb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.push_v1_ethereum.EPNSCoreV1_5_UpdateChannel_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

EPNS_Transfer_event

EPNSCoreV1_5_AddChannel_event

EPNSCoreV1_5_ChannelNotifcationSettingsAdded_event

EPNSCoreV1_5_ChannelVerificationRevoked_event

EPNSCoreV1_5_ChannelVerified_event

EPNSCoreV1_5_DeactivateChannel_event

EPNSCoreV1_5_Paused_event

EPNSCoreV1_5_ReactivateChannel_event

EPNSCoreV1_5_Unpaused_event

EPNSCoreV1_5_UpdateChannel_event

​Tables

​EPNS_Transfer_event

​EPNSCoreV1_5_AddChannel_event

​EPNSCoreV1_5_ChannelNotifcationSettingsAdded_event

​EPNSCoreV1_5_ChannelVerificationRevoked_event

​EPNSCoreV1_5_ChannelVerified_event

​EPNSCoreV1_5_DeactivateChannel_event

​EPNSCoreV1_5_Paused_event

​EPNSCoreV1_5_ReactivateChannel_event

​EPNSCoreV1_5_Unpaused_event

​EPNSCoreV1_5_UpdateChannel_event

Tables

EPNS_Transfer_event

EPNSCoreV1_5_AddChannel_event

EPNSCoreV1_5_ChannelNotifcationSettingsAdded_event

EPNSCoreV1_5_ChannelVerificationRevoked_event

EPNSCoreV1_5_ChannelVerified_event

EPNSCoreV1_5_DeactivateChannel_event

EPNSCoreV1_5_Paused_event

EPNSCoreV1_5_ReactivateChannel_event

EPNSCoreV1_5_Unpaused_event

EPNSCoreV1_5_UpdateChannel_event