PREVIEW / futures_daily / 2017-03-14
file: by_date/futures_daily/2017/2017-03-14.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-14 | ES | Futures | 2574.74 | 2575.55 | 2557.36 | 2566.32 | 2014740.0 |
| 2017-03-14 | NQ | Futures | 6359.18 | 6360.65 | 6317.07 | 6342.99 | 235023.0 |
| 2017-03-14 | YM | Futures | 21986.5 | 21989.7 | 21889.5 | 21950.7 | 165058.0 |
| 2017-03-14 | CL | Futures | 51.36 | 51.73 | 50.0 | 50.68 | 393761.0 |
| 2017-03-14 | GC | Futures | 1537.4 | 1542.6 | 1529.0 | 1536.3 | 183719.0 |
| 2017-03-14 | ZN | Futures | 120.617344 | 120.92461 | 120.586617 | 120.817067 | 938460.0 |
| 2017-03-14 | A6 | Futures | 0.77588 | 0.7766 | 0.7726 | 0.77516 | 60868.0 |
| 2017-03-14 | AD | Futures | 0.75942 | 0.75982 | 0.75671 | 0.75717 | 59270.0 |
| 2017-03-14 | ALI | Futures | 2505.66 | 2505.66 | 2505.66 | 2505.66 | 0.0 |
| 2017-03-14 | B | Futures | 37.49 | 37.87 | 36.69 | 37.18 | 411631.0 |
| 2017-03-14 | B6 | Futures | 1.2842 | 1.2843 | 1.2725 | 1.2779 | 103864.0 |
| 2017-03-14 | BFX | Futures | 4562.5 | 4562.5 | 4537.1 | 4543.2 | 43.0 |
| 2017-03-14 | BR | Futures | 0.22332 | 0.22477 | 0.22332 | 0.22347 | 17.0 |
| 2017-03-14 | BZ | Futures | 37.36 | 37.68 | 36.53 | 37.01 | 49660.0 |
| 2017-03-14 | C | Futures | 1723.0 | 1763.0 | 1722.0 | 1760.0 | 16419.0 |
| 2017-03-14 | CB | Futures | 268.344 | 269.748 | 268.222 | 269.748 | 20.0 |
| 2017-03-14 | CC | Futures | 1536.0 | 1577.0 | 1531.0 | 1571.0 | 24531.0 |
| 2017-03-14 | CNH | Futures | 7.271 | 7.2746 | 7.2572 | 7.2572 | 69.0 |
| 2017-03-14 | CSC | Futures | 3.643 | 3.67 | 3.643 | 3.67 | 49.0 |
| 2017-03-14 | CT | Futures | 85.74 | 86.21 | 85.6 | 85.99 | 9929.0 |
| 2017-03-14 | DC | Futures | 30.0 | 30.18 | 29.66 | 30.15 | 163.0 |
| 2017-03-14 | DX | Futures | 94.364 | 94.713 | 94.298 | 94.633 | 22531.0 |
| 2017-03-14 | E1 | Futures | 1.23415 | 1.23415 | 1.22946 | 1.23069 | 14472.0 |
| 2017-03-14 | E6 | Futures | 1.23267 | 1.23376 | 1.22662 | 1.22789 | 159533.0 |
| 2017-03-14 | E7 | Futures | 1.2263 | 1.2275 | 1.2204 | 1.2216 | 1986.0 |
| 2017-03-14 | EBM | Futures | 192.38 | 193.22 | 190.98 | 191.26 | 30344.0 |
| 2017-03-14 | ED | Futures | 95.4913 | 95.501 | 95.4913 | 95.4962 | 204393.0 |
| 2017-03-14 | ER | Futures | 98.308 | 98.318 | 98.308 | 98.313 | 63551.0 |
| 2017-03-14 | EW | Futures | 1821.7 | 1821.7 | 1803.4 | 1813.7 | 30812.0 |
| 2017-03-14 | FBON | Futures | 119.0 | 119.43 | 118.8 | 119.33 | 550.0 |
| 2017-03-14 | FBTP | Futures | 102.72 | 103.01 | 102.5 | 102.84 | 114412.0 |
| 2017-03-14 | FBTS | Futures | 101.456 | 101.528 | 101.383 | 101.465 | 42298.0 |
| 2017-03-14 | FCE | Futures | 4409.4 | 4409.4 | 4360.4 | 4374.6 | 159614.0 |
| 2017-03-14 | FDAX | Futures | 12679.6 | 12679.6 | 12590.9 | 12654.8 | 138187.0 |
| 2017-03-14 | FDXM | Futures | 12600.1 | 12600.1 | 12517.4 | 12577.6 | 2447.0 |
| 2017-03-14 | FESX | Futures | 2729.6 | 2732.0 | 2701.8 | 2710.0 | 1717588.0 |
| 2017-03-14 | FEU3 | Futures | 98.986 | 98.986 | 98.986 | 98.986 | 10.0 |
| 2017-03-14 | FGBL | Futures | 146.16 | 146.74 | 145.88 | 146.64 | 727965.0 |
| 2017-03-14 | FGBM | Futures | 128.72 | 128.99 | 128.61 | 128.93 | 515053.0 |
| 2017-03-14 | FGBS | Futures | 112.332 | 112.402 | 112.332 | 112.382 | 246522.0 |
| 2017-03-14 | FGBX | Futures | 163.02 | 165.33 | 162.58 | 165.01 | 55315.0 |
| 2017-03-14 | FMWO | Futures | 6181.9 | 6181.9 | 6154.2 | 6162.6 | 4759.0 |
| 2017-03-14 | FOAT | Futures | 129.89 | 130.23 | 129.75 | 130.09 | 130145.0 |
| 2017-03-14 | FTDX | Futures | 1946.0 | 1946.0 | 1938.6 | 1940.6 | 1253.0 |
| 2017-03-14 | FTI | Futures | 464.61 | 464.66 | 460.79 | 462.11 | 34152.0 |
| 2017-03-14 | FTUK | Futures | 6233.8 | 6252.2 | 6208.6 | 6223.6 | 327501.0 |
| 2017-03-14 | FVSA | Futures | 679.38 | 693.24 | 675.22 | 680.76 | 15094.0 |
| 2017-03-14 | FXXP | Futures | 310.3 | 310.3 | 308.4 | 309.1 | 137888.0 |
| 2017-03-14 | G | Futures | 113.6 | 114.0 | 113.46 | 113.92 | 164874.0 |
| 2017-03-14 | GF | Futures | 295.488 | 296.237 | 291.682 | 293.873 | 5877.0 |
> showing 50 of 110 rows — these rows as CSV