PREVIEW / futures_daily / 2015-11-09
file: by_date/futures_daily/2015/2015-11-09.parquet size: 9 KB rows: 109
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-11-09 | ES | Futures | 2225.37 | 2231.49 | 2193.46 | 2205.16 | 1856213.0 |
| 2015-11-09 | NQ | Futures | 5496.74 | 5510.19 | 5404.08 | 5440.04 | 256938.0 |
| 2015-11-09 | YM | Futures | 18392.5 | 18438.9 | 18169.6 | 18236.7 | 146385.0 |
| 2015-11-09 | CL | Futures | 70.69 | 71.64 | 69.29 | 69.66 | 487992.0 |
| 2015-11-09 | GC | Futures | 1405.9 | 1413.4 | 1403.7 | 1404.6 | 141885.0 |
| 2015-11-09 | ZN | Futures | 120.817778 | 120.832745 | 120.413655 | 120.727973 | 1310407.0 |
| 2015-11-09 | A6 | Futures | 0.70203 | 0.70573 | 0.70173 | 0.70343 | 66950.0 |
| 2015-11-09 | AD | Futures | 0.76984 | 0.77302 | 0.76933 | 0.77107 | 43668.0 |
| 2015-11-09 | ALI | Futures | 2147.75 | 2147.75 | 2147.75 | 2147.75 | 0.0 |
| 2015-11-09 | B | Futures | 42.57 | 43.35 | 42.13 | 42.27 | 197570.0 |
| 2015-11-09 | B6 | Futures | 1.585 | 1.5928 | 1.5837 | 1.5912 | 82223.0 |
| 2015-11-09 | BFX | Futures | 4426.4 | 4426.4 | 4399.1 | 4399.1 | 18.0 |
| 2015-11-09 | BR | Futures | 0.16149 | 0.16315 | 0.16084 | 0.16149 | 3799.0 |
| 2015-11-09 | BZ | Futures | 42.25 | 43.06 | 41.87 | 42.0 | 17565.0 |
| 2015-11-09 | C | Futures | 2375.0 | 2377.0 | 2347.0 | 2352.0 | 5336.0 |
| 2015-11-09 | CB | Futures | 215.545 | 217.243 | 215.545 | 217.243 | 5.0 |
| 2015-11-09 | CC | Futures | 2384.0 | 2392.0 | 2355.0 | 2371.0 | 26214.0 |
| 2015-11-09 | CNH | Futures | 7.113 | 7.1156 | 7.1116 | 7.1116 | 94.0 |
| 2015-11-09 | CSC | Futures | 4.304 | 4.309 | 4.263 | 4.284 | 56.0 |
| 2015-11-09 | CT | Futures | 74.22 | 74.46 | 73.91 | 74.26 | 22069.0 |
| 2015-11-09 | DC | Futures | 34.63 | 34.63 | 34.01 | 34.23 | 165.0 |
| 2015-11-09 | DX | Futures | 92.942 | 92.993 | 92.507 | 92.662 | 26605.0 |
| 2015-11-09 | E1 | Futures | 1.26235 | 1.26996 | 1.26184 | 1.26552 | 24262.0 |
| 2015-11-09 | E6 | Futures | 1.25754 | 1.26456 | 1.25613 | 1.2607 | 200622.0 |
| 2015-11-09 | E7 | Futures | 1.2505 | 1.2575 | 1.2492 | 1.2537 | 3370.0 |
| 2015-11-09 | EBM | Futures | 270.01 | 271.11 | 268.55 | 268.55 | 17415.0 |
| 2015-11-09 | ED | Futures | 95.6823 | 95.6871 | 95.6775 | 95.6823 | 176370.0 |
| 2015-11-09 | ER | Futures | 98.185 | 98.225 | 98.176 | 98.205 | 126778.0 |
| 2015-11-09 | EW | Futures | 1540.0 | 1543.5 | 1516.0 | 1527.0 | 17104.0 |
| 2015-11-09 | FBON | Futures | 112.94 | 113.15 | 112.73 | 112.91 | 811.0 |
| 2015-11-09 | FBTP | Futures | 103.1 | 103.38 | 102.51 | 103.1 | 102931.0 |
| 2015-11-09 | FBTS | Futures | 100.463 | 100.543 | 100.409 | 100.507 | 23444.0 |
| 2015-11-09 | FCE | Futures | 4165.1 | 4167.2 | 4087.5 | 4094.6 | 75790.0 |
| 2015-11-09 | FDAX | Futures | 12109.5 | 12129.9 | 11879.3 | 11907.4 | 86938.0 |
| 2015-11-09 | FDXM | Futures | 11319.0 | 11333.4 | 11098.8 | 11125.5 | 9216.0 |
| 2015-11-09 | FESX | Futures | 2599.9 | 2603.6 | 2553.4 | 2557.2 | 929796.0 |
| 2015-11-09 | FEU3 | Futures | 98.873 | 98.873 | 98.853 | 98.853 | 30.0 |
| 2015-11-09 | FGBL | Futures | 138.07 | 138.53 | 137.75 | 138.3 | 813551.0 |
| 2015-11-09 | FGBM | Futures | 125.17 | 125.57 | 125.14 | 125.42 | 548550.0 |
| 2015-11-09 | FGBS | Futures | 111.363 | 111.473 | 111.353 | 111.423 | 332901.0 |
| 2015-11-09 | FGBX | Futures | 153.48 | 153.8 | 152.29 | 152.44 | 45375.0 |
| 2015-11-09 | FMWO | Futures | 5689.2 | 5689.2 | 5633.5 | 5634.8 | 108.0 |
| 2015-11-09 | FOAT | Futures | 126.85 | 127.24 | 126.49 | 127.0 | 89047.0 |
| 2015-11-09 | FTDX | Futures | 1742.0 | 1742.0 | 1716.9 | 1719.2 | 203.0 |
| 2015-11-09 | FTI | Futures | 409.91 | 410.52 | 403.28 | 404.42 | 25634.0 |
| 2015-11-09 | FTUK | Futures | 5108.4 | 5117.7 | 5033.6 | 5046.1 | 91455.0 |
| 2015-11-09 | FVSA | Futures | 1994.29 | 2127.55 | 1962.12 | 2067.81 | 11065.0 |
| 2015-11-09 | FXXP | Futures | 295.9 | 296.1 | 291.8 | 292.1 | 14049.0 |
| 2015-11-09 | G | Futures | 103.17 | 103.19 | 102.74 | 102.97 | 163127.0 |
| 2015-11-09 | GF | Futures | 327.719 | 327.719 | 320.039 | 320.039 | 3881.0 |
> showing 50 of 109 rows — these rows as CSV