PREVIEW / futures_30min / 2011-03-07
file: by_date/futures_30min/2011/2011-03-07.parquet size: 73 KB rows: 2,583
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-07 00:00:00 | ES | Futures | 1300.97 | 1301.47 | 1300.23 | 1300.72 | 2303.0 |
| 2011-03-07 00:30:00 | ES | Futures | 1300.72 | 1301.96 | 1300.48 | 1301.47 | 1246.0 |
| 2011-03-07 01:00:00 | ES | Futures | 1301.47 | 1302.21 | 1300.72 | 1300.97 | 1684.0 |
| 2011-03-07 01:30:00 | ES | Futures | 1300.97 | 1301.71 | 1300.72 | 1301.47 | 2494.0 |
| 2011-03-07 02:00:00 | ES | Futures | 1301.22 | 1301.96 | 1300.48 | 1300.97 | 3257.0 |
| 2011-03-07 02:30:00 | ES | Futures | 1301.22 | 1302.7 | 1300.97 | 1302.7 | 5397.0 |
| 2011-03-07 03:00:00 | ES | Futures | 1302.46 | 1305.92 | 1301.96 | 1304.44 | 19897.0 |
| 2011-03-07 03:30:00 | ES | Futures | 1304.44 | 1308.15 | 1303.94 | 1307.4 | 16616.0 |
| 2011-03-07 04:00:00 | ES | Futures | 1307.65 | 1309.88 | 1306.66 | 1309.88 | 13150.0 |
| 2011-03-07 04:30:00 | ES | Futures | 1309.63 | 1309.88 | 1308.89 | 1309.63 | 8752.0 |
| 2011-03-07 05:00:00 | ES | Futures | 1309.38 | 1309.63 | 1307.4 | 1309.14 | 10030.0 |
| 2011-03-07 05:30:00 | ES | Futures | 1308.89 | 1309.14 | 1305.92 | 1307.16 | 15981.0 |
| 2011-03-07 06:00:00 | ES | Futures | 1307.4 | 1308.89 | 1306.17 | 1308.39 | 12929.0 |
| 2011-03-07 06:30:00 | ES | Futures | 1308.15 | 1311.86 | 1308.15 | 1311.12 | 30242.0 |
| 2011-03-07 07:00:00 | ES | Futures | 1311.12 | 1312.35 | 1310.13 | 1310.62 | 19758.0 |
| 2011-03-07 07:30:00 | ES | Futures | 1310.37 | 1310.37 | 1305.43 | 1305.67 | 38246.0 |
| 2011-03-07 08:00:00 | ES | Futures | 1305.43 | 1308.15 | 1304.44 | 1307.16 | 35011.0 |
| 2011-03-07 08:30:00 | ES | Futures | 1307.4 | 1308.89 | 1307.16 | 1308.64 | 17418.0 |
| 2011-03-07 09:00:00 | ES | Futures | 1308.89 | 1311.61 | 1308.64 | 1310.62 | 48808.0 |
| 2011-03-07 09:30:00 | ES | Futures | 1310.62 | 1313.59 | 1309.63 | 1312.35 | 243205.0 |
| 2011-03-07 10:00:00 | ES | Futures | 1312.35 | 1313.34 | 1306.91 | 1309.63 | 172016.0 |
| 2011-03-07 10:30:00 | ES | Futures | 1309.63 | 1310.13 | 1301.47 | 1302.21 | 260822.0 |
| 2011-03-07 11:00:00 | ES | Futures | 1302.21 | 1302.46 | 1298.0 | 1298.5 | 228004.0 |
| 2011-03-07 11:30:00 | ES | Futures | 1298.5 | 1298.99 | 1293.8 | 1295.28 | 268417.0 |
| 2011-03-07 12:00:00 | ES | Futures | 1295.28 | 1297.51 | 1293.8 | 1294.29 | 113955.0 |
| 2011-03-07 12:30:00 | ES | Futures | 1294.29 | 1296.02 | 1291.07 | 1291.57 | 131796.0 |
| 2011-03-07 13:00:00 | ES | Futures | 1291.57 | 1293.05 | 1289.34 | 1291.57 | 133077.0 |
| 2011-03-07 13:30:00 | ES | Futures | 1291.82 | 1293.8 | 1290.83 | 1292.06 | 95711.0 |
| 2011-03-07 14:00:00 | ES | Futures | 1292.06 | 1296.27 | 1290.83 | 1293.8 | 112097.0 |
| 2011-03-07 14:30:00 | ES | Futures | 1293.8 | 1295.28 | 1292.56 | 1294.29 | 75408.0 |
| 2011-03-07 15:00:00 | ES | Futures | 1294.54 | 1298.5 | 1293.05 | 1297.76 | 118647.0 |
| 2011-03-07 15:30:00 | ES | Futures | 1297.51 | 1300.23 | 1294.79 | 1296.27 | 246327.0 |
| 2011-03-07 16:00:00 | ES | Futures | 1296.27 | 1296.77 | 1295.28 | 1295.28 | 93677.0 |
| 2011-03-07 16:30:00 | ES | Futures | 1295.28 | 1296.52 | 1294.54 | 1296.27 | 6381.0 |
| 2011-03-07 17:00:00 | ES | Futures | 1296.02 | 1296.77 | 1295.78 | 1296.02 | 3096.0 |
| 2011-03-07 18:00:00 | ES | Futures | 1296.52 | 1297.01 | 1296.27 | 1296.52 | 2389.0 |
| 2011-03-07 18:30:00 | ES | Futures | 1296.27 | 1298.74 | 1296.27 | 1298.5 | 4337.0 |
| 2011-03-07 19:00:00 | ES | Futures | 1298.5 | 1298.99 | 1297.76 | 1298.5 | 3262.0 |
| 2011-03-07 19:30:00 | ES | Futures | 1298.5 | 1298.5 | 1296.77 | 1297.01 | 3511.0 |
| 2011-03-07 20:00:00 | ES | Futures | 1296.77 | 1298.74 | 1296.77 | 1298.25 | 3253.0 |
| 2011-03-07 20:30:00 | ES | Futures | 1298.5 | 1298.99 | 1297.76 | 1298.74 | 2618.0 |
| 2011-03-07 21:00:00 | ES | Futures | 1298.74 | 1298.74 | 1297.26 | 1298.25 | 1240.0 |
| 2011-03-07 21:30:00 | ES | Futures | 1298.25 | 1299.73 | 1298.25 | 1299.49 | 2331.0 |
| 2011-03-07 22:00:00 | ES | Futures | 1299.49 | 1299.49 | 1298.74 | 1299.24 | 1371.0 |
| 2011-03-07 22:30:00 | ES | Futures | 1299.24 | 1300.72 | 1298.99 | 1300.48 | 5434.0 |
| 2011-03-07 23:00:00 | ES | Futures | 1300.48 | 1300.97 | 1299.73 | 1300.23 | 1459.0 |
| 2011-03-07 23:30:00 | ES | Futures | 1299.98 | 1300.72 | 1299.98 | 1300.72 | 998.0 |
| 2011-03-07 00:00:00 | NQ | Futures | 2697.53 | 2697.82 | 2695.52 | 2695.81 | 76.0 |
| 2011-03-07 00:30:00 | NQ | Futures | 2696.38 | 2698.68 | 2696.1 | 2698.1 | 90.0 |
| 2011-03-07 01:00:00 | NQ | Futures | 2698.1 | 2700.11 | 2696.96 | 2697.24 | 224.0 |
> showing 50 of 2,583 rows — these rows as CSV