PREVIEW / futures_30min / 2024-08-22
file: by_date/futures_30min/2024/2024-08-22.parquet size: 111 KB rows: 3,903
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-22 00:00:00 | ES | Futures | 5907.86 | 5909.7 | 5906.82 | 5907.6 | 1249.0 |
| 2024-08-22 00:30:00 | ES | Futures | 5907.6 | 5910.75 | 5907.6 | 5910.75 | 1322.0 |
| 2024-08-22 01:00:00 | ES | Futures | 5910.49 | 5912.32 | 5910.22 | 5911.8 | 1003.0 |
| 2024-08-22 01:30:00 | ES | Futures | 5911.8 | 5912.85 | 5911.27 | 5911.8 | 1399.0 |
| 2024-08-22 02:00:00 | ES | Futures | 5911.8 | 5915.73 | 5910.75 | 5915.21 | 2023.0 |
| 2024-08-22 02:30:00 | ES | Futures | 5915.21 | 5917.04 | 5913.89 | 5916.52 | 1747.0 |
| 2024-08-22 03:00:00 | ES | Futures | 5916.52 | 5920.19 | 5916.25 | 5918.61 | 4253.0 |
| 2024-08-22 03:30:00 | ES | Futures | 5918.35 | 5919.14 | 5914.68 | 5918.61 | 3028.0 |
| 2024-08-22 04:00:00 | ES | Futures | 5918.35 | 5920.19 | 5915.73 | 5918.88 | 3492.0 |
| 2024-08-22 04:30:00 | ES | Futures | 5918.88 | 5921.76 | 5918.88 | 5920.19 | 2161.0 |
| 2024-08-22 05:00:00 | ES | Futures | 5920.19 | 5924.12 | 5919.92 | 5921.76 | 2521.0 |
| 2024-08-22 05:30:00 | ES | Futures | 5921.76 | 5922.02 | 5918.35 | 5918.88 | 2072.0 |
| 2024-08-22 06:00:00 | ES | Futures | 5918.88 | 5923.59 | 5918.09 | 5921.23 | 2548.0 |
| 2024-08-22 06:30:00 | ES | Futures | 5921.5 | 5925.17 | 5921.23 | 5924.91 | 2926.0 |
| 2024-08-22 07:00:00 | ES | Futures | 5924.64 | 5930.15 | 5924.12 | 5928.31 | 5430.0 |
| 2024-08-22 07:30:00 | ES | Futures | 5928.58 | 5929.62 | 5924.64 | 5928.84 | 6108.0 |
| 2024-08-22 08:00:00 | ES | Futures | 5928.58 | 5931.46 | 5924.38 | 5925.95 | 9341.0 |
| 2024-08-22 08:30:00 | ES | Futures | 5925.95 | 5931.46 | 5920.19 | 5930.41 | 13487.0 |
| 2024-08-22 09:00:00 | ES | Futures | 5930.41 | 5934.08 | 5929.36 | 5934.08 | 13539.0 |
| 2024-08-22 09:30:00 | ES | Futures | 5934.08 | 5940.9 | 5923.59 | 5931.2 | 114171.0 |
| 2024-08-22 10:00:00 | ES | Futures | 5931.72 | 5933.03 | 5912.06 | 5918.35 | 105809.0 |
| 2024-08-22 10:30:00 | ES | Futures | 5918.35 | 5918.61 | 5908.39 | 5912.32 | 67938.0 |
| 2024-08-22 11:00:00 | ES | Futures | 5912.32 | 5919.92 | 5896.59 | 5897.9 | 71643.0 |
| 2024-08-22 11:30:00 | ES | Futures | 5897.9 | 5900.0 | 5875.88 | 5882.96 | 121246.0 |
| 2024-08-22 12:00:00 | ES | Futures | 5882.96 | 5906.29 | 5882.7 | 5903.41 | 70206.0 |
| 2024-08-22 12:30:00 | ES | Futures | 5903.67 | 5907.6 | 5877.98 | 5881.65 | 87394.0 |
| 2024-08-22 13:00:00 | ES | Futures | 5881.65 | 5890.3 | 5873.52 | 5880.34 | 67159.0 |
| 2024-08-22 13:30:00 | ES | Futures | 5880.08 | 5881.91 | 5856.48 | 5859.89 | 93757.0 |
| 2024-08-22 14:00:00 | ES | Futures | 5859.63 | 5876.67 | 5856.74 | 5875.62 | 64293.0 |
| 2024-08-22 14:30:00 | ES | Futures | 5875.88 | 5878.5 | 5863.3 | 5864.61 | 56019.0 |
| 2024-08-22 15:00:00 | ES | Futures | 5864.87 | 5877.45 | 5859.89 | 5862.77 | 70136.0 |
| 2024-08-22 15:30:00 | ES | Futures | 5862.77 | 5870.11 | 5854.38 | 5867.49 | 177420.0 |
| 2024-08-22 16:00:00 | ES | Futures | 5867.49 | 5872.21 | 5862.25 | 5870.38 | 55791.0 |
| 2024-08-22 16:30:00 | ES | Futures | 5870.64 | 5874.83 | 5869.85 | 5870.9 | 5795.0 |
| 2024-08-22 18:00:00 | ES | Futures | 5870.11 | 5874.57 | 5870.11 | 5874.31 | 2015.0 |
| 2024-08-22 18:30:00 | ES | Futures | 5874.05 | 5876.93 | 5874.05 | 5876.14 | 1424.0 |
| 2024-08-22 19:00:00 | ES | Futures | 5876.14 | 5877.45 | 5874.57 | 5875.36 | 1427.0 |
| 2024-08-22 19:30:00 | ES | Futures | 5875.09 | 5877.45 | 5874.05 | 5877.19 | 1177.0 |
| 2024-08-22 20:00:00 | ES | Futures | 5877.45 | 5879.81 | 5876.67 | 5879.55 | 2583.0 |
| 2024-08-22 20:30:00 | ES | Futures | 5879.29 | 5880.08 | 5875.36 | 5876.4 | 3028.0 |
| 2024-08-22 21:00:00 | ES | Futures | 5876.4 | 5880.34 | 5875.62 | 5879.81 | 2733.0 |
| 2024-08-22 21:30:00 | ES | Futures | 5879.81 | 5879.81 | 5876.4 | 5877.72 | 1513.0 |
| 2024-08-22 22:00:00 | ES | Futures | 5877.98 | 5880.34 | 5876.67 | 5879.29 | 1752.0 |
| 2024-08-22 22:30:00 | ES | Futures | 5879.55 | 5881.39 | 5878.24 | 5880.6 | 1595.0 |
| 2024-08-22 23:00:00 | ES | Futures | 5880.86 | 5881.91 | 5880.34 | 5881.12 | 1089.0 |
| 2024-08-22 23:30:00 | ES | Futures | 5881.39 | 5885.58 | 5880.86 | 5883.22 | 2340.0 |
| 2024-08-22 00:00:00 | NQ | Futures | 20994.53 | 21006.14 | 20988.19 | 20992.68 | 981.0 |
| 2024-08-22 00:30:00 | NQ | Futures | 20994.26 | 21015.38 | 20993.74 | 21013.27 | 1077.0 |
| 2024-08-22 01:00:00 | NQ | Futures | 21013.8 | 21021.45 | 21008.52 | 21018.02 | 901.0 |
| 2024-08-22 01:30:00 | NQ | Futures | 21017.23 | 21019.61 | 21005.09 | 21005.62 | 1168.0 |
> showing 50 of 3,903 rows — these rows as CSV