Elprognerd13 Contracts
Updated 2023-03-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
block_timestamp::date as date,
'Arbitrum' as chain,
COUNT(*) as "Number of contracts",
sum( "Number of contracts") over (order by date) as "Cumulative number of contracts"
FROM arbitrum.core.fact_transactions
WHERE TO_ADDRESS IS NULL AND INPUT_DATA != '' AND block_timestamp >= '2023-01-01'
GROUP BY 1,2
UNION all
SELECT
block_timestamp::date as date,
'Optimism' as chain,
COUNT(*) as "Number of contracts",
sum( "Number of contracts") over (order by date) as "Cumulative number of contracts"
FROM optimism.core.fact_transactions
WHERE TO_ADDRESS IS NULL AND INPUT_DATA != '' AND block_timestamp >= '2023-01-01'
GROUP BY 1,2
ORDER BY 1
Run a query to Download Data