PREVIEW / futures_1hour / 2024-05-19
file: by_date/futures_1hour/2024/2024-05-19.parquet size: 19 KB rows: 414
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-05-19 18:00:00 | ES | Futures | 5655.31 | 5660.61 | 5655.04 | 5658.76 | 6251.0 |
| 2024-05-19 19:00:00 | ES | Futures | 5658.76 | 5663.0 | 5658.76 | 5661.68 | 3896.0 |
| 2024-05-19 20:00:00 | ES | Futures | 5661.94 | 5662.74 | 5658.49 | 5661.41 | 5840.0 |
| 2024-05-19 21:00:00 | ES | Futures | 5661.15 | 5661.94 | 5659.82 | 5660.35 | 4041.0 |
| 2024-05-19 22:00:00 | ES | Futures | 5660.61 | 5662.47 | 5658.76 | 5661.94 | 4212.0 |
| 2024-05-19 23:00:00 | ES | Futures | 5662.21 | 5662.74 | 5660.35 | 5660.61 | 3148.0 |
| 2024-05-19 18:00:00 | NQ | Futures | 19938.15 | 19964.63 | 19937.61 | 19960.08 | 2995.0 |
| 2024-05-19 19:00:00 | NQ | Futures | 19960.35 | 19978.54 | 19959.01 | 19973.72 | 2178.0 |
| 2024-05-19 20:00:00 | NQ | Futures | 19974.79 | 19980.14 | 19964.9 | 19973.46 | 2897.0 |
| 2024-05-19 21:00:00 | NQ | Futures | 19972.65 | 19978.54 | 19966.77 | 19972.65 | 2682.0 |
| 2024-05-19 22:00:00 | NQ | Futures | 19971.58 | 19984.16 | 19965.43 | 19981.75 | 2544.0 |
| 2024-05-19 23:00:00 | NQ | Futures | 19981.75 | 19987.1 | 19975.86 | 19976.93 | 2213.0 |
| 2024-05-19 18:00:00 | YM | Futures | 42609.3 | 42659.2 | 42609.3 | 42642.2 | 956.0 |
| 2024-05-19 19:00:00 | YM | Futures | 42641.2 | 42664.5 | 42640.1 | 42659.2 | 483.0 |
| 2024-05-19 20:00:00 | YM | Futures | 42659.2 | 42667.7 | 42636.9 | 42663.4 | 705.0 |
| 2024-05-19 21:00:00 | YM | Futures | 42661.3 | 42674.1 | 42651.8 | 42658.1 | 714.0 |
| 2024-05-19 22:00:00 | YM | Futures | 42658.1 | 42664.5 | 42648.6 | 42661.3 | 474.0 |
| 2024-05-19 23:00:00 | YM | Futures | 42660.3 | 42662.4 | 42647.5 | 42649.6 | 389.0 |
| 2024-05-19 18:00:00 | CL | Futures | 67.76 | 67.88 | 67.69 | 67.71 | 3418.0 |
| 2024-05-19 19:00:00 | CL | Futures | 67.71 | 67.74 | 67.54 | 67.57 | 1114.0 |
| 2024-05-19 20:00:00 | CL | Futures | 67.56 | 67.74 | 67.49 | 67.74 | 2071.0 |
| 2024-05-19 21:00:00 | CL | Futures | 67.74 | 67.96 | 67.59 | 67.85 | 5049.0 |
| 2024-05-19 22:00:00 | CL | Futures | 67.85 | 67.97 | 67.77 | 67.78 | 2242.0 |
| 2024-05-19 23:00:00 | CL | Futures | 67.78 | 67.85 | 67.71 | 67.83 | 1676.0 |
| 2024-05-19 18:00:00 | GC | Futures | 2628.5 | 2636.7 | 2627.4 | 2628.5 | 5425.0 |
| 2024-05-19 19:00:00 | GC | Futures | 2628.5 | 2631.8 | 2627.8 | 2631.4 | 2965.0 |
| 2024-05-19 20:00:00 | GC | Futures | 2631.5 | 2638.0 | 2627.2 | 2636.7 | 5312.0 |
| 2024-05-19 21:00:00 | GC | Futures | 2636.9 | 2653.2 | 2636.9 | 2646.5 | 18177.0 |
| 2024-05-19 22:00:00 | GC | Futures | 2646.7 | 2649.2 | 2639.9 | 2645.7 | 6214.0 |
| 2024-05-19 23:00:00 | GC | Futures | 2645.6 | 2650.8 | 2642.0 | 2649.5 | 6003.0 |
| 2024-05-19 18:00:00 | ZN | Futures | 110.025371 | 110.072612 | 110.025371 | 110.072612 | 8514.0 |
| 2024-05-19 19:00:00 | ZN | Futures | 110.056865 | 110.088359 | 110.056865 | 110.072612 | 4992.0 |
| 2024-05-19 20:00:00 | ZN | Futures | 110.056865 | 110.119854 | 110.009624 | 110.104107 | 16069.0 |
| 2024-05-19 21:00:00 | ZN | Futures | 110.119854 | 110.135601 | 110.104107 | 110.119854 | 4343.0 |
| 2024-05-19 22:00:00 | ZN | Futures | 110.104107 | 110.119854 | 110.041118 | 110.072612 | 11169.0 |
| 2024-05-19 23:00:00 | ZN | Futures | 110.072612 | 110.088359 | 110.056865 | 110.072612 | 7571.0 |
> showing 36 of 414 rows — these rows as CSV