PREVIEW / futures_30min / 2008-05-28
file: by_date/futures_30min/2008/2008-05-28.parquet size: 65 KB rows: 2,226
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-05-28 00:00:00 | ES | Futures | 1288.09 | 1288.32 | 1286.46 | 1286.69 | 870.0 |
| 2008-05-28 00:30:00 | ES | Futures | 1286.46 | 1286.93 | 1286.0 | 1286.0 | 1051.0 |
| 2008-05-28 01:00:00 | ES | Futures | 1286.0 | 1287.16 | 1285.76 | 1286.93 | 696.0 |
| 2008-05-28 01:30:00 | ES | Futures | 1287.16 | 1287.39 | 1286.0 | 1286.23 | 754.0 |
| 2008-05-28 02:00:00 | ES | Futures | 1286.0 | 1286.93 | 1285.53 | 1286.69 | 1954.0 |
| 2008-05-28 02:30:00 | ES | Futures | 1286.69 | 1288.56 | 1286.23 | 1287.86 | 2091.0 |
| 2008-05-28 03:00:00 | ES | Futures | 1287.86 | 1288.79 | 1286.69 | 1287.63 | 7391.0 |
| 2008-05-28 03:30:00 | ES | Futures | 1287.63 | 1288.09 | 1285.76 | 1286.69 | 4497.0 |
| 2008-05-28 04:00:00 | ES | Futures | 1286.46 | 1290.89 | 1286.0 | 1289.49 | 10719.0 |
| 2008-05-28 04:30:00 | ES | Futures | 1289.72 | 1291.82 | 1289.26 | 1289.26 | 7155.0 |
| 2008-05-28 05:00:00 | ES | Futures | 1289.49 | 1291.12 | 1289.26 | 1290.42 | 5013.0 |
| 2008-05-28 05:30:00 | ES | Futures | 1290.65 | 1292.28 | 1290.42 | 1290.65 | 8415.0 |
| 2008-05-28 06:00:00 | ES | Futures | 1290.65 | 1293.45 | 1290.42 | 1292.52 | 7647.0 |
| 2008-05-28 06:30:00 | ES | Futures | 1292.52 | 1292.75 | 1290.19 | 1291.35 | 6960.0 |
| 2008-05-28 07:00:00 | ES | Futures | 1291.35 | 1292.75 | 1291.12 | 1292.05 | 7515.0 |
| 2008-05-28 07:30:00 | ES | Futures | 1292.05 | 1294.61 | 1291.82 | 1294.15 | 14720.0 |
| 2008-05-28 08:00:00 | ES | Futures | 1294.38 | 1294.38 | 1292.28 | 1292.28 | 21810.0 |
| 2008-05-28 08:30:00 | ES | Futures | 1292.52 | 1297.64 | 1292.52 | 1295.31 | 67065.0 |
| 2008-05-28 09:00:00 | ES | Futures | 1295.08 | 1295.31 | 1293.21 | 1293.68 | 27501.0 |
| 2008-05-28 09:30:00 | ES | Futures | 1293.68 | 1294.61 | 1289.72 | 1291.12 | 178859.0 |
| 2008-05-28 10:00:00 | ES | Futures | 1291.35 | 1291.58 | 1285.53 | 1286.69 | 187771.0 |
| 2008-05-28 10:30:00 | ES | Futures | 1286.69 | 1291.12 | 1286.46 | 1290.19 | 126704.0 |
| 2008-05-28 11:00:00 | ES | Futures | 1290.42 | 1290.65 | 1286.23 | 1287.16 | 85420.0 |
| 2008-05-28 11:30:00 | ES | Futures | 1287.16 | 1289.26 | 1286.23 | 1286.46 | 83780.0 |
| 2008-05-28 12:00:00 | ES | Futures | 1286.46 | 1288.79 | 1283.2 | 1287.86 | 141404.0 |
| 2008-05-28 12:30:00 | ES | Futures | 1287.63 | 1288.56 | 1286.69 | 1288.32 | 51026.0 |
| 2008-05-28 13:00:00 | ES | Futures | 1288.09 | 1290.89 | 1287.63 | 1290.42 | 64746.0 |
| 2008-05-28 13:30:00 | ES | Futures | 1290.19 | 1291.12 | 1285.76 | 1287.86 | 81625.0 |
| 2008-05-28 14:00:00 | ES | Futures | 1287.63 | 1288.79 | 1285.06 | 1286.93 | 81753.0 |
| 2008-05-28 14:30:00 | ES | Futures | 1286.93 | 1290.19 | 1286.46 | 1288.79 | 61763.0 |
| 2008-05-28 15:00:00 | ES | Futures | 1288.56 | 1294.38 | 1288.32 | 1293.21 | 121378.0 |
| 2008-05-28 15:30:00 | ES | Futures | 1293.21 | 1296.01 | 1291.35 | 1296.01 | 149479.0 |
| 2008-05-28 16:00:00 | ES | Futures | 1296.01 | 1297.64 | 1295.31 | 1295.31 | 67367.0 |
| 2008-05-28 16:30:00 | ES | Futures | 1294.61 | 1295.31 | 1294.15 | 1294.61 | 10421.0 |
| 2008-05-28 17:00:00 | ES | Futures | 1294.61 | 1294.84 | 1292.98 | 1293.91 | 2612.0 |
| 2008-05-28 18:00:00 | ES | Futures | 1293.68 | 1294.15 | 1293.45 | 1293.91 | 525.0 |
| 2008-05-28 18:30:00 | ES | Futures | 1293.91 | 1294.15 | 1293.45 | 1293.45 | 213.0 |
| 2008-05-28 19:00:00 | ES | Futures | 1293.68 | 1294.15 | 1293.68 | 1293.91 | 154.0 |
| 2008-05-28 19:30:00 | ES | Futures | 1293.91 | 1294.38 | 1293.68 | 1293.68 | 569.0 |
| 2008-05-28 20:00:00 | ES | Futures | 1293.68 | 1293.68 | 1292.98 | 1293.21 | 957.0 |
| 2008-05-28 20:30:00 | ES | Futures | 1293.21 | 1294.61 | 1293.21 | 1294.38 | 1254.0 |
| 2008-05-28 21:00:00 | ES | Futures | 1294.38 | 1296.01 | 1294.38 | 1295.78 | 1987.0 |
| 2008-05-28 21:30:00 | ES | Futures | 1296.01 | 1296.01 | 1294.84 | 1295.54 | 456.0 |
| 2008-05-28 22:00:00 | ES | Futures | 1295.54 | 1296.01 | 1295.54 | 1295.78 | 372.0 |
| 2008-05-28 22:30:00 | ES | Futures | 1295.78 | 1296.47 | 1295.54 | 1295.54 | 517.0 |
| 2008-05-28 23:00:00 | ES | Futures | 1295.78 | 1295.78 | 1294.38 | 1294.84 | 618.0 |
| 2008-05-28 23:30:00 | ES | Futures | 1294.84 | 1295.31 | 1294.15 | 1295.08 | 554.0 |
| 2008-05-28 00:00:00 | NQ | Futures | 2253.86 | 2253.86 | 2249.05 | 2250.47 | 66.0 |
| 2008-05-28 00:30:00 | NQ | Futures | 2249.62 | 2249.9 | 2249.34 | 2249.34 | 99.0 |
| 2008-05-28 01:00:00 | NQ | Futures | 2249.34 | 2250.75 | 2249.34 | 2250.75 | 11.0 |
> showing 50 of 2,226 rows — these rows as CSV