marquBONK - [burn] dist of burn
Updated 2024-05-21
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
burn_events as (
select
block_timestamp
, tx_id
, fact_transactions.signers[0] as user_address
, burn_amount as amount_raw
from solana.defi.fact_token_burn_actions
inner join solana.core.fact_transactions
using(tx_id, block_timestamp, succeeded)
where succeeded
and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
and block_timestamp > '2022-12-25'
),
agg_users as (
select
user_address,
sum(amount_raw) / pow(10,5) as bonk
from burn_events
group by 1
),
binned as (
select
case
when bonk < pow(10,2) then 'a. < 100'
QueryRunArchived: QueryRun has been archived