PREVIEW / futures_1hour / 2024-10-28
file: by_date/futures_1hour/2024/2024-10-28.parquet size: 67 KB rows: 2,127
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-28 00:00:00 | ES | Futures | 6095.95 | 6103.47 | 6095.43 | 6102.95 | 4632.0 |
| 2024-10-28 01:00:00 | ES | Futures | 6103.21 | 6103.47 | 6092.83 | 6093.09 | 6034.0 |
| 2024-10-28 02:00:00 | ES | Futures | 6093.35 | 6098.54 | 6092.05 | 6095.69 | 5425.0 |
| 2024-10-28 03:00:00 | ES | Futures | 6095.69 | 6104.25 | 6094.91 | 6099.06 | 11455.0 |
| 2024-10-28 04:00:00 | ES | Futures | 6099.06 | 6107.62 | 6094.13 | 6105.29 | 20890.0 |
| 2024-10-28 05:00:00 | ES | Futures | 6105.55 | 6106.85 | 6100.62 | 6106.85 | 10305.0 |
| 2024-10-28 06:00:00 | ES | Futures | 6106.59 | 6108.66 | 6099.84 | 6100.1 | 10809.0 |
| 2024-10-28 07:00:00 | ES | Futures | 6100.1 | 6101.65 | 6094.13 | 6094.13 | 18593.0 |
| 2024-10-28 08:00:00 | ES | Futures | 6094.13 | 6104.25 | 6087.64 | 6103.47 | 32473.0 |
| 2024-10-28 09:00:00 | ES | Futures | 6103.21 | 6105.81 | 6091.27 | 6093.09 | 133854.0 |
| 2024-10-28 10:00:00 | ES | Futures | 6093.09 | 6103.73 | 6089.98 | 6097.76 | 124719.0 |
| 2024-10-28 11:00:00 | ES | Futures | 6097.76 | 6099.06 | 6084.79 | 6086.86 | 110677.0 |
| 2024-10-28 12:00:00 | ES | Futures | 6086.6 | 6095.17 | 6083.23 | 6087.9 | 84828.0 |
| 2024-10-28 13:00:00 | ES | Futures | 6088.16 | 6095.95 | 6083.23 | 6094.91 | 68688.0 |
| 2024-10-28 14:00:00 | ES | Futures | 6095.17 | 6096.46 | 6086.08 | 6089.2 | 78736.0 |
| 2024-10-28 15:00:00 | ES | Futures | 6088.94 | 6095.17 | 6082.71 | 6086.08 | 146225.0 |
| 2024-10-28 16:00:00 | ES | Futures | 6085.82 | 6089.98 | 6084.01 | 6087.64 | 58152.0 |
| 2024-10-28 18:00:00 | ES | Futures | 6090.5 | 6090.5 | 6081.67 | 6083.75 | 5300.0 |
| 2024-10-28 19:00:00 | ES | Futures | 6084.01 | 6086.08 | 6082.45 | 6084.53 | 3051.0 |
| 2024-10-28 20:00:00 | ES | Futures | 6084.79 | 6086.6 | 6078.3 | 6084.27 | 6952.0 |
| 2024-10-28 21:00:00 | ES | Futures | 6084.27 | 6085.3 | 6079.85 | 6083.23 | 8069.0 |
| 2024-10-28 22:00:00 | ES | Futures | 6083.23 | 6084.79 | 6080.89 | 6082.45 | 5083.0 |
| 2024-10-28 23:00:00 | ES | Futures | 6082.45 | 6086.34 | 6073.11 | 6074.66 | 8090.0 |
| 2024-10-28 00:00:00 | NQ | Futures | 21512.22 | 21560.23 | 21510.13 | 21557.88 | 3787.0 |
| 2024-10-28 01:00:00 | NQ | Futures | 21558.14 | 21560.23 | 21504.39 | 21507.0 | 3913.0 |
| 2024-10-28 02:00:00 | NQ | Futures | 21507.26 | 21535.96 | 21501.0 | 21521.09 | 3573.0 |
| 2024-10-28 03:00:00 | NQ | Futures | 21520.31 | 21552.92 | 21513.53 | 21530.22 | 5911.0 |
| 2024-10-28 04:00:00 | NQ | Futures | 21531.27 | 21570.14 | 21505.7 | 21562.84 | 9748.0 |
| 2024-10-28 05:00:00 | NQ | Futures | 21563.1 | 21572.75 | 21538.83 | 21572.23 | 5588.0 |
| 2024-10-28 06:00:00 | NQ | Futures | 21571.71 | 21579.01 | 21529.44 | 21533.62 | 5848.0 |
| 2024-10-28 07:00:00 | NQ | Futures | 21533.09 | 21540.14 | 21509.87 | 21519.0 | 7546.0 |
| 2024-10-28 08:00:00 | NQ | Futures | 21519.27 | 21562.32 | 21479.08 | 21561.27 | 15499.0 |
| 2024-10-28 09:00:00 | NQ | Futures | 21560.49 | 21567.8 | 21424.55 | 21453.52 | 65611.0 |
| 2024-10-28 10:00:00 | NQ | Futures | 21452.99 | 21517.96 | 21449.6 | 21473.61 | 63555.0 |
| 2024-10-28 11:00:00 | NQ | Futures | 21473.34 | 21478.04 | 21416.21 | 21428.21 | 50848.0 |
| 2024-10-28 12:00:00 | NQ | Futures | 21428.21 | 21469.43 | 21412.03 | 21426.38 | 35267.0 |
| 2024-10-28 13:00:00 | NQ | Futures | 21426.38 | 21457.69 | 21401.85 | 21452.73 | 30982.0 |
| 2024-10-28 14:00:00 | NQ | Futures | 21452.73 | 21457.43 | 21399.51 | 21419.08 | 33500.0 |
| 2024-10-28 15:00:00 | NQ | Futures | 21419.34 | 21435.77 | 21380.2 | 21395.33 | 44663.0 |
| 2024-10-28 16:00:00 | NQ | Futures | 21395.33 | 21419.08 | 21384.9 | 21402.38 | 12221.0 |
| 2024-10-28 18:00:00 | NQ | Futures | 21408.38 | 21421.42 | 21383.59 | 21392.98 | 2518.0 |
| 2024-10-28 19:00:00 | NQ | Futures | 21392.98 | 21406.03 | 21389.07 | 21402.12 | 1891.0 |
| 2024-10-28 20:00:00 | NQ | Futures | 21403.16 | 21419.34 | 21370.02 | 21408.64 | 4242.0 |
| 2024-10-28 21:00:00 | NQ | Futures | 21408.9 | 21415.16 | 21383.33 | 21401.59 | 4379.0 |
| 2024-10-28 22:00:00 | NQ | Futures | 21402.38 | 21407.07 | 21384.11 | 21395.85 | 2899.0 |
| 2024-10-28 23:00:00 | NQ | Futures | 21395.59 | 21414.38 | 21348.89 | 21354.63 | 4320.0 |
| 2024-10-28 00:00:00 | YM | Futures | 44211.2 | 44244.5 | 44207.0 | 44243.4 | 782.0 |
| 2024-10-28 01:00:00 | YM | Futures | 44243.4 | 44245.5 | 44192.4 | 44195.5 | 577.0 |
| 2024-10-28 02:00:00 | YM | Futures | 44195.5 | 44225.7 | 44186.2 | 44213.2 | 834.0 |
| 2024-10-28 03:00:00 | YM | Futures | 44212.2 | 44277.8 | 44208.0 | 44233.0 | 1982.0 |
> showing 50 of 2,127 rows — these rows as CSV