PREVIEW / futures_30min / 2009-12-14
file: by_date/futures_30min/2009/2009-12-14.parquet size: 64 KB rows: 2,397
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-14 00:00:00 | ES | Futures | 1079.58 | 1081.04 | 1079.34 | 1080.8 | 3879.0 |
| 2009-12-14 00:30:00 | ES | Futures | 1080.56 | 1081.29 | 1080.31 | 1080.8 | 1778.0 |
| 2009-12-14 01:00:00 | ES | Futures | 1080.8 | 1082.26 | 1080.56 | 1082.02 | 2318.0 |
| 2009-12-14 01:30:00 | ES | Futures | 1082.26 | 1082.99 | 1081.53 | 1082.26 | 3540.0 |
| 2009-12-14 02:00:00 | ES | Futures | 1082.26 | 1082.99 | 1081.29 | 1081.29 | 4548.0 |
| 2009-12-14 02:30:00 | ES | Futures | 1081.29 | 1082.5 | 1080.56 | 1080.56 | 4033.0 |
| 2009-12-14 03:00:00 | ES | Futures | 1080.8 | 1081.29 | 1078.37 | 1079.1 | 12809.0 |
| 2009-12-14 03:30:00 | ES | Futures | 1079.1 | 1080.56 | 1079.1 | 1079.58 | 5920.0 |
| 2009-12-14 04:00:00 | ES | Futures | 1079.83 | 1080.07 | 1078.61 | 1079.1 | 7417.0 |
| 2009-12-14 04:30:00 | ES | Futures | 1079.34 | 1079.83 | 1078.61 | 1078.61 | 1986.0 |
| 2009-12-14 05:00:00 | ES | Futures | 1078.61 | 1079.58 | 1078.12 | 1078.85 | 5289.0 |
| 2009-12-14 05:30:00 | ES | Futures | 1078.85 | 1078.85 | 1077.64 | 1077.64 | 6321.0 |
| 2009-12-14 06:00:00 | ES | Futures | 1077.88 | 1078.61 | 1077.39 | 1077.64 | 4546.0 |
| 2009-12-14 06:30:00 | ES | Futures | 1077.64 | 1078.37 | 1076.42 | 1078.12 | 8655.0 |
| 2009-12-14 07:00:00 | ES | Futures | 1078.12 | 1079.34 | 1077.88 | 1079.1 | 6296.0 |
| 2009-12-14 07:30:00 | ES | Futures | 1079.1 | 1079.1 | 1078.12 | 1078.61 | 4691.0 |
| 2009-12-14 08:00:00 | ES | Futures | 1078.61 | 1080.07 | 1078.37 | 1079.58 | 12013.0 |
| 2009-12-14 08:30:00 | ES | Futures | 1079.58 | 1079.83 | 1078.61 | 1078.61 | 6900.0 |
| 2009-12-14 09:00:00 | ES | Futures | 1078.61 | 1079.83 | 1078.37 | 1079.1 | 12804.0 |
| 2009-12-14 09:30:00 | ES | Futures | 1078.85 | 1079.1 | 1075.69 | 1076.66 | 179314.0 |
| 2009-12-14 10:00:00 | ES | Futures | 1076.42 | 1076.91 | 1074.23 | 1076.18 | 131429.0 |
| 2009-12-14 10:30:00 | ES | Futures | 1075.93 | 1078.12 | 1075.2 | 1076.91 | 97348.0 |
| 2009-12-14 11:00:00 | ES | Futures | 1076.91 | 1078.61 | 1075.93 | 1078.12 | 63586.0 |
| 2009-12-14 11:30:00 | ES | Futures | 1078.12 | 1079.58 | 1077.39 | 1078.12 | 70517.0 |
| 2009-12-14 12:00:00 | ES | Futures | 1078.12 | 1079.1 | 1077.64 | 1078.85 | 38827.0 |
| 2009-12-14 12:30:00 | ES | Futures | 1078.61 | 1080.31 | 1078.61 | 1079.34 | 55382.0 |
| 2009-12-14 13:00:00 | ES | Futures | 1079.34 | 1079.58 | 1077.64 | 1078.61 | 55842.0 |
| 2009-12-14 13:30:00 | ES | Futures | 1078.37 | 1079.1 | 1076.66 | 1078.61 | 57619.0 |
| 2009-12-14 14:00:00 | ES | Futures | 1078.61 | 1078.85 | 1077.88 | 1077.88 | 24654.0 |
| 2009-12-14 14:30:00 | ES | Futures | 1078.12 | 1079.58 | 1077.64 | 1078.37 | 60638.0 |
| 2009-12-14 15:00:00 | ES | Futures | 1078.61 | 1079.58 | 1077.88 | 1078.37 | 46122.0 |
| 2009-12-14 15:30:00 | ES | Futures | 1078.61 | 1079.83 | 1078.37 | 1079.34 | 96847.0 |
| 2009-12-14 16:00:00 | ES | Futures | 1079.34 | 1079.34 | 1078.12 | 1078.61 | 61703.0 |
| 2009-12-14 16:30:00 | ES | Futures | 1078.37 | 1078.61 | 1077.15 | 1077.64 | 4606.0 |
| 2009-12-14 17:00:00 | ES | Futures | 1077.39 | 1077.88 | 1077.15 | 1077.64 | 1355.0 |
| 2009-12-14 18:00:00 | ES | Futures | 1077.64 | 1077.88 | 1075.93 | 1077.15 | 6459.0 |
| 2009-12-14 18:30:00 | ES | Futures | 1077.15 | 1077.64 | 1077.15 | 1077.64 | 1344.0 |
| 2009-12-14 19:00:00 | ES | Futures | 1077.39 | 1077.88 | 1076.91 | 1077.15 | 1582.0 |
| 2009-12-14 19:30:00 | ES | Futures | 1077.39 | 1078.85 | 1077.39 | 1078.37 | 3943.0 |
| 2009-12-14 20:00:00 | ES | Futures | 1078.37 | 1078.61 | 1077.64 | 1077.88 | 744.0 |
| 2009-12-14 20:30:00 | ES | Futures | 1077.88 | 1078.12 | 1077.88 | 1078.12 | 507.0 |
| 2009-12-14 21:00:00 | ES | Futures | 1077.88 | 1078.12 | 1077.39 | 1078.12 | 1399.0 |
| 2009-12-14 21:30:00 | ES | Futures | 1078.12 | 1078.61 | 1077.88 | 1078.37 | 379.0 |
| 2009-12-14 22:00:00 | ES | Futures | 1078.61 | 1079.1 | 1078.37 | 1079.1 | 979.0 |
| 2009-12-14 22:30:00 | ES | Futures | 1078.85 | 1080.07 | 1078.61 | 1080.07 | 4328.0 |
| 2009-12-14 23:00:00 | ES | Futures | 1079.83 | 1080.56 | 1079.58 | 1080.31 | 1574.0 |
| 2009-12-14 23:30:00 | ES | Futures | 1080.56 | 1081.04 | 1080.07 | 1080.07 | 1279.0 |
| 2009-12-14 00:00:00 | NQ | Futures | 2059.96 | 2063.67 | 2059.96 | 2062.81 | 309.0 |
| 2009-12-14 00:30:00 | NQ | Futures | 2062.24 | 2064.24 | 2061.96 | 2062.81 | 242.0 |
| 2009-12-14 01:00:00 | NQ | Futures | 2063.38 | 2064.81 | 2063.1 | 2064.81 | 151.0 |
> showing 50 of 2,397 rows — these rows as CSV