PREVIEW / futures_30min / 2012-02-07
file: by_date/futures_30min/2012/2012-02-07.parquet size: 76 KB rows: 2,794
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-07 00:00:00 | ES | Futures | 1349.4 | 1349.9 | 1349.14 | 1349.4 | 2119.0 |
| 2012-02-07 00:30:00 | ES | Futures | 1349.4 | 1349.65 | 1348.89 | 1349.4 | 1603.0 |
| 2012-02-07 01:00:00 | ES | Futures | 1349.65 | 1349.65 | 1348.89 | 1349.14 | 855.0 |
| 2012-02-07 01:30:00 | ES | Futures | 1349.14 | 1349.4 | 1348.64 | 1348.89 | 1264.0 |
| 2012-02-07 02:00:00 | ES | Futures | 1348.89 | 1350.66 | 1348.64 | 1350.66 | 2935.0 |
| 2012-02-07 02:30:00 | ES | Futures | 1350.66 | 1352.67 | 1350.4 | 1352.42 | 8400.0 |
| 2012-02-07 03:00:00 | ES | Futures | 1352.42 | 1353.18 | 1349.9 | 1350.15 | 15516.0 |
| 2012-02-07 03:30:00 | ES | Futures | 1350.15 | 1351.41 | 1349.4 | 1349.9 | 11700.0 |
| 2012-02-07 04:00:00 | ES | Futures | 1349.9 | 1349.9 | 1347.38 | 1348.89 | 15852.0 |
| 2012-02-07 04:30:00 | ES | Futures | 1348.64 | 1349.9 | 1348.14 | 1349.65 | 7837.0 |
| 2012-02-07 05:00:00 | ES | Futures | 1349.65 | 1350.15 | 1348.64 | 1348.89 | 6732.0 |
| 2012-02-07 05:30:00 | ES | Futures | 1348.89 | 1349.9 | 1347.88 | 1348.64 | 7125.0 |
| 2012-02-07 06:00:00 | ES | Futures | 1348.64 | 1348.89 | 1347.13 | 1347.88 | 11939.0 |
| 2012-02-07 06:30:00 | ES | Futures | 1347.88 | 1348.14 | 1345.87 | 1345.87 | 15304.0 |
| 2012-02-07 07:00:00 | ES | Futures | 1346.12 | 1346.12 | 1343.85 | 1345.11 | 21296.0 |
| 2012-02-07 07:30:00 | ES | Futures | 1345.11 | 1346.37 | 1344.61 | 1345.11 | 18933.0 |
| 2012-02-07 08:00:00 | ES | Futures | 1345.36 | 1346.62 | 1344.36 | 1345.87 | 17584.0 |
| 2012-02-07 08:30:00 | ES | Futures | 1346.12 | 1348.89 | 1345.36 | 1346.88 | 63079.0 |
| 2012-02-07 09:00:00 | ES | Futures | 1347.13 | 1348.39 | 1346.12 | 1347.63 | 29883.0 |
| 2012-02-07 09:30:00 | ES | Futures | 1347.88 | 1349.14 | 1343.6 | 1345.36 | 181792.0 |
| 2012-02-07 10:00:00 | ES | Futures | 1345.36 | 1347.63 | 1342.34 | 1346.37 | 151489.0 |
| 2012-02-07 10:30:00 | ES | Futures | 1346.37 | 1352.17 | 1346.37 | 1351.92 | 131814.0 |
| 2012-02-07 11:00:00 | ES | Futures | 1351.92 | 1354.44 | 1351.41 | 1354.44 | 121909.0 |
| 2012-02-07 11:30:00 | ES | Futures | 1354.18 | 1354.44 | 1352.17 | 1352.67 | 101432.0 |
| 2012-02-07 12:00:00 | ES | Futures | 1352.92 | 1354.18 | 1352.67 | 1353.18 | 46828.0 |
| 2012-02-07 12:30:00 | ES | Futures | 1352.92 | 1354.18 | 1352.67 | 1353.93 | 15313.0 |
| 2012-02-07 13:00:00 | ES | Futures | 1353.93 | 1355.19 | 1351.92 | 1353.43 | 73053.0 |
| 2012-02-07 13:30:00 | ES | Futures | 1353.68 | 1354.94 | 1352.42 | 1354.18 | 39883.0 |
| 2012-02-07 14:00:00 | ES | Futures | 1354.44 | 1354.69 | 1352.67 | 1353.18 | 35064.0 |
| 2012-02-07 14:30:00 | ES | Futures | 1353.18 | 1354.44 | 1351.41 | 1352.17 | 36220.0 |
| 2012-02-07 15:00:00 | ES | Futures | 1352.17 | 1356.2 | 1351.92 | 1355.95 | 74061.0 |
| 2012-02-07 15:30:00 | ES | Futures | 1355.7 | 1356.45 | 1353.68 | 1353.93 | 127374.0 |
| 2012-02-07 16:00:00 | ES | Futures | 1353.93 | 1355.7 | 1353.68 | 1355.44 | 62074.0 |
| 2012-02-07 16:30:00 | ES | Futures | 1354.94 | 1355.19 | 1353.93 | 1354.94 | 4914.0 |
| 2012-02-07 17:00:00 | ES | Futures | 1354.94 | 1355.19 | 1354.44 | 1354.44 | 1093.0 |
| 2012-02-07 18:00:00 | ES | Futures | 1354.18 | 1354.94 | 1353.93 | 1353.93 | 3125.0 |
| 2012-02-07 18:30:00 | ES | Futures | 1354.18 | 1354.18 | 1353.18 | 1353.68 | 2160.0 |
| 2012-02-07 19:00:00 | ES | Futures | 1353.43 | 1354.44 | 1353.43 | 1354.18 | 2194.0 |
| 2012-02-07 19:30:00 | ES | Futures | 1354.18 | 1354.44 | 1354.18 | 1354.44 | 999.0 |
| 2012-02-07 20:00:00 | ES | Futures | 1354.44 | 1354.69 | 1354.18 | 1354.18 | 1099.0 |
| 2012-02-07 20:30:00 | ES | Futures | 1354.18 | 1354.44 | 1353.93 | 1354.18 | 923.0 |
| 2012-02-07 21:00:00 | ES | Futures | 1354.18 | 1354.94 | 1354.18 | 1354.69 | 1342.0 |
| 2012-02-07 21:30:00 | ES | Futures | 1354.94 | 1354.94 | 1354.18 | 1354.94 | 1083.0 |
| 2012-02-07 22:00:00 | ES | Futures | 1354.69 | 1355.19 | 1354.69 | 1354.94 | 1425.0 |
| 2012-02-07 22:30:00 | ES | Futures | 1355.19 | 1355.44 | 1354.69 | 1355.19 | 1917.0 |
| 2012-02-07 23:00:00 | ES | Futures | 1355.19 | 1355.7 | 1355.19 | 1355.19 | 1033.0 |
| 2012-02-07 23:30:00 | ES | Futures | 1355.44 | 1355.7 | 1355.19 | 1355.44 | 869.0 |
| 2012-02-07 00:00:00 | NQ | Futures | 2916.57 | 2917.73 | 2916.29 | 2916.57 | 95.0 |
| 2012-02-07 00:30:00 | NQ | Futures | 2916.0 | 2917.15 | 2915.71 | 2916.86 | 127.0 |
| 2012-02-07 01:00:00 | NQ | Futures | 2916.86 | 2917.73 | 2916.29 | 2916.57 | 91.0 |
> showing 50 of 2,794 rows — these rows as CSV