PREVIEW / futures_1hour / 2024-10-13
file: by_date/futures_1hour/2024/2024-10-13.parquet size: 19 KB rows: 433
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-13 18:00:00 | ES | Futures | 6077.52 | 6082.19 | 6074.92 | 6081.67 | 6929.0 |
| 2024-10-13 19:00:00 | ES | Futures | 6081.67 | 6083.49 | 6078.04 | 6078.56 | 4144.0 |
| 2024-10-13 20:00:00 | ES | Futures | 6078.56 | 6080.37 | 6076.74 | 6078.3 | 3933.0 |
| 2024-10-13 21:00:00 | ES | Futures | 6078.04 | 6080.11 | 6075.7 | 6076.74 | 5485.0 |
| 2024-10-13 22:00:00 | ES | Futures | 6076.74 | 6078.04 | 6072.85 | 6077.26 | 4004.0 |
| 2024-10-13 23:00:00 | ES | Futures | 6077.52 | 6080.37 | 6075.18 | 6078.56 | 2635.0 |
| 2024-10-13 18:00:00 | NQ | Futures | 21324.36 | 21336.11 | 21298.27 | 21332.45 | 3734.0 |
| 2024-10-13 19:00:00 | NQ | Futures | 21332.45 | 21343.41 | 21314.45 | 21318.1 | 3003.0 |
| 2024-10-13 20:00:00 | NQ | Futures | 21318.88 | 21324.36 | 21301.14 | 21306.1 | 2745.0 |
| 2024-10-13 21:00:00 | NQ | Futures | 21306.1 | 21310.54 | 21284.97 | 21290.71 | 3850.0 |
| 2024-10-13 22:00:00 | NQ | Futures | 21290.45 | 21300.62 | 21272.96 | 21293.32 | 3373.0 |
| 2024-10-13 23:00:00 | NQ | Futures | 21293.58 | 21309.23 | 21280.27 | 21298.79 | 2363.0 |
| 2024-10-13 18:00:00 | YM | Futures | 44866.8 | 44903.3 | 44847.1 | 44897.0 | 830.0 |
| 2024-10-13 19:00:00 | YM | Futures | 44894.9 | 44908.5 | 44871.0 | 44880.4 | 600.0 |
| 2024-10-13 20:00:00 | YM | Futures | 44879.3 | 44899.1 | 44873.1 | 44890.8 | 643.0 |
| 2024-10-13 21:00:00 | YM | Futures | 44887.6 | 44905.3 | 44875.2 | 44886.6 | 768.0 |
| 2024-10-13 22:00:00 | YM | Futures | 44883.5 | 44902.2 | 44863.7 | 44901.2 | 608.0 |
| 2024-10-13 23:00:00 | YM | Futures | 44902.2 | 44911.6 | 44889.7 | 44902.2 | 326.0 |
| 2024-10-13 18:00:00 | CL | Futures | 67.31 | 67.34 | 66.64 | 66.68 | 5611.0 |
| 2024-10-13 19:00:00 | CL | Futures | 66.68 | 66.76 | 66.45 | 66.56 | 2614.0 |
| 2024-10-13 20:00:00 | CL | Futures | 66.57 | 66.85 | 66.44 | 66.85 | 2624.0 |
| 2024-10-13 21:00:00 | CL | Futures | 66.85 | 66.94 | 66.53 | 66.77 | 7003.0 |
| 2024-10-13 22:00:00 | CL | Futures | 66.77 | 66.96 | 66.55 | 66.93 | 3719.0 |
| 2024-10-13 23:00:00 | CL | Futures | 66.94 | 67.12 | 66.89 | 66.97 | 2247.0 |
| 2024-10-13 18:00:00 | GC | Futures | 2814.7 | 2815.4 | 2801.8 | 2808.4 | 4841.0 |
| 2024-10-13 19:00:00 | GC | Futures | 2808.4 | 2808.7 | 2805.4 | 2805.8 | 1647.0 |
| 2024-10-13 20:00:00 | GC | Futures | 2805.9 | 2806.7 | 2802.8 | 2805.0 | 2890.0 |
| 2024-10-13 21:00:00 | GC | Futures | 2804.9 | 2806.8 | 2801.5 | 2804.2 | 4653.0 |
| 2024-10-13 22:00:00 | GC | Futures | 2803.9 | 2814.6 | 2800.9 | 2813.6 | 6061.0 |
| 2024-10-13 23:00:00 | GC | Futures | 2813.8 | 2816.1 | 2812.3 | 2814.1 | 2929.0 |
| 2024-10-13 18:00:00 | ZN | Futures | 112.282665 | 112.282665 | 112.188757 | 112.22006 | 13364.0 |
| 2024-10-13 19:00:00 | ZN | Futures | 112.235711 | 112.251362 | 112.22006 | 112.235711 | 2997.0 |
| 2024-10-13 20:00:00 | ZN | Futures | 112.235711 | 112.267014 | 112.204408 | 112.267014 | 5624.0 |
| 2024-10-13 21:00:00 | ZN | Futures | 112.267014 | 112.282665 | 112.251362 | 112.251362 | 5387.0 |
| 2024-10-13 22:00:00 | ZN | Futures | 112.267014 | 112.282665 | 112.235711 | 112.251362 | 5807.0 |
| 2024-10-13 23:00:00 | ZN | Futures | 112.235711 | 112.251362 | 112.204408 | 112.22006 | 6369.0 |
> showing 36 of 433 rows — these rows as CSV