PREVIEW / futures_daily / 2010-11-17
file: by_date/futures_daily/2010/2010-11-17.parquet size: 9 KB rows: 92
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-11-17 | ES | Futures | 1152.42 | 1158.55 | 1149.97 | 1154.14 | 2021219.0 |
| 2010-11-17 | NQ | Futures | 2373.24 | 2391.66 | 2367.57 | 2377.77 | 260007.0 |
| 2010-11-17 | YM | Futures | 10223.3 | 10261.5 | 10204.7 | 10230.8 | 98209.0 |
| 2010-11-17 | CL | Futures | 170.15 | 170.79 | 165.61 | 166.41 | 354527.0 |
| 2010-11-17 | GC | Futures | 1822.8 | 1827.7 | 1807.9 | 1817.2 | 174178.0 |
| 2010-11-17 | ZN | Futures | 103.245012 | 103.490188 | 102.948219 | 103.128875 | 1279701.0 |
| 2010-11-17 | A6 | Futures | 0.8168 | 0.82284 | 0.81369 | 0.8194 | 102037.0 |
| 2010-11-17 | AD | Futures | 0.96944 | 0.97261 | 0.9635 | 0.96736 | 88688.0 |
| 2010-11-17 | B | Futures | 72.06 | 72.36 | 70.58 | 70.85 | 208208.0 |
| 2010-11-17 | B6 | Futures | 1.6484 | 1.6554 | 1.6456 | 1.6501 | 80762.0 |
| 2010-11-17 | BFX | Futures | 3000.2 | 3032.9 | 3000.2 | 3028.0 | 1173.0 |
| 2010-11-17 | BR | Futures | 0.24508 | 0.24691 | 0.24495 | 0.24672 | 170.0 |
| 2010-11-17 | BZ | Futures | 75.97 | 76.53 | 74.66 | 74.94 | 1014.0 |
| 2010-11-17 | C | Futures | 2005.0 | 2050.0 | 2001.0 | 2041.0 | 2980.0 |
| 2010-11-17 | CB | Futures | 95.521 | 95.521 | 94.424 | 94.701 | 25.0 |
| 2010-11-17 | CC | Futures | 2264.0 | 2322.0 | 2250.0 | 2302.0 | 7898.0 |
| 2010-11-17 | CSC | Futures | 3.378 | 3.378 | 3.378 | 3.378 | 8.0 |
| 2010-11-17 | CT | Futures | 112.58 | 114.27 | 108.13 | 109.1 | 6804.0 |
| 2010-11-17 | DC | Futures | 22.76 | 23.06 | 22.75 | 22.96 | 557.0 |
| 2010-11-17 | DX | Futures | 79.648 | 79.748 | 79.222 | 79.462 | 26651.0 |
| 2010-11-17 | E1 | Futures | 1.3187 | 1.32881 | 1.31608 | 1.32382 | 39409.0 |
| 2010-11-17 | E6 | Futures | 1.59509 | 1.60444 | 1.5919 | 1.59912 | 317980.0 |
| 2010-11-17 | E7 | Futures | 1.5826 | 1.592 | 1.5798 | 1.587 | 5047.0 |
| 2010-11-17 | ED | Futures | 94.7411 | 94.753 | 94.7387 | 94.7482 | 141554.0 |
| 2010-11-17 | ER | Futures | 97.222 | 97.237 | 97.222 | 97.237 | 83150.0 |
| 2010-11-17 | EW | Futures | 815.6 | 822.1 | 814.3 | 819.5 | 20300.0 |
| 2010-11-17 | FBTP | Futures | 65.75 | 65.89 | 65.59 | 65.78 | 4573.0 |
| 2010-11-17 | FCE | Futures | 2533.8 | 2543.5 | 2509.0 | 2537.1 | 172595.0 |
| 2010-11-17 | FDAX | Futures | 7179.5 | 7221.5 | 7163.4 | 7212.9 | 131716.0 |
| 2010-11-17 | FESX | Futures | 1738.1 | 1752.5 | 1730.7 | 1750.0 | 1126663.0 |
| 2010-11-17 | FEU3 | Futures | 97.79 | 97.8 | 97.79 | 97.8 | 46.0 |
| 2010-11-17 | FGBL | Futures | 101.49 | 101.78 | 101.31 | 101.58 | 926504.0 |
| 2010-11-17 | FGBM | Futures | 105.57 | 105.79 | 105.47 | 105.58 | 487945.0 |
| 2010-11-17 | FGBS | Futures | 107.199 | 107.297 | 107.199 | 107.263 | 367114.0 |
| 2010-11-17 | FGBX | Futures | 103.44 | 103.71 | 102.66 | 103.4 | 4845.0 |
| 2010-11-17 | FTDX | Futures | 686.2 | 686.6 | 675.6 | 684.4 | 680.0 |
| 2010-11-17 | FTI | Futures | 273.11 | 275.28 | 272.43 | 274.84 | 41941.0 |
| 2010-11-17 | FTUK | Futures | 3922.8 | 3942.2 | 3905.9 | 3931.5 | 89336.0 |
| 2010-11-17 | G | Futures | 82.56 | 82.87 | 82.49 | 82.69 | 123158.0 |
| 2010-11-17 | GF | Futures | 285.85 | 286.847 | 284.729 | 285.85 | 1573.0 |
| 2010-11-17 | GSCI | Futures | 918.32 | 926.06 | 909.37 | 910.18 | 278.0 |
| 2010-11-17 | HE | Futures | 92.46 | 93.432 | 91.896 | 92.993 | 8672.0 |
| 2010-11-17 | HG | Futures | 4.9677 | 5.0291 | 4.8136 | 4.9777 | 53717.0 |
| 2010-11-17 | HO | Futures | 1.9479 | 1.9529 | 1.9034 | 1.9133 | 6669.0 |
| 2010-11-17 | HRC | Futures | 2391.9 | 2391.9 | 2391.9 | 2391.9 | 0.0 |
| 2010-11-17 | J1 | Futures | 0.0150695 | 0.015131 | 0.0150368 | 0.0150871 | 91282.0 |
| 2010-11-17 | J7 | Futures | 0.014959 | 0.015026 | 0.014935 | 0.014984 | 122.0 |
| 2010-11-17 | JB | Futures | 121.22 | 121.34 | 120.85 | 120.85 | 3210.0 |
| 2010-11-17 | KC | Futures | 491.14 | 498.09 | 485.19 | 494.62 | 7292.0 |
| 2010-11-17 | KE | Futures | 2884.98 | 2962.17 | 2856.82 | 2901.67 | 14056.0 |
> showing 50 of 92 rows — these rows as CSV