PREVIEW / futures_daily / 2014-12-08
file: by_date/futures_daily/2014/2014-12-08.parquet size: 9 KB rows: 107
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2014-12-08 | ES | Futures | 2168.3 | 2170.13 | 2145.32 | 2151.32 | 1414138.0 |
| 2014-12-08 | NQ | Futures | 5000.11 | 5007.07 | 4936.08 | 4959.26 | 320418.0 |
| 2014-12-08 | YM | Futures | 18213.7 | 18223.9 | 18051.4 | 18110.3 | 134648.0 |
| 2014-12-08 | CL | Futures | 126.19 | 126.36 | 121.02 | 121.54 | 330077.0 |
| 2014-12-08 | GC | Futures | 1559.2 | 1582.9 | 1554.1 | 1564.0 | 107505.0 |
| 2014-12-08 | ZN | Futures | 118.568672 | 119.069211 | 118.28896 | 118.921994 | 1083456.0 |
| 2014-12-08 | A6 | Futures | 0.8061 | 0.80853 | 0.80231 | 0.80591 | 90644.0 |
| 2014-12-08 | AD | Futures | 0.88787 | 0.88878 | 0.88431 | 0.88523 | 59170.0 |
| 2014-12-08 | ALI | Futures | 2943.77 | 2943.77 | 2943.77 | 2943.77 | 0.0 |
| 2014-12-08 | B | Futures | 71.39 | 71.49 | 68.61 | 68.86 | 137142.0 |
| 2014-12-08 | B6 | Futures | 1.6359 | 1.648 | 1.6336 | 1.6463 | 75564.0 |
| 2014-12-08 | BFX | Futures | 4033.4 | 4033.4 | 4023.3 | 4023.3 | 5.0 |
| 2014-12-08 | BR | Futures | 0.20659 | 0.20679 | 0.20532 | 0.20623 | 43.0 |
| 2014-12-08 | BZ | Futures | 71.36 | 71.79 | 69.22 | 69.47 | 14801.0 |
| 2014-12-08 | C | Futures | 2108.0 | 2113.0 | 2101.0 | 2108.0 | 6857.0 |
| 2014-12-08 | CB | Futures | 138.629 | 138.629 | 138.013 | 138.568 | 27.0 |
| 2014-12-08 | CC | Futures | 2130.0 | 2147.0 | 2129.0 | 2142.0 | 7414.0 |
| 2014-12-08 | CNH | Futures | 7.0827 | 7.0843 | 7.0765 | 7.0765 | 38.0 |
| 2014-12-08 | CSC | Futures | 4.663 | 4.674 | 4.651 | 4.671 | 79.0 |
| 2014-12-08 | CT | Futures | 76.16 | 76.85 | 75.74 | 75.75 | 10111.0 |
| 2014-12-08 | DC | Futures | 37.26 | 37.4 | 36.93 | 37.19 | 164.0 |
| 2014-12-08 | DX | Futures | 84.898 | 85.022 | 84.4 | 84.53 | 45090.0 |
| 2014-12-08 | E1 | Futures | 1.30653 | 1.31305 | 1.30244 | 1.31088 | 43113.0 |
| 2014-12-08 | E6 | Futures | 1.44643 | 1.45326 | 1.44172 | 1.45102 | 209860.0 |
| 2014-12-08 | E7 | Futures | 1.4372 | 1.444 | 1.4328 | 1.4419 | 2006.0 |
| 2014-12-08 | EBM | Futures | 305.76 | 307.79 | 303.73 | 306.98 | 14347.0 |
| 2014-12-08 | ED | Futures | 95.4398 | 95.4422 | 95.4374 | 95.4398 | 86908.0 |
| 2014-12-08 | ER | Futures | 98.004 | 98.009 | 97.999 | 97.999 | 45865.0 |
| 2014-12-08 | EW | Futures | 1504.8 | 1511.8 | 1487.0 | 1493.2 | 16370.0 |
| 2014-12-08 | FBTP | Futures | 98.14 | 98.43 | 97.78 | 98.38 | 58973.0 |
| 2014-12-08 | FBTS | Futures | 98.721 | 98.774 | 98.579 | 98.765 | 8979.0 |
| 2014-12-08 | FCE | Futures | 3569.0 | 3573.1 | 3520.0 | 3541.9 | 68497.0 |
| 2014-12-08 | FDAX | Futures | 11052.5 | 11056.4 | 10901.9 | 10984.1 | 87152.0 |
| 2014-12-08 | FESX | Futures | 2370.9 | 2374.5 | 2336.1 | 2354.2 | 697213.0 |
| 2014-12-08 | FGBL | Futures | 133.71 | 134.57 | 133.6 | 134.39 | 622808.0 |
| 2014-12-08 | FGBM | Futures | 123.07 | 123.31 | 123.0 | 123.24 | 412634.0 |
| 2014-12-08 | FGBS | Futures | 110.808 | 110.858 | 110.798 | 110.833 | 235185.0 |
| 2014-12-08 | FGBX | Futures | 147.81 | 149.94 | 147.65 | 149.32 | 25387.0 |
| 2014-12-08 | FMWO | Futures | 5766.4 | 5777.7 | 5766.4 | 5771.4 | 159.0 |
| 2014-12-08 | FOAT | Futures | 123.84 | 124.37 | 123.58 | 124.31 | 55384.0 |
| 2014-12-08 | FTDX | Futures | 1305.7 | 1310.0 | 1300.1 | 1305.3 | 306.0 |
| 2014-12-08 | FTI | Futures | 374.72 | 374.94 | 369.37 | 371.63 | 23609.0 |
| 2014-12-08 | FTUK | Futures | 5201.7 | 5204.8 | 5132.1 | 5167.6 | 74009.0 |
| 2014-12-08 | FVSA | Futures | 1468.08 | 1481.26 | 1441.7 | 1463.68 | 6092.0 |
| 2014-12-08 | FXXP | Futures | 266.1 | 266.1 | 263.7 | 264.9 | 5631.0 |
| 2014-12-08 | G | Futures | 100.62 | 101.21 | 100.42 | 101.1 | 139768.0 |
| 2014-12-08 | GF | Futures | 376.092 | 376.212 | 372.041 | 372.041 | 3969.0 |
| 2014-12-08 | GSCI | Futures | 792.34 | 792.85 | 780.86 | 782.21 | 2398.0 |
| 2014-12-08 | HE | Futures | 114.703 | 114.838 | 113.496 | 114.2 | 13159.0 |
| 2014-12-08 | HG | Futures | 3.6851 | 3.7105 | 3.6603 | 3.6654 | 34272.0 |
> showing 50 of 107 rows — these rows as CSV