freemartianPika airdrop - treasury earnings
Updated 2023-09-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
-- forked from Pika airdrop - Total Redeem @ https://flipsidecrypto.xyz/edit/queries/945b016a-9efa-4e80-92e1-8ffbf8083766
-- select * from optimism.core.ez_token_transfers
-- where tx_hash = '0xb4711b7b8cc2d1797dc5193572d9d4a9d52cf22553404af2e945f4c15393aacf'
select
sum(amount) as Total_PIKA_Redeemed,
count(distinct to_address) as total_Redeemers
from optimism.core.ez_token_transfers
where from_address = '0x21a4a5c00ab2fd749ebec8282456d93351459f2a'
and contract_address = '0x9a601c5bb360811d96a23689066af316a30c3027'
and origin_function_signature = '0x379607f5'
and to_address = '0x4a1a4458e808842fe68099f73529fa20ac9b9eba'
Run a query to Download Data