SELECT b.Value*0.01 as Fee, 'YOLO' as "type" FROM blast.core.fact_event_logs a

INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH

WHERE a.contract_address = LOWER('0x0000000000E14E87e5c80A8A90817308fFF715d3')

AND a.tx_status = 'SUCCESS'

AND a.topics[0] = '0x73a19dd210f1a7f902193214c0ee91dd35ee5b4d920cba8d519eca65a7b488ca' -- yolo deposited

AND a.BLOCK_TIMESTAMP <= '2024-06-11 14:00:00.000'

AND a.BLOCK_TIMESTAMP >= '2024-02-21 14:00:00.000'

UNION ALL

SELECT b.Value*0.01 as Fee, 'YOLO' as "type" FROM blast.core.fact_event_logs a

INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH

WHERE contract_address = LOWER('0x0000000000E14E87e5c80A8A90817308fFF715d3')

AND tx_status = 'SUCCESS'

AND topics[0] = '0xa315167fc4200676e8597c5df065fafa8cecfeac15a8e2aded299a649e4a5175' -- yolo multientry

AND a.BLOCK_TIMESTAMP <= '2024-06-11 14:00:00.000'

AND a.BLOCK_TIMESTAMP >= '2024-02-21 14:00:00.000'

UNION ALL

SELECT b.Value*0.01 as Fee, 'YOLO Limited' as "type" FROM blast.core.fact_event_logs a

INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH

WHERE a.contract_address = LOWER('0x28EF3eaE1AbB6D6e22e9bFc7a0944f707E4726b3')

AND a.tx_status = 'SUCCESS'

AND a.topics[0] = '0x73a19dd210f1a7f902193214c0ee91dd35ee5b4d920cba8d519eca65a7b488ca' -- yololimited deposited

AND a.BLOCK_TIMESTAMP <= '2024-06-11 14:00:00.000'

AND a.BLOCK_TIMESTAMP >= '2024-02-21 14:00:00.000'

UNION ALL

SELECT b.Value*0.01 as Fee, 'YOLO Limited' as "type" FROM blast.core.fact_event_logs a

INNER JOIN blast.core.fact_transactions b ON a.TX_HASH = b.TX_HASH

WHERE contract_address = LOWER('0x28EF3eaE1AbB6D6e22e9bFc7a0944f707E4726b3')

AND tx_status = 'SUCCESS'

AND topics[0] = '0xa315167fc4200676e8597c5df065fafa8cecfeac15a8e2aded299a649e4a5175' -- yololimited multientry

AND a.BLOCK_TIMESTAMP <= '2024-06-11 14:00:00.000'

AND a.BLOCK_TIMESTAMP >= '2024-02-21 14:00:00.000'