from algorand.transactions where day >= '2022-5-9'and fee is not null

group by day),

eth as ( select date(block_timestamp) as date, sum(TX_FEE) as Ethereum_fee

from ethereum_core.fact_transactions where date >= '2022-05-09'

group by date),

sol as ( select date(block_timestamp) as date, sum(FEE)/pow(10,9) as Solana_fee

from solana.fact_transactions where date >= '2022-05-09'

group by date),

flow as ( select date_trunc(day,block_timestamp) as date, (1e-5 * count (TX_ID)) as Flow_fee

from flow.core.fact_events where block_timestamp >= '2022-05-09' and EVENT_TYPE='FeesDeducted'

group by date)

select algo.day, Algorand_fee, Ethereum_fee, Solana_fee,Flow_fee from algo

join eth on algo.day = eth.date join sol on algo.day = sol.date join flow on algo.day = flow.date