PREVIEW / futures_daily / 2014-12-16
file: by_date/futures_daily/2014/2014-12-16.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 |
|---|---|---|---|---|---|---|---|
| 2014-12-16 | ES | Futures | 2080.01 | 2108.05 | 2055.9 | 2059.57 | 3365454.0 |
| 2014-12-16 | NQ | Futures | 4829.42 | 4861.33 | 4734.86 | 4737.76 | 639787.0 |
| 2014-12-16 | YM | Futures | 17463.8 | 17687.9 | 17287.6 | 17321.2 | 333975.0 |
| 2014-12-16 | CL | Futures | 109.25 | 112.5 | 105.64 | 110.19 | 292441.0 |
| 2014-12-16 | GC | Futures | 1564.7 | 1602.0 | 1554.7 | 1563.2 | 231509.0 |
| 2014-12-16 | ZN | Futures | 119.92307 | 120.968312 | 119.908348 | 120.261669 | 1460070.0 |
| 2014-12-16 | A6 | Futures | 0.79895 | 0.80522 | 0.79787 | 0.79905 | 81077.0 |
| 2014-12-16 | AD | Futures | 0.87157 | 0.87564 | 0.87137 | 0.8734 | 65768.0 |
| 2014-12-16 | ALI | Futures | 2894.22 | 2894.22 | 2894.22 | 2894.22 | 6.0 |
| 2014-12-16 | B | Futures | 62.89 | 63.29 | 60.45 | 62.01 | 351493.0 |
| 2014-12-16 | B6 | Futures | 1.6437 | 1.6588 | 1.6403 | 1.6528 | 117755.0 |
| 2014-12-16 | BFX | Futures | 3800.3 | 3849.6 | 3743.3 | 3849.6 | 789.0 |
| 2014-12-16 | BR | Futures | 0.19732 | 0.1987 | 0.19674 | 0.1974 | 615.0 |
| 2014-12-16 | BZ | Futures | 63.44 | 63.83 | 61.03 | 62.56 | 20873.0 |
| 2014-12-16 | C | Futures | 2083.0 | 2108.0 | 2081.0 | 2105.0 | 7235.0 |
| 2014-12-16 | CB | Futures | 135.549 | 135.549 | 134.337 | 135.056 | 49.0 |
| 2014-12-16 | CC | Futures | 2133.0 | 2159.0 | 2129.0 | 2150.0 | 11458.0 |
| 2014-12-16 | CNH | Futures | 7.1155 | 7.1155 | 7.1045 | 7.1068 | 14.0 |
| 2014-12-16 | CSC | Futures | 4.484 | 4.529 | 4.467 | 4.478 | 143.0 |
| 2014-12-16 | CT | Futures | 77.36 | 77.64 | 76.26 | 76.35 | 12458.0 |
| 2014-12-16 | DC | Futures | 34.85 | 35.3 | 34.45 | 34.6 | 316.0 |
| 2014-12-16 | DX | Futures | 83.942 | 83.994 | 83.137 | 83.579 | 56867.0 |
| 2014-12-16 | E1 | Futures | 1.32429 | 1.33796 | 1.32365 | 1.32914 | 78123.0 |
| 2014-12-16 | E6 | Futures | 1.46455 | 1.47961 | 1.46361 | 1.46973 | 204489.0 |
| 2014-12-16 | E7 | Futures | 1.4556 | 1.4707 | 1.4549 | 1.461 | 6303.0 |
| 2014-12-16 | EBM | Futures | 309.81 | 320.76 | 309.41 | 317.52 | 41147.0 |
| 2014-12-16 | ED | Futures | 95.4306 | 95.445 | 95.4259 | 95.4306 | 263956.0 |
| 2014-12-16 | ER | Futures | 97.999 | 98.004 | 97.984 | 97.994 | 76754.0 |
| 2014-12-16 | EW | Futures | 1454.3 | 1468.4 | 1436.3 | 1447.5 | 49036.0 |
| 2014-12-16 | FBTP | Futures | 97.81 | 97.99 | 96.99 | 97.77 | 97547.0 |
| 2014-12-16 | FBTS | Futures | 98.322 | 98.366 | 98.163 | 98.349 | 21549.0 |
| 2014-12-16 | FCE | Futures | 3280.3 | 3348.0 | 3205.6 | 3344.4 | 137139.0 |
| 2014-12-16 | FDAX | Futures | 10257.2 | 10491.7 | 10096.2 | 10477.4 | 327537.0 |
| 2014-12-16 | FESX | Futures | 2149.9 | 2196.1 | 2099.5 | 2194.6 | 1854132.0 |
| 2014-12-16 | FGBL | Futures | 135.38 | 136.1 | 135.3 | 135.74 | 846551.0 |
| 2014-12-16 | FGBM | Futures | 123.39 | 123.64 | 123.39 | 123.47 | 406174.0 |
| 2014-12-16 | FGBS | Futures | 110.903 | 110.948 | 110.893 | 110.908 | 310856.0 |
| 2014-12-16 | FGBX | Futures | 153.43 | 155.83 | 153.11 | 154.77 | 41690.0 |
| 2014-12-16 | FMWO | Futures | 5530.7 | 5583.4 | 5460.5 | 5580.9 | 1131.0 |
| 2014-12-16 | FOAT | Futures | 124.87 | 125.35 | 124.8 | 125.19 | 79524.0 |
| 2014-12-16 | FTDX | Futures | 1224.8 | 1229.0 | 1204.6 | 1229.0 | 586.0 |
| 2014-12-16 | FTI | Futures | 343.38 | 350.48 | 337.15 | 350.09 | 30628.0 |
| 2014-12-16 | FTUK | Futures | 4810.3 | 4906.6 | 4744.5 | 4887.5 | 169804.0 |
| 2014-12-16 | FVSA | Futures | 1881.55 | 1994.06 | 1776.81 | 1784.57 | 21101.0 |
| 2014-12-16 | FXXP | Futures | 243.6 | 248.3 | 240.2 | 247.8 | 38687.0 |
| 2014-12-16 | G | Futures | 102.42 | 103.52 | 102.42 | 102.84 | 205481.0 |
| 2014-12-16 | GF | Futures | 352.346 | 352.346 | 352.346 | 352.346 | 879.0 |
| 2014-12-16 | GSCI | Futures | 737.74 | 752.23 | 735.44 | 742.43 | 344.0 |
| 2014-12-16 | HE | Futures | 111.249 | 112.49 | 107.694 | 109.572 | 14412.0 |
| 2014-12-16 | HG | Futures | 3.6489 | 3.6661 | 3.6127 | 3.6311 | 49922.0 |
> showing 50 of 106 rows — these rows as CSV