PREVIEW / futures_daily / 2015-12-17
file: by_date/futures_daily/2015/2015-12-17.parquet size: 9 KB rows: 109
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-12-17 | ES | Futures | 2201.16 | 2213.98 | 2160.57 | 2162.71 | 2114912.0 |
| 2015-12-17 | NQ | Futures | 5451.52 | 5490.8 | 5351.29 | 5356.86 | 320692.0 |
| 2015-12-17 | YM | Futures | 18240.4 | 18352.2 | 17944.5 | 17960.0 | 197411.0 |
| 2015-12-17 | CL | Futures | 55.1 | 55.15 | 53.48 | 53.94 | 292565.0 |
| 2015-12-17 | GC | Futures | 1382.8 | 1383.4 | 1350.0 | 1353.7 | 168666.0 |
| 2015-12-17 | ZN | Futures | 120.994425 | 121.566005 | 120.964342 | 121.41559 | 981541.0 |
| 2015-12-17 | A6 | Futures | 0.71883 | 0.71973 | 0.70791 | 0.70961 | 88603.0 |
| 2015-12-17 | AD | Futures | 0.742 | 0.7421 | 0.73106 | 0.73259 | 70746.0 |
| 2015-12-17 | ALI | Futures | 2109.18 | 2109.18 | 2109.18 | 2109.18 | 0.0 |
| 2015-12-17 | B | Futures | 32.77 | 33.06 | 32.03 | 32.3 | 200845.0 |
| 2015-12-17 | B6 | Futures | 1.5768 | 1.5804 | 1.5643 | 1.5666 | 102976.0 |
| 2015-12-17 | BFX | Futures | 4498.1 | 4498.1 | 4466.5 | 4466.5 | 39.0 |
| 2015-12-17 | BR | Futures | 0.15843 | 0.15868 | 0.1574 | 0.1578 | 608.0 |
| 2015-12-17 | BZ | Futures | 32.52 | 32.76 | 31.75 | 32.01 | 24297.0 |
| 2015-12-17 | C | Futures | 2388.0 | 2391.0 | 2363.0 | 2380.0 | 9483.0 |
| 2015-12-17 | CB | Futures | 249.618 | 249.866 | 247.423 | 249.866 | 28.0 |
| 2015-12-17 | CC | Futures | 2431.0 | 2432.0 | 2380.0 | 2398.0 | 19811.0 |
| 2015-12-17 | CNH | Futures | 7.2633 | 7.2909 | 7.2633 | 7.2909 | 8.0 |
| 2015-12-17 | CSC | Futures | 3.861 | 3.895 | 3.853 | 3.875 | 126.0 |
| 2015-12-17 | CT | Futures | 74.09 | 74.32 | 73.64 | 73.78 | 12729.0 |
| 2015-12-17 | DC | Futures | 30.64 | 30.86 | 30.49 | 30.86 | 172.0 |
| 2015-12-17 | DX | Futures | 92.158 | 92.803 | 92.149 | 92.779 | 30971.0 |
| 2015-12-17 | E1 | Futures | 1.27965 | 1.27965 | 1.26867 | 1.27069 | 18880.0 |
| 2015-12-17 | E6 | Futures | 1.27713 | 1.27713 | 1.26613 | 1.26637 | 225946.0 |
| 2015-12-17 | E7 | Futures | 1.2697 | 1.27 | 1.259 | 1.2593 | 5518.0 |
| 2015-12-17 | EBM | Futures | 247.9 | 248.6 | 245.78 | 247.19 | 19537.0 |
| 2015-12-17 | ED | Futures | 95.6025 | 95.6073 | 95.5688 | 95.5832 | 508073.0 |
| 2015-12-17 | ER | Futures | 98.215 | 98.22 | 98.21 | 98.215 | 40535.0 |
| 2015-12-17 | EW | Futures | 1482.3 | 1490.4 | 1459.3 | 1460.2 | 22701.0 |
| 2015-12-17 | FBON | Futures | 115.64 | 115.76 | 115.33 | 115.46 | 645.0 |
| 2015-12-17 | FBTP | Futures | 103.91 | 104.51 | 103.88 | 104.39 | 78141.0 |
| 2015-12-17 | FBTS | Futures | 100.517 | 100.579 | 100.508 | 100.543 | 20113.0 |
| 2015-12-17 | FCE | Futures | 3918.3 | 3965.9 | 3898.2 | 3905.7 | 50740.0 |
| 2015-12-17 | FDAX | Futures | 11523.6 | 11751.9 | 11416.3 | 11665.7 | 65678.0 |
| 2015-12-17 | FDIV | Futures | 139.92 | 139.92 | 139.6 | 139.6 | 1.0 |
| 2015-12-17 | FDXM | Futures | 11016.2 | 11233.9 | 10955.0 | 11154.1 | 2620.0 |
| 2015-12-17 | FESX | Futures | 2507.6 | 2538.0 | 2489.4 | 2510.7 | 1021297.0 |
| 2015-12-17 | FGBL | Futures | 138.92 | 139.7 | 138.83 | 139.55 | 551669.0 |
| 2015-12-17 | FGBM | Futures | 125.42 | 125.66 | 125.38 | 125.6 | 344171.0 |
| 2015-12-17 | FGBS | Futures | 111.403 | 111.453 | 111.403 | 111.433 | 177136.0 |
| 2015-12-17 | FGBX | Futures | 156.45 | 158.34 | 156.43 | 157.97 | 30550.0 |
| 2015-12-17 | FMWO | Futures | 5626.1 | 5629.8 | 5550.7 | 5555.6 | 765.0 |
| 2015-12-17 | FOAT | Futures | 127.39 | 128.12 | 127.32 | 127.89 | 61318.0 |
| 2015-12-17 | FTDX | Futures | 1736.7 | 1758.8 | 1736.7 | 1744.9 | 723.0 |
| 2015-12-17 | FTI | Futures | 384.75 | 388.59 | 382.26 | 383.7 | 13609.0 |
| 2015-12-17 | FTUK | Futures | 4957.6 | 4991.4 | 4927.8 | 4948.6 | 110252.0 |
| 2015-12-17 | FVSA | Futures | 2225.66 | 2277.42 | 2112.73 | 2249.19 | 14635.0 |
| 2015-12-17 | FXXP | Futures | 287.3 | 289.2 | 285.6 | 286.7 | 42566.0 |
| 2015-12-17 | G | Futures | 104.17 | 104.89 | 104.13 | 104.74 | 187396.0 |
| 2015-12-17 | GF | Futures | 284.522 | 285.053 | 276.415 | 278.442 | 5561.0 |
> showing 50 of 109 rows — these rows as CSV