PREVIEW / futures_daily / 2012-12-18
file: by_date/futures_daily/2012/2012-12-18.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-18 | ES | Futures | 1461.38 | 1476.98 | 1458.31 | 1474.42 | 2497775.0 |
| 2012-12-18 | NQ | Futures | 3073.34 | 3122.36 | 3070.74 | 3116.02 | 397730.0 |
| 2012-12-18 | YM | Futures | 12933.1 | 13048.8 | 12914.4 | 13018.4 | 143962.0 |
| 2012-12-18 | CL | Futures | 156.08 | 157.3 | 155.62 | 156.9 | 193195.0 |
| 2012-12-18 | GC | Futures | 2264.3 | 2271.3 | 2214.8 | 2226.4 | 180399.0 |
| 2012-12-18 | ZN | Futures | 116.707467 | 116.776377 | 116.252655 | 116.376694 | 1197143.0 |
| 2012-12-18 | A6 | Futures | 0.95856 | 0.95966 | 0.95582 | 0.9571 | 76381.0 |
| 2012-12-18 | AD | Futures | 1.01723 | 1.01773 | 1.01503 | 1.01563 | 52305.0 |
| 2012-12-18 | B | Futures | 100.69 | 101.62 | 100.64 | 101.49 | 137271.0 |
| 2012-12-18 | B6 | Futures | 1.6924 | 1.6999 | 1.6919 | 1.6975 | 83645.0 |
| 2012-12-18 | BFX | Futures | 2993.7 | 3003.1 | 2993.2 | 3003.1 | 808.0 |
| 2012-12-18 | BR | Futures | 0.23144 | 0.23274 | 0.23139 | 0.2326 | 36.0 |
| 2012-12-18 | BZ | Futures | 104.15 | 104.66 | 103.7 | 104.56 | 306.0 |
| 2012-12-18 | C | Futures | 1638.0 | 1639.0 | 1618.0 | 1620.0 | 5805.0 |
| 2012-12-18 | CB | Futures | 86.882 | 86.882 | 86.661 | 86.661 | 14.0 |
| 2012-12-18 | CC | Futures | 1826.0 | 1826.0 | 1801.0 | 1808.0 | 8318.0 |
| 2012-12-18 | CSC | Futures | 3.976 | 3.976 | 3.922 | 3.969 | 14.0 |
| 2012-12-18 | CT | Futures | 95.36 | 96.01 | 94.7 | 95.58 | 10708.0 |
| 2012-12-18 | DC | Futures | 29.69 | 29.76 | 29.21 | 29.62 | 128.0 |
| 2012-12-18 | DX | Futures | 76.788 | 76.817 | 76.47 | 76.564 | 21583.0 |
| 2012-12-18 | E1 | Futures | 1.40479 | 1.41328 | 1.4035 | 1.41135 | 22197.0 |
| 2012-12-18 | E6 | Futures | 1.55375 | 1.56295 | 1.55304 | 1.56047 | 181264.0 |
| 2012-12-18 | E7 | Futures | 1.5429 | 1.5522 | 1.5424 | 1.5498 | 2845.0 |
| 2012-12-18 | EBM | Futures | 285.35 | 285.91 | 282.01 | 282.85 | 22495.0 |
| 2012-12-18 | ED | Futures | 95.2342 | 95.239 | 95.2103 | 95.2247 | 306148.0 |
| 2012-12-18 | ER | Futures | 97.847 | 97.857 | 97.837 | 97.847 | 161842.0 |
| 2012-12-18 | EW | Futures | 1029.8 | 1044.4 | 1028.7 | 1043.7 | 41721.0 |
| 2012-12-18 | FBTP | Futures | 74.8 | 75.55 | 74.8 | 75.45 | 17222.0 |
| 2012-12-18 | FBTS | Futures | 90.612 | 90.79 | 90.527 | 90.756 | 3413.0 |
| 2012-12-18 | FCE | Futures | 2754.1 | 2758.7 | 2734.9 | 2749.2 | 160950.0 |
| 2012-12-18 | FDAX | Futures | 8349.7 | 8387.9 | 8334.4 | 8374.2 | 84351.0 |
| 2012-12-18 | FESX | Futures | 1796.1 | 1804.3 | 1788.6 | 1798.8 | 1016981.0 |
| 2012-12-18 | FEU3 | Futures | 98.458 | 98.458 | 98.448 | 98.453 | 17.0 |
| 2012-12-18 | FGBL | Futures | 119.49 | 119.72 | 119.11 | 119.36 | 513488.0 |
| 2012-12-18 | FGBM | Futures | 117.12 | 117.24 | 116.96 | 117.07 | 323827.0 |
| 2012-12-18 | FGBS | Futures | 110.492 | 110.522 | 110.477 | 110.492 | 224959.0 |
| 2012-12-18 | FGBX | Futures | 126.36 | 126.87 | 125.69 | 126.1 | 5182.0 |
| 2012-12-18 | FOAT | Futures | 105.93 | 105.99 | 105.58 | 105.75 | 21915.0 |
| 2012-12-18 | FTDX | Futures | 785.3 | 791.9 | 784.3 | 788.1 | 2317.0 |
| 2012-12-18 | FTI | Futures | 296.59 | 296.59 | 294.96 | 295.47 | 49011.0 |
| 2012-12-18 | FTUK | Futures | 4332.4 | 4353.4 | 4329.1 | 4345.3 | 171734.0 |
| 2012-12-18 | FVSA | Futures | 3959.49 | 3959.49 | 3786.89 | 3807.2 | 14571.0 |
| 2012-12-18 | FXXP | Futures | 201.3 | 201.8 | 201.1 | 201.7 | 38698.0 |
| 2012-12-18 | G | Futures | 98.12 | 98.13 | 97.61 | 97.72 | 118398.0 |
| 2012-12-18 | GF | Futures | 292.885 | 293.644 | 288.521 | 288.806 | 4805.0 |
| 2012-12-18 | GSCI | Futures | 1029.3 | 1033.09 | 1026.57 | 1030.99 | 202.0 |
| 2012-12-18 | HE | Futures | 97.404 | 98.867 | 96.974 | 97.863 | 13809.0 |
| 2012-12-18 | HG | Futures | 4.7231 | 4.734 | 4.6743 | 4.6917 | 37225.0 |
| 2012-12-18 | HH | Futures | 40.128 | 40.128 | 40.128 | 40.128 | 1716.0 |
| 2012-12-18 | HO | Futures | 2.3735 | 2.4127 | 2.3735 | 2.406 | 14436.0 |
> showing 50 of 101 rows — these rows as CSV