PREVIEW / futures_30min / 2008-04-18
file: by_date/futures_30min/2008/2008-04-18.parquet size: 61 KB rows: 1,866
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-18 00:00:00 | ES | Futures | 1278.08 | 1278.78 | 1277.38 | 1278.54 | 716.0 |
| 2008-04-18 00:30:00 | ES | Futures | 1278.54 | 1278.78 | 1278.31 | 1278.78 | 373.0 |
| 2008-04-18 01:00:00 | ES | Futures | 1278.78 | 1278.78 | 1278.31 | 1278.78 | 204.0 |
| 2008-04-18 01:30:00 | ES | Futures | 1278.78 | 1278.78 | 1278.31 | 1278.54 | 375.0 |
| 2008-04-18 02:00:00 | ES | Futures | 1278.54 | 1278.78 | 1275.98 | 1277.85 | 3569.0 |
| 2008-04-18 02:30:00 | ES | Futures | 1277.85 | 1279.24 | 1277.61 | 1278.54 | 3010.0 |
| 2008-04-18 03:00:00 | ES | Futures | 1278.54 | 1280.17 | 1277.85 | 1279.94 | 5829.0 |
| 2008-04-18 03:30:00 | ES | Futures | 1279.94 | 1281.8 | 1279.71 | 1281.11 | 7134.0 |
| 2008-04-18 04:00:00 | ES | Futures | 1281.11 | 1281.11 | 1278.31 | 1278.31 | 4462.0 |
| 2008-04-18 04:30:00 | ES | Futures | 1278.08 | 1278.54 | 1276.91 | 1278.08 | 3847.0 |
| 2008-04-18 05:00:00 | ES | Futures | 1278.08 | 1280.87 | 1278.08 | 1280.17 | 4552.0 |
| 2008-04-18 05:30:00 | ES | Futures | 1280.17 | 1280.87 | 1279.71 | 1280.64 | 3666.0 |
| 2008-04-18 06:00:00 | ES | Futures | 1280.64 | 1283.9 | 1279.94 | 1283.43 | 10776.0 |
| 2008-04-18 06:30:00 | ES | Futures | 1283.2 | 1288.79 | 1282.04 | 1288.32 | 30749.0 |
| 2008-04-18 07:00:00 | ES | Futures | 1288.56 | 1292.98 | 1288.32 | 1290.65 | 32473.0 |
| 2008-04-18 07:30:00 | ES | Futures | 1290.42 | 1294.61 | 1290.19 | 1292.52 | 43011.0 |
| 2008-04-18 08:00:00 | ES | Futures | 1292.52 | 1293.91 | 1291.12 | 1292.98 | 36617.0 |
| 2008-04-18 08:30:00 | ES | Futures | 1293.21 | 1296.24 | 1292.52 | 1296.24 | 26570.0 |
| 2008-04-18 09:00:00 | ES | Futures | 1296.24 | 1296.47 | 1294.61 | 1296.01 | 40999.0 |
| 2008-04-18 09:30:00 | ES | Futures | 1296.01 | 1296.71 | 1291.12 | 1292.28 | 234353.0 |
| 2008-04-18 10:00:00 | ES | Futures | 1292.05 | 1292.98 | 1289.95 | 1291.12 | 167956.0 |
| 2008-04-18 10:30:00 | ES | Futures | 1291.35 | 1297.17 | 1290.89 | 1295.31 | 160703.0 |
| 2008-04-18 11:00:00 | ES | Futures | 1295.31 | 1297.64 | 1293.45 | 1296.01 | 145762.0 |
| 2008-04-18 11:30:00 | ES | Futures | 1296.24 | 1299.97 | 1294.61 | 1298.8 | 120655.0 |
| 2008-04-18 12:00:00 | ES | Futures | 1298.8 | 1301.13 | 1297.64 | 1300.43 | 111177.0 |
| 2008-04-18 12:30:00 | ES | Futures | 1300.43 | 1301.13 | 1298.57 | 1299.04 | 61449.0 |
| 2008-04-18 13:00:00 | ES | Futures | 1298.8 | 1302.29 | 1298.57 | 1301.6 | 74602.0 |
| 2008-04-18 13:30:00 | ES | Futures | 1301.6 | 1302.06 | 1298.8 | 1299.73 | 61341.0 |
| 2008-04-18 14:00:00 | ES | Futures | 1299.97 | 1300.2 | 1295.78 | 1296.71 | 83622.0 |
| 2008-04-18 14:30:00 | ES | Futures | 1296.71 | 1299.04 | 1296.47 | 1297.41 | 64483.0 |
| 2008-04-18 15:00:00 | ES | Futures | 1297.41 | 1297.41 | 1292.52 | 1292.98 | 123738.0 |
| 2008-04-18 15:30:00 | ES | Futures | 1292.98 | 1297.87 | 1292.75 | 1296.71 | 189951.0 |
| 2008-04-18 16:00:00 | ES | Futures | 1296.71 | 1297.17 | 1291.82 | 1292.05 | 91349.0 |
| 2008-04-18 00:00:00 | NQ | Futures | 2121.21 | 2121.21 | 2119.52 | 2120.93 | 71.0 |
| 2008-04-18 00:30:00 | NQ | Futures | 2120.37 | 2120.65 | 2119.52 | 2119.52 | 50.0 |
| 2008-04-18 01:00:00 | NQ | Futures | 2119.23 | 2119.8 | 2118.95 | 2119.23 | 8.0 |
| 2008-04-18 01:30:00 | NQ | Futures | 2120.08 | 2120.93 | 2120.08 | 2120.93 | 45.0 |
| 2008-04-18 02:00:00 | NQ | Futures | 2120.08 | 2120.08 | 2116.12 | 2118.67 | 480.0 |
| 2008-04-18 02:30:00 | NQ | Futures | 2117.26 | 2120.65 | 2117.26 | 2119.8 | 273.0 |
| 2008-04-18 03:00:00 | NQ | Futures | 2119.8 | 2123.48 | 2119.23 | 2122.91 | 1556.0 |
| 2008-04-18 03:30:00 | NQ | Futures | 2123.19 | 2124.33 | 2122.63 | 2123.48 | 721.0 |
| 2008-04-18 04:00:00 | NQ | Futures | 2123.76 | 2124.04 | 2121.21 | 2121.21 | 236.0 |
| 2008-04-18 04:30:00 | NQ | Futures | 2120.93 | 2120.93 | 2117.54 | 2117.82 | 1189.0 |
| 2008-04-18 05:00:00 | NQ | Futures | 2117.82 | 2122.06 | 2117.54 | 2120.93 | 447.0 |
| 2008-04-18 05:30:00 | NQ | Futures | 2121.21 | 2122.63 | 2120.65 | 2122.63 | 165.0 |
| 2008-04-18 06:00:00 | NQ | Futures | 2122.35 | 2126.31 | 2121.78 | 2125.46 | 710.0 |
| 2008-04-18 06:30:00 | NQ | Futures | 2125.74 | 2131.68 | 2124.61 | 2129.7 | 3085.0 |
| 2008-04-18 07:00:00 | NQ | Futures | 2129.42 | 2133.66 | 2129.42 | 2129.98 | 1805.0 |
| 2008-04-18 07:30:00 | NQ | Futures | 2129.42 | 2134.79 | 2129.13 | 2132.81 | 3428.0 |
| 2008-04-18 08:00:00 | NQ | Futures | 2133.09 | 2139.03 | 2131.96 | 2138.18 | 3327.0 |
> showing 50 of 1,866 rows — these rows as CSV