PREVIEW / futures_30min / 2010-12-27
file: by_date/futures_30min/2010/2010-12-27.parquet size: 63 KB rows: 2,340
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-27 00:00:00 | ES | Futures | 1237.63 | 1237.88 | 1237.38 | 1237.38 | 529.0 |
| 2010-12-27 00:30:00 | ES | Futures | 1237.63 | 1237.88 | 1237.14 | 1237.63 | 542.0 |
| 2010-12-27 01:00:00 | ES | Futures | 1237.38 | 1237.88 | 1236.89 | 1237.14 | 780.0 |
| 2010-12-27 01:30:00 | ES | Futures | 1236.89 | 1237.63 | 1236.64 | 1237.63 | 757.0 |
| 2010-12-27 02:00:00 | ES | Futures | 1237.63 | 1238.13 | 1236.89 | 1236.89 | 1248.0 |
| 2010-12-27 02:30:00 | ES | Futures | 1237.14 | 1237.38 | 1236.64 | 1237.38 | 1727.0 |
| 2010-12-27 03:00:00 | ES | Futures | 1237.38 | 1237.38 | 1232.68 | 1233.42 | 17418.0 |
| 2010-12-27 03:30:00 | ES | Futures | 1233.42 | 1234.91 | 1232.93 | 1234.66 | 4112.0 |
| 2010-12-27 04:00:00 | ES | Futures | 1234.66 | 1235.16 | 1234.17 | 1234.66 | 1904.0 |
| 2010-12-27 04:30:00 | ES | Futures | 1234.66 | 1234.91 | 1234.17 | 1234.91 | 915.0 |
| 2010-12-27 05:00:00 | ES | Futures | 1234.91 | 1235.16 | 1234.41 | 1234.91 | 1396.0 |
| 2010-12-27 05:30:00 | ES | Futures | 1234.66 | 1235.4 | 1234.66 | 1235.4 | 640.0 |
| 2010-12-27 06:00:00 | ES | Futures | 1235.4 | 1237.14 | 1235.16 | 1237.14 | 3876.0 |
| 2010-12-27 06:30:00 | ES | Futures | 1236.89 | 1237.14 | 1235.65 | 1235.65 | 2565.0 |
| 2010-12-27 07:00:00 | ES | Futures | 1235.65 | 1236.15 | 1234.66 | 1234.91 | 2479.0 |
| 2010-12-27 07:30:00 | ES | Futures | 1234.91 | 1234.91 | 1233.67 | 1233.92 | 4209.0 |
| 2010-12-27 08:00:00 | ES | Futures | 1234.17 | 1234.91 | 1233.92 | 1234.66 | 3596.0 |
| 2010-12-27 08:30:00 | ES | Futures | 1234.66 | 1235.4 | 1234.17 | 1235.16 | 5808.0 |
| 2010-12-27 09:00:00 | ES | Futures | 1235.16 | 1235.65 | 1234.66 | 1234.91 | 5901.0 |
| 2010-12-27 09:30:00 | ES | Futures | 1234.66 | 1236.15 | 1234.17 | 1235.65 | 68129.0 |
| 2010-12-27 10:00:00 | ES | Futures | 1235.65 | 1238.13 | 1235.16 | 1238.13 | 47625.0 |
| 2010-12-27 10:30:00 | ES | Futures | 1237.88 | 1238.13 | 1236.89 | 1237.14 | 33102.0 |
| 2010-12-27 11:00:00 | ES | Futures | 1237.38 | 1237.63 | 1236.89 | 1237.38 | 32584.0 |
| 2010-12-27 11:30:00 | ES | Futures | 1237.38 | 1237.88 | 1236.89 | 1237.63 | 31273.0 |
| 2010-12-27 12:00:00 | ES | Futures | 1237.38 | 1238.37 | 1237.38 | 1238.37 | 15473.0 |
| 2010-12-27 12:30:00 | ES | Futures | 1238.37 | 1238.62 | 1237.88 | 1238.13 | 16114.0 |
| 2010-12-27 13:00:00 | ES | Futures | 1238.37 | 1240.6 | 1238.13 | 1240.1 | 62938.0 |
| 2010-12-27 13:30:00 | ES | Futures | 1240.1 | 1240.85 | 1239.86 | 1240.6 | 27175.0 |
| 2010-12-27 14:00:00 | ES | Futures | 1240.85 | 1240.85 | 1239.86 | 1239.86 | 9375.0 |
| 2010-12-27 14:30:00 | ES | Futures | 1239.86 | 1241.09 | 1239.86 | 1240.1 | 26465.0 |
| 2010-12-27 15:00:00 | ES | Futures | 1240.1 | 1241.09 | 1239.86 | 1240.85 | 25185.0 |
| 2010-12-27 15:30:00 | ES | Futures | 1240.85 | 1241.34 | 1240.1 | 1240.1 | 45057.0 |
| 2010-12-27 16:00:00 | ES | Futures | 1240.1 | 1240.85 | 1239.86 | 1240.85 | 51790.0 |
| 2010-12-27 16:30:00 | ES | Futures | 1240.6 | 1240.6 | 1240.1 | 1240.35 | 2283.0 |
| 2010-12-27 17:00:00 | ES | Futures | 1240.35 | 1240.85 | 1240.35 | 1240.6 | 376.0 |
| 2010-12-27 18:00:00 | ES | Futures | 1240.6 | 1240.85 | 1240.35 | 1240.35 | 637.0 |
| 2010-12-27 18:30:00 | ES | Futures | 1240.35 | 1240.85 | 1240.35 | 1240.85 | 689.0 |
| 2010-12-27 19:00:00 | ES | Futures | 1240.85 | 1241.34 | 1240.6 | 1241.34 | 1380.0 |
| 2010-12-27 19:30:00 | ES | Futures | 1241.09 | 1241.59 | 1241.09 | 1241.09 | 781.0 |
| 2010-12-27 20:00:00 | ES | Futures | 1241.34 | 1241.84 | 1241.09 | 1241.59 | 1185.0 |
| 2010-12-27 20:30:00 | ES | Futures | 1241.59 | 1241.84 | 1241.34 | 1241.34 | 895.0 |
| 2010-12-27 21:00:00 | ES | Futures | 1241.59 | 1241.84 | 1241.34 | 1241.59 | 701.0 |
| 2010-12-27 21:30:00 | ES | Futures | 1241.59 | 1241.59 | 1241.09 | 1241.59 | 424.0 |
| 2010-12-27 22:00:00 | ES | Futures | 1241.34 | 1241.59 | 1241.09 | 1241.34 | 367.0 |
| 2010-12-27 22:30:00 | ES | Futures | 1241.34 | 1241.59 | 1241.09 | 1241.59 | 338.0 |
| 2010-12-27 23:00:00 | ES | Futures | 1241.59 | 1241.59 | 1241.09 | 1241.34 | 390.0 |
| 2010-12-27 23:30:00 | ES | Futures | 1241.34 | 1241.59 | 1241.09 | 1241.34 | 379.0 |
| 2010-12-27 00:00:00 | NQ | Futures | 2557.75 | 2558.32 | 2557.75 | 2558.03 | 36.0 |
| 2010-12-27 00:30:00 | NQ | Futures | 2558.32 | 2558.32 | 2557.75 | 2558.03 | 18.0 |
| 2010-12-27 01:00:00 | NQ | Futures | 2558.32 | 2558.61 | 2557.17 | 2557.46 | 96.0 |
> showing 50 of 2,340 rows — these rows as CSV