SELECT

DISTINCT DATE_TRUNC('day',block_timestamp) AS dt

FROM optimism.core.fact_transactions

WHERE dt >= DATE_TRUNC('day',(select max(block_timestamp) from optimism.core.fact_transactions)) - interval '6 months' - interval '31 days'

ORDER BY dt desc

)

,trunc_event_data AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS dt,

tx_hash,

l.project_name AS project,

l.label_type AS type

--,count(distinct event_index),

--count(distinct label_type) as l

FROM

optimism.core.fact_event_logs f

INNER JOIN optimism.core.dim_labels l ON f.ORIGIN_FROM_ADDRESS = l.address

--WHERE dt_hour > DATE_TRUNC(hour,NOW()) - interval '24 hours'

WHERE dt >= DATE_TRUNC('day',(select max(block_timestamp) from optimism.core.fact_transactions)) - interval '6 months' - interval '31 days'

GROUP BY 1,2,3,4

ORDER BY 2, dt desc

,addrs AS (

SELECT dt, addr, num_txs -- , eth_fees

FROM (

SELECT

DATE_TRUNC('day',block_timestamp) AS dt, from_address AS addr--, 'Send' AS addr_type

, COUNT(*) AS num_txs

-- , SUM( (l1_fee + gas_price*gas_used)/1e18 ) AS eth_fees

FROM optimism.core.fact_transactions f

INNER JOIN trunc_event_data e ON f.tx_hash = e.tx_hash