PREVIEW / futures_1hour / 2009-12-29
file: by_date/futures_1hour/2009/2009-12-29.parquet size: 43 KB rows: 1,339
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-29 00:00:00 | ES | Futures | 1092.96 | 1093.69 | 1092.48 | 1093.45 | 831.0 |
| 2009-12-29 01:00:00 | ES | Futures | 1093.69 | 1094.91 | 1093.45 | 1094.18 | 2177.0 |
| 2009-12-29 02:00:00 | ES | Futures | 1094.18 | 1095.15 | 1094.18 | 1094.42 | 2335.0 |
| 2009-12-29 03:00:00 | ES | Futures | 1094.18 | 1094.91 | 1092.96 | 1094.18 | 7216.0 |
| 2009-12-29 04:00:00 | ES | Futures | 1093.93 | 1094.91 | 1093.93 | 1094.42 | 4195.0 |
| 2009-12-29 05:00:00 | ES | Futures | 1094.42 | 1095.15 | 1094.18 | 1094.91 | 3736.0 |
| 2009-12-29 06:00:00 | ES | Futures | 1094.91 | 1098.07 | 1094.42 | 1097.34 | 10332.0 |
| 2009-12-29 07:00:00 | ES | Futures | 1097.1 | 1097.34 | 1096.61 | 1097.1 | 6952.0 |
| 2009-12-29 08:00:00 | ES | Futures | 1097.1 | 1097.1 | 1095.88 | 1096.12 | 12595.0 |
| 2009-12-29 09:00:00 | ES | Futures | 1096.12 | 1097.1 | 1093.93 | 1094.66 | 67839.0 |
| 2009-12-29 10:00:00 | ES | Futures | 1094.66 | 1095.88 | 1093.45 | 1094.42 | 80211.0 |
| 2009-12-29 11:00:00 | ES | Futures | 1094.42 | 1094.66 | 1091.99 | 1093.2 | 73886.0 |
| 2009-12-29 12:00:00 | ES | Futures | 1093.2 | 1093.69 | 1091.75 | 1092.72 | 54669.0 |
| 2009-12-29 13:00:00 | ES | Futures | 1092.72 | 1093.93 | 1091.99 | 1093.93 | 35801.0 |
| 2009-12-29 14:00:00 | ES | Futures | 1093.93 | 1093.93 | 1092.48 | 1092.96 | 39328.0 |
| 2009-12-29 15:00:00 | ES | Futures | 1092.96 | 1094.66 | 1091.26 | 1091.75 | 117907.0 |
| 2009-12-29 16:00:00 | ES | Futures | 1091.99 | 1092.48 | 1090.29 | 1091.75 | 51263.0 |
| 2009-12-29 17:00:00 | ES | Futures | 1091.5 | 1091.99 | 1091.26 | 1091.26 | 476.0 |
| 2009-12-29 18:00:00 | ES | Futures | 1091.75 | 1092.23 | 1091.26 | 1091.5 | 1502.0 |
| 2009-12-29 19:00:00 | ES | Futures | 1091.26 | 1091.75 | 1089.07 | 1089.8 | 4466.0 |
| 2009-12-29 20:00:00 | ES | Futures | 1089.56 | 1089.8 | 1089.07 | 1089.31 | 1942.0 |
| 2009-12-29 21:00:00 | ES | Futures | 1089.31 | 1089.8 | 1088.83 | 1089.07 | 1382.0 |
| 2009-12-29 22:00:00 | ES | Futures | 1088.83 | 1089.56 | 1088.83 | 1089.56 | 839.0 |
| 2009-12-29 23:00:00 | ES | Futures | 1089.31 | 1089.8 | 1088.58 | 1089.07 | 2310.0 |
| 2009-12-29 00:00:00 | NQ | Futures | 2141.93 | 2143.93 | 2141.93 | 2142.22 | 92.0 |
| 2009-12-29 01:00:00 | NQ | Futures | 2142.22 | 2145.07 | 2141.93 | 2143.08 | 184.0 |
| 2009-12-29 02:00:00 | NQ | Futures | 2143.36 | 2147.36 | 2143.36 | 2145.93 | 710.0 |
| 2009-12-29 03:00:00 | NQ | Futures | 2145.93 | 2146.5 | 2142.79 | 2143.93 | 909.0 |
| 2009-12-29 04:00:00 | NQ | Futures | 2143.93 | 2145.07 | 2143.65 | 2143.93 | 365.0 |
| 2009-12-29 05:00:00 | NQ | Futures | 2144.22 | 2145.93 | 2143.93 | 2145.36 | 506.0 |
| 2009-12-29 06:00:00 | NQ | Futures | 2145.65 | 2149.36 | 2144.5 | 2147.93 | 1223.0 |
| 2009-12-29 07:00:00 | NQ | Futures | 2148.5 | 2148.79 | 2146.22 | 2147.65 | 1076.0 |
| 2009-12-29 08:00:00 | NQ | Futures | 2147.65 | 2147.93 | 2145.93 | 2146.79 | 893.0 |
| 2009-12-29 09:00:00 | NQ | Futures | 2147.07 | 2148.22 | 2141.08 | 2142.79 | 17449.0 |
| 2009-12-29 10:00:00 | NQ | Futures | 2143.08 | 2143.65 | 2137.93 | 2141.08 | 15027.0 |
| 2009-12-29 11:00:00 | NQ | Futures | 2141.08 | 2141.65 | 2136.22 | 2138.79 | 13245.0 |
| 2009-12-29 12:00:00 | NQ | Futures | 2138.79 | 2140.79 | 2135.65 | 2138.22 | 11091.0 |
| 2009-12-29 13:00:00 | NQ | Futures | 2138.51 | 2141.36 | 2137.08 | 2140.5 | 5502.0 |
| 2009-12-29 14:00:00 | NQ | Futures | 2140.79 | 2140.79 | 2137.93 | 2138.79 | 7558.0 |
| 2009-12-29 15:00:00 | NQ | Futures | 2138.79 | 2142.5 | 2136.22 | 2137.08 | 20666.0 |
| 2009-12-29 16:00:00 | NQ | Futures | 2137.36 | 2139.36 | 2136.51 | 2138.79 | 5460.0 |
| 2009-12-29 17:00:00 | NQ | Futures | 2138.79 | 2138.79 | 2138.22 | 2138.22 | 34.0 |
| 2009-12-29 18:00:00 | NQ | Futures | 2139.08 | 2139.08 | 2137.93 | 2138.22 | 103.0 |
| 2009-12-29 19:00:00 | NQ | Futures | 2138.22 | 2138.22 | 2133.94 | 2135.65 | 359.0 |
| 2009-12-29 20:00:00 | NQ | Futures | 2135.65 | 2135.65 | 2134.51 | 2135.08 | 168.0 |
| 2009-12-29 21:00:00 | NQ | Futures | 2134.79 | 2135.65 | 2134.51 | 2134.79 | 143.0 |
| 2009-12-29 22:00:00 | NQ | Futures | 2134.79 | 2135.36 | 2134.51 | 2135.36 | 192.0 |
| 2009-12-29 23:00:00 | NQ | Futures | 2135.08 | 2135.65 | 2134.51 | 2135.65 | 222.0 |
| 2009-12-29 00:00:00 | YM | Futures | 9814.8 | 9819.5 | 9814.8 | 9818.5 | 9.0 |
| 2009-12-29 01:00:00 | YM | Futures | 9819.5 | 9823.2 | 9816.7 | 9822.3 | 130.0 |
> showing 50 of 1,339 rows — these rows as CSV