adriaparcerisasarb2
Updated 2023-03-30
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
33
34
35
36
›
⌄
with
news as (
SELECT
distinct to_address,
min(block_timestamp::date) as debut
from arbitrum.core.fact_token_transfers
where FROM_ADDRESS = lower('0x67a24CE4321aB3aF51c2D0a4801c3E111D88C9d9')
and contract_address = lower('0x912ce59144191c1204e64559fe8253a0e49e6548')
GROUP by 1
),
news2 as (
select distinct debut, count(distinct to_address) as news
from news group by 1
),
others as (
select
trunc(BLOCK_TIMESTAMP,'day') as date,
count(distinct x.TO_ADDRESS) as airdropers,
--count(distinct y.to_address) as news,
--sum(news) over (order by date) as total_airdropers,
sum(RAW_AMOUNT/ 1e18) as arb_amount,
sum(RAW_AMOUNT/ 1e18 / 1162166000) * 100 as pcg_claimed,
sum(pcg_claimed) over (order by date) as total_pcg_claimed
from arbitrum.core.fact_token_transfers x
--join news y on trunc(x.block_timestamp,'day')=trunc(y.debut,'day')
where FROM_ADDRESS = lower('0x67a24CE4321aB3aF51c2D0a4801c3E111D88C9d9')
and contract_address = lower('0x912ce59144191c1204e64559fe8253a0e49e6548')
GROUP by 1 order by 1 asc
)
SELECT
date,
airdropers,
sum(news) over (order by date) as total_airdropers,
arb_amount,pcg_claimed,total_pcg_claimed
from others x join news2 y on x.date=y.debut
order by 1 asc
Run a query to Download Data