PREVIEW / futures_30min / 2014-10-26
file: by_date/futures_30min/2014/2014-10-26.parquet size: 19 KB rows: 512
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-10-26 18:00:00 | ES | Futures | 2054.09 | 2055.4 | 2053.56 | 2054.87 | 4425.0 |
| 2014-10-26 18:30:00 | ES | Futures | 2054.87 | 2054.87 | 2053.82 | 2053.82 | 1440.0 |
| 2014-10-26 19:00:00 | ES | Futures | 2053.82 | 2056.71 | 2053.82 | 2056.18 | 3294.0 |
| 2014-10-26 19:30:00 | ES | Futures | 2056.18 | 2056.97 | 2055.4 | 2056.18 | 2622.0 |
| 2014-10-26 20:00:00 | ES | Futures | 2056.44 | 2056.71 | 2054.61 | 2056.18 | 1976.0 |
| 2014-10-26 20:30:00 | ES | Futures | 2056.18 | 2056.18 | 2054.35 | 2054.61 | 1370.0 |
| 2014-10-26 21:00:00 | ES | Futures | 2054.61 | 2055.13 | 2053.82 | 2053.82 | 2512.0 |
| 2014-10-26 21:30:00 | ES | Futures | 2053.82 | 2054.09 | 2052.25 | 2052.51 | 3908.0 |
| 2014-10-26 22:00:00 | ES | Futures | 2052.78 | 2053.56 | 2051.99 | 2052.51 | 1784.0 |
| 2014-10-26 22:30:00 | ES | Futures | 2052.78 | 2053.04 | 2051.2 | 2051.99 | 3066.0 |
| 2014-10-26 23:00:00 | ES | Futures | 2051.73 | 2052.51 | 2051.47 | 2052.25 | 505.0 |
| 2014-10-26 23:30:00 | ES | Futures | 2052.25 | 2053.56 | 2052.25 | 2053.3 | 1098.0 |
| 2014-10-26 18:00:00 | NQ | Futures | 4729.99 | 4733.51 | 4729.11 | 4731.75 | 486.0 |
| 2014-10-26 18:30:00 | NQ | Futures | 4732.04 | 4732.34 | 4729.41 | 4730.58 | 118.0 |
| 2014-10-26 19:00:00 | NQ | Futures | 4730.28 | 4737.32 | 4730.28 | 4736.44 | 487.0 |
| 2014-10-26 19:30:00 | NQ | Futures | 4736.44 | 4739.37 | 4733.8 | 4737.9 | 459.0 |
| 2014-10-26 20:00:00 | NQ | Futures | 4737.9 | 4738.49 | 4734.09 | 4738.49 | 588.0 |
| 2014-10-26 20:30:00 | NQ | Futures | 4738.2 | 4738.49 | 4734.09 | 4735.27 | 286.0 |
| 2014-10-26 21:00:00 | NQ | Futures | 4735.27 | 4735.85 | 4734.09 | 4734.68 | 397.0 |
| 2014-10-26 21:30:00 | NQ | Futures | 4734.68 | 4734.97 | 4729.41 | 4729.99 | 611.0 |
| 2014-10-26 22:00:00 | NQ | Futures | 4729.7 | 4730.87 | 4727.65 | 4728.82 | 348.0 |
| 2014-10-26 22:30:00 | NQ | Futures | 4729.11 | 4732.04 | 4728.53 | 4731.16 | 954.0 |
| 2014-10-26 23:00:00 | NQ | Futures | 4730.58 | 4732.04 | 4730.28 | 4731.16 | 135.0 |
| 2014-10-26 23:30:00 | NQ | Futures | 4731.75 | 4733.51 | 4731.46 | 4733.21 | 379.0 |
| 2014-10-26 18:00:00 | YM | Futures | 17411.9 | 17418.1 | 17400.4 | 17415.0 | 479.0 |
| 2014-10-26 18:30:00 | YM | Futures | 17416.0 | 17416.0 | 17407.7 | 17408.8 | 53.0 |
| 2014-10-26 19:00:00 | YM | Futures | 17408.8 | 17436.8 | 17405.6 | 17432.7 | 817.0 |
| 2014-10-26 19:30:00 | YM | Futures | 17432.7 | 17438.9 | 17427.5 | 17431.6 | 448.0 |
| 2014-10-26 20:00:00 | YM | Futures | 17430.6 | 17433.7 | 17419.2 | 17433.7 | 329.0 |
| 2014-10-26 20:30:00 | YM | Futures | 17432.7 | 17433.7 | 17417.1 | 17419.2 | 256.0 |
| 2014-10-26 21:00:00 | YM | Futures | 17420.2 | 17422.3 | 17414.0 | 17415.0 | 396.0 |
| 2014-10-26 21:30:00 | YM | Futures | 17412.9 | 17414.0 | 17400.4 | 17403.6 | 389.0 |
| 2014-10-26 22:00:00 | YM | Futures | 17402.5 | 17407.7 | 17398.4 | 17402.5 | 194.0 |
| 2014-10-26 22:30:00 | YM | Futures | 17403.6 | 17405.6 | 17395.2 | 17397.3 | 331.0 |
| 2014-10-26 23:00:00 | YM | Futures | 17399.4 | 17401.5 | 17397.3 | 17399.4 | 89.0 |
| 2014-10-26 23:30:00 | YM | Futures | 17399.4 | 17411.9 | 17399.4 | 17411.9 | 352.0 |
| 2014-10-26 18:00:00 | CL | Futures | 136.72 | 136.77 | 136.33 | 136.43 | 631.0 |
| 2014-10-26 18:30:00 | CL | Futures | 136.43 | 136.53 | 136.35 | 136.38 | 240.0 |
| 2014-10-26 19:00:00 | CL | Futures | 136.4 | 136.53 | 136.38 | 136.53 | 230.0 |
| 2014-10-26 19:30:00 | CL | Futures | 136.48 | 136.53 | 136.3 | 136.35 | 220.0 |
| 2014-10-26 20:00:00 | CL | Futures | 136.35 | 136.38 | 136.06 | 136.21 | 582.0 |
| 2014-10-26 20:30:00 | CL | Futures | 136.2 | 136.43 | 136.11 | 136.38 | 604.0 |
| 2014-10-26 21:00:00 | CL | Futures | 136.38 | 136.4 | 136.16 | 136.16 | 430.0 |
| 2014-10-26 21:30:00 | CL | Futures | 136.16 | 136.21 | 136.01 | 136.2 | 463.0 |
| 2014-10-26 22:00:00 | CL | Futures | 136.2 | 136.3 | 136.1 | 136.28 | 339.0 |
| 2014-10-26 22:30:00 | CL | Futures | 136.3 | 136.48 | 136.28 | 136.43 | 386.0 |
| 2014-10-26 23:00:00 | CL | Futures | 136.43 | 136.48 | 136.2 | 136.3 | 364.0 |
| 2014-10-26 23:30:00 | CL | Futures | 136.3 | 136.3 | 136.2 | 136.2 | 141.0 |
| 2014-10-26 18:00:00 | GC | Futures | 1684.5 | 1685.0 | 1680.2 | 1681.3 | 920.0 |
| 2014-10-26 18:30:00 | GC | Futures | 1681.1 | 1681.8 | 1680.7 | 1681.3 | 315.0 |
> showing 50 of 512 rows — these rows as CSV