PREVIEW / futures_daily / 2016-03-10
file: by_date/futures_daily/2016/2016-03-10.parquet size: 9 KB rows: 107
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-03-10 | ES | Futures | 2125.59 | 2147.22 | 2101.29 | 2124.26 | 2738172.0 |
| 2016-03-10 | NQ | Futures | 5035.35 | 5096.61 | 4958.57 | 5023.34 | 392234.0 |
| 2016-03-10 | YM | Futures | 17599.9 | 17755.9 | 17386.7 | 17571.8 | 32937.0 |
| 2016-03-10 | CL | Futures | 47.96 | 48.35 | 46.75 | 47.54 | 701435.0 |
| 2016-03-10 | GC | Futures | 1610.9 | 1637.4 | 1590.1 | 1635.4 | 304980.0 |
| 2016-03-10 | ZN | Futures | 124.740461 | 124.936594 | 124.06154 | 124.212411 | 1683316.0 |
| 2016-03-10 | A6 | Futures | 0.7528 | 0.75715 | 0.74855 | 0.75108 | 67819.0 |
| 2016-03-10 | AD | Futures | 0.77175 | 0.77278 | 0.76327 | 0.76633 | 55426.0 |
| 2016-03-10 | ALI | Futures | 2112.26 | 2116.1 | 2112.26 | 2116.1 | 5.0 |
| 2016-03-10 | B | Futures | 34.05 | 34.15 | 33.0 | 33.35 | 287782.0 |
| 2016-03-10 | B6 | Futures | 1.4969 | 1.508 | 1.487 | 1.5048 | 120919.0 |
| 2016-03-10 | BR | Futures | 0.17384 | 0.17514 | 0.17205 | 0.17475 | 86.0 |
| 2016-03-10 | BZ | Futures | 33.67 | 33.8 | 32.69 | 33.02 | 28194.0 |
| 2016-03-10 | C | Futures | 2341.0 | 2366.0 | 2338.0 | 2361.0 | 9943.0 |
| 2016-03-10 | CB | Futures | 248.464 | 252.427 | 248.464 | 252.0 | 27.0 |
| 2016-03-10 | CC | Futures | 2220.0 | 2247.0 | 2212.0 | 2242.0 | 15226.0 |
| 2016-03-10 | CNH | Futures | 7.1407 | 7.1439 | 7.1188 | 7.1188 | 87.0 |
| 2016-03-10 | CSC | Futures | 3.527 | 3.53 | 3.522 | 3.53 | 33.0 |
| 2016-03-10 | CT | Futures | 65.04 | 65.45 | 63.93 | 65.27 | 19495.0 |
| 2016-03-10 | DC | Futures | 27.8 | 27.99 | 27.66 | 27.8 | 121.0 |
| 2016-03-10 | DX | Futures | 90.761 | 91.833 | 89.488 | 89.614 | 71168.0 |
| 2016-03-10 | E1 | Futures | 1.26589 | 1.286 | 1.25006 | 1.28411 | 40763.0 |
| 2016-03-10 | E6 | Futures | 1.28671 | 1.31202 | 1.26572 | 1.30975 | 286293.0 |
| 2016-03-10 | E7 | Futures | 1.2795 | 1.305 | 1.259 | 1.3026 | 3983.0 |
| 2016-03-10 | EBM | Futures | 199.78 | 201.38 | 198.17 | 198.49 | 24055.0 |
| 2016-03-10 | ED | Futures | 95.6389 | 95.6437 | 95.6196 | 95.6389 | 412003.0 |
| 2016-03-10 | ER | Futures | 98.288 | 98.318 | 98.234 | 98.249 | 297982.0 |
| 2016-03-10 | EW | Futures | 1463.5 | 1472.7 | 1439.2 | 1453.1 | 24487.0 |
| 2016-03-10 | FBON | Futures | 117.34 | 118.96 | 116.62 | 117.2 | 355.0 |
| 2016-03-10 | FBTP | Futures | 106.3 | 108.06 | 105.69 | 106.28 | 217137.0 |
| 2016-03-10 | FBTS | Futures | 101.051 | 101.212 | 100.934 | 100.988 | 38679.0 |
| 2016-03-10 | FCE | Futures | 3690.1 | 3815.9 | 3585.2 | 3622.6 | 207260.0 |
| 2016-03-10 | FDAX | Futures | 10550.9 | 10839.9 | 10187.1 | 10315.6 | 213040.0 |
| 2016-03-10 | FDXM | Futures | 10085.1 | 10367.5 | 9767.6 | 9874.1 | 384.0 |
| 2016-03-10 | FESX | Futures | 2294.7 | 2380.5 | 2228.4 | 2262.8 | 468339.0 |
| 2016-03-10 | FEU3 | Futures | 98.952 | 98.956 | 98.902 | 98.902 | 109.0 |
| 2016-03-10 | FGBL | Futures | 145.04 | 146.15 | 143.83 | 144.14 | 1170334.0 |
| 2016-03-10 | FGBM | Futures | 127.5 | 127.92 | 126.74 | 126.83 | 1034418.0 |
| 2016-03-10 | FGBS | Futures | 111.758 | 111.822 | 111.553 | 111.578 | 752578.0 |
| 2016-03-10 | FGBX | Futures | 168.4 | 170.94 | 165.04 | 166.26 | 63812.0 |
| 2016-03-10 | FMWO | Futures | 5409.9 | 5466.0 | 5386.3 | 5388.8 | 1236.0 |
| 2016-03-10 | FOAT | Futures | 132.16 | 133.82 | 131.02 | 131.34 | 159294.0 |
| 2016-03-10 | FTDX | Futures | 1535.2 | 1535.2 | 1492.8 | 1492.8 | 157.0 |
| 2016-03-10 | FTI | Futures | 385.68 | 394.73 | 377.96 | 380.67 | 504.0 |
| 2016-03-10 | FTUK | Futures | 5010.6 | 5058.1 | 4899.6 | 4929.7 | 22287.0 |
| 2016-03-10 | FVSA | Futures | 3039.66 | 3261.79 | 2759.08 | 3162.42 | 38863.0 |
| 2016-03-10 | FXXP | Futures | 266.9 | 273.7 | 262.5 | 262.5 | 2247.0 |
| 2016-03-10 | G | Futures | 108.18 | 108.33 | 107.43 | 107.55 | 243092.0 |
| 2016-03-10 | GF | Futures | 312.299 | 317.943 | 312.299 | 317.256 | 5645.0 |
| 2016-03-10 | GSCI | Futures | 495.41 | 495.48 | 490.68 | 493.68 | 2969.0 |
> showing 50 of 107 rows — these rows as CSV