PREVIEW / futures_daily / 2015-11-10
file: by_date/futures_daily/2015/2015-11-10.parquet size: 9 KB rows: 108
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-10 | ES | Futures | 2204.36 | 2211.54 | 2196.12 | 2210.48 | 1286098.0 |
| 2015-11-10 | NQ | Futures | 5436.82 | 5451.14 | 5392.97 | 5428.64 | 241859.0 |
| 2015-11-10 | YM | Futures | 18239.8 | 18287.2 | 18167.5 | 18279.0 | 127743.0 |
| 2015-11-10 | CL | Futures | 70.02 | 71.07 | 69.18 | 70.2 | 445973.0 |
| 2015-11-10 | GC | Futures | 1408.1 | 1413.3 | 1399.3 | 1405.1 | 144170.0 |
| 2015-11-10 | ZN | Futures | 120.68307 | 121.04229 | 120.653135 | 120.98242 | 1127084.0 |
| 2015-11-10 | A6 | Futures | 0.70313 | 0.70523 | 0.70043 | 0.70073 | 63431.0 |
| 2015-11-10 | AD | Futures | 0.77076 | 0.77312 | 0.76994 | 0.77138 | 42719.0 |
| 2015-11-10 | ALI | Futures | 2128.71 | 2128.71 | 2128.71 | 2128.71 | 5.0 |
| 2015-11-10 | B | Futures | 42.39 | 42.81 | 42.05 | 42.43 | 246321.0 |
| 2015-11-10 | B6 | Futures | 1.5913 | 1.5947 | 1.589 | 1.5906 | 49805.0 |
| 2015-11-10 | BR | Futures | 0.16124 | 0.16414 | 0.16001 | 0.16146 | 1259.0 |
| 2015-11-10 | BZ | Futures | 42.13 | 42.53 | 41.78 | 42.16 | 21826.0 |
| 2015-11-10 | C | Futures | 2345.0 | 2398.0 | 2345.0 | 2396.0 | 9857.0 |
| 2015-11-10 | CB | Futures | 216.259 | 217.489 | 216.259 | 217.464 | 13.0 |
| 2015-11-10 | CC | Futures | 2373.0 | 2424.0 | 2370.0 | 2418.0 | 31715.0 |
| 2015-11-10 | CNH | Futures | 7.1111 | 7.1164 | 7.1111 | 7.1162 | 47.0 |
| 2015-11-10 | CSC | Futures | 4.238 | 4.273 | 4.235 | 4.235 | 59.0 |
| 2015-11-10 | CT | Futures | 74.3 | 75.47 | 73.91 | 74.29 | 24670.0 |
| 2015-11-10 | DC | Futures | 34.01 | 34.19 | 33.68 | 33.7 | 312.0 |
| 2015-11-10 | DX | Futures | 92.684 | 93.152 | 92.638 | 92.956 | 23424.0 |
| 2015-11-10 | E1 | Futures | 1.26502 | 1.26743 | 1.25893 | 1.26121 | 20174.0 |
| 2015-11-10 | E6 | Futures | 1.26023 | 1.26152 | 1.25098 | 1.25472 | 193840.0 |
| 2015-11-10 | E7 | Futures | 1.2541 | 1.2544 | 1.2441 | 1.2478 | 4464.0 |
| 2015-11-10 | EBM | Futures | 268.55 | 268.55 | 263.8 | 264.17 | 24075.0 |
| 2015-11-10 | ED | Futures | 95.6871 | 95.6919 | 95.6823 | 95.6919 | 105589.0 |
| 2015-11-10 | ER | Futures | 98.215 | 98.22 | 98.205 | 98.21 | 101070.0 |
| 2015-11-10 | EW | Futures | 1526.3 | 1535.8 | 1520.5 | 1535.3 | 16519.0 |
| 2015-11-10 | FBON | Futures | 114.12 | 114.12 | 113.12 | 113.8 | 420.0 |
| 2015-11-10 | FBTP | Futures | 103.33 | 103.88 | 103.21 | 103.7 | 102985.0 |
| 2015-11-10 | FBTS | Futures | 100.543 | 100.606 | 100.543 | 100.57 | 21499.0 |
| 2015-11-10 | FCE | Futures | 4112.5 | 4123.4 | 4063.3 | 4096.7 | 76642.0 |
| 2015-11-10 | FDAX | Futures | 11954.2 | 11974.6 | 11814.4 | 11930.0 | 90845.0 |
| 2015-11-10 | FDXM | Futures | 11173.9 | 11185.2 | 11039.1 | 11147.2 | 13094.0 |
| 2015-11-10 | FESX | Futures | 2571.4 | 2575.2 | 2539.9 | 2563.2 | 998031.0 |
| 2015-11-10 | FEU3 | Futures | 98.863 | 98.863 | 98.858 | 98.858 | 25.0 |
| 2015-11-10 | FGBL | Futures | 138.54 | 139.0 | 138.33 | 138.88 | 714823.0 |
| 2015-11-10 | FGBM | Futures | 125.56 | 125.68 | 125.5 | 125.63 | 468413.0 |
| 2015-11-10 | FGBS | Futures | 111.473 | 111.503 | 111.458 | 111.478 | 277063.0 |
| 2015-11-10 | FGBX | Futures | 152.99 | 154.56 | 152.48 | 153.76 | 41186.0 |
| 2015-11-10 | FMWO | Futures | 5638.5 | 5645.9 | 5631.1 | 5634.8 | 274.0 |
| 2015-11-10 | FOAT | Futures | 127.25 | 127.73 | 127.06 | 127.61 | 87377.0 |
| 2015-11-10 | FTDX | Futures | 1722.6 | 1726.4 | 1714.5 | 1721.1 | 143.0 |
| 2015-11-10 | FTI | Futures | 404.42 | 404.42 | 400.12 | 403.25 | 179.0 |
| 2015-11-10 | FTUK | Futures | 5054.1 | 5076.3 | 5009.5 | 5026.8 | 86518.0 |
| 2015-11-10 | FVSA | Futures | 2090.78 | 2127.55 | 2031.05 | 2118.36 | 16614.0 |
| 2015-11-10 | FXXP | Futures | 293.6 | 293.6 | 290.4 | 292.7 | 19668.0 |
| 2015-11-10 | G | Futures | 103.11 | 103.36 | 102.99 | 103.22 | 154427.0 |
| 2015-11-10 | GF | Futures | 320.039 | 326.747 | 310.34 | 311.884 | 9102.0 |
| 2015-11-10 | GSCI | Futures | 562.23 | 562.23 | 559.78 | 561.36 | 2782.0 |
> showing 50 of 108 rows — these rows as CSV