PREVIEW / futures_30min / 2008-07-23
file: by_date/futures_30min/2008/2008-07-23.parquet size: 67 KB rows: 2,318
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-07-23 00:00:00 | ES | Futures | 1185.09 | 1185.78 | 1184.85 | 1185.32 | 642.0 |
| 2008-07-23 00:30:00 | ES | Futures | 1185.32 | 1185.55 | 1184.39 | 1184.62 | 618.0 |
| 2008-07-23 01:00:00 | ES | Futures | 1184.62 | 1185.09 | 1183.92 | 1184.39 | 902.0 |
| 2008-07-23 01:30:00 | ES | Futures | 1184.39 | 1185.55 | 1184.39 | 1185.32 | 1239.0 |
| 2008-07-23 02:00:00 | ES | Futures | 1185.32 | 1186.25 | 1184.85 | 1186.02 | 2340.0 |
| 2008-07-23 02:30:00 | ES | Futures | 1186.02 | 1188.11 | 1185.78 | 1187.41 | 9024.0 |
| 2008-07-23 03:00:00 | ES | Futures | 1187.18 | 1187.87 | 1186.25 | 1187.18 | 14744.0 |
| 2008-07-23 03:30:00 | ES | Futures | 1186.95 | 1187.64 | 1186.48 | 1187.41 | 5941.0 |
| 2008-07-23 04:00:00 | ES | Futures | 1187.41 | 1192.06 | 1187.18 | 1191.13 | 18005.0 |
| 2008-07-23 04:30:00 | ES | Futures | 1191.36 | 1194.15 | 1191.13 | 1192.06 | 15958.0 |
| 2008-07-23 05:00:00 | ES | Futures | 1192.06 | 1193.22 | 1191.59 | 1191.83 | 8615.0 |
| 2008-07-23 05:30:00 | ES | Futures | 1191.83 | 1192.06 | 1190.66 | 1191.59 | 6288.0 |
| 2008-07-23 06:00:00 | ES | Futures | 1191.59 | 1192.52 | 1191.13 | 1191.36 | 4323.0 |
| 2008-07-23 06:30:00 | ES | Futures | 1191.36 | 1191.83 | 1190.43 | 1190.66 | 5057.0 |
| 2008-07-23 07:00:00 | ES | Futures | 1190.43 | 1191.83 | 1189.73 | 1191.59 | 17248.0 |
| 2008-07-23 07:30:00 | ES | Futures | 1191.59 | 1191.83 | 1188.8 | 1190.43 | 14716.0 |
| 2008-07-23 08:00:00 | ES | Futures | 1190.43 | 1192.29 | 1189.73 | 1191.83 | 24191.0 |
| 2008-07-23 08:30:00 | ES | Futures | 1191.59 | 1192.29 | 1189.5 | 1189.97 | 23908.0 |
| 2008-07-23 09:00:00 | ES | Futures | 1189.97 | 1190.9 | 1188.11 | 1188.8 | 27740.0 |
| 2008-07-23 09:30:00 | ES | Futures | 1188.8 | 1191.13 | 1185.78 | 1188.34 | 200097.0 |
| 2008-07-23 10:00:00 | ES | Futures | 1188.34 | 1197.4 | 1187.18 | 1195.54 | 237755.0 |
| 2008-07-23 10:30:00 | ES | Futures | 1195.54 | 1200.43 | 1194.85 | 1195.08 | 247872.0 |
| 2008-07-23 11:00:00 | ES | Futures | 1194.85 | 1196.24 | 1192.29 | 1195.54 | 161371.0 |
| 2008-07-23 11:30:00 | ES | Futures | 1195.54 | 1195.78 | 1189.97 | 1190.66 | 117002.0 |
| 2008-07-23 12:00:00 | ES | Futures | 1190.66 | 1192.06 | 1187.41 | 1189.73 | 131528.0 |
| 2008-07-23 12:30:00 | ES | Futures | 1189.73 | 1192.29 | 1187.64 | 1191.36 | 80874.0 |
| 2008-07-23 13:00:00 | ES | Futures | 1191.36 | 1192.52 | 1188.57 | 1189.97 | 49685.0 |
| 2008-07-23 13:30:00 | ES | Futures | 1189.97 | 1194.38 | 1186.48 | 1188.57 | 144886.0 |
| 2008-07-23 14:00:00 | ES | Futures | 1188.57 | 1194.61 | 1187.87 | 1194.38 | 144307.0 |
| 2008-07-23 14:30:00 | ES | Futures | 1194.15 | 1196.01 | 1190.2 | 1191.13 | 101149.0 |
| 2008-07-23 15:00:00 | ES | Futures | 1191.36 | 1193.45 | 1189.27 | 1190.43 | 81966.0 |
| 2008-07-23 15:30:00 | ES | Futures | 1190.43 | 1192.29 | 1188.34 | 1191.83 | 123640.0 |
| 2008-07-23 16:00:00 | ES | Futures | 1191.83 | 1193.92 | 1191.36 | 1191.59 | 71895.0 |
| 2008-07-23 16:30:00 | ES | Futures | 1191.13 | 1192.29 | 1189.97 | 1190.66 | 8164.0 |
| 2008-07-23 17:00:00 | ES | Futures | 1190.66 | 1191.59 | 1190.66 | 1190.9 | 1840.0 |
| 2008-07-23 18:00:00 | ES | Futures | 1191.59 | 1192.29 | 1190.9 | 1191.59 | 1139.0 |
| 2008-07-23 18:30:00 | ES | Futures | 1191.59 | 1193.22 | 1191.59 | 1192.52 | 1438.0 |
| 2008-07-23 19:00:00 | ES | Futures | 1192.29 | 1192.99 | 1192.29 | 1192.76 | 278.0 |
| 2008-07-23 19:30:00 | ES | Futures | 1192.76 | 1192.99 | 1191.13 | 1191.83 | 472.0 |
| 2008-07-23 20:00:00 | ES | Futures | 1191.83 | 1191.83 | 1190.9 | 1191.13 | 1026.0 |
| 2008-07-23 20:30:00 | ES | Futures | 1190.9 | 1191.83 | 1190.9 | 1190.9 | 591.0 |
| 2008-07-23 21:00:00 | ES | Futures | 1190.9 | 1191.83 | 1190.9 | 1191.59 | 502.0 |
| 2008-07-23 21:30:00 | ES | Futures | 1191.59 | 1191.59 | 1190.9 | 1191.13 | 500.0 |
| 2008-07-23 22:00:00 | ES | Futures | 1190.9 | 1191.36 | 1190.43 | 1190.66 | 1023.0 |
| 2008-07-23 22:30:00 | ES | Futures | 1190.66 | 1191.13 | 1190.43 | 1190.9 | 275.0 |
| 2008-07-23 23:00:00 | ES | Futures | 1190.9 | 1191.13 | 1190.66 | 1190.9 | 454.0 |
| 2008-07-23 23:30:00 | ES | Futures | 1191.13 | 1191.36 | 1190.66 | 1191.13 | 355.0 |
| 2008-07-23 00:00:00 | NQ | Futures | 2052.85 | 2055.1 | 2052.85 | 2053.69 | 150.0 |
| 2008-07-23 00:30:00 | NQ | Futures | 2053.97 | 2053.97 | 2053.13 | 2053.13 | 60.0 |
| 2008-07-23 01:00:00 | NQ | Futures | 2053.13 | 2053.69 | 2052.56 | 2052.56 | 55.0 |
> showing 50 of 2,318 rows — these rows as CSV