PREVIEW / futures_daily / 2015-11-06
file: by_date/futures_daily/2015/2015-11-06.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 |
|---|---|---|---|---|---|---|---|
| 2015-11-06 | ES | Futures | 2228.29 | 2232.81 | 2209.94 | 2227.23 | 1846631.0 |
| 2015-11-06 | NQ | Futures | 5496.16 | 5505.51 | 5447.05 | 5498.79 | 276682.0 |
| 2015-11-06 | YM | Futures | 18374.9 | 18422.4 | 18266.6 | 18410.0 | 173163.0 |
| 2015-11-06 | CL | Futures | 72.1 | 72.47 | 70.04 | 70.32 | 448133.0 |
| 2015-11-06 | GC | Futures | 1424.1 | 1432.5 | 1400.0 | 1404.1 | 199866.0 |
| 2015-11-06 | ZN | Futures | 121.596088 | 121.655958 | 120.578297 | 120.74294 | 1844567.0 |
| 2015-11-06 | A6 | Futures | 0.71333 | 0.71573 | 0.70103 | 0.70273 | 120756.0 |
| 2015-11-06 | AD | Futures | 0.77762 | 0.77824 | 0.76871 | 0.76994 | 71330.0 |
| 2015-11-06 | ALI | Futures | 2139.36 | 2139.36 | 2139.36 | 2139.36 | 0.0 |
| 2015-11-06 | B | Futures | 43.1 | 43.53 | 42.37 | 42.49 | 218226.0 |
| 2015-11-06 | B6 | Futures | 1.6013 | 1.6022 | 1.5821 | 1.5835 | 124070.0 |
| 2015-11-06 | BFX | Futures | 4394.8 | 4434.9 | 4394.8 | 4427.6 | 3.0 |
| 2015-11-06 | BR | Futures | 0.16192 | 0.16278 | 0.15924 | 0.16186 | 1929.0 |
| 2015-11-06 | BZ | Futures | 42.88 | 43.2 | 42.12 | 42.22 | 14214.0 |
| 2015-11-06 | C | Futures | 2376.0 | 2383.0 | 2355.0 | 2380.0 | 5411.0 |
| 2015-11-06 | CB | Futures | 215.472 | 215.521 | 215.472 | 215.521 | 4.0 |
| 2015-11-06 | CC | Futures | 2408.0 | 2412.0 | 2368.0 | 2393.0 | 28983.0 |
| 2015-11-06 | CNH | Futures | 7.0958 | 7.1189 | 7.0818 | 7.1189 | 115.0 |
| 2015-11-06 | CSC | Futures | 4.296 | 4.325 | 4.291 | 4.325 | 43.0 |
| 2015-11-06 | CT | Futures | 74.53 | 74.62 | 73.96 | 73.97 | 19904.0 |
| 2015-11-06 | DC | Futures | 34.23 | 34.7 | 34.08 | 34.5 | 199.0 |
| 2015-11-06 | DX | Futures | 91.712 | 93.03 | 91.656 | 92.834 | 49527.0 |
| 2015-11-06 | E1 | Futures | 1.27529 | 1.27681 | 1.26007 | 1.26197 | 30136.0 |
| 2015-11-06 | E6 | Futures | 1.27534 | 1.27686 | 1.25461 | 1.25929 | 303479.0 |
| 2015-11-06 | E7 | Futures | 1.2683 | 1.2697 | 1.2478 | 1.2523 | 4307.0 |
| 2015-11-06 | EBM | Futures | 267.45 | 271.84 | 267.09 | 271.47 | 22090.0 |
| 2015-11-06 | ED | Futures | 95.7111 | 95.7159 | 95.6679 | 95.6823 | 355030.0 |
| 2015-11-06 | ER | Futures | 98.2 | 98.21 | 98.18 | 98.185 | 78070.0 |
| 2015-11-06 | EW | Futures | 1539.6 | 1545.7 | 1527.4 | 1540.1 | 11780.0 |
| 2015-11-06 | FBON | Futures | 114.51 | 114.55 | 113.35 | 113.47 | 982.0 |
| 2015-11-06 | FBTP | Futures | 103.79 | 103.96 | 102.87 | 103.11 | 124464.0 |
| 2015-11-06 | FBTS | Futures | 100.525 | 100.57 | 100.436 | 100.463 | 29289.0 |
| 2015-11-06 | FCE | Futures | 4160.9 | 4179.3 | 4110.4 | 4155.1 | 103364.0 |
| 2015-11-06 | FDAX | Futures | 12007.1 | 12180.0 | 11940.5 | 12100.7 | 97919.0 |
| 2015-11-06 | FDXM | Futures | 11223.3 | 11379.7 | 11156.4 | 11305.6 | 11802.0 |
| 2015-11-06 | FESX | Futures | 2583.4 | 2609.6 | 2561.7 | 2594.6 | 1222136.0 |
| 2015-11-06 | FEU3 | Futures | 98.853 | 98.853 | 98.833 | 98.833 | 211.0 |
| 2015-11-06 | FGBL | Futures | 139.15 | 139.27 | 137.95 | 138.08 | 881780.0 |
| 2015-11-06 | FGBM | Futures | 125.55 | 125.61 | 125.12 | 125.18 | 666331.0 |
| 2015-11-06 | FGBS | Futures | 111.433 | 111.438 | 111.363 | 111.373 | 359463.0 |
| 2015-11-06 | FGBX | Futures | 156.35 | 156.43 | 153.01 | 153.8 | 50528.0 |
| 2015-11-06 | FMWO | Futures | 5711.4 | 5711.4 | 5684.2 | 5684.2 | 563.0 |
| 2015-11-06 | FOAT | Futures | 127.68 | 127.8 | 126.72 | 126.85 | 126210.0 |
| 2015-11-06 | FTDX | Futures | 1720.7 | 1744.4 | 1720.7 | 1735.8 | 115.0 |
| 2015-11-06 | FTI | Futures | 406.2 | 410.95 | 404.29 | 408.56 | 35051.0 |
| 2015-11-06 | FTUK | Futures | 5104.4 | 5128.9 | 5076.3 | 5092.3 | 96104.0 |
| 2015-11-06 | FVSA | Futures | 2012.67 | 2058.62 | 1966.72 | 2008.07 | 6004.0 |
| 2015-11-06 | FXXP | Futures | 294.6 | 297.4 | 292.7 | 295.6 | 15393.0 |
| 2015-11-06 | G | Futures | 103.81 | 104.04 | 103.02 | 103.12 | 213168.0 |
| 2015-11-06 | GF | Futures | 328.215 | 332.462 | 325.324 | 328.17 | 2357.0 |
> showing 50 of 109 rows — these rows as CSV