PREVIEW / futures_daily / 2010-08-12
file: by_date/futures_daily/2010/2010-08-12.parquet size: 9 KB rows: 91
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-08-12 | ES | Futures | 1058.26 | 1060.7 | 1044.12 | 1052.65 | 2180112.0 |
| 2010-08-12 | NQ | Futures | 2079.45 | 2080.58 | 2044.36 | 2068.13 | 349332.0 |
| 2010-08-12 | YM | Futures | 9557.5 | 9585.2 | 9452.1 | 9496.5 | 133247.0 |
| 2010-08-12 | CL | Futures | 164.14 | 165.54 | 160.34 | 160.81 | 430788.0 |
| 2010-08-12 | GC | Futures | 1631.9 | 1656.3 | 1630.4 | 1653.8 | 124749.0 |
| 2010-08-12 | ZN | Futures | 102.923975 | 103.052038 | 102.603818 | 102.731881 | 1191629.0 |
| 2010-08-12 | A6 | Futures | 0.73867 | 0.74439 | 0.73626 | 0.73834 | 112091.0 |
| 2010-08-12 | AD | Futures | 0.94323 | 0.94727 | 0.94046 | 0.9453 | 77993.0 |
| 2010-08-12 | B | Futures | 67.38 | 67.76 | 65.71 | 65.94 | 173457.0 |
| 2010-08-12 | B6 | Futures | 1.6234 | 1.6305 | 1.6147 | 1.6152 | 106079.0 |
| 2010-08-12 | BR | Futures | 0.23513 | 0.23513 | 0.2344 | 0.2344 | 58.0 |
| 2010-08-12 | BZ | Futures | 71.92 | 71.99 | 70.95 | 70.95 | 304.0 |
| 2010-08-12 | C | Futures | 2293.0 | 2335.0 | 2282.0 | 2319.0 | 2773.0 |
| 2010-08-12 | CB | Futures | 92.227 | 93.193 | 91.744 | 91.744 | 19.0 |
| 2010-08-12 | CC | Futures | 2371.0 | 2422.0 | 2371.0 | 2404.0 | 11051.0 |
| 2010-08-12 | CSC | Futures | 3.821 | 3.852 | 3.821 | 3.852 | 10.0 |
| 2010-08-12 | CT | Futures | 70.84 | 73.1 | 70.84 | 72.98 | 155.0 |
| 2010-08-12 | DC | Futures | 23.91 | 24.03 | 23.79 | 23.89 | 154.0 |
| 2010-08-12 | DX | Futures | 83.244 | 83.592 | 82.886 | 83.422 | 17703.0 |
| 2010-08-12 | E1 | Futures | 1.2386 | 1.25567 | 1.23768 | 1.24976 | 39008.0 |
| 2010-08-12 | E6 | Futures | 1.51903 | 1.5292 | 1.51111 | 1.51619 | 360136.0 |
| 2010-08-12 | E7 | Futures | 1.5086 | 1.5182 | 1.5003 | 1.5053 | 5414.0 |
| 2010-08-12 | ED | Futures | 94.5653 | 94.5653 | 94.5036 | 94.5369 | 397204.0 |
| 2010-08-12 | ER | Futures | 97.276 | 97.306 | 97.267 | 97.281 | 170138.0 |
| 2010-08-12 | EW | Futures | 723.2 | 726.2 | 711.2 | 721.6 | 24730.0 |
| 2010-08-12 | FBTP | Futures | 66.92 | 66.99 | 66.74 | 66.8 | 3866.0 |
| 2010-08-12 | FCE | Futures | 2379.5 | 2397.3 | 2362.0 | 2385.4 | 3528.0 |
| 2010-08-12 | FDAX | Futures | 6673.6 | 6721.0 | 6636.6 | 6681.8 | 133718.0 |
| 2010-08-12 | FESX | Futures | 1678.0 | 1693.4 | 1669.3 | 1686.0 | 1178252.0 |
| 2010-08-12 | FEU3 | Futures | 97.845 | 97.855 | 97.84 | 97.84 | 17.0 |
| 2010-08-12 | FGBL | Futures | 102.3 | 102.62 | 102.23 | 102.48 | 731646.0 |
| 2010-08-12 | FGBM | Futures | 106.03 | 106.23 | 106.0 | 106.16 | 392933.0 |
| 2010-08-12 | FGBS | Futures | 107.637 | 107.745 | 107.613 | 107.726 | 386399.0 |
| 2010-08-12 | FGBX | Futures | 102.6 | 103.12 | 102.47 | 102.82 | 4286.0 |
| 2010-08-12 | FTDX | Futures | 655.8 | 660.6 | 654.0 | 657.1 | 723.0 |
| 2010-08-12 | FTI | Futures | 258.1 | 260.53 | 257.3 | 258.9 | 1825.0 |
| 2010-08-12 | FTUK | Futures | 3589.1 | 3624.6 | 3576.7 | 3619.4 | 101274.0 |
| 2010-08-12 | G | Futures | 82.8 | 83.13 | 82.76 | 83.08 | 113708.0 |
| 2010-08-12 | GF | Futures | 284.635 | 284.888 | 282.17 | 282.423 | 3329.0 |
| 2010-08-12 | GSCI | Futures | 875.59 | 883.48 | 870.83 | 870.83 | 3127.0 |
| 2010-08-12 | HE | Futures | 97.845 | 98.997 | 97.087 | 98.306 | 11976.0 |
| 2010-08-12 | HG | Futures | 4.3272 | 4.4142 | 4.3272 | 4.3982 | 38267.0 |
| 2010-08-12 | HO | Futures | 1.8042 | 1.8155 | 1.7505 | 1.754 | 73777.0 |
| 2010-08-12 | HRC | Futures | 2753.7 | 2753.7 | 2753.7 | 2753.7 | 0.0 |
| 2010-08-12 | J1 | Futures | 0.0147588 | 0.0148155 | 0.0146343 | 0.0146519 | 128351.0 |
| 2010-08-12 | J7 | Futures | 0.014647 | 0.014703 | 0.014527 | 0.014542 | 358.0 |
| 2010-08-12 | JB | Futures | 121.11 | 121.28 | 121.04 | 121.15 | 2825.0 |
| 2010-08-12 | KC | Futures | 429.07 | 446.4 | 426.68 | 440.87 | 20985.0 |
| 2010-08-12 | KE | Futures | 3018.12 | 3196.03 | 3004.27 | 3089.49 | 13256.0 |
| 2010-08-12 | KRW | Futures | 0.0008251 | 0.0008251 | 0.0008251 | 0.0008251 | 23.0 |
> showing 50 of 91 rows — these rows as CSV