nitsCantina Minting Times
Updated 2022-06-17
9
1
2
3
4
5
6
7
›
⌄
SELECT trunc(block_timestamp, 'hour') as day, count(DISTINCT origin_address) as oa, sum(oa) over (order by day) as cumulative_addresses
from
(SELECT * from flipside_prod_db.ethereum.udm_events
-- where tx_id = '0xd74bcef914fbf47b4f1c3831a462e537d4542b7968ad57d656f7fb6b3d98f4ac'
where contract_address = '0x903e2f5d42ee23156d548dd46bb84b7873789e44' and origin_function_signature = '0x46534510')
GROUP by 1
limit 10000
Run a query to Download Data