azerbaijanUntitled Query
Updated 2023-02-20Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
BLOCK_TIMESTAMP::date as date,
sum(raw_amount)/pow(10,18) as total_dropped,
count(distinct(to_address)) as n_recipients
FROM optimism.core.fact_token_transfers
where block_timestamp > '2023-02-08'
and from_address - lower('0x2501c477d0a35545a387aa4a3eee4292a9a8b3f0')
and contract_address = lower('0x4200000000000000000000000000000000000042')
group by 1
order by 1 asc
Run a query to Download Data