freemartianParallel mints
Updated 2024-01-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- select * from base.core.fact_transactions
-- WHERE tx_hash = '0xdbcc6772c0265ed21c9ca9b9f37af108ff5af9bab5141c67a68a98c17fb3ef91'
SELECT
date_trunc('hour', block_timestamp) as time,
count(distinct from_address) as Unique_minters,
sum(eth_value/0.05) as Total_mints
from base.core.fact_traces
where to_address = '0x1f9248b193806d7bb7f04945bc8f35dfeeffca34'
and eth_value > 0
and identifier = 'CALL_ORIGIN'
and block_timestamp > '2023-08-11 15:00:00.000'
group by time
QueryRunArchived: QueryRun has been archived