headitmanagerTotal unique wallets since February 1st
Updated 2022-04-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with algorand_table as (select count(distinct sender) as wallets ,'ALGORAND : Total unique wallets since February 1st' from algorand.transactions where block_timestamp::date >= '2022-02-01')
, terra_table as (select count(distinct tx_from) as wallets,'TERRA : Total unique wallets since February 1st' from terra.transactions where block_timestamp::date >= '2022-02-01')
, solana_table as (select count(distinct tx_from_address)as wallets,'SOLANA : Total unique wallets since February 1st' as temp_field from solana.transactions where block_timestamp::date >= '2022-02-01')
, ethereum_table as (select count(distinct from_address) as wallets,'ETHEREUM : Total unique wallets since February 1st' as temp_field from ethereum.transactions where block_timestamp::date >= '2022-02-01')
select * from algorand_table
UNION
select * from terra_table
UNION
select * from solana_table
UNION
select * from ethereum_table
Run a query to Download Data