Yousefi_1994Total Number of Transactions in the last months from month before
Updated 2022-07-20
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_wallet_rest_of_year as (
select
distinct proposer
from flow.core.fact_transactions
where block_timestamp::date > '2022-05-18' and block_timestamp::date <= '2022-06-18'
),
flow_wallet_last_from_befor_month as (
select
count(distinct proposer) as number_of_wallet
from flow.core.fact_transactions
where block_timestamp::date > '2022-06-18' and block_timestamp::date <= '2022-07-18'
and proposer in (select proposer from flow_wallet_rest_of_year)
),
flow_wallet_last_month as (
select
count(distinct proposer) as number_of_wallet
from flow.core.fact_transactions
where block_timestamp::date > '2022-06-18' and block_timestamp::date <= '2022-07-18'
),
ethereum_wallet_rest_of_year as (
select
distinct from_address
from ethereum.core.fact_transactions
where block_timestamp::date > '2022-05-18' and block_timestamp::date <= '2022-06-18'
),
ethereum_wallet_last_from_befor_month as (
select
count(distinct from_address) as number_of_wallet
from ethereum.core.fact_transactions
where block_timestamp::date > '2022-06-18' and block_timestamp::date <= '2022-07-18'
and from_address in (select from_address from ethereum_wallet_rest_of_year)
),
ethereum_wallet_last_month as (
select
count(distinct from_address) as number_of_wallet
from ethereum.core.fact_transactions
Run a query to Download Data