marquBONK - [burn] dist of burn
    Updated 2024-05-21
    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