PREVIEW / futures_30min / 2014-02-23
file: by_date/futures_30min/2014/2014-02-23.parquet size: 20 KB rows: 501
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-23 18:00:00 | ES | Futures | 1898.77 | 1899.55 | 1898.0 | 1899.29 | 4828.0 |
| 2014-02-23 18:30:00 | ES | Futures | 1899.03 | 1899.29 | 1898.0 | 1898.52 | 1433.0 |
| 2014-02-23 19:00:00 | ES | Futures | 1898.26 | 1899.55 | 1897.48 | 1899.29 | 2160.0 |
| 2014-02-23 19:30:00 | ES | Futures | 1899.29 | 1901.36 | 1899.29 | 1901.1 | 3550.0 |
| 2014-02-23 20:00:00 | ES | Futures | 1901.36 | 1902.39 | 1899.55 | 1899.81 | 5580.0 |
| 2014-02-23 20:30:00 | ES | Futures | 1900.07 | 1900.58 | 1898.0 | 1898.0 | 3366.0 |
| 2014-02-23 21:00:00 | ES | Futures | 1898.0 | 1898.52 | 1895.93 | 1895.93 | 4532.0 |
| 2014-02-23 21:30:00 | ES | Futures | 1896.19 | 1897.48 | 1894.89 | 1895.67 | 4217.0 |
| 2014-02-23 22:00:00 | ES | Futures | 1895.67 | 1896.96 | 1894.89 | 1896.19 | 2619.0 |
| 2014-02-23 22:30:00 | ES | Futures | 1896.45 | 1896.7 | 1894.89 | 1895.15 | 2603.0 |
| 2014-02-23 23:00:00 | ES | Futures | 1895.41 | 1895.67 | 1893.6 | 1894.12 | 4003.0 |
| 2014-02-23 23:30:00 | ES | Futures | 1893.86 | 1894.64 | 1892.57 | 1893.6 | 3835.0 |
| 2014-02-23 18:00:00 | NQ | Futures | 4262.31 | 4265.22 | 4259.98 | 4264.64 | 557.0 |
| 2014-02-23 18:30:00 | NQ | Futures | 4264.64 | 4264.93 | 4261.73 | 4262.02 | 115.0 |
| 2014-02-23 19:00:00 | NQ | Futures | 4262.6 | 4266.38 | 4261.44 | 4266.09 | 277.0 |
| 2014-02-23 19:30:00 | NQ | Futures | 4265.8 | 4269.87 | 4265.51 | 4269.29 | 441.0 |
| 2014-02-23 20:00:00 | NQ | Futures | 4269.29 | 4271.32 | 4264.64 | 4265.22 | 616.0 |
| 2014-02-23 20:30:00 | NQ | Futures | 4265.22 | 4266.96 | 4261.73 | 4261.73 | 509.0 |
| 2014-02-23 21:00:00 | NQ | Futures | 4261.73 | 4262.31 | 4257.08 | 4257.37 | 539.0 |
| 2014-02-23 21:30:00 | NQ | Futures | 4257.37 | 4259.69 | 4254.17 | 4255.62 | 378.0 |
| 2014-02-23 22:00:00 | NQ | Futures | 4255.33 | 4258.82 | 4254.17 | 4257.08 | 157.0 |
| 2014-02-23 22:30:00 | NQ | Futures | 4257.08 | 4257.95 | 4254.46 | 4255.92 | 230.0 |
| 2014-02-23 23:00:00 | NQ | Futures | 4255.92 | 4257.08 | 4252.14 | 4253.01 | 409.0 |
| 2014-02-23 23:30:00 | NQ | Futures | 4253.01 | 4253.88 | 4249.81 | 4251.85 | 395.0 |
| 2014-02-23 18:00:00 | YM | Futures | 16508.0 | 16511.0 | 16498.7 | 16506.9 | 330.0 |
| 2014-02-23 18:30:00 | YM | Futures | 16504.9 | 16509.0 | 16500.8 | 16501.8 | 89.0 |
| 2014-02-23 19:00:00 | YM | Futures | 16499.8 | 16513.1 | 16495.7 | 16511.0 | 261.0 |
| 2014-02-23 19:30:00 | YM | Futures | 16511.0 | 16525.4 | 16511.0 | 16523.3 | 421.0 |
| 2014-02-23 20:00:00 | YM | Futures | 16523.3 | 16533.6 | 16509.0 | 16514.1 | 508.0 |
| 2014-02-23 20:30:00 | YM | Futures | 16512.1 | 16516.2 | 16498.7 | 16498.7 | 368.0 |
| 2014-02-23 21:00:00 | YM | Futures | 16498.7 | 16501.8 | 16480.3 | 16483.4 | 507.0 |
| 2014-02-23 21:30:00 | YM | Futures | 16483.4 | 16491.6 | 16468.0 | 16474.1 | 805.0 |
| 2014-02-23 22:00:00 | YM | Futures | 16473.1 | 16486.4 | 16471.0 | 16481.3 | 281.0 |
| 2014-02-23 22:30:00 | YM | Futures | 16484.4 | 16486.4 | 16472.1 | 16475.1 | 188.0 |
| 2014-02-23 23:00:00 | YM | Futures | 16473.1 | 16478.2 | 16456.7 | 16459.8 | 486.0 |
| 2014-02-23 23:30:00 | YM | Futures | 16461.8 | 16464.9 | 16446.4 | 16456.7 | 665.0 |
| 2014-02-23 18:00:00 | CL | Futures | 161.69 | 162.09 | 161.63 | 162.03 | 951.0 |
| 2014-02-23 18:30:00 | CL | Futures | 162.04 | 162.09 | 161.98 | 162.06 | 254.0 |
| 2014-02-23 19:00:00 | CL | Futures | 162.06 | 162.34 | 162.04 | 162.2 | 668.0 |
| 2014-02-23 19:30:00 | CL | Futures | 162.22 | 162.25 | 162.1 | 162.23 | 392.0 |
| 2014-02-23 20:00:00 | CL | Futures | 162.22 | 162.25 | 162.07 | 162.14 | 386.0 |
| 2014-02-23 20:30:00 | CL | Futures | 162.14 | 162.15 | 161.99 | 162.01 | 433.0 |
| 2014-02-23 21:00:00 | CL | Futures | 162.01 | 162.07 | 161.93 | 162.04 | 293.0 |
| 2014-02-23 21:30:00 | CL | Futures | 162.04 | 162.04 | 161.88 | 161.92 | 271.0 |
| 2014-02-23 22:00:00 | CL | Futures | 161.93 | 161.98 | 161.93 | 161.98 | 100.0 |
| 2014-02-23 22:30:00 | CL | Futures | 161.98 | 162.01 | 161.87 | 161.93 | 90.0 |
| 2014-02-23 23:00:00 | CL | Futures | 161.95 | 162.01 | 161.9 | 162.01 | 114.0 |
| 2014-02-23 23:30:00 | CL | Futures | 162.01 | 162.04 | 161.95 | 162.03 | 122.0 |
| 2014-02-23 18:00:00 | GC | Futures | 1815.4 | 1816.1 | 1813.2 | 1813.7 | 592.0 |
| 2014-02-23 18:30:00 | GC | Futures | 1813.6 | 1813.9 | 1812.1 | 1813.9 | 276.0 |
> showing 50 of 501 rows — these rows as CSV