P as( select hour, price from base.price.ez_prices_hourly where token_address = '0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938' order by 1 desc limit 1 ),

L as ( select * from (values

('Ethereum' , '0xa469b7ee9ee773642b3e93e842e5d9b5baa10067'),

('Arbitrum' , '0x5018609ab477cc502e170a5accf5312b86a4b94f'),

('Base' , '0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938'),

('Blast' , '0x52056ed29fe015f4ba2e3b079d10c0b87f46e8c6'),

('Manta' , '0x73d23f3778a90be8846e172354a115543df2a7e4')

) as l1 (chain,contract_address) ),

K as ( select * from (values

('0xc46a2a9dd7d4daf5852ef71818a300f35ee8ee4c','Arbitrum','Dex','Camelot'),

('0xa544c20e6d22c0d47e3db9304be56ba89341a103','Blast','Dex','Thruster'),

('0xed0a57a0f1d12572a19711ad49117c16cc0dad11','Blast','Dex','Thruster'),

('0x69bb9e50eff791bfdf538b2d9e3a2d32c7aea69e','Blast','Dex','Thruster'),

('0x5559543e730881939c04c3717198404f5bebc73b','Blast','Dex','Fenix'),

('0x547213367cfb08ab418e7b54d7883b2c2aa27fd7','Ethereum','Dex','Anzen'),

('0x5d74abb95e85cba124fb27df08994ef072b5d49b','Ethereum','DeFi','Anzen'),

('0x663de54432a1d74912c99e7929d2d58a75452170','Ethereum','DeFi','Anzen'),

('0xd759e176def0f14e5c2d300238d41b1cbb5585bf','Ethereum','DeFi','Gudchain'),

('0x00da578acb3381f48f187374cda78d6824676f27','Ethereum','Dex','Uniswap'),

('0xf3a0d4580933022f2c54283adfa87ec51d17885c','Ethereum','Dex','Uniswap'),

('0x8c117f11f5c937e6465e014ca692ecacceca568f','Ethereum','Dex','Uniswap'),

('0xd543975c6eb81faad89e1fb6e5340666f468066f','Ethereum','Dex','Uniswap'),

('0x9008d19f58aabd9ed0d60971565aa8510560ab41','Ethereum','Dex','Cow'),

('0x000000fee13a103a10d593b9ae06b3e05f2e7e1c','Ethereum','Dex','Tokenelon'),

('0xa87c9808c0ebe20a1427b5c769623c77201f6f4d','Base','DeFi','Anzen'),

('0x9357e7f1c49e6d0094287f882fc47774fd3bc291','Base','DeFi','Zerolend'),

('0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb','Base','DeFi','Morpho'),

('0xa4442b665d4c6dbc6ea43137b336e3089f05626c','Base','DeFi','Ionic'),

('0xcbafa036638f9b128bed110420d4594353d03c55','Base','DeFi','Extra'),

('0xbdaaebf3095334058dc931293cf3892789d2d2b5','Base','DeFi','Krav'),

('0x6d0b9c9e92a3de30081563c3657b5258b3ffa38b','Base','Dex','Aerodrome'),

('0xcea8ef6ce6235f2c2cdd13c9e8a3ed470725a638','Base','Dex','Aerodrome'),