nitsEth to Sol bridge Volume
Updated 2022-06-17
9
1
2
3
4
›
⌄
SELECT date(block_timestamp) as day,symbol, sum(amount_usd) as total_amt, sum(total_amt) over (partition by symbol order by day) as cumulative_amt, avg(total_amt) over (partition by symbol order by day) as cumulative_amt_avg
from ethereum.udm_events
where from_address ilike '0xf92cd566ea4864356c5491c177a430c222d7e678' and amount_usd is not NULL and day >= CURRENT_DATE -365
GROUP by 1 , 2
Run a query to Download Data