PREVIEW / futures_daily / 2011-12-27
file: by_date/futures_daily/2011/2011-12-27.parquet size: 9 KB rows: 90
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-12-27 | ES | Futures | 1265.0 | 1268.51 | 1260.48 | 1264.74 | 508261.0 |
| 2011-12-27 | NQ | Futures | 2607.4 | 2626.27 | 2601.68 | 2612.55 | 73764.0 |
| 2011-12-27 | YM | Futures | 11832.2 | 11856.3 | 11785.7 | 11816.7 | 35166.0 |
| 2011-12-27 | CL | Futures | 186.74 | 190.2 | 185.71 | 189.4 | 124238.0 |
| 2011-12-27 | GC | Futures | 2172.7 | 2172.7 | 2148.2 | 2154.2 | 46351.0 |
| 2011-12-27 | ZN | Futures | 112.287584 | 112.42261 | 112.152558 | 112.301087 | 173791.0 |
| 2011-12-27 | A6 | Futures | 0.89607 | 0.89749 | 0.89465 | 0.89732 | 21265.0 |
| 2011-12-27 | AD | Futures | 0.98164 | 0.98435 | 0.97943 | 0.98415 | 15445.0 |
| 2011-12-27 | B | Futures | 95.71 | 96.96 | 95.49 | 96.76 | 20843.0 |
| 2011-12-27 | B6 | Futures | 1.6351 | 1.6379 | 1.6329 | 1.6367 | 21226.0 |
| 2011-12-27 | BFX | Futures | 2469.8 | 2469.8 | 2466.4 | 2466.4 | 2.0 |
| 2011-12-27 | BR | Futures | 0.24844 | 0.24844 | 0.24844 | 0.24844 | 181.0 |
| 2011-12-27 | BZ | Futures | 101.64 | 102.68 | 101.6 | 102.68 | 155.0 |
| 2011-12-27 | CC | Futures | 1706.0 | 1740.0 | 1695.0 | 1718.0 | 2728.0 |
| 2011-12-27 | CSC | Futures | 3.952 | 3.952 | 3.952 | 3.952 | 4.0 |
| 2011-12-27 | CT | Futures | 112.37 | 113.49 | 112.36 | 113.22 | 2302.0 |
| 2011-12-27 | DC | Futures | 28.59 | 28.8 | 28.59 | 28.71 | 33.0 |
| 2011-12-27 | DX | Futures | 78.011 | 78.094 | 77.904 | 77.997 | 5655.0 |
| 2011-12-27 | E1 | Futures | 1.40727 | 1.41003 | 1.40675 | 1.40832 | 6022.0 |
| 2011-12-27 | E6 | Futures | 1.56453 | 1.56549 | 1.5625 | 1.56381 | 37818.0 |
| 2011-12-27 | E7 | Futures | 1.5496 | 1.5511 | 1.5481 | 1.5495 | 774.0 |
| 2011-12-27 | EBM | Futures | 245.04 | 250.28 | 241.76 | 249.62 | 4800.0 |
| 2011-12-27 | ED | Futures | 94.8575 | 94.8862 | 94.8575 | 94.8814 | 31085.0 |
| 2011-12-27 | ER | Futures | 97.184 | 97.248 | 97.184 | 97.238 | 30767.0 |
| 2011-12-27 | EW | Futures | 887.5 | 894.9 | 884.0 | 889.8 | 13149.0 |
| 2011-12-27 | FBTP | Futures | 58.08 | 58.21 | 57.69 | 58.21 | 2065.0 |
| 2011-12-27 | FBTS | Futures | 79.841 | 79.857 | 79.648 | 79.857 | 96.0 |
| 2011-12-27 | FCE | Futures | 2231.3 | 2243.5 | 2218.0 | 2223.1 | 19167.0 |
| 2011-12-27 | FDAX | Futures | 6521.0 | 6550.8 | 6498.3 | 6522.6 | 32515.0 |
| 2011-12-27 | FESX | Futures | 1533.0 | 1539.7 | 1523.6 | 1529.0 | 181859.0 |
| 2011-12-27 | FGBL | Futures | 111.65 | 112.18 | 111.27 | 111.66 | 90892.0 |
| 2011-12-27 | FGBM | Futures | 112.61 | 112.93 | 112.44 | 112.76 | 76530.0 |
| 2011-12-27 | FGBS | Futures | 109.785 | 109.889 | 109.765 | 109.874 | 94104.0 |
| 2011-12-27 | FGBX | Futures | 117.01 | 117.83 | 116.73 | 117.62 | 610.0 |
| 2011-12-27 | FTDX | Futures | 631.7 | 632.6 | 625.2 | 627.5 | 149.0 |
| 2011-12-27 | FTI | Futures | 259.46 | 261.68 | 258.54 | 259.84 | 11844.0 |
| 2011-12-27 | FVSA | Futures | 12440.9 | 12480.77 | 12420.96 | 12480.77 | 688.0 |
| 2011-12-27 | FXXP | Futures | 171.2 | 171.2 | 169.2 | 169.8 | 2744.0 |
| 2011-12-27 | GF | Futures | 317.618 | 317.888 | 315.303 | 316.972 | 1514.0 |
| 2011-12-27 | GSCI | Futures | 1011.34 | 1027.34 | 1011.34 | 1022.71 | 194.0 |
| 2011-12-27 | HE | Futures | 105.835 | 105.958 | 105.188 | 105.712 | 8062.0 |
| 2011-12-27 | HG | Futures | 4.5571 | 4.5584 | 4.4384 | 4.4965 | 11850.0 |
| 2011-12-27 | HO | Futures | 2.3557 | 2.3836 | 2.3464 | 2.3624 | 11853.0 |
| 2011-12-27 | HRC | Futures | 2825.8 | 2825.8 | 2825.8 | 2825.8 | 0.0 |
| 2011-12-27 | J1 | Futures | 0.0161451 | 0.0161966 | 0.0161439 | 0.0161564 | 21784.0 |
| 2011-12-27 | J7 | Futures | 0.016075 | 0.016131 | 0.016075 | 0.01609 | 98.0 |
| 2011-12-27 | JB | Futures | 124.61 | 124.63 | 124.44 | 124.46 | 1309.0 |
| 2011-12-27 | KC | Futures | 505.79 | 516.56 | 505.79 | 516.21 | 2989.0 |
| 2011-12-27 | KE | Futures | 2501.31 | 2576.77 | 2500.39 | 2561.13 | 5557.0 |
| 2011-12-27 | LBS | Futures | 424.6 | 433.6 | 424.6 | 429.7 | 305.0 |
> showing 50 of 90 rows — these rows as CSV