PREVIEW / futures_daily / 2011-02-09
file: by_date/futures_daily/2011/2011-02-09.parquet size: 9 KB rows: 94
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-02-09 | ES | Futures | 1300.78 | 1301.28 | 1291.19 | 1298.57 | 1825859.0 |
| 2011-02-09 | NQ | Futures | 2682.16 | 2685.56 | 2668.53 | 2681.87 | 198569.0 |
| 2011-02-09 | YM | Futures | 11408.0 | 11435.2 | 11374.3 | 11424.9 | 108339.0 |
| 2011-02-09 | CL | Futures | 177.7 | 178.92 | 175.69 | 176.4 | 367209.0 |
| 2011-02-09 | GC | Futures | 1850.8 | 1856.1 | 1843.4 | 1853.1 | 109183.0 |
| 2011-02-09 | ZN | Futures | 98.06082 | 98.736742 | 97.904837 | 98.645753 | 1451507.0 |
| 2011-02-09 | A6 | Futures | 0.85657 | 0.85733 | 0.85182 | 0.85267 | 87693.0 |
| 2011-02-09 | AD | Futures | 0.99691 | 1.00029 | 0.99612 | 0.99681 | 64107.0 |
| 2011-02-09 | B | Futures | 85.99 | 87.51 | 85.69 | 87.17 | 182465.0 |
| 2011-02-09 | B6 | Futures | 1.6672 | 1.6723 | 1.6626 | 1.6693 | 119649.0 |
| 2011-02-09 | BFX | Futures | 3151.1 | 3162.9 | 3132.6 | 3162.9 | 1323.0 |
| 2011-02-09 | BR | Futures | 0.25735 | 0.25864 | 0.25735 | 0.25842 | 284.0 |
| 2011-02-09 | BZ | Futures | 91.76 | 93.39 | 91.76 | 93.14 | 1418.0 |
| 2011-02-09 | C | Futures | 2322.0 | 2359.0 | 2316.0 | 2346.0 | 3260.0 |
| 2011-02-09 | CB | Futures | 117.042 | 117.042 | 115.575 | 116.162 | 31.0 |
| 2011-02-09 | CC | Futures | 2604.0 | 2674.0 | 2593.0 | 2639.0 | 10667.0 |
| 2011-02-09 | CSC | Futures | 4.284 | 4.284 | 4.245 | 4.263 | 39.0 |
| 2011-02-09 | CT | Futures | 150.32 | 156.31 | 148.92 | 154.85 | 18372.0 |
| 2011-02-09 | DC | Futures | 30.43 | 30.48 | 30.1 | 30.43 | 594.0 |
| 2011-02-09 | DX | Futures | 77.914 | 78.044 | 77.44 | 77.581 | 22296.0 |
| 2011-02-09 | E1 | Futures | 1.36093 | 1.3726 | 1.35687 | 1.3688 | 51288.0 |
| 2011-02-09 | E6 | Futures | 1.61154 | 1.62539 | 1.60941 | 1.6229 | 356255.0 |
| 2011-02-09 | E7 | Futures | 1.5993 | 1.6133 | 1.5973 | 1.6108 | 6675.0 |
| 2011-02-09 | EBM | Futures | 252.15 | 255.1 | 248.97 | 252.83 | 6250.0 |
| 2011-02-09 | ED | Futures | 94.8384 | 94.8527 | 94.8384 | 94.848 | 180040.0 |
| 2011-02-09 | ER | Futures | 97.262 | 97.271 | 97.242 | 97.262 | 115473.0 |
| 2011-02-09 | EW | Futures | 942.1 | 943.9 | 937.0 | 941.1 | 17498.0 |
| 2011-02-09 | FBTP | Futures | 63.89 | 64.12 | 63.84 | 63.89 | 4672.0 |
| 2011-02-09 | FCE | Futures | 2738.5 | 2750.5 | 2727.2 | 2731.8 | 106007.0 |
| 2011-02-09 | FDAX | Futures | 7843.0 | 7879.4 | 7837.1 | 7839.7 | 116642.0 |
| 2011-02-09 | FESX | Futures | 1889.3 | 1897.4 | 1880.0 | 1883.1 | 1026173.0 |
| 2011-02-09 | FEU3 | Futures | 97.81 | 97.82 | 97.81 | 97.82 | 27.0 |
| 2011-02-09 | FGBL | Futures | 97.02 | 97.32 | 96.86 | 96.88 | 884840.0 |
| 2011-02-09 | FGBM | Futures | 102.97 | 103.13 | 102.85 | 102.88 | 623283.0 |
| 2011-02-09 | FGBS | Futures | 106.487 | 106.581 | 106.468 | 106.487 | 739741.0 |
| 2011-02-09 | FGBX | Futures | 93.19 | 93.7 | 92.74 | 92.79 | 4274.0 |
| 2011-02-09 | FTDX | Futures | 791.2 | 796.9 | 788.1 | 790.7 | 508.0 |
| 2011-02-09 | FTI | Futures | 298.38 | 298.82 | 296.81 | 297.53 | 22628.0 |
| 2011-02-09 | FTUK | Futures | 4221.1 | 4221.1 | 4186.0 | 4191.2 | 80441.0 |
| 2011-02-09 | FXXP | Futures | 186.9 | 186.9 | 185.8 | 186.0 | 419.0 |
| 2011-02-09 | G | Futures | 79.39 | 79.56 | 79.24 | 79.26 | 76662.0 |
| 2011-02-09 | GF | Futures | 306.923 | 308.279 | 303.161 | 303.222 | 5740.0 |
| 2011-02-09 | GSCI | Futures | 1028.05 | 1035.45 | 1026.3 | 1033.46 | 3174.0 |
| 2011-02-09 | HE | Futures | 106.472 | 107.522 | 105.947 | 106.472 | 15724.0 |
| 2011-02-09 | HG | Futures | 6.1192 | 6.1359 | 5.9846 | 6.0292 | 41996.0 |
| 2011-02-09 | HO | Futures | 2.2852 | 2.3217 | 2.2808 | 2.3156 | 56867.0 |
| 2011-02-09 | HRC | Futures | 2815.6 | 2815.6 | 2815.6 | 2815.6 | 0.0 |
| 2011-02-09 | J1 | Futures | 0.0152603 | 0.0152804 | 0.0151925 | 0.0152478 | 128629.0 |
| 2011-02-09 | J7 | Futures | 0.015156 | 0.015171 | 0.015084 | 0.015139 | 400.0 |
| 2011-02-09 | JB | Futures | 119.96 | 119.96 | 119.56 | 119.85 | 3336.0 |
> showing 50 of 94 rows — these rows as CSV