PREVIEW / futures_30min / 2010-12-20
file: by_date/futures_30min/2010/2010-12-20.parquet size: 70 KB rows: 2,595
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-20 00:00:00 | ES | Futures | 1222.29 | 1222.54 | 1221.3 | 1221.79 | 2163.0 |
| 2010-12-20 00:30:00 | ES | Futures | 1221.55 | 1222.29 | 1221.3 | 1222.29 | 1099.0 |
| 2010-12-20 01:00:00 | ES | Futures | 1222.29 | 1223.28 | 1221.79 | 1223.03 | 1162.0 |
| 2010-12-20 01:30:00 | ES | Futures | 1223.03 | 1223.77 | 1222.78 | 1222.78 | 1913.0 |
| 2010-12-20 02:00:00 | ES | Futures | 1222.78 | 1223.77 | 1222.54 | 1223.77 | 1389.0 |
| 2010-12-20 02:30:00 | ES | Futures | 1223.77 | 1224.27 | 1223.28 | 1223.77 | 2853.0 |
| 2010-12-20 03:00:00 | ES | Futures | 1224.02 | 1226.25 | 1223.28 | 1226.0 | 10105.0 |
| 2010-12-20 03:30:00 | ES | Futures | 1226.0 | 1227.24 | 1225.75 | 1226.25 | 7580.0 |
| 2010-12-20 04:00:00 | ES | Futures | 1226.25 | 1226.99 | 1225.51 | 1226.5 | 3732.0 |
| 2010-12-20 04:30:00 | ES | Futures | 1226.25 | 1226.74 | 1225.51 | 1225.75 | 3401.0 |
| 2010-12-20 05:00:00 | ES | Futures | 1226.0 | 1226.5 | 1225.75 | 1226.25 | 3070.0 |
| 2010-12-20 05:30:00 | ES | Futures | 1226.25 | 1227.73 | 1225.51 | 1227.49 | 4502.0 |
| 2010-12-20 06:00:00 | ES | Futures | 1227.49 | 1229.22 | 1227.49 | 1228.48 | 11402.0 |
| 2010-12-20 06:30:00 | ES | Futures | 1228.72 | 1229.47 | 1228.48 | 1229.47 | 8028.0 |
| 2010-12-20 07:00:00 | ES | Futures | 1229.47 | 1231.44 | 1228.97 | 1231.2 | 23134.0 |
| 2010-12-20 07:30:00 | ES | Futures | 1230.95 | 1231.69 | 1229.96 | 1229.96 | 11723.0 |
| 2010-12-20 08:00:00 | ES | Futures | 1230.21 | 1230.95 | 1229.71 | 1230.21 | 9231.0 |
| 2010-12-20 08:30:00 | ES | Futures | 1230.21 | 1230.45 | 1229.96 | 1229.96 | 9067.0 |
| 2010-12-20 09:00:00 | ES | Futures | 1229.96 | 1230.95 | 1229.96 | 1229.96 | 10552.0 |
| 2010-12-20 09:30:00 | ES | Futures | 1230.21 | 1230.7 | 1228.48 | 1229.22 | 89275.0 |
| 2010-12-20 10:00:00 | ES | Futures | 1228.97 | 1229.22 | 1224.76 | 1226.0 | 152447.0 |
| 2010-12-20 10:30:00 | ES | Futures | 1225.75 | 1226.74 | 1224.52 | 1224.52 | 92446.0 |
| 2010-12-20 11:00:00 | ES | Futures | 1224.52 | 1225.75 | 1223.53 | 1225.51 | 78641.0 |
| 2010-12-20 11:30:00 | ES | Futures | 1225.75 | 1227.24 | 1225.26 | 1226.99 | 58071.0 |
| 2010-12-20 12:00:00 | ES | Futures | 1226.99 | 1228.23 | 1226.5 | 1227.49 | 41334.0 |
| 2010-12-20 12:30:00 | ES | Futures | 1227.73 | 1229.71 | 1226.99 | 1229.71 | 58990.0 |
| 2010-12-20 13:00:00 | ES | Futures | 1229.71 | 1230.21 | 1229.22 | 1229.47 | 31754.0 |
| 2010-12-20 13:30:00 | ES | Futures | 1229.47 | 1229.96 | 1229.22 | 1229.47 | 16714.0 |
| 2010-12-20 14:00:00 | ES | Futures | 1229.71 | 1232.93 | 1229.47 | 1231.69 | 114690.0 |
| 2010-12-20 14:30:00 | ES | Futures | 1231.94 | 1232.19 | 1230.95 | 1231.2 | 42480.0 |
| 2010-12-20 15:00:00 | ES | Futures | 1231.2 | 1231.44 | 1229.47 | 1229.47 | 54858.0 |
| 2010-12-20 15:30:00 | ES | Futures | 1229.47 | 1231.44 | 1229.22 | 1229.47 | 91469.0 |
| 2010-12-20 16:00:00 | ES | Futures | 1229.47 | 1229.96 | 1228.23 | 1228.23 | 65645.0 |
| 2010-12-20 16:30:00 | ES | Futures | 1228.23 | 1228.72 | 1227.98 | 1228.72 | 2704.0 |
| 2010-12-20 17:00:00 | ES | Futures | 1228.72 | 1228.97 | 1228.48 | 1228.97 | 506.0 |
| 2010-12-20 18:00:00 | ES | Futures | 1229.22 | 1229.96 | 1228.97 | 1228.97 | 2528.0 |
| 2010-12-20 18:30:00 | ES | Futures | 1229.22 | 1229.47 | 1228.23 | 1228.48 | 1219.0 |
| 2010-12-20 19:00:00 | ES | Futures | 1228.48 | 1228.97 | 1228.23 | 1228.48 | 1086.0 |
| 2010-12-20 19:30:00 | ES | Futures | 1228.48 | 1228.72 | 1228.23 | 1228.23 | 376.0 |
| 2010-12-20 20:00:00 | ES | Futures | 1228.48 | 1231.2 | 1228.23 | 1230.7 | 3313.0 |
| 2010-12-20 20:30:00 | ES | Futures | 1230.45 | 1230.7 | 1229.96 | 1230.7 | 1260.0 |
| 2010-12-20 21:00:00 | ES | Futures | 1230.7 | 1233.42 | 1230.45 | 1232.93 | 6715.0 |
| 2010-12-20 21:30:00 | ES | Futures | 1232.68 | 1232.93 | 1232.19 | 1232.68 | 2954.0 |
| 2010-12-20 22:00:00 | ES | Futures | 1232.43 | 1233.18 | 1232.19 | 1232.93 | 1353.0 |
| 2010-12-20 22:30:00 | ES | Futures | 1232.93 | 1233.18 | 1232.43 | 1232.68 | 758.0 |
| 2010-12-20 23:00:00 | ES | Futures | 1232.68 | 1232.93 | 1231.94 | 1232.93 | 921.0 |
| 2010-12-20 23:30:00 | ES | Futures | 1232.93 | 1232.93 | 1232.19 | 1232.43 | 626.0 |
| 2010-12-20 00:00:00 | NQ | Futures | 2534.78 | 2535.36 | 2533.92 | 2534.21 | 112.0 |
| 2010-12-20 00:30:00 | NQ | Futures | 2533.92 | 2535.64 | 2533.35 | 2535.36 | 70.0 |
| 2010-12-20 01:00:00 | NQ | Futures | 2535.36 | 2537.08 | 2535.07 | 2536.51 | 119.0 |
> showing 50 of 2,595 rows — these rows as CSV