Sbhn_NP2024-06-24 10:32 AM
Updated 2024-10-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
select date_trunc('{{Date}}',block_timestamp) as date,
case when event_data:price_feed:price_identifier:bytes = '0xff61491a931112ddf1bd8147cd1b641375f79f5825126d665480874634fd0ace' then 'ETH'
when event_data:price_feed:price_identifier:bytes = '0xe62df6c8b4a85fe1a67db44dc12de5db330f7ac66b72dc658afedf0f4a415b43' then 'BTC'
when event_data:price_feed:price_identifier:bytes = '0x03ae4db29ed4ae33d323568895aa00337e658e348b37509f5372ae51f0af00d5' then 'APT'
when event_data:price_feed:price_identifier:bytes = '0x2f95862b045670cd22bee3114c39763a4a08beeb663b145d283c31d7d1101c4f' then 'BNB'
when event_data:price_feed:price_identifier:bytes = '0xef0d8b6fda2ceba41da15d4095d1da392a0d2f8ed0c6c7bc0f4cfac8c280b56d' then 'SOL'
when event_data:price_feed:price_identifier:bytes = '0xeaa020c61cc479712813461ce153894a96a6c00b21ed0cfc2798d1f9a9e9c94a' then 'USDC'
when event_data:price_feed:price_identifier:bytes = '0x2b89b9dc8fdf9f34709a5b106b472f0f39bb6ca9ce04b0fd7f2e971688e2e53b' then 'USDT'
when event_data:price_feed:price_identifier:bytes = '0x2356af9529a1064d41e32d617e2ce1dca5733afa901daba9e2b68dee5d53ecf9' then 'CAKE'
when event_data:price_feed:price_identifier:bytes = '0x23d7315113f5b1d3ba7a83604c44b94d79f4fd69af77f804fc7f920a6dc65744' then 'SUI'
when event_data:price_feed:price_identifier:bytes = '0xe5b274b2611143df055d6e7cd8d93fe1961716bcd4dca1cad87a83bc1e78c1ef' then 'CETUS'
when event_data:price_feed:price_identifier:bytes = '0xc9d8b075a5c69303365ae23633d4e085199bf5c520a3b90fed1322a0342ffc33' then 'WBTC'
when event_data:price_feed:price_identifier:bytes = '0x846ae1bdb6300b817cee5fdee2a6da192775030db5615b94a465f53bd40850b5' then 'STETH'
when event_data:price_feed:price_identifier:bytes = '0xdcef50dd0a4cd2dcc17e45df1676dcb336a11a61c69df7a0299b0150c672d25c' then 'DOGE'
when event_data:price_feed:price_identifier:bytes = '0x2a01deaec9e51a579277b34b122399984d0bbf57e2458a7e42fecd2829867a0d' then 'ADA'
when event_data:price_feed:price_identifier:bytes = '0x74e3fbb0d33e0ed8c0078b56134dcebdae38852f0858a8ea4de4c5ea7474bd42' then 'THL'
when event_data:price_feed:price_identifier:bytes = '0x3dd2b63686a450ec7290df3a1e0b583c0481f651351edfa7636f39aed55cf8a3' then 'BCH'
when event_data:price_feed:price_identifier:bytes = '0x2b9ab1e972a281585084148ba1389800799bd4be63b957507db1349314e47445' then 'AAVE'
when event_data:price_feed:price_identifier:bytes = '0x15add95022ae13563a11992e727c91bdb6b55bc183d9d747436c80a483d8c864' then 'APE'
when event_data:price_feed:price_identifier:bytes = '0x3fa4252848f9f0a1480be62745a4629d9eb1322aebab8a791e344b3b9c1adcf5' then 'ARB'
when event_data:price_feed:price_identifier:bytes = '0xa19d04ac696c7a6616d291c7e5d1377cc8be437c327b75adb5dc1bad745fcae8' then 'CRV'
when event_data:price_feed:price_identifier:bytes = '0x7f981f906d7cfe93f618804f1de89e0199ead306edc022d3230b3e8305f391b0' then 'BETH'
when event_data:price_feed:price_identifier:bytes = '0x15ecddd26d49e1a8f1de9376ebebc03916ede873447c1255d2d5891b92ce5717' then 'CBETH'
when event_data:price_feed:price_identifier:bytes = '0x5de33a9112c2b700b8d30b8a3402c103578ccfa2765696471cc672bd5cf6ac52' then 'MATIC'
when event_data:price_feed:price_identifier:bytes = '0xb0948a5e5313200c632b51bb5ca32f6de0d36e9950a942d19751e833f70dabfd' then 'DAI'
when event_data:price_feed:price_identifier:bytes = '0xec5d399846a9209f3fe5881d70aae9268c94339ff9817e8d18ff19fa05eea1c8' then 'XRP'
when event_data:price_feed:price_identifier:bytes = '0xca3eed9b267293f6595901c734c7525ce8ef49adafe8284606ceb307afa2ca5b' then 'DOT'
when event_data:price_feed:price_identifier:bytes = '0x6e3f3fa8253588df9326580180233eb791e03b443a3ba7a1d892e73874e19a54' then 'LTC'
when event_data:price_feed:price_identifier:bytes = '0x8963217838ab4cf5cadc172203c1f0b763fbaa45f346d8ee50ba994bbcac3026' then 'TON'
when event_data:price_feed:price_identifier:bytes = '0x67aed5a24fdad045475e7195c98a98aea119c763f272d4523f5bac93a4f33c2b' then 'TRX'
when event_data:price_feed:price_identifier:bytes = '0xf0d57deca57b3da2fe63a493f4c25925fdfd8edf834b20f93e1f84dbd1504d4a' then 'SHIB'
when event_data:price_feed:price_identifier:bytes = '0x78d185a741d07edb3412b09008b7c5cfb9bbbd7d568bf00ba737b456ba171501' then 'UNI'
when event_data:price_feed:price_identifier:bytes = '0xc3883bcf1101c111e9fcfe2465703c47f2b638e21fef2cce0502e6c8f416e0e2' then 'MANTA'
when event_data:price_feed:price_identifier:bytes = '0x78d185a741d07edb3412b09008b7c5cfb9bbbd7d568bf00ba737b456ba171501' then 'UNI'
when event_data:price_feed:price_identifier:bytes = '0x0bbf28e9a841a1cc788f6a361b17ca072d0ea3098a1e5df1c3922d06719579ff' then 'PYTH'
when event_data:price_feed:price_identifier:bytes = '0x09f7c1d7dfbb7df2b8fe3d3d87ee94a2259d212da4f30c1f0540d066dfa44723' then 'Forex JPY'
QueryRunArchived: QueryRun has been archived