PREVIEW / futures_daily / 2015-03-04
file: by_date/futures_daily/2015/2015-03-04.parquet size: 9 KB rows: 106
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-03-04 | ES | Futures | 2206.05 | 2206.05 | 2185.61 | 2197.4 | 1490440.0 |
| 2015-03-04 | NQ | Futures | 5172.87 | 5172.87 | 5127.62 | 5156.63 | 210995.0 |
| 2015-03-04 | YM | Futures | 18522.0 | 18522.0 | 18345.8 | 18420.2 | 118085.0 |
| 2015-03-04 | CL | Futures | 93.64 | 96.2 | 91.78 | 95.35 | 463989.0 |
| 2015-03-04 | GC | Futures | 1574.0 | 1580.0 | 1566.0 | 1570.2 | 107563.0 |
| 2015-03-04 | ZN | Futures | 120.143896 | 120.364721 | 120.026122 | 120.188061 | 61727.0 |
| 2015-03-04 | A6 | Futures | 0.76496 | 0.76956 | 0.763 | 0.76545 | 77344.0 |
| 2015-03-04 | AD | Futures | 0.81514 | 0.82074 | 0.81097 | 0.82034 | 90881.0 |
| 2015-03-04 | ALI | Futures | 2675.2 | 2675.2 | 2675.2 | 2675.2 | 0.0 |
| 2015-03-04 | B | Futures | 60.56 | 60.71 | 59.28 | 60.24 | 162982.0 |
| 2015-03-04 | B6 | Futures | 1.615 | 1.6163 | 1.6035 | 1.6045 | 100733.0 |
| 2015-03-04 | BFX | Futures | 4454.8 | 4468.1 | 4454.8 | 4468.1 | 76.0 |
| 2015-03-04 | BR | Futures | 0.18919 | 0.18919 | 0.18525 | 0.18631 | 726.0 |
| 2015-03-04 | BZ | Futures | 60.01 | 60.13 | 58.8 | 59.71 | 27556.0 |
| 2015-03-04 | C | Futures | 2233.0 | 2240.0 | 2224.0 | 2239.0 | 4033.0 |
| 2015-03-04 | CB | Futures | 145.646 | 145.646 | 145.242 | 145.646 | 7.0 |
| 2015-03-04 | CC | Futures | 2231.0 | 2232.0 | 2210.0 | 2220.0 | 9772.0 |
| 2015-03-04 | CNH | Futures | 7.1411 | 7.1514 | 7.1411 | 7.1514 | 17.0 |
| 2015-03-04 | CSC | Futures | 4.551 | 4.551 | 4.492 | 4.532 | 6.0 |
| 2015-03-04 | CT | Futures | 81.62 | 81.8 | 80.81 | 81.52 | 13673.0 |
| 2015-03-04 | DC | Futures | 37.02 | 37.54 | 36.66 | 36.89 | 73.0 |
| 2015-03-04 | DX | Futures | 90.289 | 90.937 | 90.27 | 90.858 | 57087.0 |
| 2015-03-04 | E1 | Futures | 1.32863 | 1.33144 | 1.31829 | 1.32634 | 24090.0 |
| 2015-03-04 | E6 | Futures | 1.31517 | 1.31587 | 1.30129 | 1.3027 | 252913.0 |
| 2015-03-04 | E7 | Futures | 1.3072 | 1.308 | 1.2934 | 1.2949 | 5676.0 |
| 2015-03-04 | EBM | Futures | 300.08 | 300.08 | 298.46 | 299.27 | 2733.0 |
| 2015-03-04 | ED | Futures | 95.457 | 95.457 | 95.4546 | 95.457 | 77703.0 |
| 2015-03-04 | ER | Futures | 98.058 | 98.063 | 98.058 | 98.058 | 14796.0 |
| 2015-03-04 | EW | Futures | 1577.4 | 1577.9 | 1563.5 | 1570.9 | 15882.0 |
| 2015-03-04 | FBTP | Futures | 102.5 | 102.77 | 102.34 | 102.49 | 175381.0 |
| 2015-03-04 | FBTS | Futures | 99.51 | 99.581 | 99.493 | 99.528 | 57894.0 |
| 2015-03-04 | FCE | Futures | 3971.6 | 4004.9 | 3950.1 | 3998.0 | 110503.0 |
| 2015-03-04 | FDAX | Futures | 12564.6 | 12680.6 | 12427.5 | 12630.6 | 124209.0 |
| 2015-03-04 | FESX | Futures | 2568.0 | 2588.1 | 2545.6 | 2578.1 | 1115652.0 |
| 2015-03-04 | FGBL | Futures | 139.02 | 139.25 | 138.86 | 139.01 | 1208723.0 |
| 2015-03-04 | FGBM | Futures | 124.53 | 124.61 | 124.42 | 124.5 | 884255.0 |
| 2015-03-04 | FGBS | Futures | 111.188 | 111.198 | 111.153 | 111.178 | 596063.0 |
| 2015-03-04 | FGBX | Futures | 165.56 | 166.68 | 165.42 | 166.1 | 59620.0 |
| 2015-03-04 | FMWO | Futures | 5824.0 | 5824.0 | 5780.7 | 5799.2 | 122.0 |
| 2015-03-04 | FOAT | Futures | 127.64 | 127.88 | 127.53 | 127.67 | 149403.0 |
| 2015-03-04 | FTDX | Futures | 1474.4 | 1474.4 | 1455.2 | 1470.2 | 172.0 |
| 2015-03-04 | FTI | Futures | 415.24 | 418.48 | 413.47 | 417.45 | 24579.0 |
| 2015-03-04 | FTUK | Futures | 5356.4 | 5382.1 | 5324.8 | 5361.5 | 109984.0 |
| 2015-03-04 | FVSA | Futures | 1750.17 | 1839.69 | 1709.88 | 1750.17 | 18201.0 |
| 2015-03-04 | FXXP | Futures | 293.8 | 295.6 | 292.3 | 294.6 | 11369.0 |
| 2015-03-04 | G | Futures | 102.46 | 102.6 | 102.23 | 102.28 | 171139.0 |
| 2015-03-04 | GF | Futures | 341.021 | 349.582 | 339.924 | 349.582 | 5020.0 |
| 2015-03-04 | GSCI | Futures | 714.77 | 718.72 | 707.12 | 717.34 | 340.0 |
| 2015-03-04 | HE | Futures | 87.537 | 91.964 | 86.061 | 91.226 | 31847.0 |
| 2015-03-04 | HG | Futures | 3.3733 | 3.3999 | 3.351 | 3.379 | 32320.0 |
> showing 50 of 106 rows — these rows as CSV