PREVIEW / futures_daily / 2016-01-20
file: by_date/futures_daily/2016/2016-01-20.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-01-20 | ES | Futures | 1999.28 | 2006.49 | 1927.19 | 1981.39 | 3929776.0 |
| 2016-01-20 | NQ | Futures | 4854.53 | 4890.28 | 4669.89 | 4845.15 | 628240.0 |
| 2016-01-20 | YM | Futures | 16440.9 | 16493.7 | 15899.7 | 16264.0 | 373958.0 |
| 2016-01-20 | CL | Futures | 42.45 | 42.86 | 39.7 | 40.84 | 690039.0 |
| 2016-01-20 | GC | Futures | 1402.3 | 1431.4 | 1402.0 | 1426.7 | 193281.0 |
| 2016-01-20 | ZN | Futures | 123.476285 | 124.423904 | 123.461244 | 124.062907 | 1996094.0 |
| 2016-01-20 | A6 | Futures | 0.69027 | 0.69208 | 0.68246 | 0.68947 | 150309.0 |
| 2016-01-20 | AD | Futures | 0.70171 | 0.70632 | 0.69619 | 0.70509 | 143358.0 |
| 2016-01-20 | ALI | Futures | 2058.86 | 2058.86 | 2058.86 | 2058.86 | 0.0 |
| 2016-01-20 | B | Futures | 24.7 | 24.78 | 23.35 | 24.03 | 375397.0 |
| 2016-01-20 | B6 | Futures | 1.4904 | 1.4962 | 1.4863 | 1.4892 | 104905.0 |
| 2016-01-20 | BFX | Futures | 3970.0 | 3970.0 | 3950.7 | 3950.7 | 4.0 |
| 2016-01-20 | BR | Futures | 0.15171 | 0.15277 | 0.15057 | 0.15079 | 27.0 |
| 2016-01-20 | BZ | Futures | 24.68 | 24.7 | 23.12 | 23.77 | 39000.0 |
| 2016-01-20 | C | Futures | 2242.0 | 2245.0 | 2146.0 | 2162.0 | 16275.0 |
| 2016-01-20 | CB | Futures | 265.637 | 271.203 | 265.637 | 269.626 | 71.0 |
| 2016-01-20 | CC | Futures | 2148.0 | 2148.0 | 2055.0 | 2072.0 | 37880.0 |
| 2016-01-20 | CNH | Futures | 7.317 | 7.3243 | 7.3054 | 7.319 | 41.0 |
| 2016-01-20 | CSC | Futures | 3.726 | 3.726 | 3.689 | 3.699 | 96.0 |
| 2016-01-20 | CT | Futures | 73.15 | 73.16 | 72.06 | 72.59 | 16553.0 |
| 2016-01-20 | DC | Futures | 29.48 | 29.57 | 29.08 | 29.27 | 124.0 |
| 2016-01-20 | DX | Futures | 92.551 | 92.723 | 92.182 | 92.643 | 33763.0 |
| 2016-01-20 | E1 | Futures | 1.26084 | 1.26627 | 1.25781 | 1.2592 | 21842.0 |
| 2016-01-20 | E6 | Futures | 1.27789 | 1.28519 | 1.27356 | 1.27525 | 201616.0 |
| 2016-01-20 | E7 | Futures | 1.2704 | 1.278 | 1.2665 | 1.2681 | 6957.0 |
| 2016-01-20 | EBM | Futures | 232.36 | 232.71 | 230.59 | 230.95 | 22463.0 |
| 2016-01-20 | ED | Futures | 95.5976 | 95.6313 | 95.5976 | 95.6169 | 400701.0 |
| 2016-01-20 | ER | Futures | 98.234 | 98.254 | 98.234 | 98.249 | 86100.0 |
| 2016-01-20 | EW | Futures | 1328.2 | 1334.7 | 1277.0 | 1323.8 | 41248.0 |
| 2016-01-20 | FBON | Futures | 116.07 | 116.38 | 115.12 | 115.14 | 1426.0 |
| 2016-01-20 | FBTP | Futures | 105.09 | 105.51 | 104.07 | 104.39 | 208223.0 |
| 2016-01-20 | FBTS | Futures | 100.864 | 100.873 | 100.713 | 100.757 | 52905.0 |
| 2016-01-20 | FCE | Futures | 3492.5 | 3510.1 | 3407.7 | 3457.2 | 156596.0 |
| 2016-01-20 | FDAX | Futures | 10182.8 | 10321.0 | 10032.1 | 10147.0 | 161395.0 |
| 2016-01-20 | FDXM | Futures | 9733.6 | 9868.4 | 9594.7 | 9703.6 | 36822.0 |
| 2016-01-20 | FESX | Futures | 2197.4 | 2220.2 | 2153.3 | 2180.7 | 2242136.0 |
| 2016-01-20 | FEU3 | Futures | 98.897 | 98.902 | 98.897 | 98.902 | 1.0 |
| 2016-01-20 | FGBL | Futures | 141.51 | 142.2 | 141.51 | 142.02 | 947225.0 |
| 2016-01-20 | FGBM | Futures | 126.32 | 126.5 | 126.3 | 126.39 | 493242.0 |
| 2016-01-20 | FGBS | Futures | 111.548 | 111.598 | 111.548 | 111.578 | 262263.0 |
| 2016-01-20 | FGBX | Futures | 160.54 | 162.76 | 160.5 | 162.18 | 51755.0 |
| 2016-01-20 | FMWO | Futures | 5023.9 | 5028.9 | 4962.8 | 4970.3 | 683.0 |
| 2016-01-20 | FOAT | Futures | 128.99 | 129.57 | 128.89 | 129.2 | 141455.0 |
| 2016-01-20 | FTDX | Futures | 1543.8 | 1549.6 | 1513.1 | 1528.0 | 865.0 |
| 2016-01-20 | FTI | Futures | 350.61 | 353.89 | 343.75 | 348.62 | 49873.0 |
| 2016-01-20 | FTUK | Futures | 4716.6 | 4720.6 | 4523.2 | 4571.4 | 178161.0 |
| 2016-01-20 | FVSA | Futures | 3032.54 | 3217.09 | 2992.64 | 3177.19 | 23401.0 |
| 2016-01-20 | FXXP | Futures | 254.6 | 256.0 | 248.9 | 251.7 | 66123.0 |
| 2016-01-20 | G | Futures | 106.55 | 106.94 | 106.47 | 106.8 | 237979.0 |
| 2016-01-20 | GF | Futures | 294.529 | 298.849 | 290.16 | 293.989 | 6588.0 |
> showing 50 of 110 rows — these rows as CSV