PREVIEW / futures_daily / 2010-07-16
file: by_date/futures_daily/2010/2010-07-16.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-07-16 | ES | Futures | 1063.62 | 1067.77 | 1032.9 | 1036.8 | 2503643.0 |
| 2010-07-16 | NQ | Futures | 2093.31 | 2100.67 | 2037.28 | 2039.55 | 397734.0 |
| 2010-07-16 | YM | Futures | 9518.6 | 9542.7 | 9269.9 | 9300.4 | 168022.0 |
| 2010-07-16 | CL | Futures | 164.03 | 164.61 | 160.55 | 162.16 | 160890.0 |
| 2010-07-16 | GC | Futures | 1649.2 | 1651.7 | 1617.5 | 1620.8 | 145699.0 |
| 2010-07-16 | ZN | Futures | 100.465172 | 101.15671 | 100.439559 | 100.977422 | 1137303.0 |
| 2010-07-16 | A6 | Futures | 0.72781 | 0.72781 | 0.71463 | 0.71728 | 107809.0 |
| 2010-07-16 | AD | Futures | 0.95093 | 0.95093 | 0.93325 | 0.93641 | 95864.0 |
| 2010-07-16 | B | Futures | 66.78 | 66.86 | 65.26 | 65.89 | 120157.0 |
| 2010-07-16 | B6 | Futures | 1.6026 | 1.6031 | 1.5852 | 1.5879 | 96332.0 |
| 2010-07-16 | BFX | Futures | 2851.7 | 2851.7 | 2785.6 | 2787.2 | 225.0 |
| 2010-07-16 | BZ | Futures | 71.08 | 71.19 | 69.77 | 70.42 | 92.0 |
| 2010-07-16 | C | Futures | 2644.0 | 2693.0 | 2643.0 | 2666.0 | 4051.0 |
| 2010-07-16 | CB | Futures | 84.984 | 84.984 | 84.984 | 84.984 | 10.0 |
| 2010-07-16 | CC | Futures | 2631.0 | 2677.0 | 2617.0 | 2640.0 | 10889.0 |
| 2010-07-16 | CSC | Futures | 3.772 | 3.772 | 3.755 | 3.758 | 3.0 |
| 2010-07-16 | CT | Futures | 66.07 | 67.95 | 66.05 | 67.27 | 265.0 |
| 2010-07-16 | DC | Futures | 23.37 | 23.37 | 22.99 | 23.03 | 196.0 |
| 2010-07-16 | DX | Futures | 83.264 | 83.45 | 82.901 | 83.312 | 22109.0 |
| 2010-07-16 | E1 | Futures | 1.2625 | 1.26368 | 1.24661 | 1.25121 | 36166.0 |
| 2010-07-16 | E6 | Futures | 1.52908 | 1.53795 | 1.52412 | 1.5305 | 289643.0 |
| 2010-07-16 | E7 | Futures | 1.5183 | 1.5269 | 1.5133 | 1.5195 | 3543.0 |
| 2010-07-16 | ED | Futures | 94.385 | 94.423 | 94.385 | 94.3945 | 216646.0 |
| 2010-07-16 | ER | Futures | 97.183 | 97.188 | 97.139 | 97.173 | 236356.0 |
| 2010-07-16 | EW | Futures | 733.1 | 736.0 | 708.9 | 710.0 | 32087.0 |
| 2010-07-16 | FBTP | Futures | 64.86 | 65.19 | 64.78 | 65.15 | 2631.0 |
| 2010-07-16 | FCE | Futures | 2350.3 | 2371.6 | 2278.5 | 2295.5 | 160260.0 |
| 2010-07-16 | FDAX | Futures | 6696.5 | 6757.9 | 6543.6 | 6585.5 | 160138.0 |
| 2010-07-16 | FESX | Futures | 1670.5 | 1687.9 | 1621.6 | 1638.3 | 1441325.0 |
| 2010-07-16 | FEU3 | Futures | 97.741 | 97.741 | 97.706 | 97.731 | 138.0 |
| 2010-07-16 | FGBL | Futures | 100.63 | 101.06 | 100.3 | 100.88 | 709217.0 |
| 2010-07-16 | FGBM | Futures | 104.89 | 105.03 | 104.68 | 104.94 | 396468.0 |
| 2010-07-16 | FGBS | Futures | 107.298 | 107.343 | 107.234 | 107.313 | 386101.0 |
| 2010-07-16 | FGBX | Futures | 100.52 | 100.68 | 99.67 | 100.35 | 2719.0 |
| 2010-07-16 | FTDX | Futures | 691.5 | 695.5 | 672.1 | 682.7 | 426.0 |
| 2010-07-16 | FTI | Futures | 260.65 | 262.71 | 254.25 | 256.31 | 35902.0 |
| 2010-07-16 | FTUK | Futures | 3580.2 | 3607.7 | 3501.0 | 3533.4 | 112664.0 |
| 2010-07-16 | G | Futures | 81.14 | 81.64 | 81.08 | 81.46 | 69284.0 |
| 2010-07-16 | GF | Futures | 286.781 | 287.097 | 285.076 | 285.708 | 1831.0 |
| 2010-07-16 | GSCI | Futures | 857.34 | 859.38 | 845.2 | 852.08 | 2616.0 |
| 2010-07-16 | HE | Futures | 98.404 | 99.769 | 98.13 | 99.193 | 12372.0 |
| 2010-07-16 | HG | Futures | 4.0446 | 4.058 | 3.9221 | 3.9234 | 33941.0 |
| 2010-07-16 | HO | Futures | 1.7951 | 1.8028 | 1.7672 | 1.7823 | 13825.0 |
| 2010-07-16 | HRC | Futures | 2828.0 | 2875.5 | 2828.0 | 2875.5 | 0.0 |
| 2010-07-16 | J1 | Futures | 0.0144078 | 0.014594 | 0.0143864 | 0.0145211 | 153264.0 |
| 2010-07-16 | J7 | Futures | 0.014299 | 0.014483 | 0.014281 | 0.014412 | 272.0 |
| 2010-07-16 | JB | Futures | 120.61 | 120.81 | 120.56 | 120.6 | 2255.0 |
| 2010-07-16 | KC | Futures | 420.53 | 426.43 | 414.5 | 419.52 | 8891.0 |
| 2010-07-16 | KE | Futures | 2568.54 | 2581.33 | 2522.73 | 2552.56 | 12884.0 |
| 2010-07-16 | L | Futures | 98.066 | 98.076 | 98.056 | 98.066 | 25224.0 |
> showing 50 of 90 rows — these rows as CSV