with initial_data_one as
(
select
distinct from_address as address,
block_timestamp
from polygon.core.fact_transactions
where block_timestamp::date > '2022-07-01'
),
initial_data_two as
(
select
distinct from_address as address,
block_timestamp
from polygon.core.fact_token_transfers
where block_timestamp::date > '2022-07-01'
),
initial_data_three as
(
select
distinct matic_from_address as address,
block_timestamp
from polygon.core.ez_matic_transfers
where block_timestamp::date > '2022-07-01'
),
initial_data_five as
(
select 'transactions' as status, * from initial_data_one
UNION
select 'token transfer' as status, * from initial_data_two
UNION
select 'matic transfer' as status, * from initial_data_three
)
select
status,
count(address) as number,
block_timestamp::date as day