kiacryptoNumber of wallets that used the chain everyday since May 9th
Updated 2022-05-31Copy Reference Fork
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 flow as (
select authorizers, count(distinct block_timestamp::date) as number_of_day
from flow.core.fact_transactions
where block_timestamp::date between '2022-05-09' and '2022-05-30'
group by 1 having number_of_day = 22
),
sol as (
select signers, count(distinct block_timestamp::date) as number_of_day
from flipside_prod_db.solana.fact_transactions
where block_timestamp::date between '2022-05-09' and '2022-05-30'
group by 1 having number_of_day = 22
),
eth as (
select from_address, count(distinct block_timestamp::date) as number_of_day
from flipside_prod_db.ethereum_core.fact_transactions
where block_timestamp::date between '2022-05-09' and '2022-05-30'
group by 1 having number_of_day = 22
),
algo as (
select sender, count(distinct block_timestamp::date) as number_of_day
from flipside_prod_db.algorand.transactions
where block_timestamp::date between '2022-05-09' and '2022-05-30'
group by 1 having number_of_day = 22
)
select count(*) as number_of_wallet, 'flow' as blockchain
from flow
union all
select count(*) as number_of_wallet, 'solana' as blockchain
from sol
union all
select count(*) as number_of_wallet, 'ethereum' as blockchain
Run a query to Download Data