mo115all evms -Charlie's query
Updated 2023-12-06
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
›
⌄
/* use livequery to get a cache of data before 2023-11-30 */
with eth_dau AS (
select
'ethereum' as chain,
date_trunc('month', block_timestamp) as month,
sum(case when nonce = 1 then 1 else 0 end) as n_first_tx,
count(distinct from_address) as n_unique_from
from ethereum.core.fact_transactions
where
block_timestamp >= '2023-12-01'
and block_timestamp < current_date
group by month
),
arb_dau AS (
select
'arbitrum' as chain,
date_trunc('month', block_timestamp) as month,
sum(case when nonce = 1 then 1 else 0 end) as n_first_tx,
count(distinct from_address) as n_unique_from
from arbitrum.core.fact_transactions
where
block_timestamp >= '2023-12-01'
and block_timestamp < current_date
-- ignore system transactions
and from_address != lower('0x00000000000000000000000000000000000A4B05')
group by month
),
avax_dau AS (
select
'avalanche' as chain,
date_trunc('month', block_timestamp) as month,
sum(case when nonce = 1 then 1 else 0 end) as n_first_tx,
Run a query to Download Data