PREVIEW / futures_daily / 2012-12-10
file: by_date/futures_daily/2012/2012-12-10.parquet size: 9 KB rows: 94
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-10 | ES | Futures | 1441.18 | 1446.27 | 1435.84 | 1445.51 | 1136090.0 |
| 2012-12-10 | NQ | Futures | 3034.16 | 3061.49 | 3021.22 | 3049.7 | 211325.0 |
| 2012-12-10 | YM | Futures | 12834.0 | 12867.4 | 12781.1 | 12861.5 | 2245.0 |
| 2012-12-10 | CL | Futures | 153.95 | 155.38 | 152.79 | 153.2 | 211603.0 |
| 2012-12-10 | GC | Futures | 2272.7 | 2290.5 | 2269.9 | 2284.7 | 84330.0 |
| 2012-12-10 | ZN | Futures | 117.837605 | 118.044338 | 117.796258 | 117.865169 | 521331.0 |
| 2012-12-10 | A6 | Futures | 0.95243 | 0.95417 | 0.9506 | 0.95234 | 24629.0 |
| 2012-12-10 | AD | Futures | 1.01382 | 1.01442 | 1.01192 | 1.01352 | 22145.0 |
| 2012-12-10 | B | Futures | 99.09 | 100.26 | 98.78 | 99.04 | 158599.0 |
| 2012-12-10 | B6 | Futures | 1.6747 | 1.6816 | 1.673 | 1.6789 | 15566.0 |
| 2012-12-10 | BR | Futures | 0.23372 | 0.23372 | 0.23274 | 0.23341 | 286.0 |
| 2012-12-10 | BZ | Futures | 102.49 | 102.53 | 102.03 | 102.03 | 789.0 |
| 2012-12-10 | C | Futures | 1643.0 | 1652.0 | 1623.0 | 1629.0 | 17261.0 |
| 2012-12-10 | CC | Futures | 1812.0 | 1816.0 | 1790.0 | 1795.0 | 11289.0 |
| 2012-12-10 | CSC | Futures | 3.914 | 3.916 | 3.905 | 3.912 | 39.0 |
| 2012-12-10 | CT | Futures | 92.94 | 93.55 | 92.21 | 92.37 | 10014.0 |
| 2012-12-10 | DC | Futures | 28.88 | 29.01 | 28.88 | 28.99 | 76.0 |
| 2012-12-10 | DX | Futures | 77.878 | 77.878 | 77.579 | 77.613 | 8364.0 |
| 2012-12-10 | E1 | Futures | 1.37737 | 1.38239 | 1.37647 | 1.38175 | 6156.0 |
| 2012-12-10 | E6 | Futures | 1.52238 | 1.52839 | 1.52143 | 1.52757 | 17015.0 |
| 2012-12-10 | E7 | Futures | 1.5133 | 1.518 | 1.511 | 1.5171 | 235.0 |
| 2012-12-10 | EBM | Futures | 298.15 | 298.42 | 295.92 | 296.2 | 9696.0 |
| 2012-12-10 | ED | Futures | 95.2342 | 95.2342 | 95.2247 | 95.2295 | 98629.0 |
| 2012-12-10 | ER | Futures | 97.891 | 97.906 | 97.881 | 97.886 | 104737.0 |
| 2012-12-10 | EW | Futures | 1020.8 | 1027.2 | 1020.8 | 1027.2 | 38.0 |
| 2012-12-10 | FBTP | Futures | 74.39 | 74.39 | 72.87 | 73.4 | 52932.0 |
| 2012-12-10 | FBTS | Futures | 90.104 | 90.256 | 89.621 | 89.968 | 7939.0 |
| 2012-12-10 | FCE | Futures | 2721.7 | 2728.9 | 2693.0 | 2720.2 | 93118.0 |
| 2012-12-10 | FDAX | Futures | 8241.3 | 8262.1 | 8170.1 | 8251.1 | 107144.0 |
| 2012-12-10 | FESX | Futures | 1768.2 | 1768.9 | 1742.3 | 1762.0 | 63380.0 |
| 2012-12-10 | FEU3 | Futures | 98.492 | 98.492 | 98.492 | 98.492 | 67.0 |
| 2012-12-10 | FGBL | Futures | 120.52 | 120.82 | 120.3 | 120.35 | 553848.0 |
| 2012-12-10 | FGBM | Futures | 117.66 | 117.8 | 117.54 | 117.55 | 288322.0 |
| 2012-12-10 | FGBS | Futures | 110.667 | 110.697 | 110.637 | 110.652 | 195196.0 |
| 2012-12-10 | FGBX | Futures | 127.36 | 127.94 | 127.02 | 127.23 | 9326.0 |
| 2012-12-10 | FOAT | Futures | 106.47 | 106.68 | 106.2 | 106.37 | 25330.0 |
| 2012-12-10 | FTDX | Futures | 786.2 | 787.7 | 786.2 | 787.7 | 2.0 |
| 2012-12-10 | FTI | Futures | 293.71 | 294.96 | 293.15 | 294.7 | 6589.0 |
| 2012-12-10 | FTUK | Futures | 4326.9 | 4329.5 | 4308.2 | 4325.5 | 7392.0 |
| 2012-12-10 | FVSA | Futures | 4139.42 | 4277.4 | 4047.44 | 4081.93 | 16775.0 |
| 2012-12-10 | G | Futures | 99.64 | 99.64 | 99.2 | 99.24 | 96760.0 |
| 2012-12-10 | GF | Futures | 282.923 | 284.536 | 282.022 | 284.204 | 4255.0 |
| 2012-12-10 | GSCI | Futures | 1021.33 | 1026.32 | 1016.1 | 1018.92 | 2506.0 |
| 2012-12-10 | HE | Futures | 95.884 | 96.572 | 95.625 | 96.314 | 13604.0 |
| 2012-12-10 | HG | Futures | 4.7096 | 4.7758 | 4.6949 | 4.7591 | 45399.0 |
| 2012-12-10 | HH | Futures | 40.621 | 40.621 | 40.621 | 40.621 | 1103.0 |
| 2012-12-10 | HO | Futures | 2.3557 | 2.3786 | 2.3406 | 2.343 | 16474.0 |
| 2012-12-10 | HRC | Futures | 2439.4 | 2439.4 | 2439.4 | 2439.4 | 0.0 |
| 2012-12-10 | J1 | Futures | 0.015197 | 0.0152722 | 0.0151769 | 0.0152333 | 26867.0 |
| 2012-12-10 | J7 | Futures | 0.015133 | 0.015194 | 0.015108 | 0.015158 | 61.0 |
> showing 50 of 94 rows — these rows as CSV