--The total volume of overtime markets in the last two weeks
SELECT sum(CASE WHEN CONTRACT_ADDRESS='0x7f5c764cbc14f9669b88837ca1490cca17c31607' THEN RAW_AMOUNT/1e6 WHEN CONTRACT_ADDRESS='0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9' THEN RAW_AMOUNT/1e18 WHEN
CONTRACT_ADDRESS='0x94b008aa00579c1307b0ef2c499ad98a8ce58e58' THEN RAW_AMOUNT/1e6 WHEN CONTRACT_ADDRESS='0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' THEN RAW_AMOUNT/1e18 END) AS total_volume FROM optimism.core.fact_token_transfers
WHERE block_timestamp>=CURRENT_DATE-14 AND ORIGIN_TO_ADDRESS='0x170a5714112daeff20e798b6e92e25b86ea603c1' AND TO_ADDRESS='0x170a5714112daeff20e798b6e92e25b86ea603c1'