developer_viola2023-06-07 04:04 PM
Updated 2023-11-02
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 eth as (
select date_trunc('day', block_timestamp) as block_date, count(DISTINCT from_address) as Etheruem
from ethereum.core.fact_transactions
where block_date > '2021-12-31'
group by block_date),
bsc as (
select date_trunc('day', block_timestamp) as block_date, count(DISTINCT from_address) as Bsc
from bsc.core.fact_transactions
where block_date > '2021-12-31'
group by block_date
),
poly as (
select date_trunc('day', block_timestamp) as block_date, count(DISTINCT from_address) as Polygon
from polygon.core.fact_transactions
where block_date > '2021-12-31'
group by block_date
),
avax as (
select date_trunc('day', block_timestamp) as block_date, count(DISTINCT from_address) as Avalanche
from avalanche.core.fact_transactions
where block_date > '2021-12-31'
group by block_date
),
base as (
select date_trunc('day', block_timestamp) as block_date, count(DISTINCT from_address) as Base
from base.core.fact_transactions
where block_date > '2021-12-31'
group by block_date
)
select eth.*, bsc.Bsc, poly.Polygon, avax.Avalanche, base.Base from eth
left join bsc
Run a query to Download Data