LTirrell2023-03-09 05:21 PM
    Updated 2023-03-09
    WITH
    solana_wallets AS (
    SELECT
    signers[0] AS address,
    MIN(DATE(block_timestamp)) AS creation_date
    FROM
    solana.core.fact_transactions
    GROUP BY
    address
    ),
    solana_fee_payers as (
    SELECT
    creation_date,
    count(address) as address_count,
    'manual' as query_type
    FROM
    solana_wallets
    WHERE
    creation_date = '2023-03-07'
    group by
    creation_date,
    query_type
    ),
    signers_table as (
    select
    first_tx_date as creation_date,
    count(signer) as address_count,
    'ez_signers' as query_type
    from
    solana.core.ez_signers
    WHERE
    creation_date = '2023-03-07'
    group by
    creation_date,
    query_type
    )
    Run a query to Download Data