PREVIEW / futures_daily / 2016-04-12
file: by_date/futures_daily/2016/2016-04-12.parquet size: 9 KB rows: 109
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-04-12 | ES | Futures | 2182.33 | 2210.25 | 2178.84 | 2207.3 | 1831285.0 |
| 2016-04-12 | NQ | Futures | 5225.26 | 5284.59 | 5201.17 | 5275.78 | 252487.0 |
| 2016-04-12 | YM | Futures | 18151.0 | 18357.9 | 18130.2 | 18338.1 | 174972.0 |
| 2016-04-12 | CL | Futures | 48.98 | 51.29 | 48.66 | 51.19 | 796837.0 |
| 2016-04-12 | GC | Futures | 1623.8 | 1630.1 | 1615.0 | 1625.2 | 157241.0 |
| 2016-04-12 | ZN | Futures | 126.475482 | 126.520743 | 126.007781 | 126.053042 | 977573.0 |
| 2016-04-12 | A6 | Futures | 0.76656 | 0.77628 | 0.76545 | 0.77607 | 102056.0 |
| 2016-04-12 | AD | Futures | 0.79261 | 0.80202 | 0.79128 | 0.80192 | 83208.0 |
| 2016-04-12 | ALI | Futures | 2067.87 | 2081.12 | 2067.87 | 2079.51 | 11.0 |
| 2016-04-12 | B | Futures | 35.56 | 37.32 | 35.44 | 37.22 | 357354.0 |
| 2016-04-12 | B6 | Futures | 1.4991 | 1.5111 | 1.495 | 1.5034 | 91320.0 |
| 2016-04-12 | BFX | Futures | 3847.3 | 3879.1 | 3846.2 | 3879.1 | 3.0 |
| 2016-04-12 | BR | Futures | 0.18194 | 0.18412 | 0.1811 | 0.18246 | 98.0 |
| 2016-04-12 | BZ | Futures | 35.12 | 36.93 | 34.98 | 36.84 | 39987.0 |
| 2016-04-12 | C | Futures | 2267.0 | 2286.0 | 2250.0 | 2285.0 | 3134.0 |
| 2016-04-12 | CB | Futures | 264.622 | 265.384 | 264.591 | 264.591 | 9.0 |
| 2016-04-12 | CC | Futures | 2157.0 | 2170.0 | 2138.0 | 2167.0 | 23618.0 |
| 2016-04-12 | CNH | Futures | 7.0556 | 7.0624 | 7.0516 | 7.058 | 20.0 |
| 2016-04-12 | CSC | Futures | 3.627 | 3.666 | 3.627 | 3.658 | 73.0 |
| 2016-04-12 | CT | Futures | 69.94 | 71.03 | 69.11 | 70.64 | 30391.0 |
| 2016-04-12 | DC | Futures | 28.8 | 29.02 | 28.8 | 28.94 | 184.0 |
| 2016-04-12 | DX | Futures | 87.619 | 87.996 | 87.283 | 87.586 | 23992.0 |
| 2016-04-12 | E1 | Futures | 1.32005 | 1.32633 | 1.31301 | 1.31917 | 18142.0 |
| 2016-04-12 | E6 | Futures | 1.33255 | 1.33954 | 1.32561 | 1.33156 | 182161.0 |
| 2016-04-12 | E7 | Futures | 1.3253 | 1.3322 | 1.3185 | 1.3244 | 3717.0 |
| 2016-04-12 | EBM | Futures | 195.59 | 198.17 | 194.63 | 196.88 | 26256.0 |
| 2016-04-12 | ED | Futures | 95.7208 | 95.7208 | 95.716 | 95.716 | 72334.0 |
| 2016-04-12 | ER | Futures | 98.259 | 98.264 | 98.254 | 98.259 | 64653.0 |
| 2016-04-12 | EW | Futures | 1499.4 | 1521.0 | 1499.4 | 1520.0 | 15475.0 |
| 2016-04-12 | FBON | Futures | 118.43 | 118.43 | 118.08 | 118.28 | 298.0 |
| 2016-04-12 | FBTP | Futures | 107.06 | 107.06 | 106.47 | 106.72 | 78079.0 |
| 2016-04-12 | FBTS | Futures | 100.997 | 101.006 | 100.961 | 100.997 | 16681.0 |
| 2016-04-12 | FCE | Futures | 3593.0 | 3639.7 | 3564.5 | 3629.1 | 156481.0 |
| 2016-04-12 | FDAX | Futures | 10426.2 | 10558.9 | 10360.7 | 10524.0 | 116127.0 |
| 2016-04-12 | FDXM | Futures | 10038.6 | 10167.9 | 9977.5 | 10134.8 | 24127.0 |
| 2016-04-12 | FESX | Futures | 2222.2 | 2246.4 | 2205.8 | 2239.4 | 1322966.0 |
| 2016-04-12 | FEU3 | Futures | 98.912 | 98.912 | 98.912 | 98.912 | 16.0 |
| 2016-04-12 | FGBL | Futures | 146.69 | 146.7 | 146.0 | 146.18 | 811361.0 |
| 2016-04-12 | FGBM | Futures | 127.77 | 127.79 | 127.6 | 127.66 | 429046.0 |
| 2016-04-12 | FGBS | Futures | 111.703 | 111.708 | 111.683 | 111.693 | 115394.0 |
| 2016-04-12 | FGBX | Futures | 174.65 | 174.65 | 172.22 | 172.96 | 60519.0 |
| 2016-04-12 | FMWO | Futures | 5539.5 | 5578.0 | 5529.5 | 5574.3 | 241.0 |
| 2016-04-12 | FOAT | Futures | 134.15 | 134.19 | 133.43 | 133.61 | 131904.0 |
| 2016-04-12 | FTDX | Futures | 1556.6 | 1559.0 | 1537.6 | 1556.6 | 31.0 |
| 2016-04-12 | FTI | Futures | 388.04 | 391.7 | 385.51 | 390.43 | 23356.0 |
| 2016-04-12 | FTUK | Futures | 5056.8 | 5126.6 | 5049.4 | 5108.0 | 113621.0 |
| 2016-04-12 | FVSA | Futures | 2744.12 | 2801.84 | 2707.39 | 2744.12 | 9915.0 |
| 2016-04-12 | FXXP | Futures | 262.7 | 265.4 | 261.1 | 264.7 | 25423.0 |
| 2016-04-12 | G | Futures | 108.64 | 108.65 | 108.25 | 108.43 | 177886.0 |
| 2016-04-12 | GF | Futures | 303.12 | 305.317 | 299.824 | 301.721 | 5401.0 |
> showing 50 of 109 rows — these rows as CSV