DataBeingUntitled Query
Updated 2022-05-16
9
1
2
3
4
5
6
7
8
›
⌄
select symbol, sum(amount_usd) as collateral_usd, date_trunc('day',block_timestamp) as day
from ethereum.udm_events
Where event_name = 'transfer'
and to_label = 'maker'
and origin_function_signature = '0x1cff79cd' and day >= CURRENT_DATE - 365
group by 1,3
-- 0xf3ffa2eb , 0x7c025200, 0x6a761202 -- 0x1cff79cd
Run a query to Download Data