PREVIEW / futures_1hour / 2010-06-11
file: by_date/futures_1hour/2010/2010-06-11.parquet size: 38 KB rows: 1,076
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-06-11 00:00:00 | ES | Futures | 1058.12 | 1060.57 | 1058.12 | 1058.12 | 1974.0 |
| 2010-06-11 01:00:00 | ES | Futures | 1058.12 | 1060.08 | 1057.39 | 1059.59 | 2167.0 |
| 2010-06-11 02:00:00 | ES | Futures | 1059.59 | 1061.79 | 1059.59 | 1059.83 | 8667.0 |
| 2010-06-11 03:00:00 | ES | Futures | 1059.83 | 1060.57 | 1057.63 | 1057.63 | 16759.0 |
| 2010-06-11 04:00:00 | ES | Futures | 1057.63 | 1061.54 | 1057.63 | 1060.08 | 14661.0 |
| 2010-06-11 05:00:00 | ES | Futures | 1059.83 | 1063.25 | 1059.83 | 1062.28 | 12346.0 |
| 2010-06-11 06:00:00 | ES | Futures | 1062.28 | 1063.01 | 1059.83 | 1060.08 | 12276.0 |
| 2010-06-11 07:00:00 | ES | Futures | 1060.08 | 1061.54 | 1058.85 | 1060.08 | 11775.0 |
| 2010-06-11 08:00:00 | ES | Futures | 1060.08 | 1061.3 | 1050.79 | 1051.28 | 74721.0 |
| 2010-06-11 09:00:00 | ES | Futures | 1051.28 | 1060.08 | 1050.54 | 1059.59 | 111646.0 |
| 2010-06-11 10:00:00 | ES | Futures | 1059.59 | 1064.48 | 1057.63 | 1058.85 | 133295.0 |
| 2010-06-11 11:00:00 | ES | Futures | 1058.85 | 1060.57 | 1054.94 | 1060.32 | 85944.0 |
| 2010-06-11 12:00:00 | ES | Futures | 1060.32 | 1060.81 | 1056.65 | 1059.34 | 37598.0 |
| 2010-06-11 13:00:00 | ES | Futures | 1059.34 | 1062.52 | 1057.63 | 1058.37 | 35544.0 |
| 2010-06-11 14:00:00 | ES | Futures | 1058.61 | 1060.57 | 1055.68 | 1059.1 | 29856.0 |
| 2010-06-11 15:00:00 | ES | Futures | 1059.1 | 1067.9 | 1057.88 | 1067.17 | 87984.0 |
| 2010-06-11 16:00:00 | ES | Futures | 1067.17 | 1067.17 | 1064.72 | 1065.21 | 29087.0 |
| 2010-06-11 00:00:00 | NQ | Futures | 2084.51 | 2087.94 | 2084.22 | 2084.22 | 42.0 |
| 2010-06-11 01:00:00 | NQ | Futures | 2087.08 | 2087.08 | 2082.79 | 2086.51 | 106.0 |
| 2010-06-11 02:00:00 | NQ | Futures | 2088.23 | 2091.67 | 2088.23 | 2089.37 | 809.0 |
| 2010-06-11 03:00:00 | NQ | Futures | 2089.66 | 2091.09 | 2083.65 | 2085.94 | 1342.0 |
| 2010-06-11 04:00:00 | NQ | Futures | 2086.22 | 2091.67 | 2084.79 | 2088.8 | 1079.0 |
| 2010-06-11 05:00:00 | NQ | Futures | 2089.66 | 2093.67 | 2088.8 | 2092.52 | 707.0 |
| 2010-06-11 06:00:00 | NQ | Futures | 2092.52 | 2094.53 | 2088.52 | 2088.8 | 773.0 |
| 2010-06-11 07:00:00 | NQ | Futures | 2089.09 | 2091.95 | 2086.8 | 2089.66 | 1095.0 |
| 2010-06-11 08:00:00 | NQ | Futures | 2089.37 | 2092.24 | 2071.05 | 2071.62 | 7584.0 |
| 2010-06-11 09:00:00 | NQ | Futures | 2071.91 | 2095.39 | 2070.76 | 2094.24 | 13661.0 |
| 2010-06-11 10:00:00 | NQ | Futures | 2093.96 | 2111.14 | 2090.23 | 2096.25 | 14827.0 |
| 2010-06-11 11:00:00 | NQ | Futures | 2095.96 | 2100.83 | 2085.08 | 2100.26 | 10776.0 |
| 2010-06-11 12:00:00 | NQ | Futures | 2100.26 | 2101.69 | 2092.24 | 2098.25 | 4194.0 |
| 2010-06-11 13:00:00 | NQ | Futures | 2098.25 | 2107.13 | 2092.81 | 2095.67 | 4350.0 |
| 2010-06-11 14:00:00 | NQ | Futures | 2095.67 | 2101.97 | 2089.09 | 2098.25 | 4791.0 |
| 2010-06-11 15:00:00 | NQ | Futures | 2098.25 | 2117.73 | 2095.96 | 2115.15 | 9690.0 |
| 2010-06-11 16:00:00 | NQ | Futures | 2115.15 | 2115.43 | 2107.99 | 2112.28 | 1683.0 |
| 2010-06-11 00:00:00 | YM | Futures | 9540.8 | 9556.0 | 9539.0 | 9542.7 | 171.0 |
| 2010-06-11 01:00:00 | YM | Futures | 9542.7 | 9551.3 | 9533.3 | 9544.6 | 187.0 |
| 2010-06-11 02:00:00 | YM | Futures | 9546.5 | 9564.5 | 9546.5 | 9550.3 | 1047.0 |
| 2010-06-11 03:00:00 | YM | Futures | 9551.3 | 9556.9 | 9531.4 | 9534.2 | 4584.0 |
| 2010-06-11 04:00:00 | YM | Futures | 9535.2 | 9561.7 | 9530.4 | 9548.4 | 3361.0 |
| 2010-06-11 05:00:00 | YM | Futures | 9549.4 | 9571.1 | 9549.4 | 9566.4 | 2268.0 |
| 2010-06-11 06:00:00 | YM | Futures | 9567.4 | 9574.9 | 9554.1 | 9555.0 | 1484.0 |
| 2010-06-11 07:00:00 | YM | Futures | 9555.0 | 9564.5 | 9545.6 | 9550.3 | 1560.0 |
| 2010-06-11 08:00:00 | YM | Futures | 9553.2 | 9563.6 | 9479.3 | 9482.2 | 5598.0 |
| 2010-06-11 09:00:00 | YM | Futures | 9482.2 | 9547.5 | 9477.4 | 9542.7 | 14284.0 |
| 2010-06-11 10:00:00 | YM | Futures | 9544.6 | 9579.7 | 9530.4 | 9541.8 | 21972.0 |
| 2010-06-11 11:00:00 | YM | Futures | 9542.7 | 9556.9 | 9509.6 | 9556.0 | 14145.0 |
| 2010-06-11 12:00:00 | YM | Futures | 9555.0 | 9557.9 | 9520.0 | 9538.0 | 8413.0 |
| 2010-06-11 13:00:00 | YM | Futures | 9539.0 | 9568.3 | 9526.6 | 9531.4 | 7044.0 |
| 2010-06-11 14:00:00 | YM | Futures | 9532.3 | 9552.2 | 9510.6 | 9539.0 | 8917.0 |
| 2010-06-11 15:00:00 | YM | Futures | 9539.0 | 9613.7 | 9527.6 | 9611.8 | 19298.0 |
> showing 50 of 1,076 rows — these rows as CSV