kaibladeDaily # of Widget Creations
    Updated 2023-03-15
    -- forked from aec7d753-f0d2-4e1e-8359-cfa3dcb5e48d

    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
    ),

    index_string AS
    (SELECT *, TO_CHAR(node_data) AS string_data,
    node_data:graph AS graph_content,
    OBJECT_KEYS(node_data) AS obj_keys
    FROM near.social.fact_decoded_actions
    Run a query to Download Data