PREVIEW / futures_30min / 2010-09-09
file: by_date/futures_30min/2010/2010-09-09.parquet size: 71 KB rows: 2,506
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-09 00:00:00 | ES | Futures | 1076.97 | 1078.2 | 1076.97 | 1077.22 | 1441.0 |
| 2010-09-09 00:30:00 | ES | Futures | 1077.22 | 1077.46 | 1076.73 | 1076.97 | 1115.0 |
| 2010-09-09 01:00:00 | ES | Futures | 1077.22 | 1077.22 | 1076.73 | 1076.73 | 1131.0 |
| 2010-09-09 01:30:00 | ES | Futures | 1076.73 | 1078.2 | 1076.73 | 1077.22 | 2606.0 |
| 2010-09-09 02:00:00 | ES | Futures | 1077.46 | 1079.18 | 1076.97 | 1078.93 | 3249.0 |
| 2010-09-09 02:30:00 | ES | Futures | 1078.93 | 1079.18 | 1077.22 | 1077.95 | 4026.0 |
| 2010-09-09 03:00:00 | ES | Futures | 1077.71 | 1079.18 | 1076.48 | 1076.97 | 12792.0 |
| 2010-09-09 03:30:00 | ES | Futures | 1076.73 | 1077.95 | 1076.73 | 1077.46 | 8237.0 |
| 2010-09-09 04:00:00 | ES | Futures | 1077.71 | 1081.39 | 1077.46 | 1080.65 | 9159.0 |
| 2010-09-09 04:30:00 | ES | Futures | 1080.65 | 1082.37 | 1079.67 | 1081.63 | 11452.0 |
| 2010-09-09 05:00:00 | ES | Futures | 1081.63 | 1082.61 | 1080.65 | 1082.12 | 9050.0 |
| 2010-09-09 05:30:00 | ES | Futures | 1081.88 | 1083.11 | 1081.88 | 1082.86 | 13387.0 |
| 2010-09-09 06:00:00 | ES | Futures | 1082.86 | 1083.35 | 1082.12 | 1082.61 | 8246.0 |
| 2010-09-09 06:30:00 | ES | Futures | 1082.61 | 1083.35 | 1082.37 | 1083.11 | 4456.0 |
| 2010-09-09 07:00:00 | ES | Futures | 1082.86 | 1083.6 | 1082.61 | 1082.86 | 5619.0 |
| 2010-09-09 07:30:00 | ES | Futures | 1083.11 | 1083.35 | 1081.63 | 1081.88 | 7741.0 |
| 2010-09-09 08:00:00 | ES | Futures | 1081.88 | 1083.11 | 1081.63 | 1082.86 | 18941.0 |
| 2010-09-09 08:30:00 | ES | Futures | 1083.11 | 1088.01 | 1081.88 | 1086.79 | 99326.0 |
| 2010-09-09 09:00:00 | ES | Futures | 1086.79 | 1091.45 | 1086.79 | 1090.22 | 97602.0 |
| 2010-09-09 09:30:00 | ES | Futures | 1090.22 | 1090.96 | 1086.05 | 1088.75 | 142647.0 |
| 2010-09-09 10:00:00 | ES | Futures | 1088.5 | 1088.99 | 1085.31 | 1087.03 | 84968.0 |
| 2010-09-09 10:30:00 | ES | Futures | 1086.79 | 1087.03 | 1084.58 | 1084.58 | 56247.0 |
| 2010-09-09 11:00:00 | ES | Futures | 1084.82 | 1088.26 | 1084.58 | 1088.01 | 54281.0 |
| 2010-09-09 11:30:00 | ES | Futures | 1088.01 | 1088.75 | 1086.79 | 1087.03 | 30664.0 |
| 2010-09-09 12:00:00 | ES | Futures | 1087.28 | 1088.01 | 1086.79 | 1087.77 | 24213.0 |
| 2010-09-09 12:30:00 | ES | Futures | 1087.77 | 1088.01 | 1083.6 | 1083.6 | 38692.0 |
| 2010-09-09 13:00:00 | ES | Futures | 1083.6 | 1084.58 | 1081.39 | 1081.39 | 59377.0 |
| 2010-09-09 13:30:00 | ES | Futures | 1081.39 | 1083.84 | 1080.16 | 1081.39 | 55111.0 |
| 2010-09-09 14:00:00 | ES | Futures | 1081.14 | 1082.86 | 1080.41 | 1081.39 | 34432.0 |
| 2010-09-09 14:30:00 | ES | Futures | 1081.14 | 1084.33 | 1081.14 | 1083.84 | 35413.0 |
| 2010-09-09 15:00:00 | ES | Futures | 1083.84 | 1085.56 | 1083.6 | 1085.07 | 35906.0 |
| 2010-09-09 15:30:00 | ES | Futures | 1085.07 | 1086.54 | 1082.86 | 1083.35 | 65470.0 |
| 2010-09-09 16:00:00 | ES | Futures | 1083.11 | 1084.33 | 1081.63 | 1082.37 | 48029.0 |
| 2010-09-09 16:30:00 | ES | Futures | 1082.61 | 1083.11 | 1081.14 | 1081.39 | 3782.0 |
| 2010-09-09 17:00:00 | ES | Futures | 1081.39 | 1082.61 | 1080.16 | 1081.63 | 5088.0 |
| 2010-09-09 18:00:00 | ES | Futures | 1081.39 | 1081.88 | 1080.9 | 1081.88 | 721.0 |
| 2010-09-09 18:30:00 | ES | Futures | 1081.88 | 1082.12 | 1081.63 | 1082.12 | 282.0 |
| 2010-09-09 19:00:00 | ES | Futures | 1082.12 | 1082.37 | 1081.39 | 1081.63 | 283.0 |
| 2010-09-09 19:30:00 | ES | Futures | 1081.39 | 1082.37 | 1081.39 | 1081.63 | 691.0 |
| 2010-09-09 20:00:00 | ES | Futures | 1081.39 | 1084.09 | 1080.9 | 1083.6 | 2446.0 |
| 2010-09-09 20:30:00 | ES | Futures | 1083.6 | 1084.09 | 1083.11 | 1083.6 | 3222.0 |
| 2010-09-09 21:00:00 | ES | Futures | 1083.84 | 1085.07 | 1083.11 | 1083.35 | 2749.0 |
| 2010-09-09 21:30:00 | ES | Futures | 1083.6 | 1084.33 | 1082.37 | 1083.84 | 2309.0 |
| 2010-09-09 22:00:00 | ES | Futures | 1083.84 | 1084.33 | 1082.12 | 1082.86 | 1327.0 |
| 2010-09-09 22:30:00 | ES | Futures | 1082.86 | 1083.11 | 1081.88 | 1082.12 | 854.0 |
| 2010-09-09 23:00:00 | ES | Futures | 1082.12 | 1082.37 | 1081.14 | 1081.88 | 1008.0 |
| 2010-09-09 23:30:00 | ES | Futures | 1081.63 | 1081.88 | 1080.41 | 1080.65 | 1470.0 |
| 2010-09-09 00:00:00 | NQ | Futures | 2150.1 | 2151.82 | 2150.1 | 2150.96 | 85.0 |
| 2010-09-09 00:30:00 | NQ | Futures | 2150.68 | 2150.96 | 2149.53 | 2150.39 | 67.0 |
| 2010-09-09 01:00:00 | NQ | Futures | 2150.39 | 2150.39 | 2149.53 | 2149.53 | 39.0 |
> showing 50 of 2,506 rows — these rows as CSV