DATE_TRUNC('day', HOUR) AS DAY,

SYMBOL AS SYMBOL,

TOKEN_ADDRESS AS TOKEN_CONTRACT,

BLOCKCHAIN AS BLOCKCHAIN,

IS_NATIVE AS IS_NATIVE,

AVG(PRICE) AS AVG_PRICE

FROM crosschain.price.ez_prices_hourly

WHERE

TOKEN_ADDRESS IN ('0xf091867ec603a6628ed83d274e835539d82e9cc8','0x33349b282065b0284d756f0577fb39c158f935e6',

'0x799ebfabe77a6e34311eeee9825190b9ece32824','0x9f52c8ecbee10e00d9faaac5ee9ba0ff6550f511',

'0xbb0e17ef65f82ab018d8edd776e8dd940327b28b','0xe514d9deb7966c8be0ca922de8a064264ea6bcd4',

'0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0','hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux',

'0xd9fcd98c322942075a5c3860693e9f4f03aae07b','0x94F82266C8f64e4c7108406f84E38498141c8211',

'0x6b3595068778dd592e39a122f4f5a5cf09c90fe2','ibc/831F0B1BBB1D08A2B75311892876D71565478C532967545476DF4C2D7492E48C',

'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3','0x48c3399719b582dd63eb5aadf12a40b4c3f52fa2',

'0x5afe3855358e112b5647b952709e6165e1c1eeee','0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb',

'secret1k0jntykt7e4g3y88ltc60czgjuqdy4c9e8fzek','0xfa94348467f64d5a457f75f8bc40495d33c65abb',

'0xfa94348467f64d5a457f75f8bc40495d33c65abb','0xd402298a793948698b9a63311404fbbee944eafd',

'0xaa247c0d81b83812e1abf8bab078e4540d87e3fb','AMUwxPsqWSd1fbCGzWsrRKDcNoduuWMkdR38qPdit8G8',

'0xcb84d72e61e383767c4dfeb2d8ff7f4fb89abc6e','0xfb782396c9b20e564a64896181c7ac8d8979d5f4',

'0x3ef389f264e07fff3106a3926f2a166d1393086f', 'PoRTjZMPXb9T7dyU7tpLEZRQj7e6ssfAE62j2oQuc6y',

'0x1e4746dc744503b53b4a082cb3607b169a289090','GENEtH5amGSi8kHAtQoezp1XEXwZJ8vcuePYnXdKrMYz',

'EchesyfXePKdLtoiZSL8pBe8Myagyy8ZRqsACNCFGnvp','EchesyfXePKdLtoiZSL8pBe8Myagyy8ZRqsACNCFGnvp',

'0x1b40183efb4dd766f11bda7a7c3ad8982e998421','0xd1d2eb1b1e90b638588728b4130137d262c87cae',

'0x57e114b691db790c35207b2e685d4a43181e6061','0x1b40183efb4dd766f11bda7a7c3ad8982e998421',

'0xf1dc500fde233a4055e25e5bbf516372bc4f6871','0xC0041EF357B183448B235a8Ea73Ce4E4eC8c265F',

'0x9f285507ea5b4f33822ca7abb5ec8953ce37a645','0xc67b12049c2d0cf6e476bc64c7f82fc6c63cffc5',

'0xf1Dc500FdE233A4055e25e5BbF516372BC4F6871','0xa8754b9fa15fc18bb59458815510e40a12cd2014',

'0xbf30461210b37012783957D90dC26B95Ce3b6f2d','0xd0a6053f087e87a25dc60701ba6e663b1a548e85',

'0x4c9edd5852cd905f086c759e8383e09bff1e68b3','0x163f8c2467924be0ae7b5347228cabf260318753',

'0xae7ab96520de3a18e5e111b5eaab095312d7fe84','0x157a6df6B74F4E5E45af4E4615FDe7B49225a662')

AND DATE(HOUR) = (SELECT DATE(MAX(HOUR)) FROM crosschain.price.ez_prices_hourly)

GROUP BY

DAY, SYMBOL, TOKEN_CONTRACT, BLOCKCHAIN, IS_NATIVE