PREVIEW / futures_30min / 2011-10-13
file: by_date/futures_30min/2011/2011-10-13.parquet size: 78 KB rows: 2,739
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-13 00:00:00 | ES | Futures | 1202.38 | 1203.39 | 1201.63 | 1202.38 | 1959.0 |
| 2011-10-13 00:30:00 | ES | Futures | 1202.64 | 1203.39 | 1202.13 | 1202.38 | 1388.0 |
| 2011-10-13 01:00:00 | ES | Futures | 1202.38 | 1203.14 | 1201.63 | 1201.88 | 1959.0 |
| 2011-10-13 01:30:00 | ES | Futures | 1202.13 | 1202.13 | 1199.12 | 1199.88 | 5193.0 |
| 2011-10-13 02:00:00 | ES | Futures | 1200.13 | 1200.63 | 1197.87 | 1198.87 | 9597.0 |
| 2011-10-13 02:30:00 | ES | Futures | 1198.87 | 1201.38 | 1198.87 | 1199.88 | 4533.0 |
| 2011-10-13 03:00:00 | ES | Futures | 1199.88 | 1205.14 | 1199.63 | 1204.64 | 20839.0 |
| 2011-10-13 03:30:00 | ES | Futures | 1204.64 | 1207.9 | 1203.64 | 1206.4 | 23718.0 |
| 2011-10-13 04:00:00 | ES | Futures | 1206.4 | 1206.65 | 1199.12 | 1199.88 | 31104.0 |
| 2011-10-13 04:30:00 | ES | Futures | 1199.88 | 1200.88 | 1196.87 | 1197.87 | 23835.0 |
| 2011-10-13 05:00:00 | ES | Futures | 1198.12 | 1200.63 | 1197.62 | 1198.62 | 14839.0 |
| 2011-10-13 05:30:00 | ES | Futures | 1198.62 | 1198.87 | 1195.11 | 1196.87 | 31405.0 |
| 2011-10-13 06:00:00 | ES | Futures | 1196.87 | 1198.12 | 1194.36 | 1196.12 | 38021.0 |
| 2011-10-13 06:30:00 | ES | Futures | 1195.87 | 1200.13 | 1194.86 | 1199.12 | 32139.0 |
| 2011-10-13 07:00:00 | ES | Futures | 1199.38 | 1199.38 | 1193.86 | 1198.12 | 29136.0 |
| 2011-10-13 07:30:00 | ES | Futures | 1198.12 | 1198.37 | 1194.86 | 1195.61 | 17773.0 |
| 2011-10-13 08:00:00 | ES | Futures | 1195.87 | 1197.12 | 1193.61 | 1196.87 | 27582.0 |
| 2011-10-13 08:30:00 | ES | Futures | 1196.87 | 1198.37 | 1194.11 | 1197.37 | 38109.0 |
| 2011-10-13 09:00:00 | ES | Futures | 1197.37 | 1199.12 | 1197.12 | 1198.12 | 27158.0 |
| 2011-10-13 09:30:00 | ES | Futures | 1198.12 | 1198.62 | 1192.1 | 1193.36 | 236838.0 |
| 2011-10-13 10:00:00 | ES | Futures | 1193.11 | 1196.12 | 1190.85 | 1194.61 | 218781.0 |
| 2011-10-13 10:30:00 | ES | Futures | 1194.36 | 1197.37 | 1189.6 | 1189.85 | 187208.0 |
| 2011-10-13 11:00:00 | ES | Futures | 1189.85 | 1193.61 | 1188.84 | 1191.1 | 189615.0 |
| 2011-10-13 11:30:00 | ES | Futures | 1191.1 | 1196.62 | 1190.85 | 1194.36 | 131938.0 |
| 2011-10-13 12:00:00 | ES | Futures | 1194.36 | 1196.12 | 1191.85 | 1192.1 | 68048.0 |
| 2011-10-13 12:30:00 | ES | Futures | 1192.1 | 1195.11 | 1190.85 | 1194.36 | 57346.0 |
| 2011-10-13 13:00:00 | ES | Futures | 1194.36 | 1199.88 | 1192.1 | 1199.12 | 119212.0 |
| 2011-10-13 13:30:00 | ES | Futures | 1199.12 | 1201.38 | 1198.12 | 1199.12 | 91246.0 |
| 2011-10-13 14:00:00 | ES | Futures | 1199.38 | 1200.88 | 1196.87 | 1197.87 | 65316.0 |
| 2011-10-13 14:30:00 | ES | Futures | 1198.12 | 1204.39 | 1197.37 | 1202.89 | 108060.0 |
| 2011-10-13 15:00:00 | ES | Futures | 1202.89 | 1206.65 | 1199.63 | 1199.88 | 154348.0 |
| 2011-10-13 15:30:00 | ES | Futures | 1200.13 | 1203.64 | 1197.87 | 1202.89 | 172695.0 |
| 2011-10-13 16:00:00 | ES | Futures | 1202.89 | 1205.39 | 1201.13 | 1201.38 | 86160.0 |
| 2011-10-13 16:30:00 | ES | Futures | 1201.13 | 1201.88 | 1200.38 | 1201.88 | 6483.0 |
| 2011-10-13 17:00:00 | ES | Futures | 1201.63 | 1203.14 | 1201.63 | 1202.89 | 3047.0 |
| 2011-10-13 18:00:00 | ES | Futures | 1202.64 | 1203.14 | 1201.88 | 1202.13 | 1374.0 |
| 2011-10-13 18:30:00 | ES | Futures | 1202.38 | 1203.14 | 1198.87 | 1199.12 | 6653.0 |
| 2011-10-13 19:00:00 | ES | Futures | 1199.12 | 1200.88 | 1199.12 | 1199.88 | 2197.0 |
| 2011-10-13 19:30:00 | ES | Futures | 1199.88 | 1200.63 | 1198.87 | 1200.13 | 2706.0 |
| 2011-10-13 20:00:00 | ES | Futures | 1200.13 | 1202.13 | 1198.12 | 1198.37 | 4757.0 |
| 2011-10-13 20:30:00 | ES | Futures | 1198.37 | 1199.38 | 1196.87 | 1197.12 | 3322.0 |
| 2011-10-13 21:00:00 | ES | Futures | 1196.87 | 1198.37 | 1196.62 | 1197.87 | 2774.0 |
| 2011-10-13 21:30:00 | ES | Futures | 1197.62 | 1203.64 | 1196.62 | 1200.63 | 9887.0 |
| 2011-10-13 22:00:00 | ES | Futures | 1200.63 | 1201.13 | 1198.62 | 1199.12 | 3168.0 |
| 2011-10-13 22:30:00 | ES | Futures | 1198.87 | 1199.88 | 1197.12 | 1198.37 | 4012.0 |
| 2011-10-13 23:00:00 | ES | Futures | 1198.12 | 1199.88 | 1197.62 | 1199.88 | 2815.0 |
| 2011-10-13 23:30:00 | ES | Futures | 1199.88 | 1200.13 | 1198.87 | 1199.38 | 1887.0 |
| 2011-10-13 00:00:00 | NQ | Futures | 2652.28 | 2653.14 | 2649.97 | 2652.28 | 214.0 |
| 2011-10-13 00:30:00 | NQ | Futures | 2652.28 | 2653.43 | 2651.7 | 2651.99 | 91.0 |
| 2011-10-13 01:00:00 | NQ | Futures | 2651.99 | 2652.86 | 2649.97 | 2650.55 | 116.0 |
> showing 50 of 2,739 rows — these rows as CSV