PREVIEW / futures_30min / 2010-06-22
file: by_date/futures_30min/2010/2010-06-22.parquet size: 71 KB rows: 2,521
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-06-22 00:00:00 | ES | Futures | 1090.71 | 1090.96 | 1090.22 | 1090.22 | 1918.0 |
| 2010-06-22 00:30:00 | ES | Futures | 1090.47 | 1090.71 | 1089.98 | 1090.22 | 2098.0 |
| 2010-06-22 01:00:00 | ES | Futures | 1090.47 | 1090.71 | 1089.98 | 1090.22 | 2333.0 |
| 2010-06-22 01:30:00 | ES | Futures | 1090.22 | 1090.71 | 1089.98 | 1090.47 | 6812.0 |
| 2010-06-22 02:00:00 | ES | Futures | 1090.47 | 1090.71 | 1087.52 | 1089.73 | 15116.0 |
| 2010-06-22 02:30:00 | ES | Futures | 1089.73 | 1091.2 | 1089.49 | 1090.22 | 3870.0 |
| 2010-06-22 03:00:00 | ES | Futures | 1090.22 | 1092.43 | 1089.98 | 1091.94 | 14309.0 |
| 2010-06-22 03:30:00 | ES | Futures | 1091.94 | 1092.43 | 1089.98 | 1091.2 | 14596.0 |
| 2010-06-22 04:00:00 | ES | Futures | 1091.45 | 1092.18 | 1090.22 | 1090.47 | 7772.0 |
| 2010-06-22 04:30:00 | ES | Futures | 1090.47 | 1091.45 | 1089.98 | 1090.71 | 5189.0 |
| 2010-06-22 05:00:00 | ES | Futures | 1090.47 | 1090.71 | 1084.58 | 1085.07 | 24727.0 |
| 2010-06-22 05:30:00 | ES | Futures | 1085.07 | 1085.8 | 1083.84 | 1084.09 | 13587.0 |
| 2010-06-22 06:00:00 | ES | Futures | 1084.09 | 1085.8 | 1083.11 | 1085.07 | 12200.0 |
| 2010-06-22 06:30:00 | ES | Futures | 1085.07 | 1087.52 | 1084.82 | 1085.31 | 18055.0 |
| 2010-06-22 07:00:00 | ES | Futures | 1085.31 | 1087.52 | 1085.07 | 1086.54 | 19245.0 |
| 2010-06-22 07:30:00 | ES | Futures | 1086.54 | 1088.26 | 1085.31 | 1086.3 | 22300.0 |
| 2010-06-22 08:00:00 | ES | Futures | 1086.05 | 1087.52 | 1084.58 | 1087.28 | 22513.0 |
| 2010-06-22 08:30:00 | ES | Futures | 1087.28 | 1089.49 | 1087.03 | 1089.24 | 27241.0 |
| 2010-06-22 09:00:00 | ES | Futures | 1089.24 | 1089.98 | 1088.5 | 1088.99 | 26341.0 |
| 2010-06-22 09:30:00 | ES | Futures | 1089.24 | 1093.9 | 1088.26 | 1088.99 | 220650.0 |
| 2010-06-22 10:00:00 | ES | Futures | 1089.24 | 1089.73 | 1084.58 | 1087.03 | 222854.0 |
| 2010-06-22 10:30:00 | ES | Futures | 1087.03 | 1088.99 | 1084.09 | 1088.01 | 139927.0 |
| 2010-06-22 11:00:00 | ES | Futures | 1088.26 | 1088.5 | 1084.82 | 1088.5 | 130753.0 |
| 2010-06-22 11:30:00 | ES | Futures | 1088.5 | 1092.18 | 1087.77 | 1089.49 | 112845.0 |
| 2010-06-22 12:00:00 | ES | Futures | 1089.49 | 1090.22 | 1087.77 | 1088.01 | 67793.0 |
| 2010-06-22 12:30:00 | ES | Futures | 1087.77 | 1088.26 | 1086.3 | 1087.77 | 49994.0 |
| 2010-06-22 13:00:00 | ES | Futures | 1087.77 | 1089.24 | 1085.56 | 1085.8 | 67733.0 |
| 2010-06-22 13:30:00 | ES | Futures | 1085.8 | 1088.99 | 1084.58 | 1085.8 | 132869.0 |
| 2010-06-22 14:00:00 | ES | Futures | 1085.56 | 1085.8 | 1080.9 | 1082.12 | 135564.0 |
| 2010-06-22 14:30:00 | ES | Futures | 1081.88 | 1083.6 | 1072.8 | 1075.25 | 224066.0 |
| 2010-06-22 15:00:00 | ES | Futures | 1075.25 | 1077.71 | 1072.55 | 1073.29 | 146877.0 |
| 2010-06-22 15:30:00 | ES | Futures | 1073.04 | 1073.54 | 1069.36 | 1071.33 | 234338.0 |
| 2010-06-22 16:00:00 | ES | Futures | 1071.08 | 1071.82 | 1069.36 | 1070.1 | 80328.0 |
| 2010-06-22 16:30:00 | ES | Futures | 1070.59 | 1072.55 | 1070.59 | 1071.82 | 6726.0 |
| 2010-06-22 17:00:00 | ES | Futures | 1071.82 | 1072.55 | 1071.08 | 1071.57 | 3085.0 |
| 2010-06-22 18:00:00 | ES | Futures | 1071.57 | 1072.31 | 1071.33 | 1071.57 | 1866.0 |
| 2010-06-22 18:30:00 | ES | Futures | 1071.82 | 1072.55 | 1071.57 | 1071.82 | 1059.0 |
| 2010-06-22 19:00:00 | ES | Futures | 1071.82 | 1073.29 | 1071.57 | 1072.8 | 1803.0 |
| 2010-06-22 19:30:00 | ES | Futures | 1072.8 | 1072.8 | 1071.33 | 1072.06 | 1813.0 |
| 2010-06-22 20:00:00 | ES | Futures | 1071.82 | 1072.8 | 1071.82 | 1072.55 | 2009.0 |
| 2010-06-22 20:30:00 | ES | Futures | 1072.8 | 1073.04 | 1071.82 | 1071.82 | 3675.0 |
| 2010-06-22 21:00:00 | ES | Futures | 1072.06 | 1072.8 | 1071.82 | 1072.31 | 2961.0 |
| 2010-06-22 21:30:00 | ES | Futures | 1072.06 | 1074.27 | 1071.82 | 1074.27 | 4193.0 |
| 2010-06-22 22:00:00 | ES | Futures | 1074.27 | 1074.52 | 1073.29 | 1074.27 | 2083.0 |
| 2010-06-22 22:30:00 | ES | Futures | 1074.03 | 1074.76 | 1073.54 | 1074.52 | 2997.0 |
| 2010-06-22 23:00:00 | ES | Futures | 1074.27 | 1074.27 | 1072.8 | 1072.8 | 1845.0 |
| 2010-06-22 23:30:00 | ES | Futures | 1073.04 | 1074.03 | 1072.31 | 1073.54 | 2614.0 |
| 2010-06-22 00:00:00 | NQ | Futures | 2180.19 | 2180.77 | 2179.05 | 2179.62 | 226.0 |
| 2010-06-22 00:30:00 | NQ | Futures | 2179.91 | 2179.91 | 2177.9 | 2178.47 | 155.0 |
| 2010-06-22 01:00:00 | NQ | Futures | 2178.19 | 2178.76 | 2177.33 | 2178.19 | 209.0 |
> showing 50 of 2,521 rows — these rows as CSV