PREVIEW / futures_1hour / 2025-08-06
file: by_date/futures_1hour/2025/2025-08-06.parquet size: 65 KB rows: 2,054
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 |
|---|---|---|---|---|---|---|---|
| 2025-08-06 00:00:00 | ES | Futures | 6387.79 | 6390.06 | 6387.29 | 6388.8 | 2820.0 |
| 2025-08-06 01:00:00 | ES | Futures | 6388.8 | 6398.37 | 6387.54 | 6395.1 | 6020.0 |
| 2025-08-06 02:00:00 | ES | Futures | 6395.1 | 6401.14 | 6393.34 | 6396.86 | 7360.0 |
| 2025-08-06 03:00:00 | ES | Futures | 6396.86 | 6405.93 | 6396.86 | 6405.17 | 10813.0 |
| 2025-08-06 04:00:00 | ES | Futures | 6405.17 | 6405.68 | 6391.32 | 6393.34 | 10234.0 |
| 2025-08-06 05:00:00 | ES | Futures | 6393.08 | 6396.11 | 6385.02 | 6387.79 | 7747.0 |
| 2025-08-06 06:00:00 | ES | Futures | 6387.79 | 6391.07 | 6379.23 | 6386.79 | 12167.0 |
| 2025-08-06 07:00:00 | ES | Futures | 6386.79 | 6391.32 | 6384.77 | 6386.28 | 11517.0 |
| 2025-08-06 08:00:00 | ES | Futures | 6386.03 | 6388.05 | 6378.22 | 6386.79 | 19130.0 |
| 2025-08-06 09:00:00 | ES | Futures | 6386.79 | 6392.33 | 6374.7 | 6380.99 | 180352.0 |
| 2025-08-06 10:00:00 | ES | Futures | 6380.74 | 6402.65 | 6373.19 | 6401.4 | 223582.0 |
| 2025-08-06 11:00:00 | ES | Futures | 6401.4 | 6422.05 | 6396.36 | 6419.53 | 173560.0 |
| 2025-08-06 12:00:00 | ES | Futures | 6419.53 | 6422.8 | 6410.97 | 6415.25 | 98101.0 |
| 2025-08-06 13:00:00 | ES | Futures | 6415.25 | 6419.78 | 6411.97 | 6415.0 | 69340.0 |
| 2025-08-06 14:00:00 | ES | Futures | 6415.0 | 6424.82 | 6414.49 | 6418.77 | 77406.0 |
| 2025-08-06 15:00:00 | ES | Futures | 6419.03 | 6427.34 | 6416.51 | 6419.53 | 170876.0 |
| 2025-08-06 16:00:00 | ES | Futures | 6419.53 | 6420.29 | 6415.5 | 6418.52 | 42452.0 |
| 2025-08-06 18:00:00 | ES | Futures | 6418.77 | 6435.4 | 6411.97 | 6430.86 | 16014.0 |
| 2025-08-06 19:00:00 | ES | Futures | 6430.61 | 6435.4 | 6425.58 | 6428.35 | 5776.0 |
| 2025-08-06 20:00:00 | ES | Futures | 6428.09 | 6436.41 | 6426.08 | 6433.64 | 6399.0 |
| 2025-08-06 21:00:00 | ES | Futures | 6433.38 | 6439.43 | 6433.13 | 6436.66 | 5101.0 |
| 2025-08-06 22:00:00 | ES | Futures | 6436.41 | 6439.18 | 6432.63 | 6434.39 | 3712.0 |
| 2025-08-06 23:00:00 | ES | Futures | 6434.39 | 6437.67 | 6433.64 | 6435.65 | 3218.0 |
| 2025-08-06 00:00:00 | NQ | Futures | 23368.27 | 23375.33 | 23359.19 | 23364.49 | 2149.0 |
| 2025-08-06 01:00:00 | NQ | Futures | 23363.98 | 23403.83 | 23356.42 | 23386.68 | 3964.0 |
| 2025-08-06 02:00:00 | NQ | Futures | 23386.43 | 23409.12 | 23382.39 | 23394.25 | 4089.0 |
| 2025-08-06 03:00:00 | NQ | Futures | 23394.25 | 23426.27 | 23392.99 | 23422.24 | 6693.0 |
| 2025-08-06 04:00:00 | NQ | Futures | 23423.25 | 23429.3 | 23357.68 | 23368.02 | 7397.0 |
| 2025-08-06 05:00:00 | NQ | Futures | 23369.03 | 23382.14 | 23333.22 | 23347.59 | 6672.0 |
| 2025-08-06 06:00:00 | NQ | Futures | 23348.85 | 23358.44 | 23308.51 | 23345.58 | 9447.0 |
| 2025-08-06 07:00:00 | NQ | Futures | 23345.83 | 23398.79 | 23339.02 | 23377.85 | 9202.0 |
| 2025-08-06 08:00:00 | NQ | Futures | 23377.6 | 23388.45 | 23341.79 | 23380.88 | 11049.0 |
| 2025-08-06 09:00:00 | NQ | Futures | 23380.12 | 23446.95 | 23350.12 | 23403.32 | 78716.0 |
| 2025-08-06 10:00:00 | NQ | Futures | 23403.58 | 23489.82 | 23366.0 | 23485.03 | 91575.0 |
| 2025-08-06 11:00:00 | NQ | Futures | 23485.28 | 23579.09 | 23460.57 | 23571.53 | 76759.0 |
| 2025-08-06 12:00:00 | NQ | Futures | 23571.27 | 23593.21 | 23549.08 | 23574.55 | 43340.0 |
| 2025-08-06 13:00:00 | NQ | Futures | 23574.3 | 23600.28 | 23561.94 | 23576.57 | 28233.0 |
| 2025-08-06 14:00:00 | NQ | Futures | 23576.57 | 23639.36 | 23574.05 | 23619.94 | 37337.0 |
| 2025-08-06 15:00:00 | NQ | Futures | 23619.44 | 23649.45 | 23611.12 | 23628.77 | 50486.0 |
| 2025-08-06 16:00:00 | NQ | Futures | 23628.52 | 23629.78 | 23601.79 | 23617.17 | 17962.0 |
| 2025-08-06 18:00:00 | NQ | Futures | 23622.47 | 23685.51 | 23588.17 | 23665.34 | 11028.0 |
| 2025-08-06 19:00:00 | NQ | Futures | 23665.34 | 23681.48 | 23648.44 | 23656.26 | 5194.0 |
| 2025-08-06 20:00:00 | NQ | Futures | 23656.01 | 23706.69 | 23648.44 | 23692.57 | 6661.0 |
| 2025-08-06 21:00:00 | NQ | Futures | 23692.57 | 23716.02 | 23682.48 | 23701.15 | 4758.0 |
| 2025-08-06 22:00:00 | NQ | Futures | 23700.39 | 23710.22 | 23689.8 | 23692.57 | 3663.0 |
| 2025-08-06 23:00:00 | NQ | Futures | 23692.82 | 23703.67 | 23687.78 | 23694.59 | 1971.0 |
| 2025-08-06 00:00:00 | YM | Futures | 45308.8 | 45324.1 | 45304.7 | 45320.0 | 213.0 |
| 2025-08-06 01:00:00 | YM | Futures | 45323.1 | 45386.4 | 45316.9 | 45364.9 | 685.0 |
| 2025-08-06 02:00:00 | YM | Futures | 45364.9 | 45408.9 | 45350.6 | 45375.2 | 1200.0 |
| 2025-08-06 03:00:00 | YM | Futures | 45376.2 | 45441.6 | 45376.2 | 45435.4 | 1388.0 |
> showing 50 of 2,054 rows — these rows as CSV