Lordkingpsp
Updated 2023-07-27Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with
a as (
select
ORIGIN_FROM_ADDRESS as claimer ,
RAW_AMOUNT/pow(10,DECIMALS) as volume ,
AMOUNT_USD as USD ,
BLOCK_TIMESTAMP ,
TX_HASH
from ethereum.core.ez_token_transfers
where
ORIGIN_TO_ADDRESS ='0x090e53c44e8a9b6b1bca800e881455b921aec420' and
CONTRACT_ADDRESS = '0xcafe001067cdef266afb7eb5a286dcfd277f3de5' and
ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'
)
select
sum(volume) as PSP ,'Claimed PSP' as title from a group by 2
union
select (149840000 - sum(volume)) as PSP ,'Remaining PSP' as title from a group by 2
union
select 149840000 as PSP ,'PSP Airdrop Allocation' as title from a
Run a query to Download Data