PREVIEW / futures_daily / 2015-01-14
file: by_date/futures_daily/2015/2015-01-14.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-01-14 | ES | Futures | 2114.34 | 2116.69 | 2076.6 | 2104.12 | 2516599.0 |
| 2015-01-14 | NQ | Futures | 4824.49 | 4837.55 | 4757.78 | 4809.99 | 450812.0 |
| 2015-01-14 | YM | Futures | 17866.1 | 17892.6 | 17500.5 | 17685.8 | 328082.0 |
| 2015-01-14 | CL | Futures | 89.88 | 94.91 | 87.73 | 94.09 | 300679.0 |
| 2015-01-14 | GC | Futures | 1611.5 | 1629.1 | 1603.3 | 1615.9 | 193111.0 |
| 2015-01-14 | ZN | Futures | 121.792727 | 122.705474 | 121.733841 | 122.263822 | 1993923.0 |
| 2015-01-14 | A6 | Futures | 0.79621 | 0.79866 | 0.7868 | 0.79454 | 109735.0 |
| 2015-01-14 | AD | Futures | 0.85089 | 0.85262 | 0.84641 | 0.85049 | 68479.0 |
| 2015-01-14 | ALI | Futures | 2778.4 | 2778.4 | 2778.4 | 2778.4 | 0.0 |
| 2015-01-14 | B | Futures | 49.02 | 51.44 | 47.77 | 50.92 | 411296.0 |
| 2015-01-14 | B6 | Futures | 1.5934 | 1.6049 | 1.5917 | 1.5997 | 106646.0 |
| 2015-01-14 | BFX | Futures | 3951.5 | 3984.1 | 3940.7 | 3949.1 | 869.0 |
| 2015-01-14 | BR | Futures | 0.2064 | 0.20924 | 0.2064 | 0.20844 | 249.0 |
| 2015-01-14 | BZ | Futures | 49.29 | 51.69 | 48.01 | 51.2 | 45338.0 |
| 2015-01-14 | C | Futures | 2234.0 | 2241.0 | 2217.0 | 2237.0 | 7526.0 |
| 2015-01-14 | CB | Futures | 133.084 | 133.084 | 133.084 | 133.084 | 16.0 |
| 2015-01-14 | CC | Futures | 2202.0 | 2212.0 | 2182.0 | 2208.0 | 10079.0 |
| 2015-01-14 | CSC | Futures | 4.367 | 4.367 | 4.219 | 4.239 | 232.0 |
| 2015-01-14 | CT | Futures | 76.7 | 76.7 | 74.92 | 75.33 | 23359.0 |
| 2015-01-14 | DC | Futures | 34.08 | 34.08 | 32.47 | 32.56 | 493.0 |
| 2015-01-14 | DX | Futures | 87.52 | 87.686 | 86.895 | 87.411 | 50462.0 |
| 2015-01-14 | E1 | Futures | 1.25368 | 1.26108 | 1.24844 | 1.25355 | 52840.0 |
| 2015-01-14 | E6 | Futures | 1.38586 | 1.39433 | 1.38022 | 1.38586 | 233788.0 |
| 2015-01-14 | E7 | Futures | 1.3778 | 1.3859 | 1.3721 | 1.3776 | 6618.0 |
| 2015-01-14 | EBM | Futures | 313.06 | 313.87 | 311.03 | 311.44 | 20692.0 |
| 2015-01-14 | ED | Futures | 95.4546 | 95.4641 | 95.4498 | 95.4594 | 207689.0 |
| 2015-01-14 | ER | Futures | 98.033 | 98.038 | 98.028 | 98.033 | 34940.0 |
| 2015-01-14 | EW | Futures | 1492.1 | 1495.9 | 1470.4 | 1487.6 | 19959.0 |
| 2015-01-14 | FBTP | Futures | 99.16 | 100.06 | 99.1 | 99.79 | 109326.0 |
| 2015-01-14 | FBTS | Futures | 98.748 | 98.845 | 98.73 | 98.801 | 17041.0 |
| 2015-01-14 | FCE | Futures | 3437.4 | 3509.2 | 3430.0 | 3444.7 | 125075.0 |
| 2015-01-14 | FDAX | Futures | 10864.3 | 11068.0 | 10842.1 | 10918.2 | 176525.0 |
| 2015-01-14 | FESX | Futures | 2211.9 | 2267.4 | 2209.0 | 2226.3 | 1611337.0 |
| 2015-01-14 | FEU3 | Futures | 98.655 | 98.655 | 98.655 | 98.655 | 1.0 |
| 2015-01-14 | FGBL | Futures | 137.42 | 137.82 | 137.32 | 137.69 | 745298.0 |
| 2015-01-14 | FGBM | Futures | 123.95 | 124.03 | 123.91 | 123.97 | 399705.0 |
| 2015-01-14 | FGBS | Futures | 111.013 | 111.023 | 111.003 | 111.008 | 218788.0 |
| 2015-01-14 | FGBX | Futures | 160.7 | 162.21 | 160.58 | 161.55 | 28963.0 |
| 2015-01-14 | FMWO | Futures | 5476.4 | 5495.0 | 5451.7 | 5455.4 | 2345.0 |
| 2015-01-14 | FOAT | Futures | 126.68 | 127.28 | 126.57 | 127.18 | 75638.0 |
| 2015-01-14 | FTDX | Futures | 1332.7 | 1350.1 | 1332.7 | 1338.3 | 157.0 |
| 2015-01-14 | FTI | Futures | 359.53 | 367.01 | 359.53 | 360.91 | 22635.0 |
| 2015-01-14 | FTUK | Futures | 4990.0 | 5005.2 | 4901.9 | 4933.9 | 163629.0 |
| 2015-01-14 | FVSA | Futures | 2152.16 | 2182.29 | 2074.68 | 2156.46 | 15027.0 |
| 2015-01-14 | FXXP | Futures | 256.1 | 259.8 | 254.7 | 255.8 | 15778.0 |
| 2015-01-14 | G | Futures | 104.86 | 105.45 | 104.69 | 105.17 | 203338.0 |
| 2015-01-14 | GF | Futures | 355.444 | 359.577 | 351.058 | 354.432 | 6887.0 |
| 2015-01-14 | GSCI | Futures | 655.04 | 674.6 | 652.36 | 670.2 | 3545.0 |
| 2015-01-14 | HE | Futures | 101.556 | 102.629 | 100.818 | 101.992 | 29358.0 |
| 2015-01-14 | HG | Futures | 3.3142 | 3.3243 | 3.0785 | 3.1827 | 124429.0 |
> showing 50 of 106 rows — these rows as CSV