PREVIEW / futures_30min / 2010-01-12
file: by_date/futures_30min/2010/2010-01-12.parquet size: 73 KB rows: 2,583
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-01-12 00:00:00 | ES | Futures | 1108.53 | 1109.5 | 1108.53 | 1109.26 | 1064.0 |
| 2010-01-12 00:30:00 | ES | Futures | 1109.26 | 1110.48 | 1109.02 | 1110.23 | 1324.0 |
| 2010-01-12 01:00:00 | ES | Futures | 1110.23 | 1112.18 | 1110.23 | 1111.45 | 6093.0 |
| 2010-01-12 01:30:00 | ES | Futures | 1111.69 | 1112.18 | 1111.21 | 1111.45 | 5004.0 |
| 2010-01-12 02:00:00 | ES | Futures | 1111.45 | 1111.69 | 1109.99 | 1110.23 | 2677.0 |
| 2010-01-12 02:30:00 | ES | Futures | 1110.48 | 1110.96 | 1109.75 | 1109.99 | 1673.0 |
| 2010-01-12 03:00:00 | ES | Futures | 1109.99 | 1110.96 | 1108.29 | 1108.29 | 14106.0 |
| 2010-01-12 03:30:00 | ES | Futures | 1108.53 | 1108.77 | 1107.31 | 1107.56 | 14838.0 |
| 2010-01-12 04:00:00 | ES | Futures | 1107.56 | 1108.04 | 1105.61 | 1105.85 | 20423.0 |
| 2010-01-12 04:30:00 | ES | Futures | 1105.61 | 1107.56 | 1105.37 | 1107.07 | 11724.0 |
| 2010-01-12 05:00:00 | ES | Futures | 1107.31 | 1108.29 | 1106.58 | 1108.04 | 6120.0 |
| 2010-01-12 05:30:00 | ES | Futures | 1108.04 | 1108.77 | 1107.31 | 1107.8 | 7645.0 |
| 2010-01-12 06:00:00 | ES | Futures | 1108.04 | 1108.29 | 1102.45 | 1104.15 | 38987.0 |
| 2010-01-12 06:30:00 | ES | Futures | 1104.39 | 1105.12 | 1102.94 | 1103.91 | 13795.0 |
| 2010-01-12 07:00:00 | ES | Futures | 1103.91 | 1105.61 | 1103.42 | 1104.64 | 11403.0 |
| 2010-01-12 07:30:00 | ES | Futures | 1104.88 | 1105.12 | 1103.67 | 1104.39 | 14161.0 |
| 2010-01-12 08:00:00 | ES | Futures | 1104.39 | 1105.12 | 1102.69 | 1102.94 | 25590.0 |
| 2010-01-12 08:30:00 | ES | Futures | 1102.69 | 1104.64 | 1102.21 | 1103.67 | 33881.0 |
| 2010-01-12 09:00:00 | ES | Futures | 1103.67 | 1105.12 | 1103.18 | 1104.64 | 25169.0 |
| 2010-01-12 09:30:00 | ES | Futures | 1104.64 | 1106.58 | 1101.96 | 1106.1 | 263748.0 |
| 2010-01-12 10:00:00 | ES | Futures | 1106.34 | 1107.07 | 1104.15 | 1106.58 | 143846.0 |
| 2010-01-12 10:30:00 | ES | Futures | 1106.58 | 1107.07 | 1105.37 | 1106.34 | 101796.0 |
| 2010-01-12 11:00:00 | ES | Futures | 1106.34 | 1106.34 | 1104.88 | 1106.1 | 85511.0 |
| 2010-01-12 11:30:00 | ES | Futures | 1106.1 | 1106.58 | 1103.67 | 1103.91 | 99628.0 |
| 2010-01-12 12:00:00 | ES | Futures | 1103.91 | 1104.15 | 1099.77 | 1100.26 | 173894.0 |
| 2010-01-12 12:30:00 | ES | Futures | 1100.26 | 1100.75 | 1097.83 | 1098.56 | 164437.0 |
| 2010-01-12 13:00:00 | ES | Futures | 1098.56 | 1099.77 | 1097.34 | 1098.31 | 105061.0 |
| 2010-01-12 13:30:00 | ES | Futures | 1098.56 | 1100.5 | 1098.31 | 1100.02 | 68807.0 |
| 2010-01-12 14:00:00 | ES | Futures | 1100.26 | 1100.5 | 1099.04 | 1099.77 | 60435.0 |
| 2010-01-12 14:30:00 | ES | Futures | 1100.02 | 1101.72 | 1098.31 | 1101.48 | 111950.0 |
| 2010-01-12 15:00:00 | ES | Futures | 1101.23 | 1101.48 | 1099.29 | 1100.75 | 76163.0 |
| 2010-01-12 15:30:00 | ES | Futures | 1100.75 | 1101.96 | 1098.07 | 1101.48 | 214735.0 |
| 2010-01-12 16:00:00 | ES | Futures | 1101.48 | 1103.67 | 1101.48 | 1103.67 | 123774.0 |
| 2010-01-12 16:30:00 | ES | Futures | 1103.67 | 1103.91 | 1102.94 | 1103.42 | 8971.0 |
| 2010-01-12 17:00:00 | ES | Futures | 1103.42 | 1103.91 | 1103.18 | 1103.67 | 1881.0 |
| 2010-01-12 18:00:00 | ES | Futures | 1103.18 | 1103.42 | 1102.69 | 1102.94 | 2539.0 |
| 2010-01-12 18:30:00 | ES | Futures | 1102.94 | 1103.67 | 1102.94 | 1103.67 | 1447.0 |
| 2010-01-12 19:00:00 | ES | Futures | 1103.67 | 1105.12 | 1103.18 | 1104.88 | 4215.0 |
| 2010-01-12 19:30:00 | ES | Futures | 1104.88 | 1105.85 | 1104.64 | 1104.64 | 2698.0 |
| 2010-01-12 20:00:00 | ES | Futures | 1104.64 | 1105.12 | 1103.42 | 1103.67 | 2537.0 |
| 2010-01-12 20:30:00 | ES | Futures | 1103.67 | 1104.39 | 1103.42 | 1103.67 | 2232.0 |
| 2010-01-12 21:00:00 | ES | Futures | 1103.91 | 1105.61 | 1103.42 | 1105.37 | 4395.0 |
| 2010-01-12 21:30:00 | ES | Futures | 1105.12 | 1106.34 | 1103.67 | 1104.15 | 6421.0 |
| 2010-01-12 22:00:00 | ES | Futures | 1103.91 | 1104.15 | 1103.42 | 1103.42 | 2199.0 |
| 2010-01-12 22:30:00 | ES | Futures | 1103.42 | 1104.64 | 1103.18 | 1104.39 | 2592.0 |
| 2010-01-12 23:00:00 | ES | Futures | 1104.39 | 1105.12 | 1104.15 | 1105.12 | 1799.0 |
| 2010-01-12 23:30:00 | ES | Futures | 1105.12 | 1105.61 | 1104.88 | 1105.37 | 1807.0 |
| 2010-01-12 00:00:00 | NQ | Futures | 2147.07 | 2148.5 | 2146.5 | 2147.65 | 51.0 |
| 2010-01-12 00:30:00 | NQ | Futures | 2147.93 | 2149.64 | 2147.07 | 2149.07 | 157.0 |
| 2010-01-12 01:00:00 | NQ | Futures | 2149.64 | 2152.22 | 2149.64 | 2151.36 | 359.0 |
> showing 50 of 2,583 rows — these rows as CSV