PREVIEW / futures_30min / 2008-01-16
file: by_date/futures_30min/2008/2008-01-16.parquet size: 48 KB rows: 1,481
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-01-16 00:00:00 | ES | Futures | 1283.29 | 1283.29 | 1282.36 | 1282.59 | 1038.0 |
| 2008-01-16 00:30:00 | ES | Futures | 1282.59 | 1282.83 | 1281.19 | 1282.13 | 1612.0 |
| 2008-01-16 01:00:00 | ES | Futures | 1282.13 | 1283.52 | 1281.89 | 1283.29 | 1482.0 |
| 2008-01-16 01:30:00 | ES | Futures | 1283.52 | 1284.46 | 1282.13 | 1282.36 | 1849.0 |
| 2008-01-16 02:00:00 | ES | Futures | 1282.36 | 1284.22 | 1281.66 | 1283.76 | 3731.0 |
| 2008-01-16 02:30:00 | ES | Futures | 1283.76 | 1285.39 | 1283.52 | 1284.22 | 3754.0 |
| 2008-01-16 03:00:00 | ES | Futures | 1284.22 | 1285.39 | 1280.49 | 1282.13 | 12959.0 |
| 2008-01-16 03:30:00 | ES | Futures | 1282.13 | 1286.32 | 1281.66 | 1285.86 | 9240.0 |
| 2008-01-16 04:00:00 | ES | Futures | 1285.62 | 1285.86 | 1282.83 | 1284.92 | 10368.0 |
| 2008-01-16 04:30:00 | ES | Futures | 1284.92 | 1286.56 | 1284.46 | 1285.86 | 9468.0 |
| 2008-01-16 05:00:00 | ES | Futures | 1285.86 | 1286.56 | 1282.83 | 1283.52 | 8336.0 |
| 2008-01-16 05:30:00 | ES | Futures | 1283.29 | 1283.99 | 1281.19 | 1281.19 | 5791.0 |
| 2008-01-16 06:00:00 | ES | Futures | 1281.43 | 1283.52 | 1280.49 | 1282.59 | 10246.0 |
| 2008-01-16 06:30:00 | ES | Futures | 1282.36 | 1283.29 | 1279.33 | 1282.59 | 19103.0 |
| 2008-01-16 07:00:00 | ES | Futures | 1282.59 | 1284.92 | 1281.43 | 1283.99 | 22360.0 |
| 2008-01-16 07:30:00 | ES | Futures | 1283.99 | 1287.49 | 1283.76 | 1283.76 | 25722.0 |
| 2008-01-16 08:00:00 | ES | Futures | 1283.99 | 1289.35 | 1283.29 | 1287.72 | 33910.0 |
| 2008-01-16 08:30:00 | ES | Futures | 1287.72 | 1287.95 | 1281.66 | 1285.39 | 56187.0 |
| 2008-01-16 09:00:00 | ES | Futures | 1285.39 | 1290.29 | 1284.46 | 1286.32 | 59701.0 |
| 2008-01-16 09:30:00 | ES | Futures | 1286.32 | 1296.58 | 1286.09 | 1287.26 | 335249.0 |
| 2008-01-16 10:00:00 | ES | Futures | 1287.26 | 1290.05 | 1282.36 | 1284.92 | 254409.0 |
| 2008-01-16 10:30:00 | ES | Futures | 1285.16 | 1287.72 | 1276.3 | 1279.79 | 278280.0 |
| 2008-01-16 11:00:00 | ES | Futures | 1279.79 | 1287.26 | 1279.33 | 1286.79 | 185792.0 |
| 2008-01-16 11:30:00 | ES | Futures | 1287.02 | 1293.32 | 1281.19 | 1291.92 | 214861.0 |
| 2008-01-16 12:00:00 | ES | Futures | 1291.92 | 1294.95 | 1288.19 | 1290.29 | 165398.0 |
| 2008-01-16 12:30:00 | ES | Futures | 1290.29 | 1295.42 | 1289.12 | 1290.75 | 127790.0 |
| 2008-01-16 13:00:00 | ES | Futures | 1290.75 | 1292.15 | 1286.09 | 1286.79 | 99290.0 |
| 2008-01-16 13:30:00 | ES | Futures | 1286.79 | 1291.69 | 1285.62 | 1287.95 | 118079.0 |
| 2008-01-16 14:00:00 | ES | Futures | 1288.19 | 1297.51 | 1284.22 | 1297.28 | 214864.0 |
| 2008-01-16 14:30:00 | ES | Futures | 1297.28 | 1303.34 | 1293.55 | 1294.72 | 283820.0 |
| 2008-01-16 15:00:00 | ES | Futures | 1294.72 | 1301.01 | 1293.08 | 1298.21 | 169636.0 |
| 2008-01-16 15:30:00 | ES | Futures | 1298.21 | 1300.08 | 1283.99 | 1284.46 | 286928.0 |
| 2008-01-16 16:00:00 | ES | Futures | 1284.46 | 1285.62 | 1282.83 | 1283.52 | 95952.0 |
| 2008-01-16 16:30:00 | ES | Futures | 1284.46 | 1286.79 | 1284.46 | 1285.62 | 7080.0 |
| 2008-01-16 17:00:00 | ES | Futures | 1285.62 | 1286.56 | 1284.69 | 1285.39 | 2138.0 |
| 2008-01-16 18:00:00 | ES | Futures | 1285.62 | 1286.09 | 1284.22 | 1285.62 | 3247.0 |
| 2008-01-16 18:30:00 | ES | Futures | 1285.62 | 1286.32 | 1285.16 | 1286.09 | 1349.0 |
| 2008-01-16 19:00:00 | ES | Futures | 1286.09 | 1287.49 | 1285.62 | 1287.02 | 2866.0 |
| 2008-01-16 19:30:00 | ES | Futures | 1287.02 | 1288.42 | 1286.79 | 1287.02 | 2258.0 |
| 2008-01-16 20:00:00 | ES | Futures | 1287.02 | 1287.95 | 1285.16 | 1286.79 | 1822.0 |
| 2008-01-16 20:30:00 | ES | Futures | 1286.79 | 1287.95 | 1286.56 | 1287.72 | 981.0 |
| 2008-01-16 21:00:00 | ES | Futures | 1287.72 | 1288.65 | 1287.72 | 1288.65 | 1348.0 |
| 2008-01-16 21:30:00 | ES | Futures | 1288.65 | 1289.35 | 1287.72 | 1288.89 | 1792.0 |
| 2008-01-16 22:00:00 | ES | Futures | 1288.65 | 1288.89 | 1287.95 | 1288.42 | 1191.0 |
| 2008-01-16 22:30:00 | ES | Futures | 1288.42 | 1288.42 | 1284.69 | 1284.92 | 3047.0 |
| 2008-01-16 23:00:00 | ES | Futures | 1284.92 | 1286.79 | 1283.52 | 1286.32 | 2285.0 |
| 2008-01-16 23:30:00 | ES | Futures | 1286.32 | 1288.89 | 1285.39 | 1288.42 | 1473.0 |
| 2008-01-16 00:00:00 | NQ | Futures | 2133.94 | 2134.22 | 2129.11 | 2131.1 | 348.0 |
| 2008-01-16 00:30:00 | NQ | Futures | 2130.81 | 2131.38 | 2129.4 | 2129.68 | 50.0 |
| 2008-01-16 01:00:00 | NQ | Futures | 2130.25 | 2131.95 | 2129.4 | 2129.68 | 197.0 |
> showing 50 of 1,481 rows — these rows as CSV