PREVIEW / futures_30min / 2010-01-20
file: by_date/futures_30min/2010/2010-01-20.parquet size: 73 KB rows: 2,631
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-01-20 00:00:00 | ES | Futures | 1113.15 | 1113.4 | 1111.69 | 1111.69 | 2455.0 |
| 2010-01-20 00:30:00 | ES | Futures | 1111.69 | 1112.18 | 1111.45 | 1111.69 | 1964.0 |
| 2010-01-20 01:00:00 | ES | Futures | 1111.94 | 1112.18 | 1111.69 | 1111.69 | 2540.0 |
| 2010-01-20 01:30:00 | ES | Futures | 1111.94 | 1112.18 | 1111.45 | 1111.45 | 3851.0 |
| 2010-01-20 02:00:00 | ES | Futures | 1111.69 | 1111.94 | 1111.21 | 1111.45 | 7572.0 |
| 2010-01-20 02:30:00 | ES | Futures | 1111.69 | 1111.69 | 1110.48 | 1110.48 | 9640.0 |
| 2010-01-20 03:00:00 | ES | Futures | 1110.48 | 1111.21 | 1109.02 | 1109.75 | 24409.0 |
| 2010-01-20 03:30:00 | ES | Futures | 1109.99 | 1111.69 | 1109.5 | 1111.21 | 12402.0 |
| 2010-01-20 04:00:00 | ES | Futures | 1111.45 | 1112.42 | 1110.48 | 1111.45 | 10867.0 |
| 2010-01-20 04:30:00 | ES | Futures | 1111.21 | 1111.94 | 1110.23 | 1110.48 | 6267.0 |
| 2010-01-20 05:00:00 | ES | Futures | 1110.48 | 1111.45 | 1109.5 | 1111.21 | 8727.0 |
| 2010-01-20 05:30:00 | ES | Futures | 1110.96 | 1111.94 | 1110.72 | 1110.96 | 5825.0 |
| 2010-01-20 06:00:00 | ES | Futures | 1111.21 | 1111.94 | 1109.5 | 1109.75 | 12162.0 |
| 2010-01-20 06:30:00 | ES | Futures | 1109.5 | 1110.48 | 1108.53 | 1108.53 | 15818.0 |
| 2010-01-20 07:00:00 | ES | Futures | 1108.53 | 1109.26 | 1107.31 | 1108.53 | 34327.0 |
| 2010-01-20 07:30:00 | ES | Futures | 1108.77 | 1110.23 | 1107.8 | 1110.23 | 22293.0 |
| 2010-01-20 08:00:00 | ES | Futures | 1110.23 | 1112.18 | 1108.53 | 1109.5 | 59984.0 |
| 2010-01-20 08:30:00 | ES | Futures | 1109.26 | 1110.48 | 1106.83 | 1107.31 | 52651.0 |
| 2010-01-20 09:00:00 | ES | Futures | 1107.31 | 1107.8 | 1106.1 | 1107.56 | 53737.0 |
| 2010-01-20 09:30:00 | ES | Futures | 1107.8 | 1107.8 | 1102.45 | 1104.39 | 310356.0 |
| 2010-01-20 10:00:00 | ES | Futures | 1104.64 | 1105.12 | 1099.29 | 1099.29 | 266961.0 |
| 2010-01-20 10:30:00 | ES | Futures | 1099.29 | 1100.99 | 1097.58 | 1098.07 | 189979.0 |
| 2010-01-20 11:00:00 | ES | Futures | 1098.31 | 1098.56 | 1094.91 | 1098.07 | 239001.0 |
| 2010-01-20 11:30:00 | ES | Futures | 1098.07 | 1098.31 | 1096.61 | 1097.1 | 92166.0 |
| 2010-01-20 12:00:00 | ES | Futures | 1097.34 | 1099.29 | 1096.12 | 1098.31 | 102256.0 |
| 2010-01-20 12:30:00 | ES | Futures | 1098.31 | 1098.8 | 1096.37 | 1097.58 | 71365.0 |
| 2010-01-20 13:00:00 | ES | Futures | 1097.58 | 1097.83 | 1095.39 | 1097.1 | 78339.0 |
| 2010-01-20 13:30:00 | ES | Futures | 1097.1 | 1100.5 | 1096.37 | 1099.53 | 91729.0 |
| 2010-01-20 14:00:00 | ES | Futures | 1099.29 | 1100.75 | 1098.8 | 1099.29 | 87108.0 |
| 2010-01-20 14:30:00 | ES | Futures | 1099.29 | 1102.21 | 1098.8 | 1101.96 | 106839.0 |
| 2010-01-20 15:00:00 | ES | Futures | 1101.72 | 1103.42 | 1100.99 | 1102.69 | 94861.0 |
| 2010-01-20 15:30:00 | ES | Futures | 1102.45 | 1104.88 | 1101.23 | 1103.91 | 187979.0 |
| 2010-01-20 16:00:00 | ES | Futures | 1103.67 | 1104.39 | 1103.18 | 1103.67 | 75424.0 |
| 2010-01-20 16:30:00 | ES | Futures | 1103.91 | 1104.64 | 1103.67 | 1104.15 | 3457.0 |
| 2010-01-20 17:00:00 | ES | Futures | 1103.91 | 1104.64 | 1103.91 | 1104.64 | 1172.0 |
| 2010-01-20 18:00:00 | ES | Futures | 1104.15 | 1105.37 | 1103.91 | 1104.39 | 3144.0 |
| 2010-01-20 18:30:00 | ES | Futures | 1104.39 | 1105.12 | 1104.15 | 1104.88 | 1304.0 |
| 2010-01-20 19:00:00 | ES | Futures | 1105.12 | 1106.1 | 1104.88 | 1106.1 | 3311.0 |
| 2010-01-20 19:30:00 | ES | Futures | 1105.85 | 1106.1 | 1105.12 | 1105.12 | 2582.0 |
| 2010-01-20 20:00:00 | ES | Futures | 1105.12 | 1105.61 | 1104.64 | 1105.37 | 2505.0 |
| 2010-01-20 20:30:00 | ES | Futures | 1105.61 | 1105.85 | 1104.64 | 1104.64 | 2620.0 |
| 2010-01-20 21:00:00 | ES | Futures | 1104.64 | 1107.56 | 1103.42 | 1105.61 | 11209.0 |
| 2010-01-20 21:30:00 | ES | Futures | 1105.61 | 1106.1 | 1104.39 | 1104.88 | 2447.0 |
| 2010-01-20 22:00:00 | ES | Futures | 1104.88 | 1105.37 | 1104.39 | 1105.37 | 1473.0 |
| 2010-01-20 22:30:00 | ES | Futures | 1105.37 | 1106.83 | 1105.12 | 1106.58 | 2622.0 |
| 2010-01-20 23:00:00 | ES | Futures | 1106.83 | 1107.56 | 1106.1 | 1106.34 | 3439.0 |
| 2010-01-20 23:30:00 | ES | Futures | 1106.34 | 1107.07 | 1105.61 | 1107.07 | 1108.0 |
| 2010-01-20 00:00:00 | NQ | Futures | 2155.64 | 2156.21 | 2152.79 | 2153.07 | 376.0 |
| 2010-01-20 00:30:00 | NQ | Futures | 2153.07 | 2153.64 | 2152.79 | 2153.07 | 104.0 |
| 2010-01-20 01:00:00 | NQ | Futures | 2153.07 | 2153.64 | 2152.5 | 2152.5 | 52.0 |
> showing 50 of 2,631 rows — these rows as CSV