PREVIEW / futures_daily / 2015-12-31
file: by_date/futures_daily/2015/2015-12-31.parquet size: 9 KB rows: 91
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-31 | ES | Futures | 2195.29 | 2197.96 | 2168.58 | 2174.19 | 1029390.0 |
| 2015-12-31 | NQ | Futures | 5448.89 | 5457.09 | 5368.58 | 5378.25 | 160705.0 |
| 2015-12-31 | YM | Futures | 18127.6 | 18146.3 | 17900.0 | 17944.5 | 80554.0 |
| 2015-12-31 | CL | Futures | 54.75 | 56.21 | 53.87 | 55.09 | 283623.0 |
| 2015-12-31 | GC | Futures | 1367.8 | 1370.5 | 1362.6 | 1367.3 | 55707.0 |
| 2015-12-31 | ZN | Futures | 121.009467 | 121.280215 | 120.934259 | 121.205007 | 459340.0 |
| 2015-12-31 | A6 | Futures | 0.72634 | 0.73165 | 0.72554 | 0.72805 | 43277.0 |
| 2015-12-31 | AD | Futures | 0.73699 | 0.73985 | 0.73556 | 0.73955 | 35267.0 |
| 2015-12-31 | ALI | Futures | 2129.93 | 2129.93 | 2129.93 | 2129.93 | 0.0 |
| 2015-12-31 | B | Futures | 31.88 | 33.04 | 31.45 | 32.46 | 78612.0 |
| 2015-12-31 | B6 | Futures | 1.558 | 1.5619 | 1.5494 | 1.5503 | 55795.0 |
| 2015-12-31 | BR | Futures | 0.15529 | 0.15529 | 0.15523 | 0.15523 | 1.0 |
| 2015-12-31 | BZ | Futures | 31.54 | 32.68 | 31.13 | 32.12 | 9699.0 |
| 2015-12-31 | C | Futures | 2366.0 | 2389.0 | 2352.0 | 2381.0 | 16478.0 |
| 2015-12-31 | CB | Futures | 262.266 | 267.183 | 262.266 | 264.06 | 17.0 |
| 2015-12-31 | CC | Futures | 2381.0 | 2385.0 | 2350.0 | 2367.0 | 15718.0 |
| 2015-12-31 | CNH | Futures | 7.2819 | 7.2982 | 7.2819 | 7.2822 | 5.0 |
| 2015-12-31 | CSC | Futures | 3.853 | 3.866 | 3.831 | 3.831 | 41.0 |
| 2015-12-31 | CT | Futures | 74.86 | 74.86 | 73.86 | 74.12 | 14032.0 |
| 2015-12-31 | DC | Futures | 30.66 | 30.66 | 30.3 | 30.38 | 60.0 |
| 2015-12-31 | DX | Futures | 91.789 | 92.336 | 91.785 | 92.242 | 18783.0 |
| 2015-12-31 | E1 | Futures | 1.28041 | 1.28256 | 1.26236 | 1.26652 | 15321.0 |
| 2015-12-31 | E6 | Futures | 1.28017 | 1.28133 | 1.27116 | 1.27292 | 85614.0 |
| 2015-12-31 | E7 | Futures | 1.2728 | 1.274 | 1.264 | 1.2658 | 3269.0 |
| 2015-12-31 | EBM | Futures | 246.48 | 247.19 | 244.01 | 245.07 | 3453.0 |
| 2015-12-31 | ED | Futures | 95.5399 | 95.5543 | 95.5399 | 95.5495 | 80183.0 |
| 2015-12-31 | ER | Futures | 98.22 | 98.22 | 98.21 | 98.215 | 8891.0 |
| 2015-12-31 | EW | Futures | 1486.4 | 1489.4 | 1466.9 | 1471.2 | 14118.0 |
| 2015-12-31 | FCE | Futures | 3910.7 | 3913.7 | 3879.4 | 3879.4 | 11970.0 |
| 2015-12-31 | FTI | Futures | 389.38 | 390.39 | 385.27 | 386.06 | 3285.0 |
| 2015-12-31 | FTUK | Futures | 5062.0 | 5073.4 | 5042.8 | 5055.5 | 15678.0 |
| 2015-12-31 | G | Futures | 103.69 | 104.16 | 103.67 | 103.94 | 35891.0 |
| 2015-12-31 | GF | Futures | 321.68 | 323.997 | 320.474 | 322.163 | 1380.0 |
| 2015-12-31 | GSCI | Futures | 485.75 | 493.19 | 483.55 | 489.35 | 142.0 |
| 2015-12-31 | HE | Futures | 85.867 | 86.19 | 85.006 | 85.795 | 11529.0 |
| 2015-12-31 | HG | Futures | 2.6921 | 2.6934 | 2.6545 | 2.6771 | 24051.0 |
| 2015-12-31 | HH | Futures | 24.608 | 25.644 | 24.608 | 25.223 | 3623.0 |
| 2015-12-31 | HO | Futures | 0.8633 | 0.8877 | 0.8477 | 0.8643 | 15811.0 |
| 2015-12-31 | HRC | Futures | 1341.3 | 1341.3 | 1341.3 | 1341.3 | 0.0 |
| 2015-12-31 | J1 | Futures | 0.0103608 | 0.0104032 | 0.0103533 | 0.0103864 | 57371.0 |
| 2015-12-31 | J7 | Futures | 0.010349 | 0.010399 | 0.010349 | 0.010381 | 702.0 |
| 2015-12-31 | JB | Futures | 135.57 | 135.61 | 135.51 | 135.61 | 199.0 |
| 2015-12-31 | KC | Futures | 186.77 | 191.29 | 186.54 | 191.14 | 11397.0 |
| 2015-12-31 | KE | Futures | 1330.58 | 1342.0 | 1326.29 | 1338.43 | 9823.0 |
| 2015-12-31 | L | Futures | 99.165 | 99.165 | 99.145 | 99.155 | 19103.0 |
| 2015-12-31 | LBS | Futures | 386.9 | 390.1 | 386.1 | 386.7 | 204.0 |
| 2015-12-31 | LE | Futures | 168.804 | 169.268 | 168.125 | 169.02 | 11197.0 |
| 2015-12-31 | MFS | Futures | 1685.5 | 1693.4 | 1666.7 | 1669.8 | 14985.0 |
| 2015-12-31 | MGC | Futures | 1367.0 | 1368.5 | 1360.9 | 1365.6 | 1259.0 |
| 2015-12-31 | MME | Futures | 788.9 | 790.9 | 783.5 | 784.4 | 30394.0 |
> showing 50 of 91 rows — these rows as CSV