PREVIEW / futures_30min / 2008-04-21
file: by_date/futures_30min/2008/2008-04-21.parquet size: 64 KB rows: 2,159
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-04-21 00:00:00 | ES | Futures | 1295.31 | 1295.31 | 1294.61 | 1294.61 | 441.0 |
| 2008-04-21 00:30:00 | ES | Futures | 1294.61 | 1295.08 | 1293.91 | 1294.84 | 403.0 |
| 2008-04-21 01:00:00 | ES | Futures | 1294.84 | 1295.08 | 1293.68 | 1293.68 | 367.0 |
| 2008-04-21 01:30:00 | ES | Futures | 1293.68 | 1295.54 | 1292.98 | 1295.31 | 1205.0 |
| 2008-04-21 02:00:00 | ES | Futures | 1295.31 | 1297.41 | 1295.08 | 1297.41 | 3979.0 |
| 2008-04-21 02:30:00 | ES | Futures | 1297.17 | 1297.41 | 1296.24 | 1296.94 | 1374.0 |
| 2008-04-21 03:00:00 | ES | Futures | 1296.94 | 1297.41 | 1295.08 | 1296.71 | 5923.0 |
| 2008-04-21 03:30:00 | ES | Futures | 1296.47 | 1298.34 | 1296.24 | 1296.24 | 6794.0 |
| 2008-04-21 04:00:00 | ES | Futures | 1296.24 | 1296.94 | 1293.68 | 1294.61 | 7272.0 |
| 2008-04-21 04:30:00 | ES | Futures | 1294.61 | 1294.84 | 1293.45 | 1293.68 | 3172.0 |
| 2008-04-21 05:00:00 | ES | Futures | 1293.91 | 1294.84 | 1293.21 | 1293.91 | 2061.0 |
| 2008-04-21 05:30:00 | ES | Futures | 1293.91 | 1295.08 | 1292.75 | 1295.08 | 4684.0 |
| 2008-04-21 06:00:00 | ES | Futures | 1295.31 | 1295.54 | 1292.52 | 1293.21 | 3673.0 |
| 2008-04-21 06:30:00 | ES | Futures | 1292.98 | 1294.38 | 1292.05 | 1292.05 | 4610.0 |
| 2008-04-21 07:00:00 | ES | Futures | 1292.05 | 1292.28 | 1287.86 | 1288.79 | 18334.0 |
| 2008-04-21 07:30:00 | ES | Futures | 1289.02 | 1291.58 | 1288.09 | 1290.65 | 10064.0 |
| 2008-04-21 08:00:00 | ES | Futures | 1290.65 | 1292.05 | 1290.19 | 1291.12 | 10199.0 |
| 2008-04-21 08:30:00 | ES | Futures | 1291.35 | 1291.82 | 1289.95 | 1290.89 | 9095.0 |
| 2008-04-21 09:00:00 | ES | Futures | 1291.12 | 1291.12 | 1288.32 | 1289.72 | 23807.0 |
| 2008-04-21 09:30:00 | ES | Futures | 1289.72 | 1293.68 | 1289.49 | 1291.82 | 138967.0 |
| 2008-04-21 10:00:00 | ES | Futures | 1292.05 | 1292.05 | 1286.46 | 1287.16 | 151450.0 |
| 2008-04-21 10:30:00 | ES | Futures | 1286.93 | 1289.49 | 1286.23 | 1286.69 | 115320.0 |
| 2008-04-21 11:00:00 | ES | Futures | 1286.46 | 1289.95 | 1286.0 | 1288.56 | 102129.0 |
| 2008-04-21 11:30:00 | ES | Futures | 1288.79 | 1291.58 | 1288.56 | 1290.89 | 83669.0 |
| 2008-04-21 12:00:00 | ES | Futures | 1290.65 | 1291.58 | 1289.95 | 1291.12 | 49750.0 |
| 2008-04-21 12:30:00 | ES | Futures | 1291.12 | 1291.58 | 1289.49 | 1290.89 | 40916.0 |
| 2008-04-21 13:00:00 | ES | Futures | 1290.89 | 1292.98 | 1290.89 | 1291.82 | 44846.0 |
| 2008-04-21 13:30:00 | ES | Futures | 1291.82 | 1292.05 | 1288.79 | 1289.72 | 49001.0 |
| 2008-04-21 14:00:00 | ES | Futures | 1289.49 | 1290.65 | 1288.56 | 1289.49 | 44934.0 |
| 2008-04-21 14:30:00 | ES | Futures | 1289.49 | 1292.75 | 1288.79 | 1292.05 | 71818.0 |
| 2008-04-21 15:00:00 | ES | Futures | 1292.05 | 1295.08 | 1292.05 | 1293.91 | 86034.0 |
| 2008-04-21 15:30:00 | ES | Futures | 1293.91 | 1296.71 | 1292.98 | 1294.61 | 100909.0 |
| 2008-04-21 16:00:00 | ES | Futures | 1294.61 | 1295.08 | 1292.28 | 1292.98 | 48787.0 |
| 2008-04-21 16:30:00 | ES | Futures | 1292.05 | 1295.31 | 1290.42 | 1291.35 | 7644.0 |
| 2008-04-21 17:00:00 | ES | Futures | 1290.89 | 1291.58 | 1289.26 | 1289.72 | 3117.0 |
| 2008-04-21 18:00:00 | ES | Futures | 1289.72 | 1290.19 | 1289.49 | 1290.19 | 1393.0 |
| 2008-04-21 18:30:00 | ES | Futures | 1290.19 | 1290.42 | 1289.95 | 1290.42 | 208.0 |
| 2008-04-21 19:00:00 | ES | Futures | 1290.19 | 1290.42 | 1289.72 | 1289.72 | 447.0 |
| 2008-04-21 19:30:00 | ES | Futures | 1289.95 | 1289.95 | 1289.26 | 1289.26 | 987.0 |
| 2008-04-21 20:00:00 | ES | Futures | 1289.26 | 1289.72 | 1287.63 | 1288.09 | 1956.0 |
| 2008-04-21 20:30:00 | ES | Futures | 1288.09 | 1289.26 | 1287.86 | 1288.32 | 570.0 |
| 2008-04-21 21:00:00 | ES | Futures | 1288.56 | 1288.56 | 1287.16 | 1287.63 | 910.0 |
| 2008-04-21 21:30:00 | ES | Futures | 1287.86 | 1288.09 | 1287.16 | 1287.39 | 597.0 |
| 2008-04-21 22:00:00 | ES | Futures | 1287.39 | 1287.63 | 1286.93 | 1287.63 | 817.0 |
| 2008-04-21 22:30:00 | ES | Futures | 1287.63 | 1287.86 | 1287.16 | 1287.63 | 399.0 |
| 2008-04-21 23:00:00 | ES | Futures | 1287.63 | 1287.86 | 1287.16 | 1287.39 | 200.0 |
| 2008-04-21 23:30:00 | ES | Futures | 1287.39 | 1287.63 | 1286.69 | 1287.16 | 542.0 |
| 2008-04-21 00:00:00 | NQ | Futures | 2157.98 | 2158.55 | 2156.29 | 2157.7 | 54.0 |
| 2008-04-21 00:30:00 | NQ | Futures | 2156.0 | 2156.85 | 2155.72 | 2156.57 | 50.0 |
| 2008-04-21 01:00:00 | NQ | Futures | 2157.42 | 2157.42 | 2154.02 | 2154.31 | 27.0 |
> showing 50 of 2,159 rows — these rows as CSV