PREVIEW / futures_1hour / 2021-09-26
file: by_date/futures_1hour/2021/2021-09-26.parquet size: 19 KB rows: 399
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2021-09-26 18:00:00 | ES | Futures | 5018.87 | 5027.9 | 5017.74 | 5025.36 | 10744.0 |
| 2021-09-26 19:00:00 | ES | Futures | 5025.36 | 5026.49 | 5020.84 | 5025.64 | 5855.0 |
| 2021-09-26 20:00:00 | ES | Futures | 5025.92 | 5037.77 | 5023.95 | 5036.08 | 19552.0 |
| 2021-09-26 21:00:00 | ES | Futures | 5036.08 | 5043.14 | 5035.8 | 5042.01 | 10282.0 |
| 2021-09-26 22:00:00 | ES | Futures | 5042.01 | 5043.14 | 5039.75 | 5040.88 | 6268.0 |
| 2021-09-26 23:00:00 | ES | Futures | 5041.16 | 5042.01 | 5035.23 | 5036.64 | 4867.0 |
| 2021-09-26 18:00:00 | NQ | Futures | 17758.84 | 17771.59 | 17741.74 | 17745.79 | 5085.0 |
| 2021-09-26 19:00:00 | NQ | Futures | 17746.66 | 17759.42 | 17738.26 | 17757.68 | 2615.0 |
| 2021-09-26 20:00:00 | NQ | Futures | 17757.68 | 17822.6 | 17754.2 | 17816.51 | 8427.0 |
| 2021-09-26 21:00:00 | NQ | Futures | 17817.09 | 17850.71 | 17811.29 | 17841.43 | 5597.0 |
| 2021-09-26 22:00:00 | NQ | Futures | 17841.43 | 17844.62 | 17827.81 | 17833.61 | 3338.0 |
| 2021-09-26 23:00:00 | NQ | Futures | 17833.9 | 17839.12 | 17811.0 | 17816.51 | 2804.0 |
| 2021-09-26 18:00:00 | YM | Futures | 38891.0 | 38985.2 | 38876.4 | 38953.8 | 2667.0 |
| 2021-09-26 19:00:00 | YM | Futures | 38957.1 | 38970.6 | 38910.1 | 38968.3 | 1625.0 |
| 2021-09-26 20:00:00 | YM | Futures | 38967.2 | 39045.7 | 38952.7 | 39026.6 | 3368.0 |
| 2021-09-26 21:00:00 | YM | Futures | 39025.5 | 39074.8 | 39021.0 | 39064.7 | 1648.0 |
| 2021-09-26 22:00:00 | YM | Futures | 39065.9 | 39074.8 | 39049.1 | 39055.8 | 1432.0 |
| 2021-09-26 23:00:00 | YM | Futures | 39056.9 | 39064.7 | 39007.6 | 39019.9 | 1076.0 |
| 2021-09-26 18:00:00 | CL | Futures | 51.44 | 51.77 | 51.42 | 51.68 | 5792.0 |
| 2021-09-26 19:00:00 | CL | Futures | 51.69 | 51.88 | 51.66 | 51.88 | 3326.0 |
| 2021-09-26 20:00:00 | CL | Futures | 51.88 | 51.97 | 51.83 | 51.95 | 5228.0 |
| 2021-09-26 21:00:00 | CL | Futures | 51.95 | 52.23 | 51.95 | 52.16 | 12593.0 |
| 2021-09-26 22:00:00 | CL | Futures | 52.17 | 52.17 | 51.93 | 52.09 | 7214.0 |
| 2021-09-26 23:00:00 | CL | Futures | 52.09 | 52.09 | 51.86 | 51.93 | 3743.0 |
| 2021-09-26 18:00:00 | GC | Futures | 2108.8 | 2109.2 | 2104.8 | 2105.5 | 1358.0 |
| 2021-09-26 19:00:00 | GC | Futures | 2105.5 | 2106.8 | 2104.6 | 2106.3 | 1116.0 |
| 2021-09-26 20:00:00 | GC | Futures | 2106.3 | 2112.2 | 2105.8 | 2111.4 | 3010.0 |
| 2021-09-26 21:00:00 | GC | Futures | 2111.6 | 2118.3 | 2110.5 | 2117.2 | 5198.0 |
| 2021-09-26 22:00:00 | GC | Futures | 2117.2 | 2119.8 | 2116.7 | 2118.5 | 3134.0 |
| 2021-09-26 23:00:00 | GC | Futures | 2118.5 | 2119.4 | 2117.1 | 2117.8 | 1552.0 |
| 2021-09-26 18:00:00 | ZN | Futures | 134.93654 | 134.93654 | 134.872688 | 134.872688 | 16749.0 |
| 2021-09-26 19:00:00 | ZN | Futures | 134.856725 | 134.888651 | 134.824798 | 134.872688 | 15330.0 |
| 2021-09-26 20:00:00 | ZN | Futures | 134.872688 | 134.968467 | 134.840761 | 134.968467 | 27623.0 |
| 2021-09-26 21:00:00 | ZN | Futures | 134.952504 | 135.000393 | 134.920577 | 134.952504 | 20162.0 |
| 2021-09-26 22:00:00 | ZN | Futures | 134.952504 | 135.000393 | 134.952504 | 135.000393 | 17534.0 |
| 2021-09-26 23:00:00 | ZN | Futures | 134.98443 | 135.016356 | 134.968467 | 135.000393 | 11604.0 |
> showing 36 of 399 rows — these rows as CSV