PREVIEW / futures_daily / 2013-11-27
file: by_date/futures_daily/2013/2013-11-27.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-27 | ES | Futures | 1851.06 | 1856.71 | 1850.29 | 1853.37 | 849593.0 |
| 2013-11-27 | NQ | Futures | 3958.97 | 3987.97 | 3957.54 | 3983.67 | 146375.0 |
| 2013-11-27 | YM | Futures | 15979.6 | 16015.5 | 15962.7 | 15993.6 | 79001.0 |
| 2013-11-27 | CL | Futures | 165.42 | 165.6 | 162.36 | 163.3 | 230878.0 |
| 2013-11-27 | GC | Futures | 1643.3 | 1661.4 | 1635.8 | 1639.0 | 154819.0 |
| 2013-11-27 | ZN | Futures | 115.050992 | 115.079316 | 114.569489 | 114.88105 | 1537505.0 |
| 2013-11-27 | A6 | Futures | 0.86091 | 0.86204 | 0.85515 | 0.85619 | 76007.0 |
| 2013-11-27 | AD | Futures | 0.95793 | 0.95894 | 0.95257 | 0.95308 | 57341.0 |
| 2013-11-27 | B | Futures | 112.12 | 112.93 | 111.81 | 112.6 | 91242.0 |
| 2013-11-27 | B6 | Futures | 1.7016 | 1.714 | 1.7 | 1.7084 | 124746.0 |
| 2013-11-27 | BR | Futures | 0.22059 | 0.22059 | 0.2192 | 0.2192 | 258.0 |
| 2013-11-27 | BZ | Futures | 114.12 | 114.87 | 113.78 | 114.56 | 7708.0 |
| 2013-11-27 | C | Futures | 1869.0 | 1870.0 | 1838.0 | 1844.0 | 1405.0 |
| 2013-11-27 | CB | Futures | 75.564 | 75.564 | 74.828 | 75.564 | 22.0 |
| 2013-11-27 | CC | Futures | 2055.0 | 2069.0 | 2043.0 | 2053.0 | 7785.0 |
| 2013-11-27 | CSC | Futures | 3.484 | 3.488 | 3.482 | 3.482 | 11.0 |
| 2013-11-27 | CT | Futures | 90.2 | 90.45 | 88.3 | 89.44 | 13204.0 |
| 2013-11-27 | DC | Futures | 26.52 | 26.64 | 26.49 | 26.61 | 94.0 |
| 2013-11-27 | DX | Futures | 76.881 | 77.0 | 76.7 | 76.935 | 16928.0 |
| 2013-11-27 | E1 | Futures | 1.41732 | 1.42169 | 1.41346 | 1.41552 | 25411.0 |
| 2013-11-27 | E6 | Futures | 1.60106 | 1.60672 | 1.6 | 1.60177 | 158394.0 |
| 2013-11-27 | E7 | Futures | 1.591 | 1.5962 | 1.5898 | 1.5914 | 2831.0 |
| 2013-11-27 | ED | Futures | 95.3733 | 95.3733 | 95.3662 | 95.371 | 112923.0 |
| 2013-11-27 | ER | Futures | 97.876 | 97.881 | 97.871 | 97.871 | 38774.0 |
| 2013-11-27 | EW | Futures | 1329.8 | 1334.6 | 1328.4 | 1333.1 | 11525.0 |
| 2013-11-27 | FBTP | Futures | 81.95 | 82.07 | 81.73 | 81.97 | 32766.0 |
| 2013-11-27 | FBTS | Futures | 95.71 | 95.771 | 95.606 | 95.658 | 7807.0 |
| 2013-11-27 | FCE | Futures | 3324.5 | 3337.0 | 3314.4 | 3327.6 | 75158.0 |
| 2013-11-27 | FDAX | Futures | 10334.9 | 10395.4 | 10318.3 | 10380.4 | 73163.0 |
| 2013-11-27 | FESX | Futures | 2153.3 | 2165.9 | 2147.7 | 2161.0 | 683229.0 |
| 2013-11-27 | FGBL | Futures | 120.62 | 120.7 | 120.38 | 120.6 | 588978.0 |
| 2013-11-27 | FGBM | Futures | 118.41 | 118.56 | 118.39 | 118.51 | 370571.0 |
| 2013-11-27 | FGBS | Futures | 110.568 | 110.593 | 110.563 | 110.578 | 200723.0 |
| 2013-11-27 | FGBX | Futures | 121.49 | 121.49 | 120.82 | 121.2 | 13352.0 |
| 2013-11-27 | FMWO | Futures | 5359.8 | 5359.8 | 5359.8 | 5359.8 | 0.0 |
| 2013-11-27 | FOAT | Futures | 108.78 | 108.87 | 108.65 | 108.81 | 27562.0 |
| 2013-11-27 | FTDX | Futures | 1081.2 | 1084.5 | 1078.9 | 1084.5 | 173.0 |
| 2013-11-27 | FTI | Futures | 341.47 | 342.29 | 340.31 | 341.99 | 25476.0 |
| 2013-11-27 | FTUK | Futures | 4976.7 | 4998.4 | 4970.3 | 4988.3 | 90776.0 |
| 2013-11-27 | FVSA | Futures | 1900.03 | 1906.09 | 1875.83 | 1881.88 | 3692.0 |
| 2013-11-27 | FXXP | Futures | 235.9 | 236.9 | 235.3 | 236.4 | 3091.0 |
| 2013-11-27 | G | Futures | 92.26 | 92.44 | 91.99 | 92.21 | 155625.0 |
| 2013-11-27 | GF | Futures | 264.786 | 266.436 | 264.464 | 266.154 | 3208.0 |
| 2013-11-27 | GSCI | Futures | 1030.76 | 1030.76 | 1025.95 | 1029.1 | 8.0 |
| 2013-11-27 | HE | Futures | 109.54 | 110.385 | 109.117 | 109.268 | 14700.0 |
| 2013-11-27 | HG | Futures | 4.0505 | 4.084 | 4.0164 | 4.0296 | 47590.0 |
| 2013-11-27 | HH | Futures | 38.799 | 39.169 | 38.789 | 39.019 | 827.0 |
| 2013-11-27 | HO | Futures | 2.4303 | 2.4344 | 2.4206 | 2.4258 | 12109.0 |
| 2013-11-27 | HRC | Futures | 2388.8 | 2388.8 | 2388.8 | 2388.8 | 10.0 |
| 2013-11-27 | J1 | Futures | 0.0124231 | 0.0124369 | 0.0123136 | 0.0123224 | 99741.0 |
> showing 50 of 102 rows — these rows as CSV