freemartianUntitled Query
Updated 2022-06-13
9
1
2
3
4
5
6
7
8
9
›
⌄
select event_inputs:to as vault, sum(event_inputs:value)/pow(10,18) as nft_value
from flipside_prod_db.ethereum_core.fact_event_logs
where contract_address = lower('0x3E135c3E981fAe3383A5aE0d323860a34CfAB893')
and origin_to_address = lower('0x3E135c3E981fAe3383A5aE0d323860a34CfAB893')
and block_timestamp > CURRENT_DATE - 60
and vault is not null
and event_inputs:value is not null
group by vault
order by nft_value DESC
Run a query to Download Data