PREVIEW / futures_daily / 2012-01-10
file: by_date/futures_daily/2012/2012-01-10.parquet size: 9 KB rows: 97
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-10 | ES | Futures | 1279.55 | 1296.61 | 1279.05 | 1290.59 | 1531383.0 |
| 2012-01-10 | NQ | Futures | 2683.45 | 2719.76 | 2683.16 | 2702.89 | 147334.0 |
| 2012-01-10 | YM | Futures | 11928.9 | 12052.7 | 11921.1 | 11982.1 | 90605.0 |
| 2012-01-10 | CL | Futures | 189.32 | 193.26 | 189.32 | 191.08 | 291273.0 |
| 2012-01-10 | GC | Futures | 2176.9 | 2216.1 | 2172.7 | 2202.8 | 168405.0 |
| 2012-01-10 | ZN | Futures | 113.030227 | 113.111242 | 112.73317 | 112.962714 | 742256.0 |
| 2012-01-10 | A6 | Futures | 0.90461 | 0.91423 | 0.90426 | 0.91209 | 93214.0 |
| 2012-01-10 | AD | Futures | 0.97843 | 0.98706 | 0.97843 | 0.98666 | 60638.0 |
| 2012-01-10 | B | Futures | 100.14 | 101.38 | 100.08 | 100.67 | 161609.0 |
| 2012-01-10 | B6 | Futures | 1.6154 | 1.6195 | 1.6136 | 1.6178 | 53615.0 |
| 2012-01-10 | BR | Futures | 0.25277 | 0.25675 | 0.25277 | 0.25675 | 858.0 |
| 2012-01-10 | BZ | Futures | 106.87 | 107.52 | 106.35 | 106.84 | 1291.0 |
| 2012-01-10 | C | Futures | 1501.0 | 1575.0 | 1500.0 | 1574.0 | 21106.0 |
| 2012-01-10 | CB | Futures | 90.692 | 90.692 | 89.884 | 89.884 | 28.0 |
| 2012-01-10 | CC | Futures | 1696.0 | 1837.0 | 1690.0 | 1809.0 | 25644.0 |
| 2012-01-10 | CSC | Futures | 4.032 | 4.042 | 4.032 | 4.042 | 9.0 |
| 2012-01-10 | CT | Futures | 124.29 | 125.03 | 123.26 | 124.88 | 10016.0 |
| 2012-01-10 | DC | Futures | 29.69 | 29.77 | 29.38 | 29.69 | 255.0 |
| 2012-01-10 | DX | Futures | 79.101 | 79.228 | 78.853 | 78.937 | 13990.0 |
| 2012-01-10 | E1 | Futures | 1.38364 | 1.38824 | 1.38154 | 1.38561 | 20109.0 |
| 2012-01-10 | E6 | Futures | 1.52676 | 1.53285 | 1.52365 | 1.52939 | 214390.0 |
| 2012-01-10 | E7 | Futures | 1.5134 | 1.5187 | 1.5098 | 1.5154 | 3632.0 |
| 2012-01-10 | EBM | Futures | 264.04 | 265.35 | 260.76 | 264.37 | 9579.0 |
| 2012-01-10 | ED | Futures | 94.996 | 95.0056 | 94.9769 | 95.0008 | 189046.0 |
| 2012-01-10 | ER | Futures | 97.346 | 97.346 | 97.297 | 97.317 | 139611.0 |
| 2012-01-10 | EW | Futures | 899.0 | 914.0 | 898.7 | 911.2 | 19545.0 |
| 2012-01-10 | FBTP | Futures | 57.44 | 57.59 | 57.17 | 57.42 | 5602.0 |
| 2012-01-10 | FBTS | Futures | 79.752 | 79.873 | 79.672 | 79.833 | 570.0 |
| 2012-01-10 | FCE | Futures | 2262.4 | 2306.1 | 2259.9 | 2299.7 | 75557.0 |
| 2012-01-10 | FDAX | Futures | 6730.8 | 6844.5 | 6708.7 | 6813.1 | 150734.0 |
| 2012-01-10 | FESX | Futures | 1539.7 | 1571.8 | 1536.3 | 1565.8 | 1174355.0 |
| 2012-01-10 | FGBL | Futures | 112.33 | 112.53 | 112.03 | 112.26 | 501918.0 |
| 2012-01-10 | FGBM | Futures | 113.1 | 113.2 | 112.86 | 112.97 | 338976.0 |
| 2012-01-10 | FGBS | Futures | 109.909 | 109.944 | 109.845 | 109.874 | 340147.0 |
| 2012-01-10 | FGBX | Futures | 117.7 | 117.96 | 117.01 | 117.59 | 3931.0 |
| 2012-01-10 | FTDX | Futures | 665.1 | 666.0 | 650.2 | 654.4 | 946.0 |
| 2012-01-10 | FTI | Futures | 261.72 | 264.61 | 261.64 | 263.27 | 15.0 |
| 2012-01-10 | FTUK | Futures | 4039.5 | 4093.6 | 4039.5 | 4087.8 | 100871.0 |
| 2012-01-10 | FVSA | Futures | 11962.4 | 11962.4 | 11444.03 | 11444.03 | 5453.0 |
| 2012-01-10 | FXXP | Futures | 175.1 | 176.8 | 174.8 | 176.6 | 3277.0 |
| 2012-01-10 | G | Futures | 94.67 | 94.69 | 94.18 | 94.25 | 112991.0 |
| 2012-01-10 | GF | Futures | 318.372 | 321.341 | 318.372 | 321.129 | 2686.0 |
| 2012-01-10 | GSCI | Futures | 1039.96 | 1050.91 | 1039.96 | 1047.39 | 1409.0 |
| 2012-01-10 | HE | Futures | 103.216 | 104.048 | 102.846 | 103.924 | 23543.0 |
| 2012-01-10 | HG | Futures | 4.5162 | 4.6396 | 4.4899 | 4.6336 | 42602.0 |
| 2012-01-10 | HO | Futures | 2.4816 | 2.5187 | 2.4803 | 2.5038 | 37505.0 |
| 2012-01-10 | HRC | Futures | 2876.8 | 2876.8 | 2876.8 | 2876.8 | 0.0 |
| 2012-01-10 | J1 | Futures | 0.0163485 | 0.0163686 | 0.0163398 | 0.0163624 | 42533.0 |
| 2012-01-10 | J7 | Futures | 0.016282 | 0.0163 | 0.016272 | 0.016295 | 315.0 |
| 2012-01-10 | JB | Futures | 124.56 | 124.7 | 124.51 | 124.57 | 1023.0 |
> showing 50 of 97 rows — these rows as CSV