PREVIEW / futures_30min / 2010-05-17
file: by_date/futures_30min/2010/2010-05-17.parquet size: 74 KB rows: 2,531
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-05-17 00:00:00 | ES | Futures | 1096.01 | 1098.21 | 1096.01 | 1098.21 | 4825.0 |
| 2010-05-17 00:30:00 | ES | Futures | 1097.96 | 1099.67 | 1096.99 | 1098.94 | 2493.0 |
| 2010-05-17 01:00:00 | ES | Futures | 1099.18 | 1099.67 | 1097.72 | 1097.96 | 2896.0 |
| 2010-05-17 01:30:00 | ES | Futures | 1097.96 | 1098.7 | 1096.5 | 1097.96 | 4907.0 |
| 2010-05-17 02:00:00 | ES | Futures | 1097.72 | 1100.41 | 1095.52 | 1099.43 | 12877.0 |
| 2010-05-17 02:30:00 | ES | Futures | 1099.67 | 1103.1 | 1098.7 | 1102.61 | 9478.0 |
| 2010-05-17 03:00:00 | ES | Futures | 1102.85 | 1107.74 | 1102.12 | 1106.03 | 34326.0 |
| 2010-05-17 03:30:00 | ES | Futures | 1106.03 | 1107.98 | 1103.1 | 1103.34 | 24725.0 |
| 2010-05-17 04:00:00 | ES | Futures | 1103.58 | 1107.01 | 1102.12 | 1106.03 | 18282.0 |
| 2010-05-17 04:30:00 | ES | Futures | 1105.78 | 1109.7 | 1105.3 | 1107.25 | 21087.0 |
| 2010-05-17 05:00:00 | ES | Futures | 1107.01 | 1112.63 | 1106.76 | 1111.41 | 23980.0 |
| 2010-05-17 05:30:00 | ES | Futures | 1111.41 | 1111.9 | 1109.21 | 1109.45 | 9596.0 |
| 2010-05-17 06:00:00 | ES | Futures | 1109.45 | 1111.9 | 1109.21 | 1111.41 | 10897.0 |
| 2010-05-17 06:30:00 | ES | Futures | 1111.41 | 1113.36 | 1110.92 | 1110.92 | 11455.0 |
| 2010-05-17 07:00:00 | ES | Futures | 1110.92 | 1114.34 | 1110.67 | 1114.34 | 14264.0 |
| 2010-05-17 07:30:00 | ES | Futures | 1114.09 | 1114.58 | 1111.9 | 1112.63 | 17846.0 |
| 2010-05-17 08:00:00 | ES | Futures | 1112.63 | 1113.12 | 1105.78 | 1105.78 | 48440.0 |
| 2010-05-17 08:30:00 | ES | Futures | 1105.78 | 1109.7 | 1104.56 | 1108.72 | 48408.0 |
| 2010-05-17 09:00:00 | ES | Futures | 1108.96 | 1112.63 | 1108.23 | 1111.65 | 38378.0 |
| 2010-05-17 09:30:00 | ES | Futures | 1111.65 | 1114.83 | 1105.78 | 1107.01 | 255754.0 |
| 2010-05-17 10:00:00 | ES | Futures | 1106.76 | 1110.67 | 1105.3 | 1109.21 | 209466.0 |
| 2010-05-17 10:30:00 | ES | Futures | 1108.96 | 1110.92 | 1105.05 | 1105.3 | 180355.0 |
| 2010-05-17 11:00:00 | ES | Futures | 1105.05 | 1106.27 | 1097.47 | 1100.41 | 241963.0 |
| 2010-05-17 11:30:00 | ES | Futures | 1100.41 | 1102.61 | 1096.01 | 1096.5 | 166817.0 |
| 2010-05-17 12:00:00 | ES | Futures | 1096.5 | 1096.74 | 1087.94 | 1092.1 | 304474.0 |
| 2010-05-17 12:30:00 | ES | Futures | 1092.1 | 1095.52 | 1092.1 | 1092.59 | 104649.0 |
| 2010-05-17 13:00:00 | ES | Futures | 1092.59 | 1098.7 | 1092.1 | 1097.23 | 111482.0 |
| 2010-05-17 13:30:00 | ES | Futures | 1097.23 | 1099.43 | 1093.32 | 1097.47 | 121849.0 |
| 2010-05-17 14:00:00 | ES | Futures | 1097.72 | 1100.65 | 1096.99 | 1097.96 | 134849.0 |
| 2010-05-17 14:30:00 | ES | Futures | 1097.96 | 1104.56 | 1097.23 | 1104.07 | 169702.0 |
| 2010-05-17 15:00:00 | ES | Futures | 1104.07 | 1107.74 | 1098.7 | 1102.12 | 207475.0 |
| 2010-05-17 15:30:00 | ES | Futures | 1101.87 | 1111.16 | 1101.63 | 1109.45 | 285084.0 |
| 2010-05-17 16:00:00 | ES | Futures | 1109.21 | 1110.18 | 1107.98 | 1109.45 | 84647.0 |
| 2010-05-17 16:30:00 | ES | Futures | 1110.18 | 1112.38 | 1109.21 | 1111.41 | 10101.0 |
| 2010-05-17 17:00:00 | ES | Futures | 1111.41 | 1111.41 | 1110.43 | 1110.92 | 1956.0 |
| 2010-05-17 18:00:00 | ES | Futures | 1110.43 | 1111.65 | 1110.43 | 1111.16 | 2041.0 |
| 2010-05-17 18:30:00 | ES | Futures | 1111.16 | 1112.38 | 1111.16 | 1111.65 | 2011.0 |
| 2010-05-17 19:00:00 | ES | Futures | 1111.41 | 1111.65 | 1110.18 | 1110.18 | 1626.0 |
| 2010-05-17 19:30:00 | ES | Futures | 1110.18 | 1111.16 | 1109.94 | 1111.16 | 1894.0 |
| 2010-05-17 20:00:00 | ES | Futures | 1110.92 | 1111.65 | 1108.23 | 1108.96 | 4128.0 |
| 2010-05-17 20:30:00 | ES | Futures | 1108.96 | 1108.96 | 1106.76 | 1107.25 | 3402.0 |
| 2010-05-17 21:00:00 | ES | Futures | 1107.25 | 1107.25 | 1105.05 | 1105.78 | 6096.0 |
| 2010-05-17 21:30:00 | ES | Futures | 1105.78 | 1107.74 | 1105.54 | 1107.5 | 2656.0 |
| 2010-05-17 22:00:00 | ES | Futures | 1107.25 | 1108.96 | 1106.03 | 1106.52 | 4183.0 |
| 2010-05-17 22:30:00 | ES | Futures | 1106.52 | 1106.52 | 1105.3 | 1105.54 | 1708.0 |
| 2010-05-17 23:00:00 | ES | Futures | 1105.54 | 1107.74 | 1104.81 | 1107.74 | 2327.0 |
| 2010-05-17 23:30:00 | ES | Futures | 1107.5 | 1108.47 | 1106.76 | 1107.98 | 2214.0 |
| 2010-05-17 00:00:00 | NQ | Futures | 2161.25 | 2165.84 | 2160.97 | 2165.26 | 375.0 |
| 2010-05-17 00:30:00 | NQ | Futures | 2165.26 | 2166.7 | 2162.69 | 2166.7 | 215.0 |
| 2010-05-17 01:00:00 | NQ | Futures | 2166.98 | 2167.84 | 2163.83 | 2166.12 | 244.0 |
> showing 50 of 2,531 rows — these rows as CSV