PREVIEW / futures_30min / 2008-08-14
file: by_date/futures_30min/2008/2008-08-14.parquet size: 66 KB rows: 2,222
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-14 00:00:00 | ES | Futures | 1196.24 | 1196.24 | 1195.78 | 1195.78 | 297.0 |
| 2008-08-14 00:30:00 | ES | Futures | 1195.78 | 1196.47 | 1195.78 | 1196.01 | 303.0 |
| 2008-08-14 01:00:00 | ES | Futures | 1196.01 | 1196.71 | 1195.78 | 1196.01 | 345.0 |
| 2008-08-14 01:30:00 | ES | Futures | 1196.24 | 1196.24 | 1195.54 | 1195.54 | 442.0 |
| 2008-08-14 02:00:00 | ES | Futures | 1195.54 | 1196.24 | 1194.15 | 1195.78 | 2490.0 |
| 2008-08-14 02:30:00 | ES | Futures | 1195.78 | 1197.17 | 1195.08 | 1196.71 | 3334.0 |
| 2008-08-14 03:00:00 | ES | Futures | 1196.71 | 1198.57 | 1194.38 | 1198.1 | 7016.0 |
| 2008-08-14 03:30:00 | ES | Futures | 1198.33 | 1199.26 | 1196.94 | 1198.57 | 6017.0 |
| 2008-08-14 04:00:00 | ES | Futures | 1198.8 | 1198.8 | 1196.94 | 1197.4 | 4239.0 |
| 2008-08-14 04:30:00 | ES | Futures | 1197.4 | 1197.64 | 1196.47 | 1196.94 | 2605.0 |
| 2008-08-14 05:00:00 | ES | Futures | 1197.17 | 1198.1 | 1195.08 | 1196.47 | 3766.0 |
| 2008-08-14 05:30:00 | ES | Futures | 1196.24 | 1198.1 | 1196.24 | 1196.94 | 2919.0 |
| 2008-08-14 06:00:00 | ES | Futures | 1196.94 | 1197.87 | 1195.08 | 1196.94 | 8096.0 |
| 2008-08-14 06:30:00 | ES | Futures | 1197.17 | 1198.1 | 1196.71 | 1197.4 | 2962.0 |
| 2008-08-14 07:00:00 | ES | Futures | 1197.4 | 1199.26 | 1197.17 | 1197.87 | 7755.0 |
| 2008-08-14 07:30:00 | ES | Futures | 1197.87 | 1198.8 | 1197.4 | 1197.64 | 3197.0 |
| 2008-08-14 08:00:00 | ES | Futures | 1197.64 | 1198.8 | 1196.94 | 1197.87 | 11543.0 |
| 2008-08-14 08:30:00 | ES | Futures | 1197.64 | 1197.64 | 1186.71 | 1187.64 | 95976.0 |
| 2008-08-14 09:00:00 | ES | Futures | 1187.64 | 1189.27 | 1186.02 | 1186.48 | 35852.0 |
| 2008-08-14 09:30:00 | ES | Futures | 1186.48 | 1192.76 | 1185.55 | 1192.29 | 216771.0 |
| 2008-08-14 10:00:00 | ES | Futures | 1192.06 | 1196.71 | 1191.13 | 1196.71 | 179146.0 |
| 2008-08-14 10:30:00 | ES | Futures | 1196.47 | 1202.28 | 1195.54 | 1200.66 | 229174.0 |
| 2008-08-14 11:00:00 | ES | Futures | 1200.66 | 1205.07 | 1199.5 | 1202.75 | 135176.0 |
| 2008-08-14 11:30:00 | ES | Futures | 1202.52 | 1203.45 | 1200.66 | 1202.75 | 69272.0 |
| 2008-08-14 12:00:00 | ES | Futures | 1202.75 | 1204.84 | 1201.59 | 1202.05 | 91334.0 |
| 2008-08-14 12:30:00 | ES | Futures | 1202.05 | 1209.26 | 1201.82 | 1206.7 | 123590.0 |
| 2008-08-14 13:00:00 | ES | Futures | 1206.7 | 1207.4 | 1204.61 | 1204.61 | 54284.0 |
| 2008-08-14 13:30:00 | ES | Futures | 1204.61 | 1204.84 | 1201.59 | 1203.91 | 79898.0 |
| 2008-08-14 14:00:00 | ES | Futures | 1204.14 | 1206.24 | 1202.75 | 1203.91 | 86335.0 |
| 2008-08-14 14:30:00 | ES | Futures | 1203.68 | 1204.14 | 1198.8 | 1200.43 | 81063.0 |
| 2008-08-14 15:00:00 | ES | Futures | 1200.66 | 1202.05 | 1198.1 | 1199.03 | 101401.0 |
| 2008-08-14 15:30:00 | ES | Futures | 1198.8 | 1202.75 | 1198.57 | 1202.05 | 147609.0 |
| 2008-08-14 16:00:00 | ES | Futures | 1202.05 | 1202.98 | 1201.12 | 1202.75 | 71732.0 |
| 2008-08-14 16:30:00 | ES | Futures | 1202.52 | 1204.38 | 1201.82 | 1204.14 | 4752.0 |
| 2008-08-14 17:00:00 | ES | Futures | 1203.91 | 1205.31 | 1203.91 | 1204.38 | 1517.0 |
| 2008-08-14 18:00:00 | ES | Futures | 1204.38 | 1205.07 | 1204.38 | 1205.07 | 461.0 |
| 2008-08-14 18:30:00 | ES | Futures | 1205.07 | 1205.31 | 1204.84 | 1205.07 | 201.0 |
| 2008-08-14 19:00:00 | ES | Futures | 1205.07 | 1205.31 | 1204.84 | 1204.84 | 228.0 |
| 2008-08-14 19:30:00 | ES | Futures | 1204.84 | 1205.31 | 1204.61 | 1205.07 | 528.0 |
| 2008-08-14 20:00:00 | ES | Futures | 1205.07 | 1205.31 | 1204.61 | 1205.07 | 436.0 |
| 2008-08-14 20:30:00 | ES | Futures | 1205.07 | 1208.33 | 1205.07 | 1206.7 | 3482.0 |
| 2008-08-14 21:00:00 | ES | Futures | 1206.7 | 1206.93 | 1206.0 | 1206.47 | 1053.0 |
| 2008-08-14 21:30:00 | ES | Futures | 1206.24 | 1206.93 | 1206.0 | 1206.24 | 816.0 |
| 2008-08-14 22:00:00 | ES | Futures | 1206.24 | 1206.24 | 1205.07 | 1205.54 | 1112.0 |
| 2008-08-14 22:30:00 | ES | Futures | 1205.54 | 1205.77 | 1204.61 | 1205.31 | 851.0 |
| 2008-08-14 23:00:00 | ES | Futures | 1205.54 | 1206.24 | 1205.07 | 1206.24 | 261.0 |
| 2008-08-14 23:30:00 | ES | Futures | 1205.77 | 1206.24 | 1205.31 | 1206.0 | 418.0 |
| 2008-08-14 00:00:00 | NQ | Futures | 2188.43 | 2188.43 | 2188.43 | 2188.43 | 13.0 |
| 2008-08-14 00:30:00 | NQ | Futures | 2188.43 | 2189.83 | 2188.43 | 2189.27 | 13.0 |
| 2008-08-14 01:00:00 | NQ | Futures | 2188.99 | 2189.55 | 2188.15 | 2188.15 | 15.0 |
> showing 50 of 2,222 rows — these rows as CSV