PREVIEW / futures_daily / 2013-12-18
file: by_date/futures_daily/2013/2013-12-18.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-18 | ES | Futures | 1826.68 | 1862.5 | 1815.08 | 1860.44 | 2702375.0 |
| 2013-12-18 | NQ | Futures | 3977.35 | 4034.83 | 3926.2 | 4033.4 | 397935.0 |
| 2013-12-18 | YM | Futures | 15778.1 | 16102.6 | 15724.2 | 16083.6 | 196955.0 |
| 2013-12-18 | CL | Futures | 172.19 | 173.54 | 171.72 | 173.11 | 206080.0 |
| 2013-12-18 | GC | Futures | 1629.0 | 1647.1 | 1609.0 | 1635.2 | 160628.0 |
| 2013-12-18 | ZN | Futures | 114.047836 | 114.233838 | 113.346751 | 113.81891 | 1296718.0 |
| 2013-12-18 | A6 | Futures | 0.84453 | 0.84739 | 0.83548 | 0.84177 | 108757.0 |
| 2013-12-18 | AD | Futures | 0.95268 | 0.95309 | 0.94387 | 0.94823 | 78980.0 |
| 2013-12-18 | B | Futures | 110.07 | 111.5 | 109.54 | 111.39 | 187960.0 |
| 2013-12-18 | B6 | Futures | 1.7083 | 1.7308 | 1.7081 | 1.7251 | 146288.0 |
| 2013-12-18 | BFX | Futures | 3369.5 | 3381.7 | 3368.2 | 3376.3 | 849.0 |
| 2013-12-18 | BR | Futures | 0.21878 | 0.21956 | 0.21585 | 0.2173 | 177.0 |
| 2013-12-18 | BZ | Futures | 112.18 | 113.41 | 111.45 | 113.33 | 7394.0 |
| 2013-12-18 | C | Futures | 1881.0 | 1889.0 | 1863.0 | 1869.0 | 6611.0 |
| 2013-12-18 | CB | Futures | 78.017 | 78.729 | 77.772 | 78.471 | 33.0 |
| 2013-12-18 | CC | Futures | 2057.0 | 2074.0 | 2052.0 | 2056.0 | 8143.0 |
| 2013-12-18 | CNH | Futures | 7.005 | 7.0056 | 7.0045 | 7.0045 | 80.0 |
| 2013-12-18 | CSC | Futures | 3.685 | 3.718 | 3.685 | 3.718 | 6.0 |
| 2013-12-18 | CT | Futures | 94.58 | 94.87 | 94.07 | 94.64 | 11010.0 |
| 2013-12-18 | DC | Futures | 28.36 | 28.82 | 28.36 | 28.79 | 328.0 |
| 2013-12-18 | DX | Futures | 76.276 | 76.756 | 75.601 | 76.312 | 35097.0 |
| 2013-12-18 | E1 | Futures | 1.45201 | 1.45457 | 1.43532 | 1.44713 | 42120.0 |
| 2013-12-18 | E6 | Futures | 1.62525 | 1.63446 | 1.61404 | 1.62395 | 228130.0 |
| 2013-12-18 | E7 | Futures | 1.6148 | 1.6272 | 1.6035 | 1.6134 | 7229.0 |
| 2013-12-18 | EBM | Futures | 281.92 | 283.31 | 280.87 | 281.57 | 16958.0 |
| 2013-12-18 | ED | Futures | 95.3662 | 95.371 | 95.3519 | 95.3614 | 211793.0 |
| 2013-12-18 | ER | Futures | 97.832 | 97.857 | 97.822 | 97.847 | 131328.0 |
| 2013-12-18 | EW | Futures | 1323.7 | 1342.9 | 1312.3 | 1342.4 | 32408.0 |
| 2013-12-18 | FBTP | Futures | 82.2 | 82.24 | 81.92 | 82.02 | 20765.0 |
| 2013-12-18 | FBTS | Futures | 95.653 | 95.67 | 95.565 | 95.6 | 6396.0 |
| 2013-12-18 | FCE | Futures | 3185.9 | 3243.6 | 3176.9 | 3204.2 | 117110.0 |
| 2013-12-18 | FDAX | Futures | 10135.2 | 10309.3 | 10134.7 | 10200.1 | 20448.0 |
| 2013-12-18 | FESX | Futures | 2075.4 | 2118.3 | 2072.6 | 2089.4 | 678739.0 |
| 2013-12-18 | FEU3 | Futures | 98.463 | 98.463 | 98.463 | 98.463 | 301.0 |
| 2013-12-18 | FGBL | Futures | 119.47 | 119.55 | 118.87 | 119.25 | 483359.0 |
| 2013-12-18 | FGBM | Futures | 117.69 | 117.81 | 117.41 | 117.53 | 318620.0 |
| 2013-12-18 | FGBS | Futures | 110.323 | 110.368 | 110.288 | 110.303 | 275120.0 |
| 2013-12-18 | FGBX | Futures | 120.33 | 120.68 | 119.5 | 120.31 | 17181.0 |
| 2013-12-18 | FMWO | Futures | 5250.9 | 5261.0 | 5250.9 | 5256.0 | 789.0 |
| 2013-12-18 | FOAT | Futures | 108.44 | 108.5 | 108.26 | 108.27 | 33543.0 |
| 2013-12-18 | FTDX | Futures | 1066.2 | 1084.0 | 1066.2 | 1073.2 | 1057.0 |
| 2013-12-18 | FTI | Futures | 326.33 | 331.22 | 325.04 | 327.36 | 21638.0 |
| 2013-12-18 | FTUK | Futures | 4881.4 | 4935.6 | 4830.0 | 4875.4 | 147053.0 |
| 2013-12-18 | FVSA | Futures | 1993.51 | 1998.88 | 1918.28 | 1945.15 | 11889.0 |
| 2013-12-18 | FXXP | Futures | 229.0 | 230.4 | 229.0 | 230.0 | 13239.0 |
| 2013-12-18 | G | Futures | 91.26 | 91.43 | 90.75 | 90.87 | 126103.0 |
| 2013-12-18 | GF | Futures | 269.092 | 269.294 | 267.281 | 267.322 | 2458.0 |
| 2013-12-18 | GSCI | Futures | 1032.77 | 1038.55 | 1032.36 | 1037.73 | 20.0 |
| 2013-12-18 | HE | Futures | 103.984 | 104.769 | 103.924 | 104.286 | 13441.0 |
| 2013-12-18 | HG | Futures | 4.1888 | 4.2058 | 4.1661 | 4.1919 | 39892.0 |
> showing 50 of 105 rows — these rows as CSV