flipside

    Bonk transfer
    MrftiBonk transfer
    Updated 2024-01-28
    (
    SELECT
    'old' dash,
    date_trunc('day',block_timestamp) as "Date",
    count(distinct tx_id) as "Transfers",
    sum(amount) as "Bonk volume"
    FROM solana.core.fact_transfers
    WHERE mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    and "Date" < '2023-03-21 00:00:00.000 '
    GROUP by 2
    )
    union all
    (
    SELECT
    'New' dash,
    date_trunc('day',block_timestamp) as "Date",
    count(distinct tx_id) as "Transfers",
    sum(amount) as "Bonk volume"
    FROM solana.core.fact_transfers
    WHERE mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    and "Date" > '2023-03-21 00:00:00.000'
    and "Date" != '2023-07-01 00:00:00.000'
    GROUP by 2
    )


    Last run: about 1 year ago
    DASH
    Date
    Transfers
    Bonk volume
    1
    		New2023-03-31 00:00:00.0001213333391230198999.32
    2
    		New2023-05-20 00:00:00.000944372107514746850.4
    3
    		New2023-06-03 00:00:00.0001514505822166635220.37
    4
    		New2023-07-10 00:00:00.00016938112468490382229.1
    5
    		New2024-01-06 00:00:00.00033632664357965935269.9
    6
    		New2023-10-15 00:00:00.00019724517224004125110.6
    7
    		New2023-11-22 00:00:00.00044534351610526280643.5
    8
    		New2023-12-10 00:00:00.00025017715876608697583.4
    9
    		old2023-01-22 00:00:00.000801936291149417885.44
    10
    		New2023-04-22 00:00:00.0001082784194873814710.37
    11
    		New2023-06-21 00:00:00.0001078834800677660382.89
    12
    		New2023-09-22 00:00:00.00011734942065294685939.4
    13
    		New2023-11-26 00:00:00.0001616068343556898941.16
    14
    		New2023-03-25 00:00:00.000932383695971438872.46
    15
    		New2023-04-18 00:00:00.0001702014484874466401.32
    16
    		New2023-06-28 00:00:00.000688905821629542218.72
    17
    		New2023-09-13 00:00:00.00017384434178871681371.9
    18
    		New2023-10-20 00:00:00.00027544142459985402525.4
    19
    		New2023-12-29 00:00:00.000572752347179579808310
    20
    		old2023-02-05 00:00:00.00024876411446386174003.2
    ...
    404
    23KB
    640s