KaskoazulL1 Unique Users
Updated 2022-03-12
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
›
⌄
--Question 37: Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra.
--How does user adoption seem to be trending for Solana compared to these other major chains?
--Does it appear that market conditions are slowing down growth or activity on the networks?
WITH SOL AS (
SELECT block_timestamp::date as fecha, count(distinct tx_from_address) as SOL_wallets, 'SOLANA' as L1
FROM solana.transactions
WHERE fecha >= '2022-02-01' and fecha < '2022-03-12'
GROUP BY fecha
),
ETH AS (
SELECT block_timestamp::date as fecha, count(distinct from_address) as ETH_wallets, 'ETHEREUM' as L1
FROM ethereum.transactions
WHERE fecha >= '2022-02-01' and fecha < '2022-03-12'
GROUP BY fecha
),
TERRA AS (
SELECT block_timestamp::date as fecha, count(distinct tx_from) as TERRA_wallets, 'TERRA' as L1
FROM terra.transactions
WHERE fecha >= '2022-02-01' and fecha < '2022-03-12'
GROUP BY fecha
),
FIRSTJOINT AS (
SELECT S.fecha, S.SOL_wallets, E.ETH_wallets
FROM SOL S INNER JOIN ETH E ON S.fecha = E.fecha
)
SELECT F.fecha, F.SOL_wallets, F.ETH_wallets, T.TERRA_wallets
FROM FIRSTJOINT F INNER JOIN TERRA T ON F.fecha = T.fecha
Run a query to Download Data