TheLaughingManEVMs || contract_program_deployments || TLM
Updated 2024-11-26
999
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
›
⌄
---create sample space for chains/dates---
with chains as (
SELECT * from
( values
('ethereum'),
('arbitrum'),
('base'),
('optimism')
) as a (chain)
)
, dates as (
SELECT
date_day as date
from crosschain.core.dim_dates
WHERE 1=1
AND date_day BETWEEN CURRENT_DATE -1 -29 AND CURRENT_DATE -1
)
, sample_space as (
SELECT
date
, chain
from dates
LEFT JOIN chains on 1=1
)
-- Respective chain's data CTEs
, eth_stats as (
SELECT
'ethereum' as chain
, block_timestamp::date as date
, COUNT(*) as n_contracts
FROM ethereum.core.fact_traces
WHERE 1=1
QueryRunArchived: QueryRun has been archived