OwentellNew Contract Usage on NEAR (10)
Updated 2023-03-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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