PREVIEW / futures_daily / 2011-02-03
file: by_date/futures_daily/2011/2011-02-03.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 |
|---|---|---|---|---|---|---|---|
| 2011-02-03 | ES | Futures | 1279.87 | 1285.28 | 1271.25 | 1282.82 | 1828391.0 |
| 2011-02-03 | NQ | Futures | 2632.77 | 2641.0 | 2606.37 | 2635.89 | 258037.0 |
| 2011-02-03 | YM | Futures | 11215.2 | 11263.0 | 11168.4 | 11239.6 | 98505.0 |
| 2011-02-03 | CL | Futures | 184.99 | 187.26 | 183.09 | 184.19 | 290494.0 |
| 2011-02-03 | GC | Futures | 1813.1 | 1841.1 | 1798.6 | 1836.2 | 189233.0 |
| 2011-02-03 | ZN | Futures | 99.750627 | 99.815619 | 99.165694 | 99.360671 | 1379745.0 |
| 2011-02-03 | A6 | Futures | 0.85216 | 0.85784 | 0.85105 | 0.8564 | 94239.0 |
| 2011-02-03 | AD | Futures | 1.00336 | 1.00505 | 0.99939 | 1.00168 | 67960.0 |
| 2011-02-03 | B | Futures | 87.67 | 88.35 | 86.72 | 87.03 | 105527.0 |
| 2011-02-03 | B6 | Futures | 1.6783 | 1.6882 | 1.6719 | 1.6746 | 136208.0 |
| 2011-02-03 | BFX | Futures | 3109.5 | 3109.5 | 3091.0 | 3093.9 | 42.0 |
| 2011-02-03 | BR | Futures | 0.25704 | 0.25704 | 0.25638 | 0.25653 | 149.0 |
| 2011-02-03 | BZ | Futures | 93.91 | 93.91 | 92.85 | 92.99 | 496.0 |
| 2011-02-03 | C | Futures | 2403.0 | 2418.0 | 2379.0 | 2394.0 | 4553.0 |
| 2011-02-03 | CC | Futures | 2712.0 | 2721.0 | 2692.0 | 2703.0 | 10610.0 |
| 2011-02-03 | CSC | Futures | 4.171 | 4.197 | 4.171 | 4.197 | 2.0 |
| 2011-02-03 | CT | Futures | 153.58 | 155.4 | 146.82 | 147.37 | 25218.0 |
| 2011-02-03 | DC | Futures | 29.69 | 30.17 | 29.59 | 30.13 | 464.0 |
| 2011-02-03 | DX | Futures | 77.086 | 77.855 | 76.996 | 77.727 | 25181.0 |
| 2011-02-03 | E1 | Futures | 1.39449 | 1.39554 | 1.3764 | 1.38741 | 51525.0 |
| 2011-02-03 | E6 | Futures | 1.63248 | 1.63497 | 1.60941 | 1.61237 | 416132.0 |
| 2011-02-03 | E7 | Futures | 1.6205 | 1.6227 | 1.5974 | 1.6004 | 5710.0 |
| 2011-02-03 | EBM | Futures | 248.52 | 250.78 | 247.15 | 250.33 | 7579.0 |
| 2011-02-03 | ED | Futures | 94.8384 | 94.8432 | 94.8337 | 94.8384 | 149409.0 |
| 2011-02-03 | ER | Futures | 97.222 | 97.271 | 97.222 | 97.262 | 260418.0 |
| 2011-02-03 | EW | Futures | 921.2 | 926.1 | 914.0 | 924.0 | 20786.0 |
| 2011-02-03 | FBTP | Futures | 64.94 | 65.0 | 64.51 | 64.54 | 10396.0 |
| 2011-02-03 | FCE | Futures | 2707.1 | 2710.8 | 2675.8 | 2692.5 | 129183.0 |
| 2011-02-03 | FDAX | Futures | 7685.0 | 7734.3 | 7659.3 | 7700.5 | 117226.0 |
| 2011-02-03 | FESX | Futures | 1866.3 | 1872.5 | 1848.9 | 1857.6 | 1196756.0 |
| 2011-02-03 | FEU3 | Futures | 97.825 | 97.825 | 97.82 | 97.82 | 15.0 |
| 2011-02-03 | FGBL | Futures | 97.24 | 97.67 | 97.12 | 97.59 | 1043185.0 |
| 2011-02-03 | FGBM | Futures | 102.93 | 103.51 | 102.88 | 103.47 | 751844.0 |
| 2011-02-03 | FGBS | Futures | 106.438 | 106.724 | 106.423 | 106.704 | 947410.0 |
| 2011-02-03 | FGBX | Futures | 94.16 | 94.76 | 93.96 | 94.63 | 4988.0 |
| 2011-02-03 | FTDX | Futures | 770.1 | 772.3 | 766.2 | 768.4 | 174.0 |
| 2011-02-03 | FTI | Futures | 295.08 | 295.08 | 291.81 | 293.42 | 33133.0 |
| 2011-02-03 | FTUK | Futures | 4144.0 | 4150.9 | 4111.7 | 4134.3 | 79471.0 |
| 2011-02-03 | FXXP | Futures | 183.6 | 184.5 | 183.5 | 184.3 | 3665.0 |
| 2011-02-03 | G | Futures | 79.92 | 80.03 | 79.73 | 79.89 | 134294.0 |
| 2011-02-03 | GF | Futures | 310.808 | 310.808 | 307.354 | 309.574 | 3356.0 |
| 2011-02-03 | GSCI | Futures | 1051.14 | 1053.85 | 1041.43 | 1043.82 | 255.0 |
| 2011-02-03 | HE | Futures | 106.881 | 107.581 | 105.597 | 106.822 | 22799.0 |
| 2011-02-03 | HG | Futures | 6.0746 | 6.1039 | 6.0166 | 6.0566 | 25876.0 |
| 2011-02-03 | HO | Futures | 2.3249 | 2.3451 | 2.3082 | 2.3144 | 52808.0 |
| 2011-02-03 | HRC | Futures | 2833.3 | 2833.3 | 2833.3 | 2833.3 | 34.0 |
| 2011-02-03 | J1 | Futures | 0.0154098 | 0.0154324 | 0.0153056 | 0.0153847 | 118655.0 |
| 2011-02-03 | J7 | Futures | 0.015304 | 0.01532 | 0.015199 | 0.015275 | 137.0 |
| 2011-02-03 | JB | Futures | 120.73 | 120.76 | 120.44 | 120.49 | 1453.0 |
| 2011-02-03 | KC | Futures | 615.28 | 621.9 | 613.31 | 616.38 | 9775.0 |
> showing 50 of 93 rows — these rows as CSV