Yousefi_1994Bonk Daily Transfer
Updated 2023-02-08
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
bonk_transfer as (
select
transfers.*
from
solana.core.fact_transfers transfers
where
mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
and block_timestamp::date >= '2022-12-24'
),
transfer_bonk_from_user as (
select
block_timestamp,
tx_id,
amount,
tx_from as address
from
bonk_transfer
where
tx_from not in (
'9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw',
'6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p',
'BqnpCdDLPV2pFdAaLnVidmn3G93RP2p5oRdGEY2sJGez',
'5P6n5omLbLbP4kaPGL8etqQAHEx2UCkaUyvjLDnwV4EY',
'2PFvRYt5h88ePdQXBrH3dyFmQqJHTNZYLztE847dHWYz',
'DBR2ZUvjZTcgy6R9US64t96pBEZMyr9DPW6G2scrctQK',
'4CUMsJG7neKqZuuLeoBoMuqufaNBc2wdwQiXnoH4aJcD',
'2yBBKgCwGdVpo192D8WZeAtqyhyP8DkCMnmTLeVYfKtA'
)
and tx_to not in (
'9AhKqLR67hwapvG8SA2JFXaCshXc9nALJjpKaHZrsbkw',
'6JZoszTBzkGsskbheswiS6z2LRGckyFY4SpEGiLZqA9p',
'BqnpCdDLPV2pFdAaLnVidmn3G93RP2p5oRdGEY2sJGez',
'5P6n5omLbLbP4kaPGL8etqQAHEx2UCkaUyvjLDnwV4EY',
'2PFvRYt5h88ePdQXBrH3dyFmQqJHTNZYLztE847dHWYz',
'DBR2ZUvjZTcgy6R9US64t96pBEZMyr9DPW6G2scrctQK',
Run a query to Download Data