FROM base.core.fact_token_transfers

LEFT outer join (

SELECT

date(hour) as date1,

token_address,

symbol,

decimals,

median(price) as price

FROM base.price.ez_hourly_token_prices

GROUP BY 1,2,3,4

) on date(block_timestamp) = date1

AND token_address = CONTRACT_ADDRESS

WHERE --tx_hash LIKE '0xc8dddfe5c9ccfe2ac6d0b17d58ab07702a6b128e27c556f33f256cccfefcc85e'

ORIGIN_TO_ADDRESS in (

lower('0xbb7e170df05231f2ceab51c80f35fe68e47d3af4'), --

lower('0xbBf71AAD6E1F8D180D3B1D898528654c1d18b2fF'), -- fBOMB/AERO

lower('0x7f670f78B17dEC44d5Ef68a48740b6f8849cc2e6'), -- WETH/AERO

lower('0x2223F9FE624F69Da4D8256A7bCc9104FBA7F8f75'), -- AERO/USDbC

lower('0x6EAB8c1B93f5799daDf2C687a30230a540DbD636'), -- DAI/USDbC

lower('0x9e4CB8b916289864321661CE02cf66aa5BA63C94'), -- WETH/DEUS

lower('0x4a3636608d7Bc5776CB19Eb72cAa36EbB9Ea683B'), -- USD+/USDbC

lower('0x1b05e4e814b3431a48b8164c41eaC834d9cE2Da6'), -- DAI+/USD+

lower('0x2d25E0514f23c6367687dE89Bd5167dc754D4934'), -- WETH/TAROT

lower('0xb680190fB16f417647e69D6A84719aE9c7E5E20a'), -- USDbC/STG

lower('0x8b432C54d6e8E1B8D1802753514AB53044Af1861'), -- DOLA/MAI

lower('0x218F511431194B2C756D67a137DE536beA74E498'), -- ERN/stERN

lower('0x6e23f90E25f432c9dF9eF9276472DDa3951e4465'),

lower('0xA819Af1CC8AbE618eA8abaDeb464960F7451CEAB'), -- WETH/UNIDX

lower('0x0B25c51637c43decd6CC1C1e3da4518D54ddb528'), -- DOLA/USBbC

lower('0x2B7704f1cb9324cD8586B33C6c540CbD64E58237'), -- EXTRA/USDbC

lower('0xAf58FDeE432a104a932a899968d60F92838886cd'), -- T/WETH

lower('0x2722C8f9B5E2aC72D1f225f8e8c990E449ba0078'), -- tBTC/WETH

lower('0x723AEf6543aecE026a15662Be4D3fb3424D502A9') -- tBTC/USDbC

LIMIT 100