PREVIEW / futures_30min / 2010-05-19
file: by_date/futures_30min/2010/2010-05-19.parquet size: 75 KB rows: 2,573
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-05-19 00:00:00 | ES | Futures | 1087.7 | 1089.16 | 1086.72 | 1087.94 | 2468.0 |
| 2010-05-19 00:30:00 | ES | Futures | 1087.94 | 1087.94 | 1085.99 | 1087.21 | 2904.0 |
| 2010-05-19 01:00:00 | ES | Futures | 1087.21 | 1090.63 | 1086.96 | 1089.41 | 4453.0 |
| 2010-05-19 01:30:00 | ES | Futures | 1089.65 | 1090.63 | 1088.67 | 1089.9 | 3975.0 |
| 2010-05-19 02:00:00 | ES | Futures | 1090.14 | 1091.61 | 1086.23 | 1089.16 | 15021.0 |
| 2010-05-19 02:30:00 | ES | Futures | 1089.16 | 1091.61 | 1087.7 | 1091.61 | 11868.0 |
| 2010-05-19 03:00:00 | ES | Futures | 1091.61 | 1092.83 | 1087.45 | 1092.1 | 38747.0 |
| 2010-05-19 03:30:00 | ES | Futures | 1092.1 | 1092.83 | 1088.43 | 1089.41 | 25138.0 |
| 2010-05-19 04:00:00 | ES | Futures | 1089.16 | 1089.16 | 1083.05 | 1083.79 | 36322.0 |
| 2010-05-19 04:30:00 | ES | Futures | 1084.03 | 1084.52 | 1080.85 | 1083.79 | 36683.0 |
| 2010-05-19 05:00:00 | ES | Futures | 1083.54 | 1084.76 | 1081.1 | 1081.83 | 19144.0 |
| 2010-05-19 05:30:00 | ES | Futures | 1081.83 | 1084.03 | 1080.12 | 1081.1 | 25025.0 |
| 2010-05-19 06:00:00 | ES | Futures | 1081.1 | 1083.05 | 1080.36 | 1081.83 | 14275.0 |
| 2010-05-19 06:30:00 | ES | Futures | 1081.83 | 1084.03 | 1081.59 | 1083.79 | 18398.0 |
| 2010-05-19 07:00:00 | ES | Futures | 1084.03 | 1087.21 | 1083.79 | 1086.47 | 30237.0 |
| 2010-05-19 07:30:00 | ES | Futures | 1086.23 | 1086.72 | 1083.3 | 1086.47 | 19532.0 |
| 2010-05-19 08:00:00 | ES | Futures | 1086.47 | 1091.12 | 1085.25 | 1087.94 | 60614.0 |
| 2010-05-19 08:30:00 | ES | Futures | 1087.94 | 1092.1 | 1086.47 | 1091.36 | 60029.0 |
| 2010-05-19 09:00:00 | ES | Futures | 1091.12 | 1091.61 | 1087.94 | 1087.94 | 63396.0 |
| 2010-05-19 09:30:00 | ES | Futures | 1087.94 | 1097.72 | 1087.7 | 1093.56 | 356112.0 |
| 2010-05-19 10:00:00 | ES | Futures | 1093.32 | 1093.81 | 1078.9 | 1086.23 | 446284.0 |
| 2010-05-19 10:30:00 | ES | Futures | 1086.47 | 1089.65 | 1082.56 | 1086.23 | 272143.0 |
| 2010-05-19 11:00:00 | ES | Futures | 1085.99 | 1086.96 | 1077.19 | 1079.88 | 208341.0 |
| 2010-05-19 11:30:00 | ES | Futures | 1079.88 | 1081.1 | 1074.25 | 1079.63 | 248209.0 |
| 2010-05-19 12:00:00 | ES | Futures | 1079.63 | 1086.23 | 1078.41 | 1084.27 | 179331.0 |
| 2010-05-19 12:30:00 | ES | Futures | 1084.03 | 1088.43 | 1080.36 | 1088.19 | 124130.0 |
| 2010-05-19 13:00:00 | ES | Futures | 1088.19 | 1091.85 | 1085.01 | 1089.16 | 169996.0 |
| 2010-05-19 13:30:00 | ES | Futures | 1089.41 | 1092.34 | 1085.99 | 1089.41 | 132282.0 |
| 2010-05-19 14:00:00 | ES | Futures | 1089.41 | 1093.07 | 1085.01 | 1087.94 | 136861.0 |
| 2010-05-19 14:30:00 | ES | Futures | 1087.7 | 1091.61 | 1085.5 | 1087.94 | 126236.0 |
| 2010-05-19 15:00:00 | ES | Futures | 1087.7 | 1089.16 | 1082.32 | 1088.67 | 192165.0 |
| 2010-05-19 15:30:00 | ES | Futures | 1088.67 | 1093.32 | 1087.21 | 1087.94 | 287190.0 |
| 2010-05-19 16:00:00 | ES | Futures | 1087.94 | 1088.19 | 1084.76 | 1085.01 | 111646.0 |
| 2010-05-19 16:30:00 | ES | Futures | 1085.25 | 1090.87 | 1085.25 | 1090.14 | 18941.0 |
| 2010-05-19 17:00:00 | ES | Futures | 1090.39 | 1090.39 | 1087.94 | 1089.65 | 2981.0 |
| 2010-05-19 18:00:00 | ES | Futures | 1090.14 | 1090.63 | 1089.16 | 1089.65 | 2938.0 |
| 2010-05-19 18:30:00 | ES | Futures | 1089.65 | 1089.9 | 1088.43 | 1088.67 | 1424.0 |
| 2010-05-19 19:00:00 | ES | Futures | 1088.67 | 1090.87 | 1088.43 | 1090.14 | 1320.0 |
| 2010-05-19 19:30:00 | ES | Futures | 1090.39 | 1091.61 | 1088.67 | 1090.39 | 3062.0 |
| 2010-05-19 20:00:00 | ES | Futures | 1090.63 | 1090.63 | 1088.43 | 1089.9 | 4172.0 |
| 2010-05-19 20:30:00 | ES | Futures | 1089.9 | 1090.87 | 1088.19 | 1088.19 | 3678.0 |
| 2010-05-19 21:00:00 | ES | Futures | 1088.19 | 1088.67 | 1085.99 | 1086.23 | 4911.0 |
| 2010-05-19 21:30:00 | ES | Futures | 1086.23 | 1088.43 | 1085.99 | 1087.45 | 3638.0 |
| 2010-05-19 22:00:00 | ES | Futures | 1087.21 | 1088.92 | 1086.23 | 1088.92 | 4380.0 |
| 2010-05-19 22:30:00 | ES | Futures | 1088.67 | 1089.65 | 1087.45 | 1087.94 | 2549.0 |
| 2010-05-19 23:00:00 | ES | Futures | 1087.7 | 1088.19 | 1086.96 | 1087.21 | 1040.0 |
| 2010-05-19 23:30:00 | ES | Futures | 1087.21 | 1087.45 | 1085.5 | 1085.99 | 2460.0 |
| 2010-05-19 00:00:00 | NQ | Futures | 2150.37 | 2154.09 | 2149.51 | 2151.52 | 198.0 |
| 2010-05-19 00:30:00 | NQ | Futures | 2151.23 | 2151.23 | 2147.79 | 2150.66 | 140.0 |
| 2010-05-19 01:00:00 | NQ | Futures | 2150.09 | 2156.96 | 2149.8 | 2154.38 | 159.0 |
> showing 50 of 2,573 rows — these rows as CSV