PREVIEW / futures_1hour / 2008-01-16
file: by_date/futures_1hour/2008/2008-01-16.parquet size: 31 KB rows: 796
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-16 00:00:00 | ES | Futures | 1283.29 | 1283.29 | 1281.19 | 1282.13 | 2650.0 |
| 2008-01-16 01:00:00 | ES | Futures | 1282.13 | 1284.46 | 1281.89 | 1282.36 | 3331.0 |
| 2008-01-16 02:00:00 | ES | Futures | 1282.36 | 1285.39 | 1281.66 | 1284.22 | 7485.0 |
| 2008-01-16 03:00:00 | ES | Futures | 1284.22 | 1286.32 | 1280.49 | 1285.86 | 22199.0 |
| 2008-01-16 04:00:00 | ES | Futures | 1285.62 | 1286.56 | 1282.83 | 1285.86 | 19836.0 |
| 2008-01-16 05:00:00 | ES | Futures | 1285.86 | 1286.56 | 1281.19 | 1281.19 | 14127.0 |
| 2008-01-16 06:00:00 | ES | Futures | 1281.43 | 1283.52 | 1279.33 | 1282.59 | 29349.0 |
| 2008-01-16 07:00:00 | ES | Futures | 1282.59 | 1287.49 | 1281.43 | 1283.76 | 48082.0 |
| 2008-01-16 08:00:00 | ES | Futures | 1283.99 | 1289.35 | 1281.66 | 1285.39 | 90097.0 |
| 2008-01-16 09:00:00 | ES | Futures | 1285.39 | 1296.58 | 1284.46 | 1287.26 | 394950.0 |
| 2008-01-16 10:00:00 | ES | Futures | 1287.26 | 1290.05 | 1276.3 | 1279.79 | 532689.0 |
| 2008-01-16 11:00:00 | ES | Futures | 1279.79 | 1293.32 | 1279.33 | 1291.92 | 400653.0 |
| 2008-01-16 12:00:00 | ES | Futures | 1291.92 | 1295.42 | 1288.19 | 1290.75 | 293188.0 |
| 2008-01-16 13:00:00 | ES | Futures | 1290.75 | 1292.15 | 1285.62 | 1287.95 | 217369.0 |
| 2008-01-16 14:00:00 | ES | Futures | 1288.19 | 1303.34 | 1284.22 | 1294.72 | 498684.0 |
| 2008-01-16 15:00:00 | ES | Futures | 1294.72 | 1301.01 | 1283.99 | 1284.46 | 456564.0 |
| 2008-01-16 16:00:00 | ES | Futures | 1284.46 | 1286.79 | 1282.83 | 1285.62 | 103032.0 |
| 2008-01-16 17:00:00 | ES | Futures | 1285.62 | 1286.56 | 1284.69 | 1285.39 | 2138.0 |
| 2008-01-16 18:00:00 | ES | Futures | 1285.62 | 1286.32 | 1284.22 | 1286.09 | 4596.0 |
| 2008-01-16 19:00:00 | ES | Futures | 1286.09 | 1288.42 | 1285.62 | 1287.02 | 5124.0 |
| 2008-01-16 20:00:00 | ES | Futures | 1287.02 | 1287.95 | 1285.16 | 1287.72 | 2803.0 |
| 2008-01-16 21:00:00 | ES | Futures | 1287.72 | 1289.35 | 1287.72 | 1288.89 | 3140.0 |
| 2008-01-16 22:00:00 | ES | Futures | 1288.65 | 1288.89 | 1284.69 | 1284.92 | 4238.0 |
| 2008-01-16 23:00:00 | ES | Futures | 1284.92 | 1288.89 | 1283.52 | 1288.42 | 3758.0 |
| 2008-01-16 00:00:00 | NQ | Futures | 2133.94 | 2134.22 | 2129.11 | 2129.68 | 398.0 |
| 2008-01-16 01:00:00 | NQ | Futures | 2130.25 | 2133.09 | 2129.4 | 2131.67 | 305.0 |
| 2008-01-16 02:00:00 | NQ | Futures | 2131.1 | 2139.05 | 2130.81 | 2136.78 | 1225.0 |
| 2008-01-16 03:00:00 | NQ | Futures | 2136.21 | 2141.03 | 2129.96 | 2140.75 | 1577.0 |
| 2008-01-16 04:00:00 | NQ | Futures | 2140.75 | 2141.03 | 2135.92 | 2137.91 | 2243.0 |
| 2008-01-16 05:00:00 | NQ | Futures | 2138.48 | 2140.47 | 2131.95 | 2132.23 | 1127.0 |
| 2008-01-16 06:00:00 | NQ | Futures | 2132.23 | 2137.34 | 2127.69 | 2134.79 | 2112.0 |
| 2008-01-16 07:00:00 | NQ | Futures | 2134.5 | 2143.3 | 2132.8 | 2138.48 | 5933.0 |
| 2008-01-16 08:00:00 | NQ | Futures | 2138.48 | 2148.13 | 2136.78 | 2141.6 | 13031.0 |
| 2008-01-16 09:00:00 | NQ | Futures | 2141.88 | 2166.58 | 2141.32 | 2143.59 | 82551.0 |
| 2008-01-16 10:00:00 | NQ | Futures | 2143.3 | 2145.86 | 2110.95 | 2119.46 | 131150.0 |
| 2008-01-16 11:00:00 | NQ | Futures | 2119.46 | 2150.68 | 2118.89 | 2148.41 | 93530.0 |
| 2008-01-16 12:00:00 | NQ | Futures | 2148.41 | 2158.35 | 2140.47 | 2150.4 | 77659.0 |
| 2008-01-16 13:00:00 | NQ | Futures | 2150.4 | 2152.95 | 2136.49 | 2143.87 | 51223.0 |
| 2008-01-16 14:00:00 | NQ | Futures | 2143.87 | 2179.07 | 2137.63 | 2157.78 | 107316.0 |
| 2008-01-16 15:00:00 | NQ | Futures | 2157.78 | 2173.11 | 2137.06 | 2137.63 | 96424.0 |
| 2008-01-16 16:00:00 | NQ | Futures | 2138.19 | 2142.45 | 2134.79 | 2139.9 | 19107.0 |
| 2008-01-16 17:00:00 | NQ | Futures | 2140.75 | 2141.32 | 2138.48 | 2139.9 | 181.0 |
| 2008-01-16 18:00:00 | NQ | Futures | 2139.05 | 2140.47 | 2137.63 | 2140.47 | 182.0 |
| 2008-01-16 19:00:00 | NQ | Futures | 2140.75 | 2143.59 | 2139.33 | 2143.02 | 249.0 |
| 2008-01-16 20:00:00 | NQ | Futures | 2142.74 | 2143.87 | 2140.75 | 2143.59 | 107.0 |
| 2008-01-16 21:00:00 | NQ | Futures | 2143.3 | 2144.72 | 2141.88 | 2144.44 | 171.0 |
| 2008-01-16 22:00:00 | NQ | Futures | 2143.87 | 2143.87 | 2136.78 | 2137.06 | 246.0 |
| 2008-01-16 23:00:00 | NQ | Futures | 2137.06 | 2144.16 | 2136.78 | 2143.02 | 205.0 |
| 2008-01-16 00:00:00 | YM | Futures | 11319.9 | 11319.9 | 11303.5 | 11304.4 | 166.0 |
| 2008-01-16 01:00:00 | YM | Futures | 11305.4 | 11324.4 | 11301.7 | 11303.5 | 189.0 |
> showing 50 of 796 rows — these rows as CSV