PREVIEW / futures_daily / 2012-12-05
file: by_date/futures_daily/2012/2012-12-05.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-05 | ES | Futures | 1427.7 | 1439.91 | 1421.59 | 1433.29 | 2045099.0 |
| 2012-12-05 | NQ | Futures | 3061.78 | 3082.78 | 3018.05 | 3034.74 | 361358.0 |
| 2012-12-05 | YM | Futures | 12615.3 | 12768.6 | 12601.6 | 12717.8 | 173092.0 |
| 2012-12-05 | CL | Futures | 158.46 | 159.45 | 156.6 | 157.35 | 220850.0 |
| 2012-12-05 | GC | Futures | 2262.4 | 2276.5 | 2246.8 | 2257.2 | 157791.0 |
| 2012-12-05 | ZN | Futures | 117.865073 | 118.126019 | 117.782669 | 118.029881 | 41867.0 |
| 2012-12-05 | A6 | Futures | 0.94998 | 0.95198 | 0.94798 | 0.94971 | 114378.0 |
| 2012-12-05 | AD | Futures | 1.01021 | 1.01272 | 1.00931 | 1.01222 | 75615.0 |
| 2012-12-05 | B | Futures | 101.57 | 102.25 | 100.45 | 100.66 | 114598.0 |
| 2012-12-05 | B6 | Futures | 1.6814 | 1.6835 | 1.6796 | 1.6812 | 99409.0 |
| 2012-12-05 | BFX | Futures | 2961.9 | 2966.4 | 2940.1 | 2946.8 | 129.0 |
| 2012-12-05 | BR | Futures | 0.23056 | 0.23196 | 0.23014 | 0.23088 | 467.0 |
| 2012-12-05 | BZ | Futures | 104.73 | 105.32 | 103.7 | 103.7 | 237.0 |
| 2012-12-05 | C | Futures | 1618.0 | 1625.0 | 1602.0 | 1610.0 | 9120.0 |
| 2012-12-05 | CB | Futures | 87.573 | 88.498 | 87.573 | 88.498 | 5.0 |
| 2012-12-05 | CC | Futures | 1850.0 | 1860.0 | 1822.0 | 1826.0 | 11433.0 |
| 2012-12-05 | CSC | Futures | 3.92 | 3.92 | 3.92 | 3.92 | 2.0 |
| 2012-12-05 | CT | Futures | 91.76 | 92.2 | 91.15 | 91.92 | 9492.0 |
| 2012-12-05 | DC | Futures | 29.13 | 29.18 | 28.91 | 29.12 | 136.0 |
| 2012-12-05 | DX | Futures | 77.121 | 77.339 | 77.068 | 77.26 | 17874.0 |
| 2012-12-05 | E1 | Futures | 1.38934 | 1.39166 | 1.38419 | 1.38973 | 29890.0 |
| 2012-12-05 | E6 | Futures | 1.54228 | 1.54616 | 1.53804 | 1.54028 | 253686.0 |
| 2012-12-05 | E7 | Futures | 1.5326 | 1.5368 | 1.5288 | 1.5311 | 2611.0 |
| 2012-12-05 | EBM | Futures | 296.48 | 297.31 | 295.36 | 297.03 | 10728.0 |
| 2012-12-05 | ED | Futures | 95.2349 | 95.2372 | 95.2325 | 95.2325 | 107510.0 |
| 2012-12-05 | ER | Futures | 97.881 | 97.886 | 97.876 | 97.881 | 58513.0 |
| 2012-12-05 | EW | Futures | 1015.6 | 1023.3 | 1010.1 | 1019.3 | 23785.0 |
| 2012-12-05 | FBTP | Futures | 75.59 | 75.6 | 75.1 | 75.32 | 33743.0 |
| 2012-12-05 | FBTS | Futures | 90.739 | 90.773 | 90.629 | 90.731 | 3626.0 |
| 2012-12-05 | FCE | Futures | 2713.0 | 2727.0 | 2692.3 | 2704.7 | 95339.0 |
| 2012-12-05 | FDAX | Futures | 8216.1 | 8224.3 | 8138.3 | 8156.4 | 130725.0 |
| 2012-12-05 | FESX | Futures | 1775.0 | 1779.1 | 1755.3 | 1760.7 | 940162.0 |
| 2012-12-05 | FGBL | Futures | 119.3 | 120.0 | 119.22 | 119.93 | 983158.0 |
| 2012-12-05 | FGBM | Futures | 116.84 | 117.24 | 116.8 | 117.21 | 611443.0 |
| 2012-12-05 | FGBS | Futures | 110.432 | 110.507 | 110.432 | 110.492 | 584494.0 |
| 2012-12-05 | FGBX | Futures | 126.16 | 127.19 | 125.85 | 127.08 | 23004.0 |
| 2012-12-05 | FOAT | Futures | 105.72 | 106.04 | 105.51 | 105.99 | 57009.0 |
| 2012-12-05 | FTDX | Futures | 785.3 | 786.2 | 783.4 | 784.8 | 192.0 |
| 2012-12-05 | FTI | Futures | 291.14 | 292.0 | 289.34 | 290.46 | 22781.0 |
| 2012-12-05 | FTUK | Futures | 4295.5 | 4330.6 | 4292.5 | 4303.9 | 77129.0 |
| 2012-12-05 | FVSA | Futures | 4024.44 | 4150.92 | 3989.94 | 4116.43 | 4267.0 |
| 2012-12-05 | FXXP | Futures | 200.5 | 200.5 | 199.2 | 199.7 | 1443.0 |
| 2012-12-05 | G | Futures | 98.79 | 99.29 | 98.31 | 99.23 | 177114.0 |
| 2012-12-05 | GF | Futures | 276.472 | 278.417 | 275.95 | 277.8 | 3022.0 |
| 2012-12-05 | GSCI | Futures | 1043.52 | 1044.16 | 1034.08 | 1039.89 | 91.0 |
| 2012-12-05 | HE | Futures | 98.179 | 98.953 | 97.806 | 98.294 | 14845.0 |
| 2012-12-05 | HG | Futures | 4.7026 | 4.7437 | 4.6885 | 4.734 | 46292.0 |
| 2012-12-05 | HH | Futures | 43.439 | 43.439 | 43.439 | 43.439 | 2786.0 |
| 2012-12-05 | HO | Futures | 2.4361 | 2.4457 | 2.4056 | 2.4115 | 17447.0 |
| 2012-12-05 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
> showing 50 of 101 rows — these rows as CSV