andurilSocial Data - Programs, Tokens and Misc
    Updated 2024-02-06
    with
    compression_txs as (
    select distinct
    tx_id
    from
    solana.core.fact_events
    where
    date(block_timestamp) >= '2023-08-10'
    and program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
    and signers[0] = '4WCBsTL4fHpg8qCt1wxoqRzgj2CZepdpmS5NaaoxPUJh'
    ),
    dialect_agg as (
    select
    date_trunc('month',block_timestamp) as month,
    'Dialect' as label,
    count(distinct tx_id) as txs, --mints
    count(distinct instructions[0]:accounts[1]) as wallets--collectors
    from
    solana.core.fact_transactions
    inner join compression_txs using (tx_id)
    where
    month between '2023-08-10' and date_trunc('month', current_date())
    and (
    log_messages[1] = 'Program log: Instruction: MintToCollectionV1'
    OR log_messages[1] = 'Program log: Instruction: MintV1'
    )
    and succeeded
    group by
    1
    ),


    social_transfers AS (
    SELECT
    block_timestamp,
    tx_id,
    Last run: over 1 year ago
    MONTH
    LABEL
    TXS
    WALLETS
    1
    2024-02-01 00:00:00.000UnderDog170082
    2
    2024-02-01 00:00:00.000Spling Labs1450834
    3
    2024-02-01 00:00:00.000Access102002455
    4
    2024-02-01 00:00:00.000Dialect3945784
    5
    2024-02-01 00:00:00.000Dispatch38881
    6
    2024-02-01 00:00:00.000Squads3875628
    7
    2024-02-01 00:00:00.000Exchange Art28531067
    8
    2024-02-01 00:00:00.000Taki21781882
    9
    2024-02-01 00:00:00.000Bonfida13601037
    10
    2024-02-01 00:00:00.000Audius1316161
    11
    2024-02-01 00:00:00.000ANS Domain910318
    12
    2024-02-01 00:00:00.000Nina Protocol3079
    13
    2024-02-01 00:00:00.000Raindrops1763
    14
    2024-02-01 00:00:00.000Backpack6242
    15
    2024-02-01 00:00:00.000BazeOne277
    16
    2024-02-01 00:00:00.000Only12316
    17
    2024-02-01 00:00:00.000CodeCanvas118
    18
    2024-02-01 00:00:00.000Cupcake74
    19
    2024-02-01 00:00:00.000Only111
    20
    2024-01-01 00:00:00.000UnderDog1969682
    ...
    146
    7KB
    557s