PREVIEW / futures_30min / 2010-10-13
file: by_date/futures_30min/2010/2010-10-13.parquet size: 75 KB rows: 2,687
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-10-13 00:00:00 | ES | Futures | 1149.33 | 1150.07 | 1149.08 | 1150.07 | 1846.0 |
| 2010-10-13 00:30:00 | ES | Futures | 1149.82 | 1150.07 | 1149.33 | 1149.33 | 1227.0 |
| 2010-10-13 01:00:00 | ES | Futures | 1149.33 | 1149.33 | 1148.59 | 1149.08 | 4136.0 |
| 2010-10-13 01:30:00 | ES | Futures | 1148.84 | 1149.08 | 1148.35 | 1148.84 | 2975.0 |
| 2010-10-13 02:00:00 | ES | Futures | 1148.84 | 1151.06 | 1148.59 | 1150.32 | 4895.0 |
| 2010-10-13 02:30:00 | ES | Futures | 1150.32 | 1151.3 | 1150.07 | 1150.32 | 6787.0 |
| 2010-10-13 03:00:00 | ES | Futures | 1150.32 | 1151.55 | 1150.32 | 1151.3 | 13949.0 |
| 2010-10-13 03:30:00 | ES | Futures | 1151.06 | 1153.27 | 1150.81 | 1153.27 | 20466.0 |
| 2010-10-13 04:00:00 | ES | Futures | 1153.03 | 1155.49 | 1152.78 | 1154.51 | 25828.0 |
| 2010-10-13 04:30:00 | ES | Futures | 1154.51 | 1155.74 | 1154.26 | 1154.51 | 9200.0 |
| 2010-10-13 05:00:00 | ES | Futures | 1154.51 | 1155.74 | 1154.51 | 1155.0 | 7523.0 |
| 2010-10-13 05:30:00 | ES | Futures | 1155.0 | 1157.22 | 1155.0 | 1156.73 | 21363.0 |
| 2010-10-13 06:00:00 | ES | Futures | 1156.48 | 1156.73 | 1155.74 | 1155.99 | 6513.0 |
| 2010-10-13 06:30:00 | ES | Futures | 1155.74 | 1157.46 | 1155.74 | 1156.73 | 13588.0 |
| 2010-10-13 07:00:00 | ES | Futures | 1156.97 | 1156.97 | 1155.0 | 1156.48 | 21671.0 |
| 2010-10-13 07:30:00 | ES | Futures | 1156.23 | 1157.96 | 1155.74 | 1156.73 | 23113.0 |
| 2010-10-13 08:00:00 | ES | Futures | 1156.73 | 1158.2 | 1155.49 | 1157.22 | 33433.0 |
| 2010-10-13 08:30:00 | ES | Futures | 1157.46 | 1157.96 | 1155.99 | 1156.48 | 35161.0 |
| 2010-10-13 09:00:00 | ES | Futures | 1156.48 | 1156.48 | 1155.0 | 1155.49 | 38677.0 |
| 2010-10-13 09:30:00 | ES | Futures | 1155.49 | 1157.22 | 1152.78 | 1156.48 | 275738.0 |
| 2010-10-13 10:00:00 | ES | Futures | 1156.48 | 1158.45 | 1155.25 | 1156.97 | 174718.0 |
| 2010-10-13 10:30:00 | ES | Futures | 1157.22 | 1159.68 | 1156.48 | 1159.44 | 169194.0 |
| 2010-10-13 11:00:00 | ES | Futures | 1159.68 | 1161.65 | 1158.45 | 1159.68 | 185136.0 |
| 2010-10-13 11:30:00 | ES | Futures | 1159.68 | 1160.67 | 1158.94 | 1159.93 | 63553.0 |
| 2010-10-13 12:00:00 | ES | Futures | 1159.93 | 1162.39 | 1159.93 | 1161.9 | 67929.0 |
| 2010-10-13 12:30:00 | ES | Futures | 1161.9 | 1163.13 | 1161.41 | 1161.9 | 76070.0 |
| 2010-10-13 13:00:00 | ES | Futures | 1161.9 | 1162.89 | 1160.92 | 1161.65 | 53030.0 |
| 2010-10-13 13:30:00 | ES | Futures | 1161.41 | 1163.38 | 1161.41 | 1162.39 | 60635.0 |
| 2010-10-13 14:00:00 | ES | Futures | 1162.39 | 1164.37 | 1161.9 | 1162.39 | 105913.0 |
| 2010-10-13 14:30:00 | ES | Futures | 1162.15 | 1163.38 | 1160.67 | 1161.16 | 106948.0 |
| 2010-10-13 15:00:00 | ES | Futures | 1161.16 | 1162.39 | 1158.45 | 1158.7 | 167319.0 |
| 2010-10-13 15:30:00 | ES | Futures | 1158.7 | 1160.67 | 1156.97 | 1157.71 | 217969.0 |
| 2010-10-13 16:00:00 | ES | Futures | 1157.96 | 1158.7 | 1157.46 | 1158.2 | 85852.0 |
| 2010-10-13 16:30:00 | ES | Futures | 1158.2 | 1158.45 | 1157.22 | 1157.46 | 7726.0 |
| 2010-10-13 17:00:00 | ES | Futures | 1157.46 | 1157.96 | 1157.22 | 1157.71 | 2498.0 |
| 2010-10-13 18:00:00 | ES | Futures | 1157.71 | 1157.71 | 1157.22 | 1157.46 | 1976.0 |
| 2010-10-13 18:30:00 | ES | Futures | 1157.46 | 1157.71 | 1156.97 | 1157.46 | 974.0 |
| 2010-10-13 19:00:00 | ES | Futures | 1157.46 | 1157.96 | 1157.22 | 1157.96 | 1932.0 |
| 2010-10-13 19:30:00 | ES | Futures | 1157.96 | 1158.45 | 1157.46 | 1157.71 | 2941.0 |
| 2010-10-13 20:00:00 | ES | Futures | 1157.96 | 1160.18 | 1157.71 | 1160.18 | 7270.0 |
| 2010-10-13 20:30:00 | ES | Futures | 1159.93 | 1161.9 | 1159.93 | 1160.92 | 8694.0 |
| 2010-10-13 21:00:00 | ES | Futures | 1160.92 | 1161.9 | 1160.67 | 1161.65 | 3689.0 |
| 2010-10-13 21:30:00 | ES | Futures | 1161.65 | 1163.13 | 1161.65 | 1162.39 | 7479.0 |
| 2010-10-13 22:00:00 | ES | Futures | 1162.89 | 1162.89 | 1161.65 | 1161.9 | 4134.0 |
| 2010-10-13 22:30:00 | ES | Futures | 1161.9 | 1162.39 | 1160.42 | 1160.67 | 4300.0 |
| 2010-10-13 23:00:00 | ES | Futures | 1160.67 | 1160.92 | 1159.68 | 1160.18 | 2613.0 |
| 2010-10-13 23:30:00 | ES | Futures | 1159.93 | 1161.65 | 1159.68 | 1161.65 | 3321.0 |
| 2010-10-13 00:00:00 | NQ | Futures | 2339.69 | 2340.84 | 2339.12 | 2340.84 | 109.0 |
| 2010-10-13 00:30:00 | NQ | Futures | 2341.12 | 2342.56 | 2341.12 | 2342.27 | 67.0 |
| 2010-10-13 01:00:00 | NQ | Futures | 2341.41 | 2341.41 | 2339.12 | 2339.69 | 237.0 |
> showing 50 of 2,687 rows — these rows as CSV