(

select sum(ETH_VALUE) as amount

,count(distinct TX_HASH) as total_count

, count(case when STATUS='SUCCESS' then 1 else null end) as success_count

, count(case when STATUS='FAIL' then 1 else null end) as fail_count

, sum(TX_FEE) as fees

,date_trunc('day', block_timestamp) as dt

from optimism.core.fact_transactions

group by dt

)

,eth_transfer_data as

(

select

ADDRESS_NAME,

sum(t.AMOUNT_USD) as amount

,count(distinct t.TX_HASH) as total_count

,date_trunc('day', t.block_timestamp) as dt

from optimism.core.ez_eth_transfers as t inner join optimism.core.dim_labels as l on t.ETH_TO_ADDRESS=l.ADDRESS

group by dt ,ADDRESS_NAME

)

,token_transfer_data as

(

select

ADDRESS_NAME,

sum(t.RAW_AMOUNT/1e18) as amount

,count(distinct t.TX_HASH) as total_count

,date_trunc('day', t.block_timestamp) as dt

from optimism.core.fact_token_transfers as t inner join optimism.core.dim_labels as l on t.TO_ADDRESS=l.ADDRESS

group by dt ,ADDRESS_NAME

having amount < 999999999

)

, token_bridges_inflow as

(

select sum(t.RAW_AMOUNT/1e18) as inflow,date_trunc('day', t.block_timestamp) as dt ,l.address_name