datavortexDaily Active
Updated 2024-09-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH daily_activity AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(DISTINCT from_address) AS unique_senders,
COUNT(DISTINCT to_address) AS unique_receivers
FROM
optimism.core.ez_token_transfers
WHERE
contract_address = LOWER('0x296F55F8Fb28E498B858d0BcDA06D955B2Cb3f97')
GROUP BY
DATE_TRUNC('day', block_timestamp)
)
SELECT
day,
unique_senders,
unique_receivers
FROM
daily_activity
ORDER BY
day;
QueryRunArchived: QueryRun has been archived