PREVIEW / futures_30min / 2024-11-18
file: by_date/futures_30min/2024/2024-11-18.parquet size: 114 KB rows: 4,067
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-18 00:00:00 | ES | Futures | 6139.29 | 6139.8 | 6136.43 | 6137.99 | 3501.0 |
| 2024-11-18 00:30:00 | ES | Futures | 6137.99 | 6138.25 | 6135.65 | 6137.99 | 1969.0 |
| 2024-11-18 01:00:00 | ES | Futures | 6137.73 | 6139.03 | 6135.39 | 6138.25 | 2666.0 |
| 2024-11-18 01:30:00 | ES | Futures | 6138.25 | 6141.1 | 6138.25 | 6140.58 | 2654.0 |
| 2024-11-18 02:00:00 | ES | Futures | 6140.58 | 6140.84 | 6131.24 | 6131.5 | 5829.0 |
| 2024-11-18 02:30:00 | ES | Futures | 6131.5 | 6132.28 | 6124.23 | 6128.39 | 8011.0 |
| 2024-11-18 03:00:00 | ES | Futures | 6128.39 | 6133.84 | 6123.45 | 6132.54 | 14012.0 |
| 2024-11-18 03:30:00 | ES | Futures | 6132.28 | 6132.28 | 6126.83 | 6130.72 | 7226.0 |
| 2024-11-18 04:00:00 | ES | Futures | 6130.98 | 6130.98 | 6120.08 | 6123.71 | 16709.0 |
| 2024-11-18 04:30:00 | ES | Futures | 6123.71 | 6126.05 | 6119.04 | 6121.64 | 9776.0 |
| 2024-11-18 05:00:00 | ES | Futures | 6121.64 | 6124.49 | 6120.08 | 6123.45 | 7931.0 |
| 2024-11-18 05:30:00 | ES | Futures | 6123.2 | 6129.42 | 6121.64 | 6128.65 | 6141.0 |
| 2024-11-18 06:00:00 | ES | Futures | 6128.65 | 6128.9 | 6123.45 | 6124.75 | 4360.0 |
| 2024-11-18 06:30:00 | ES | Futures | 6124.75 | 6125.79 | 6119.82 | 6123.45 | 5433.0 |
| 2024-11-18 07:00:00 | ES | Futures | 6123.71 | 6127.09 | 6121.64 | 6125.27 | 6916.0 |
| 2024-11-18 07:30:00 | ES | Futures | 6125.27 | 6128.9 | 6122.68 | 6125.27 | 7469.0 |
| 2024-11-18 08:00:00 | ES | Futures | 6125.27 | 6126.83 | 6110.74 | 6114.63 | 19279.0 |
| 2024-11-18 08:30:00 | ES | Futures | 6114.37 | 6127.09 | 6113.85 | 6124.75 | 19652.0 |
| 2024-11-18 09:00:00 | ES | Futures | 6124.75 | 6130.72 | 6124.49 | 6125.01 | 21509.0 |
| 2024-11-18 09:30:00 | ES | Futures | 6125.01 | 6126.57 | 6115.67 | 6120.08 | 137103.0 |
| 2024-11-18 10:00:00 | ES | Futures | 6120.08 | 6137.21 | 6118.0 | 6136.95 | 103229.0 |
| 2024-11-18 10:30:00 | ES | Futures | 6136.69 | 6146.81 | 6135.91 | 6145.77 | 96079.0 |
| 2024-11-18 11:00:00 | ES | Futures | 6145.77 | 6155.12 | 6143.96 | 6150.19 | 63414.0 |
| 2024-11-18 11:30:00 | ES | Futures | 6150.19 | 6159.01 | 6142.4 | 6146.29 | 88915.0 |
| 2024-11-18 12:00:00 | ES | Futures | 6146.29 | 6148.63 | 6141.36 | 6146.81 | 58704.0 |
| 2024-11-18 12:30:00 | ES | Futures | 6146.81 | 6150.19 | 6140.06 | 6149.93 | 52610.0 |
| 2024-11-18 13:00:00 | ES | Futures | 6149.93 | 6150.19 | 6144.22 | 6144.22 | 38272.0 |
| 2024-11-18 13:30:00 | ES | Futures | 6144.48 | 6147.59 | 6132.54 | 6146.55 | 65221.0 |
| 2024-11-18 14:00:00 | ES | Futures | 6146.55 | 6147.33 | 6133.32 | 6135.39 | 61939.0 |
| 2024-11-18 14:30:00 | ES | Futures | 6135.65 | 6146.81 | 6133.32 | 6144.22 | 51820.0 |
| 2024-11-18 15:00:00 | ES | Futures | 6143.96 | 6147.33 | 6142.66 | 6147.07 | 41840.0 |
| 2024-11-18 15:30:00 | ES | Futures | 6147.33 | 6147.33 | 6138.25 | 6145.77 | 128127.0 |
| 2024-11-18 16:00:00 | ES | Futures | 6145.77 | 6147.33 | 6141.36 | 6142.92 | 35256.0 |
| 2024-11-18 16:30:00 | ES | Futures | 6143.18 | 6144.48 | 6142.14 | 6144.22 | 5019.0 |
| 2024-11-18 18:00:00 | ES | Futures | 6144.48 | 6145.0 | 6136.95 | 6141.36 | 4077.0 |
| 2024-11-18 18:30:00 | ES | Futures | 6141.36 | 6142.92 | 6140.06 | 6142.14 | 2148.0 |
| 2024-11-18 19:00:00 | ES | Futures | 6142.14 | 6149.15 | 6141.62 | 6146.81 | 4795.0 |
| 2024-11-18 19:30:00 | ES | Futures | 6147.07 | 6147.07 | 6140.32 | 6143.44 | 3202.0 |
| 2024-11-18 20:00:00 | ES | Futures | 6143.18 | 6143.18 | 6139.29 | 6141.36 | 2391.0 |
| 2024-11-18 20:30:00 | ES | Futures | 6141.36 | 6146.81 | 6139.55 | 6146.03 | 2818.0 |
| 2024-11-18 21:00:00 | ES | Futures | 6146.29 | 6147.33 | 6143.96 | 6146.81 | 2662.0 |
| 2024-11-18 21:30:00 | ES | Futures | 6146.81 | 6150.45 | 6146.29 | 6149.93 | 2888.0 |
| 2024-11-18 22:00:00 | ES | Futures | 6150.19 | 6156.93 | 6149.93 | 6155.38 | 4350.0 |
| 2024-11-18 22:30:00 | ES | Futures | 6155.38 | 6157.45 | 6154.6 | 6155.38 | 3178.0 |
| 2024-11-18 23:00:00 | ES | Futures | 6155.64 | 6158.75 | 6155.38 | 6158.49 | 2908.0 |
| 2024-11-18 23:30:00 | ES | Futures | 6158.49 | 6159.79 | 6155.12 | 6156.67 | 2493.0 |
| 2024-11-18 00:00:00 | NQ | Futures | 21550.05 | 21558.4 | 21537.01 | 21544.31 | 2039.0 |
| 2024-11-18 00:30:00 | NQ | Futures | 21545.1 | 21545.1 | 21531.79 | 21540.14 | 1506.0 |
| 2024-11-18 01:00:00 | NQ | Futures | 21540.14 | 21543.79 | 21526.31 | 21537.79 | 1707.0 |
| 2024-11-18 01:30:00 | NQ | Futures | 21537.79 | 21553.97 | 21535.7 | 21550.05 | 1378.0 |
> showing 50 of 4,067 rows — these rows as CSV