PREVIEW / futures_30min / 2010-08-13
file: by_date/futures_30min/2010/2010-08-13.parquet size: 60 KB rows: 2,033
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-08-13 00:00:00 | ES | Futures | 1065.93 | 1065.93 | 1064.21 | 1065.19 | 1863.0 |
| 2010-08-13 00:30:00 | ES | Futures | 1065.19 | 1065.19 | 1064.46 | 1064.95 | 975.0 |
| 2010-08-13 01:00:00 | ES | Futures | 1064.95 | 1066.66 | 1064.7 | 1066.42 | 2913.0 |
| 2010-08-13 01:30:00 | ES | Futures | 1066.42 | 1067.4 | 1065.93 | 1066.91 | 4974.0 |
| 2010-08-13 02:00:00 | ES | Futures | 1066.91 | 1068.87 | 1066.91 | 1068.38 | 13576.0 |
| 2010-08-13 02:30:00 | ES | Futures | 1068.38 | 1068.38 | 1067.16 | 1067.65 | 6791.0 |
| 2010-08-13 03:00:00 | ES | Futures | 1067.65 | 1068.38 | 1066.17 | 1067.65 | 15643.0 |
| 2010-08-13 03:30:00 | ES | Futures | 1067.65 | 1068.14 | 1064.95 | 1065.19 | 12465.0 |
| 2010-08-13 04:00:00 | ES | Futures | 1065.19 | 1066.66 | 1064.95 | 1065.68 | 7892.0 |
| 2010-08-13 04:30:00 | ES | Futures | 1065.44 | 1067.4 | 1065.19 | 1065.68 | 6627.0 |
| 2010-08-13 05:00:00 | ES | Futures | 1065.68 | 1066.17 | 1060.28 | 1060.78 | 16977.0 |
| 2010-08-13 05:30:00 | ES | Futures | 1060.78 | 1061.76 | 1057.09 | 1057.83 | 23918.0 |
| 2010-08-13 06:00:00 | ES | Futures | 1057.83 | 1058.32 | 1054.89 | 1056.6 | 20624.0 |
| 2010-08-13 06:30:00 | ES | Futures | 1056.85 | 1057.34 | 1055.87 | 1056.11 | 10619.0 |
| 2010-08-13 07:00:00 | ES | Futures | 1056.11 | 1057.34 | 1055.62 | 1056.36 | 10171.0 |
| 2010-08-13 07:30:00 | ES | Futures | 1056.6 | 1056.6 | 1054.64 | 1055.62 | 25932.0 |
| 2010-08-13 08:00:00 | ES | Futures | 1055.62 | 1056.36 | 1053.66 | 1055.13 | 25833.0 |
| 2010-08-13 08:30:00 | ES | Futures | 1055.13 | 1058.81 | 1052.68 | 1058.08 | 91024.0 |
| 2010-08-13 09:00:00 | ES | Futures | 1057.83 | 1058.57 | 1055.62 | 1057.59 | 36997.0 |
| 2010-08-13 09:30:00 | ES | Futures | 1057.34 | 1063.47 | 1057.09 | 1063.23 | 211521.0 |
| 2010-08-13 10:00:00 | ES | Futures | 1063.23 | 1064.21 | 1059.3 | 1061.02 | 146835.0 |
| 2010-08-13 10:30:00 | ES | Futures | 1061.02 | 1062.0 | 1057.83 | 1059.3 | 109566.0 |
| 2010-08-13 11:00:00 | ES | Futures | 1059.55 | 1061.02 | 1057.59 | 1058.81 | 77602.0 |
| 2010-08-13 11:30:00 | ES | Futures | 1058.57 | 1059.3 | 1056.36 | 1058.81 | 76902.0 |
| 2010-08-13 12:00:00 | ES | Futures | 1058.81 | 1061.02 | 1058.32 | 1061.02 | 37343.0 |
| 2010-08-13 12:30:00 | ES | Futures | 1060.78 | 1062.49 | 1059.79 | 1062.25 | 36334.0 |
| 2010-08-13 13:00:00 | ES | Futures | 1062.25 | 1062.98 | 1061.02 | 1062.0 | 32470.0 |
| 2010-08-13 13:30:00 | ES | Futures | 1061.76 | 1063.72 | 1061.27 | 1061.51 | 31264.0 |
| 2010-08-13 14:00:00 | ES | Futures | 1061.51 | 1062.0 | 1060.04 | 1061.02 | 29949.0 |
| 2010-08-13 14:30:00 | ES | Futures | 1061.02 | 1061.51 | 1058.57 | 1059.3 | 42314.0 |
| 2010-08-13 15:00:00 | ES | Futures | 1059.55 | 1061.27 | 1059.06 | 1059.79 | 43094.0 |
| 2010-08-13 15:30:00 | ES | Futures | 1059.79 | 1060.78 | 1056.85 | 1057.59 | 147853.0 |
| 2010-08-13 16:00:00 | ES | Futures | 1057.59 | 1058.08 | 1055.62 | 1055.87 | 86085.0 |
| 2010-08-13 00:00:00 | NQ | Futures | 2106.83 | 2106.83 | 2104.54 | 2105.97 | 163.0 |
| 2010-08-13 00:30:00 | NQ | Futures | 2106.55 | 2106.55 | 2104.83 | 2105.11 | 61.0 |
| 2010-08-13 01:00:00 | NQ | Futures | 2105.4 | 2107.98 | 2105.11 | 2107.69 | 247.0 |
| 2010-08-13 01:30:00 | NQ | Futures | 2107.98 | 2109.13 | 2107.41 | 2108.55 | 294.0 |
| 2010-08-13 02:00:00 | NQ | Futures | 2108.84 | 2112.28 | 2108.55 | 2111.13 | 671.0 |
| 2010-08-13 02:30:00 | NQ | Futures | 2110.85 | 2111.42 | 2108.84 | 2109.99 | 280.0 |
| 2010-08-13 03:00:00 | NQ | Futures | 2110.27 | 2111.42 | 2107.12 | 2109.7 | 673.0 |
| 2010-08-13 03:30:00 | NQ | Futures | 2109.41 | 2110.27 | 2104.83 | 2104.83 | 881.0 |
| 2010-08-13 04:00:00 | NQ | Futures | 2104.83 | 2107.69 | 2104.83 | 2105.69 | 482.0 |
| 2010-08-13 04:30:00 | NQ | Futures | 2105.4 | 2108.84 | 2104.54 | 2105.69 | 306.0 |
| 2010-08-13 05:00:00 | NQ | Futures | 2105.97 | 2106.83 | 2096.52 | 2096.52 | 1117.0 |
| 2010-08-13 05:30:00 | NQ | Futures | 2096.8 | 2098.81 | 2089.93 | 2090.79 | 1736.0 |
| 2010-08-13 06:00:00 | NQ | Futures | 2090.5 | 2091.07 | 2084.77 | 2087.92 | 1912.0 |
| 2010-08-13 06:30:00 | NQ | Futures | 2088.21 | 2089.35 | 2086.49 | 2087.35 | 861.0 |
| 2010-08-13 07:00:00 | NQ | Futures | 2087.06 | 2089.35 | 2086.49 | 2087.92 | 604.0 |
| 2010-08-13 07:30:00 | NQ | Futures | 2087.92 | 2087.92 | 2084.19 | 2086.49 | 1062.0 |
| 2010-08-13 08:00:00 | NQ | Futures | 2086.49 | 2087.92 | 2082.19 | 2085.63 | 2448.0 |
> showing 50 of 2,033 rows — these rows as CSV