PREVIEW / futures_30min / 2010-09-21
file: by_date/futures_30min/2010/2010-09-21.parquet size: 73 KB rows: 2,607
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-09-21 00:00:00 | ES | Futures | 1118.77 | 1118.77 | 1117.54 | 1117.78 | 2189.0 |
| 2010-09-21 00:30:00 | ES | Futures | 1117.78 | 1117.78 | 1116.3 | 1116.55 | 5853.0 |
| 2010-09-21 01:00:00 | ES | Futures | 1116.8 | 1117.29 | 1116.55 | 1117.04 | 3176.0 |
| 2010-09-21 01:30:00 | ES | Futures | 1117.04 | 1118.52 | 1116.55 | 1118.03 | 4758.0 |
| 2010-09-21 02:00:00 | ES | Futures | 1118.27 | 1118.52 | 1117.54 | 1117.78 | 3922.0 |
| 2010-09-21 02:30:00 | ES | Futures | 1117.78 | 1118.27 | 1116.8 | 1116.8 | 4330.0 |
| 2010-09-21 03:00:00 | ES | Futures | 1117.04 | 1119.51 | 1116.55 | 1118.52 | 12465.0 |
| 2010-09-21 03:30:00 | ES | Futures | 1118.77 | 1119.51 | 1118.03 | 1119.01 | 9549.0 |
| 2010-09-21 04:00:00 | ES | Futures | 1119.26 | 1120.74 | 1119.01 | 1120.25 | 11107.0 |
| 2010-09-21 04:30:00 | ES | Futures | 1120.25 | 1120.99 | 1119.26 | 1120.0 | 5709.0 |
| 2010-09-21 05:00:00 | ES | Futures | 1120.0 | 1122.71 | 1119.51 | 1121.73 | 14338.0 |
| 2010-09-21 05:30:00 | ES | Futures | 1121.97 | 1122.22 | 1120.25 | 1120.74 | 6236.0 |
| 2010-09-21 06:00:00 | ES | Futures | 1120.74 | 1120.99 | 1118.27 | 1119.51 | 8868.0 |
| 2010-09-21 06:30:00 | ES | Futures | 1119.75 | 1120.0 | 1118.77 | 1120.0 | 5990.0 |
| 2010-09-21 07:00:00 | ES | Futures | 1119.75 | 1121.73 | 1119.26 | 1121.23 | 7857.0 |
| 2010-09-21 07:30:00 | ES | Futures | 1120.99 | 1121.23 | 1119.75 | 1120.99 | 7879.0 |
| 2010-09-21 08:00:00 | ES | Futures | 1120.99 | 1121.48 | 1118.27 | 1118.77 | 28146.0 |
| 2010-09-21 08:30:00 | ES | Futures | 1118.77 | 1123.2 | 1118.77 | 1122.22 | 43175.0 |
| 2010-09-21 09:00:00 | ES | Futures | 1122.46 | 1123.7 | 1121.97 | 1122.22 | 32068.0 |
| 2010-09-21 09:30:00 | ES | Futures | 1122.22 | 1122.71 | 1119.51 | 1120.49 | 166353.0 |
| 2010-09-21 10:00:00 | ES | Futures | 1120.49 | 1121.97 | 1119.51 | 1120.49 | 122361.0 |
| 2010-09-21 10:30:00 | ES | Futures | 1120.74 | 1121.97 | 1119.75 | 1120.25 | 93956.0 |
| 2010-09-21 11:00:00 | ES | Futures | 1120.25 | 1121.23 | 1117.78 | 1118.03 | 96218.0 |
| 2010-09-21 11:30:00 | ES | Futures | 1118.03 | 1119.26 | 1117.54 | 1119.01 | 59257.0 |
| 2010-09-21 12:00:00 | ES | Futures | 1119.01 | 1120.0 | 1117.78 | 1118.03 | 30808.0 |
| 2010-09-21 12:30:00 | ES | Futures | 1117.78 | 1119.26 | 1117.78 | 1119.01 | 29857.0 |
| 2010-09-21 13:00:00 | ES | Futures | 1119.01 | 1119.01 | 1117.04 | 1117.54 | 48823.0 |
| 2010-09-21 13:30:00 | ES | Futures | 1117.54 | 1118.52 | 1116.55 | 1118.27 | 45927.0 |
| 2010-09-21 14:00:00 | ES | Futures | 1118.03 | 1123.94 | 1114.33 | 1122.22 | 268341.0 |
| 2010-09-21 14:30:00 | ES | Futures | 1121.97 | 1127.89 | 1120.99 | 1123.94 | 311094.0 |
| 2010-09-21 15:00:00 | ES | Futures | 1123.7 | 1123.94 | 1119.51 | 1120.99 | 180127.0 |
| 2010-09-21 15:30:00 | ES | Futures | 1120.99 | 1121.23 | 1115.32 | 1119.26 | 295122.0 |
| 2010-09-21 16:00:00 | ES | Futures | 1119.51 | 1119.75 | 1118.27 | 1118.77 | 83581.0 |
| 2010-09-21 16:30:00 | ES | Futures | 1119.01 | 1119.26 | 1117.29 | 1118.03 | 7641.0 |
| 2010-09-21 17:00:00 | ES | Futures | 1117.78 | 1118.03 | 1116.8 | 1117.54 | 2203.0 |
| 2010-09-21 18:00:00 | ES | Futures | 1117.54 | 1118.03 | 1116.8 | 1117.78 | 1778.0 |
| 2010-09-21 18:30:00 | ES | Futures | 1118.03 | 1119.01 | 1117.78 | 1118.03 | 1418.0 |
| 2010-09-21 19:00:00 | ES | Futures | 1118.03 | 1119.01 | 1117.78 | 1118.77 | 955.0 |
| 2010-09-21 19:30:00 | ES | Futures | 1118.52 | 1119.51 | 1117.04 | 1118.27 | 3635.0 |
| 2010-09-21 20:00:00 | ES | Futures | 1118.27 | 1120.25 | 1118.27 | 1120.0 | 3904.0 |
| 2010-09-21 20:30:00 | ES | Futures | 1120.25 | 1122.46 | 1120.25 | 1121.97 | 7927.0 |
| 2010-09-21 21:00:00 | ES | Futures | 1121.97 | 1122.71 | 1121.73 | 1122.22 | 1818.0 |
| 2010-09-21 21:30:00 | ES | Futures | 1122.22 | 1123.45 | 1122.22 | 1122.96 | 3968.0 |
| 2010-09-21 22:00:00 | ES | Futures | 1123.2 | 1123.2 | 1122.46 | 1122.96 | 1844.0 |
| 2010-09-21 22:30:00 | ES | Futures | 1122.71 | 1123.2 | 1122.22 | 1122.46 | 1677.0 |
| 2010-09-21 23:00:00 | ES | Futures | 1122.46 | 1122.96 | 1121.97 | 1122.96 | 1440.0 |
| 2010-09-21 23:30:00 | ES | Futures | 1122.71 | 1123.45 | 1122.46 | 1123.2 | 1569.0 |
| 2010-09-21 00:00:00 | NQ | Futures | 2273.13 | 2273.13 | 2271.98 | 2271.98 | 165.0 |
| 2010-09-21 00:30:00 | NQ | Futures | 2272.27 | 2272.55 | 2269.97 | 2270.55 | 331.0 |
| 2010-09-21 01:00:00 | NQ | Futures | 2270.55 | 2271.12 | 2269.97 | 2270.83 | 139.0 |
> showing 50 of 2,607 rows — these rows as CSV