PREVIEW / futures_1hour / 2024-08-27
file: by_date/futures_1hour/2024/2024-08-27.parquet size: 65 KB rows: 2,059
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-08-27 00:00:00 | ES | Futures | 5908.65 | 5910.75 | 5906.29 | 5910.22 | 1956.0 |
| 2024-08-27 01:00:00 | ES | Futures | 5910.22 | 5913.11 | 5909.96 | 5912.58 | 2759.0 |
| 2024-08-27 02:00:00 | ES | Futures | 5912.32 | 5913.37 | 5909.18 | 5911.8 | 3190.0 |
| 2024-08-27 03:00:00 | ES | Futures | 5911.8 | 5914.42 | 5907.6 | 5914.16 | 7849.0 |
| 2024-08-27 04:00:00 | ES | Futures | 5914.16 | 5920.45 | 5913.63 | 5915.73 | 9812.0 |
| 2024-08-27 05:00:00 | ES | Futures | 5915.73 | 5920.19 | 5914.68 | 5915.73 | 4568.0 |
| 2024-08-27 06:00:00 | ES | Futures | 5915.47 | 5916.52 | 5901.57 | 5903.67 | 9417.0 |
| 2024-08-27 07:00:00 | ES | Futures | 5903.67 | 5914.68 | 5900.26 | 5909.7 | 13291.0 |
| 2024-08-27 08:00:00 | ES | Futures | 5909.96 | 5909.96 | 5890.04 | 5894.23 | 29830.0 |
| 2024-08-27 09:00:00 | ES | Futures | 5894.23 | 5905.24 | 5884.53 | 5900.79 | 151842.0 |
| 2024-08-27 10:00:00 | ES | Futures | 5900.52 | 5920.71 | 5897.9 | 5919.66 | 175812.0 |
| 2024-08-27 11:00:00 | ES | Futures | 5919.4 | 5924.38 | 5900.52 | 5909.7 | 153259.0 |
| 2024-08-27 12:00:00 | ES | Futures | 5909.44 | 5914.94 | 5900.79 | 5911.01 | 77711.0 |
| 2024-08-27 13:00:00 | ES | Futures | 5910.75 | 5923.86 | 5910.75 | 5922.81 | 78298.0 |
| 2024-08-27 14:00:00 | ES | Futures | 5922.81 | 5924.12 | 5916.52 | 5919.14 | 60805.0 |
| 2024-08-27 15:00:00 | ES | Futures | 5919.14 | 5922.02 | 5914.42 | 5918.35 | 127335.0 |
| 2024-08-27 16:00:00 | ES | Futures | 5918.35 | 5921.76 | 5915.73 | 5917.56 | 33269.0 |
| 2024-08-27 18:00:00 | ES | Futures | 5918.35 | 5919.92 | 5907.08 | 5910.22 | 7977.0 |
| 2024-08-27 19:00:00 | ES | Futures | 5910.22 | 5913.63 | 5904.46 | 5909.96 | 4578.0 |
| 2024-08-27 20:00:00 | ES | Futures | 5909.96 | 5913.11 | 5908.39 | 5912.58 | 3414.0 |
| 2024-08-27 21:00:00 | ES | Futures | 5912.85 | 5914.68 | 5909.18 | 5913.89 | 3807.0 |
| 2024-08-27 22:00:00 | ES | Futures | 5913.63 | 5918.09 | 5912.06 | 5916.78 | 3138.0 |
| 2024-08-27 23:00:00 | ES | Futures | 5916.52 | 5917.56 | 5915.47 | 5916.78 | 1743.0 |
| 2024-08-27 00:00:00 | NQ | Futures | 20692.27 | 20705.2 | 20678.54 | 20700.98 | 1662.0 |
| 2024-08-27 01:00:00 | NQ | Futures | 20701.77 | 20719.46 | 20700.98 | 20715.5 | 1982.0 |
| 2024-08-27 02:00:00 | NQ | Futures | 20714.71 | 20715.5 | 20692.0 | 20704.41 | 2753.0 |
| 2024-08-27 03:00:00 | NQ | Futures | 20704.94 | 20716.55 | 20679.6 | 20712.33 | 4120.0 |
| 2024-08-27 04:00:00 | NQ | Futures | 20712.6 | 20745.33 | 20707.58 | 20716.29 | 6256.0 |
| 2024-08-27 05:00:00 | NQ | Futures | 20715.5 | 20745.86 | 20713.65 | 20730.02 | 3665.0 |
| 2024-08-27 06:00:00 | NQ | Futures | 20729.75 | 20734.51 | 20651.88 | 20671.68 | 7586.0 |
| 2024-08-27 07:00:00 | NQ | Futures | 20671.41 | 20711.54 | 20647.66 | 20691.48 | 7230.0 |
| 2024-08-27 08:00:00 | NQ | Futures | 20692.53 | 20692.53 | 20593.27 | 20604.63 | 13912.0 |
| 2024-08-27 09:00:00 | NQ | Futures | 20604.36 | 20665.34 | 20528.86 | 20633.4 | 74886.0 |
| 2024-08-27 10:00:00 | NQ | Futures | 20635.78 | 20773.84 | 20622.84 | 20769.35 | 76782.0 |
| 2024-08-27 11:00:00 | NQ | Futures | 20769.62 | 20795.75 | 20672.73 | 20707.58 | 58835.0 |
| 2024-08-27 12:00:00 | NQ | Futures | 20707.05 | 20746.91 | 20678.54 | 20722.89 | 39937.0 |
| 2024-08-27 13:00:00 | NQ | Futures | 20722.63 | 20791.79 | 20715.23 | 20787.3 | 37389.0 |
| 2024-08-27 14:00:00 | NQ | Futures | 20787.57 | 20794.17 | 20737.94 | 20754.83 | 28237.0 |
| 2024-08-27 15:00:00 | NQ | Futures | 20755.36 | 20768.82 | 20728.96 | 20750.34 | 40401.0 |
| 2024-08-27 16:00:00 | NQ | Futures | 20750.61 | 20761.17 | 20723.42 | 20734.24 | 9354.0 |
| 2024-08-27 18:00:00 | NQ | Futures | 20733.71 | 20743.74 | 20670.36 | 20692.0 | 5876.0 |
| 2024-08-27 19:00:00 | NQ | Futures | 20690.16 | 20704.15 | 20654.78 | 20682.5 | 3626.0 |
| 2024-08-27 20:00:00 | NQ | Futures | 20683.29 | 20701.24 | 20674.05 | 20698.87 | 3312.0 |
| 2024-08-27 21:00:00 | NQ | Futures | 20699.66 | 20708.64 | 20678.81 | 20705.47 | 3147.0 |
| 2024-08-27 22:00:00 | NQ | Futures | 20705.2 | 20727.64 | 20694.38 | 20719.99 | 2966.0 |
| 2024-08-27 23:00:00 | NQ | Futures | 20718.93 | 20723.15 | 20707.05 | 20716.03 | 1443.0 |
| 2024-08-27 00:00:00 | YM | Futures | 43411.9 | 43418.2 | 43399.3 | 43412.9 | 343.0 |
| 2024-08-27 01:00:00 | YM | Futures | 43416.1 | 43429.7 | 43412.9 | 43427.6 | 354.0 |
| 2024-08-27 02:00:00 | YM | Futures | 43425.5 | 43440.2 | 43412.9 | 43436.0 | 547.0 |
| 2024-08-27 03:00:00 | YM | Futures | 43433.9 | 43456.0 | 43420.3 | 43449.7 | 1119.0 |
> showing 50 of 2,059 rows — these rows as CSV