PREVIEW / futures_30min / 2014-06-01
file: by_date/futures_30min/2014/2014-06-01.parquet size: 19 KB rows: 496
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-06-01 18:00:00 | ES | Futures | 1995.57 | 1996.61 | 1994.79 | 1995.83 | 5415.0 |
| 2014-06-01 18:30:00 | ES | Futures | 1995.83 | 1995.83 | 1995.05 | 1995.31 | 545.0 |
| 2014-06-01 19:00:00 | ES | Futures | 1995.31 | 1995.57 | 1994.53 | 1995.05 | 924.0 |
| 2014-06-01 19:30:00 | ES | Futures | 1995.05 | 1995.05 | 1994.27 | 1995.05 | 1247.0 |
| 2014-06-01 20:00:00 | ES | Futures | 1994.79 | 1995.83 | 1994.79 | 1995.57 | 2255.0 |
| 2014-06-01 20:30:00 | ES | Futures | 1995.57 | 1996.35 | 1995.05 | 1996.35 | 1817.0 |
| 2014-06-01 21:00:00 | ES | Futures | 1996.35 | 1997.13 | 1996.09 | 1997.13 | 2878.0 |
| 2014-06-01 21:30:00 | ES | Futures | 1996.87 | 1997.13 | 1996.35 | 1996.61 | 2561.0 |
| 2014-06-01 22:00:00 | ES | Futures | 1996.87 | 1997.39 | 1996.87 | 1997.39 | 1243.0 |
| 2014-06-01 22:30:00 | ES | Futures | 1997.39 | 1998.17 | 1997.13 | 1997.91 | 2505.0 |
| 2014-06-01 23:00:00 | ES | Futures | 1998.17 | 1998.69 | 1997.65 | 1997.65 | 2135.0 |
| 2014-06-01 23:30:00 | ES | Futures | 1997.65 | 1997.91 | 1997.39 | 1997.91 | 555.0 |
| 2014-06-01 18:00:00 | NQ | Futures | 4350.86 | 4351.44 | 4347.37 | 4350.28 | 757.0 |
| 2014-06-01 18:30:00 | NQ | Futures | 4349.7 | 4349.99 | 4348.53 | 4349.11 | 91.0 |
| 2014-06-01 19:00:00 | NQ | Futures | 4349.11 | 4349.7 | 4346.78 | 4347.07 | 174.0 |
| 2014-06-01 19:30:00 | NQ | Futures | 4347.07 | 4347.07 | 4344.75 | 4346.2 | 267.0 |
| 2014-06-01 20:00:00 | NQ | Futures | 4345.91 | 4349.11 | 4345.91 | 4348.53 | 259.0 |
| 2014-06-01 20:30:00 | NQ | Futures | 4348.24 | 4351.15 | 4348.24 | 4351.15 | 413.0 |
| 2014-06-01 21:00:00 | NQ | Futures | 4351.15 | 4352.61 | 4350.86 | 4352.32 | 429.0 |
| 2014-06-01 21:30:00 | NQ | Futures | 4352.03 | 4352.32 | 4351.15 | 4351.44 | 218.0 |
| 2014-06-01 22:00:00 | NQ | Futures | 4351.44 | 4353.19 | 4351.44 | 4353.19 | 218.0 |
| 2014-06-01 22:30:00 | NQ | Futures | 4353.48 | 4354.94 | 4353.48 | 4354.36 | 361.0 |
| 2014-06-01 23:00:00 | NQ | Futures | 4354.65 | 4355.52 | 4353.77 | 4354.06 | 213.0 |
| 2014-06-01 23:30:00 | NQ | Futures | 4354.06 | 4354.06 | 4352.61 | 4354.06 | 127.0 |
| 2014-06-01 18:00:00 | YM | Futures | 17202.8 | 17223.4 | 17200.7 | 17207.9 | 823.0 |
| 2014-06-01 18:30:00 | YM | Futures | 17209.0 | 17210.0 | 17205.9 | 17207.9 | 62.0 |
| 2014-06-01 19:00:00 | YM | Futures | 17206.9 | 17210.0 | 17200.7 | 17202.8 | 180.0 |
| 2014-06-01 19:30:00 | YM | Futures | 17203.8 | 17203.8 | 17198.7 | 17203.8 | 98.0 |
| 2014-06-01 20:00:00 | YM | Futures | 17203.8 | 17210.0 | 17203.8 | 17207.9 | 254.0 |
| 2014-06-01 20:30:00 | YM | Futures | 17209.0 | 17214.1 | 17202.8 | 17214.1 | 732.0 |
| 2014-06-01 21:00:00 | YM | Futures | 17213.1 | 17220.3 | 17213.1 | 17220.3 | 433.0 |
| 2014-06-01 21:30:00 | YM | Futures | 17220.3 | 17223.4 | 17217.2 | 17218.2 | 1121.0 |
| 2014-06-01 22:00:00 | YM | Futures | 17218.2 | 17224.4 | 17218.2 | 17224.4 | 231.0 |
| 2014-06-01 22:30:00 | YM | Futures | 17224.4 | 17233.7 | 17224.4 | 17231.6 | 517.0 |
| 2014-06-01 23:00:00 | YM | Futures | 17232.6 | 17236.8 | 17229.6 | 17230.6 | 543.0 |
| 2014-06-01 23:30:00 | YM | Futures | 17230.6 | 17231.6 | 17227.5 | 17229.6 | 91.0 |
| 2014-06-01 18:00:00 | CL | Futures | 166.14 | 166.17 | 166.02 | 166.07 | 442.0 |
| 2014-06-01 18:30:00 | CL | Futures | 166.07 | 166.25 | 166.01 | 166.14 | 419.0 |
| 2014-06-01 19:00:00 | CL | Futures | 166.15 | 166.23 | 166.12 | 166.22 | 205.0 |
| 2014-06-01 19:30:00 | CL | Futures | 166.22 | 166.38 | 166.18 | 166.31 | 370.0 |
| 2014-06-01 20:00:00 | CL | Futures | 166.31 | 166.38 | 166.28 | 166.28 | 302.0 |
| 2014-06-01 20:30:00 | CL | Futures | 166.3 | 166.31 | 166.27 | 166.31 | 191.0 |
| 2014-06-01 21:00:00 | CL | Futures | 166.31 | 166.36 | 166.3 | 166.33 | 309.0 |
| 2014-06-01 21:30:00 | CL | Futures | 166.35 | 166.43 | 166.33 | 166.43 | 213.0 |
| 2014-06-01 22:00:00 | CL | Futures | 166.43 | 166.52 | 166.41 | 166.51 | 388.0 |
| 2014-06-01 22:30:00 | CL | Futures | 166.51 | 166.54 | 166.48 | 166.51 | 212.0 |
| 2014-06-01 23:00:00 | CL | Futures | 166.51 | 166.52 | 166.48 | 166.48 | 228.0 |
| 2014-06-01 23:30:00 | CL | Futures | 166.49 | 166.59 | 166.48 | 166.57 | 236.0 |
| 2014-06-01 18:00:00 | GC | Futures | 1712.8 | 1713.5 | 1710.0 | 1710.2 | 1091.0 |
| 2014-06-01 18:30:00 | GC | Futures | 1710.2 | 1710.6 | 1709.4 | 1709.5 | 294.0 |
> showing 50 of 496 rows — these rows as CSV