SELECT DATE_TRUNC('day', block_timestamp) as day, SUM(ethereum.public.udf_hex_to_int(substr(data,3,64))::numeric/1E18) as amount FROM blast.core.fact_event_logs

WHERE contract_address = LOWER('0x0000000000e14e87e5c80a8a90817308fff715d3')

AND tx_status = 'SUCCESS'

AND topics[0] = LOWER('0xa0c67dacab0c86ad0a872c2ed3fa9deb08f80f4f0543d481f2fac9ee41d02691') -- YOLO Safe Recieved

GROUP BY 1

UNION ALL

SELECT DATE_TRUNC('day', block_timestamp) as day, sum(value) as fees FROM blast.core.fact_traces

WHERE TO_ADDRESS = LOWER('0x6b86fF7863e27d1C8CCf05dF9cB03b8eFaA52125')

AND FROM_ADDRESS = LOWER('0x0000000000acc01064aa5280da3f1c41a35827bc') -- PTB

GROUP BY 1

UNION ALL

SELECT DATE_TRUNC('day', block_timestamp) as day, sum(value) as fees FROM blast.core.fact_traces

WHERE TO_ADDRESS = LOWER('0x6b86fF7863e27d1C8CCf05dF9cB03b8eFaA52125')

AND FROM_ADDRESS = LOWER('0x693B37a9859Ce9465Fb2aAdeB03811a26A0c37C0') -- MOD ETH

GROUP BY 1

UNION ALL

SELECT DATE_TRUNC('day', block_timestamp) as day, sum(value) as fees FROM blast.core.fact_traces

WHERE TO_ADDRESS = LOWER('0x6b86fF7863e27d1C8CCf05dF9cB03b8eFaA52125')

AND FROM_ADDRESS = LOWER('0xA56A95F41e64Bc76CDE7423aB2A2ee1763bD8Bcc') -- MOD BTC

GROUP BY 1

)

GROUP BY 1

ORDER BY 1 ASC