PREVIEW / futures_30min / 2010-01-22
file: by_date/futures_30min/2010/2010-01-22.parquet size: 63 KB rows: 2,129
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-01-22 00:00:00 | ES | Futures | 1082.02 | 1082.74 | 1081.53 | 1082.26 | 2166.0 |
| 2010-01-22 00:30:00 | ES | Futures | 1082.5 | 1082.74 | 1081.04 | 1081.77 | 3607.0 |
| 2010-01-22 01:00:00 | ES | Futures | 1081.77 | 1082.99 | 1081.53 | 1082.74 | 2831.0 |
| 2010-01-22 01:30:00 | ES | Futures | 1082.74 | 1084.2 | 1082.26 | 1082.74 | 4882.0 |
| 2010-01-22 02:00:00 | ES | Futures | 1082.99 | 1083.47 | 1082.02 | 1082.74 | 6330.0 |
| 2010-01-22 02:30:00 | ES | Futures | 1082.99 | 1083.96 | 1082.5 | 1083.23 | 10565.0 |
| 2010-01-22 03:00:00 | ES | Futures | 1082.99 | 1085.66 | 1082.02 | 1085.18 | 24946.0 |
| 2010-01-22 03:30:00 | ES | Futures | 1084.93 | 1085.66 | 1083.72 | 1084.69 | 15310.0 |
| 2010-01-22 04:00:00 | ES | Futures | 1084.45 | 1085.18 | 1083.23 | 1084.93 | 11860.0 |
| 2010-01-22 04:30:00 | ES | Futures | 1084.69 | 1085.42 | 1083.23 | 1084.2 | 11316.0 |
| 2010-01-22 05:00:00 | ES | Futures | 1084.45 | 1084.93 | 1082.26 | 1082.74 | 9331.0 |
| 2010-01-22 05:30:00 | ES | Futures | 1082.99 | 1083.72 | 1081.04 | 1081.53 | 10149.0 |
| 2010-01-22 06:00:00 | ES | Futures | 1081.77 | 1082.99 | 1080.31 | 1081.53 | 10969.0 |
| 2010-01-22 06:30:00 | ES | Futures | 1081.29 | 1082.99 | 1074.96 | 1076.91 | 60067.0 |
| 2010-01-22 07:00:00 | ES | Futures | 1076.66 | 1079.83 | 1076.66 | 1079.34 | 25380.0 |
| 2010-01-22 07:30:00 | ES | Futures | 1079.34 | 1080.07 | 1077.39 | 1078.85 | 32014.0 |
| 2010-01-22 08:00:00 | ES | Futures | 1079.1 | 1080.07 | 1077.88 | 1079.83 | 25615.0 |
| 2010-01-22 08:30:00 | ES | Futures | 1079.83 | 1080.8 | 1076.42 | 1076.66 | 47372.0 |
| 2010-01-22 09:00:00 | ES | Futures | 1076.42 | 1079.83 | 1076.42 | 1077.64 | 60768.0 |
| 2010-01-22 09:30:00 | ES | Futures | 1077.88 | 1081.77 | 1075.69 | 1078.85 | 361975.0 |
| 2010-01-22 10:00:00 | ES | Futures | 1078.61 | 1079.34 | 1071.31 | 1077.39 | 350352.0 |
| 2010-01-22 10:30:00 | ES | Futures | 1077.39 | 1079.83 | 1075.2 | 1079.1 | 244307.0 |
| 2010-01-22 11:00:00 | ES | Futures | 1078.85 | 1081.53 | 1076.66 | 1081.04 | 215212.0 |
| 2010-01-22 11:30:00 | ES | Futures | 1081.04 | 1081.29 | 1076.42 | 1077.64 | 111278.0 |
| 2010-01-22 12:00:00 | ES | Futures | 1077.39 | 1079.1 | 1075.69 | 1079.1 | 121402.0 |
| 2010-01-22 12:30:00 | ES | Futures | 1078.85 | 1080.07 | 1076.18 | 1076.42 | 96257.0 |
| 2010-01-22 13:00:00 | ES | Futures | 1076.42 | 1076.91 | 1074.47 | 1075.2 | 94464.0 |
| 2010-01-22 13:30:00 | ES | Futures | 1075.2 | 1075.69 | 1071.55 | 1073.01 | 155436.0 |
| 2010-01-22 14:00:00 | ES | Futures | 1073.01 | 1074.47 | 1070.83 | 1071.55 | 138984.0 |
| 2010-01-22 14:30:00 | ES | Futures | 1071.55 | 1073.01 | 1066.2 | 1066.2 | 235110.0 |
| 2010-01-22 15:00:00 | ES | Futures | 1066.45 | 1068.64 | 1060.37 | 1062.8 | 380543.0 |
| 2010-01-22 15:30:00 | ES | Futures | 1063.04 | 1063.77 | 1056.96 | 1058.42 | 404003.0 |
| 2010-01-22 16:00:00 | ES | Futures | 1058.42 | 1062.31 | 1057.69 | 1062.07 | 203103.0 |
| 2010-01-22 00:00:00 | NQ | Futures | 2104.52 | 2106.23 | 2103.94 | 2105.66 | 341.0 |
| 2010-01-22 00:30:00 | NQ | Futures | 2105.37 | 2106.23 | 2103.94 | 2105.09 | 216.0 |
| 2010-01-22 01:00:00 | NQ | Futures | 2105.09 | 2106.8 | 2104.8 | 2106.8 | 131.0 |
| 2010-01-22 01:30:00 | NQ | Futures | 2106.51 | 2110.51 | 2106.23 | 2107.66 | 503.0 |
| 2010-01-22 02:00:00 | NQ | Futures | 2107.37 | 2108.8 | 2106.23 | 2108.23 | 612.0 |
| 2010-01-22 02:30:00 | NQ | Futures | 2108.23 | 2110.23 | 2107.94 | 2108.51 | 370.0 |
| 2010-01-22 03:00:00 | NQ | Futures | 2109.09 | 2112.8 | 2107.66 | 2111.08 | 2902.0 |
| 2010-01-22 03:30:00 | NQ | Futures | 2111.08 | 2112.51 | 2108.51 | 2109.94 | 1895.0 |
| 2010-01-22 04:00:00 | NQ | Futures | 2109.66 | 2111.08 | 2107.66 | 2110.23 | 1252.0 |
| 2010-01-22 04:30:00 | NQ | Futures | 2110.23 | 2111.66 | 2107.66 | 2110.8 | 973.0 |
| 2010-01-22 05:00:00 | NQ | Futures | 2110.51 | 2111.37 | 2107.09 | 2108.8 | 1028.0 |
| 2010-01-22 05:30:00 | NQ | Futures | 2108.8 | 2109.09 | 2105.94 | 2106.51 | 1909.0 |
| 2010-01-22 06:00:00 | NQ | Futures | 2106.51 | 2109.09 | 2104.52 | 2106.23 | 1351.0 |
| 2010-01-22 06:30:00 | NQ | Futures | 2106.23 | 2108.8 | 2097.09 | 2100.23 | 4783.0 |
| 2010-01-22 07:00:00 | NQ | Futures | 2100.52 | 2105.09 | 2099.95 | 2103.66 | 1995.0 |
| 2010-01-22 07:30:00 | NQ | Futures | 2104.23 | 2105.94 | 2100.23 | 2104.23 | 1614.0 |
| 2010-01-22 08:00:00 | NQ | Futures | 2104.23 | 2107.94 | 2102.52 | 2107.66 | 2954.0 |
> showing 50 of 2,129 rows — these rows as CSV