PREVIEW / futures_30min / 2010-03-10
file: by_date/futures_30min/2010/2010-03-10.parquet size: 65 KB rows: 2,405
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-03-10 00:00:00 | ES | Futures | 1109.02 | 1109.99 | 1108.77 | 1109.5 | 1107.0 |
| 2010-03-10 00:30:00 | ES | Futures | 1109.75 | 1109.75 | 1109.26 | 1109.5 | 358.0 |
| 2010-03-10 01:00:00 | ES | Futures | 1109.5 | 1109.75 | 1109.02 | 1109.26 | 651.0 |
| 2010-03-10 01:30:00 | ES | Futures | 1109.26 | 1109.75 | 1109.02 | 1109.5 | 1148.0 |
| 2010-03-10 02:00:00 | ES | Futures | 1109.75 | 1109.99 | 1107.56 | 1108.04 | 3943.0 |
| 2010-03-10 02:30:00 | ES | Futures | 1108.04 | 1108.77 | 1107.8 | 1108.04 | 3039.0 |
| 2010-03-10 03:00:00 | ES | Futures | 1108.04 | 1109.02 | 1107.07 | 1108.29 | 9045.0 |
| 2010-03-10 03:30:00 | ES | Futures | 1108.29 | 1109.75 | 1107.56 | 1108.77 | 6926.0 |
| 2010-03-10 04:00:00 | ES | Futures | 1109.02 | 1111.21 | 1108.53 | 1111.21 | 10981.0 |
| 2010-03-10 04:30:00 | ES | Futures | 1110.96 | 1111.21 | 1109.02 | 1109.26 | 6693.0 |
| 2010-03-10 05:00:00 | ES | Futures | 1109.26 | 1109.26 | 1108.53 | 1109.26 | 3775.0 |
| 2010-03-10 05:30:00 | ES | Futures | 1109.26 | 1110.23 | 1108.77 | 1109.99 | 5624.0 |
| 2010-03-10 06:00:00 | ES | Futures | 1109.75 | 1110.72 | 1108.77 | 1109.5 | 6213.0 |
| 2010-03-10 06:30:00 | ES | Futures | 1109.5 | 1111.45 | 1109.5 | 1110.48 | 7450.0 |
| 2010-03-10 07:00:00 | ES | Futures | 1110.48 | 1111.45 | 1109.5 | 1109.5 | 9580.0 |
| 2010-03-10 07:30:00 | ES | Futures | 1109.5 | 1110.23 | 1109.02 | 1109.75 | 8762.0 |
| 2010-03-10 08:00:00 | ES | Futures | 1109.5 | 1110.72 | 1109.02 | 1110.48 | 12298.0 |
| 2010-03-10 08:30:00 | ES | Futures | 1110.23 | 1110.48 | 1109.26 | 1109.99 | 12236.0 |
| 2010-03-10 09:00:00 | ES | Futures | 1109.75 | 1110.48 | 1108.53 | 1109.75 | 17803.0 |
| 2010-03-10 09:30:00 | ES | Futures | 1109.75 | 1112.91 | 1109.26 | 1111.94 | 141126.0 |
| 2010-03-10 10:00:00 | ES | Futures | 1112.18 | 1114.86 | 1111.94 | 1114.37 | 148996.0 |
| 2010-03-10 10:30:00 | ES | Futures | 1114.13 | 1116.56 | 1114.13 | 1115.34 | 126715.0 |
| 2010-03-10 11:00:00 | ES | Futures | 1115.58 | 1117.04 | 1115.34 | 1115.83 | 104349.0 |
| 2010-03-10 11:30:00 | ES | Futures | 1115.83 | 1116.56 | 1113.4 | 1114.61 | 125825.0 |
| 2010-03-10 12:00:00 | ES | Futures | 1114.61 | 1114.86 | 1109.99 | 1109.99 | 179392.0 |
| 2010-03-10 12:30:00 | ES | Futures | 1109.99 | 1113.15 | 1108.53 | 1112.91 | 117995.0 |
| 2010-03-10 13:00:00 | ES | Futures | 1112.67 | 1114.37 | 1111.45 | 1112.67 | 84847.0 |
| 2010-03-10 13:30:00 | ES | Futures | 1112.67 | 1114.13 | 1111.69 | 1112.18 | 57237.0 |
| 2010-03-10 14:00:00 | ES | Futures | 1112.18 | 1116.07 | 1111.45 | 1115.83 | 102786.0 |
| 2010-03-10 14:30:00 | ES | Futures | 1115.58 | 1116.56 | 1113.88 | 1114.13 | 73020.0 |
| 2010-03-10 15:00:00 | ES | Futures | 1114.13 | 1116.07 | 1112.18 | 1112.18 | 103834.0 |
| 2010-03-10 15:30:00 | ES | Futures | 1112.18 | 1115.34 | 1110.72 | 1113.88 | 220744.0 |
| 2010-03-10 16:00:00 | ES | Futures | 1114.13 | 1115.58 | 1113.64 | 1114.61 | 96392.0 |
| 2010-03-10 16:30:00 | ES | Futures | 1114.37 | 1114.86 | 1114.37 | 1114.61 | 5987.0 |
| 2010-03-10 17:00:00 | ES | Futures | 1114.61 | 1114.61 | 1114.13 | 1114.37 | 1568.0 |
| 2010-03-10 18:00:00 | ES | Futures | 1114.13 | 1114.61 | 1113.4 | 1113.64 | 1782.0 |
| 2010-03-10 18:30:00 | ES | Futures | 1113.64 | 1114.37 | 1113.15 | 1113.64 | 2175.0 |
| 2010-03-10 19:00:00 | ES | Futures | 1113.4 | 1114.86 | 1113.15 | 1113.88 | 2521.0 |
| 2010-03-10 19:30:00 | ES | Futures | 1113.64 | 1113.88 | 1112.91 | 1113.4 | 1667.0 |
| 2010-03-10 20:00:00 | ES | Futures | 1113.15 | 1114.86 | 1113.15 | 1114.37 | 1124.0 |
| 2010-03-10 20:30:00 | ES | Futures | 1114.61 | 1114.61 | 1113.88 | 1114.37 | 495.0 |
| 2010-03-10 21:00:00 | ES | Futures | 1114.13 | 1114.13 | 1111.45 | 1111.94 | 6772.0 |
| 2010-03-10 21:30:00 | ES | Futures | 1111.94 | 1111.94 | 1109.75 | 1109.75 | 6546.0 |
| 2010-03-10 22:00:00 | ES | Futures | 1109.75 | 1110.72 | 1109.75 | 1109.99 | 2981.0 |
| 2010-03-10 22:30:00 | ES | Futures | 1110.23 | 1110.72 | 1109.26 | 1109.26 | 3315.0 |
| 2010-03-10 23:00:00 | ES | Futures | 1109.26 | 1110.23 | 1108.77 | 1110.23 | 3238.0 |
| 2010-03-10 23:30:00 | ES | Futures | 1109.99 | 1110.23 | 1109.26 | 1109.99 | 2123.0 |
| 2010-03-10 00:00:00 | NQ | Futures | 2173.07 | 2173.92 | 2173.07 | 2173.64 | 21.0 |
| 2010-03-10 00:30:00 | NQ | Futures | 2173.35 | 2173.64 | 2173.07 | 2173.07 | 16.0 |
| 2010-03-10 01:00:00 | NQ | Futures | 2173.35 | 2174.21 | 2173.35 | 2173.64 | 42.0 |
> showing 50 of 2,405 rows — these rows as CSV