TRUNC(block_timestamp, 'day') AS date,

SUM(event_data:amount) AS total_tx_flow_fee

FROM flow.core.fact_events

WHERE event_contract = 'A.f919ee77447b7497.FlowFees'

AND event_type = 'FeesDeducted'

AND block_timestamp < CURRENT_DATE

GROUP BY 1

ORDER BY 1 ASC;