puriffaucet usage
Updated 2024-11-26
9
1
2
3
4
5
6
›
⌄
select count(distinct tx_hash) as txs, count(distinct address) as users, sum(amount) as amount from (
select block_timestamp, tx_hash,
concat('0x',substr(TOPICS[1], 27,64)) as address, (ethereum.public.udf_hex_to_int(data)::int)/1e18 as amount from berachain.testnet.fact_event_logs
where topics[0]='0x7cad7fbe1215c486c724bf41124e0ed689d280724381379da844556025c463c1'
and contract_address=lower('0xF1E4A550772faBfc35B28b51eB8d0b6FCd1c4878')
)
QueryRunArchived: QueryRun has been archived