PREVIEW / futures_30min / 2008-08-20
file: by_date/futures_30min/2008/2008-08-20.parquet size: 63 KB rows: 2,154
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-20 00:00:00 | ES | Futures | 1182.76 | 1182.76 | 1182.06 | 1182.3 | 457.0 |
| 2008-08-20 00:30:00 | ES | Futures | 1182.3 | 1182.76 | 1182.06 | 1182.53 | 742.0 |
| 2008-08-20 01:00:00 | ES | Futures | 1182.53 | 1182.76 | 1181.6 | 1181.6 | 535.0 |
| 2008-08-20 01:30:00 | ES | Futures | 1181.83 | 1182.76 | 1181.6 | 1182.3 | 480.0 |
| 2008-08-20 02:00:00 | ES | Futures | 1182.3 | 1183.46 | 1181.6 | 1183.23 | 3869.0 |
| 2008-08-20 02:30:00 | ES | Futures | 1182.99 | 1182.99 | 1181.6 | 1181.83 | 2275.0 |
| 2008-08-20 03:00:00 | ES | Futures | 1181.83 | 1183.23 | 1180.67 | 1180.9 | 4508.0 |
| 2008-08-20 03:30:00 | ES | Futures | 1180.9 | 1183.69 | 1180.67 | 1183.23 | 5209.0 |
| 2008-08-20 04:00:00 | ES | Futures | 1183.23 | 1183.69 | 1182.76 | 1182.99 | 3303.0 |
| 2008-08-20 04:30:00 | ES | Futures | 1182.99 | 1184.39 | 1182.76 | 1184.16 | 5751.0 |
| 2008-08-20 05:00:00 | ES | Futures | 1184.16 | 1184.62 | 1183.23 | 1184.39 | 6147.0 |
| 2008-08-20 05:30:00 | ES | Futures | 1184.16 | 1185.32 | 1183.46 | 1183.92 | 6846.0 |
| 2008-08-20 06:00:00 | ES | Futures | 1183.92 | 1184.39 | 1181.13 | 1181.83 | 6715.0 |
| 2008-08-20 06:30:00 | ES | Futures | 1181.83 | 1183.69 | 1181.83 | 1183.23 | 2512.0 |
| 2008-08-20 07:00:00 | ES | Futures | 1183.46 | 1183.92 | 1182.3 | 1182.99 | 3237.0 |
| 2008-08-20 07:30:00 | ES | Futures | 1182.99 | 1183.69 | 1182.06 | 1182.53 | 6610.0 |
| 2008-08-20 08:00:00 | ES | Futures | 1182.76 | 1182.99 | 1179.74 | 1180.21 | 19239.0 |
| 2008-08-20 08:30:00 | ES | Futures | 1180.21 | 1181.13 | 1178.81 | 1179.04 | 16337.0 |
| 2008-08-20 09:00:00 | ES | Futures | 1179.04 | 1182.3 | 1178.81 | 1181.6 | 29119.0 |
| 2008-08-20 09:30:00 | ES | Futures | 1181.6 | 1181.83 | 1172.3 | 1174.63 | 243549.0 |
| 2008-08-20 10:00:00 | ES | Futures | 1174.86 | 1180.44 | 1171.84 | 1177.42 | 207802.0 |
| 2008-08-20 10:30:00 | ES | Futures | 1177.42 | 1186.02 | 1177.18 | 1185.78 | 209435.0 |
| 2008-08-20 11:00:00 | ES | Futures | 1185.78 | 1186.95 | 1183.46 | 1184.39 | 115702.0 |
| 2008-08-20 11:30:00 | ES | Futures | 1184.39 | 1184.62 | 1179.51 | 1181.6 | 106690.0 |
| 2008-08-20 12:00:00 | ES | Futures | 1181.6 | 1182.53 | 1176.95 | 1178.81 | 83909.0 |
| 2008-08-20 12:30:00 | ES | Futures | 1178.81 | 1179.74 | 1175.56 | 1177.88 | 66848.0 |
| 2008-08-20 13:00:00 | ES | Futures | 1177.65 | 1180.44 | 1177.18 | 1179.28 | 51977.0 |
| 2008-08-20 13:30:00 | ES | Futures | 1179.51 | 1180.9 | 1178.35 | 1179.74 | 56574.0 |
| 2008-08-20 14:00:00 | ES | Futures | 1179.74 | 1179.74 | 1174.16 | 1175.56 | 87098.0 |
| 2008-08-20 14:30:00 | ES | Futures | 1175.56 | 1180.21 | 1174.63 | 1180.21 | 80281.0 |
| 2008-08-20 15:00:00 | ES | Futures | 1180.21 | 1181.6 | 1177.18 | 1178.81 | 88513.0 |
| 2008-08-20 15:30:00 | ES | Futures | 1179.04 | 1185.55 | 1176.72 | 1185.09 | 153739.0 |
| 2008-08-20 16:00:00 | ES | Futures | 1185.09 | 1185.32 | 1183.92 | 1184.16 | 72977.0 |
| 2008-08-20 16:30:00 | ES | Futures | 1184.16 | 1184.62 | 1183.46 | 1184.39 | 4724.0 |
| 2008-08-20 17:00:00 | ES | Futures | 1184.62 | 1185.78 | 1184.39 | 1185.78 | 1372.0 |
| 2008-08-20 18:00:00 | ES | Futures | 1185.55 | 1185.55 | 1183.92 | 1183.92 | 725.0 |
| 2008-08-20 18:30:00 | ES | Futures | 1184.16 | 1184.16 | 1183.92 | 1184.16 | 147.0 |
| 2008-08-20 19:00:00 | ES | Futures | 1183.92 | 1184.39 | 1183.92 | 1183.92 | 177.0 |
| 2008-08-20 19:30:00 | ES | Futures | 1183.92 | 1184.39 | 1183.69 | 1184.16 | 303.0 |
| 2008-08-20 20:00:00 | ES | Futures | 1183.92 | 1184.16 | 1182.99 | 1182.99 | 1179.0 |
| 2008-08-20 20:30:00 | ES | Futures | 1183.23 | 1183.46 | 1182.3 | 1182.53 | 1297.0 |
| 2008-08-20 21:00:00 | ES | Futures | 1182.53 | 1182.76 | 1181.83 | 1182.06 | 1296.0 |
| 2008-08-20 21:30:00 | ES | Futures | 1182.3 | 1182.53 | 1181.6 | 1182.3 | 857.0 |
| 2008-08-20 22:00:00 | ES | Futures | 1182.3 | 1182.53 | 1180.67 | 1181.37 | 1669.0 |
| 2008-08-20 22:30:00 | ES | Futures | 1181.37 | 1181.6 | 1181.13 | 1181.6 | 314.0 |
| 2008-08-20 23:00:00 | ES | Futures | 1181.6 | 1181.83 | 1181.13 | 1181.37 | 380.0 |
| 2008-08-20 23:30:00 | ES | Futures | 1181.6 | 1181.6 | 1180.21 | 1180.21 | 1033.0 |
| 2008-08-20 00:00:00 | NQ | Futures | 2167.05 | 2167.33 | 2166.49 | 2167.05 | 71.0 |
| 2008-08-20 00:30:00 | NQ | Futures | 2166.77 | 2167.89 | 2166.77 | 2167.33 | 62.0 |
| 2008-08-20 01:00:00 | NQ | Futures | 2167.33 | 2167.89 | 2166.77 | 2167.33 | 156.0 |
> showing 50 of 2,154 rows — these rows as CSV