PREVIEW / futures_daily / 2010-12-09
file: by_date/futures_daily/2010/2010-12-09.parquet size: 9 KB rows: 93
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-09 | ES | Futures | 1204.13 | 1213.44 | 1202.17 | 1208.54 | 1388754.0 |
| 2010-12-09 | NQ | Futures | 2494.0 | 2511.29 | 2487.48 | 2495.98 | 161286.0 |
| 2010-12-09 | YM | Futures | 10574.1 | 10646.7 | 10540.6 | 10572.2 | 84413.0 |
| 2010-12-09 | CL | Futures | 181.83 | 183.62 | 180.11 | 181.46 | 353964.0 |
| 2010-12-09 | GC | Futures | 1879.9 | 1897.0 | 1877.3 | 1893.2 | 125993.0 |
| 2010-12-09 | ZN | Futures | 100.361557 | 100.868499 | 100.192576 | 100.465545 | 1311228.0 |
| 2010-12-09 | A6 | Futures | 0.82192 | 0.82955 | 0.82032 | 0.82477 | 98287.0 |
| 2010-12-09 | AD | Futures | 0.97994 | 0.9841 | 0.97826 | 0.98004 | 80092.0 |
| 2010-12-09 | B | Futures | 77.48 | 77.96 | 76.81 | 77.41 | 86615.0 |
| 2010-12-09 | B6 | Futures | 1.6408 | 1.6445 | 1.631 | 1.635 | 100727.0 |
| 2010-12-09 | BFX | Futures | 3037.9 | 3041.1 | 3010.2 | 3029.6 | 110.0 |
| 2010-12-09 | BR | Futures | 0.24955 | 0.24955 | 0.24735 | 0.24759 | 129.0 |
| 2010-12-09 | BZ | Futures | 82.43 | 82.48 | 82.03 | 82.03 | 285.0 |
| 2010-12-09 | C | Futures | 2211.0 | 2211.0 | 2171.0 | 2172.0 | 10963.0 |
| 2010-12-09 | CB | Futures | 99.002 | 99.148 | 98.723 | 98.855 | 23.0 |
| 2010-12-09 | CC | Futures | 2475.0 | 2490.0 | 2426.0 | 2443.0 | 7365.0 |
| 2010-12-09 | CSC | Futures | 3.319 | 3.337 | 3.295 | 3.332 | 20.0 |
| 2010-12-09 | CT | Futures | 113.35 | 116.58 | 111.19 | 116.58 | 7006.0 |
| 2010-12-09 | DC | Futures | 22.23 | 22.47 | 22.23 | 22.34 | 122.0 |
| 2010-12-09 | DX | Futures | 80.245 | 80.676 | 79.934 | 80.34 | 26864.0 |
| 2010-12-09 | E1 | Futures | 1.33209 | 1.33853 | 1.32671 | 1.33433 | 41950.0 |
| 2010-12-09 | E6 | Futures | 1.56907 | 1.57641 | 1.55701 | 1.56564 | 313895.0 |
| 2010-12-09 | E7 | Futures | 1.5569 | 1.564 | 1.5451 | 1.5538 | 4879.0 |
| 2010-12-09 | EBM | Futures | 214.25 | 219.01 | 214.25 | 216.74 | 14213.0 |
| 2010-12-09 | ED | Futures | 94.7553 | 94.7601 | 94.753 | 94.7577 | 164639.0 |
| 2010-12-09 | ER | Futures | 97.281 | 97.281 | 97.276 | 97.281 | 56699.0 |
| 2010-12-09 | EW | Futures | 872.5 | 878.9 | 869.2 | 874.0 | 35393.0 |
| 2010-12-09 | FBTP | Futures | 64.55 | 64.77 | 64.41 | 64.56 | 3694.0 |
| 2010-12-09 | FCE | Futures | 2583.3 | 2592.0 | 2567.9 | 2582.0 | 131714.0 |
| 2010-12-09 | FDAX | Futures | 7540.4 | 7560.3 | 7471.5 | 7490.4 | 151225.0 |
| 2010-12-09 | FESX | Futures | 1772.5 | 1779.4 | 1763.7 | 1773.1 | 1230769.0 |
| 2010-12-09 | FEU3 | Futures | 97.845 | 97.845 | 97.845 | 97.845 | 21.0 |
| 2010-12-09 | FGBL | Futures | 98.64 | 99.27 | 98.55 | 98.96 | 729455.0 |
| 2010-12-09 | FGBM | Futures | 104.4 | 104.64 | 104.35 | 104.45 | 474429.0 |
| 2010-12-09 | FGBS | Futures | 107.336 | 107.336 | 107.218 | 107.257 | 544209.0 |
| 2010-12-09 | FGBX | Futures | 97.58 | 99.03 | 97.5 | 98.39 | 3000.0 |
| 2010-12-09 | FTDX | Futures | 728.0 | 730.6 | 721.4 | 726.2 | 988.0 |
| 2010-12-09 | FTI | Futures | 281.2 | 282.32 | 280.19 | 281.0 | 31010.0 |
| 2010-12-09 | FTUK | Futures | 4027.9 | 4036.9 | 4007.1 | 4009.2 | 122804.0 |
| 2010-12-09 | FXXP | Futures | 178.7 | 178.7 | 178.3 | 178.3 | 309.0 |
| 2010-12-09 | G | Futures | 81.28 | 81.55 | 81.12 | 81.36 | 82158.0 |
| 2010-12-09 | GF | Futures | 293.573 | 295.441 | 292.888 | 294.133 | 1799.0 |
| 2010-12-09 | GSCI | Futures | 985.57 | 993.38 | 984.84 | 988.34 | 2819.0 |
| 2010-12-09 | HE | Futures | 95.533 | 95.909 | 94.686 | 95.188 | 11006.0 |
| 2010-12-09 | HG | Futures | 5.4802 | 5.5368 | 5.4049 | 5.4468 | 35675.0 |
| 2010-12-09 | HO | Futures | 2.0857 | 2.0959 | 2.0691 | 2.0797 | 14583.0 |
| 2010-12-09 | HRC | Futures | 2455.4 | 2455.4 | 2455.4 | 2455.4 | 0.0 |
| 2010-12-09 | J1 | Futures | 0.0149489 | 0.0150406 | 0.0149326 | 0.0150092 | 115862.0 |
| 2010-12-09 | J7 | Futures | 0.01483 | 0.014937 | 0.01483 | 0.014906 | 215.0 |
| 2010-12-09 | KC | Futures | 504.19 | 507.38 | 500.51 | 501.61 | 9034.0 |
> showing 50 of 93 rows — these rows as CSV