PREVIEW / futures_daily / 2012-12-21
file: by_date/futures_daily/2012/2012-12-21.parquet size: 9 KB rows: 101
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-21 | ES | Futures | 1474.42 | 1474.68 | 1423.52 | 1459.08 | 2112856.0 |
| 2012-12-21 | NQ | Futures | 3105.63 | 3108.81 | 3040.75 | 3068.72 | 241714.0 |
| 2012-12-21 | YM | Futures | 13003.7 | 13009.6 | 12711.5 | 12881.1 | 139153.0 |
| 2012-12-21 | CL | Futures | 159.77 | 159.86 | 156.12 | 157.36 | 180375.0 |
| 2012-12-21 | GC | Futures | 2196.8 | 2212.8 | 2180.6 | 2212.3 | 136092.0 |
| 2012-12-21 | ZN | Futures | 116.555863 | 116.996892 | 116.486952 | 116.85907 | 706935.0 |
| 2012-12-21 | A6 | Futures | 0.95289 | 0.95353 | 0.94529 | 0.94612 | 95508.0 |
| 2012-12-21 | AD | Futures | 1.01322 | 1.01352 | 1.0055 | 1.0066 | 74349.0 |
| 2012-12-21 | B | Futures | 102.76 | 102.83 | 101.32 | 101.61 | 132659.0 |
| 2012-12-21 | B6 | Futures | 1.7007 | 1.7008 | 1.6875 | 1.6884 | 91489.0 |
| 2012-12-21 | BFX | Futures | 3006.2 | 3012.0 | 3003.9 | 3003.9 | 17.0 |
| 2012-12-21 | BR | Futures | 0.23475 | 0.23475 | 0.23385 | 0.23431 | 104.0 |
| 2012-12-21 | BZ | Futures | 105.85 | 105.85 | 104.41 | 104.68 | 571.0 |
| 2012-12-21 | C | Futures | 1572.0 | 1596.0 | 1561.0 | 1574.0 | 6437.0 |
| 2012-12-21 | CB | Futures | 86.009 | 86.166 | 86.009 | 86.166 | 5.0 |
| 2012-12-21 | CC | Futures | 1756.0 | 1778.0 | 1739.0 | 1744.0 | 10012.0 |
| 2012-12-21 | CSC | Futures | 3.856 | 3.916 | 3.856 | 3.905 | 39.0 |
| 2012-12-21 | CT | Futures | 95.14 | 96.0 | 94.75 | 95.87 | 7986.0 |
| 2012-12-21 | DC | Futures | 28.82 | 29.38 | 28.8 | 29.02 | 138.0 |
| 2012-12-21 | DX | Futures | 76.552 | 76.899 | 76.518 | 76.877 | 22721.0 |
| 2012-12-21 | E1 | Futures | 1.41483 | 1.41483 | 1.40505 | 1.40659 | 25782.0 |
| 2012-12-21 | E6 | Futures | 1.56401 | 1.56401 | 1.55328 | 1.55528 | 202083.0 |
| 2012-12-21 | E7 | Futures | 1.5533 | 1.5533 | 1.5427 | 1.5447 | 5856.0 |
| 2012-12-21 | EBM | Futures | 277.84 | 282.85 | 277.29 | 282.01 | 20202.0 |
| 2012-12-21 | ED | Futures | 95.2151 | 95.2247 | 95.2151 | 95.2151 | 58415.0 |
| 2012-12-21 | ER | Futures | 97.847 | 97.852 | 97.837 | 97.842 | 51702.0 |
| 2012-12-21 | EW | Futures | 1050.1 | 1050.1 | 1031.1 | 1040.8 | 19780.0 |
| 2012-12-21 | FBTP | Futures | 75.47 | 75.64 | 75.21 | 75.44 | 12345.0 |
| 2012-12-21 | FBTS | Futures | 90.959 | 90.993 | 90.815 | 90.917 | 1455.0 |
| 2012-12-21 | FCE | Futures | 2745.5 | 2776.4 | 2741.3 | 2761.7 | 110667.0 |
| 2012-12-21 | FDAX | Futures | 8320.2 | 8374.8 | 8306.5 | 8358.9 | 116167.0 |
| 2012-12-21 | FESX | Futures | 1790.0 | 1812.5 | 1788.6 | 1802.3 | 877360.0 |
| 2012-12-21 | FEU3 | Futures | 98.458 | 98.458 | 98.448 | 98.448 | 259.0 |
| 2012-12-21 | FGBL | Futures | 119.52 | 119.73 | 119.39 | 119.66 | 357454.0 |
| 2012-12-21 | FGBM | Futures | 117.23 | 117.35 | 117.14 | 117.29 | 230668.0 |
| 2012-12-21 | FGBS | Futures | 110.512 | 110.522 | 110.487 | 110.512 | 136883.0 |
| 2012-12-21 | FGBX | Futures | 127.08 | 127.49 | 126.66 | 126.98 | 8029.0 |
| 2012-12-21 | FOAT | Futures | 106.18 | 106.29 | 106.07 | 106.2 | 13885.0 |
| 2012-12-21 | FTDX | Futures | 790.5 | 791.9 | 785.3 | 790.5 | 185.0 |
| 2012-12-21 | FTI | Futures | 296.33 | 297.75 | 294.4 | 296.03 | 35432.0 |
| 2012-12-21 | FTUK | Futures | 4372.2 | 4372.2 | 4310.4 | 4341.3 | 113212.0 |
| 2012-12-21 | FVSA | Futures | 3878.27 | 4152.38 | 3878.27 | 4142.23 | 22000.0 |
| 2012-12-21 | FXXP | Futures | 202.3 | 202.3 | 200.8 | 201.9 | 5309.0 |
| 2012-12-21 | G | Futures | 97.95 | 98.31 | 97.87 | 98.21 | 72660.0 |
| 2012-12-21 | GF | Futures | 289.517 | 289.992 | 287.477 | 288.711 | 2082.0 |
| 2012-12-21 | GSCI | Futures | 1033.81 | 1035.34 | 1026.73 | 1028.18 | 88.0 |
| 2012-12-21 | HE | Futures | 98.953 | 99.814 | 98.724 | 99.728 | 12174.0 |
| 2012-12-21 | HG | Futures | 4.544 | 4.5966 | 4.5395 | 4.5806 | 44538.0 |
| 2012-12-21 | HH | Futures | 40.774 | 40.774 | 40.516 | 40.516 | 2757.0 |
| 2012-12-21 | HO | Futures | 2.4436 | 2.4461 | 2.4119 | 2.4151 | 19881.0 |
> showing 50 of 101 rows — these rows as CSV