PREVIEW / futures_daily / 2012-08-14
file: by_date/futures_daily/2012/2012-08-14.parquet size: 9 KB rows: 99
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-08-14 | ES | Futures | 1419.83 | 1427.43 | 1415.02 | 1419.33 | 1435083.0 |
| 2012-08-14 | NQ | Futures | 3131.1 | 3148.31 | 3122.78 | 3129.66 | 188377.0 |
| 2012-08-14 | YM | Futures | 12740.3 | 12797.6 | 12713.2 | 12741.3 | 89230.0 |
| 2012-08-14 | CL | Futures | 168.3 | 170.47 | 167.99 | 169.59 | 80084.0 |
| 2012-08-14 | GC | Futures | 2153.0 | 2161.5 | 2127.7 | 2139.4 | 118540.0 |
| 2012-08-14 | ZN | Futures | 116.413417 | 116.481511 | 115.963997 | 116.04571 | 952133.0 |
| 2012-08-14 | A6 | Futures | 0.94289 | 0.94486 | 0.93929 | 0.94118 | 108821.0 |
| 2012-08-14 | AD | Futures | 1.00942 | 1.01133 | 1.00792 | 1.01073 | 73974.0 |
| 2012-08-14 | B | Futures | 101.23 | 102.09 | 101.03 | 101.82 | 147545.0 |
| 2012-08-14 | B6 | Futures | 1.6386 | 1.6446 | 1.637 | 1.6397 | 78859.0 |
| 2012-08-14 | BFX | Futures | 2821.4 | 2823.0 | 2808.7 | 2815.1 | 1383.0 |
| 2012-08-14 | BR | Futures | 0.23551 | 0.23551 | 0.23453 | 0.23499 | 132.0 |
| 2012-08-14 | BZ | Futures | 106.59 | 107.47 | 106.57 | 107.31 | 2514.0 |
| 2012-08-14 | C | Futures | 1662.0 | 1696.0 | 1662.0 | 1676.0 | 2352.0 |
| 2012-08-14 | CB | Futures | 96.881 | 96.881 | 96.612 | 96.612 | 18.0 |
| 2012-08-14 | CC | Futures | 1808.0 | 1871.0 | 1808.0 | 1841.0 | 18682.0 |
| 2012-08-14 | CSC | Futures | 4.023 | 4.025 | 4.014 | 4.014 | 18.0 |
| 2012-08-14 | CT | Futures | 95.1 | 95.24 | 94.03 | 94.31 | 25.0 |
| 2012-08-14 | DC | Futures | 29.72 | 29.88 | 29.49 | 29.79 | 143.0 |
| 2012-08-14 | DX | Futures | 80.1 | 80.187 | 79.833 | 80.102 | 15659.0 |
| 2012-08-14 | E1 | Futures | 1.32628 | 1.33234 | 1.32473 | 1.32653 | 30149.0 |
| 2012-08-14 | E6 | Futures | 1.45504 | 1.46153 | 1.45327 | 1.45504 | 182943.0 |
| 2012-08-14 | E7 | Futures | 1.4464 | 1.4523 | 1.4441 | 1.446 | 3152.0 |
| 2012-08-14 | ED | Futures | 95.1752 | 95.1823 | 95.1704 | 95.1752 | 114815.0 |
| 2012-08-14 | ER | Futures | 97.827 | 97.832 | 97.822 | 97.827 | 35702.0 |
| 2012-08-14 | EW | Futures | 972.1 | 978.6 | 967.2 | 970.9 | 18104.0 |
| 2012-08-14 | FBTP | Futures | 65.88 | 66.35 | 65.73 | 66.25 | 7965.0 |
| 2012-08-14 | FBTS | Futures | 86.146 | 86.369 | 86.063 | 86.311 | 1437.0 |
| 2012-08-14 | FCE | Futures | 2565.4 | 2573.2 | 2553.1 | 2568.3 | 167882.0 |
| 2012-08-14 | FDAX | Futures | 7601.5 | 7639.2 | 7575.9 | 7609.2 | 88690.0 |
| 2012-08-14 | FESX | Futures | 1643.4 | 1650.9 | 1634.6 | 1642.7 | 705202.0 |
| 2012-08-14 | FGBL | Futures | 118.11 | 118.18 | 117.52 | 117.64 | 516864.0 |
| 2012-08-14 | FGBM | Futures | 116.3 | 116.36 | 116.02 | 116.09 | 305844.0 |
| 2012-08-14 | FGBS | Futures | 110.507 | 110.522 | 110.477 | 110.487 | 176549.0 |
| 2012-08-14 | FGBX | Futures | 125.59 | 126.08 | 124.76 | 124.99 | 5896.0 |
| 2012-08-14 | FOAT | Futures | 102.77 | 102.92 | 102.59 | 102.7 | 13611.0 |
| 2012-08-14 | FTDX | Futures | 725.9 | 728.6 | 724.0 | 725.9 | 123.0 |
| 2012-08-14 | FTI | Futures | 283.28 | 284.3 | 282.18 | 283.15 | 23238.0 |
| 2012-08-14 | FTUK | Futures | 4239.7 | 4266.3 | 4236.1 | 4252.8 | 62039.0 |
| 2012-08-14 | FVSA | Futures | 6481.54 | 6648.06 | 6391.88 | 6596.83 | 4090.0 |
| 2012-08-14 | FXXP | Futures | 193.4 | 193.9 | 193.0 | 193.5 | 696.0 |
| 2012-08-14 | G | Futures | 99.83 | 100.14 | 99.61 | 99.7 | 97592.0 |
| 2012-08-14 | GF | Futures | 281.915 | 286.15 | 281.471 | 285.658 | 2437.0 |
| 2012-08-14 | GSCI | Futures | 1056.76 | 1059.42 | 1053.3 | 1058.13 | 185.0 |
| 2012-08-14 | HE | Futures | 95.346 | 96.118 | 94.573 | 95.686 | 17245.0 |
| 2012-08-14 | HG | Futures | 4.3203 | 4.3544 | 4.2984 | 4.3273 | 37746.0 |
| 2012-08-14 | HO | Futures | 2.4644 | 2.4896 | 2.4637 | 2.4811 | 38081.0 |
| 2012-08-14 | HRC | Futures | 2533.1 | 2533.1 | 2533.1 | 2533.1 | 0.0 |
| 2012-08-14 | J1 | Futures | 0.0160008 | 0.0160058 | 0.0158792 | 0.0159118 | 82639.0 |
| 2012-08-14 | J7 | Futures | 0.01594 | 0.015942 | 0.015818 | 0.015849 | 336.0 |
> showing 50 of 99 rows — these rows as CSV