PREVIEW / futures_30min / 2014-12-14
file: by_date/futures_30min/2014/2014-12-14.parquet size: 21 KB rows: 532
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-12-14 18:00:00 | ES | Futures | 2095.22 | 2098.37 | 2092.32 | 2096.0 | 14010.0 |
| 2014-12-14 18:30:00 | ES | Futures | 2096.0 | 2098.37 | 2094.69 | 2095.22 | 4631.0 |
| 2014-12-14 19:00:00 | ES | Futures | 2095.22 | 2097.58 | 2094.69 | 2096.79 | 6833.0 |
| 2014-12-14 19:30:00 | ES | Futures | 2097.06 | 2100.74 | 2096.27 | 2099.69 | 6029.0 |
| 2014-12-14 20:00:00 | ES | Futures | 2099.69 | 2101.79 | 2098.9 | 2101.27 | 4969.0 |
| 2014-12-14 20:30:00 | ES | Futures | 2101.0 | 2101.27 | 2099.43 | 2100.21 | 3183.0 |
| 2014-12-14 21:00:00 | ES | Futures | 2100.21 | 2101.0 | 2099.69 | 2100.21 | 2989.0 |
| 2014-12-14 21:30:00 | ES | Futures | 2100.48 | 2101.79 | 2100.21 | 2101.79 | 1985.0 |
| 2014-12-14 22:00:00 | ES | Futures | 2101.53 | 2104.95 | 2101.53 | 2104.16 | 6353.0 |
| 2014-12-14 22:30:00 | ES | Futures | 2104.16 | 2105.21 | 2103.11 | 2104.16 | 4025.0 |
| 2014-12-14 23:00:00 | ES | Futures | 2104.16 | 2104.69 | 2103.37 | 2104.16 | 1373.0 |
| 2014-12-14 23:30:00 | ES | Futures | 2104.16 | 2105.48 | 2103.37 | 2103.64 | 2096.0 |
| 2014-12-14 18:00:00 | NQ | Futures | 4916.05 | 4923.98 | 4910.76 | 4918.69 | 1467.0 |
| 2014-12-14 18:30:00 | NQ | Futures | 4918.99 | 4923.98 | 4914.29 | 4914.29 | 887.0 |
| 2014-12-14 19:00:00 | NQ | Futures | 4914.29 | 4920.75 | 4913.7 | 4920.46 | 2315.0 |
| 2014-12-14 19:30:00 | NQ | Futures | 4919.87 | 4929.85 | 4919.28 | 4926.62 | 1280.0 |
| 2014-12-14 20:00:00 | NQ | Futures | 4926.62 | 4930.44 | 4924.57 | 4929.56 | 1040.0 |
| 2014-12-14 20:30:00 | NQ | Futures | 4929.85 | 4930.15 | 4925.45 | 4927.5 | 822.0 |
| 2014-12-14 21:00:00 | NQ | Futures | 4927.5 | 4929.85 | 4926.33 | 4927.8 | 604.0 |
| 2014-12-14 21:30:00 | NQ | Futures | 4927.8 | 4933.67 | 4927.8 | 4933.38 | 494.0 |
| 2014-12-14 22:00:00 | NQ | Futures | 4933.38 | 4938.96 | 4933.08 | 4937.49 | 955.0 |
| 2014-12-14 22:30:00 | NQ | Futures | 4937.2 | 4938.96 | 4935.14 | 4935.43 | 753.0 |
| 2014-12-14 23:00:00 | NQ | Futures | 4935.43 | 4937.78 | 4935.14 | 4937.2 | 216.0 |
| 2014-12-14 23:30:00 | NQ | Futures | 4936.9 | 4941.01 | 4935.73 | 4936.31 | 472.0 |
| 2014-12-14 18:00:00 | YM | Futures | 17941.1 | 17970.3 | 17919.2 | 17947.4 | 2320.0 |
| 2014-12-14 18:30:00 | YM | Futures | 17947.4 | 17968.3 | 17940.1 | 17942.2 | 602.0 |
| 2014-12-14 19:00:00 | YM | Futures | 17940.1 | 17959.9 | 17939.0 | 17957.8 | 1348.0 |
| 2014-12-14 19:30:00 | YM | Futures | 17957.8 | 17989.1 | 17953.6 | 17980.8 | 742.0 |
| 2014-12-14 20:00:00 | YM | Futures | 17978.7 | 17996.4 | 17973.5 | 17993.3 | 809.0 |
| 2014-12-14 20:30:00 | YM | Futures | 17993.3 | 17994.4 | 17980.8 | 17985.0 | 695.0 |
| 2014-12-14 21:00:00 | YM | Futures | 17982.9 | 17990.2 | 17979.7 | 17983.9 | 631.0 |
| 2014-12-14 21:30:00 | YM | Futures | 17985.0 | 17999.6 | 17985.0 | 17998.5 | 715.0 |
| 2014-12-14 22:00:00 | YM | Futures | 17998.5 | 18022.5 | 17998.5 | 18017.3 | 726.0 |
| 2014-12-14 22:30:00 | YM | Futures | 18016.3 | 18024.6 | 18006.9 | 18012.1 | 805.0 |
| 2014-12-14 23:00:00 | YM | Futures | 18013.1 | 18016.3 | 18006.9 | 18014.2 | 428.0 |
| 2014-12-14 23:30:00 | YM | Futures | 18013.1 | 18029.8 | 18004.8 | 18009.0 | 1309.0 |
| 2014-12-14 18:00:00 | CL | Futures | 96.84 | 97.11 | 96.11 | 96.89 | 2776.0 |
| 2014-12-14 18:30:00 | CL | Futures | 96.92 | 97.45 | 96.72 | 96.75 | 1027.0 |
| 2014-12-14 19:00:00 | CL | Futures | 96.75 | 96.96 | 96.3 | 96.79 | 642.0 |
| 2014-12-14 19:30:00 | CL | Futures | 96.79 | 97.4 | 96.74 | 97.32 | 449.0 |
| 2014-12-14 20:00:00 | CL | Futures | 97.3 | 97.42 | 96.99 | 97.27 | 347.0 |
| 2014-12-14 20:30:00 | CL | Futures | 97.27 | 97.72 | 97.08 | 97.67 | 478.0 |
| 2014-12-14 21:00:00 | CL | Futures | 97.69 | 99.36 | 97.45 | 98.34 | 1238.0 |
| 2014-12-14 21:30:00 | CL | Futures | 98.34 | 99.44 | 98.29 | 99.41 | 609.0 |
| 2014-12-14 22:00:00 | CL | Futures | 99.46 | 100.28 | 99.32 | 100.19 | 1176.0 |
| 2014-12-14 22:30:00 | CL | Futures | 100.24 | 100.38 | 99.31 | 99.46 | 514.0 |
| 2014-12-14 23:00:00 | CL | Futures | 99.48 | 99.53 | 98.86 | 98.95 | 232.0 |
| 2014-12-14 23:30:00 | CL | Futures | 98.97 | 99.65 | 98.97 | 99.46 | 276.0 |
| 2014-12-14 18:00:00 | GC | Futures | 1671.7 | 1675.8 | 1671.1 | 1672.4 | 774.0 |
| 2014-12-14 18:30:00 | GC | Futures | 1672.4 | 1673.2 | 1671.6 | 1672.4 | 456.0 |
> showing 50 of 532 rows — these rows as CSV