PREVIEW / futures_30min / 2010-10-15
file: by_date/futures_30min/2010/2010-10-15.parquet size: 63 KB rows: 2,160
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-15 00:00:00 | ES | Futures | 1156.97 | 1157.46 | 1155.74 | 1155.99 | 1478.0 |
| 2010-10-15 00:30:00 | ES | Futures | 1156.23 | 1156.73 | 1155.99 | 1156.48 | 1215.0 |
| 2010-10-15 01:00:00 | ES | Futures | 1156.48 | 1157.71 | 1156.23 | 1157.46 | 1824.0 |
| 2010-10-15 01:30:00 | ES | Futures | 1157.46 | 1158.2 | 1156.97 | 1157.71 | 2175.0 |
| 2010-10-15 02:00:00 | ES | Futures | 1157.71 | 1158.2 | 1156.48 | 1157.71 | 4741.0 |
| 2010-10-15 02:30:00 | ES | Futures | 1157.71 | 1159.93 | 1157.46 | 1159.19 | 7796.0 |
| 2010-10-15 03:00:00 | ES | Futures | 1159.19 | 1159.44 | 1155.99 | 1156.48 | 19304.0 |
| 2010-10-15 03:30:00 | ES | Futures | 1156.48 | 1156.97 | 1155.25 | 1155.99 | 11051.0 |
| 2010-10-15 04:00:00 | ES | Futures | 1156.23 | 1156.97 | 1154.51 | 1156.73 | 13494.0 |
| 2010-10-15 04:30:00 | ES | Futures | 1156.73 | 1157.46 | 1156.23 | 1156.97 | 9618.0 |
| 2010-10-15 05:00:00 | ES | Futures | 1156.97 | 1157.22 | 1155.74 | 1156.48 | 7113.0 |
| 2010-10-15 05:30:00 | ES | Futures | 1156.48 | 1157.22 | 1154.75 | 1155.74 | 9417.0 |
| 2010-10-15 06:00:00 | ES | Futures | 1155.99 | 1156.73 | 1154.51 | 1155.49 | 9024.0 |
| 2010-10-15 06:30:00 | ES | Futures | 1155.49 | 1155.74 | 1154.01 | 1155.0 | 13732.0 |
| 2010-10-15 07:00:00 | ES | Futures | 1155.0 | 1155.74 | 1153.77 | 1154.01 | 13057.0 |
| 2010-10-15 07:30:00 | ES | Futures | 1154.01 | 1155.99 | 1153.77 | 1155.25 | 19921.0 |
| 2010-10-15 08:00:00 | ES | Futures | 1155.25 | 1161.9 | 1155.25 | 1158.45 | 85286.0 |
| 2010-10-15 08:30:00 | ES | Futures | 1158.7 | 1163.38 | 1158.45 | 1159.44 | 126674.0 |
| 2010-10-15 09:00:00 | ES | Futures | 1159.19 | 1162.89 | 1157.46 | 1161.65 | 83694.0 |
| 2010-10-15 09:30:00 | ES | Futures | 1161.65 | 1162.39 | 1153.77 | 1154.51 | 318655.0 |
| 2010-10-15 10:00:00 | ES | Futures | 1154.51 | 1156.48 | 1146.62 | 1148.84 | 362068.0 |
| 2010-10-15 10:30:00 | ES | Futures | 1148.59 | 1152.78 | 1147.11 | 1151.55 | 185215.0 |
| 2010-10-15 11:00:00 | ES | Futures | 1151.8 | 1155.0 | 1151.55 | 1154.51 | 143471.0 |
| 2010-10-15 11:30:00 | ES | Futures | 1154.26 | 1157.22 | 1151.06 | 1151.8 | 185497.0 |
| 2010-10-15 12:00:00 | ES | Futures | 1151.8 | 1154.01 | 1149.82 | 1154.01 | 165867.0 |
| 2010-10-15 12:30:00 | ES | Futures | 1153.77 | 1155.99 | 1152.78 | 1153.52 | 102650.0 |
| 2010-10-15 13:00:00 | ES | Futures | 1153.77 | 1154.75 | 1153.03 | 1154.51 | 48380.0 |
| 2010-10-15 13:30:00 | ES | Futures | 1154.51 | 1155.0 | 1151.3 | 1152.04 | 100860.0 |
| 2010-10-15 14:00:00 | ES | Futures | 1152.04 | 1155.0 | 1150.56 | 1154.75 | 88626.0 |
| 2010-10-15 14:30:00 | ES | Futures | 1154.75 | 1156.23 | 1152.78 | 1154.26 | 75058.0 |
| 2010-10-15 15:00:00 | ES | Futures | 1154.01 | 1154.26 | 1151.8 | 1152.78 | 86792.0 |
| 2010-10-15 15:30:00 | ES | Futures | 1152.78 | 1156.73 | 1152.29 | 1155.99 | 165661.0 |
| 2010-10-15 16:00:00 | ES | Futures | 1156.23 | 1158.94 | 1155.49 | 1158.45 | 105647.0 |
| 2010-10-15 00:00:00 | NQ | Futures | 2375.27 | 2375.27 | 2372.11 | 2372.68 | 74.0 |
| 2010-10-15 00:30:00 | NQ | Futures | 2372.97 | 2373.83 | 2372.4 | 2373.54 | 60.0 |
| 2010-10-15 01:00:00 | NQ | Futures | 2373.54 | 2375.55 | 2373.26 | 2375.27 | 96.0 |
| 2010-10-15 01:30:00 | NQ | Futures | 2374.98 | 2376.41 | 2374.41 | 2374.98 | 176.0 |
| 2010-10-15 02:00:00 | NQ | Futures | 2374.98 | 2375.27 | 2372.68 | 2374.98 | 347.0 |
| 2010-10-15 02:30:00 | NQ | Futures | 2374.98 | 2378.42 | 2374.12 | 2377.56 | 416.0 |
| 2010-10-15 03:00:00 | NQ | Futures | 2377.27 | 2377.27 | 2369.81 | 2370.39 | 1261.0 |
| 2010-10-15 03:30:00 | NQ | Futures | 2370.39 | 2372.97 | 2368.95 | 2371.25 | 1124.0 |
| 2010-10-15 04:00:00 | NQ | Futures | 2370.96 | 2372.11 | 2368.09 | 2371.25 | 979.0 |
| 2010-10-15 04:30:00 | NQ | Futures | 2371.54 | 2373.26 | 2370.96 | 2372.97 | 380.0 |
| 2010-10-15 05:00:00 | NQ | Futures | 2372.97 | 2372.97 | 2370.1 | 2372.11 | 299.0 |
| 2010-10-15 05:30:00 | NQ | Futures | 2372.11 | 2372.68 | 2368.38 | 2370.39 | 361.0 |
| 2010-10-15 06:00:00 | NQ | Futures | 2370.39 | 2371.82 | 2367.52 | 2369.53 | 567.0 |
| 2010-10-15 06:30:00 | NQ | Futures | 2369.53 | 2369.53 | 2367.23 | 2368.38 | 661.0 |
| 2010-10-15 07:00:00 | NQ | Futures | 2368.38 | 2370.1 | 2366.37 | 2366.66 | 1197.0 |
| 2010-10-15 07:30:00 | NQ | Futures | 2366.95 | 2369.81 | 2365.51 | 2369.53 | 1180.0 |
| 2010-10-15 08:00:00 | NQ | Futures | 2369.53 | 2381.86 | 2369.24 | 2373.83 | 6833.0 |
> showing 50 of 2,160 rows — these rows as CSV