PREVIEW / futures_30min / 2015-10-08
file: by_date/futures_30min/2015/2015-10-08.parquet size: 80 KB rows: 2,912
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-08 00:00:00 | ES | Futures | 2116.0 | 2116.8 | 2114.66 | 2115.19 | 2828.0 |
| 2015-10-08 00:30:00 | ES | Futures | 2115.19 | 2115.46 | 2112.25 | 2113.86 | 4374.0 |
| 2015-10-08 01:00:00 | ES | Futures | 2114.12 | 2116.26 | 2113.32 | 2113.86 | 5079.0 |
| 2015-10-08 01:30:00 | ES | Futures | 2114.12 | 2114.66 | 2111.98 | 2111.98 | 3530.0 |
| 2015-10-08 02:00:00 | ES | Futures | 2112.25 | 2114.66 | 2111.18 | 2114.12 | 7197.0 |
| 2015-10-08 02:30:00 | ES | Futures | 2114.12 | 2114.66 | 2111.18 | 2112.79 | 5260.0 |
| 2015-10-08 03:00:00 | ES | Futures | 2112.52 | 2115.46 | 2109.84 | 2110.11 | 16041.0 |
| 2015-10-08 03:30:00 | ES | Futures | 2109.84 | 2116.8 | 2109.57 | 2115.19 | 13480.0 |
| 2015-10-08 04:00:00 | ES | Futures | 2115.46 | 2118.14 | 2112.79 | 2114.12 | 12529.0 |
| 2015-10-08 04:30:00 | ES | Futures | 2113.86 | 2116.0 | 2112.25 | 2112.79 | 8088.0 |
| 2015-10-08 05:00:00 | ES | Futures | 2112.52 | 2118.14 | 2111.45 | 2117.33 | 9137.0 |
| 2015-10-08 05:30:00 | ES | Futures | 2117.07 | 2118.4 | 2113.86 | 2115.73 | 7688.0 |
| 2015-10-08 06:00:00 | ES | Futures | 2116.0 | 2122.15 | 2116.0 | 2119.21 | 13446.0 |
| 2015-10-08 06:30:00 | ES | Futures | 2119.21 | 2121.88 | 2116.8 | 2118.67 | 7872.0 |
| 2015-10-08 07:00:00 | ES | Futures | 2118.67 | 2120.81 | 2117.87 | 2119.74 | 11998.0 |
| 2015-10-08 07:30:00 | ES | Futures | 2120.01 | 2122.15 | 2118.67 | 2121.35 | 12955.0 |
| 2015-10-08 08:00:00 | ES | Futures | 2121.08 | 2121.88 | 2118.14 | 2118.67 | 17410.0 |
| 2015-10-08 08:30:00 | ES | Futures | 2118.67 | 2120.54 | 2115.19 | 2118.14 | 34287.0 |
| 2015-10-08 09:00:00 | ES | Futures | 2117.87 | 2121.88 | 2116.53 | 2121.88 | 18868.0 |
| 2015-10-08 09:30:00 | ES | Futures | 2121.88 | 2124.29 | 2117.87 | 2122.42 | 171942.0 |
| 2015-10-08 10:00:00 | ES | Futures | 2122.42 | 2125.36 | 2118.94 | 2119.74 | 106598.0 |
| 2015-10-08 10:30:00 | ES | Futures | 2119.74 | 2124.83 | 2119.47 | 2124.02 | 79885.0 |
| 2015-10-08 11:00:00 | ES | Futures | 2123.76 | 2125.36 | 2118.67 | 2123.76 | 98851.0 |
| 2015-10-08 11:30:00 | ES | Futures | 2124.02 | 2126.97 | 2123.76 | 2126.16 | 69146.0 |
| 2015-10-08 12:00:00 | ES | Futures | 2126.43 | 2129.37 | 2124.02 | 2124.83 | 79415.0 |
| 2015-10-08 12:30:00 | ES | Futures | 2124.83 | 2128.3 | 2119.47 | 2121.62 | 83711.0 |
| 2015-10-08 13:00:00 | ES | Futures | 2121.88 | 2127.23 | 2120.81 | 2125.9 | 65755.0 |
| 2015-10-08 13:30:00 | ES | Futures | 2125.9 | 2128.84 | 2125.9 | 2128.04 | 46274.0 |
| 2015-10-08 14:00:00 | ES | Futures | 2128.3 | 2136.87 | 2125.63 | 2133.12 | 216411.0 |
| 2015-10-08 14:30:00 | ES | Futures | 2132.85 | 2143.56 | 2132.32 | 2142.22 | 136398.0 |
| 2015-10-08 15:00:00 | ES | Futures | 2141.95 | 2149.98 | 2141.68 | 2145.7 | 150266.0 |
| 2015-10-08 15:30:00 | ES | Futures | 2145.43 | 2147.3 | 2141.42 | 2146.23 | 157127.0 |
| 2015-10-08 16:00:00 | ES | Futures | 2145.96 | 2148.37 | 2144.63 | 2148.11 | 68418.0 |
| 2015-10-08 16:30:00 | ES | Futures | 2147.84 | 2148.37 | 2145.16 | 2146.77 | 9166.0 |
| 2015-10-08 18:00:00 | ES | Futures | 2144.89 | 2145.96 | 2144.09 | 2145.16 | 2701.0 |
| 2015-10-08 18:30:00 | ES | Futures | 2145.43 | 2146.23 | 2145.16 | 2145.96 | 1126.0 |
| 2015-10-08 19:00:00 | ES | Futures | 2145.96 | 2147.03 | 2145.96 | 2146.77 | 1309.0 |
| 2015-10-08 19:30:00 | ES | Futures | 2146.5 | 2146.77 | 2145.16 | 2145.7 | 1439.0 |
| 2015-10-08 20:00:00 | ES | Futures | 2145.43 | 2147.3 | 2144.36 | 2145.43 | 3598.0 |
| 2015-10-08 20:30:00 | ES | Futures | 2145.16 | 2146.77 | 2144.36 | 2145.16 | 3190.0 |
| 2015-10-08 21:00:00 | ES | Futures | 2144.89 | 2146.23 | 2143.02 | 2145.96 | 3648.0 |
| 2015-10-08 21:30:00 | ES | Futures | 2145.7 | 2146.23 | 2144.09 | 2144.36 | 3764.0 |
| 2015-10-08 22:00:00 | ES | Futures | 2144.63 | 2147.03 | 2144.63 | 2145.96 | 2906.0 |
| 2015-10-08 22:30:00 | ES | Futures | 2145.96 | 2146.23 | 2145.16 | 2145.43 | 1238.0 |
| 2015-10-08 23:00:00 | ES | Futures | 2145.43 | 2146.23 | 2145.16 | 2146.23 | 1713.0 |
| 2015-10-08 23:30:00 | ES | Futures | 2146.23 | 2149.98 | 2145.96 | 2149.71 | 3438.0 |
| 2015-10-08 00:00:00 | NQ | Futures | 5102.02 | 5104.09 | 5098.16 | 5099.05 | 960.0 |
| 2015-10-08 00:30:00 | NQ | Futures | 5098.46 | 5100.54 | 5092.83 | 5096.68 | 696.0 |
| 2015-10-08 01:00:00 | NQ | Futures | 5096.68 | 5102.31 | 5094.01 | 5095.2 | 1030.0 |
| 2015-10-08 01:30:00 | NQ | Futures | 5094.9 | 5096.09 | 5090.45 | 5091.05 | 670.0 |
> showing 50 of 2,912 rows — these rows as CSV