PREVIEW / futures_daily / 2017-03-30
file: by_date/futures_daily/2017/2017-03-30.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 |
|---|---|---|---|---|---|---|---|
| 2017-03-30 | ES | Futures | 2559.8 | 2570.39 | 2555.73 | 2567.95 | 1164616.0 |
| 2017-03-30 | NQ | Futures | 6402.46 | 6420.13 | 6391.27 | 6404.23 | 163121.0 |
| 2017-03-30 | YM | Futures | 21733.3 | 21835.6 | 21704.8 | 21799.8 | 104368.0 |
| 2017-03-30 | CL | Futures | 51.99 | 52.9 | 51.64 | 52.77 | 580668.0 |
| 2017-03-30 | GC | Futures | 1606.3 | 1606.8 | 1591.1 | 1596.0 | 217657.0 |
| 2017-03-30 | ZN | Futures | 122.537758 | 122.599211 | 122.184401 | 122.261218 | 1058234.0 |
| 2017-03-30 | A6 | Futures | 0.78605 | 0.78728 | 0.78317 | 0.78522 | 66214.0 |
| 2017-03-30 | AD | Futures | 0.76594 | 0.769 | 0.76467 | 0.76681 | 62726.0 |
| 2017-03-30 | ALI | Futures | 2617.67 | 2617.67 | 2617.67 | 2617.67 | 0.0 |
| 2017-03-30 | B | Futures | 38.1 | 38.63 | 37.84 | 38.53 | 439028.0 |
| 2017-03-30 | B6 | Futures | 1.3063 | 1.3154 | 1.3027 | 1.3106 | 108018.0 |
| 2017-03-30 | BR | Futures | 0.22817 | 0.22832 | 0.22756 | 0.22796 | 41.0 |
| 2017-03-30 | BZ | Futures | 38.01 | 38.52 | 37.74 | 38.42 | 33993.0 |
| 2017-03-30 | C | Futures | 1750.0 | 1759.0 | 1720.0 | 1746.0 | 13321.0 |
| 2017-03-30 | CB | Futures | 262.424 | 263.645 | 262.424 | 263.614 | 18.0 |
| 2017-03-30 | CC | Futures | 1587.0 | 1617.0 | 1569.0 | 1600.0 | 17453.0 |
| 2017-03-30 | CSC | Futures | 3.632 | 3.677 | 3.621 | 3.652 | 134.0 |
| 2017-03-30 | CT | Futures | 84.88 | 85.31 | 84.82 | 84.97 | 13991.0 |
| 2017-03-30 | DC | Futures | 29.9 | 30.44 | 29.85 | 30.22 | 283.0 |
| 2017-03-30 | DX | Futures | 93.027 | 93.6 | 92.975 | 93.432 | 28862.0 |
| 2017-03-30 | E1 | Futures | 1.24626 | 1.24762 | 1.23959 | 1.24132 | 22997.0 |
| 2017-03-30 | E6 | Futures | 1.24511 | 1.24511 | 1.23365 | 1.23578 | 199350.0 |
| 2017-03-30 | E7 | Futures | 1.2386 | 1.2386 | 1.2274 | 1.2295 | 3199.0 |
| 2017-03-30 | EBM | Futures | 186.22 | 186.22 | 183.14 | 183.42 | 28463.0 |
| 2017-03-30 | ED | Futures | 95.5639 | 95.5688 | 95.5542 | 95.5639 | 213840.0 |
| 2017-03-30 | ER | Futures | 98.323 | 98.328 | 98.323 | 98.328 | 43050.0 |
| 2017-03-30 | EW | Futures | 1814.8 | 1827.2 | 1812.2 | 1826.1 | 9894.0 |
| 2017-03-30 | FBON | Futures | 121.91 | 122.0 | 121.56 | 122.0 | 729.0 |
| 2017-03-30 | FBTP | Futures | 104.83 | 105.07 | 104.66 | 104.95 | 132383.0 |
| 2017-03-30 | FBTS | Futures | 101.809 | 101.864 | 101.809 | 101.836 | 38896.0 |
| 2017-03-30 | FCE | Futures | 4468.5 | 4487.9 | 4461.5 | 4485.3 | 56935.0 |
| 2017-03-30 | FDAX | Futures | 12915.5 | 12970.4 | 12904.4 | 12964.6 | 57849.0 |
| 2017-03-30 | FDXM | Futures | 12802.1 | 12855.4 | 12790.5 | 12850.7 | 17062.0 |
| 2017-03-30 | FESX | Futures | 2776.1 | 2785.9 | 2768.8 | 2784.3 | 624112.0 |
| 2017-03-30 | FGBL | Futures | 148.11 | 148.49 | 148.02 | 148.37 | 703930.0 |
| 2017-03-30 | FGBM | Futures | 129.24 | 129.4 | 129.22 | 129.33 | 452150.0 |
| 2017-03-30 | FGBS | Futures | 112.287 | 112.337 | 112.282 | 112.307 | 222993.0 |
| 2017-03-30 | FGBX | Futures | 168.09 | 168.85 | 167.83 | 168.51 | 36371.0 |
| 2017-03-30 | FMWO | Futures | 6227.8 | 6247.1 | 6218.2 | 6247.1 | 323.0 |
| 2017-03-30 | FOAT | Futures | 131.94 | 132.23 | 131.8 | 131.97 | 101174.0 |
| 2017-03-30 | FTDX | Futures | 1986.2 | 2001.4 | 1986.2 | 2000.4 | 155.0 |
| 2017-03-30 | FTI | Futures | 465.61 | 468.07 | 465.29 | 467.75 | 18189.0 |
| 2017-03-30 | FTUK | Futures | 6249.7 | 6261.7 | 6220.2 | 6247.1 | 72456.0 |
| 2017-03-30 | FVSA | Futures | 637.78 | 648.87 | 637.78 | 640.55 | 8551.0 |
| 2017-03-30 | FXXP | Futures | 314.4 | 316.2 | 314.3 | 316.1 | 27126.0 |
| 2017-03-30 | G | Futures | 114.88 | 115.21 | 114.88 | 115.17 | 158256.0 |
| 2017-03-30 | GF | Futures | 308.864 | 309.037 | 304.828 | 305.693 | 2251.0 |
| 2017-03-30 | GSCI | Futures | 491.79 | 493.44 | 491.28 | 493.19 | 337.0 |
| 2017-03-30 | HE | Futures | 82.992 | 84.546 | 82.962 | 84.277 | 289.0 |
| 2017-03-30 | HG | Futures | 3.2926 | 3.3468 | 3.2686 | 3.2907 | 90782.0 |
> showing 50 of 107 rows — these rows as CSV