PREVIEW / futures_daily / 2015-12-18
file: by_date/futures_daily/2015/2015-12-18.parquet size: 10 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-12-18 | ES | Futures | 2161.91 | 2168.05 | 2126.66 | 2127.73 | 2118900.0 |
| 2015-12-18 | NQ | Futures | 5356.86 | 5378.84 | 5278.02 | 5280.66 | 340479.0 |
| 2015-12-18 | YM | Futures | 17953.8 | 17997.3 | 17599.9 | 17609.2 | 221125.0 |
| 2015-12-18 | CL | Futures | 53.77 | 54.94 | 53.07 | 53.63 | 402547.0 |
| 2015-12-18 | GC | Futures | 1356.1 | 1381.3 | 1354.2 | 1373.5 | 122220.0 |
| 2015-12-18 | ZN | Futures | 121.550964 | 121.927003 | 121.475756 | 121.761546 | 784697.0 |
| 2015-12-18 | A6 | Futures | 0.71001 | 0.71843 | 0.70951 | 0.71723 | 72453.0 |
| 2015-12-18 | AD | Futures | 0.73402 | 0.73811 | 0.73034 | 0.73423 | 70300.0 |
| 2015-12-18 | ALI | Futures | 2148.73 | 2148.73 | 2148.73 | 2148.73 | 12.0 |
| 2015-12-18 | B | Futures | 32.08 | 32.88 | 31.73 | 32.14 | 218042.0 |
| 2015-12-18 | B6 | Futures | 1.5688 | 1.5732 | 1.5665 | 1.5693 | 72754.0 |
| 2015-12-18 | BFX | Futures | 4459.8 | 4459.8 | 4433.1 | 4433.1 | 3.0 |
| 2015-12-18 | BR | Futures | 0.15661 | 0.1585 | 0.15604 | 0.15604 | 1578.0 |
| 2015-12-18 | BZ | Futures | 31.83 | 32.58 | 31.45 | 31.85 | 30194.0 |
| 2015-12-18 | C | Futures | 2381.0 | 2388.0 | 2364.0 | 2375.0 | 5131.0 |
| 2015-12-18 | CB | Futures | 249.897 | 250.515 | 248.072 | 250.515 | 17.0 |
| 2015-12-18 | CC | Futures | 2409.0 | 2412.0 | 2381.0 | 2398.0 | 10682.0 |
| 2015-12-18 | CNH | Futures | 7.2995 | 7.2995 | 7.2748 | 7.2768 | 9.0 |
| 2015-12-18 | CSC | Futures | 3.858 | 3.87 | 3.826 | 3.841 | 118.0 |
| 2015-12-18 | CT | Futures | 73.78 | 74.89 | 73.74 | 74.6 | 13392.0 |
| 2015-12-18 | DC | Futures | 30.62 | 30.62 | 30.28 | 30.47 | 163.0 |
| 2015-12-18 | DX | Futures | 92.527 | 92.751 | 92.168 | 92.229 | 29688.0 |
| 2015-12-18 | E1 | Futures | 1.27372 | 1.27877 | 1.27056 | 1.27751 | 15808.0 |
| 2015-12-18 | E6 | Futures | 1.26988 | 1.27455 | 1.26637 | 1.2735 | 192169.0 |
| 2015-12-18 | E7 | Futures | 1.2624 | 1.2674 | 1.2593 | 1.2664 | 4085.0 |
| 2015-12-18 | EBM | Futures | 248.25 | 250.01 | 247.19 | 248.96 | 13428.0 |
| 2015-12-18 | ED | Futures | 95.588 | 95.5928 | 95.5688 | 95.5736 | 230803.0 |
| 2015-12-18 | ER | Futures | 98.21 | 98.225 | 98.21 | 98.215 | 47854.0 |
| 2015-12-18 | EW | Futures | 1459.9 | 1463.8 | 1440.9 | 1442.2 | 28209.0 |
| 2015-12-18 | FBON | Futures | 115.56 | 116.06 | 115.43 | 115.91 | 2742.0 |
| 2015-12-18 | FBTP | Futures | 104.48 | 104.93 | 104.42 | 104.86 | 55738.0 |
| 2015-12-18 | FBTS | Futures | 100.543 | 100.632 | 100.543 | 100.57 | 15717.0 |
| 2015-12-18 | FCE | Futures | 3886.5 | 3902.4 | 3825.0 | 3862.2 | 120467.0 |
| 2015-12-18 | FDAX | Futures | 11572.4 | 11643.4 | 11401.6 | 11503.0 | 99195.0 |
| 2015-12-18 | FDIV | Futures | 138.63 | 139.05 | 137.89 | 137.89 | 13.0 |
| 2015-12-18 | FDXM | Futures | 11064.9 | 11134.4 | 10907.3 | 10998.6 | 24190.0 |
| 2015-12-18 | FESX | Futures | 2489.4 | 2502.3 | 2448.3 | 2473.4 | 1468061.0 |
| 2015-12-18 | FEU3 | Futures | 98.877 | 98.877 | 98.873 | 98.873 | 216.0 |
| 2015-12-18 | FGBL | Futures | 139.77 | 140.32 | 139.7 | 140.15 | 436130.0 |
| 2015-12-18 | FGBM | Futures | 125.65 | 125.81 | 125.63 | 125.76 | 257364.0 |
| 2015-12-18 | FGBS | Futures | 111.438 | 111.463 | 111.433 | 111.453 | 115450.0 |
| 2015-12-18 | FGBX | Futures | 158.44 | 160.1 | 158.24 | 159.49 | 20287.0 |
| 2015-12-18 | FMWO | Futures | 5555.6 | 5563.1 | 5529.5 | 5537.0 | 183.0 |
| 2015-12-18 | FOAT | Futures | 128.11 | 128.55 | 128.01 | 128.37 | 48008.0 |
| 2015-12-18 | FTDX | Futures | 1728.1 | 1741.5 | 1723.3 | 1740.6 | 510.0 |
| 2015-12-18 | FTI | Futures | 381.47 | 382.17 | 376.62 | 379.33 | 47646.0 |
| 2015-12-18 | FTUK | Futures | 4910.7 | 4940.5 | 4852.4 | 4898.0 | 137457.0 |
| 2015-12-18 | FVSA | Futures | 2315.06 | 2404.47 | 2282.13 | 2338.59 | 6891.0 |
| 2015-12-18 | FXXP | Futures | 284.8 | 285.9 | 280.9 | 283.3 | 27912.0 |
| 2015-12-18 | G | Futures | 104.92 | 105.18 | 104.7 | 104.85 | 113133.0 |
> showing 50 of 109 rows — these rows as CSV