PREVIEW / futures_daily / 2012-01-19
file: by_date/futures_daily/2012/2012-01-19.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-01-19 | ES | Futures | 1307.4 | 1316.18 | 1303.88 | 1315.17 | 1837168.0 |
| 2012-01-19 | NQ | Futures | 2767.79 | 2793.23 | 2765.79 | 2773.51 | 185083.0 |
| 2012-01-19 | YM | Futures | 12094.2 | 12174.5 | 12074.9 | 12172.6 | 84063.0 |
| 2012-01-19 | CL | Futures | 189.41 | 191.08 | 187.12 | 187.9 | 284496.0 |
| 2012-01-19 | GC | Futures | 2242.2 | 2255.6 | 2226.7 | 2233.8 | 130752.0 |
| 2012-01-19 | ZN | Futures | 113.408299 | 113.529823 | 112.773677 | 112.949211 | 1274258.0 |
| 2012-01-19 | A6 | Futures | 0.9209 | 0.9225 | 0.91689 | 0.91956 | 102828.0 |
| 2012-01-19 | AD | Futures | 0.99037 | 0.99539 | 0.98967 | 0.99077 | 78058.0 |
| 2012-01-19 | B | Futures | 99.01 | 99.59 | 98.36 | 99.41 | 167280.0 |
| 2012-01-19 | B6 | Futures | 1.6123 | 1.6193 | 1.6106 | 1.6161 | 81310.0 |
| 2012-01-19 | BFX | Futures | 2598.2 | 2646.2 | 2594.3 | 2646.2 | 1280.0 |
| 2012-01-19 | BR | Futures | 0.26218 | 0.26279 | 0.26166 | 0.26166 | 95.0 |
| 2012-01-19 | BZ | Futures | 105.46 | 105.65 | 104.41 | 105.5 | 793.0 |
| 2012-01-19 | C | Futures | 1550.0 | 1570.0 | 1533.0 | 1567.0 | 8307.0 |
| 2012-01-19 | CB | Futures | 87.193 | 87.193 | 85.579 | 85.848 | 48.0 |
| 2012-01-19 | CC | Futures | 1778.0 | 1822.0 | 1769.0 | 1799.0 | 9437.0 |
| 2012-01-19 | CSC | Futures | 3.886 | 3.934 | 3.881 | 3.915 | 128.0 |
| 2012-01-19 | CT | Futures | 125.57 | 126.86 | 124.62 | 126.44 | 9162.0 |
| 2012-01-19 | DC | Futures | 28.02 | 28.23 | 27.64 | 28.14 | 879.0 |
| 2012-01-19 | DX | Futures | 78.561 | 78.649 | 78.089 | 78.259 | 21556.0 |
| 2012-01-19 | E1 | Futures | 1.39782 | 1.41003 | 1.39559 | 1.40648 | 26183.0 |
| 2012-01-19 | E6 | Futures | 1.5368 | 1.5509 | 1.53489 | 1.54636 | 285083.0 |
| 2012-01-19 | E7 | Futures | 1.5231 | 1.5367 | 1.521 | 1.5322 | 4025.0 |
| 2012-01-19 | EBM | Futures | 259.12 | 260.76 | 258.47 | 260.11 | 5566.0 |
| 2012-01-19 | ED | Futures | 95.0486 | 95.0581 | 95.0295 | 95.0486 | 189862.0 |
| 2012-01-19 | ER | Futures | 97.381 | 97.395 | 97.371 | 97.385 | 83013.0 |
| 2012-01-19 | EW | Futures | 926.2 | 938.2 | 921.7 | 935.8 | 18180.0 |
| 2012-01-19 | FBTP | Futures | 60.55 | 61.03 | 60.48 | 60.88 | 9567.0 |
| 2012-01-19 | FBTS | Futures | 82.04 | 82.281 | 82.008 | 82.153 | 914.0 |
| 2012-01-19 | FCE | Futures | 2341.3 | 2371.9 | 2330.3 | 2369.1 | 96127.0 |
| 2012-01-19 | FDAX | Futures | 7067.6 | 7097.4 | 6996.9 | 7086.9 | 140730.0 |
| 2012-01-19 | FESX | Futures | 1606.5 | 1627.3 | 1595.2 | 1625.3 | 1182038.0 |
| 2012-01-19 | FGBL | Futures | 112.99 | 113.09 | 112.36 | 112.45 | 709878.0 |
| 2012-01-19 | FGBM | Futures | 113.4 | 113.48 | 113.04 | 113.11 | 351340.0 |
| 2012-01-19 | FGBS | Futures | 109.864 | 109.889 | 109.805 | 109.825 | 360325.0 |
| 2012-01-19 | FGBX | Futures | 118.23 | 118.72 | 117.42 | 117.62 | 5344.0 |
| 2012-01-19 | FTDX | Futures | 695.3 | 698.5 | 694.4 | 697.2 | 164.0 |
| 2012-01-19 | FTI | Futures | 264.82 | 267.54 | 263.57 | 267.29 | 23676.0 |
| 2012-01-19 | FTUK | Futures | 4093.2 | 4116.3 | 4075.6 | 4114.1 | 98743.0 |
| 2012-01-19 | FVSA | Futures | 11427.75 | 11427.75 | 11024.42 | 11101.24 | 1763.0 |
| 2012-01-19 | FXXP | Futures | 179.0 | 181.0 | 178.7 | 180.7 | 2628.0 |
| 2012-01-19 | G | Futures | 95.03 | 95.06 | 94.33 | 94.41 | 159337.0 |
| 2012-01-19 | GF | Futures | 324.151 | 327.332 | 323.78 | 326.59 | 3048.0 |
| 2012-01-19 | GSCI | Futures | 1034.88 | 1039.26 | 1027.76 | 1031.36 | 117.0 |
| 2012-01-19 | HE | Futures | 106.438 | 106.74 | 105.682 | 105.743 | 11487.0 |
| 2012-01-19 | HG | Futures | 4.9561 | 5.0405 | 4.9555 | 5.0128 | 45970.0 |
| 2012-01-19 | HO | Futures | 2.4596 | 2.4645 | 2.434 | 2.4549 | 37908.0 |
| 2012-01-19 | HRC | Futures | 2876.8 | 2876.8 | 2876.8 | 2876.8 | 0.0 |
| 2012-01-19 | J1 | Futures | 0.0163586 | 0.0163812 | 0.0162481 | 0.016282 | 90035.0 |
| 2012-01-19 | J7 | Futures | 0.016292 | 0.016312 | 0.016182 | 0.016215 | 337.0 |
> showing 50 of 98 rows — these rows as CSV