boomer77psp claimers sold
Updated 2022-05-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with raw as (select block_timestamp, tx_hash, event_inputs:amount/1e18 as amount, event_inputs:recipient::string as claimer
from ethereum_core.fact_event_logs
where contract_address = '0x090e53c44e8a9b6b1bca800e881455b921aec420' and event_name = 'Claimed' and tx_status = 'SUCCESS'),
allsell as (select date_trunc('day',block_timestamp) as dt,
amount, origin_address as seller
from ethereum.udm_events
where contract_address = lower('0xcafe001067cdef266afb7eb5a286dcfd277f3de5') and origin_address in (select claimer from raw)
and to_address in (lower('0x4a73a7e29988F171910119d660c4dd548282bF2a') ,lower('0xB4bBb0d88631d843b344892c24E3123F25801705'))
),
last_sell as (select dt, sum(amount) as volume_sell, count(distinct seller) as seller_count, case
when date(dt) between '2021-11-15' and '2021-11-21' then '$PSP Claim Week'
when date(dt) < '2021-11-15' then 'before $PSP'
when date(dt) > '2021-11-21' then 'after $PSP'
else null end as airdrop
from allsell
group by 1)
select *
from last_sell
Run a query to Download Data