PREVIEW / futures_30min / 2010-07-16
file: by_date/futures_30min/2010/2010-07-16.parquet size: 64 KB rows: 2,082
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-07-16 00:00:00 | ES | Futures | 1069.61 | 1070.1 | 1068.63 | 1068.63 | 1722.0 |
| 2010-07-16 00:30:00 | ES | Futures | 1068.63 | 1068.87 | 1067.16 | 1067.65 | 3255.0 |
| 2010-07-16 01:00:00 | ES | Futures | 1067.4 | 1067.65 | 1065.93 | 1067.16 | 3513.0 |
| 2010-07-16 01:30:00 | ES | Futures | 1067.16 | 1067.89 | 1066.66 | 1066.91 | 1804.0 |
| 2010-07-16 02:00:00 | ES | Futures | 1066.91 | 1068.63 | 1066.66 | 1067.89 | 5661.0 |
| 2010-07-16 02:30:00 | ES | Futures | 1067.89 | 1068.63 | 1067.65 | 1068.63 | 3496.0 |
| 2010-07-16 03:00:00 | ES | Futures | 1068.63 | 1071.33 | 1068.38 | 1069.85 | 17104.0 |
| 2010-07-16 03:30:00 | ES | Futures | 1070.1 | 1071.57 | 1069.61 | 1070.1 | 11073.0 |
| 2010-07-16 04:00:00 | ES | Futures | 1069.85 | 1070.35 | 1067.65 | 1068.63 | 13576.0 |
| 2010-07-16 04:30:00 | ES | Futures | 1068.63 | 1069.12 | 1067.16 | 1067.4 | 5727.0 |
| 2010-07-16 05:00:00 | ES | Futures | 1067.4 | 1070.1 | 1066.91 | 1069.36 | 10626.0 |
| 2010-07-16 05:30:00 | ES | Futures | 1069.61 | 1072.8 | 1068.87 | 1072.06 | 8386.0 |
| 2010-07-16 06:00:00 | ES | Futures | 1071.82 | 1073.78 | 1071.57 | 1073.29 | 7345.0 |
| 2010-07-16 06:30:00 | ES | Futures | 1073.54 | 1074.27 | 1072.55 | 1072.8 | 12198.0 |
| 2010-07-16 07:00:00 | ES | Futures | 1072.8 | 1074.52 | 1072.06 | 1074.03 | 16019.0 |
| 2010-07-16 07:30:00 | ES | Futures | 1074.03 | 1074.52 | 1070.1 | 1070.84 | 16387.0 |
| 2010-07-16 08:00:00 | ES | Futures | 1070.84 | 1071.08 | 1068.38 | 1069.12 | 28610.0 |
| 2010-07-16 08:30:00 | ES | Futures | 1068.87 | 1071.57 | 1067.4 | 1068.14 | 59695.0 |
| 2010-07-16 09:00:00 | ES | Futures | 1068.38 | 1068.87 | 1064.46 | 1065.44 | 74157.0 |
| 2010-07-16 09:30:00 | ES | Futures | 1065.68 | 1066.42 | 1053.66 | 1055.38 | 346462.0 |
| 2010-07-16 10:00:00 | ES | Futures | 1055.38 | 1056.11 | 1050.72 | 1054.15 | 271915.0 |
| 2010-07-16 10:30:00 | ES | Futures | 1054.4 | 1055.87 | 1052.43 | 1055.38 | 145667.0 |
| 2010-07-16 11:00:00 | ES | Futures | 1055.38 | 1056.11 | 1049.49 | 1051.94 | 131828.0 |
| 2010-07-16 11:30:00 | ES | Futures | 1051.94 | 1052.43 | 1048.02 | 1048.51 | 115878.0 |
| 2010-07-16 12:00:00 | ES | Futures | 1048.51 | 1050.72 | 1046.54 | 1048.51 | 129126.0 |
| 2010-07-16 12:30:00 | ES | Futures | 1048.51 | 1049.0 | 1046.05 | 1046.54 | 58873.0 |
| 2010-07-16 13:00:00 | ES | Futures | 1046.54 | 1048.26 | 1045.56 | 1046.3 | 77180.0 |
| 2010-07-16 13:30:00 | ES | Futures | 1046.3 | 1049.24 | 1044.09 | 1045.32 | 122388.0 |
| 2010-07-16 14:00:00 | ES | Futures | 1045.07 | 1047.28 | 1043.84 | 1045.07 | 73806.0 |
| 2010-07-16 14:30:00 | ES | Futures | 1045.07 | 1046.05 | 1043.35 | 1043.84 | 79713.0 |
| 2010-07-16 15:00:00 | ES | Futures | 1044.09 | 1045.32 | 1039.43 | 1041.15 | 168277.0 |
| 2010-07-16 15:30:00 | ES | Futures | 1040.9 | 1044.34 | 1039.67 | 1041.88 | 288568.0 |
| 2010-07-16 16:00:00 | ES | Futures | 1041.88 | 1044.09 | 1041.39 | 1043.6 | 146161.0 |
| 2010-07-16 00:00:00 | NQ | Futures | 2120.02 | 2121.16 | 2117.44 | 2117.44 | 155.0 |
| 2010-07-16 00:30:00 | NQ | Futures | 2117.72 | 2118.01 | 2112.56 | 2112.85 | 509.0 |
| 2010-07-16 01:00:00 | NQ | Futures | 2112.85 | 2113.42 | 2110.56 | 2111.42 | 623.0 |
| 2010-07-16 01:30:00 | NQ | Futures | 2111.99 | 2113.14 | 2111.13 | 2111.71 | 161.0 |
| 2010-07-16 02:00:00 | NQ | Futures | 2111.99 | 2113.42 | 2110.85 | 2112.28 | 635.0 |
| 2010-07-16 02:30:00 | NQ | Futures | 2112.28 | 2114.57 | 2112.28 | 2114.0 | 307.0 |
| 2010-07-16 03:00:00 | NQ | Futures | 2114.28 | 2120.3 | 2114.28 | 2117.72 | 1352.0 |
| 2010-07-16 03:30:00 | NQ | Futures | 2117.72 | 2120.59 | 2116.86 | 2117.72 | 726.0 |
| 2010-07-16 04:00:00 | NQ | Futures | 2118.01 | 2118.01 | 2114.28 | 2116.58 | 864.0 |
| 2010-07-16 04:30:00 | NQ | Futures | 2116.86 | 2117.72 | 2114.0 | 2114.28 | 361.0 |
| 2010-07-16 05:00:00 | NQ | Futures | 2114.0 | 2118.3 | 2113.42 | 2117.44 | 714.0 |
| 2010-07-16 05:30:00 | NQ | Futures | 2117.72 | 2122.59 | 2116.86 | 2122.02 | 671.0 |
| 2010-07-16 06:00:00 | NQ | Futures | 2122.59 | 2125.46 | 2122.59 | 2124.89 | 997.0 |
| 2010-07-16 06:30:00 | NQ | Futures | 2125.17 | 2126.89 | 2123.45 | 2124.89 | 754.0 |
| 2010-07-16 07:00:00 | NQ | Futures | 2124.89 | 2127.18 | 2124.03 | 2126.61 | 1086.0 |
| 2010-07-16 07:30:00 | NQ | Futures | 2126.61 | 2126.89 | 2121.45 | 2122.59 | 1789.0 |
| 2010-07-16 08:00:00 | NQ | Futures | 2122.59 | 2123.17 | 2118.3 | 2120.02 | 3211.0 |
> showing 50 of 2,082 rows — these rows as CSV