freemartianUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with top100 as (
select user_address, balance
from flipside_prod_db.ethereum.erc20_balances
where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and balance_date = CURRENT_DATE -1
order by balance desc
limit 100)
select distinct tx_from_address as staker
from ethereum.events_emitted e
inner join top100 t on t.user_address = e.tx_from_address
where contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
and block_timestamp between '2020-01-01' and '2022-06-15'
and event_name = 'Submitted'
Run a query to Download Data