PREVIEW / futures_30min / 2010-06-16
file: by_date/futures_30min/2010/2010-06-16.parquet size: 69 KB rows: 2,500
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-16 00:00:00 | ES | Futures | 1087.52 | 1087.77 | 1086.05 | 1086.54 | 1598.0 |
| 2010-06-16 00:30:00 | ES | Futures | 1086.54 | 1086.79 | 1085.8 | 1086.3 | 1615.0 |
| 2010-06-16 01:00:00 | ES | Futures | 1086.3 | 1086.54 | 1085.31 | 1085.56 | 2251.0 |
| 2010-06-16 01:30:00 | ES | Futures | 1085.56 | 1086.54 | 1085.31 | 1085.56 | 4253.0 |
| 2010-06-16 02:00:00 | ES | Futures | 1085.56 | 1087.28 | 1085.31 | 1086.54 | 3970.0 |
| 2010-06-16 02:30:00 | ES | Futures | 1086.54 | 1088.01 | 1086.05 | 1086.79 | 4142.0 |
| 2010-06-16 03:00:00 | ES | Futures | 1086.79 | 1086.79 | 1085.07 | 1085.8 | 16933.0 |
| 2010-06-16 03:30:00 | ES | Futures | 1085.56 | 1086.54 | 1083.35 | 1084.33 | 20230.0 |
| 2010-06-16 04:00:00 | ES | Futures | 1084.58 | 1085.31 | 1083.11 | 1084.09 | 17414.0 |
| 2010-06-16 04:30:00 | ES | Futures | 1084.09 | 1085.31 | 1083.11 | 1085.07 | 13042.0 |
| 2010-06-16 05:00:00 | ES | Futures | 1085.07 | 1085.07 | 1082.37 | 1083.6 | 15421.0 |
| 2010-06-16 05:30:00 | ES | Futures | 1083.6 | 1085.56 | 1083.35 | 1085.31 | 8159.0 |
| 2010-06-16 06:00:00 | ES | Futures | 1085.31 | 1086.3 | 1084.09 | 1085.56 | 8214.0 |
| 2010-06-16 06:30:00 | ES | Futures | 1085.56 | 1085.8 | 1084.33 | 1084.33 | 6479.0 |
| 2010-06-16 07:00:00 | ES | Futures | 1084.58 | 1085.31 | 1083.84 | 1084.33 | 14341.0 |
| 2010-06-16 07:30:00 | ES | Futures | 1084.33 | 1084.82 | 1081.63 | 1082.86 | 38440.0 |
| 2010-06-16 08:00:00 | ES | Futures | 1083.11 | 1083.11 | 1080.9 | 1081.14 | 49276.0 |
| 2010-06-16 08:30:00 | ES | Futures | 1080.9 | 1083.11 | 1079.67 | 1082.12 | 72147.0 |
| 2010-06-16 09:00:00 | ES | Futures | 1082.12 | 1084.33 | 1081.63 | 1084.33 | 48428.0 |
| 2010-06-16 09:30:00 | ES | Futures | 1084.09 | 1087.52 | 1082.37 | 1087.52 | 246656.0 |
| 2010-06-16 10:00:00 | ES | Futures | 1087.52 | 1088.5 | 1083.84 | 1084.33 | 197067.0 |
| 2010-06-16 10:30:00 | ES | Futures | 1084.33 | 1086.79 | 1082.12 | 1086.3 | 160029.0 |
| 2010-06-16 11:00:00 | ES | Futures | 1086.3 | 1090.22 | 1085.31 | 1089.24 | 156497.0 |
| 2010-06-16 11:30:00 | ES | Futures | 1089.49 | 1089.73 | 1087.28 | 1088.99 | 101816.0 |
| 2010-06-16 12:00:00 | ES | Futures | 1088.99 | 1092.92 | 1088.99 | 1091.45 | 122065.0 |
| 2010-06-16 12:30:00 | ES | Futures | 1091.45 | 1091.94 | 1088.26 | 1089.49 | 63339.0 |
| 2010-06-16 13:00:00 | ES | Futures | 1089.49 | 1090.71 | 1088.01 | 1090.47 | 65051.0 |
| 2010-06-16 13:30:00 | ES | Futures | 1090.47 | 1092.43 | 1089.24 | 1092.18 | 54529.0 |
| 2010-06-16 14:00:00 | ES | Futures | 1092.43 | 1094.15 | 1091.45 | 1091.94 | 90511.0 |
| 2010-06-16 14:30:00 | ES | Futures | 1091.94 | 1093.66 | 1089.73 | 1091.69 | 108914.0 |
| 2010-06-16 15:00:00 | ES | Futures | 1091.45 | 1091.69 | 1085.56 | 1086.05 | 133508.0 |
| 2010-06-16 15:30:00 | ES | Futures | 1085.8 | 1090.22 | 1085.07 | 1089.24 | 193807.0 |
| 2010-06-16 16:00:00 | ES | Futures | 1089.24 | 1090.96 | 1088.5 | 1089.24 | 79644.0 |
| 2010-06-16 16:30:00 | ES | Futures | 1089.49 | 1089.73 | 1087.52 | 1088.01 | 7812.0 |
| 2010-06-16 17:00:00 | ES | Futures | 1088.01 | 1088.01 | 1086.54 | 1087.28 | 4141.0 |
| 2010-06-16 18:00:00 | ES | Futures | 1087.28 | 1087.28 | 1086.3 | 1086.79 | 2743.0 |
| 2010-06-16 18:30:00 | ES | Futures | 1086.79 | 1087.28 | 1086.3 | 1086.79 | 1243.0 |
| 2010-06-16 19:00:00 | ES | Futures | 1086.79 | 1086.79 | 1085.8 | 1086.3 | 900.0 |
| 2010-06-16 19:30:00 | ES | Futures | 1086.3 | 1086.54 | 1085.8 | 1086.05 | 896.0 |
| 2010-06-16 20:00:00 | ES | Futures | 1086.05 | 1087.28 | 1085.56 | 1087.03 | 2914.0 |
| 2010-06-16 20:30:00 | ES | Futures | 1087.03 | 1087.52 | 1086.54 | 1086.79 | 2500.0 |
| 2010-06-16 21:00:00 | ES | Futures | 1086.79 | 1087.52 | 1086.05 | 1086.3 | 1864.0 |
| 2010-06-16 21:30:00 | ES | Futures | 1086.3 | 1086.54 | 1084.82 | 1085.56 | 4835.0 |
| 2010-06-16 22:00:00 | ES | Futures | 1085.31 | 1085.56 | 1085.07 | 1085.31 | 1789.0 |
| 2010-06-16 22:30:00 | ES | Futures | 1085.31 | 1085.8 | 1085.07 | 1085.56 | 952.0 |
| 2010-06-16 23:00:00 | ES | Futures | 1085.31 | 1085.56 | 1085.07 | 1085.31 | 578.0 |
| 2010-06-16 23:30:00 | ES | Futures | 1085.31 | 1085.31 | 1084.09 | 1084.33 | 2148.0 |
| 2010-06-16 00:00:00 | NQ | Futures | 2167.01 | 2167.3 | 2165.01 | 2165.29 | 121.0 |
| 2010-06-16 00:30:00 | NQ | Futures | 2165.01 | 2165.87 | 2164.72 | 2165.87 | 64.0 |
| 2010-06-16 01:00:00 | NQ | Futures | 2165.29 | 2165.58 | 2164.15 | 2164.43 | 86.0 |
> showing 50 of 2,500 rows — these rows as CSV