PREVIEW / futures_daily / 2016-12-23
file: by_date/futures_daily/2016/2016-12-23.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-12-23 | ES | Futures | 2447.36 | 2451.15 | 2443.83 | 2450.07 | 396535.0 |
| 2016-12-23 | NQ | Futures | 5814.96 | 5826.74 | 5801.99 | 5824.98 | 69061.0 |
| 2016-12-23 | YM | Futures | 20925.9 | 20950.1 | 20902.7 | 20933.2 | 42113.0 |
| 2016-12-23 | CL | Futures | 56.38 | 57.02 | 55.93 | 56.74 | 285166.0 |
| 2016-12-23 | GC | Futures | 1451.1 | 1460.5 | 1450.5 | 1455.8 | 74795.0 |
| 2016-12-23 | ZN | Futures | 120.559954 | 120.758621 | 120.498826 | 120.651647 | 287288.0 |
| 2016-12-23 | A6 | Futures | 0.73736 | 0.73879 | 0.73183 | 0.73285 | 55361.0 |
| 2016-12-23 | AD | Futures | 0.75799 | 0.75855 | 0.75304 | 0.75523 | 44081.0 |
| 2016-12-23 | ALI | Futures | 2355.87 | 2355.87 | 2355.87 | 2355.87 | 0.0 |
| 2016-12-23 | B | Futures | 40.86 | 41.16 | 40.42 | 41.09 | 104088.0 |
| 2016-12-23 | B6 | Futures | 1.2913 | 1.2929 | 1.2855 | 1.2901 | 58061.0 |
| 2016-12-23 | BFX | Futures | 4305.5 | 4308.5 | 4305.5 | 4308.5 | 10.0 |
| 2016-12-23 | BR | Futures | 0.21376 | 0.21376 | 0.21376 | 0.21376 | 12.0 |
| 2016-12-23 | BZ | Futures | 40.58 | 40.92 | 40.13 | 40.79 | 15503.0 |
| 2016-12-23 | C | Futures | 1870.0 | 1885.0 | 1856.0 | 1883.0 | 2151.0 |
| 2016-12-23 | CB | Futures | 280.672 | 280.733 | 279.085 | 280.702 | 20.0 |
| 2016-12-23 | CC | Futures | 1666.0 | 1726.0 | 1660.0 | 1724.0 | 11098.0 |
| 2016-12-23 | CNH | Futures | 7.4594 | 7.4663 | 7.4594 | 7.4595 | 31.0 |
| 2016-12-23 | CSC | Futures | 4.034 | 4.034 | 4.006 | 4.013 | 3.0 |
| 2016-12-23 | CT | Futures | 80.63 | 81.03 | 80.24 | 80.26 | 7123.0 |
| 2016-12-23 | DC | Futures | 32.98 | 33.07 | 32.96 | 33.03 | 51.0 |
| 2016-12-23 | DX | Futures | 95.99 | 96.093 | 95.772 | 95.904 | 11978.0 |
| 2016-12-23 | E1 | Futures | 1.21422 | 1.21632 | 1.21186 | 1.21298 | 7876.0 |
| 2016-12-23 | E6 | Futures | 1.21034 | 1.21445 | 1.20948 | 1.21179 | 71023.0 |
| 2016-12-23 | E7 | Futures | 1.2044 | 1.208 | 1.2034 | 1.2055 | 1747.0 |
| 2016-12-23 | EBM | Futures | 190.28 | 190.28 | 188.58 | 188.86 | 8448.0 |
| 2016-12-23 | ED | Futures | 95.5713 | 95.5762 | 95.5713 | 95.5713 | 33523.0 |
| 2016-12-23 | ER | Futures | 98.283 | 98.283 | 98.279 | 98.283 | 19920.0 |
| 2016-12-23 | EW | Futures | 1777.9 | 1782.2 | 1776.1 | 1780.5 | 7326.0 |
| 2016-12-23 | FBON | Futures | 122.78 | 122.87 | 122.55 | 122.81 | 237.0 |
| 2016-12-23 | FBTP | Futures | 106.78 | 107.08 | 106.73 | 107.04 | 28641.0 |
| 2016-12-23 | FBTS | Futures | 101.891 | 101.936 | 101.873 | 101.909 | 7559.0 |
| 2016-12-23 | FCE | Futures | 4252.4 | 4262.9 | 4244.5 | 4257.2 | 30908.0 |
| 2016-12-23 | FDAX | Futures | 12099.5 | 12125.9 | 12040.4 | 12084.2 | 35970.0 |
| 2016-12-23 | FDXM | Futures | 12049.7 | 12077.0 | 11990.8 | 12035.5 | 6705.0 |
| 2016-12-23 | FESX | Futures | 2607.9 | 2615.9 | 2603.1 | 2610.3 | 334565.0 |
| 2016-12-23 | FEU3 | Futures | 98.956 | 98.956 | 98.952 | 98.952 | 2.0 |
| 2016-12-23 | FGBL | Futures | 147.21 | 147.71 | 147.15 | 147.6 | 166237.0 |
| 2016-12-23 | FGBM | Futures | 128.9 | 129.12 | 128.9 | 128.99 | 100801.0 |
| 2016-12-23 | FGBS | Futures | 112.162 | 112.172 | 112.152 | 112.162 | 54350.0 |
| 2016-12-23 | FGBX | Futures | 170.86 | 172.66 | 170.68 | 172.3 | 11862.0 |
| 2016-12-23 | FMWO | Futures | 5881.6 | 5882.8 | 5873.1 | 5873.1 | 339.0 |
| 2016-12-23 | FOAT | Futures | 133.47 | 133.81 | 133.38 | 133.67 | 21957.0 |
| 2016-12-23 | FTDX | Futures | 1745.0 | 1757.8 | 1743.5 | 1755.3 | 272.0 |
| 2016-12-23 | FTI | Futures | 438.83 | 440.01 | 438.6 | 439.28 | 10813.0 |
| 2016-12-23 | FTUK | Futures | 5925.7 | 5943.1 | 5922.3 | 5938.9 | 18551.0 |
| 2016-12-23 | FVSA | Futures | 1046.87 | 1057.84 | 1038.65 | 1052.35 | 9170.0 |
| 2016-12-23 | FXXP | Futures | 297.3 | 297.8 | 296.4 | 297.3 | 8136.0 |
| 2016-12-23 | G | Futures | 111.0 | 111.48 | 110.98 | 111.4 | 28049.0 |
| 2016-12-23 | GF | Futures | 291.844 | 293.183 | 288.721 | 291.621 | 2759.0 |
> showing 50 of 110 rows — these rows as CSV