*

FROM (

SELECT

date_trunc('day', HOUR) as date,

CASE

when token_address LIKE lower('0x2260FAC5E5542a773Aa44fBCfeDf7C193bc2C599')

AND blockchain LIKE 'ethereum'

then 'BTC'

when token_address LIKE lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2')

AND blockchain LIKE 'ethereum'

then 'ETH'

when token_address LIKE lower('0xbb4CdB9CBd36B01bD1cBaEBF2De08d9173bc095c')

AND blockchain LIKE 'bsc'

then 'BNB'

when token_address LIKE lower('0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7')

AND blockchain LIKE 'avalanche'

then 'AVAX'

when token_address LIKE lower('0x0d500B1d8E8eF31E21C99d1Db9A6444d3ADf1270')

AND blockchain LIKE 'polygon'

then 'MATIC'

when token_address LIKE lower('0x4200000000000000000000000000000000000042')

AND blockchain LIKE 'optimism'

then 'OP'

when token_address LIKE lower('0x912CE59144191C1204E64559FE8253a0e49E6548')

AND blockchain LIKE 'arbitrum'

then 'ARB'

when token_address LIKE lower('0x1f9840a85d5aF5bf1D1762F925BDADdC4201F984')

AND blockchain LIKE 'ethereum'

then 'UNI'

when token_address LIKE lower('0x9f8F72aA9304c8B593d555F12eF6589cC3A579A2')

AND blockchain LIKE 'ethereum'

then 'MKR'

when token_address LIKE lower('0x5A98FcBEA516Cf06857215779Fd812CA3beF1B32')