PREVIEW / futures_1hour / 2014-02-14
file: by_date/futures_1hour/2014/2014-02-14.parquet size: 42 KB rows: 1,258
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-14 00:00:00 | ES | Futures | 1881.44 | 1881.96 | 1878.86 | 1880.67 | 13912.0 |
| 2014-02-14 01:00:00 | ES | Futures | 1880.93 | 1883.77 | 1880.15 | 1883.25 | 4774.0 |
| 2014-02-14 02:00:00 | ES | Futures | 1883.25 | 1885.07 | 1883.0 | 1884.03 | 9054.0 |
| 2014-02-14 03:00:00 | ES | Futures | 1883.77 | 1885.07 | 1881.7 | 1883.51 | 22843.0 |
| 2014-02-14 04:00:00 | ES | Futures | 1883.77 | 1888.94 | 1883.25 | 1887.65 | 25093.0 |
| 2014-02-14 05:00:00 | ES | Futures | 1887.65 | 1887.91 | 1886.36 | 1887.13 | 12918.0 |
| 2014-02-14 06:00:00 | ES | Futures | 1886.88 | 1889.72 | 1886.62 | 1889.2 | 19239.0 |
| 2014-02-14 07:00:00 | ES | Futures | 1889.2 | 1889.98 | 1887.91 | 1888.94 | 16878.0 |
| 2014-02-14 08:00:00 | ES | Futures | 1888.94 | 1889.2 | 1886.1 | 1887.65 | 36944.0 |
| 2014-02-14 09:00:00 | ES | Futures | 1887.65 | 1890.5 | 1883.51 | 1889.2 | 240335.0 |
| 2014-02-14 10:00:00 | ES | Futures | 1889.2 | 1896.19 | 1886.88 | 1893.08 | 264458.0 |
| 2014-02-14 11:00:00 | ES | Futures | 1893.08 | 1895.67 | 1892.31 | 1894.38 | 102298.0 |
| 2014-02-14 12:00:00 | ES | Futures | 1894.38 | 1895.67 | 1893.34 | 1894.89 | 48862.0 |
| 2014-02-14 13:00:00 | ES | Futures | 1894.89 | 1899.29 | 1894.38 | 1898.77 | 105226.0 |
| 2014-02-14 14:00:00 | ES | Futures | 1898.77 | 1902.39 | 1898.52 | 1901.62 | 125104.0 |
| 2014-02-14 15:00:00 | ES | Futures | 1901.62 | 1901.88 | 1897.74 | 1898.77 | 164132.0 |
| 2014-02-14 16:00:00 | ES | Futures | 1898.77 | 1899.55 | 1896.96 | 1898.26 | 94240.0 |
| 2014-02-14 17:00:00 | ES | Futures | 1898.26 | 1898.52 | 1897.22 | 1897.48 | 2192.0 |
| 2014-02-14 00:00:00 | NQ | Futures | 4234.7 | 4236.73 | 4230.04 | 4233.53 | 1659.0 |
| 2014-02-14 01:00:00 | NQ | Futures | 4233.53 | 4240.51 | 4233.24 | 4239.35 | 479.0 |
| 2014-02-14 02:00:00 | NQ | Futures | 4239.35 | 4243.42 | 4239.35 | 4241.96 | 710.0 |
| 2014-02-14 03:00:00 | NQ | Futures | 4242.25 | 4246.32 | 4237.89 | 4242.25 | 2856.0 |
| 2014-02-14 04:00:00 | NQ | Futures | 4242.54 | 4252.72 | 4242.25 | 4250.1 | 3060.0 |
| 2014-02-14 05:00:00 | NQ | Futures | 4250.39 | 4250.68 | 4246.9 | 4248.36 | 1139.0 |
| 2014-02-14 06:00:00 | NQ | Futures | 4248.07 | 4254.75 | 4246.9 | 4253.01 | 2005.0 |
| 2014-02-14 07:00:00 | NQ | Futures | 4253.01 | 4255.04 | 4250.1 | 4252.14 | 2232.0 |
| 2014-02-14 08:00:00 | NQ | Futures | 4252.43 | 4252.72 | 4246.61 | 4248.36 | 5011.0 |
| 2014-02-14 09:00:00 | NQ | Futures | 4248.07 | 4248.07 | 4234.7 | 4239.06 | 48138.0 |
| 2014-02-14 10:00:00 | NQ | Futures | 4239.35 | 4253.88 | 4232.95 | 4241.67 | 43312.0 |
| 2014-02-14 11:00:00 | NQ | Futures | 4241.67 | 4253.01 | 4239.64 | 4250.39 | 19959.0 |
| 2014-02-14 12:00:00 | NQ | Futures | 4250.39 | 4251.26 | 4243.42 | 4248.94 | 9200.0 |
| 2014-02-14 13:00:00 | NQ | Futures | 4248.94 | 4259.69 | 4248.07 | 4258.24 | 16052.0 |
| 2014-02-14 14:00:00 | NQ | Futures | 4258.53 | 4264.93 | 4257.37 | 4264.05 | 14090.0 |
| 2014-02-14 15:00:00 | NQ | Futures | 4263.76 | 4264.35 | 4254.46 | 4255.62 | 29418.0 |
| 2014-02-14 16:00:00 | NQ | Futures | 4255.62 | 4258.82 | 4252.14 | 4257.08 | 6034.0 |
| 2014-02-14 17:00:00 | NQ | Futures | 4257.08 | 4257.95 | 4255.92 | 4256.79 | 190.0 |
| 2014-02-14 00:00:00 | YM | Futures | 16343.9 | 16347.0 | 16315.2 | 16336.7 | 1843.0 |
| 2014-02-14 01:00:00 | YM | Futures | 16335.7 | 16357.2 | 16332.6 | 16355.2 | 548.0 |
| 2014-02-14 02:00:00 | YM | Futures | 16355.2 | 16374.7 | 16355.2 | 16361.3 | 1304.0 |
| 2014-02-14 03:00:00 | YM | Futures | 16362.4 | 16374.7 | 16342.9 | 16353.1 | 3170.0 |
| 2014-02-14 04:00:00 | YM | Futures | 16353.1 | 16402.3 | 16352.1 | 16392.1 | 3219.0 |
| 2014-02-14 05:00:00 | YM | Futures | 16393.1 | 16394.1 | 16378.8 | 16383.9 | 1582.0 |
| 2014-02-14 06:00:00 | YM | Futures | 16382.9 | 16407.5 | 16382.9 | 16402.3 | 1773.0 |
| 2014-02-14 07:00:00 | YM | Futures | 16402.3 | 16409.5 | 16393.1 | 16399.3 | 1665.0 |
| 2014-02-14 08:00:00 | YM | Futures | 16399.3 | 16402.3 | 16380.8 | 16389.0 | 3476.0 |
| 2014-02-14 09:00:00 | YM | Futures | 16388.0 | 16417.7 | 16357.2 | 16413.6 | 22136.0 |
| 2014-02-14 10:00:00 | YM | Futures | 16413.6 | 16475.1 | 16393.1 | 16460.8 | 25339.0 |
| 2014-02-14 11:00:00 | YM | Futures | 16461.8 | 16491.6 | 16457.7 | 16481.3 | 11279.0 |
| 2014-02-14 12:00:00 | YM | Futures | 16481.3 | 16492.6 | 16474.1 | 16486.4 | 5862.0 |
| 2014-02-14 13:00:00 | YM | Futures | 16485.4 | 16528.5 | 16483.4 | 16523.3 | 9084.0 |
> showing 50 of 1,258 rows — these rows as CSV