PREVIEW / futures_daily / 2010-06-17
file: by_date/futures_daily/2010/2010-06-17.parquet size: 9 KB rows: 90
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-06-17 | ES | Futures | 1082.64 | 1089.96 | 1073.62 | 1084.35 | 2715158.0 |
| 2010-06-17 | NQ | Futures | 2156.69 | 2171.12 | 2142.26 | 2161.22 | 345053.0 |
| 2010-06-17 | YM | Futures | 9568.6 | 9622.2 | 9484.4 | 9593.5 | 168086.0 |
| 2010-06-17 | CL | Futures | 167.79 | 168.88 | 165.65 | 166.68 | 228190.0 |
| 2010-06-17 | GC | Futures | 1680.0 | 1708.9 | 1679.2 | 1703.3 | 140087.0 |
| 2010-06-17 | ZN | Futures | 98.544231 | 99.043676 | 98.300912 | 98.941226 | 1128415.0 |
| 2010-06-17 | A6 | Futures | 0.70734 | 0.71306 | 0.70427 | 0.71107 | 88741.0 |
| 2010-06-17 | AD | Futures | 0.96258 | 0.96535 | 0.95458 | 0.96002 | 83230.0 |
| 2010-06-17 | B | Futures | 68.53 | 69.41 | 68.13 | 69.04 | 175267.0 |
| 2010-06-17 | B6 | Futures | 1.528 | 1.5403 | 1.5198 | 1.5371 | 104174.0 |
| 2010-06-17 | BFX | Futures | 2872.4 | 2891.5 | 2870.4 | 2876.8 | 356.0 |
| 2010-06-17 | BR | Futures | 0.22996 | 0.22996 | 0.22996 | 0.22996 | 118.0 |
| 2010-06-17 | BZ | Futures | 74.3 | 74.83 | 73.96 | 74.46 | 316.0 |
| 2010-06-17 | C | Futures | 2418.0 | 2418.0 | 2394.0 | 2402.0 | 3806.0 |
| 2010-06-17 | CB | Futures | 81.604 | 81.604 | 81.363 | 81.604 | 9.0 |
| 2010-06-17 | CC | Futures | 2481.0 | 2481.0 | 2448.0 | 2464.0 | 3765.0 |
| 2010-06-17 | CT | Futures | 65.06 | 65.14 | 63.95 | 64.22 | 6968.0 |
| 2010-06-17 | DC | Futures | 22.39 | 22.45 | 22.29 | 22.39 | 29.0 |
| 2010-06-17 | DX | Futures | 87.17 | 87.497 | 86.474 | 86.663 | 20949.0 |
| 2010-06-17 | E1 | Futures | 1.16269 | 1.18593 | 1.16124 | 1.18252 | 45463.0 |
| 2010-06-17 | E6 | Futures | 1.45589 | 1.46901 | 1.44867 | 1.46475 | 316888.0 |
| 2010-06-17 | E7 | Futures | 1.4452 | 1.4583 | 1.4384 | 1.4542 | 5107.0 |
| 2010-06-17 | ED | Futures | 94.2237 | 94.2474 | 94.2142 | 94.2332 | 172174.0 |
| 2010-06-17 | ER | Futures | 97.316 | 97.326 | 97.291 | 97.301 | 110472.0 |
| 2010-06-17 | EW | Futures | 759.8 | 764.7 | 749.9 | 758.6 | 25597.0 |
| 2010-06-17 | FBTP | Futures | 64.48 | 64.84 | 64.35 | 64.74 | 4633.0 |
| 2010-06-17 | FCE | Futures | 2413.5 | 2443.1 | 2405.9 | 2421.1 | 117249.0 |
| 2010-06-17 | FDAX | Futures | 6735.1 | 6798.2 | 6713.9 | 6771.0 | 90013.0 |
| 2010-06-17 | FESX | Futures | 1679.8 | 1698.4 | 1673.0 | 1683.5 | 1252063.0 |
| 2010-06-17 | FEU3 | Futures | 97.874 | 97.879 | 97.859 | 97.859 | 198.0 |
| 2010-06-17 | FGBL | Futures | 100.28 | 100.39 | 99.88 | 100.25 | 1007382.0 |
| 2010-06-17 | FGBM | Futures | 105.22 | 105.28 | 104.92 | 105.16 | 576317.0 |
| 2010-06-17 | FGBS | Futures | 107.765 | 107.775 | 107.657 | 107.691 | 550722.0 |
| 2010-06-17 | FGBX | Futures | 98.95 | 99.04 | 97.68 | 98.57 | 2666.0 |
| 2010-06-17 | FTDX | Futures | 678.7 | 689.7 | 678.7 | 684.0 | 1309.0 |
| 2010-06-17 | FTI | Futures | 265.11 | 267.17 | 264.04 | 265.7 | 30626.0 |
| 2010-06-17 | FTUK | Futures | 3584.3 | 3621.8 | 3580.5 | 3590.1 | 157099.0 |
| 2010-06-17 | G | Futures | 80.1 | 80.47 | 79.92 | 80.26 | 100223.0 |
| 2010-06-17 | GF | Futures | 279.519 | 280.15 | 278.192 | 278.256 | 1538.0 |
| 2010-06-17 | GSCI | Futures | 872.74 | 879.92 | 869.33 | 872.23 | 274.0 |
| 2010-06-17 | HE | Futures | 101.009 | 101.353 | 100.227 | 100.54 | 8848.0 |
| 2010-06-17 | HG | Futures | 4.0582 | 4.0663 | 3.9238 | 3.9455 | 33700.0 |
| 2010-06-17 | HO | Futures | 1.8828 | 1.9146 | 1.8756 | 1.9111 | 16680.0 |
| 2010-06-17 | HRC | Futures | 2994.3 | 2994.3 | 2994.3 | 2994.3 | 0.0 |
| 2010-06-17 | J1 | Futures | 0.0137851 | 0.0139197 | 0.0137763 | 0.0138757 | 154182.0 |
| 2010-06-17 | J7 | Futures | 0.013679 | 0.013814 | 0.013679 | 0.013771 | 201.0 |
| 2010-06-17 | JB | Futures | 119.45 | 119.64 | 119.45 | 119.53 | 961.0 |
| 2010-06-17 | KC | Futures | 401.38 | 405.45 | 394.53 | 396.94 | 4437.0 |
| 2010-06-17 | KE | Futures | 2132.43 | 2162.86 | 2115.04 | 2154.17 | 10912.0 |
| 2010-06-17 | L | Futures | 97.997 | 97.997 | 97.967 | 97.987 | 28341.0 |
> showing 50 of 90 rows — these rows as CSV