PREVIEW / futures_30min / 2008-08-21
file: by_date/futures_30min/2008/2008-08-21.parquet size: 65 KB rows: 2,143
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-21 00:00:00 | ES | Futures | 1180.44 | 1180.9 | 1180.21 | 1180.44 | 635.0 |
| 2008-08-21 00:30:00 | ES | Futures | 1180.44 | 1180.9 | 1180.21 | 1180.67 | 368.0 |
| 2008-08-21 01:00:00 | ES | Futures | 1180.9 | 1181.37 | 1179.74 | 1180.21 | 1798.0 |
| 2008-08-21 01:30:00 | ES | Futures | 1180.21 | 1180.44 | 1179.04 | 1179.74 | 1557.0 |
| 2008-08-21 02:00:00 | ES | Futures | 1179.74 | 1180.44 | 1179.04 | 1179.28 | 1975.0 |
| 2008-08-21 02:30:00 | ES | Futures | 1179.04 | 1179.51 | 1178.11 | 1179.28 | 4217.0 |
| 2008-08-21 03:00:00 | ES | Futures | 1179.51 | 1180.67 | 1176.95 | 1177.65 | 10463.0 |
| 2008-08-21 03:30:00 | ES | Futures | 1177.65 | 1178.11 | 1175.32 | 1177.18 | 10384.0 |
| 2008-08-21 04:00:00 | ES | Futures | 1177.18 | 1177.42 | 1176.02 | 1177.18 | 4402.0 |
| 2008-08-21 04:30:00 | ES | Futures | 1177.18 | 1180.21 | 1176.25 | 1179.04 | 7921.0 |
| 2008-08-21 05:00:00 | ES | Futures | 1179.28 | 1179.74 | 1177.88 | 1178.58 | 4202.0 |
| 2008-08-21 05:30:00 | ES | Futures | 1178.35 | 1178.58 | 1175.56 | 1176.95 | 4785.0 |
| 2008-08-21 06:00:00 | ES | Futures | 1176.95 | 1179.28 | 1176.72 | 1178.58 | 5790.0 |
| 2008-08-21 06:30:00 | ES | Futures | 1178.81 | 1179.74 | 1177.88 | 1178.58 | 4460.0 |
| 2008-08-21 07:00:00 | ES | Futures | 1178.81 | 1180.67 | 1178.35 | 1179.74 | 7694.0 |
| 2008-08-21 07:30:00 | ES | Futures | 1179.51 | 1180.44 | 1176.72 | 1176.95 | 15602.0 |
| 2008-08-21 08:00:00 | ES | Futures | 1177.18 | 1179.74 | 1176.95 | 1177.88 | 14607.0 |
| 2008-08-21 08:30:00 | ES | Futures | 1178.11 | 1180.44 | 1175.09 | 1176.02 | 27104.0 |
| 2008-08-21 09:00:00 | ES | Futures | 1176.02 | 1176.95 | 1174.63 | 1175.79 | 29588.0 |
| 2008-08-21 09:30:00 | ES | Futures | 1175.79 | 1181.6 | 1174.39 | 1180.67 | 179973.0 |
| 2008-08-21 10:00:00 | ES | Futures | 1180.67 | 1183.92 | 1178.11 | 1181.83 | 162303.0 |
| 2008-08-21 10:30:00 | ES | Futures | 1181.83 | 1182.06 | 1176.49 | 1179.51 | 152763.0 |
| 2008-08-21 11:00:00 | ES | Futures | 1179.51 | 1180.9 | 1176.49 | 1180.44 | 102581.0 |
| 2008-08-21 11:30:00 | ES | Futures | 1180.21 | 1183.92 | 1179.04 | 1181.83 | 114608.0 |
| 2008-08-21 12:00:00 | ES | Futures | 1181.83 | 1184.62 | 1180.9 | 1181.13 | 89284.0 |
| 2008-08-21 12:30:00 | ES | Futures | 1181.13 | 1182.3 | 1180.44 | 1182.06 | 31960.0 |
| 2008-08-21 13:00:00 | ES | Futures | 1181.83 | 1186.02 | 1181.83 | 1183.92 | 74702.0 |
| 2008-08-21 13:30:00 | ES | Futures | 1183.92 | 1186.25 | 1182.53 | 1183.92 | 55695.0 |
| 2008-08-21 14:00:00 | ES | Futures | 1183.69 | 1186.95 | 1182.76 | 1185.78 | 73506.0 |
| 2008-08-21 14:30:00 | ES | Futures | 1186.02 | 1190.9 | 1185.78 | 1189.04 | 119292.0 |
| 2008-08-21 15:00:00 | ES | Futures | 1189.04 | 1191.59 | 1188.11 | 1189.04 | 82609.0 |
| 2008-08-21 15:30:00 | ES | Futures | 1188.8 | 1190.66 | 1186.71 | 1187.18 | 114344.0 |
| 2008-08-21 16:00:00 | ES | Futures | 1187.41 | 1187.41 | 1185.32 | 1185.55 | 66118.0 |
| 2008-08-21 16:30:00 | ES | Futures | 1185.55 | 1186.25 | 1185.32 | 1185.78 | 3586.0 |
| 2008-08-21 17:00:00 | ES | Futures | 1186.02 | 1186.25 | 1185.09 | 1185.32 | 1437.0 |
| 2008-08-21 18:00:00 | ES | Futures | 1185.32 | 1186.48 | 1185.09 | 1185.78 | 896.0 |
| 2008-08-21 18:30:00 | ES | Futures | 1185.55 | 1185.78 | 1185.09 | 1185.09 | 407.0 |
| 2008-08-21 19:00:00 | ES | Futures | 1185.09 | 1185.78 | 1185.09 | 1185.32 | 209.0 |
| 2008-08-21 19:30:00 | ES | Futures | 1185.32 | 1185.55 | 1184.85 | 1185.55 | 634.0 |
| 2008-08-21 20:00:00 | ES | Futures | 1185.32 | 1185.32 | 1182.3 | 1182.76 | 3306.0 |
| 2008-08-21 20:30:00 | ES | Futures | 1182.76 | 1183.23 | 1182.06 | 1183.23 | 1115.0 |
| 2008-08-21 21:00:00 | ES | Futures | 1183.23 | 1184.16 | 1182.53 | 1183.92 | 1150.0 |
| 2008-08-21 21:30:00 | ES | Futures | 1183.92 | 1184.39 | 1183.46 | 1183.92 | 548.0 |
| 2008-08-21 22:00:00 | ES | Futures | 1184.16 | 1184.62 | 1183.46 | 1184.62 | 703.0 |
| 2008-08-21 22:30:00 | ES | Futures | 1184.62 | 1184.62 | 1183.23 | 1183.69 | 494.0 |
| 2008-08-21 23:00:00 | ES | Futures | 1183.69 | 1184.16 | 1183.46 | 1183.46 | 309.0 |
| 2008-08-21 23:30:00 | ES | Futures | 1183.69 | 1185.78 | 1183.69 | 1185.09 | 1511.0 |
| 2008-08-21 00:00:00 | NQ | Futures | 2147.92 | 2148.77 | 2146.8 | 2147.36 | 133.0 |
| 2008-08-21 00:30:00 | NQ | Futures | 2147.08 | 2148.48 | 2146.8 | 2148.2 | 18.0 |
| 2008-08-21 01:00:00 | NQ | Futures | 2147.64 | 2151.02 | 2147.64 | 2148.2 | 403.0 |
> showing 50 of 2,143 rows — these rows as CSV