mamad-5XN3k3Most Popular Contracts
Updated 2024-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with contracts as (
select
distinct contract_address,
min(block_timestamp) as min_date
from blast.core.fact_event_logs
where block_Timestamp >= '2024-02-29 09:00:00.000'
group by 1
)
select
contract_address,
count(distinct TX_HASH) as txs,
sum(value) as volume,
count(distinct from_address) as users
from blast.core.fact_transactions t
join contracts c on c.contract_address = t.to_address
group by 1
order by 2 desc
QueryRunArchived: QueryRun has been archived