satishkumarACTIVE-ADDRESSES
Updated 2024-05-30
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
›
⌄
SELECT block_timestamp::date as date, 'ethereum' as blockchain, count(DISTINCT from_address) as active_addresses
FROM ethereum.core.fact_transactions WHERE block_timestamp::date BETWEEN DATEADD(DD, -3, GETDATE())
and DATEADD(DD, -2, GETDATE()) GROUP BY 1
UNION
SELECT block_timestamp::date as date, 'arbitrum' as blockchain, count(DISTINCT from_address) as active_addresses
FROM arbitrum.core.fact_transactions WHERE block_timestamp::date BETWEEN DATEADD(DD, -3, GETDATE())
and DATEADD(DD, -2, GETDATE()) GROUP BY 1
UNION
SELECT block_timestamp::date as date, 'avalanche' as blockchain, count(DISTINCT from_address) as active_addresses
FROM avalanche.core.fact_transactions WHERE block_timestamp::date BETWEEN DATEADD(DD, -3, GETDATE())
and DATEADD(DD, -2, GETDATE()) GROUP BY 1
UNION
SELECT block_timestamp::date as date, 'bsc' as blockchain, count(DISTINCT from_address) as active_addresses
FROM bsc.core.fact_transactions WHERE block_timestamp::date BETWEEN DATEADD(DD, -3, GETDATE())
and DATEADD(DD, -2, GETDATE()) GROUP BY 1
UNION
SELECT block_timestamp::date as date, 'cosmoshub' as blockchain, count(DISTINCT tx_from) as active_addresses
FROM cosmos.core.fact_transactions WHERE block_timestamp::date BETWEEN DATEADD(DD, -3, GETDATE())
and DATEADD(DD, -2, GETDATE()) GROUP BY 1
UNION
SELECT block_timestamp::date as date, 'optimism' as blockchain, count(DISTINCT from_address) as active_addresses
FROM optimism.core.fact_transactions WHERE block_timestamp::date BETWEEN DATEADD(DD, -3, GETDATE())
and DATEADD(DD, -2, GETDATE()) GROUP BY 1
UNION
SELECT block_timestamp::date as date, 'osmosis' as blockchain, count(DISTINCT tx_from) as active_addresses
FROM osmosis.core.fact_transactions WHERE block_timestamp::date BETWEEN DATEADD(DD, -3, GETDATE())
and DATEADD(DD, -2, GETDATE()) GROUP BY 1
UNION
SELECT block_timestamp::date as date, 'polygon' as blockchain, count(DISTINCT from_address) as active_addresses
FROM polygon.core.fact_transactions WHERE block_timestamp::date BETWEEN DATEADD(DD, -3, GETDATE())
and DATEADD(DD, -2, GETDATE()) GROUP BY 1
UNION
SELECT block_timestamp::date as date, 'near' as blockchain, count(DISTINCT tx_signer) as active_addresses
FROM near.core.fact_transactions WHERE block_timestamp::date BETWEEN DATEADD(DD, -3, GETDATE())
and DATEADD(DD, -2, GETDATE()) GROUP BY 1
UNION
QueryRunArchived: QueryRun has been archived