PREVIEW / futures_1hour / 2010-01-15
file: by_date/futures_1hour/2010/2010-01-15.parquet size: 39 KB rows: 1,119
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-15 00:00:00 | ES | Futures | 1111.45 | 1113.88 | 1111.21 | 1113.4 | 4259.0 |
| 2010-01-15 01:00:00 | ES | Futures | 1113.4 | 1113.4 | 1112.67 | 1112.67 | 1202.0 |
| 2010-01-15 02:00:00 | ES | Futures | 1112.91 | 1113.64 | 1112.18 | 1112.91 | 4642.0 |
| 2010-01-15 03:00:00 | ES | Futures | 1112.67 | 1115.1 | 1110.96 | 1114.37 | 15602.0 |
| 2010-01-15 04:00:00 | ES | Futures | 1114.61 | 1115.1 | 1113.64 | 1113.88 | 10706.0 |
| 2010-01-15 05:00:00 | ES | Futures | 1113.88 | 1114.13 | 1110.72 | 1111.45 | 20363.0 |
| 2010-01-15 06:00:00 | ES | Futures | 1111.21 | 1113.64 | 1109.99 | 1110.72 | 21456.0 |
| 2010-01-15 07:00:00 | ES | Futures | 1110.72 | 1111.69 | 1106.83 | 1108.53 | 72344.0 |
| 2010-01-15 08:00:00 | ES | Futures | 1108.53 | 1111.69 | 1108.04 | 1109.99 | 62042.0 |
| 2010-01-15 09:00:00 | ES | Futures | 1109.99 | 1113.15 | 1105.85 | 1106.83 | 309607.0 |
| 2010-01-15 10:00:00 | ES | Futures | 1106.83 | 1107.31 | 1100.5 | 1102.69 | 427989.0 |
| 2010-01-15 11:00:00 | ES | Futures | 1102.45 | 1103.18 | 1099.77 | 1100.5 | 209569.0 |
| 2010-01-15 12:00:00 | ES | Futures | 1100.26 | 1101.72 | 1097.1 | 1098.56 | 239268.0 |
| 2010-01-15 13:00:00 | ES | Futures | 1098.8 | 1100.02 | 1097.83 | 1099.53 | 112099.0 |
| 2010-01-15 14:00:00 | ES | Futures | 1099.53 | 1100.26 | 1098.07 | 1099.04 | 130674.0 |
| 2010-01-15 15:00:00 | ES | Futures | 1098.8 | 1102.69 | 1098.8 | 1101.48 | 273228.0 |
| 2010-01-15 16:00:00 | ES | Futures | 1101.48 | 1102.21 | 1101.23 | 1101.48 | 89719.0 |
| 2010-01-15 00:00:00 | NQ | Futures | 2150.22 | 2154.79 | 2149.93 | 2153.64 | 399.0 |
| 2010-01-15 01:00:00 | NQ | Futures | 2154.21 | 2154.21 | 2152.79 | 2153.64 | 92.0 |
| 2010-01-15 02:00:00 | NQ | Futures | 2152.79 | 2154.21 | 2151.64 | 2153.36 | 653.0 |
| 2010-01-15 03:00:00 | NQ | Futures | 2153.36 | 2158.79 | 2151.07 | 2158.21 | 1767.0 |
| 2010-01-15 04:00:00 | NQ | Futures | 2157.93 | 2158.5 | 2155.64 | 2156.21 | 862.0 |
| 2010-01-15 05:00:00 | NQ | Futures | 2156.21 | 2156.5 | 2149.07 | 2150.22 | 2030.0 |
| 2010-01-15 06:00:00 | NQ | Futures | 2150.5 | 2154.5 | 2148.5 | 2149.64 | 1512.0 |
| 2010-01-15 07:00:00 | NQ | Futures | 2149.93 | 2150.79 | 2143.65 | 2147.93 | 5427.0 |
| 2010-01-15 08:00:00 | NQ | Futures | 2148.22 | 2154.79 | 2147.36 | 2152.22 | 4925.0 |
| 2010-01-15 09:00:00 | NQ | Futures | 2152.22 | 2160.78 | 2142.22 | 2145.07 | 55521.0 |
| 2010-01-15 10:00:00 | NQ | Futures | 2145.36 | 2146.5 | 2132.51 | 2138.51 | 74862.0 |
| 2010-01-15 11:00:00 | NQ | Futures | 2138.51 | 2138.79 | 2127.08 | 2128.51 | 34649.0 |
| 2010-01-15 12:00:00 | NQ | Futures | 2128.51 | 2131.65 | 2119.08 | 2123.94 | 45321.0 |
| 2010-01-15 13:00:00 | NQ | Futures | 2123.94 | 2126.22 | 2120.23 | 2125.08 | 25431.0 |
| 2010-01-15 14:00:00 | NQ | Futures | 2125.08 | 2127.94 | 2123.08 | 2125.94 | 25569.0 |
| 2010-01-15 15:00:00 | NQ | Futures | 2125.65 | 2132.79 | 2125.65 | 2129.08 | 49530.0 |
| 2010-01-15 16:00:00 | NQ | Futures | 2129.08 | 2130.51 | 2126.51 | 2128.79 | 10565.0 |
| 2010-01-15 00:00:00 | YM | Futures | 9958.0 | 9976.7 | 9957.0 | 9973.9 | 329.0 |
| 2010-01-15 01:00:00 | YM | Futures | 9973.9 | 9973.9 | 9968.3 | 9968.3 | 99.0 |
| 2010-01-15 02:00:00 | YM | Futures | 9967.3 | 9973.9 | 9964.5 | 9968.3 | 343.0 |
| 2010-01-15 03:00:00 | YM | Futures | 9968.3 | 9986.0 | 9956.1 | 9981.4 | 1324.0 |
| 2010-01-15 04:00:00 | YM | Futures | 9981.4 | 9983.2 | 9975.8 | 9975.8 | 486.0 |
| 2010-01-15 05:00:00 | YM | Futures | 9975.8 | 9976.7 | 9953.3 | 9958.0 | 1730.0 |
| 2010-01-15 06:00:00 | YM | Futures | 9956.1 | 9975.8 | 9949.5 | 9956.1 | 1690.0 |
| 2010-01-15 07:00:00 | YM | Futures | 9956.1 | 9961.7 | 9928.0 | 9940.2 | 3790.0 |
| 2010-01-15 08:00:00 | YM | Futures | 9939.3 | 9964.5 | 9938.3 | 9952.4 | 2911.0 |
| 2010-01-15 09:00:00 | YM | Futures | 9953.3 | 9972.0 | 9910.2 | 9920.5 | 25211.0 |
| 2010-01-15 10:00:00 | YM | Futures | 9920.5 | 9922.4 | 9865.3 | 9877.5 | 30939.0 |
| 2010-01-15 11:00:00 | YM | Futures | 9877.5 | 9887.8 | 9858.8 | 9861.6 | 13609.0 |
| 2010-01-15 12:00:00 | YM | Futures | 9861.6 | 9877.5 | 9833.5 | 9844.7 | 16650.0 |
| 2010-01-15 13:00:00 | YM | Futures | 9845.7 | 9860.6 | 9834.4 | 9856.0 | 9596.0 |
| 2010-01-15 14:00:00 | YM | Futures | 9856.0 | 9862.5 | 9846.6 | 9857.8 | 9153.0 |
| 2010-01-15 15:00:00 | YM | Futures | 9856.9 | 9887.8 | 9856.0 | 9881.2 | 17263.0 |
> showing 50 of 1,119 rows — these rows as CSV