adriaparcerisasavalanche protocols vs l2
Updated 2024-05-08
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
›
⌄
with
avax as (
select
trunc(block_timestamp,'month') as date,
project_name,
count(distinct tx_hash) as txs,
count(distinct origin_from_address) as users,
rank() over (order by txs desc) as ranks
from avalanche.core.fact_event_logs x
join avalanche.core.dim_labels y on x.contract_address=y.address
where contract_address = lower('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e')
and block_timestamp >= '2022-01-01'
group by 1,2
),
opt as (
SELECT
trunc(block_timestamp,'month') as date,
project_name,
count(distinct tx_hash) as txs,
count(distinct origin_from_address) as users,
rank() over (order by txs desc) as ranks
from optimism.core.fact_event_logs x
join optimism.core.dim_labels y on x.contract_address=y.address
where contract_address = lower('0x7F5c764cBc14f9669B88837ca1490cCa17c31607')
and block_timestamp >= '2022-01-01'
group by 1,2
),
arb as (
SELECT
trunc(block_timestamp,'month') as date,
project_name,
count(distinct tx_hash) as txs,
count(distinct origin_from_address) as users,
rank() over (order by txs desc) as ranks
from arbitrum.core.fact_event_logs x
join arbitrum.core.dim_labels y on x.contract_address=y.address
QueryRunArchived: QueryRun has been archived