marquShitcoinery - [sol] spl tokens created
    Updated 2024-03-11
    with

    active_tokens as (

    select distinct
    mint,
    max(mint_amount) over (partition by amounts.mint) as mint_amount,
    max(decimal) over (partition by amounts.mint) as decimal

    from solana.defi.fact_token_mint_actions amounts
    where succeeded
    and block_timestamp > current_date() - interval '{{days}} days'
    qualify max(mint_amount) over (partition by amounts.mint) > 100000
    ),

    creation_dates as (

    select distinct
    block_timestamp,
    tx_id,
    signers[0] as creator_address,
    mint,
    fee
    from solana.core.fact_events events
    inner join solana.core.fact_transactions txs
    using(tx_id, block_timestamp, succeeded)
    inner join active_tokens
    on events.instruction :parsed :info :newAccount = active_tokens.mint
    where succeeded
    and program_id = '11111111111111111111111111111111'
    and instruction :parsed :type = 'createAccount'
    and block_timestamp ::date > current_date() - interval '{{days}} days'
    ),
    Last run: 3 months ago
    DATE
    CREATED
    Cumul. Tokens
    SOL
    Cumul. Fee
    1
    2024-11-30 00:00:00.0003879851640.62469765821.33304746
    2
    2024-11-27 00:00:00.0003561734201.12475052119.130445397
    3
    2024-11-22 00:00:00.0004320545000.99647110613.36110828
    4
    2024-11-09 00:00:00.0002251129940.4316074952.433493739
    5
    2024-12-04 00:00:00.000892981360.18192244625.285153878
    6
    2024-11-14 00:00:00.0002530259730.732510025.638173255
    7
    2024-11-11 00:00:00.0002850185320.6069351893.550704615
    8
    2024-11-24 00:00:00.0003501617720.76030617514.942122752
    9
    2024-11-23 00:00:00.0003771582710.82070829714.181816577
    10
    2024-11-17 00:00:00.0003004349080.7366372167.818195226
    11
    2024-11-16 00:00:00.0003007319040.6803862177.08155801
    12
    2024-11-25 00:00:00.0004153659251.65150381216.593626564
    13
    2024-11-20 00:00:00.0003844458650.98316253211.058689652
    14
    2024-12-03 00:00:00.0004186972441.25341943325.103231432
    15
    2024-12-02 00:00:00.0003862930581.57041513623.849811999
    16
    2024-11-19 00:00:00.0003903420211.01987912110.07552712
    17
    2024-11-29 00:00:00.0004027812850.76996032920.708349802
    18
    2024-11-12 00:00:00.0002659211910.5229560074.073660622
    19
    2024-11-21 00:00:00.0004315501801.30594752212.364637174
    20
    2024-12-01 00:00:00.0004032891960.94634940322.279396863
    30
    2KB
    296s