PREVIEW / futures_daily / 2015-11-27
file: by_date/futures_daily/2015/2015-11-27.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-27 | ES | Futures | 2228.29 | 2232.02 | 2214.2 | 2223.24 | 653387.0 |
| 2015-11-27 | NQ | Futures | 5471.6 | 5499.08 | 5454.07 | 5474.82 | 105382.0 |
| 2015-11-27 | YM | Futures | 18407.9 | 18421.4 | 18285.2 | 18366.7 | 75998.0 |
| 2015-11-27 | CL | Futures | 66.8 | 66.88 | 64.36 | 64.42 | 316475.0 |
| 2015-11-27 | GC | Futures | 1380.7 | 1385.0 | 1356.2 | 1362.2 | 187114.0 |
| 2015-11-27 | ZN | Futures | 121.760731 | 121.880471 | 121.670926 | 121.730796 | 509241.0 |
| 2015-11-27 | A6 | Futures | 0.72493 | 0.72593 | 0.71803 | 0.71903 | 85488.0 |
| 2015-11-27 | AD | Futures | 0.77035 | 0.77097 | 0.76564 | 0.76666 | 38185.0 |
| 2015-11-27 | ALI | Futures | 2122.8 | 2122.8 | 2122.8 | 2122.8 | 0.0 |
| 2015-11-27 | B | Futures | 40.38 | 40.4 | 39.59 | 39.66 | 82761.0 |
| 2015-11-27 | B6 | Futures | 1.5927 | 1.5932 | 1.5827 | 1.5849 | 76602.0 |
| 2015-11-27 | BFX | Futures | 4537.0 | 4564.9 | 4537.0 | 4553.4 | 29.0 |
| 2015-11-27 | BR | Futures | 0.1628 | 0.16441 | 0.16076 | 0.16107 | 498.0 |
| 2015-11-27 | BZ | Futures | 40.59 | 40.6 | 39.26 | 39.31 | 13766.0 |
| 2015-11-27 | C | Futures | 2391.0 | 2413.0 | 2391.0 | 2409.0 | 4806.0 |
| 2015-11-27 | CC | Futures | 2437.0 | 2446.0 | 2435.0 | 2440.0 | 6357.0 |
| 2015-11-27 | CNH | Futures | 7.1592 | 7.1836 | 7.1592 | 7.1742 | 35.0 |
| 2015-11-27 | CT | Futures | 74.79 | 75.16 | 73.6 | 74.89 | 15687.0 |
| 2015-11-27 | DX | Futures | 93.461 | 93.765 | 93.245 | 93.594 | 14134.0 |
| 2015-11-27 | E1 | Futures | 1.24218 | 1.24244 | 1.22861 | 1.23292 | 21923.0 |
| 2015-11-27 | E6 | Futures | 1.24266 | 1.24652 | 1.23821 | 1.24196 | 159550.0 |
| 2015-11-27 | E7 | Futures | 1.236 | 1.2396 | 1.2315 | 1.2351 | 3045.0 |
| 2015-11-27 | EBM | Futures | 258.32 | 258.69 | 256.49 | 257.59 | 9143.0 |
| 2015-11-27 | ED | Futures | 95.6559 | 95.6631 | 95.6559 | 95.6559 | 94148.0 |
| 2015-11-27 | ER | Futures | 98.269 | 98.279 | 98.269 | 98.279 | 52028.0 |
| 2015-11-27 | EW | Futures | 1551.9 | 1552.1 | 1537.1 | 1551.6 | 11219.0 |
| 2015-11-27 | FBON | Futures | 117.0 | 117.45 | 117.0 | 117.39 | 1009.0 |
| 2015-11-27 | FBTP | Futures | 106.03 | 106.44 | 106.0 | 106.33 | 104017.0 |
| 2015-11-27 | FBTS | Futures | 100.874 | 100.892 | 100.802 | 100.811 | 32331.0 |
| 2015-11-27 | FCE | Futures | 4109.2 | 4146.3 | 4096.6 | 4119.2 | 63171.0 |
| 2015-11-27 | FDAX | Futures | 12392.0 | 12507.1 | 12382.7 | 12438.8 | 63413.0 |
| 2015-11-27 | FDXM | Futures | 11585.5 | 11685.3 | 11570.1 | 11621.5 | 8596.0 |
| 2015-11-27 | FESX | Futures | 2605.9 | 2632.9 | 2599.9 | 2614.1 | 701630.0 |
| 2015-11-27 | FGBL | Futures | 140.97 | 141.29 | 140.86 | 141.12 | 499662.0 |
| 2015-11-27 | FGBM | Futures | 126.28 | 126.36 | 126.23 | 126.3 | 332233.0 |
| 2015-11-27 | FGBS | Futures | 111.613 | 111.633 | 111.598 | 111.603 | 167391.0 |
| 2015-11-27 | FGBX | Futures | 160.02 | 160.79 | 159.77 | 160.16 | 21090.0 |
| 2015-11-27 | FMWO | Futures | 5690.4 | 5694.1 | 5690.4 | 5694.1 | 1.0 |
| 2015-11-27 | FOAT | Futures | 129.48 | 129.88 | 129.37 | 129.71 | 63897.0 |
| 2015-11-27 | FTDX | Futures | 1738.7 | 1750.5 | 1737.7 | 1749.1 | 107.0 |
| 2015-11-27 | FTI | Futures | 408.94 | 412.71 | 407.42 | 410.33 | 23819.0 |
| 2015-11-27 | FTUK | Futures | 5132.1 | 5139.4 | 5102.0 | 5130.1 | 60079.0 |
| 2015-11-27 | FVSA | Futures | 2068.08 | 2115.41 | 2049.15 | 2091.75 | 10442.0 |
| 2015-11-27 | FXXP | Futures | 297.7 | 300.0 | 297.4 | 298.8 | 13969.0 |
| 2015-11-27 | G | Futures | 104.68 | 105.01 | 104.66 | 104.93 | 137609.0 |
| 2015-11-27 | GF | Futures | 318.543 | 321.487 | 318.157 | 320.474 | 1856.0 |
| 2015-11-27 | GSCI | Futures | 543.22 | 543.22 | 534.99 | 535.54 | 27.0 |
| 2015-11-27 | HE | Futures | 83.141 | 83.141 | 82.065 | 82.746 | 6014.0 |
| 2015-11-27 | HG | Futures | 2.5674 | 2.6765 | 2.5661 | 2.5799 | 82244.0 |
| 2015-11-27 | HH | Futures | 24.122 | 24.23 | 23.82 | 23.874 | 2959.0 |
> showing 50 of 106 rows — these rows as CSV