PREVIEW / futures_30min / 2010-11-18
file: by_date/futures_30min/2010/2010-11-18.parquet size: 75 KB rows: 2,669
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-11-18 00:00:00 | ES | Futures | 1169.79 | 1169.79 | 1167.82 | 1169.05 | 5753.0 |
| 2010-11-18 00:30:00 | ES | Futures | 1169.3 | 1171.02 | 1169.05 | 1170.53 | 5338.0 |
| 2010-11-18 01:00:00 | ES | Futures | 1170.77 | 1171.76 | 1170.04 | 1170.77 | 6777.0 |
| 2010-11-18 01:30:00 | ES | Futures | 1170.53 | 1171.51 | 1170.53 | 1171.27 | 4625.0 |
| 2010-11-18 02:00:00 | ES | Futures | 1171.51 | 1172.25 | 1170.53 | 1170.53 | 8939.0 |
| 2010-11-18 02:30:00 | ES | Futures | 1170.77 | 1171.02 | 1169.79 | 1169.79 | 7793.0 |
| 2010-11-18 03:00:00 | ES | Futures | 1169.79 | 1171.02 | 1168.56 | 1169.3 | 16043.0 |
| 2010-11-18 03:30:00 | ES | Futures | 1169.05 | 1173.73 | 1169.05 | 1173.24 | 26108.0 |
| 2010-11-18 04:00:00 | ES | Futures | 1173.24 | 1173.73 | 1172.25 | 1172.75 | 11679.0 |
| 2010-11-18 04:30:00 | ES | Futures | 1172.75 | 1173.49 | 1172.5 | 1173.24 | 10111.0 |
| 2010-11-18 05:00:00 | ES | Futures | 1173.24 | 1173.24 | 1172.01 | 1172.75 | 7494.0 |
| 2010-11-18 05:30:00 | ES | Futures | 1172.75 | 1173.98 | 1172.25 | 1172.75 | 15981.0 |
| 2010-11-18 06:00:00 | ES | Futures | 1172.75 | 1173.98 | 1172.75 | 1172.99 | 12888.0 |
| 2010-11-18 06:30:00 | ES | Futures | 1172.99 | 1174.96 | 1172.99 | 1174.23 | 15350.0 |
| 2010-11-18 07:00:00 | ES | Futures | 1174.23 | 1174.47 | 1172.75 | 1173.49 | 12801.0 |
| 2010-11-18 07:30:00 | ES | Futures | 1173.73 | 1173.98 | 1172.01 | 1172.5 | 15453.0 |
| 2010-11-18 08:00:00 | ES | Futures | 1172.25 | 1173.49 | 1172.25 | 1172.5 | 16728.0 |
| 2010-11-18 08:30:00 | ES | Futures | 1172.75 | 1174.47 | 1172.25 | 1172.25 | 35997.0 |
| 2010-11-18 09:00:00 | ES | Futures | 1172.25 | 1173.24 | 1171.51 | 1172.01 | 34199.0 |
| 2010-11-18 09:30:00 | ES | Futures | 1171.76 | 1175.95 | 1171.76 | 1173.49 | 229494.0 |
| 2010-11-18 10:00:00 | ES | Futures | 1173.73 | 1181.87 | 1173.73 | 1181.13 | 340230.0 |
| 2010-11-18 10:30:00 | ES | Futures | 1181.13 | 1181.37 | 1179.89 | 1180.63 | 112502.0 |
| 2010-11-18 11:00:00 | ES | Futures | 1180.63 | 1181.87 | 1179.15 | 1180.14 | 137271.0 |
| 2010-11-18 11:30:00 | ES | Futures | 1180.14 | 1180.88 | 1179.15 | 1179.89 | 80123.0 |
| 2010-11-18 12:00:00 | ES | Futures | 1179.89 | 1182.11 | 1179.65 | 1181.13 | 80826.0 |
| 2010-11-18 12:30:00 | ES | Futures | 1181.13 | 1182.11 | 1180.14 | 1181.37 | 64132.0 |
| 2010-11-18 13:00:00 | ES | Futures | 1181.62 | 1181.62 | 1180.63 | 1181.13 | 40872.0 |
| 2010-11-18 13:30:00 | ES | Futures | 1181.13 | 1181.62 | 1179.89 | 1180.14 | 60948.0 |
| 2010-11-18 14:00:00 | ES | Futures | 1180.14 | 1180.88 | 1178.42 | 1178.91 | 73091.0 |
| 2010-11-18 14:30:00 | ES | Futures | 1178.66 | 1181.37 | 1178.66 | 1180.39 | 75624.0 |
| 2010-11-18 15:00:00 | ES | Futures | 1180.39 | 1181.13 | 1178.66 | 1179.4 | 68394.0 |
| 2010-11-18 15:30:00 | ES | Futures | 1179.65 | 1179.65 | 1176.69 | 1178.17 | 222800.0 |
| 2010-11-18 16:00:00 | ES | Futures | 1178.17 | 1181.37 | 1177.92 | 1181.13 | 121766.0 |
| 2010-11-18 16:30:00 | ES | Futures | 1180.63 | 1180.88 | 1179.65 | 1179.89 | 9721.0 |
| 2010-11-18 17:00:00 | ES | Futures | 1180.14 | 1181.37 | 1179.89 | 1181.37 | 3732.0 |
| 2010-11-18 18:00:00 | ES | Futures | 1181.37 | 1182.36 | 1181.13 | 1182.36 | 5255.0 |
| 2010-11-18 18:30:00 | ES | Futures | 1182.11 | 1182.85 | 1181.13 | 1182.61 | 4333.0 |
| 2010-11-18 19:00:00 | ES | Futures | 1182.36 | 1182.85 | 1181.13 | 1181.37 | 3225.0 |
| 2010-11-18 19:30:00 | ES | Futures | 1181.62 | 1181.62 | 1180.88 | 1181.37 | 2340.0 |
| 2010-11-18 20:00:00 | ES | Futures | 1181.37 | 1181.62 | 1180.63 | 1181.13 | 2111.0 |
| 2010-11-18 20:30:00 | ES | Futures | 1180.88 | 1181.13 | 1179.15 | 1179.65 | 5175.0 |
| 2010-11-18 21:00:00 | ES | Futures | 1179.65 | 1180.63 | 1179.15 | 1179.4 | 5805.0 |
| 2010-11-18 21:30:00 | ES | Futures | 1179.65 | 1180.39 | 1179.4 | 1180.14 | 1928.0 |
| 2010-11-18 22:00:00 | ES | Futures | 1179.89 | 1180.14 | 1177.68 | 1177.92 | 6335.0 |
| 2010-11-18 22:30:00 | ES | Futures | 1178.17 | 1178.66 | 1177.68 | 1177.68 | 2904.0 |
| 2010-11-18 23:00:00 | ES | Futures | 1177.68 | 1178.17 | 1176.94 | 1177.18 | 5162.0 |
| 2010-11-18 23:30:00 | ES | Futures | 1177.18 | 1178.42 | 1176.94 | 1178.17 | 3172.0 |
| 2010-11-18 00:00:00 | NQ | Futures | 2422.89 | 2423.75 | 2420.02 | 2422.89 | 390.0 |
| 2010-11-18 00:30:00 | NQ | Futures | 2422.89 | 2426.05 | 2422.89 | 2425.47 | 248.0 |
| 2010-11-18 01:00:00 | NQ | Futures | 2425.76 | 2426.62 | 2424.9 | 2425.47 | 236.0 |
> showing 50 of 2,669 rows — these rows as CSV