PREVIEW / futures_30min / 2024-07-19
file: by_date/futures_30min/2024/2024-07-19.parquet size: 91 KB rows: 3,124
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-07-19 00:00:00 | ES | Futures | 5875.88 | 5876.14 | 5874.05 | 5875.09 | 1515.0 |
| 2024-07-19 00:30:00 | ES | Futures | 5875.09 | 5876.67 | 5874.83 | 5876.4 | 1070.0 |
| 2024-07-19 01:00:00 | ES | Futures | 5876.4 | 5877.98 | 5874.57 | 5876.14 | 1840.0 |
| 2024-07-19 01:30:00 | ES | Futures | 5876.14 | 5878.5 | 5875.88 | 5878.5 | 1114.0 |
| 2024-07-19 02:00:00 | ES | Futures | 5878.5 | 5880.34 | 5877.72 | 5879.55 | 2761.0 |
| 2024-07-19 02:30:00 | ES | Futures | 5879.55 | 5880.08 | 5863.56 | 5865.92 | 9499.0 |
| 2024-07-19 03:00:00 | ES | Futures | 5866.18 | 5867.49 | 5848.88 | 5854.65 | 20090.0 |
| 2024-07-19 03:30:00 | ES | Futures | 5854.38 | 5858.32 | 5839.44 | 5850.45 | 19894.0 |
| 2024-07-19 04:00:00 | ES | Futures | 5850.45 | 5857.53 | 5845.21 | 5856.22 | 15246.0 |
| 2024-07-19 04:30:00 | ES | Futures | 5856.22 | 5861.72 | 5852.81 | 5856.74 | 9812.0 |
| 2024-07-19 05:00:00 | ES | Futures | 5856.74 | 5862.25 | 5849.14 | 5849.14 | 10743.0 |
| 2024-07-19 05:30:00 | ES | Futures | 5849.14 | 5860.94 | 5849.14 | 5858.84 | 17245.0 |
| 2024-07-19 06:00:00 | ES | Futures | 5858.84 | 5870.64 | 5858.05 | 5869.59 | 11321.0 |
| 2024-07-19 06:30:00 | ES | Futures | 5869.33 | 5869.85 | 5861.2 | 5862.25 | 11359.0 |
| 2024-07-19 07:00:00 | ES | Futures | 5862.25 | 5874.05 | 5861.46 | 5871.95 | 11170.0 |
| 2024-07-19 07:30:00 | ES | Futures | 5871.95 | 5873.26 | 5869.33 | 5871.69 | 7807.0 |
| 2024-07-19 08:00:00 | ES | Futures | 5871.69 | 5875.09 | 5864.87 | 5865.66 | 17012.0 |
| 2024-07-19 08:30:00 | ES | Futures | 5865.39 | 5876.14 | 5864.87 | 5875.36 | 18913.0 |
| 2024-07-19 09:00:00 | ES | Futures | 5875.36 | 5876.14 | 5853.86 | 5859.1 | 59696.0 |
| 2024-07-19 09:30:00 | ES | Futures | 5859.1 | 5877.45 | 5853.07 | 5865.39 | 199832.0 |
| 2024-07-19 10:00:00 | ES | Futures | 5865.39 | 5869.06 | 5844.42 | 5845.73 | 143745.0 |
| 2024-07-19 10:30:00 | ES | Futures | 5845.73 | 5852.81 | 5841.01 | 5846.26 | 139106.0 |
| 2024-07-19 11:00:00 | ES | Futures | 5846.52 | 5855.43 | 5829.74 | 5830.26 | 142857.0 |
| 2024-07-19 11:30:00 | ES | Futures | 5830.53 | 5845.47 | 5825.55 | 5845.47 | 131411.0 |
| 2024-07-19 12:00:00 | ES | Futures | 5845.21 | 5849.93 | 5833.93 | 5834.72 | 107356.0 |
| 2024-07-19 12:30:00 | ES | Futures | 5834.98 | 5836.29 | 5822.66 | 5827.12 | 111766.0 |
| 2024-07-19 13:00:00 | ES | Futures | 5827.38 | 5827.64 | 5811.65 | 5819.25 | 107490.0 |
| 2024-07-19 13:30:00 | ES | Futures | 5818.99 | 5828.43 | 5813.75 | 5827.64 | 93422.0 |
| 2024-07-19 14:00:00 | ES | Futures | 5827.64 | 5831.05 | 5819.52 | 5820.3 | 73184.0 |
| 2024-07-19 14:30:00 | ES | Futures | 5820.3 | 5826.07 | 5813.22 | 5825.02 | 82265.0 |
| 2024-07-19 15:00:00 | ES | Futures | 5825.02 | 5839.44 | 5824.23 | 5834.72 | 110613.0 |
| 2024-07-19 15:30:00 | ES | Futures | 5834.46 | 5835.51 | 5815.32 | 5823.97 | 213373.0 |
| 2024-07-19 16:00:00 | ES | Futures | 5824.23 | 5830.79 | 5817.16 | 5821.09 | 64505.0 |
| 2024-07-19 16:30:00 | ES | Futures | 5821.09 | 5824.23 | 5820.04 | 5822.92 | 15183.0 |
| 2024-07-19 00:00:00 | NQ | Futures | 21072.14 | 21072.4 | 21065.01 | 21069.76 | 625.0 |
| 2024-07-19 00:30:00 | NQ | Futures | 21069.76 | 21076.36 | 21067.39 | 21073.46 | 658.0 |
| 2024-07-19 01:00:00 | NQ | Futures | 21073.72 | 21077.68 | 21063.69 | 21068.97 | 901.0 |
| 2024-07-19 01:30:00 | NQ | Futures | 21069.24 | 21079.79 | 21067.12 | 21079.27 | 751.0 |
| 2024-07-19 02:00:00 | NQ | Futures | 21079.27 | 21097.22 | 21077.42 | 21087.71 | 2080.0 |
| 2024-07-19 02:30:00 | NQ | Futures | 21087.45 | 21087.98 | 21010.9 | 21020.93 | 5659.0 |
| 2024-07-19 03:00:00 | NQ | Futures | 21021.45 | 21021.72 | 20927.21 | 20937.77 | 11256.0 |
| 2024-07-19 03:30:00 | NQ | Futures | 20937.24 | 20950.71 | 20858.31 | 20903.98 | 13554.0 |
| 2024-07-19 04:00:00 | NQ | Futures | 20903.98 | 20953.35 | 20891.58 | 20947.01 | 9269.0 |
| 2024-07-19 04:30:00 | NQ | Futures | 20947.01 | 20975.26 | 20935.66 | 20949.65 | 5847.0 |
| 2024-07-19 05:00:00 | NQ | Futures | 20950.18 | 20977.11 | 20915.33 | 20915.86 | 5708.0 |
| 2024-07-19 05:30:00 | NQ | Futures | 20915.86 | 20970.77 | 20915.33 | 20961.0 | 7825.0 |
| 2024-07-19 06:00:00 | NQ | Futures | 20959.95 | 21020.93 | 20957.57 | 21014.86 | 5909.0 |
| 2024-07-19 06:30:00 | NQ | Futures | 21014.33 | 21016.7 | 20975.79 | 20980.8 | 6704.0 |
| 2024-07-19 07:00:00 | NQ | Futures | 20980.8 | 21054.45 | 20974.47 | 21043.37 | 9734.0 |
| 2024-07-19 07:30:00 | NQ | Futures | 21044.16 | 21052.34 | 21028.32 | 21037.56 | 5426.0 |
> showing 50 of 3,124 rows — these rows as CSV