PREVIEW / futures_30min / 2010-05-18
file: by_date/futures_30min/2010/2010-05-18.parquet size: 78 KB rows: 2,577
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-18 00:00:00 | ES | Futures | 1108.23 | 1108.72 | 1107.74 | 1107.98 | 961.0 |
| 2010-05-18 00:30:00 | ES | Futures | 1107.98 | 1108.96 | 1107.01 | 1107.25 | 1685.0 |
| 2010-05-18 01:00:00 | ES | Futures | 1107.01 | 1107.74 | 1105.78 | 1106.03 | 2820.0 |
| 2010-05-18 01:30:00 | ES | Futures | 1106.03 | 1108.96 | 1106.03 | 1108.47 | 4525.0 |
| 2010-05-18 02:00:00 | ES | Futures | 1108.72 | 1111.9 | 1107.98 | 1111.65 | 7461.0 |
| 2010-05-18 02:30:00 | ES | Futures | 1111.65 | 1114.09 | 1111.16 | 1113.85 | 11171.0 |
| 2010-05-18 03:00:00 | ES | Futures | 1113.61 | 1116.54 | 1111.65 | 1115.56 | 24717.0 |
| 2010-05-18 03:30:00 | ES | Futures | 1115.81 | 1115.81 | 1112.38 | 1113.61 | 13913.0 |
| 2010-05-18 04:00:00 | ES | Futures | 1113.61 | 1115.56 | 1111.9 | 1113.36 | 20750.0 |
| 2010-05-18 04:30:00 | ES | Futures | 1113.36 | 1114.58 | 1111.41 | 1111.65 | 14422.0 |
| 2010-05-18 05:00:00 | ES | Futures | 1111.41 | 1113.36 | 1110.43 | 1110.67 | 11565.0 |
| 2010-05-18 05:30:00 | ES | Futures | 1110.67 | 1113.12 | 1110.18 | 1112.63 | 7387.0 |
| 2010-05-18 06:00:00 | ES | Futures | 1112.87 | 1114.34 | 1111.9 | 1113.85 | 8580.0 |
| 2010-05-18 06:30:00 | ES | Futures | 1113.85 | 1115.81 | 1113.61 | 1115.07 | 13762.0 |
| 2010-05-18 07:00:00 | ES | Futures | 1114.83 | 1115.56 | 1114.09 | 1114.58 | 11661.0 |
| 2010-05-18 07:30:00 | ES | Futures | 1114.58 | 1117.27 | 1113.85 | 1116.54 | 21796.0 |
| 2010-05-18 08:00:00 | ES | Futures | 1116.29 | 1118.49 | 1115.07 | 1116.78 | 37119.0 |
| 2010-05-18 08:30:00 | ES | Futures | 1116.54 | 1118.98 | 1114.83 | 1118.01 | 38865.0 |
| 2010-05-18 09:00:00 | ES | Futures | 1118.25 | 1119.23 | 1116.54 | 1118.25 | 37430.0 |
| 2010-05-18 09:30:00 | ES | Futures | 1118.49 | 1121.92 | 1116.78 | 1117.76 | 216857.0 |
| 2010-05-18 10:00:00 | ES | Futures | 1117.76 | 1119.23 | 1114.83 | 1115.56 | 208707.0 |
| 2010-05-18 10:30:00 | ES | Futures | 1115.56 | 1116.05 | 1107.74 | 1110.67 | 291906.0 |
| 2010-05-18 11:00:00 | ES | Futures | 1110.67 | 1114.09 | 1109.7 | 1113.85 | 153508.0 |
| 2010-05-18 11:30:00 | ES | Futures | 1113.85 | 1114.34 | 1105.54 | 1106.76 | 152611.0 |
| 2010-05-18 12:00:00 | ES | Futures | 1107.01 | 1108.47 | 1103.1 | 1107.5 | 141101.0 |
| 2010-05-18 12:30:00 | ES | Futures | 1107.74 | 1111.65 | 1106.27 | 1106.52 | 117036.0 |
| 2010-05-18 13:00:00 | ES | Futures | 1106.52 | 1107.74 | 1100.41 | 1104.81 | 215664.0 |
| 2010-05-18 13:30:00 | ES | Futures | 1104.56 | 1106.03 | 1097.96 | 1098.21 | 191953.0 |
| 2010-05-18 14:00:00 | ES | Futures | 1098.21 | 1103.1 | 1096.5 | 1098.21 | 177360.0 |
| 2010-05-18 14:30:00 | ES | Futures | 1098.45 | 1098.45 | 1092.1 | 1093.56 | 258007.0 |
| 2010-05-18 15:00:00 | ES | Futures | 1093.81 | 1099.18 | 1090.39 | 1091.85 | 243254.0 |
| 2010-05-18 15:30:00 | ES | Futures | 1091.61 | 1097.72 | 1090.63 | 1094.05 | 271638.0 |
| 2010-05-18 16:00:00 | ES | Futures | 1094.05 | 1095.03 | 1091.85 | 1093.32 | 114139.0 |
| 2010-05-18 16:30:00 | ES | Futures | 1093.07 | 1093.32 | 1090.39 | 1090.63 | 9900.0 |
| 2010-05-18 17:00:00 | ES | Futures | 1090.63 | 1090.63 | 1085.25 | 1086.96 | 14988.0 |
| 2010-05-18 18:00:00 | ES | Futures | 1086.72 | 1089.16 | 1086.72 | 1087.21 | 7280.0 |
| 2010-05-18 18:30:00 | ES | Futures | 1086.96 | 1087.7 | 1086.72 | 1087.21 | 3323.0 |
| 2010-05-18 19:00:00 | ES | Futures | 1087.21 | 1087.21 | 1085.5 | 1086.72 | 5726.0 |
| 2010-05-18 19:30:00 | ES | Futures | 1086.72 | 1087.21 | 1083.3 | 1083.54 | 12380.0 |
| 2010-05-18 20:00:00 | ES | Futures | 1083.79 | 1086.72 | 1083.54 | 1085.01 | 11498.0 |
| 2010-05-18 20:30:00 | ES | Futures | 1085.25 | 1085.74 | 1081.34 | 1082.81 | 11746.0 |
| 2010-05-18 21:00:00 | ES | Futures | 1083.05 | 1085.99 | 1081.83 | 1085.74 | 7357.0 |
| 2010-05-18 21:30:00 | ES | Futures | 1085.74 | 1086.47 | 1084.52 | 1085.5 | 3776.0 |
| 2010-05-18 22:00:00 | ES | Futures | 1085.5 | 1086.72 | 1085.01 | 1085.74 | 3598.0 |
| 2010-05-18 22:30:00 | ES | Futures | 1085.74 | 1086.96 | 1084.76 | 1086.47 | 2453.0 |
| 2010-05-18 23:00:00 | ES | Futures | 1086.47 | 1088.19 | 1086.23 | 1087.7 | 4085.0 |
| 2010-05-18 23:30:00 | ES | Futures | 1087.7 | 1089.41 | 1087.21 | 1087.7 | 6468.0 |
| 2010-05-18 00:00:00 | NQ | Futures | 2189.6 | 2191.04 | 2188.46 | 2189.89 | 78.0 |
| 2010-05-18 00:30:00 | NQ | Futures | 2189.89 | 2190.75 | 2187.03 | 2187.03 | 104.0 |
| 2010-05-18 01:00:00 | NQ | Futures | 2187.03 | 2189.32 | 2184.74 | 2185.6 | 187.0 |
> showing 50 of 2,577 rows — these rows as CSV