adriaparcerisasblast 4
Updated 2024-05-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- forked from 2024-03-01 09:38 AM @ https://flipsidecrypto.xyz/edit/queries/fb36a57e-a15b-4f73-9a06-66ad04e0d3eb
select
distinct label_type,
--trunc(block_timestamp,'hour') as hour,
count(distinct tx_hash) as transactions,
count(distinct from_address) as active_users,
sum(tx_fee) as fees,
avg(tx_fee) as avg_tx_fee
from blast.core.fact_transactions x join blast.core.dim_labels on to_address=address
where status='SUCCESS'
group by 1
--origin_function_signature
--status
QueryRunArchived: QueryRun has been archived