PREVIEW / futures_30min / 2008-05-12
file: by_date/futures_30min/2008/2008-05-12.parquet size: 66 KB rows: 2,211
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-12 00:00:00 | ES | Futures | 1296.71 | 1296.94 | 1296.01 | 1296.71 | 219.0 |
| 2008-05-12 00:30:00 | ES | Futures | 1296.47 | 1296.94 | 1296.24 | 1296.71 | 102.0 |
| 2008-05-12 01:00:00 | ES | Futures | 1296.94 | 1297.17 | 1296.01 | 1296.94 | 320.0 |
| 2008-05-12 01:30:00 | ES | Futures | 1296.94 | 1297.17 | 1296.47 | 1296.47 | 165.0 |
| 2008-05-12 02:00:00 | ES | Futures | 1296.47 | 1296.71 | 1296.01 | 1296.47 | 804.0 |
| 2008-05-12 02:30:00 | ES | Futures | 1296.71 | 1296.71 | 1296.01 | 1296.24 | 1411.0 |
| 2008-05-12 03:00:00 | ES | Futures | 1296.47 | 1298.34 | 1296.24 | 1297.64 | 6828.0 |
| 2008-05-12 03:30:00 | ES | Futures | 1297.87 | 1298.34 | 1297.17 | 1297.87 | 4917.0 |
| 2008-05-12 04:00:00 | ES | Futures | 1298.1 | 1298.1 | 1297.41 | 1297.87 | 1856.0 |
| 2008-05-12 04:30:00 | ES | Futures | 1297.64 | 1298.57 | 1297.64 | 1298.34 | 1891.0 |
| 2008-05-12 05:00:00 | ES | Futures | 1298.34 | 1298.57 | 1297.64 | 1297.87 | 1533.0 |
| 2008-05-12 05:30:00 | ES | Futures | 1297.87 | 1298.1 | 1295.78 | 1296.01 | 5052.0 |
| 2008-05-12 06:00:00 | ES | Futures | 1295.78 | 1296.24 | 1294.84 | 1296.24 | 3717.0 |
| 2008-05-12 06:30:00 | ES | Futures | 1296.47 | 1296.94 | 1295.31 | 1296.71 | 3238.0 |
| 2008-05-12 07:00:00 | ES | Futures | 1296.71 | 1297.87 | 1296.47 | 1297.41 | 4440.0 |
| 2008-05-12 07:30:00 | ES | Futures | 1297.41 | 1298.8 | 1296.94 | 1296.94 | 8402.0 |
| 2008-05-12 08:00:00 | ES | Futures | 1296.94 | 1297.17 | 1295.31 | 1295.54 | 13030.0 |
| 2008-05-12 08:30:00 | ES | Futures | 1295.54 | 1296.01 | 1294.15 | 1295.31 | 16985.0 |
| 2008-05-12 09:00:00 | ES | Futures | 1295.08 | 1297.17 | 1294.61 | 1296.01 | 21947.0 |
| 2008-05-12 09:30:00 | ES | Futures | 1295.78 | 1297.41 | 1292.98 | 1293.68 | 138028.0 |
| 2008-05-12 10:00:00 | ES | Futures | 1293.91 | 1294.38 | 1291.12 | 1293.68 | 121220.0 |
| 2008-05-12 10:30:00 | ES | Futures | 1293.68 | 1299.97 | 1293.21 | 1298.8 | 178210.0 |
| 2008-05-12 11:00:00 | ES | Futures | 1298.8 | 1300.9 | 1297.87 | 1300.2 | 107967.0 |
| 2008-05-12 11:30:00 | ES | Futures | 1299.97 | 1302.29 | 1299.04 | 1302.06 | 93837.0 |
| 2008-05-12 12:00:00 | ES | Futures | 1302.06 | 1303.46 | 1301.13 | 1302.06 | 76062.0 |
| 2008-05-12 12:30:00 | ES | Futures | 1301.83 | 1304.39 | 1301.36 | 1302.76 | 70673.0 |
| 2008-05-12 13:00:00 | ES | Futures | 1302.76 | 1302.99 | 1300.2 | 1300.66 | 75643.0 |
| 2008-05-12 13:30:00 | ES | Futures | 1300.66 | 1301.36 | 1299.27 | 1301.13 | 70191.0 |
| 2008-05-12 14:00:00 | ES | Futures | 1301.13 | 1305.55 | 1300.2 | 1305.32 | 100327.0 |
| 2008-05-12 14:30:00 | ES | Futures | 1305.32 | 1308.35 | 1305.09 | 1306.72 | 116543.0 |
| 2008-05-12 15:00:00 | ES | Futures | 1306.72 | 1308.35 | 1305.55 | 1306.25 | 109483.0 |
| 2008-05-12 15:30:00 | ES | Futures | 1306.25 | 1308.12 | 1305.09 | 1307.88 | 128464.0 |
| 2008-05-12 16:00:00 | ES | Futures | 1307.65 | 1308.58 | 1307.42 | 1308.35 | 74615.0 |
| 2008-05-12 16:30:00 | ES | Futures | 1307.18 | 1308.12 | 1306.95 | 1308.12 | 4050.0 |
| 2008-05-12 17:00:00 | ES | Futures | 1307.88 | 1308.12 | 1306.72 | 1307.65 | 1758.0 |
| 2008-05-12 18:00:00 | ES | Futures | 1307.42 | 1307.88 | 1307.18 | 1307.88 | 490.0 |
| 2008-05-12 18:30:00 | ES | Futures | 1307.88 | 1307.88 | 1307.42 | 1307.65 | 275.0 |
| 2008-05-12 19:00:00 | ES | Futures | 1307.88 | 1308.35 | 1307.65 | 1308.35 | 545.0 |
| 2008-05-12 19:30:00 | ES | Futures | 1308.12 | 1309.28 | 1308.12 | 1308.35 | 1059.0 |
| 2008-05-12 20:00:00 | ES | Futures | 1308.58 | 1309.28 | 1307.18 | 1308.58 | 962.0 |
| 2008-05-12 20:30:00 | ES | Futures | 1308.35 | 1309.98 | 1308.35 | 1309.51 | 1934.0 |
| 2008-05-12 21:00:00 | ES | Futures | 1309.75 | 1309.98 | 1308.58 | 1308.81 | 1053.0 |
| 2008-05-12 21:30:00 | ES | Futures | 1309.05 | 1309.51 | 1308.12 | 1308.35 | 1190.0 |
| 2008-05-12 22:00:00 | ES | Futures | 1308.58 | 1309.51 | 1308.35 | 1309.05 | 519.0 |
| 2008-05-12 22:30:00 | ES | Futures | 1309.28 | 1309.28 | 1307.18 | 1307.88 | 916.0 |
| 2008-05-12 23:00:00 | ES | Futures | 1308.12 | 1308.81 | 1307.88 | 1308.81 | 291.0 |
| 2008-05-12 23:30:00 | ES | Futures | 1308.81 | 1309.05 | 1308.12 | 1308.58 | 306.0 |
| 2008-05-12 00:00:00 | NQ | Futures | 2226.43 | 2226.99 | 2226.14 | 2226.14 | 12.0 |
| 2008-05-12 00:30:00 | NQ | Futures | 2226.14 | 2226.43 | 2225.58 | 2226.43 | 36.0 |
| 2008-05-12 01:00:00 | NQ | Futures | 2226.43 | 2227.28 | 2225.58 | 2227.28 | 46.0 |
> showing 50 of 2,211 rows — these rows as CSV