PREVIEW / futures_daily / 2015-04-09
file: by_date/futures_daily/2015/2015-04-09.parquet size: 9 KB rows: 105
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-04-09 | ES | Futures | 2184.68 | 2194.4 | 2173.11 | 2193.09 | 1211778.0 |
| 2015-04-09 | NQ | Futures | 5083.0 | 5109.99 | 5053.68 | 5107.67 | 201439.0 |
| 2015-04-09 | YM | Futures | 18250.9 | 18313.3 | 18143.5 | 18295.9 | 130620.0 |
| 2015-04-09 | CL | Futures | 89.82 | 91.7 | 88.96 | 89.45 | 449531.0 |
| 2015-04-09 | GC | Futures | 1573.6 | 1574.5 | 1560.2 | 1561.8 | 110164.0 |
| 2015-04-09 | ZN | Futures | 122.426965 | 122.693368 | 121.95336 | 122.042161 | 1015818.0 |
| 2015-04-09 | A6 | Futures | 0.75516 | 0.76029 | 0.7525 | 0.75536 | 91328.0 |
| 2015-04-09 | AD | Futures | 0.81332 | 0.81557 | 0.80883 | 0.80975 | 51520.0 |
| 2015-04-09 | ALI | Futures | 2593.33 | 2593.33 | 2593.33 | 2593.33 | 0.0 |
| 2015-04-09 | B | Futures | 55.29 | 57.08 | 55.09 | 55.66 | 214867.0 |
| 2015-04-09 | B6 | Futures | 1.5644 | 1.5661 | 1.5449 | 1.5458 | 90969.0 |
| 2015-04-09 | BFX | Futures | 4641.9 | 4672.7 | 4641.9 | 4672.7 | 14.0 |
| 2015-04-09 | BR | Futures | 0.18702 | 0.18705 | 0.18277 | 0.18363 | 180.0 |
| 2015-04-09 | BZ | Futures | 54.85 | 56.59 | 54.68 | 55.18 | 16521.0 |
| 2015-04-09 | C | Futures | 2120.0 | 2133.0 | 2112.0 | 2127.0 | 5141.0 |
| 2015-04-09 | CC | Futures | 2046.0 | 2062.0 | 2038.0 | 2057.0 | 19356.0 |
| 2015-04-09 | CNH | Futures | 7.0188 | 7.0318 | 7.0188 | 7.0309 | 14.0 |
| 2015-04-09 | CSC | Futures | 4.386 | 4.404 | 4.386 | 4.386 | 48.0 |
| 2015-04-09 | CT | Futures | 85.56 | 86.04 | 84.74 | 84.88 | 29686.0 |
| 2015-04-09 | DC | Futures | 35.58 | 36.05 | 35.58 | 35.83 | 66.0 |
| 2015-04-09 | DX | Futures | 92.263 | 93.348 | 92.24 | 93.329 | 52507.0 |
| 2015-04-09 | E1 | Futures | 1.32118 | 1.3222 | 1.30487 | 1.30512 | 20210.0 |
| 2015-04-09 | E6 | Futures | 1.26894 | 1.26965 | 1.25178 | 1.25213 | 261250.0 |
| 2015-04-09 | E7 | Futures | 1.2616 | 1.2624 | 1.2447 | 1.2449 | 6164.0 |
| 2015-04-09 | EBM | Futures | 304.89 | 305.69 | 303.28 | 303.68 | 19643.0 |
| 2015-04-09 | ED | Futures | 95.5381 | 95.5381 | 95.5333 | 95.5381 | 63490.0 |
| 2015-04-09 | ER | Futures | 98.063 | 98.073 | 98.058 | 98.063 | 29346.0 |
| 2015-04-09 | EW | Futures | 1604.1 | 1607.9 | 1592.0 | 1603.5 | 16696.0 |
| 2015-04-09 | FBTP | Futures | 104.13 | 104.13 | 103.61 | 103.76 | 75329.0 |
| 2015-04-09 | FBTS | Futures | 99.697 | 99.697 | 99.652 | 99.652 | 13543.0 |
| 2015-04-09 | FCE | Futures | 4189.5 | 4255.0 | 4185.5 | 4237.1 | 94362.0 |
| 2015-04-09 | FDAX | Futures | 13431.7 | 13594.8 | 13395.6 | 13519.3 | 83781.0 |
| 2015-04-09 | FESX | Futures | 2718.3 | 2749.2 | 2713.1 | 2733.7 | 725833.0 |
| 2015-04-09 | FGBL | Futures | 141.39 | 141.65 | 141.26 | 141.37 | 454404.0 |
| 2015-04-09 | FGBM | Futures | 125.03 | 125.05 | 124.95 | 124.98 | 261816.0 |
| 2015-04-09 | FGBS | Futures | 111.328 | 111.328 | 111.303 | 111.313 | 137614.0 |
| 2015-04-09 | FGBX | Futures | 176.6 | 177.49 | 176.1 | 176.38 | 22319.0 |
| 2015-04-09 | FMWO | Futures | 5824.9 | 5824.9 | 5816.2 | 5816.2 | 1.0 |
| 2015-04-09 | FOAT | Futures | 130.12 | 130.38 | 130.0 | 130.05 | 64542.0 |
| 2015-04-09 | FTDX | Futures | 1532.1 | 1546.7 | 1532.1 | 1544.8 | 132.0 |
| 2015-04-09 | FTI | Futures | 431.33 | 435.92 | 430.9 | 433.93 | 20995.0 |
| 2015-04-09 | FTUK | Futures | 5440.9 | 5513.4 | 5440.1 | 5484.6 | 85991.0 |
| 2015-04-09 | FVSA | Futures | 1677.07 | 1677.07 | 1588.13 | 1638.95 | 18237.0 |
| 2015-04-09 | FXXP | Futures | 307.4 | 311.2 | 307.2 | 309.8 | 12543.0 |
| 2015-04-09 | G | Futures | 105.0 | 105.52 | 104.88 | 104.97 | 126144.0 |
| 2015-04-09 | GF | Futures | 367.541 | 368.856 | 367.032 | 367.244 | 536.0 |
| 2015-04-09 | GSCI | Futures | 699.55 | 706.7 | 696.11 | 697.83 | 3294.0 |
| 2015-04-09 | HE | Futures | 81.545 | 81.834 | 80.562 | 81.545 | 208.0 |
| 2015-04-09 | HG | Futures | 3.4743 | 3.506 | 3.4501 | 3.4673 | 40445.0 |
| 2015-04-09 | HH | Futures | 32.299 | 32.608 | 31.14 | 31.189 | 2697.0 |
> showing 50 of 105 rows — these rows as CSV