freemartianPika Airdrop - All Stakers
Updated 2023-08-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- select * from optimism.core.ez_token_transfers
-- where tx_hash = '0x7695f28739eb836ef47c6f95a839112540217c83d2ecebcaa62a250708620923'
select
from_address,
sum(amount) as esPIKA_Staked
from optimism.core.ez_token_transfers
where to_address = '0x21a4a5c00ab2fd749ebec8282456d93351459f2a'
and contract_address = '0x1508fbb7928aedc86bee68c91bc4afcf493b0e78'
and origin_function_signature = '0xb6b55f25'
group by from_address
order by esPIKA_Staked desc
Run a query to Download Data