PREVIEW / futures_30min / 2014-12-07
file: by_date/futures_30min/2014/2014-12-07.parquet size: 18 KB rows: 483
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-07 18:00:00 | ES | Futures | 2175.12 | 2176.16 | 2174.33 | 2176.16 | 3796.0 |
| 2014-12-07 18:30:00 | ES | Futures | 2175.9 | 2176.95 | 2175.12 | 2175.38 | 1823.0 |
| 2014-12-07 19:00:00 | ES | Futures | 2175.38 | 2176.95 | 2175.12 | 2176.69 | 2232.0 |
| 2014-12-07 19:30:00 | ES | Futures | 2176.43 | 2176.69 | 2174.33 | 2174.33 | 2959.0 |
| 2014-12-07 20:00:00 | ES | Futures | 2174.33 | 2174.85 | 2173.54 | 2173.81 | 2492.0 |
| 2014-12-07 20:30:00 | ES | Futures | 2173.81 | 2175.38 | 2173.81 | 2174.85 | 1225.0 |
| 2014-12-07 21:00:00 | ES | Futures | 2174.85 | 2175.38 | 2174.33 | 2175.12 | 1534.0 |
| 2014-12-07 21:30:00 | ES | Futures | 2175.12 | 2175.64 | 2174.85 | 2175.38 | 871.0 |
| 2014-12-07 22:00:00 | ES | Futures | 2175.38 | 2175.38 | 2174.85 | 2175.12 | 358.0 |
| 2014-12-07 22:30:00 | ES | Futures | 2174.85 | 2175.12 | 2174.07 | 2174.07 | 1087.0 |
| 2014-12-07 23:00:00 | ES | Futures | 2174.33 | 2174.59 | 2174.33 | 2174.33 | 576.0 |
| 2014-12-07 23:30:00 | ES | Futures | 2174.33 | 2174.59 | 2174.07 | 2174.59 | 451.0 |
| 2014-12-07 18:00:00 | NQ | Futures | 5056.4 | 5057.86 | 5053.47 | 5057.86 | 916.0 |
| 2014-12-07 18:30:00 | NQ | Futures | 5057.28 | 5059.33 | 5055.81 | 5056.11 | 248.0 |
| 2014-12-07 19:00:00 | NQ | Futures | 5056.4 | 5059.62 | 5055.81 | 5059.04 | 380.0 |
| 2014-12-07 19:30:00 | NQ | Futures | 5058.74 | 5058.74 | 5053.18 | 5053.47 | 362.0 |
| 2014-12-07 20:00:00 | NQ | Futures | 5053.47 | 5054.35 | 5052.3 | 5053.47 | 574.0 |
| 2014-12-07 20:30:00 | NQ | Futures | 5053.18 | 5056.69 | 5052.88 | 5055.52 | 195.0 |
| 2014-12-07 21:00:00 | NQ | Futures | 5055.81 | 5056.4 | 5054.64 | 5055.81 | 184.0 |
| 2014-12-07 21:30:00 | NQ | Futures | 5055.81 | 5057.57 | 5055.52 | 5056.11 | 153.0 |
| 2014-12-07 22:00:00 | NQ | Futures | 5055.81 | 5056.11 | 5054.93 | 5056.11 | 127.0 |
| 2014-12-07 22:30:00 | NQ | Futures | 5056.11 | 5056.11 | 5053.76 | 5054.06 | 179.0 |
| 2014-12-07 23:00:00 | NQ | Futures | 5054.35 | 5055.23 | 5054.06 | 5054.64 | 110.0 |
| 2014-12-07 23:30:00 | NQ | Futures | 5054.64 | 5056.11 | 5054.64 | 5055.52 | 107.0 |
| 2014-12-07 18:00:00 | YM | Futures | 18666.9 | 18671.0 | 18659.6 | 18671.0 | 379.0 |
| 2014-12-07 18:30:00 | YM | Futures | 18671.0 | 18676.2 | 18663.7 | 18666.9 | 173.0 |
| 2014-12-07 19:00:00 | YM | Futures | 18665.8 | 18677.3 | 18665.8 | 18674.1 | 269.0 |
| 2014-12-07 19:30:00 | YM | Futures | 18676.2 | 18676.2 | 18657.5 | 18659.6 | 368.0 |
| 2014-12-07 20:00:00 | YM | Futures | 18660.6 | 18662.7 | 18654.4 | 18656.5 | 526.0 |
| 2014-12-07 20:30:00 | YM | Futures | 18656.5 | 18666.9 | 18655.4 | 18664.8 | 301.0 |
| 2014-12-07 21:00:00 | YM | Futures | 18663.7 | 18666.9 | 18659.6 | 18664.8 | 206.0 |
| 2014-12-07 21:30:00 | YM | Futures | 18664.8 | 18668.9 | 18664.8 | 18666.9 | 127.0 |
| 2014-12-07 22:00:00 | YM | Futures | 18666.9 | 18666.9 | 18663.7 | 18663.7 | 57.0 |
| 2014-12-07 22:30:00 | YM | Futures | 18664.8 | 18664.8 | 18656.5 | 18658.6 | 208.0 |
| 2014-12-07 23:00:00 | YM | Futures | 18658.6 | 18661.7 | 18658.6 | 18659.6 | 89.0 |
| 2014-12-07 23:30:00 | YM | Futures | 18660.6 | 18661.7 | 18658.6 | 18660.6 | 56.0 |
| 2014-12-07 18:00:00 | CL | Futures | 110.26 | 110.42 | 109.14 | 109.14 | 2658.0 |
| 2014-12-07 18:30:00 | CL | Futures | 109.14 | 109.24 | 108.87 | 109.17 | 1701.0 |
| 2014-12-07 19:00:00 | CL | Futures | 109.19 | 109.36 | 109.1 | 109.36 | 703.0 |
| 2014-12-07 19:30:00 | CL | Futures | 109.36 | 109.46 | 109.19 | 109.27 | 874.0 |
| 2014-12-07 20:00:00 | CL | Futures | 109.25 | 109.62 | 109.24 | 109.56 | 1243.0 |
| 2014-12-07 20:30:00 | CL | Futures | 109.56 | 109.81 | 109.42 | 109.74 | 996.0 |
| 2014-12-07 21:00:00 | CL | Futures | 109.73 | 109.78 | 109.51 | 109.64 | 857.0 |
| 2014-12-07 21:30:00 | CL | Futures | 109.62 | 109.68 | 109.54 | 109.64 | 531.0 |
| 2014-12-07 22:00:00 | CL | Futures | 109.66 | 109.73 | 109.57 | 109.62 | 408.0 |
| 2014-12-07 22:30:00 | CL | Futures | 109.62 | 109.66 | 109.57 | 109.61 | 143.0 |
| 2014-12-07 23:00:00 | CL | Futures | 109.62 | 109.62 | 109.39 | 109.44 | 528.0 |
| 2014-12-07 23:30:00 | CL | Futures | 109.46 | 109.73 | 109.44 | 109.64 | 856.0 |
| 2014-12-07 18:00:00 | GC | Futures | 1629.6 | 1629.6 | 1624.3 | 1625.2 | 1815.0 |
| 2014-12-07 18:30:00 | GC | Futures | 1625.2 | 1629.2 | 1624.7 | 1627.3 | 846.0 |
> showing 50 of 483 rows — these rows as CSV