PREVIEW / futures_daily / 2015-11-16
file: by_date/futures_daily/2015/2015-11-16.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 |
|---|---|---|---|---|---|---|---|
| 2015-11-16 | ES | Futures | 2134.42 | 2181.75 | 2125.91 | 2178.56 | 1711062.0 |
| 2015-11-16 | NQ | Futures | 5236.01 | 5338.02 | 5208.82 | 5331.3 | 282188.0 |
| 2015-11-16 | YM | Futures | 17651.6 | 18001.4 | 17593.9 | 17974.6 | 171733.0 |
| 2015-11-16 | CL | Futures | 65.02 | 66.78 | 63.65 | 66.09 | 354422.0 |
| 2015-11-16 | GC | Futures | 1404.4 | 1416.6 | 1394.8 | 1398.8 | 151381.0 |
| 2015-11-16 | ZN | Futures | 121.596088 | 121.596088 | 121.296738 | 121.341641 | 965992.0 |
| 2015-11-16 | A6 | Futures | 0.71103 | 0.71223 | 0.70713 | 0.70823 | 60780.0 |
| 2015-11-16 | AD | Futures | 0.76892 | 0.77045 | 0.76574 | 0.768 | 52448.0 |
| 2015-11-16 | ALI | Futures | 2106.13 | 2106.13 | 2106.13 | 2106.13 | 8.0 |
| 2015-11-16 | B | Futures | 39.43 | 39.85 | 38.06 | 39.31 | 310123.0 |
| 2015-11-16 | B6 | Futures | 1.6031 | 1.6035 | 1.5986 | 1.6002 | 47935.0 |
| 2015-11-16 | BR | Futures | 0.1582 | 0.16057 | 0.15774 | 0.1602 | 3013.0 |
| 2015-11-16 | BZ | Futures | 38.99 | 39.6 | 37.84 | 39.06 | 35040.0 |
| 2015-11-16 | C | Futures | 2455.0 | 2475.0 | 2449.0 | 2468.0 | 5290.0 |
| 2015-11-16 | CB | Futures | 218.473 | 222.385 | 218.473 | 222.385 | 6.0 |
| 2015-11-16 | CC | Futures | 2491.0 | 2499.0 | 2466.0 | 2490.0 | 16495.0 |
| 2015-11-16 | CNH | Futures | 7.1359 | 7.1514 | 7.1133 | 7.1232 | 209.0 |
| 2015-11-16 | CSC | Futures | 4.171 | 4.184 | 4.099 | 4.102 | 76.0 |
| 2015-11-16 | CT | Futures | 73.87 | 75.4 | 73.49 | 74.06 | 21247.0 |
| 2015-11-16 | DC | Futures | 33.43 | 33.59 | 32.88 | 32.9 | 303.0 |
| 2015-11-16 | DX | Futures | 92.647 | 93.1 | 92.563 | 93.094 | 31575.0 |
| 2015-11-16 | E1 | Futures | 1.26159 | 1.264 | 1.25652 | 1.2569 | 19961.0 |
| 2015-11-16 | E6 | Futures | 1.25812 | 1.2607 | 1.25086 | 1.25121 | 175399.0 |
| 2015-11-16 | E7 | Futures | 1.2506 | 1.2536 | 1.244 | 1.2443 | 3160.0 |
| 2015-11-16 | EBM | Futures | 258.32 | 258.32 | 256.13 | 257.22 | 29816.0 |
| 2015-11-16 | ED | Futures | 95.7015 | 95.7111 | 95.6871 | 95.6895 | 203901.0 |
| 2015-11-16 | ER | Futures | 98.239 | 98.254 | 98.225 | 98.229 | 53877.0 |
| 2015-11-16 | EW | Futures | 1472.6 | 1500.2 | 1464.0 | 1499.0 | 20002.0 |
| 2015-11-16 | FBON | Futures | 114.58 | 114.69 | 114.35 | 114.53 | 502.0 |
| 2015-11-16 | FBTP | Futures | 104.99 | 104.99 | 104.44 | 104.67 | 76335.0 |
| 2015-11-16 | FBTS | Futures | 100.65 | 100.659 | 100.606 | 100.642 | 15608.0 |
| 2015-11-16 | FCE | Futures | 3949.1 | 4061.5 | 3941.2 | 4012.6 | 40354.0 |
| 2015-11-16 | FDAX | Futures | 11564.4 | 11917.3 | 11544.5 | 11770.9 | 101828.0 |
| 2015-11-16 | FDXM | Futures | 10819.9 | 11128.6 | 10778.8 | 10997.9 | 12541.0 |
| 2015-11-16 | FESX | Futures | 2467.2 | 2548.2 | 2460.5 | 2513.0 | 1173229.0 |
| 2015-11-16 | FGBL | Futures | 139.96 | 140.05 | 139.51 | 139.98 | 572723.0 |
| 2015-11-16 | FGBM | Futures | 125.9 | 125.93 | 125.76 | 125.87 | 355800.0 |
| 2015-11-16 | FGBS | Futures | 111.563 | 111.563 | 111.518 | 111.533 | 172182.0 |
| 2015-11-16 | FGBX | Futures | 157.51 | 157.63 | 155.98 | 157.43 | 24235.0 |
| 2015-11-16 | FMWO | Futures | 5517.3 | 5547.0 | 5517.3 | 5530.9 | 2416.0 |
| 2015-11-16 | FOAT | Futures | 128.72 | 128.73 | 128.27 | 128.65 | 61437.0 |
| 2015-11-16 | FTDX | Futures | 1678.5 | 1714.5 | 1674.2 | 1705.5 | 174.0 |
| 2015-11-16 | FTI | Futures | 388.43 | 399.29 | 388.39 | 394.69 | 10013.0 |
| 2015-11-16 | FTUK | Futures | 4871.2 | 5004.3 | 4855.1 | 4928.3 | 104195.0 |
| 2015-11-16 | FVSA | Futures | 2295.24 | 2299.97 | 2077.55 | 2191.13 | 13278.0 |
| 2015-11-16 | FXXP | Futures | 282.8 | 292.1 | 277.2 | 288.2 | 34080.0 |
| 2015-11-16 | G | Futures | 103.86 | 103.99 | 103.61 | 103.93 | 129981.0 |
| 2015-11-16 | GF | Futures | 312.801 | 312.849 | 308.94 | 309.037 | 3266.0 |
| 2015-11-16 | GSCI | Futures | 539.03 | 540.85 | 532.69 | 538.71 | 122.0 |
| 2015-11-16 | HE | Futures | 82.522 | 82.522 | 77.474 | 77.474 | 18393.0 |
> showing 50 of 107 rows — these rows as CSV