PREVIEW / futures_30min / 2010-12-07
file: by_date/futures_30min/2010/2010-12-07.parquet size: 82 KB rows: 2,708
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-07 00:00:00 | ES | Futures | 1207.5 | 1207.75 | 1207.01 | 1207.25 | 954.0 |
| 2010-12-07 00:30:00 | ES | Futures | 1207.01 | 1207.25 | 1206.51 | 1207.25 | 1427.0 |
| 2010-12-07 01:00:00 | ES | Futures | 1207.01 | 1207.75 | 1206.76 | 1207.01 | 1712.0 |
| 2010-12-07 01:30:00 | ES | Futures | 1207.25 | 1208.24 | 1207.01 | 1207.75 | 2809.0 |
| 2010-12-07 02:00:00 | ES | Futures | 1207.99 | 1208.24 | 1206.51 | 1207.01 | 4052.0 |
| 2010-12-07 02:30:00 | ES | Futures | 1206.76 | 1208.24 | 1206.76 | 1207.75 | 3798.0 |
| 2010-12-07 03:00:00 | ES | Futures | 1207.75 | 1209.96 | 1207.75 | 1208.98 | 15541.0 |
| 2010-12-07 03:30:00 | ES | Futures | 1208.98 | 1210.21 | 1207.5 | 1209.96 | 12224.0 |
| 2010-12-07 04:00:00 | ES | Futures | 1209.72 | 1212.43 | 1209.47 | 1212.18 | 17946.0 |
| 2010-12-07 04:30:00 | ES | Futures | 1212.18 | 1215.88 | 1211.44 | 1215.39 | 28266.0 |
| 2010-12-07 05:00:00 | ES | Futures | 1215.39 | 1216.62 | 1214.65 | 1215.14 | 17974.0 |
| 2010-12-07 05:30:00 | ES | Futures | 1215.14 | 1216.87 | 1214.4 | 1216.62 | 17647.0 |
| 2010-12-07 06:00:00 | ES | Futures | 1216.62 | 1216.62 | 1214.65 | 1216.13 | 23303.0 |
| 2010-12-07 06:30:00 | ES | Futures | 1216.37 | 1216.62 | 1214.4 | 1215.39 | 16252.0 |
| 2010-12-07 07:00:00 | ES | Futures | 1215.39 | 1216.62 | 1214.65 | 1214.65 | 13178.0 |
| 2010-12-07 07:30:00 | ES | Futures | 1214.89 | 1216.62 | 1214.65 | 1215.63 | 12611.0 |
| 2010-12-07 08:00:00 | ES | Futures | 1215.63 | 1216.62 | 1215.39 | 1216.13 | 19764.0 |
| 2010-12-07 08:30:00 | ES | Futures | 1216.13 | 1217.36 | 1215.63 | 1216.62 | 27699.0 |
| 2010-12-07 09:00:00 | ES | Futures | 1216.87 | 1217.61 | 1216.13 | 1216.87 | 35939.0 |
| 2010-12-07 09:30:00 | ES | Futures | 1217.11 | 1217.61 | 1213.66 | 1213.91 | 238333.0 |
| 2010-12-07 10:00:00 | ES | Futures | 1213.66 | 1214.4 | 1211.69 | 1211.94 | 229956.0 |
| 2010-12-07 10:30:00 | ES | Futures | 1212.18 | 1213.91 | 1210.7 | 1212.92 | 142918.0 |
| 2010-12-07 11:00:00 | ES | Futures | 1212.92 | 1213.66 | 1210.95 | 1211.69 | 118110.0 |
| 2010-12-07 11:30:00 | ES | Futures | 1211.69 | 1212.68 | 1210.7 | 1211.2 | 100238.0 |
| 2010-12-07 12:00:00 | ES | Futures | 1211.2 | 1211.94 | 1209.47 | 1211.2 | 109532.0 |
| 2010-12-07 12:30:00 | ES | Futures | 1211.2 | 1212.68 | 1210.46 | 1212.18 | 54085.0 |
| 2010-12-07 13:00:00 | ES | Futures | 1212.43 | 1213.66 | 1211.69 | 1213.17 | 85104.0 |
| 2010-12-07 13:30:00 | ES | Futures | 1213.42 | 1214.4 | 1211.94 | 1212.92 | 71634.0 |
| 2010-12-07 14:00:00 | ES | Futures | 1212.92 | 1214.15 | 1212.43 | 1213.66 | 61117.0 |
| 2010-12-07 14:30:00 | ES | Futures | 1213.91 | 1215.88 | 1208.73 | 1209.47 | 198182.0 |
| 2010-12-07 15:00:00 | ES | Futures | 1209.47 | 1210.46 | 1206.02 | 1208.49 | 264004.0 |
| 2010-12-07 15:30:00 | ES | Futures | 1208.24 | 1209.96 | 1205.28 | 1205.77 | 239436.0 |
| 2010-12-07 16:00:00 | ES | Futures | 1206.02 | 1207.25 | 1204.79 | 1205.28 | 95402.0 |
| 2010-12-07 16:30:00 | ES | Futures | 1205.53 | 1206.02 | 1204.05 | 1204.3 | 7261.0 |
| 2010-12-07 17:00:00 | ES | Futures | 1204.3 | 1204.54 | 1202.08 | 1202.82 | 8510.0 |
| 2010-12-07 18:00:00 | ES | Futures | 1202.57 | 1205.28 | 1202.32 | 1205.28 | 6380.0 |
| 2010-12-07 18:30:00 | ES | Futures | 1205.28 | 1205.28 | 1204.05 | 1204.79 | 2120.0 |
| 2010-12-07 19:00:00 | ES | Futures | 1204.79 | 1205.77 | 1204.54 | 1205.53 | 1787.0 |
| 2010-12-07 19:30:00 | ES | Futures | 1205.53 | 1206.51 | 1205.04 | 1206.02 | 3335.0 |
| 2010-12-07 20:00:00 | ES | Futures | 1206.02 | 1206.76 | 1205.53 | 1206.51 | 1894.0 |
| 2010-12-07 20:30:00 | ES | Futures | 1206.51 | 1206.51 | 1204.54 | 1205.53 | 4953.0 |
| 2010-12-07 21:00:00 | ES | Futures | 1205.77 | 1206.02 | 1205.04 | 1205.04 | 1138.0 |
| 2010-12-07 21:30:00 | ES | Futures | 1205.28 | 1205.28 | 1203.8 | 1204.05 | 2562.0 |
| 2010-12-07 22:00:00 | ES | Futures | 1204.05 | 1204.05 | 1202.82 | 1203.06 | 3102.0 |
| 2010-12-07 22:30:00 | ES | Futures | 1203.06 | 1204.79 | 1203.06 | 1204.54 | 2260.0 |
| 2010-12-07 23:00:00 | ES | Futures | 1204.3 | 1204.79 | 1203.56 | 1203.8 | 1649.0 |
| 2010-12-07 23:30:00 | ES | Futures | 1203.56 | 1203.8 | 1202.08 | 1202.57 | 4296.0 |
| 2010-12-07 00:00:00 | NQ | Futures | 2519.58 | 2519.86 | 2518.72 | 2519.29 | 41.0 |
| 2010-12-07 00:30:00 | NQ | Futures | 2519.0 | 2519.0 | 2516.71 | 2517.86 | 238.0 |
| 2010-12-07 01:00:00 | NQ | Futures | 2517.86 | 2519.0 | 2517.57 | 2518.14 | 100.0 |
> showing 50 of 2,708 rows — these rows as CSV