PREVIEW / futures_1hour / 2024-11-03
file: by_date/futures_1hour/2024/2024-11-03.parquet size: 20 KB rows: 457
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-11-03 18:00:00 | ES | Futures | 5960.47 | 5975.01 | 5958.66 | 5968.78 | 21652.0 |
| 2024-11-03 19:00:00 | ES | Futures | 5969.04 | 5969.56 | 5962.55 | 5968.26 | 8576.0 |
| 2024-11-03 20:00:00 | ES | Futures | 5968.52 | 5980.98 | 5966.96 | 5978.64 | 8796.0 |
| 2024-11-03 21:00:00 | ES | Futures | 5978.9 | 5991.36 | 5978.12 | 5985.65 | 11527.0 |
| 2024-11-03 22:00:00 | ES | Futures | 5985.39 | 5991.1 | 5984.87 | 5989.02 | 5063.0 |
| 2024-11-03 23:00:00 | ES | Futures | 5988.76 | 5994.73 | 5988.24 | 5992.91 | 5140.0 |
| 2024-11-03 18:00:00 | NQ | Futures | 21017.01 | 21037.88 | 20946.56 | 21013.88 | 15990.0 |
| 2024-11-03 19:00:00 | NQ | Futures | 21013.88 | 21025.1 | 20996.92 | 21008.66 | 5328.0 |
| 2024-11-03 20:00:00 | NQ | Futures | 21008.66 | 21081.72 | 21002.66 | 21072.32 | 5595.0 |
| 2024-11-03 21:00:00 | NQ | Futures | 21072.32 | 21132.33 | 21064.76 | 21093.72 | 6055.0 |
| 2024-11-03 22:00:00 | NQ | Futures | 21093.98 | 21116.68 | 21087.98 | 21101.54 | 3746.0 |
| 2024-11-03 23:00:00 | NQ | Futures | 21101.54 | 21124.77 | 21097.89 | 21117.2 | 2548.0 |
| 2024-11-03 18:00:00 | YM | Futures | 43867.7 | 43883.3 | 43777.2 | 43799.0 | 2291.0 |
| 2024-11-03 19:00:00 | YM | Futures | 43800.1 | 43803.2 | 43756.3 | 43777.2 | 1325.0 |
| 2024-11-03 20:00:00 | YM | Futures | 43778.2 | 43834.4 | 43769.9 | 43823.0 | 1130.0 |
| 2024-11-03 21:00:00 | YM | Futures | 43825.0 | 43886.4 | 43812.5 | 43857.3 | 1233.0 |
| 2024-11-03 22:00:00 | YM | Futures | 43857.3 | 43884.4 | 43854.2 | 43879.2 | 590.0 |
| 2024-11-03 23:00:00 | YM | Futures | 43878.1 | 43927.0 | 43875.0 | 43908.3 | 761.0 |
| 2024-11-03 18:00:00 | CL | Futures | 63.61 | 64.26 | 63.58 | 63.83 | 6975.0 |
| 2024-11-03 19:00:00 | CL | Futures | 63.83 | 64.1 | 63.79 | 64.01 | 2289.0 |
| 2024-11-03 20:00:00 | CL | Futures | 64.0 | 64.06 | 63.75 | 63.79 | 2836.0 |
| 2024-11-03 21:00:00 | CL | Futures | 63.79 | 63.91 | 63.68 | 63.74 | 2155.0 |
| 2024-11-03 22:00:00 | CL | Futures | 63.74 | 63.99 | 63.7 | 63.99 | 1619.0 |
| 2024-11-03 23:00:00 | CL | Futures | 63.98 | 64.04 | 63.94 | 63.95 | 883.0 |
| 2024-11-03 18:00:00 | GC | Futures | 2888.8 | 2895.1 | 2884.5 | 2892.9 | 5097.0 |
| 2024-11-03 19:00:00 | GC | Futures | 2893.1 | 2896.2 | 2891.3 | 2895.2 | 2514.0 |
| 2024-11-03 20:00:00 | GC | Futures | 2895.4 | 2896.5 | 2889.9 | 2894.8 | 4440.0 |
| 2024-11-03 21:00:00 | GC | Futures | 2894.7 | 2896.0 | 2891.5 | 2894.9 | 2399.0 |
| 2024-11-03 22:00:00 | GC | Futures | 2895.1 | 2897.7 | 2894.3 | 2896.0 | 1942.0 |
| 2024-11-03 23:00:00 | GC | Futures | 2896.0 | 2897.1 | 2894.5 | 2896.0 | 1167.0 |
| 2024-11-03 18:00:00 | ZN | Futures | 110.482762 | 110.70188 | 110.46711 | 110.529716 | 98787.0 |
| 2024-11-03 19:00:00 | ZN | Futures | 110.529716 | 110.592321 | 110.514064 | 110.514064 | 20833.0 |
| 2024-11-03 20:00:00 | ZN | Futures | 110.514064 | 110.561018 | 110.46711 | 110.545367 | 21129.0 |
| 2024-11-03 21:00:00 | ZN | Futures | 110.561018 | 110.607972 | 110.514064 | 110.592321 | 13120.0 |
| 2024-11-03 22:00:00 | ZN | Futures | 110.57667 | 110.623624 | 110.57667 | 110.592321 | 15170.0 |
| 2024-11-03 23:00:00 | ZN | Futures | 110.592321 | 110.607972 | 110.561018 | 110.57667 | 5877.0 |
> showing 36 of 457 rows — these rows as CSV