kaibladeTop 10 Oldest User Wallets
    Updated 2023-03-15
    -- forked from 40719078-2821-41fe-a8f8-6ba37653d0c5

    with
    social_inits as (
    select * from near.core.fact_actions_events_addkey
    where receiver_id = 'social.near'
    ),
    add_signer as (
    select
    k.tx_hash,
    k.block_id,
    k.block_timestamp,
    t.tx_signer,
    k.allowance,
    t.tx_signer = t.tx_receiver
    from social_inits k
    left join near.core.fact_transactions t using (tx_hash)
    ),
    de_dupe_resigners as (
    select
    block_timestamp,
    tx_signer
    from add_signer
    WHERE block_timestamp::date BETWEEN '{{Start_Date}}' AND '{{End_Date}}'
    qualify ROW_NUMBER() over (
    PARTITION BY tx_signer
    ORDER BY
    block_timestamp
    ) = 1
    ),
    first_tx AS
    (SELECT block_timestamp, tx_signer
    FROM near.core.fact_transactions
    WHERE tx_signer IN (SELECT DISTINCT(tx_signer) FROM de_dupe_resigners)
    QUALIFY ROW_NUMBER() OVER (PARTITION BY tx_signer ORDER BY block_timestamp) = 1
    Run a query to Download Data