PREVIEW / futures_30min / 2015-02-03
file: by_date/futures_30min/2015/2015-02-03.parquet size: 90 KB rows: 3,020
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-02-03 00:00:00 | ES | Futures | 2114.43 | 2114.95 | 2112.58 | 2113.11 | 2967.0 |
| 2015-02-03 00:30:00 | ES | Futures | 2113.37 | 2115.48 | 2112.58 | 2114.69 | 1591.0 |
| 2015-02-03 01:00:00 | ES | Futures | 2114.69 | 2116.53 | 2114.16 | 2116.27 | 1656.0 |
| 2015-02-03 01:30:00 | ES | Futures | 2116.27 | 2118.9 | 2115.48 | 2118.37 | 1832.0 |
| 2015-02-03 02:00:00 | ES | Futures | 2118.11 | 2121.79 | 2117.06 | 2121.27 | 5364.0 |
| 2015-02-03 02:30:00 | ES | Futures | 2121.0 | 2121.27 | 2118.64 | 2119.95 | 3862.0 |
| 2015-02-03 03:00:00 | ES | Futures | 2119.95 | 2125.74 | 2118.9 | 2124.42 | 14121.0 |
| 2015-02-03 03:30:00 | ES | Futures | 2124.42 | 2131.53 | 2123.37 | 2131.0 | 18120.0 |
| 2015-02-03 04:00:00 | ES | Futures | 2131.0 | 2131.27 | 2127.58 | 2127.85 | 9667.0 |
| 2015-02-03 04:30:00 | ES | Futures | 2127.85 | 2128.11 | 2122.06 | 2123.37 | 10447.0 |
| 2015-02-03 05:00:00 | ES | Futures | 2123.37 | 2126.27 | 2122.58 | 2124.95 | 5711.0 |
| 2015-02-03 05:30:00 | ES | Futures | 2124.69 | 2129.16 | 2123.64 | 2126.79 | 7208.0 |
| 2015-02-03 06:00:00 | ES | Futures | 2126.79 | 2130.48 | 2126.27 | 2129.42 | 7343.0 |
| 2015-02-03 06:30:00 | ES | Futures | 2129.16 | 2134.69 | 2129.16 | 2131.53 | 12167.0 |
| 2015-02-03 07:00:00 | ES | Futures | 2131.53 | 2133.11 | 2129.95 | 2130.21 | 7099.0 |
| 2015-02-03 07:30:00 | ES | Futures | 2130.21 | 2131.0 | 2127.06 | 2128.9 | 9953.0 |
| 2015-02-03 08:00:00 | ES | Futures | 2128.9 | 2130.21 | 2124.16 | 2128.37 | 26050.0 |
| 2015-02-03 08:30:00 | ES | Futures | 2128.64 | 2131.53 | 2125.48 | 2130.21 | 21499.0 |
| 2015-02-03 09:00:00 | ES | Futures | 2130.48 | 2133.37 | 2129.69 | 2131.79 | 32142.0 |
| 2015-02-03 09:30:00 | ES | Futures | 2131.79 | 2141.53 | 2130.21 | 2140.74 | 220207.0 |
| 2015-02-03 10:00:00 | ES | Futures | 2140.48 | 2141.27 | 2134.16 | 2139.95 | 165251.0 |
| 2015-02-03 10:30:00 | ES | Futures | 2139.69 | 2140.74 | 2129.42 | 2129.42 | 128060.0 |
| 2015-02-03 11:00:00 | ES | Futures | 2129.42 | 2136.79 | 2128.64 | 2133.37 | 110851.0 |
| 2015-02-03 11:30:00 | ES | Futures | 2133.11 | 2137.85 | 2129.42 | 2129.95 | 94175.0 |
| 2015-02-03 12:00:00 | ES | Futures | 2129.95 | 2134.16 | 2127.32 | 2132.58 | 75383.0 |
| 2015-02-03 12:30:00 | ES | Futures | 2132.58 | 2136.53 | 2129.95 | 2134.16 | 61216.0 |
| 2015-02-03 13:00:00 | ES | Futures | 2134.16 | 2142.06 | 2133.11 | 2141.0 | 84881.0 |
| 2015-02-03 13:30:00 | ES | Futures | 2140.74 | 2146.27 | 2138.9 | 2145.74 | 100498.0 |
| 2015-02-03 14:00:00 | ES | Futures | 2145.74 | 2147.85 | 2139.95 | 2141.0 | 98304.0 |
| 2015-02-03 14:30:00 | ES | Futures | 2140.74 | 2144.95 | 2138.9 | 2144.95 | 58606.0 |
| 2015-02-03 15:00:00 | ES | Futures | 2145.21 | 2148.11 | 2143.11 | 2147.06 | 67633.0 |
| 2015-02-03 15:30:00 | ES | Futures | 2147.06 | 2151.53 | 2144.95 | 2151.0 | 136734.0 |
| 2015-02-03 16:00:00 | ES | Futures | 2151.27 | 2151.53 | 2147.85 | 2148.9 | 61426.0 |
| 2015-02-03 16:30:00 | ES | Futures | 2149.42 | 2150.48 | 2148.63 | 2148.9 | 6705.0 |
| 2015-02-03 17:00:00 | ES | Futures | 2148.9 | 2149.16 | 2147.85 | 2148.37 | 2197.0 |
| 2015-02-03 18:00:00 | ES | Futures | 2147.85 | 2149.16 | 2146.53 | 2147.32 | 3619.0 |
| 2015-02-03 18:30:00 | ES | Futures | 2147.32 | 2147.58 | 2146.27 | 2146.53 | 1582.0 |
| 2015-02-03 19:00:00 | ES | Futures | 2146.27 | 2147.32 | 2146.27 | 2147.06 | 2338.0 |
| 2015-02-03 19:30:00 | ES | Futures | 2147.06 | 2149.16 | 2146.79 | 2149.16 | 3103.0 |
| 2015-02-03 20:00:00 | ES | Futures | 2149.16 | 2150.21 | 2148.37 | 2148.9 | 1894.0 |
| 2015-02-03 20:30:00 | ES | Futures | 2148.9 | 2148.9 | 2147.32 | 2147.85 | 1627.0 |
| 2015-02-03 21:00:00 | ES | Futures | 2147.58 | 2148.37 | 2147.58 | 2147.85 | 1195.0 |
| 2015-02-03 21:30:00 | ES | Futures | 2147.58 | 2149.69 | 2147.58 | 2148.63 | 1635.0 |
| 2015-02-03 22:00:00 | ES | Futures | 2148.9 | 2149.42 | 2146.79 | 2147.58 | 1564.0 |
| 2015-02-03 22:30:00 | ES | Futures | 2147.58 | 2148.11 | 2146.79 | 2147.85 | 1250.0 |
| 2015-02-03 23:00:00 | ES | Futures | 2147.85 | 2148.11 | 2147.06 | 2147.85 | 738.0 |
| 2015-02-03 23:30:00 | ES | Futures | 2147.85 | 2148.11 | 2147.32 | 2147.85 | 380.0 |
| 2015-02-03 00:00:00 | NQ | Futures | 4897.55 | 4898.43 | 4893.73 | 4895.2 | 279.0 |
| 2015-02-03 00:30:00 | NQ | Futures | 4895.2 | 4900.19 | 4894.02 | 4897.84 | 152.0 |
| 2015-02-03 01:00:00 | NQ | Futures | 4897.55 | 4900.78 | 4896.96 | 4900.19 | 264.0 |
> showing 50 of 3,020 rows — these rows as CSV