PREVIEW / futures_30min / 2010-12-08
file: by_date/futures_30min/2010/2010-12-08.parquet size: 77 KB rows: 2,668
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-08 00:00:00 | ES | Futures | 1202.32 | 1202.82 | 1202.32 | 1202.32 | 1000.0 |
| 2010-12-08 00:30:00 | ES | Futures | 1202.32 | 1202.82 | 1201.34 | 1201.83 | 4562.0 |
| 2010-12-08 01:00:00 | ES | Futures | 1201.58 | 1203.31 | 1201.58 | 1202.82 | 3665.0 |
| 2010-12-08 01:30:00 | ES | Futures | 1203.06 | 1203.06 | 1200.6 | 1201.58 | 6991.0 |
| 2010-12-08 02:00:00 | ES | Futures | 1201.58 | 1201.83 | 1200.35 | 1200.6 | 6169.0 |
| 2010-12-08 02:30:00 | ES | Futures | 1200.6 | 1202.82 | 1200.11 | 1202.32 | 8500.0 |
| 2010-12-08 03:00:00 | ES | Futures | 1202.57 | 1203.8 | 1201.83 | 1203.31 | 18711.0 |
| 2010-12-08 03:30:00 | ES | Futures | 1203.31 | 1204.79 | 1202.57 | 1202.82 | 15040.0 |
| 2010-12-08 04:00:00 | ES | Futures | 1202.82 | 1203.8 | 1201.34 | 1203.31 | 12048.0 |
| 2010-12-08 04:30:00 | ES | Futures | 1203.56 | 1206.02 | 1203.56 | 1205.53 | 12533.0 |
| 2010-12-08 05:00:00 | ES | Futures | 1205.28 | 1205.77 | 1204.3 | 1205.53 | 12847.0 |
| 2010-12-08 05:30:00 | ES | Futures | 1205.28 | 1205.53 | 1203.8 | 1204.3 | 21163.0 |
| 2010-12-08 06:00:00 | ES | Futures | 1204.3 | 1205.28 | 1203.31 | 1203.56 | 13675.0 |
| 2010-12-08 06:30:00 | ES | Futures | 1203.56 | 1205.04 | 1203.31 | 1203.56 | 10458.0 |
| 2010-12-08 07:00:00 | ES | Futures | 1203.56 | 1206.27 | 1203.06 | 1206.27 | 17359.0 |
| 2010-12-08 07:30:00 | ES | Futures | 1206.27 | 1206.27 | 1204.3 | 1204.79 | 19601.0 |
| 2010-12-08 08:00:00 | ES | Futures | 1204.79 | 1207.99 | 1204.79 | 1207.25 | 25280.0 |
| 2010-12-08 08:30:00 | ES | Futures | 1207.25 | 1209.23 | 1206.76 | 1207.99 | 31972.0 |
| 2010-12-08 09:00:00 | ES | Futures | 1207.99 | 1208.73 | 1206.51 | 1207.5 | 33853.0 |
| 2010-12-08 09:30:00 | ES | Futures | 1207.5 | 1211.44 | 1207.01 | 1208.98 | 172014.0 |
| 2010-12-08 10:00:00 | ES | Futures | 1208.98 | 1208.98 | 1204.05 | 1205.77 | 215424.0 |
| 2010-12-08 10:30:00 | ES | Futures | 1206.02 | 1206.02 | 1201.83 | 1205.04 | 231851.0 |
| 2010-12-08 11:00:00 | ES | Futures | 1204.79 | 1206.76 | 1204.3 | 1206.02 | 97006.0 |
| 2010-12-08 11:30:00 | ES | Futures | 1206.02 | 1208.73 | 1205.04 | 1208.24 | 93227.0 |
| 2010-12-08 12:00:00 | ES | Futures | 1208.49 | 1208.98 | 1207.75 | 1208.24 | 64841.0 |
| 2010-12-08 12:30:00 | ES | Futures | 1207.99 | 1208.24 | 1205.28 | 1206.51 | 67188.0 |
| 2010-12-08 13:00:00 | ES | Futures | 1206.51 | 1209.23 | 1206.02 | 1207.25 | 92189.0 |
| 2010-12-08 13:30:00 | ES | Futures | 1207.25 | 1209.96 | 1207.01 | 1208.73 | 73888.0 |
| 2010-12-08 14:00:00 | ES | Futures | 1208.98 | 1209.96 | 1207.75 | 1208.98 | 54012.0 |
| 2010-12-08 14:30:00 | ES | Futures | 1209.23 | 1211.44 | 1208.98 | 1209.72 | 84076.0 |
| 2010-12-08 15:00:00 | ES | Futures | 1209.72 | 1210.46 | 1207.75 | 1207.99 | 85100.0 |
| 2010-12-08 15:30:00 | ES | Futures | 1207.99 | 1211.44 | 1207.5 | 1210.21 | 142567.0 |
| 2010-12-08 16:00:00 | ES | Futures | 1210.46 | 1211.94 | 1209.47 | 1211.2 | 85095.0 |
| 2010-12-08 16:30:00 | ES | Futures | 1211.2 | 1212.92 | 1210.95 | 1212.68 | 7250.0 |
| 2010-12-08 17:00:00 | ES | Futures | 1212.68 | 1212.92 | 1212.43 | 1212.43 | 1521.0 |
| 2010-12-08 18:00:00 | ES | Futures | 1212.68 | 1213.17 | 1211.69 | 1212.92 | 4458.0 |
| 2010-12-08 18:30:00 | ES | Futures | 1212.92 | 1215.63 | 1212.92 | 1215.63 | 9129.0 |
| 2010-12-08 19:00:00 | ES | Futures | 1215.14 | 1215.88 | 1214.65 | 1215.88 | 4012.0 |
| 2010-12-08 19:30:00 | ES | Futures | 1215.88 | 1216.37 | 1215.63 | 1216.13 | 5142.0 |
| 2010-12-08 20:00:00 | ES | Futures | 1215.88 | 1216.37 | 1215.14 | 1215.88 | 3335.0 |
| 2010-12-08 20:30:00 | ES | Futures | 1215.88 | 1216.37 | 1214.65 | 1215.39 | 4414.0 |
| 2010-12-08 21:00:00 | ES | Futures | 1215.63 | 1216.62 | 1215.39 | 1216.13 | 2425.0 |
| 2010-12-08 21:30:00 | ES | Futures | 1216.37 | 1216.37 | 1215.39 | 1215.88 | 1528.0 |
| 2010-12-08 22:00:00 | ES | Futures | 1215.63 | 1215.88 | 1214.65 | 1214.89 | 1920.0 |
| 2010-12-08 22:30:00 | ES | Futures | 1214.89 | 1215.63 | 1214.65 | 1215.39 | 1242.0 |
| 2010-12-08 23:00:00 | ES | Futures | 1215.39 | 1216.37 | 1215.39 | 1216.37 | 1585.0 |
| 2010-12-08 23:30:00 | ES | Futures | 1216.13 | 1217.11 | 1216.13 | 1216.62 | 2003.0 |
| 2010-12-08 00:00:00 | NQ | Futures | 2507.81 | 2508.1 | 2507.53 | 2507.81 | 37.0 |
| 2010-12-08 00:30:00 | NQ | Futures | 2507.53 | 2507.53 | 2505.52 | 2505.81 | 207.0 |
| 2010-12-08 01:00:00 | NQ | Futures | 2505.52 | 2507.53 | 2504.66 | 2507.24 | 191.0 |
> showing 50 of 2,668 rows — these rows as CSV