mmdrezaUntitled Query
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with smartcontracts as (
SELECT
max(near.core.fact_actions_events.BLOCK_TIMESTAMP) as tiime,
TX_RECEIVER
FROM( near.core.fact_actions_events INNER JOIN near.core.fact_transactions t
on t.TX_HASH = near.core.fact_actions_events.TX_HASH and t.BLOCK_TIMESTAMP=near.core.fact_actions_events.BLOCK_TIMESTAMP)
WHERE action_name = 'DeployContract'
GROUP BY TX_RECEIVER)
SELECT
DISTINCT TX_RECEIVER as tx,
tiime
FROM smartcontracts
Run a query to Download Data