rain_syndicaSol Inscriptions - Creators
    Updated 2023-11-28
    with

    all_txs as (

    select distinct

    block_timestamp
    , signers[0] as creator

    from solana.core.fact_events
    inner join solana.core.fact_transactions
    using(block_timestamp, tx_id, succeeded)
    where succeeded
    -- and array_contains('inscokhJarcjaEs59QbQ7hYjrKz25LEPRfCbP8EmdUp' ::variant, instruction :accounts)
    and program_id = 'Leg1xVbrpq5gY6mprak3Ud4q4mBwcJi5C9ZruYjWv7n'
    and array_contains('Program log: Instruction: CreateInscription' ::variant, log_messages)
    and block_timestamp > '2023-11-13'
    and block_timestamp < '2023-12-01'
    ),

    first_txs as (

    select

    creator
    , min(block_timestamp) as first_timestamp

    from all_txs
    group by 1
    ),

    aggregated as (

    select
    date_trunc('hour', block_timestamp) as date
    Run a query to Download Data