PREVIEW / futures_30min / 2010-10-20
file: by_date/futures_30min/2010/2010-10-20.parquet size: 76 KB rows: 2,715
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-20 00:00:00 | ES | Futures | 1150.32 | 1152.04 | 1150.32 | 1151.8 | 7607.0 |
| 2010-10-20 00:30:00 | ES | Futures | 1151.55 | 1152.04 | 1151.06 | 1151.3 | 2390.0 |
| 2010-10-20 01:00:00 | ES | Futures | 1151.3 | 1151.8 | 1150.81 | 1151.06 | 3154.0 |
| 2010-10-20 01:30:00 | ES | Futures | 1151.06 | 1151.3 | 1150.07 | 1150.32 | 2974.0 |
| 2010-10-20 02:00:00 | ES | Futures | 1150.32 | 1151.06 | 1149.82 | 1150.56 | 7500.0 |
| 2010-10-20 02:30:00 | ES | Futures | 1150.81 | 1151.3 | 1148.35 | 1149.08 | 10390.0 |
| 2010-10-20 03:00:00 | ES | Futures | 1148.84 | 1150.56 | 1147.61 | 1149.82 | 16542.0 |
| 2010-10-20 03:30:00 | ES | Futures | 1150.07 | 1151.06 | 1148.59 | 1150.07 | 11600.0 |
| 2010-10-20 04:00:00 | ES | Futures | 1150.07 | 1150.32 | 1148.1 | 1149.33 | 9558.0 |
| 2010-10-20 04:30:00 | ES | Futures | 1149.08 | 1152.29 | 1148.84 | 1152.04 | 11889.0 |
| 2010-10-20 05:00:00 | ES | Futures | 1152.04 | 1152.78 | 1151.06 | 1151.3 | 11985.0 |
| 2010-10-20 05:30:00 | ES | Futures | 1151.3 | 1152.54 | 1151.06 | 1152.29 | 7263.0 |
| 2010-10-20 06:00:00 | ES | Futures | 1152.29 | 1152.78 | 1151.3 | 1151.8 | 9773.0 |
| 2010-10-20 06:30:00 | ES | Futures | 1151.8 | 1153.77 | 1151.8 | 1152.54 | 19505.0 |
| 2010-10-20 07:00:00 | ES | Futures | 1152.29 | 1152.54 | 1151.3 | 1152.29 | 13691.0 |
| 2010-10-20 07:30:00 | ES | Futures | 1152.04 | 1153.27 | 1151.06 | 1151.55 | 29102.0 |
| 2010-10-20 08:00:00 | ES | Futures | 1151.3 | 1152.54 | 1149.33 | 1150.07 | 37075.0 |
| 2010-10-20 08:30:00 | ES | Futures | 1149.82 | 1151.8 | 1148.59 | 1148.59 | 38954.0 |
| 2010-10-20 09:00:00 | ES | Futures | 1148.84 | 1150.32 | 1147.85 | 1148.35 | 39154.0 |
| 2010-10-20 09:30:00 | ES | Futures | 1148.35 | 1154.51 | 1147.61 | 1151.3 | 294619.0 |
| 2010-10-20 10:00:00 | ES | Futures | 1151.3 | 1152.54 | 1148.35 | 1151.55 | 234899.0 |
| 2010-10-20 10:30:00 | ES | Futures | 1151.55 | 1157.96 | 1151.55 | 1156.48 | 243130.0 |
| 2010-10-20 11:00:00 | ES | Futures | 1156.48 | 1159.19 | 1155.25 | 1158.7 | 153702.0 |
| 2010-10-20 11:30:00 | ES | Futures | 1158.94 | 1159.68 | 1157.96 | 1158.2 | 94228.0 |
| 2010-10-20 12:00:00 | ES | Futures | 1158.2 | 1162.64 | 1157.96 | 1161.41 | 147668.0 |
| 2010-10-20 12:30:00 | ES | Futures | 1161.41 | 1161.9 | 1160.18 | 1161.16 | 54271.0 |
| 2010-10-20 13:00:00 | ES | Futures | 1160.92 | 1162.89 | 1159.93 | 1161.65 | 89497.0 |
| 2010-10-20 13:30:00 | ES | Futures | 1161.65 | 1162.15 | 1159.68 | 1159.93 | 43613.0 |
| 2010-10-20 14:00:00 | ES | Futures | 1160.18 | 1162.15 | 1158.2 | 1160.92 | 105708.0 |
| 2010-10-20 14:30:00 | ES | Futures | 1160.92 | 1163.38 | 1159.44 | 1160.92 | 93344.0 |
| 2010-10-20 15:00:00 | ES | Futures | 1160.92 | 1162.39 | 1159.19 | 1162.15 | 76930.0 |
| 2010-10-20 15:30:00 | ES | Futures | 1162.15 | 1162.15 | 1156.73 | 1157.71 | 219658.0 |
| 2010-10-20 16:00:00 | ES | Futures | 1157.46 | 1158.7 | 1156.97 | 1158.45 | 87847.0 |
| 2010-10-20 16:30:00 | ES | Futures | 1158.2 | 1160.42 | 1158.2 | 1159.93 | 6568.0 |
| 2010-10-20 17:00:00 | ES | Futures | 1159.68 | 1159.93 | 1158.7 | 1158.94 | 2439.0 |
| 2010-10-20 18:00:00 | ES | Futures | 1160.18 | 1160.67 | 1159.68 | 1160.18 | 2257.0 |
| 2010-10-20 18:30:00 | ES | Futures | 1160.42 | 1160.67 | 1160.18 | 1160.18 | 246.0 |
| 2010-10-20 19:00:00 | ES | Futures | 1160.18 | 1160.92 | 1159.68 | 1160.18 | 1532.0 |
| 2010-10-20 19:30:00 | ES | Futures | 1160.18 | 1161.16 | 1159.93 | 1160.67 | 1880.0 |
| 2010-10-20 20:00:00 | ES | Futures | 1160.42 | 1160.67 | 1156.73 | 1157.22 | 8508.0 |
| 2010-10-20 20:30:00 | ES | Futures | 1157.22 | 1157.46 | 1155.99 | 1157.22 | 6017.0 |
| 2010-10-20 21:00:00 | ES | Futures | 1156.97 | 1159.44 | 1156.23 | 1159.19 | 9941.0 |
| 2010-10-20 21:30:00 | ES | Futures | 1158.94 | 1159.19 | 1157.71 | 1158.45 | 5978.0 |
| 2010-10-20 22:00:00 | ES | Futures | 1158.2 | 1159.44 | 1156.73 | 1158.45 | 6330.0 |
| 2010-10-20 22:30:00 | ES | Futures | 1158.45 | 1158.94 | 1156.73 | 1156.97 | 2239.0 |
| 2010-10-20 23:00:00 | ES | Futures | 1156.97 | 1157.22 | 1155.49 | 1155.74 | 2914.0 |
| 2010-10-20 23:30:00 | ES | Futures | 1155.49 | 1158.45 | 1155.49 | 1158.2 | 3511.0 |
| 2010-10-20 00:00:00 | NQ | Futures | 2381.58 | 2384.16 | 2381.0 | 2383.59 | 326.0 |
| 2010-10-20 00:30:00 | NQ | Futures | 2383.3 | 2383.59 | 2382.44 | 2382.73 | 136.0 |
| 2010-10-20 01:00:00 | NQ | Futures | 2383.01 | 2383.87 | 2382.44 | 2383.3 | 157.0 |
> showing 50 of 2,715 rows — these rows as CSV