PREVIEW / futures_30min / 2008-01-14
file: by_date/futures_30min/2008/2008-01-14.parquet size: 41 KB rows: 1,384
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-01-14 00:00:00 | ES | Futures | 1316.17 | 1316.4 | 1315.7 | 1315.93 | 560.0 |
| 2008-01-14 00:30:00 | ES | Futures | 1315.93 | 1315.93 | 1313.84 | 1314.07 | 1407.0 |
| 2008-01-14 01:00:00 | ES | Futures | 1313.84 | 1314.3 | 1313.14 | 1314.07 | 636.0 |
| 2008-01-14 01:30:00 | ES | Futures | 1314.07 | 1314.53 | 1313.84 | 1314.53 | 471.0 |
| 2008-01-14 02:00:00 | ES | Futures | 1314.53 | 1315.93 | 1305.44 | 1314.3 | 19525.0 |
| 2008-01-14 02:30:00 | ES | Futures | 1314.3 | 1314.53 | 1308.47 | 1313.14 | 8019.0 |
| 2008-01-14 03:00:00 | ES | Futures | 1312.9 | 1315.47 | 1312.44 | 1314.3 | 7914.0 |
| 2008-01-14 03:30:00 | ES | Futures | 1314.3 | 1318.03 | 1314.3 | 1317.33 | 7479.0 |
| 2008-01-14 04:00:00 | ES | Futures | 1317.33 | 1318.73 | 1315.47 | 1315.93 | 6953.0 |
| 2008-01-14 04:30:00 | ES | Futures | 1315.7 | 1316.17 | 1314.3 | 1315.23 | 4374.0 |
| 2008-01-14 05:00:00 | ES | Futures | 1315.0 | 1317.33 | 1315.0 | 1316.63 | 3114.0 |
| 2008-01-14 05:30:00 | ES | Futures | 1316.87 | 1318.73 | 1316.4 | 1317.57 | 5058.0 |
| 2008-01-14 06:00:00 | ES | Futures | 1317.33 | 1317.33 | 1315.93 | 1316.17 | 5570.0 |
| 2008-01-14 06:30:00 | ES | Futures | 1316.4 | 1316.4 | 1314.3 | 1315.0 | 5341.0 |
| 2008-01-14 07:00:00 | ES | Futures | 1315.0 | 1316.87 | 1314.53 | 1316.87 | 6644.0 |
| 2008-01-14 07:30:00 | ES | Futures | 1316.87 | 1322.93 | 1316.63 | 1321.53 | 29960.0 |
| 2008-01-14 08:00:00 | ES | Futures | 1321.53 | 1323.16 | 1320.83 | 1322.0 | 15891.0 |
| 2008-01-14 08:30:00 | ES | Futures | 1322.23 | 1323.16 | 1321.3 | 1322.93 | 9454.0 |
| 2008-01-14 09:00:00 | ES | Futures | 1322.93 | 1323.39 | 1321.76 | 1323.16 | 11424.0 |
| 2008-01-14 09:30:00 | ES | Futures | 1323.16 | 1324.09 | 1316.17 | 1318.27 | 189159.0 |
| 2008-01-14 10:00:00 | ES | Futures | 1318.27 | 1321.53 | 1315.93 | 1320.36 | 115051.0 |
| 2008-01-14 10:30:00 | ES | Futures | 1320.36 | 1322.93 | 1319.2 | 1322.69 | 92806.0 |
| 2008-01-14 11:00:00 | ES | Futures | 1322.46 | 1324.79 | 1320.6 | 1321.76 | 102468.0 |
| 2008-01-14 11:30:00 | ES | Futures | 1321.76 | 1322.0 | 1319.9 | 1319.9 | 55580.0 |
| 2008-01-14 12:00:00 | ES | Futures | 1320.13 | 1320.83 | 1317.33 | 1317.33 | 62192.0 |
| 2008-01-14 12:30:00 | ES | Futures | 1317.33 | 1320.36 | 1316.87 | 1319.43 | 49321.0 |
| 2008-01-14 13:00:00 | ES | Futures | 1319.43 | 1321.06 | 1318.27 | 1319.2 | 47896.0 |
| 2008-01-14 13:30:00 | ES | Futures | 1319.2 | 1324.33 | 1318.5 | 1323.39 | 73493.0 |
| 2008-01-14 14:00:00 | ES | Futures | 1323.39 | 1324.09 | 1320.13 | 1322.0 | 50399.0 |
| 2008-01-14 14:30:00 | ES | Futures | 1322.0 | 1326.43 | 1321.76 | 1326.43 | 115948.0 |
| 2008-01-14 15:00:00 | ES | Futures | 1326.43 | 1327.36 | 1322.46 | 1324.33 | 94969.0 |
| 2008-01-14 15:30:00 | ES | Futures | 1324.33 | 1328.52 | 1322.69 | 1326.19 | 140665.0 |
| 2008-01-14 16:00:00 | ES | Futures | 1326.19 | 1326.43 | 1324.56 | 1324.79 | 68786.0 |
| 2008-01-14 16:30:00 | ES | Futures | 1325.26 | 1325.49 | 1324.09 | 1325.03 | 2936.0 |
| 2008-01-14 17:00:00 | ES | Futures | 1325.03 | 1325.49 | 1324.56 | 1325.26 | 995.0 |
| 2008-01-14 18:00:00 | ES | Futures | 1325.73 | 1326.66 | 1325.73 | 1325.96 | 1276.0 |
| 2008-01-14 18:30:00 | ES | Futures | 1325.73 | 1326.19 | 1325.03 | 1325.26 | 571.0 |
| 2008-01-14 19:00:00 | ES | Futures | 1325.03 | 1325.03 | 1322.93 | 1323.63 | 2262.0 |
| 2008-01-14 19:30:00 | ES | Futures | 1323.63 | 1324.56 | 1323.39 | 1323.86 | 1013.0 |
| 2008-01-14 20:00:00 | ES | Futures | 1323.86 | 1324.33 | 1323.39 | 1323.63 | 631.0 |
| 2008-01-14 20:30:00 | ES | Futures | 1323.39 | 1324.33 | 1323.39 | 1323.86 | 1011.0 |
| 2008-01-14 21:00:00 | ES | Futures | 1323.86 | 1324.09 | 1323.39 | 1323.63 | 746.0 |
| 2008-01-14 21:30:00 | ES | Futures | 1323.63 | 1323.63 | 1322.69 | 1322.69 | 734.0 |
| 2008-01-14 22:00:00 | ES | Futures | 1322.46 | 1322.69 | 1322.0 | 1322.46 | 618.0 |
| 2008-01-14 22:30:00 | ES | Futures | 1322.23 | 1322.46 | 1320.13 | 1320.36 | 3730.0 |
| 2008-01-14 23:00:00 | ES | Futures | 1320.36 | 1321.06 | 1319.9 | 1320.6 | 2020.0 |
| 2008-01-14 23:30:00 | ES | Futures | 1320.6 | 1320.6 | 1319.66 | 1319.9 | 626.0 |
| 2008-01-14 00:00:00 | NQ | Futures | 2192.98 | 2193.26 | 2192.41 | 2192.41 | 10.0 |
| 2008-01-14 00:30:00 | NQ | Futures | 2192.41 | 2194.11 | 2190.14 | 2190.14 | 85.0 |
| 2008-01-14 01:00:00 | NQ | Futures | 2191.27 | 2191.56 | 2189.0 | 2190.99 | 94.0 |
> showing 50 of 1,384 rows — these rows as CSV