PREVIEW / futures_daily / 2017-11-22
file: by_date/futures_daily/2017/2017-11-22.parquet size: 8 KB rows: 84
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-22 | ES | Futures | 2823.38 | 2828.0 | 2820.12 | 2822.02 | 770812.0 |
| 2017-11-22 | NQ | Futures | 7495.49 | 7511.93 | 7488.44 | 7505.18 | 191140.0 |
| 2017-11-22 | YM | Futures | 24868.7 | 24920.4 | 24790.5 | 24800.0 | 93770.0 |
| 2017-11-22 | CL | Futures | 57.18 | 58.21 | 57.09 | 58.08 | 837411.0 |
| 2017-11-22 | GC | Futures | 1629.4 | 1647.3 | 1626.9 | 1644.2 | 390311.0 |
| 2017-11-22 | ZN | Futures | 122.977596 | 123.378124 | 122.854356 | 123.347314 | 869759.0 |
| 2017-11-22 | AD | Futures | 0.79641 | 0.8017 | 0.79611 | 0.80109 | 66017.0 |
| 2017-11-22 | B | Futures | 44.41 | 44.86 | 44.29 | 44.79 | 322870.0 |
| 2017-11-22 | B6 | Futures | 1.3817 | 1.3908 | 1.3785 | 1.3898 | 121611.0 |
| 2017-11-22 | BR | Futures | 0.2314 | 0.23441 | 0.23098 | 0.23294 | 6373.0 |
| 2017-11-22 | C | Futures | 1516.0 | 1521.0 | 1510.0 | 1518.0 | 3979.0 |
| 2017-11-22 | CB | Futures | 284.15 | 284.397 | 284.15 | 284.397 | 7.0 |
| 2017-11-22 | CC | Futures | 1579.0 | 1590.0 | 1574.0 | 1585.0 | 10023.0 |
| 2017-11-22 | CNH | Futures | 6.8193 | 6.8193 | 6.7841 | 6.7841 | 85.0 |
| 2017-11-22 | CSC | Futures | 3.373 | 3.414 | 3.373 | 3.398 | 15.0 |
| 2017-11-22 | CT | Futures | 83.28 | 85.05 | 82.81 | 83.09 | 4453.0 |
| 2017-11-22 | DX | Futures | 87.769 | 87.793 | 87.082 | 87.096 | 24893.0 |
| 2017-11-22 | E1 | Futures | 1.23531 | 1.24802 | 1.23506 | 1.24741 | 20843.0 |
| 2017-11-22 | E6 | Futures | 1.34095 | 1.35139 | 1.3406 | 1.35099 | 192218.0 |
| 2017-11-22 | E7 | Futures | 1.3337 | 1.3444 | 1.3337 | 1.3439 | 4889.0 |
| 2017-11-22 | EBM | Futures | 170.73 | 171.54 | 170.73 | 171.27 | 16312.0 |
| 2017-11-22 | ER | Futures | 98.347 | 98.347 | 98.342 | 98.342 | 13959.0 |
| 2017-11-22 | EW | Futures | 1973.1 | 1981.0 | 1971.3 | 1974.2 | 10815.0 |
| 2017-11-22 | FBON | Futures | 126.37 | 126.54 | 126.22 | 126.52 | 271.0 |
| 2017-11-22 | FBTP | Futures | 113.03 | 113.21 | 112.72 | 113.13 | 72476.0 |
| 2017-11-22 | FBTS | Futures | 103.869 | 103.887 | 103.842 | 103.869 | 54651.0 |
| 2017-11-22 | FCE | Futures | 4809.1 | 4827.0 | 4786.7 | 4792.5 | 59527.0 |
| 2017-11-22 | FDAX | Futures | 13847.2 | 13862.5 | 13622.9 | 13672.8 | 94817.0 |
| 2017-11-22 | FDXM | Futures | 13735.6 | 13745.0 | 13508.4 | 13557.4 | 30295.0 |
| 2017-11-22 | FESX | Futures | 2919.7 | 2931.9 | 2898.5 | 2904.2 | 797925.0 |
| 2017-11-22 | FGBL | Futures | 150.92 | 150.99 | 150.35 | 150.7 | 721836.0 |
| 2017-11-22 | FGBM | Futures | 130.13 | 130.14 | 129.85 | 129.97 | 602730.0 |
| 2017-11-22 | FGBS | Futures | 112.527 | 112.532 | 112.472 | 112.482 | 488867.0 |
| 2017-11-22 | FGBX | Futures | 170.91 | 171.46 | 169.95 | 170.75 | 71624.0 |
| 2017-11-22 | FMWO | Futures | 6819.5 | 6830.1 | 6813.6 | 6819.5 | 647.0 |
| 2017-11-22 | FOAT | Futures | 139.44 | 139.51 | 138.98 | 139.27 | 114225.0 |
| 2017-11-22 | FTDX | Futures | 2580.3 | 2587.8 | 2557.4 | 2562.8 | 368.0 |
| 2017-11-22 | FTI | Futures | 503.8 | 505.47 | 500.64 | 501.38 | 23685.0 |
| 2017-11-22 | FTUK | Futures | 6422.6 | 6468.6 | 6418.7 | 6429.1 | 93473.0 |
| 2017-11-22 | FVSA | Futures | 315.75 | 318.1 | 307.53 | 314.57 | 15949.0 |
| 2017-11-22 | FXXP | Futures | 330.0 | 331.0 | 328.3 | 328.7 | 21972.0 |
| 2017-11-22 | G | Futures | 114.6 | 114.65 | 114.19 | 114.41 | 265517.0 |
| 2017-11-22 | GSCI | Futures | 499.4 | 500.51 | 499.4 | 500.04 | 291.0 |
| 2017-11-22 | HG | Futures | 3.7713 | 3.7905 | 3.7593 | 3.7815 | 31234.0 |
| 2017-11-22 | HRC | Futures | 1509.9 | 1509.9 | 1509.9 | 1509.9 | 0.0 |
| 2017-11-22 | J1 | Futures | 0.0109045 | 0.0110368 | 0.0109045 | 0.0110338 | 181019.0 |
| 2017-11-22 | J7 | Futures | 0.010883 | 0.01101 | 0.010881 | 0.011008 | 613.0 |
| 2017-11-22 | JB | Futures | 138.4 | 138.51 | 138.39 | 138.45 | 3.0 |
| 2017-11-22 | KC | Futures | 157.92 | 159.55 | 157.74 | 158.55 | 12569.0 |
| 2017-11-22 | KE | Futures | 840.63 | 850.14 | 836.63 | 842.63 | 0.0 |
> showing 50 of 84 rows — these rows as CSV