select PROPOSER

,TX_ID

,min(BLOCK_TIMESTAMP)as min_date

,max(BLOCK_TIMESTAMP)as last_date

from flow.core.fact_transactions

where BLOCK_TIMESTAMP>='2022-01-01'

group by 1,2),

tab2 as (

select TX_SENDER

,TX_GROUP_ID

,min(BLOCK_TIMESTAMP)as min_date

,max(BLOCK_TIMESTAMP)as last_date

from algorand.core.fact_transaction

where BLOCK_TIMESTAMP>='2022-01-01'

group by 1,2),

tab3 as (

select FROM_ADDRESS

,TX_HASH

,min(BLOCK_TIMESTAMP)as min_date

,max(BLOCK_TIMESTAMP)as last_date

from avalanche.core.fact_transactions

where BLOCK_TIMESTAMP>='2022-01-01'

group by 1,2),

tab4 as (

select FROM_ADDRESS

,TX_HASH

,min(BLOCK_TIMESTAMP)as min_date

,max(BLOCK_TIMESTAMP)as last_date

from bsc.core.fact_transactions

where BLOCK_TIMESTAMP>='2022-01-01'

group by 1,2),

tab5 as (

select TX_FROM

,TX_ID

,min(BLOCK_TIMESTAMP)as min_date