SYMBOL | CURRENT_PRICE | PREV_DAY_PRICE | PREV_WEEK_PRICE | |
|---|---|---|---|---|
1 | AMU | 0.0008909705556 | 0.0009359466667 | 0.0009085633333 |
2 | APT | 5.141111111 | 4.95 | 4.882083333 |
3 | AR | 5.619444444 | 5.55625 | 5.34875 |
4 | AVAX | 20.26 | 19.647916667 | 20.118333333 |
5 | AXS | 2.348333333 | 2.304583333 | 2.26375 |
6 | BTC | 87123.222222222 | 84776.708333333 | 84596.458333333 |
7 | BTRST | 0.2797823333 | 0.2772084167 | 0.2935152083 |
8 | COOKIE | 0.09918566667 | 0.09531475 | 0.09458945833 |
9 | DIVER | 0.005167973889 | 0.00513398 | 0.00518234875 |
10 | DYDX | 0.6046054444 | 0.590873 | 0.5592550833 |
11 | EDGE | 0.062822 | 0.06044995833 | 0.06717541667 |
12 | ENA | 0.2970801667 | 0.2841752917 | 0.3081795 |
13 | ETHFI | 0.4938017778 | 0.4766542083 | 0.4766547917 |
14 | EUL | 7.573888889 | 7.479583333 | 6.72625 |
15 | FIDA | 0.07285705556 | 0.07165754167 | 0.07048995833 |
16 | FLOW | 0.3771113333 | 0.3698801667 | 0.3540028333 |
17 | GALA | 0.01608462056 | 0.01540190208 | 0.01477676375 |
18 | GDT | 0.003274 | 0.003163532917 | 0.00312125125 |
19 | GENE | 0.05549705556 | 0.05531158333 | 0.061070625 |
20 | HASH | 0.01274124539 | 0.01274124539 | 0.01154261163 |
mcasto_Crypto Prices by Timeframe
Updated 4 days ago
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
›
⌄
with current_prices AS
(SELECT
DATE_TRUNC('day', HOUR) AS DAY,
SYMBOL AS SYMBOL,
TOKEN_ADDRESS AS TOKEN_CONTRACT,
BLOCKCHAIN AS BLOCKCHAIN,
IS_NATIVE AS IS_NATIVE,
AVG(PRICE) AS AVG_PRICE
FROM crosschain.price.ez_prices_hourly
WHERE
TOKEN_ADDRESS IN ('0x33349b282065b0284d756f0577fb39c158f935e6',
'0x799ebfabe77a6e34311eeee9825190b9ece32824','0x9f52c8ecbee10e00d9faaac5ee9ba0ff6550f511',
'0xbb0e17ef65f82ab018d8edd776e8dd940327b28b','0xe514d9deb7966c8be0ca922de8a064264ea6bcd4',
'0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0','hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux',
'0xd9fcd98c322942075a5c3860693e9f4f03aae07b','0x7c8155909cd385f120a56ef90728dd50f9ccbe52',
'0x6b3595068778dd592e39a122f4f5a5cf09c90fe2','ibc/831F0B1BBB1D08A2B75311892876D71565478C532967545476DF4C2D7492E48C',
'HZ1JovNiVvGrGNiiYvEo zEVgZ58xaU3RKwX8eACQBCt3','0x48c3399719b582dd63eb5aadf12a40b4c3f52fa2',
'0x5afe3855358e112b5647b952709e6165e1c1eeee','0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb',
'secret1k0jntykt7e4g3y88ltc60czgjuqdy4c9e8fzek','0xfa94348467f64d5a457f75f8bc40495d33c65abb',
'0xfa94348467f64d5a457f75f8bc40495d33c65abb','0xd402298a793948698b9a63311404fbbee944eafd',
'0xaa247c0d81b83812e1abf8bab078e4540d87e3fb','AMUwxPsqWSd1fbCGzWsrRKDcNoduuWMkdR38qPdit8G8',
'0xcb84d72e61e383767c4dfeb2d8ff7f4fb89abc6e','0xfb782396c9b20e564a64896181c7ac8d8979d5f4',
'0x3ef389f264e07fff3106a3926f2a166d1393086f', 'PoRTjZMPXb9T7dyU7tpLEZRQj7e6ssfAE62j2oQuc6y',
'0x1e4746dc744503b53b4a082cb3607b169a289090','GENEtH5amGSi8kHAtQoezp1XEXwZJ8vcuePYnXdKrMYz',
'EchesyfXePKdLtoiZSL8pBe8Myagyy8ZRqsACNCFGnvp','EchesyfXePKdLtoiZSL8pBe8Myagyy8ZRqsACNCFGnvp',
'0x1b40183efb4dd766f11bda7a7c3ad8982e998421','0xd1d2eb1b1e90b638588728b4130137d262c87cae',
'0x57e114b691db790c35207b2e685d4a43181e6061','0x1b40183efb4dd766f11bda7a7c3ad8982e998421',
'0xf1dc500fde233a4055e25e5bbf516372bc4f6871','0xC0041EF357B183448B235a8Ea73Ce4E4eC8c265F',
'0x9f285507ea5b4f33822ca7abb5ec8953ce37a645','0xc67b12049c2d0cf6e476bc64c7f82fc6c63cffc5',
'0xf1Dc500FdE233A4055e25e5BbF516372BC4F6871','0xa8754b9fa15fc18bb59458815510e40a12cd2014',
'0xbf30461210b37012783957D90dC26B95Ce3b6f2d','0xd0a6053f087e87a25dc60701ba6e663b1a548e85',
'0x163f8c2467924be0ae7b5347228cabf260318753', '0x163f8c2467924be0ae7b5347228cabf260318753',
'0xed6e000def95780fb89734c07ee2ce9f6dcaf110'
)
AND DATE(HOUR) = (SELECT DATE(MAX(HOUR)) FROM crosschain.price.ez_prices_hourly)
GROUP BY
Last run: 4 days ago
51
2KB
27s