PREVIEW / futures_daily / 2015-09-29
file: by_date/futures_daily/2015/2015-09-29.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 |
|---|---|---|---|---|---|---|---|
| 2015-09-29 | ES | Futures | 1995.86 | 2010.22 | 1979.64 | 1994.0 | 2374651.0 |
| 2015-09-29 | NQ | Futures | 4801.06 | 4845.49 | 4724.48 | 4764.23 | 427261.0 |
| 2015-09-29 | YM | Futures | 16440.3 | 16522.9 | 16301.1 | 16455.8 | 259916.0 |
| 2015-09-29 | CL | Futures | 71.47 | 73.4 | 71.15 | 72.65 | 265176.0 |
| 2015-09-29 | GC | Futures | 1460.5 | 1464.3 | 1450.3 | 1454.6 | 105548.0 |
| 2015-09-29 | ZN | Futures | 123.003035 | 123.467028 | 122.868327 | 123.39219 | 1357240.0 |
| 2015-09-29 | A6 | Futures | 0.69553 | 0.69973 | 0.69093 | 0.69563 | 80696.0 |
| 2015-09-29 | AD | Futures | 0.76421 | 0.76564 | 0.76083 | 0.76267 | 59664.0 |
| 2015-09-29 | ALI | Futures | 2118.08 | 2118.08 | 2118.08 | 2118.08 | 0.0 |
| 2015-09-29 | B | Futures | 42.88 | 44.11 | 42.88 | 43.74 | 123699.0 |
| 2015-09-29 | B6 | Futures | 1.597 | 1.6007 | 1.5927 | 1.5957 | 75278.0 |
| 2015-09-29 | BFX | Futures | 4007.2 | 4007.2 | 3972.8 | 3972.8 | 1.0 |
| 2015-09-29 | BR | Futures | 0.14625 | 0.14924 | 0.14542 | 0.14865 | 642.0 |
| 2015-09-29 | BZ | Futures | 42.73 | 43.86 | 42.72 | 43.49 | 15002.0 |
| 2015-09-29 | C | Futures | 2362.0 | 2364.0 | 2314.0 | 2323.0 | 12882.0 |
| 2015-09-29 | CB | Futures | 190.918 | 190.918 | 183.586 | 186.982 | 17.0 |
| 2015-09-29 | CC | Futures | 2378.0 | 2383.0 | 2325.0 | 2333.0 | 23772.0 |
| 2015-09-29 | CNH | Futures | 7.1239 | 7.1453 | 7.0992 | 7.1043 | 92.0 |
| 2015-09-29 | CSC | Futures | 4.271 | 4.317 | 4.253 | 4.286 | 115.0 |
| 2015-09-29 | CT | Futures | 72.86 | 73.48 | 72.64 | 73.18 | 8716.0 |
| 2015-09-29 | DC | Futures | 34.57 | 34.83 | 34.32 | 34.63 | 167.0 |
| 2015-09-29 | DX | Futures | 89.963 | 90.145 | 89.621 | 89.778 | 28185.0 |
| 2015-09-29 | E1 | Futures | 1.30624 | 1.31284 | 1.30459 | 1.31017 | 14170.0 |
| 2015-09-29 | E6 | Futures | 1.31857 | 1.32314 | 1.31283 | 1.32044 | 209876.0 |
| 2015-09-29 | E7 | Futures | 1.3107 | 1.3156 | 1.3056 | 1.3132 | 4158.0 |
| 2015-09-29 | EBM | Futures | 255.76 | 256.86 | 253.57 | 253.94 | 18105.0 |
| 2015-09-29 | ED | Futures | 95.7159 | 95.7256 | 95.7063 | 95.7256 | 151967.0 |
| 2015-09-29 | ER | Futures | 98.136 | 98.141 | 98.131 | 98.141 | 26311.0 |
| 2015-09-29 | EW | Futures | 1420.4 | 1429.9 | 1410.7 | 1417.2 | 30621.0 |
| 2015-09-29 | FBTP | Futures | 102.41 | 102.65 | 102.15 | 102.49 | 113534.0 |
| 2015-09-29 | FBTS | Futures | 100.275 | 100.293 | 100.248 | 100.266 | 15936.0 |
| 2015-09-29 | FCE | Futures | 3586.2 | 3644.1 | 3557.1 | 3615.0 | 116868.0 |
| 2015-09-29 | FDAX | Futures | 10374.9 | 10505.9 | 10243.8 | 10426.1 | 146882.0 |
| 2015-09-29 | FESX | Futures | 2247.6 | 2285.1 | 2225.9 | 2267.9 | 1432174.0 |
| 2015-09-29 | FEU3 | Futures | 98.789 | 98.789 | 98.789 | 98.789 | 4.0 |
| 2015-09-29 | FGBL | Futures | 139.13 | 139.29 | 138.69 | 138.96 | 637692.0 |
| 2015-09-29 | FGBM | Futures | 125.26 | 125.3 | 125.14 | 125.19 | 397887.0 |
| 2015-09-29 | FGBS | Futures | 111.308 | 111.313 | 111.288 | 111.293 | 249978.0 |
| 2015-09-29 | FGBX | Futures | 159.57 | 159.96 | 158.14 | 158.96 | 26114.0 |
| 2015-09-29 | FMWO | Futures | 5187.2 | 5203.3 | 5174.9 | 5183.5 | 793.0 |
| 2015-09-29 | FOAT | Futures | 127.04 | 127.14 | 126.59 | 126.88 | 64490.0 |
| 2015-09-29 | FTDX | Futures | 1617.7 | 1627.7 | 1596.4 | 1625.3 | 179.0 |
| 2015-09-29 | FTI | Futures | 354.1 | 360.36 | 351.02 | 358.23 | 39329.0 |
| 2015-09-29 | FTUK | Futures | 4715.6 | 4761.0 | 4695.9 | 4736.1 | 120342.0 |
| 2015-09-29 | FVSA | Futures | 2732.45 | 2815.67 | 2686.22 | 2727.83 | 13159.0 |
| 2015-09-29 | FXXP | Futures | 262.3 | 265.9 | 260.2 | 263.9 | 33971.0 |
| 2015-09-29 | G | Futures | 105.42 | 105.57 | 105.09 | 105.4 | 200643.0 |
| 2015-09-29 | GF | Futures | 328.342 | 328.475 | 320.974 | 321.063 | 3647.0 |
| 2015-09-29 | GSCI | Futures | 584.75 | 586.63 | 584.75 | 585.33 | 270.0 |
| 2015-09-29 | HE | Futures | 98.413 | 100.619 | 98.413 | 100.282 | 12589.0 |
> showing 50 of 107 rows — these rows as CSV