HadisehMerry $BONK-ing Christmas 3
Updated 2023-01-04
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 t1 as (
select distinct tx_to as address, * from
solana.core.fact_transfers
where block_timestamp >= '2022-12-25'
and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
and tx_from in (
'6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p', '9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw' )
),
t2 as (
select
date(block_timestamp) as date,
tx_id,
tx.tx_from as address,
sum(tx.amount) * -1 as n_tokens
from solana.core.fact_transfers tx
where tx.block_timestamp >= '2022-12-25'
and tx.mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
and address not in (
'DBR2ZUvjZTcgy6R9US64t96pBEZMyr9DPW6G2scrctQK', -- 'bonk dao wallet'
'4CUMsJG7neKqZuuLeoBoMuqufaNBc2wdwQiXnoH4aJcD', -- 'bonk team wallet'
'2yBBKgCwGdVpo192D8WZeAtqyhyP8DkCMnmTLeVYfKtA', -- 'bonk marketing wallet'
'9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw', -- 'bonk airdrop address'
'6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p', -- 'bonk new airdrop address'
'BqnpCdDLPV2pFdAaLnVidmn3G93RP2p5oRdGEY2sJGez', -- 'orca bonk-sol pool'
'5P6n5omLbLbP4kaPGL8etqQAHEx2UCkaUyvjLDnwV4EY', -- 'orca bonk-usdc pool'
'2PFvRYt5h88ePdQXBrH3dyFmQqJHTNZYLztE847dHWYz' -- 'dex bonk-usdc pool'
)
group by date,tx_id,address
),
t3 as (
select
date(block_timestamp) as date,
tx_id,
tx.tx_to as address,
sum(tx.amount) as n_tokens
from solana.core.fact_transfers tx
Run a query to Download Data