shadilHop bridge volume
Updated 2022-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with first_query as
(select sum(event_inputs:value)/pow(10,18) as total_volume,
count(distinct event_inputs:from) as total_wallets,
date(block_timestamp) as date_time
from ethereum_core.fact_event_logs
where date(block_timestamp) >= '2022-01-01'
and event_name = 'Transfer'
and lower(contract_address) = lower('0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0')
and lower(event_inputs:to::String) = lower('0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2')
group by date_time)
select total_volume,
total_wallets,
date_time
from first_query
Run a query to Download Data