PREVIEW / futures_daily / 2012-11-01
file: by_date/futures_daily/2012/2012-11-01.parquet size: 9 KB rows: 98
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-11-01 | ES | Futures | 1426.93 | 1450.34 | 1423.37 | 1448.56 | 1705976.0 |
| 2012-11-01 | NQ | Futures | 3031.0 | 3093.71 | 3022.94 | 3089.1 | 285578.0 |
| 2012-11-01 | YM | Futures | 12685.6 | 12901.4 | 12664.1 | 12855.5 | 121161.0 |
| 2012-11-01 | CL | Futures | 155.18 | 157.55 | 154.85 | 156.96 | 197179.0 |
| 2012-11-01 | GC | Futures | 2297.0 | 2306.4 | 2288.2 | 2290.4 | 121499.0 |
| 2012-11-01 | ZN | Futures | 116.862492 | 116.876226 | 116.601546 | 116.75262 | 815160.0 |
| 2012-11-01 | A6 | Futures | 0.93944 | 0.94334 | 0.93771 | 0.94171 | 99998.0 |
| 2012-11-01 | AD | Futures | 1.00278 | 1.0067 | 1.00128 | 1.00629 | 59852.0 |
| 2012-11-01 | B | Futures | 99.2 | 99.61 | 98.57 | 99.12 | 160897.0 |
| 2012-11-01 | B6 | Futures | 1.6841 | 1.6891 | 1.6834 | 1.6842 | 94345.0 |
| 2012-11-01 | BR | Futures | 0.23828 | 0.23828 | 0.23828 | 0.23828 | 284.0 |
| 2012-11-01 | BZ | Futures | 102.26 | 102.71 | 101.76 | 102.21 | 576.0 |
| 2012-11-01 | C | Futures | 1567.0 | 1585.0 | 1557.0 | 1583.0 | 3017.0 |
| 2012-11-01 | CB | Futures | 92.327 | 92.327 | 92.327 | 92.327 | 2.0 |
| 2012-11-01 | CC | Futures | 1801.0 | 1830.0 | 1793.0 | 1825.0 | 11880.0 |
| 2012-11-01 | CSC | Futures | 4.124 | 4.137 | 4.124 | 4.124 | 22.0 |
| 2012-11-01 | CT | Futures | 90.77 | 91.3 | 90.07 | 90.6 | 18986.0 |
| 2012-11-01 | DC | Futures | 30.83 | 30.99 | 30.66 | 30.91 | 234.0 |
| 2012-11-01 | DX | Futures | 77.479 | 77.673 | 77.416 | 77.621 | 18563.0 |
| 2012-11-01 | E1 | Futures | 1.38252 | 1.38548 | 1.37866 | 1.38175 | 23203.0 |
| 2012-11-01 | E6 | Futures | 1.52626 | 1.52944 | 1.52261 | 1.52403 | 189227.0 |
| 2012-11-01 | E7 | Futures | 1.5172 | 1.5203 | 1.5134 | 1.5149 | 3243.0 |
| 2012-11-01 | ED | Futures | 95.2349 | 95.2396 | 95.2253 | 95.2349 | 90624.0 |
| 2012-11-01 | ER | Futures | 97.862 | 97.871 | 97.857 | 97.866 | 105678.0 |
| 2012-11-01 | EW | Futures | 992.1 | 1021.1 | 988.9 | 1019.7 | 38026.0 |
| 2012-11-01 | FBTP | Futures | 72.18 | 72.68 | 72.18 | 72.5 | 11435.0 |
| 2012-11-01 | FBTS | Futures | 89.541 | 89.751 | 89.541 | 89.726 | 1162.0 |
| 2012-11-01 | FCE | Futures | 2573.4 | 2617.8 | 2563.3 | 2611.4 | 93575.0 |
| 2012-11-01 | FDAX | Futures | 7963.0 | 8062.7 | 7938.4 | 8034.2 | 113413.0 |
| 2012-11-01 | FESX | Futures | 1701.5 | 1728.7 | 1694.7 | 1721.9 | 804865.0 |
| 2012-11-01 | FEU3 | Futures | 98.483 | 98.487 | 98.483 | 98.487 | 600.0 |
| 2012-11-01 | FGBL | Futures | 118.36 | 118.54 | 118.23 | 118.44 | 515621.0 |
| 2012-11-01 | FGBM | Futures | 116.39 | 116.52 | 116.36 | 116.46 | 280736.0 |
| 2012-11-01 | FGBS | Futures | 110.363 | 110.402 | 110.353 | 110.382 | 218688.0 |
| 2012-11-01 | FGBX | Futures | 125.34 | 125.87 | 125.09 | 125.55 | 7494.0 |
| 2012-11-01 | FOAT | Futures | 103.65 | 103.81 | 103.65 | 103.77 | 15817.0 |
| 2012-11-01 | FTDX | Futures | 752.8 | 759.9 | 752.8 | 758.9 | 22.0 |
| 2012-11-01 | FTI | Futures | 283.55 | 287.5 | 282.39 | 286.98 | 30169.0 |
| 2012-11-01 | FTUK | Futures | 4217.5 | 4277.5 | 4210.6 | 4270.9 | 90333.0 |
| 2012-11-01 | FVSA | Futures | 5138.76 | 5138.76 | 4856.41 | 4856.41 | 4637.0 |
| 2012-11-01 | FXXP | Futures | 194.8 | 197.1 | 194.7 | 196.9 | 1844.0 |
| 2012-11-01 | G | Futures | 98.34 | 98.38 | 98.07 | 98.27 | 153388.0 |
| 2012-11-01 | GF | Futures | 280.403 | 281.315 | 277.571 | 277.763 | 2340.0 |
| 2012-11-01 | GSCI | Futures | 1031.51 | 1036.44 | 1028.19 | 1031.27 | 179.0 |
| 2012-11-01 | HE | Futures | 97.543 | 98.755 | 96.766 | 96.798 | 26810.0 |
| 2012-11-01 | HG | Futures | 4.5152 | 4.5865 | 4.5132 | 4.5646 | 45231.0 |
| 2012-11-01 | HH | Futures | 42.968 | 43.038 | 42.526 | 43.038 | 507.0 |
| 2012-11-01 | HO | Futures | 2.4751 | 2.4831 | 2.4499 | 2.4585 | 83963.0 |
| 2012-11-01 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-11-01 | J1 | Futures | 0.0156928 | 0.0157003 | 0.0156151 | 0.0156202 | 75964.0 |
> showing 50 of 98 rows — these rows as CSV