PREVIEW / futures_daily / 2011-10-20
file: by_date/futures_daily/2011/2011-10-20.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-20 | ES | Futures | 1204.63 | 1214.12 | 1190.41 | 1207.88 | 2898123.0 |
| 2011-10-20 | NQ | Futures | 2643.9 | 2662.73 | 2589.39 | 2626.49 | 351193.0 |
| 2011-10-20 | YM | Futures | 10994.7 | 11071.6 | 10884.3 | 11020.7 | 147709.0 |
| 2011-10-20 | CL | Futures | 161.71 | 163.44 | 158.0 | 161.47 | 389241.0 |
| 2011-10-20 | GC | Futures | 2221.4 | 2223.0 | 2166.6 | 2177.7 | 188355.0 |
| 2011-10-20 | ZN | Futures | 110.503828 | 110.865828 | 110.18205 | 110.436791 | 1335078.0 |
| 2011-10-20 | A6 | Futures | 0.89371 | 0.89961 | 0.88606 | 0.89565 | 207006.0 |
| 2011-10-20 | AD | Futures | 0.98004 | 0.98615 | 0.97504 | 0.98535 | 108717.0 |
| 2011-10-20 | B | Futures | 94.86 | 96.32 | 93.82 | 95.96 | 268946.0 |
| 2011-10-20 | B6 | Futures | 1.6449 | 1.6487 | 1.6357 | 1.6466 | 119347.0 |
| 2011-10-20 | BFX | Futures | 2531.6 | 2545.8 | 2519.8 | 2519.8 | 95.0 |
| 2011-10-20 | BR | Futures | 0.25002 | 0.25092 | 0.24803 | 0.2488 | 185.0 |
| 2011-10-20 | BZ | Futures | 99.79 | 101.76 | 99.17 | 101.42 | 1872.0 |
| 2011-10-20 | C | Futures | 1766.0 | 1784.0 | 1763.0 | 1769.0 | 6286.0 |
| 2011-10-20 | CC | Futures | 2031.0 | 2047.0 | 1996.0 | 2009.0 | 10185.0 |
| 2011-10-20 | CSC | Futures | 3.952 | 3.952 | 3.952 | 3.952 | 5.0 |
| 2011-10-20 | CT | Futures | 128.41 | 128.97 | 124.77 | 124.87 | 14392.0 |
| 2011-10-20 | DC | Futures | 28.41 | 28.41 | 27.82 | 28.06 | 358.0 |
| 2011-10-20 | DX | Futures | 75.95 | 76.368 | 75.563 | 75.824 | 35127.0 |
| 2011-10-20 | E1 | Futures | 1.45543 | 1.47078 | 1.44598 | 1.46842 | 36617.0 |
| 2011-10-20 | E6 | Futures | 1.64354 | 1.65381 | 1.63134 | 1.64497 | 428480.0 |
| 2011-10-20 | E7 | Futures | 1.6296 | 1.6396 | 1.6173 | 1.6309 | 7262.0 |
| 2011-10-20 | ED | Futures | 94.965 | 94.9746 | 94.9459 | 94.9602 | 138575.0 |
| 2011-10-20 | ER | Futures | 97.179 | 97.194 | 97.149 | 97.169 | 131516.0 |
| 2011-10-20 | EW | Futures | 842.4 | 849.4 | 823.7 | 841.3 | 37116.0 |
| 2011-10-20 | FBTP | Futures | 61.31 | 61.39 | 60.63 | 60.91 | 7822.0 |
| 2011-10-20 | FBTS | Futures | 81.671 | 81.727 | 81.293 | 81.55 | 1420.0 |
| 2011-10-20 | FCE | Futures | 2235.9 | 2257.8 | 2201.8 | 2211.1 | 84723.0 |
| 2011-10-20 | FDAX | Futures | 6324.9 | 6433.5 | 6247.8 | 6278.2 | 220150.0 |
| 2011-10-20 | FESX | Futures | 1519.8 | 1541.1 | 1499.2 | 1507.2 | 1704905.0 |
| 2011-10-20 | FEU3 | Futures | 97.712 | 97.727 | 97.712 | 97.727 | 200.0 |
| 2011-10-20 | FGBL | Futures | 109.61 | 109.99 | 108.92 | 109.57 | 985375.0 |
| 2011-10-20 | FGBM | Futures | 110.47 | 110.64 | 110.04 | 110.39 | 579089.0 |
| 2011-10-20 | FGBS | Futures | 108.93 | 108.979 | 108.776 | 108.88 | 665395.0 |
| 2011-10-20 | FGBX | Futures | 110.48 | 111.41 | 109.19 | 110.55 | 4501.0 |
| 2011-10-20 | FTDX | Futures | 592.0 | 634.3 | 592.0 | 623.3 | 113.0 |
| 2011-10-20 | FTI | Futures | 245.69 | 249.0 | 244.32 | 246.47 | 24157.0 |
| 2011-10-20 | FTUK | Futures | 3862.6 | 3884.5 | 3827.8 | 3842.5 | 132064.0 |
| 2011-10-20 | FVSA | Futures | 16376.47 | 17001.53 | 16043.11 | 16876.52 | 3229.0 |
| 2011-10-20 | FXXP | Futures | 162.4 | 164.2 | 162.1 | 162.3 | 6509.0 |
| 2011-10-20 | G | Futures | 90.86 | 91.12 | 90.38 | 90.75 | 129273.0 |
| 2011-10-20 | GF | Futures | 314.916 | 316.133 | 312.095 | 314.308 | 3356.0 |
| 2011-10-20 | GSCI | Futures | 980.94 | 982.82 | 963.63 | 980.16 | 195.0 |
| 2011-10-20 | HE | Futures | 116.392 | 116.778 | 114.11 | 115.653 | 15487.0 |
| 2011-10-20 | HG | Futures | 4.263 | 4.2808 | 4.0109 | 4.0459 | 63339.0 |
| 2011-10-20 | HO | Futures | 2.3998 | 2.4344 | 2.3806 | 2.4311 | 51213.0 |
| 2011-10-20 | HRC | Futures | 2706.8 | 2706.8 | 2706.8 | 2706.8 | 0.0 |
| 2011-10-20 | J1 | Futures | 0.0163637 | 0.0163989 | 0.0163084 | 0.0163624 | 102785.0 |
| 2011-10-20 | J7 | Futures | 0.016261 | 0.016298 | 0.016208 | 0.016263 | 640.0 |
| 2011-10-20 | JB | Futures | 124.01 | 124.28 | 124.01 | 124.26 | 2220.0 |
> showing 50 of 97 rows — these rows as CSV