PREVIEW / futures_30min / 2014-05-18
file: by_date/futures_30min/2014/2014-05-18.parquet size: 18 KB rows: 498
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-05-18 18:00:00 | ES | Futures | 1948.83 | 1949.87 | 1948.57 | 1949.61 | 5295.0 |
| 2014-05-18 18:30:00 | ES | Futures | 1949.87 | 1950.13 | 1949.61 | 1949.87 | 883.0 |
| 2014-05-18 19:00:00 | ES | Futures | 1949.61 | 1949.87 | 1949.61 | 1949.61 | 467.0 |
| 2014-05-18 19:30:00 | ES | Futures | 1949.61 | 1949.87 | 1948.57 | 1948.57 | 988.0 |
| 2014-05-18 20:00:00 | ES | Futures | 1948.57 | 1949.09 | 1948.31 | 1948.83 | 2261.0 |
| 2014-05-18 20:30:00 | ES | Futures | 1949.09 | 1949.09 | 1947.79 | 1948.83 | 2273.0 |
| 2014-05-18 21:00:00 | ES | Futures | 1948.83 | 1948.83 | 1947.79 | 1948.05 | 1009.0 |
| 2014-05-18 21:30:00 | ES | Futures | 1948.05 | 1948.31 | 1947.27 | 1948.05 | 1928.0 |
| 2014-05-18 22:00:00 | ES | Futures | 1948.05 | 1948.31 | 1947.27 | 1947.79 | 801.0 |
| 2014-05-18 22:30:00 | ES | Futures | 1947.53 | 1948.05 | 1947.27 | 1947.79 | 826.0 |
| 2014-05-18 23:00:00 | ES | Futures | 1947.79 | 1948.05 | 1947.27 | 1947.79 | 1155.0 |
| 2014-05-18 23:30:00 | ES | Futures | 1947.53 | 1948.05 | 1947.27 | 1947.53 | 1122.0 |
| 2014-05-18 18:00:00 | NQ | Futures | 4178.17 | 4182.24 | 4177.87 | 4181.37 | 732.0 |
| 2014-05-18 18:30:00 | NQ | Futures | 4181.66 | 4182.83 | 4181.66 | 4181.95 | 274.0 |
| 2014-05-18 19:00:00 | NQ | Futures | 4181.95 | 4182.24 | 4181.37 | 4181.95 | 105.0 |
| 2014-05-18 19:30:00 | NQ | Futures | 4181.66 | 4181.95 | 4179.62 | 4179.91 | 282.0 |
| 2014-05-18 20:00:00 | NQ | Futures | 4179.91 | 4179.91 | 4177.29 | 4179.62 | 330.0 |
| 2014-05-18 20:30:00 | NQ | Futures | 4179.04 | 4179.04 | 4176.71 | 4178.75 | 239.0 |
| 2014-05-18 21:00:00 | NQ | Futures | 4178.46 | 4179.04 | 4176.71 | 4177.29 | 250.0 |
| 2014-05-18 21:30:00 | NQ | Futures | 4177.58 | 4177.58 | 4174.09 | 4176.71 | 387.0 |
| 2014-05-18 22:00:00 | NQ | Futures | 4176.71 | 4177.29 | 4175.25 | 4176.42 | 136.0 |
| 2014-05-18 22:30:00 | NQ | Futures | 4176.42 | 4177.29 | 4175.54 | 4176.42 | 178.0 |
| 2014-05-18 23:00:00 | NQ | Futures | 4176.42 | 4176.71 | 4174.96 | 4176.13 | 135.0 |
| 2014-05-18 23:30:00 | NQ | Futures | 4175.84 | 4176.71 | 4175.25 | 4175.25 | 147.0 |
| 2014-05-18 18:00:00 | YM | Futures | 16957.7 | 16976.2 | 16956.6 | 16975.2 | 462.0 |
| 2014-05-18 18:30:00 | YM | Futures | 16975.2 | 16980.3 | 16973.1 | 16975.2 | 129.0 |
| 2014-05-18 19:00:00 | YM | Futures | 16974.1 | 16976.2 | 16972.1 | 16974.1 | 64.0 |
| 2014-05-18 19:30:00 | YM | Futures | 16972.1 | 16973.1 | 16962.8 | 16962.8 | 155.0 |
| 2014-05-18 20:00:00 | YM | Futures | 16961.8 | 16966.9 | 16956.6 | 16962.8 | 360.0 |
| 2014-05-18 20:30:00 | YM | Futures | 16963.8 | 16963.8 | 16955.6 | 16962.8 | 248.0 |
| 2014-05-18 21:00:00 | YM | Futures | 16961.8 | 16962.8 | 16956.6 | 16960.8 | 251.0 |
| 2014-05-18 21:30:00 | YM | Futures | 16959.7 | 16960.8 | 16952.5 | 16957.7 | 329.0 |
| 2014-05-18 22:00:00 | YM | Futures | 16956.6 | 16957.7 | 16952.5 | 16955.6 | 195.0 |
| 2014-05-18 22:30:00 | YM | Futures | 16954.6 | 16957.7 | 16953.5 | 16954.6 | 105.0 |
| 2014-05-18 23:00:00 | YM | Futures | 16955.6 | 16957.7 | 16952.5 | 16955.6 | 124.0 |
| 2014-05-18 23:30:00 | YM | Futures | 16953.5 | 16956.6 | 16951.5 | 16951.5 | 158.0 |
| 2014-05-18 18:00:00 | CL | Futures | 164.13 | 164.15 | 163.88 | 163.97 | 1198.0 |
| 2014-05-18 18:30:00 | CL | Futures | 163.97 | 164.05 | 163.93 | 163.94 | 146.0 |
| 2014-05-18 19:00:00 | CL | Futures | 163.94 | 164.04 | 163.93 | 164.04 | 161.0 |
| 2014-05-18 19:30:00 | CL | Futures | 164.02 | 164.05 | 163.96 | 163.97 | 117.0 |
| 2014-05-18 20:00:00 | CL | Futures | 163.99 | 164.01 | 163.96 | 163.99 | 106.0 |
| 2014-05-18 20:30:00 | CL | Futures | 163.99 | 164.02 | 163.96 | 163.99 | 174.0 |
| 2014-05-18 21:00:00 | CL | Futures | 164.01 | 164.02 | 163.97 | 164.01 | 176.0 |
| 2014-05-18 21:30:00 | CL | Futures | 164.01 | 164.1 | 163.94 | 164.07 | 350.0 |
| 2014-05-18 22:00:00 | CL | Futures | 164.07 | 164.22 | 164.05 | 164.13 | 558.0 |
| 2014-05-18 22:30:00 | CL | Futures | 164.13 | 164.23 | 164.13 | 164.22 | 216.0 |
| 2014-05-18 23:00:00 | CL | Futures | 164.22 | 164.3 | 164.18 | 164.23 | 292.0 |
| 2014-05-18 23:30:00 | CL | Futures | 164.23 | 164.25 | 164.18 | 164.18 | 105.0 |
| 2014-05-18 18:00:00 | GC | Futures | 1771.3 | 1771.4 | 1766.5 | 1769.1 | 894.0 |
| 2014-05-18 18:30:00 | GC | Futures | 1768.9 | 1769.2 | 1768.3 | 1768.8 | 127.0 |
> showing 50 of 498 rows — these rows as CSV