PREVIEW / futures_daily / 2015-10-09
file: by_date/futures_daily/2015/2015-10-09.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-10-09 | ES | Futures | 2131.76 | 2142.4 | 2126.17 | 2135.48 | 1378359.0 |
| 2015-10-09 | NQ | Futures | 5072.03 | 5108.56 | 5056.24 | 5097.16 | 208829.0 |
| 2015-10-09 | YM | Futures | 17486.6 | 17567.0 | 17447.4 | 17530.9 | 119038.0 |
| 2015-10-09 | CL | Futures | 79.81 | 81.79 | 78.98 | 79.71 | 508680.0 |
| 2015-10-09 | GC | Futures | 1469.2 | 1496.5 | 1469.0 | 1492.1 | 134869.0 |
| 2015-10-09 | ZN | Futures | 123.107807 | 123.302385 | 122.778522 | 123.077872 | 955703.0 |
| 2015-10-09 | A6 | Futures | 0.72343 | 0.73214 | 0.72283 | 0.73094 | 87514.0 |
| 2015-10-09 | AD | Futures | 0.78684 | 0.79463 | 0.78674 | 0.79094 | 58842.0 |
| 2015-10-09 | ALI | Futures | 2178.39 | 2178.39 | 2178.39 | 2178.39 | 30.0 |
| 2015-10-09 | B | Futures | 48.0 | 48.66 | 46.97 | 47.36 | 256528.0 |
| 2015-10-09 | B6 | Futures | 1.6157 | 1.6195 | 1.6108 | 1.6148 | 71517.0 |
| 2015-10-09 | BR | Futures | 0.15986 | 0.16238 | 0.15986 | 0.16124 | 1182.0 |
| 2015-10-09 | BZ | Futures | 47.65 | 48.39 | 46.73 | 47.1 | 32679.0 |
| 2015-10-09 | C | Futures | 2231.0 | 2242.0 | 2219.0 | 2221.0 | 9630.0 |
| 2015-10-09 | CB | Futures | 184.029 | 185.481 | 183.537 | 184.029 | 26.0 |
| 2015-10-09 | CC | Futures | 2240.0 | 2265.0 | 2234.0 | 2236.0 | 16763.0 |
| 2015-10-09 | CNH | Futures | 7.091 | 7.0941 | 7.0811 | 7.0811 | 83.0 |
| 2015-10-09 | CSC | Futures | 4.35 | 4.365 | 4.327 | 4.363 | 36.0 |
| 2015-10-09 | CT | Futures | 73.87 | 74.66 | 73.14 | 73.91 | 19824.0 |
| 2015-10-09 | DC | Futures | 35.23 | 35.41 | 35.1 | 35.37 | 123.0 |
| 2015-10-09 | DX | Futures | 89.177 | 89.243 | 88.611 | 88.74 | 31774.0 |
| 2015-10-09 | E1 | Futures | 1.31613 | 1.32603 | 1.31372 | 1.32311 | 14336.0 |
| 2015-10-09 | E6 | Futures | 1.32255 | 1.3352 | 1.32114 | 1.33274 | 210026.0 |
| 2015-10-09 | E7 | Futures | 1.3149 | 1.3278 | 1.3139 | 1.3254 | 4685.0 |
| 2015-10-09 | EBM | Futures | 261.97 | 264.17 | 260.15 | 262.34 | 28478.0 |
| 2015-10-09 | ED | Futures | 95.7304 | 95.74 | 95.7256 | 95.7352 | 117729.0 |
| 2015-10-09 | ER | Futures | 98.146 | 98.146 | 98.141 | 98.141 | 13476.0 |
| 2015-10-09 | EW | Futures | 1513.1 | 1521.0 | 1509.5 | 1517.3 | 18017.0 |
| 2015-10-09 | FBTP | Futures | 102.8 | 102.98 | 102.71 | 102.76 | 77808.0 |
| 2015-10-09 | FBTS | Futures | 100.382 | 100.409 | 100.373 | 100.391 | 9798.0 |
| 2015-10-09 | FCE | Futures | 3941.5 | 3944.0 | 3895.7 | 3912.8 | 77939.0 |
| 2015-10-09 | FDAX | Futures | 11144.7 | 11175.6 | 11062.7 | 11121.6 | 87626.0 |
| 2015-10-09 | FESX | Futures | 2444.8 | 2445.5 | 2417.8 | 2429.8 | 898806.0 |
| 2015-10-09 | FEU3 | Futures | 98.789 | 98.794 | 98.789 | 98.794 | 639.0 |
| 2015-10-09 | FGBL | Futures | 138.96 | 139.05 | 138.61 | 138.74 | 473355.0 |
| 2015-10-09 | FGBM | Futures | 125.23 | 125.25 | 125.12 | 125.19 | 290835.0 |
| 2015-10-09 | FGBS | Futures | 111.283 | 111.293 | 111.273 | 111.283 | 119343.0 |
| 2015-10-09 | FGBX | Futures | 158.02 | 158.43 | 157.14 | 157.51 | 20912.0 |
| 2015-10-09 | FMWO | Futures | 5591.5 | 5600.2 | 5590.3 | 5591.5 | 401.0 |
| 2015-10-09 | FOAT | Futures | 127.23 | 127.35 | 126.94 | 127.02 | 65933.0 |
| 2015-10-09 | FTDX | Futures | 1699.8 | 1699.8 | 1665.2 | 1673.7 | 266.0 |
| 2015-10-09 | FTI | Futures | 388.23 | 388.62 | 381.85 | 383.5 | 26159.0 |
| 2015-10-09 | FTUK | Futures | 5139.8 | 5167.1 | 5112.8 | 5138.6 | 104694.0 |
| 2015-10-09 | FVSA | Futures | 2237.74 | 2283.98 | 2210.0 | 2251.61 | 8904.0 |
| 2015-10-09 | FXXP | Futures | 284.3 | 284.6 | 281.1 | 282.0 | 19829.0 |
| 2015-10-09 | G | Futures | 104.71 | 104.94 | 104.47 | 104.58 | 154460.0 |
| 2015-10-09 | GF | Futures | 333.491 | 336.599 | 330.917 | 335.533 | 2033.0 |
| 2015-10-09 | GSCI | Futures | 619.35 | 619.35 | 615.84 | 617.39 | 1991.0 |
| 2015-10-09 | HE | Futures | 99.684 | 100.619 | 98.712 | 98.899 | 11840.0 |
| 2015-10-09 | HG | Futures | 2.9437 | 3.0513 | 2.9368 | 3.0219 | 75807.0 |
> showing 50 of 106 rows — these rows as CSV