mrwildcatpyth ethereum pairs time series def
Updated 2025-02-11
999
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
›
⌄
-- forked from pyth polygon pairs time series def @ https://flipsidecrypto.xyz/edit/queries/6b1fb3f3-7837-48b9-be0b-ed30a82a5b57
-- forked from pyth blast pairs time series def @ https://flipsidecrypto.xyz/edit/queries/0f359cdb-88ef-4a59-8201-43df658470e8
-- forked from pyth avalanche pairs time series def @ https://flipsidecrypto.xyz/edit/queries/42e5ed61-21cf-4825-be91-f7e6fb9b12ba
-- forked from pyth optimism pairs time series def @ https://flipsidecrypto.xyz/edit/queries/71534556-d14f-4aaf-9efd-7b93e2ebc4e9
-- forked from pyth gnosis pairs time series def @ https://flipsidecrypto.xyz/edit/queries/8cd17add-4ea3-4d32-bc0e-fb53ae2d5d5f
-- forked from pyth base pairs time series @ https://flipsidecrypto.xyz/edit/queries/0cc10a6c-e0fc-4d83-af73-daf26bbf98d4
-- forked from pyth bsc pairs time series @ https://flipsidecrypto.xyz/edit/queries/bb5b28da-6996-4773-b3ad-8a62b6962870
-- forked from 2024-06-29 09:45 PM @ https://flipsidecrypto.xyz/edit/queries/7526c40e-dbd8-474d-880a-5f2cc55e2539
WITH crypto_names AS (
SELECT * FROM (VALUES
('Commodities', 'BRENT1M', '0x374ddb8a25370dc3a997fd3c73103b1ac04c2cfd60103bf7f607fdb56c968e0d'),
('Commodities', 'BRENT2M', '0xa6416fd4788c8d0f0b5c7d9d93030f4f6b4a012a324771026f4b20d20114fcf4'),
('Commodities', 'BRENT3M', '0x6c4005cf9cc3c55690d8ad84a6487d5226f7fe732df55bfcfb76865061b0c10b'),
('Commodities', 'WTI1M', '0xeca3fb7e6be5be55a01678ee00f6405b9e4986e32d539ccd2a06a57e0c615880'),
('Commodities', 'WTI2M', '0xce78914f5aa6494591e123a5d5a8623fd85fe0fd247b97552177b48c2859eb1a'),
('Commodities', 'WTI3M', '0xc1ef96cd5a8c25e780ddc7e9e1dfaa9809e6a82ab8b58dbf233c47e9501f0176'),
('Crypto', '1INCH/USD', '0x63f341689d98a12ef60a5cff1d7f85c70a9e17bf1575f0e7c0b2512d48b1c8b3'),
('Crypto', 'AAVE/USD', '0x2b9ab1e972a281585084148ba1389800799bd4be63b957507db1349314e47445'),
('Crypto', 'ACM/USD', '0xbd640cddb72063e2ede34c6a0baf6699759b9837fcb06aa0e2fbcecb9b65fde7'),
('Crypto', 'ADA/USD', '0x2a01deaec9e51a579277b34b122399984d0bbf57e2458a7e42fecd2829867a0d'),
('Crypto', 'AGEUR/USD', '0x3b670a7aa22cf0dc3b76b42dc2e26a85bac35eafc5a5ae2defd6d98201b1b997'),
('Crypto', 'AKT/USD', '0x4ea5bb4d2f5900cc2e97ba534240950740b4d3b89fe712a94a7304fd2fd92702'),
('Crypto', 'ALGO/USD', '0xfa17ceaf30d19ba51112fdcc750cc83454776f47fb0112e4af07f15f4bb1ebc0'),
('Crypto', 'ALICE/USD', '0xccca1d2b0d9a9ca72aa2c849329520a378aea0ec7ef14497e67da4050d6cf578'),
('Crypto', 'ALPACA/USD', '0x9095653620547ece988ec51486dc7a6eb2efddbce8ea5bedbd53bf00cca84cf6'),
('Crypto', 'ALPINE/USD', '0x97d7d4c20e5a06fdb60f7a448a9e9a779f2b31c3f21121180010a4a470844aae'),
('Crypto', 'AMB/USD', '0xbe4cb6bf8f18e84b1c4fd6fafa7f048a972be26505bd58338eb66c80faa99483'),
('Crypto', 'AMP/USD', '0xd37e4513ebe235fff81e453d400debaf9a49a5df2b7faa11b3831d35d7e72cb7'),
QueryRunArchived: QueryRun has been archived