freemartianPika airdrop - Total Stakers
Updated 2023-09-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- forked from All Stakers @ https://flipsidecrypto.xyz/edit/queries/45022f49-7989-48bf-a188-0fa40f0b498a
-- select * from optimism.core.ez_token_transfers
-- where tx_hash = '0x7695f28739eb836ef47c6f95a839112540217c83d2ecebcaa62a250708620923'
select
sum(amount) as Total_esPIKA_Staked,
count(distinct from_address) as total_Stakers
from optimism.core.ez_token_transfers
where to_address = '0x21a4a5c00ab2fd749ebec8282456d93351459f2a'
and contract_address = '0x1508fbb7928aedc86bee68c91bc4afcf493b0e78'
and origin_function_signature = '0xb6b55f25'
Run a query to Download Data