PREVIEW / futures_30min / 2010-07-28
file: by_date/futures_30min/2010/2010-07-28.parquet size: 69 KB rows: 2,510
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-07-28 00:00:00 | ES | Futures | 1090.71 | 1090.96 | 1090.22 | 1090.47 | 1074.0 |
| 2010-07-28 00:30:00 | ES | Futures | 1090.47 | 1090.71 | 1089.98 | 1090.47 | 1212.0 |
| 2010-07-28 01:00:00 | ES | Futures | 1090.47 | 1093.17 | 1090.47 | 1092.92 | 3233.0 |
| 2010-07-28 01:30:00 | ES | Futures | 1092.92 | 1094.15 | 1092.92 | 1093.41 | 3417.0 |
| 2010-07-28 02:00:00 | ES | Futures | 1093.41 | 1094.39 | 1092.43 | 1093.41 | 8355.0 |
| 2010-07-28 02:30:00 | ES | Futures | 1093.41 | 1094.39 | 1092.92 | 1093.17 | 5604.0 |
| 2010-07-28 03:00:00 | ES | Futures | 1093.17 | 1095.13 | 1092.67 | 1093.17 | 14225.0 |
| 2010-07-28 03:30:00 | ES | Futures | 1093.17 | 1094.64 | 1091.94 | 1092.18 | 12887.0 |
| 2010-07-28 04:00:00 | ES | Futures | 1091.94 | 1092.92 | 1091.45 | 1091.94 | 9338.0 |
| 2010-07-28 04:30:00 | ES | Futures | 1091.94 | 1093.17 | 1091.69 | 1092.43 | 8004.0 |
| 2010-07-28 05:00:00 | ES | Futures | 1092.18 | 1093.17 | 1091.94 | 1092.43 | 4296.0 |
| 2010-07-28 05:30:00 | ES | Futures | 1092.18 | 1093.17 | 1090.96 | 1091.2 | 10570.0 |
| 2010-07-28 06:00:00 | ES | Futures | 1091.2 | 1091.2 | 1087.77 | 1088.26 | 16321.0 |
| 2010-07-28 06:30:00 | ES | Futures | 1088.01 | 1090.47 | 1087.77 | 1090.22 | 9231.0 |
| 2010-07-28 07:00:00 | ES | Futures | 1090.22 | 1091.45 | 1089.49 | 1091.45 | 9789.0 |
| 2010-07-28 07:30:00 | ES | Futures | 1091.2 | 1092.43 | 1090.22 | 1092.18 | 13282.0 |
| 2010-07-28 08:00:00 | ES | Futures | 1091.94 | 1092.18 | 1090.71 | 1091.2 | 12427.0 |
| 2010-07-28 08:30:00 | ES | Futures | 1091.2 | 1091.2 | 1086.54 | 1088.75 | 65970.0 |
| 2010-07-28 09:00:00 | ES | Futures | 1088.75 | 1089.49 | 1087.03 | 1087.77 | 32724.0 |
| 2010-07-28 09:30:00 | ES | Futures | 1087.52 | 1090.96 | 1086.05 | 1088.5 | 175366.0 |
| 2010-07-28 10:00:00 | ES | Futures | 1088.5 | 1089.49 | 1084.09 | 1086.05 | 149362.0 |
| 2010-07-28 10:30:00 | ES | Futures | 1086.05 | 1087.77 | 1083.11 | 1086.3 | 120107.0 |
| 2010-07-28 11:00:00 | ES | Futures | 1086.54 | 1086.79 | 1083.6 | 1085.07 | 97120.0 |
| 2010-07-28 11:30:00 | ES | Futures | 1085.31 | 1087.03 | 1084.58 | 1085.07 | 71787.0 |
| 2010-07-28 12:00:00 | ES | Futures | 1085.07 | 1087.03 | 1084.33 | 1085.56 | 40468.0 |
| 2010-07-28 12:30:00 | ES | Futures | 1085.8 | 1088.26 | 1085.07 | 1088.01 | 46526.0 |
| 2010-07-28 13:00:00 | ES | Futures | 1088.01 | 1088.75 | 1085.8 | 1086.54 | 64940.0 |
| 2010-07-28 13:30:00 | ES | Futures | 1086.3 | 1086.79 | 1084.58 | 1086.05 | 58838.0 |
| 2010-07-28 14:00:00 | ES | Futures | 1086.05 | 1087.52 | 1082.12 | 1083.84 | 116609.0 |
| 2010-07-28 14:30:00 | ES | Futures | 1083.6 | 1085.07 | 1081.88 | 1082.61 | 71014.0 |
| 2010-07-28 15:00:00 | ES | Futures | 1082.86 | 1083.35 | 1078.93 | 1081.14 | 130789.0 |
| 2010-07-28 15:30:00 | ES | Futures | 1081.14 | 1083.35 | 1081.14 | 1082.61 | 148344.0 |
| 2010-07-28 16:00:00 | ES | Futures | 1082.37 | 1083.11 | 1081.39 | 1082.12 | 80529.0 |
| 2010-07-28 16:30:00 | ES | Futures | 1082.12 | 1082.61 | 1081.88 | 1082.12 | 4059.0 |
| 2010-07-28 17:00:00 | ES | Futures | 1082.12 | 1082.12 | 1080.65 | 1081.14 | 1986.0 |
| 2010-07-28 18:00:00 | ES | Futures | 1081.14 | 1082.12 | 1081.14 | 1081.63 | 829.0 |
| 2010-07-28 18:30:00 | ES | Futures | 1081.88 | 1082.12 | 1081.39 | 1081.63 | 511.0 |
| 2010-07-28 19:00:00 | ES | Futures | 1081.63 | 1082.61 | 1081.39 | 1082.12 | 671.0 |
| 2010-07-28 19:30:00 | ES | Futures | 1082.37 | 1083.11 | 1082.12 | 1082.37 | 2445.0 |
| 2010-07-28 20:00:00 | ES | Futures | 1082.61 | 1083.35 | 1081.88 | 1083.11 | 2988.0 |
| 2010-07-28 20:30:00 | ES | Futures | 1083.11 | 1084.09 | 1082.61 | 1082.86 | 2621.0 |
| 2010-07-28 21:00:00 | ES | Futures | 1082.86 | 1083.11 | 1081.39 | 1082.37 | 1571.0 |
| 2010-07-28 21:30:00 | ES | Futures | 1082.37 | 1082.86 | 1081.88 | 1082.37 | 1917.0 |
| 2010-07-28 22:00:00 | ES | Futures | 1082.61 | 1083.35 | 1081.39 | 1081.39 | 2466.0 |
| 2010-07-28 22:30:00 | ES | Futures | 1081.39 | 1082.12 | 1081.14 | 1081.63 | 1420.0 |
| 2010-07-28 23:00:00 | ES | Futures | 1081.63 | 1083.11 | 1081.39 | 1083.11 | 1079.0 |
| 2010-07-28 23:30:00 | ES | Futures | 1083.11 | 1085.31 | 1083.11 | 1084.82 | 3266.0 |
| 2010-07-28 00:00:00 | NQ | Futures | 2164.15 | 2164.43 | 2163.57 | 2163.86 | 56.0 |
| 2010-07-28 00:30:00 | NQ | Futures | 2163.86 | 2163.86 | 2162.71 | 2163.57 | 24.0 |
| 2010-07-28 01:00:00 | NQ | Futures | 2163.86 | 2167.87 | 2163.86 | 2167.87 | 123.0 |
> showing 50 of 2,510 rows — these rows as CSV