PREVIEW / futures_30min / 2010-11-09
file: by_date/futures_30min/2010/2010-11-09.parquet size: 80 KB rows: 2,741
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-11-09 00:00:00 | ES | Futures | 1199.37 | 1199.37 | 1198.63 | 1198.87 | 2246.0 |
| 2010-11-09 00:30:00 | ES | Futures | 1198.63 | 1199.12 | 1198.13 | 1198.63 | 2523.0 |
| 2010-11-09 01:00:00 | ES | Futures | 1198.87 | 1199.61 | 1198.87 | 1199.37 | 1157.0 |
| 2010-11-09 01:30:00 | ES | Futures | 1199.61 | 1199.86 | 1198.87 | 1199.37 | 1417.0 |
| 2010-11-09 02:00:00 | ES | Futures | 1199.12 | 1199.61 | 1198.63 | 1198.87 | 5738.0 |
| 2010-11-09 02:30:00 | ES | Futures | 1198.87 | 1199.61 | 1198.13 | 1198.63 | 7102.0 |
| 2010-11-09 03:00:00 | ES | Futures | 1198.38 | 1199.37 | 1197.64 | 1198.13 | 15066.0 |
| 2010-11-09 03:30:00 | ES | Futures | 1198.13 | 1200.35 | 1198.13 | 1200.35 | 14289.0 |
| 2010-11-09 04:00:00 | ES | Futures | 1200.11 | 1201.09 | 1199.37 | 1200.6 | 14097.0 |
| 2010-11-09 04:30:00 | ES | Futures | 1200.6 | 1202.82 | 1200.35 | 1202.57 | 17338.0 |
| 2010-11-09 05:00:00 | ES | Futures | 1202.57 | 1204.3 | 1202.32 | 1203.31 | 18458.0 |
| 2010-11-09 05:30:00 | ES | Futures | 1203.31 | 1204.79 | 1203.31 | 1204.54 | 11694.0 |
| 2010-11-09 06:00:00 | ES | Futures | 1204.3 | 1204.79 | 1203.8 | 1204.79 | 6679.0 |
| 2010-11-09 06:30:00 | ES | Futures | 1204.54 | 1206.02 | 1204.3 | 1205.77 | 20123.0 |
| 2010-11-09 07:00:00 | ES | Futures | 1206.02 | 1206.76 | 1205.28 | 1205.28 | 25874.0 |
| 2010-11-09 07:30:00 | ES | Futures | 1205.53 | 1206.51 | 1205.04 | 1205.28 | 17313.0 |
| 2010-11-09 08:00:00 | ES | Futures | 1205.53 | 1205.77 | 1205.04 | 1205.28 | 12078.0 |
| 2010-11-09 08:30:00 | ES | Futures | 1205.28 | 1205.53 | 1204.3 | 1205.04 | 20044.0 |
| 2010-11-09 09:00:00 | ES | Futures | 1205.28 | 1206.27 | 1204.54 | 1206.27 | 22725.0 |
| 2010-11-09 09:30:00 | ES | Futures | 1206.02 | 1206.27 | 1201.83 | 1204.54 | 179311.0 |
| 2010-11-09 10:00:00 | ES | Futures | 1204.3 | 1207.5 | 1204.05 | 1206.02 | 156632.0 |
| 2010-11-09 10:30:00 | ES | Futures | 1206.02 | 1206.51 | 1202.82 | 1204.3 | 148871.0 |
| 2010-11-09 11:00:00 | ES | Futures | 1204.05 | 1204.54 | 1202.08 | 1203.31 | 104692.0 |
| 2010-11-09 11:30:00 | ES | Futures | 1203.56 | 1203.8 | 1199.61 | 1199.61 | 100539.0 |
| 2010-11-09 12:00:00 | ES | Futures | 1199.61 | 1201.34 | 1199.61 | 1200.6 | 76919.0 |
| 2010-11-09 12:30:00 | ES | Futures | 1200.6 | 1201.34 | 1199.12 | 1199.86 | 70553.0 |
| 2010-11-09 13:00:00 | ES | Futures | 1199.86 | 1202.32 | 1198.38 | 1198.87 | 103690.0 |
| 2010-11-09 13:30:00 | ES | Futures | 1198.87 | 1199.61 | 1195.18 | 1196.65 | 197805.0 |
| 2010-11-09 14:00:00 | ES | Futures | 1196.65 | 1199.37 | 1196.41 | 1197.64 | 116838.0 |
| 2010-11-09 14:30:00 | ES | Futures | 1197.64 | 1199.86 | 1197.64 | 1198.38 | 84908.0 |
| 2010-11-09 15:00:00 | ES | Futures | 1198.13 | 1198.38 | 1194.44 | 1195.18 | 209486.0 |
| 2010-11-09 15:30:00 | ES | Futures | 1194.93 | 1196.16 | 1189.26 | 1193.94 | 378469.0 |
| 2010-11-09 16:00:00 | ES | Futures | 1194.19 | 1194.68 | 1193.45 | 1193.7 | 105472.0 |
| 2010-11-09 16:30:00 | ES | Futures | 1193.45 | 1193.7 | 1192.46 | 1193.45 | 6385.0 |
| 2010-11-09 17:00:00 | ES | Futures | 1193.45 | 1193.45 | 1192.71 | 1192.71 | 2701.0 |
| 2010-11-09 18:00:00 | ES | Futures | 1192.71 | 1193.45 | 1191.48 | 1191.97 | 5749.0 |
| 2010-11-09 18:30:00 | ES | Futures | 1191.97 | 1194.44 | 1191.73 | 1194.44 | 3940.0 |
| 2010-11-09 19:00:00 | ES | Futures | 1194.19 | 1195.18 | 1192.96 | 1193.7 | 6231.0 |
| 2010-11-09 19:30:00 | ES | Futures | 1193.7 | 1195.18 | 1193.7 | 1194.93 | 3761.0 |
| 2010-11-09 20:00:00 | ES | Futures | 1194.93 | 1195.18 | 1194.19 | 1194.93 | 2208.0 |
| 2010-11-09 20:30:00 | ES | Futures | 1194.93 | 1195.18 | 1194.19 | 1194.44 | 2420.0 |
| 2010-11-09 21:00:00 | ES | Futures | 1194.44 | 1195.18 | 1193.45 | 1193.7 | 2373.0 |
| 2010-11-09 21:30:00 | ES | Futures | 1193.7 | 1193.7 | 1192.22 | 1192.96 | 3161.0 |
| 2010-11-09 22:00:00 | ES | Futures | 1192.71 | 1192.96 | 1190.99 | 1192.46 | 4264.0 |
| 2010-11-09 22:30:00 | ES | Futures | 1192.46 | 1192.96 | 1190.99 | 1191.23 | 4361.0 |
| 2010-11-09 23:00:00 | ES | Futures | 1191.48 | 1192.96 | 1190.99 | 1192.22 | 2673.0 |
| 2010-11-09 23:30:00 | ES | Futures | 1192.22 | 1193.7 | 1192.22 | 1193.2 | 2851.0 |
| 2010-11-09 00:00:00 | NQ | Futures | 2500.36 | 2501.22 | 2500.07 | 2500.93 | 52.0 |
| 2010-11-09 00:30:00 | NQ | Futures | 2501.22 | 2501.22 | 2499.78 | 2500.64 | 86.0 |
| 2010-11-09 01:00:00 | NQ | Futures | 2500.64 | 2502.65 | 2500.64 | 2502.08 | 48.0 |
> showing 50 of 2,741 rows — these rows as CSV