near new contracts 6 test

rackhaelnear new contracts 6 test

Updated 2023-03-22

-- SELECT COUNT(tx_hash) as total_contracts

-- FROM near.core.fact_actions_events

-- WHERE action_name = 'deploycontract'

-- AND date_trunc('day', block_timestamp:: date >= '2022-10-01'

SELECT COUNT(distinct tx_hash) as total_contracts

FROM near.core.fact_actions_events

WHERE action_name = 'DeployContract'

AND date_trunc('day', block_timestamp::date) BETWEEN '2022-10-01' AND '2023-02-28';

-- WITH

-- new_contracts AS (

-- SELECT tx_receiver,

-- date_trunc('day', min(block_timestamp)) AS initial_deployment_day,

-- count(DISTINCT tx_hash) AS deployed_contracts

-- FROM near.core.fact_transactions

-- WHERE tx_hash IN (SELECT tx_hash FROM near.core.fact_actions_events WHERE action_name = 'DeployContract')

-- AND block_timestamp >= '2022-10-01'

-- GROUP BY 1, 2

-- ),

-- daily_active_wallets AS (

-- SELECT

-- date_trunc('day', block_timestamp) AS day,

-- tx_receiver,

-- count(tx_signer) as users

-- FROM near.core.fact_transactions a

-- --JOIN new_contracts b ON a.tx_receiver = b.tx_receiver AND date_trunc('day', a.block_timestamp) >= b.initial_deployment_day

-- ),

-- repeat_users AS (

-- SELECT

-- date_trunc('month', day) AS month,

-- tx_receiver,

Run a query to Download Data

flipside