OwentellNew Contract Usage on NEAR (10)
    Updated 2023-03-24
    -- forked from 4c98be64-ad36-46cd-a257-546d065dce04

    -- forked from fe71382f-171d-437d-ad18-1202840aecec

    -- forked from 8bb90044-ce3e-4bc9-abe6-a8edf7471441

    -- forked from 67bec7d3-8d91-4326-afe5-353d44554d7e

    -- forked from d3ac7b9c-e8ea-4601-bcb2-2785179f0ea6

    -- forked from 418ad948-9093-46cd-8a70-31aff1d06944

    -- forked from 8b91d70e-cdd7-4fb7-9d72-6e55aa6434c7

    -- forked from 731a936c-f50f-4af2-a2f1-35fe11e5c05b

    WITH new_contracts AS (
    SELECT tx_hash
    FROM near.core.fact_actions_events
    WHERE action_name = 'DeployContract'
    AND block_timestamp >= '2022-11-01'
    ),

    contract_info AS (
    SELECT block_timestamp, tx_hash, tx_receiver as new_contract,
    gas_used / POWER(10, 12) as gas_near
    FROM near.core.fact_transactions
    WHERE tx_hash IN (SELECT tx_hash FROM new_contracts)
    AND tx_receiver NOT IN
    (SELECT tx_receiver
    FROM near.core.fact_transactions
    WHERE block_timestamp <= '2022-11-01')
    AND tx_status = 'Success'
    ),

    transactions AS (
    Run a query to Download Data