Hessishber pyth - daily
    Updated 2024-12-28
    with all_txs as (SELECT a.TOPICS[1] as feed_id,
    case
    when feed_id = '0x374ddb8a25370dc3a997fd3c73103b1ac04c2cfd60103bf7f607fdb56c968e0d' then 'Commodities.BRENT1M '
    when feed_id = '0xa6416fd4788c8d0f0b5c7d9d93030f4f6b4a012a324771026f4b20d20114fcf4' then 'Commodities.BRENT2M '
    when feed_id = '0x6c4005cf9cc3c55690d8ad84a6487d5226f7fe732df55bfcfb76865061b0c10b' then 'Commodities.BRENT3M '
    when feed_id = '0x925ca92ff005ae943c158e3563f59698ce7e75c5a8c8dd43303a0a154887b3e6' then 'Commodities.USOILSPOT '
    when feed_id = '0xeca3fb7e6be5be55a01678ee00f6405b9e4986e32d539ccd2a06a57e0c615880' then 'Commodities.WTI1M '
    when feed_id = '0xce78914f5aa6494591e123a5d5a8623fd85fe0fd247b97552177b48c2859eb1a' then 'Commodities.WTI2M '
    when feed_id = '0xc1ef96cd5a8c25e780ddc7e9e1dfaa9809e6a82ab8b58dbf233c47e9501f0176' then 'Commodities.WTI3M '
    when feed_id = '0x63f341689d98a12ef60a5cff1d7f85c70a9e17bf1575f0e7c0b2512d48b1c8b3' then '1INCH/USD'
    when feed_id = '0x2b9ab1e972a281585084148ba1389800799bd4be63b957507db1349314e47445' then 'AAVE/USD'
    when feed_id = '0xbd640cddb72063e2ede34c6a0baf6699759b9837fcb06aa0e2fbcecb9b65fde7' then 'ACM/USD'
    when feed_id = '0x2a01deaec9e51a579277b34b122399984d0bbf57e2458a7e42fecd2829867a0d' then 'ADA/USD'
    when feed_id = '0x9db37f4d5654aad3e37e2e14ffd8d53265fb3026d1d8f91146539eebaa2ef45f' then 'AERO/USD'
    when feed_id = '0x104e4d9ba218610b9af53c887f9fcb7396615259867a5a4b5983a65802aeee0b' then 'AEVO/USD'
    when feed_id = '0x17cd845b16e874485b2684f8b8d1517d744105dbb904eec30222717f4bc9ee0d' then 'AFSUI/USD'
    when feed_id = '0x3b670a7aa22cf0dc3b76b42dc2e26a85bac35eafc5a5ae2defd6d98201b1b997' then 'AGEUR/USD'
    when feed_id = '0x4ea5bb4d2f5900cc2e97ba534240950740b4d3b89fe712a94a7304fd2fd92702' then 'AKT/USD'
    when feed_id = '0xfc2176300cd75700a0aa99cf926dfddd99aa03cb2d20eb78f8161c10c143dbc7' then 'ALEX/USD '
    when feed_id = '0xfa17ceaf30d19ba51112fdcc750cc83454776f47fb0112e4af07f15f4bb1ebc0' then 'ALGO/USD'
    when feed_id = '0xccca1d2b0d9a9ca72aa2c849329520a378aea0ec7ef14497e67da4050d6cf578' then 'ALICE/USD'
    when feed_id = '0x9095653620547ece988ec51486dc7a6eb2efddbce8ea5bedbd53bf00cca84cf6' then 'ALPACA/USD'
    when feed_id = '0x119ff2acf90f68582f5afd6f7d5f12dbae81e4423f165837169d6b94c27fb384' then 'ALT/USD'
    when feed_id = '0xbe4cb6bf8f18e84b1c4fd6fafa7f048a972be26505bd58338eb66c80faa99483' then 'AMB/USD'
    when feed_id = '0xd37e4513ebe235fff81e453d400debaf9a49a5df2b7faa11b3831d35d7e72cb7' then 'AMP/USD'
    when feed_id = '0x89a58e1cab821118133d6831f5018fba5b354afb78b2d18f575b3cbf69a4f652' then 'ANKR/USD'
    when feed_id = '0x15add95022ae13563a11992e727c91bdb6b55bc183d9d747436c80a483d8c864' then 'APE/USD'
    when feed_id = '0x95ea50020cf75a81a105d639fd74773ade522e12044600b52286ff5961c71412' then 'API3/USD'
    when feed_id = '0x03ae4db29ed4ae33d323568895aa00337e658e348b37509f5372ae51f0af00d5' then 'APT/USD'
    when feed_id = '0xf610eae82767039ffc95eef8feaeddb7bbac0673cfe7773b2fde24fd1adb0aee' then 'AR/USD'
    when feed_id = '0x3fa4252848f9f0a1480be62745a4629d9eb1322aebab8a791e344b3b9c1adcf5' then 'ARB/USD'
    when feed_id = '0x2394ce86c7d68050ce52797923860f6c1656a73fb11bd10dacb3f9c719acdd1d' then 'ARG/USD '
    when feed_id = '0x7677dd124dee46cfcd46ff03cf405fb0ed94b1f49efbea3444aadbda939a7ad3' then 'ARKM/USD'
    when feed_id = '0xb881c6dad5dd3dc9a83222f8032fb439859288119afc742d43adc305cef151cc' then 'ASR/USD'
    when feed_id = '0x89b814de1eb2afd3d3b498d296fca3a873e644bafb587e84d181a01edd682853' then 'ASTR/USD'
    when feed_id = '0x2c6d813b1fbc97004bc0e420ca4c85455f4304fcd9b208d23e7a161ad113377c' then 'ASTRO/USD '