PREVIEW / futures_daily / 2010-06-21
file: by_date/futures_daily/2010/2010-06-21.parquet size: 9 KB rows: 87
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-21 | ES | Futures | 1088.49 | 1101.66 | 1076.06 | 1083.13 | 2162081.0 |
| 2010-06-21 | NQ | Futures | 2176.5 | 2196.87 | 2132.07 | 2149.9 | 328037.0 |
| 2010-06-21 | YM | Futures | 9639.8 | 9741.5 | 9554.7 | 9612.0 | 141783.0 |
| 2010-06-21 | CL | Futures | 168.07 | 170.74 | 165.99 | 167.89 | 285720.0 |
| 2010-06-21 | GC | Futures | 1720.4 | 1727.6 | 1680.0 | 1692.4 | 154610.0 |
| 2010-06-21 | ZN | Futures | 98.467394 | 98.659488 | 98.147237 | 98.595457 | 924787.0 |
| 2010-06-21 | A6 | Futures | 0.72259 | 0.72706 | 0.7182 | 0.7201 | 88668.0 |
| 2010-06-21 | AD | Futures | 0.96772 | 0.97355 | 0.96189 | 0.96466 | 80897.0 |
| 2010-06-21 | B | Futures | 68.87 | 70.07 | 68.21 | 69.16 | 137853.0 |
| 2010-06-21 | B6 | Futures | 1.5411 | 1.5501 | 1.5297 | 1.5317 | 80443.0 |
| 2010-06-21 | BFX | Futures | 2931.0 | 2931.0 | 2901.2 | 2907.5 | 375.0 |
| 2010-06-21 | BZ | Futures | 75.13 | 75.5 | 73.58 | 74.59 | 256.0 |
| 2010-06-21 | C | Futures | 2437.0 | 2463.0 | 2429.0 | 2449.0 | 2381.0 |
| 2010-06-21 | CC | Futures | 2473.0 | 2502.0 | 2467.0 | 2490.0 | 3460.0 |
| 2010-06-21 | CT | Futures | 65.25 | 65.97 | 65.02 | 65.29 | 2415.0 |
| 2010-06-21 | DC | Futures | 22.29 | 22.29 | 21.91 | 22.06 | 222.0 |
| 2010-06-21 | DX | Futures | 86.348 | 87.029 | 86.036 | 86.922 | 18978.0 |
| 2010-06-21 | E1 | Futures | 1.19092 | 1.19499 | 1.18107 | 1.18383 | 32914.0 |
| 2010-06-21 | E6 | Futures | 1.4709 | 1.4754 | 1.45577 | 1.45778 | 257963.0 |
| 2010-06-21 | E7 | Futures | 1.4596 | 1.4647 | 1.4454 | 1.4473 | 3724.0 |
| 2010-06-21 | ED | Futures | 94.2474 | 94.2901 | 94.2474 | 94.2806 | 163166.0 |
| 2010-06-21 | ER | Futures | 97.276 | 97.281 | 97.257 | 97.267 | 152910.0 |
| 2010-06-21 | EW | Futures | 757.7 | 766.9 | 746.4 | 750.6 | 24008.0 |
| 2010-06-21 | FBTP | Futures | 65.05 | 65.41 | 65.05 | 65.24 | 3373.0 |
| 2010-06-21 | FCE | Futures | 2456.6 | 2476.0 | 2414.5 | 2455.0 | 119578.0 |
| 2010-06-21 | FDAX | Futures | 6858.0 | 6918.4 | 6779.7 | 6847.7 | 125062.0 |
| 2010-06-21 | FESX | Futures | 1717.6 | 1730.0 | 1687.2 | 1709.5 | 1017440.0 |
| 2010-06-21 | FEU3 | Futures | 97.835 | 97.835 | 97.825 | 97.825 | 522.0 |
| 2010-06-21 | FGBL | Futures | 99.48 | 99.68 | 99.28 | 99.5 | 644907.0 |
| 2010-06-21 | FGBM | Futures | 104.63 | 104.73 | 104.39 | 104.53 | 430659.0 |
| 2010-06-21 | FGBS | Futures | 107.524 | 107.569 | 107.456 | 107.495 | 396027.0 |
| 2010-06-21 | FGBX | Futures | 97.53 | 97.84 | 97.21 | 97.53 | 3115.0 |
| 2010-06-21 | FTDX | Futures | 696.8 | 709.1 | 694.2 | 694.6 | 494.0 |
| 2010-06-21 | FTI | Futures | 270.1 | 272.12 | 266.14 | 270.1 | 27759.0 |
| 2010-06-21 | FTUK | Futures | 3651.0 | 3654.1 | 3572.3 | 3620.4 | 80587.0 |
| 2010-06-21 | G | Futures | 79.89 | 80.43 | 79.85 | 80.16 | 76959.0 |
| 2010-06-21 | GF | Futures | 278.319 | 282.803 | 278.319 | 282.171 | 2108.0 |
| 2010-06-21 | GSCI | Futures | 885.21 | 888.11 | 867.45 | 872.57 | 463.0 |
| 2010-06-21 | HE | Futures | 101.635 | 103.543 | 101.447 | 102.604 | 9386.0 |
| 2010-06-21 | HG | Futures | 3.9442 | 4.0854 | 3.9288 | 3.9636 | 10721.0 |
| 2010-06-21 | HO | Futures | 1.9148 | 1.9335 | 1.8929 | 1.9116 | 9400.0 |
| 2010-06-21 | HRC | Futures | 2994.3 | 2994.3 | 2994.3 | 2994.3 | 0.0 |
| 2010-06-21 | J1 | Futures | 0.0139197 | 0.0139524 | 0.0137687 | 0.0138455 | 129339.0 |
| 2010-06-21 | J7 | Futures | 0.013831 | 0.013865 | 0.013668 | 0.013741 | 161.0 |
| 2010-06-21 | JB | Futures | 119.72 | 119.75 | 119.54 | 119.54 | 1332.0 |
| 2010-06-21 | KC | Futures | 406.84 | 415.51 | 397.68 | 403.83 | 18337.0 |
| 2010-06-21 | KE | Futures | 2166.12 | 2195.47 | 2141.12 | 2172.64 | 10412.0 |
| 2010-06-21 | L | Futures | 97.977 | 98.017 | 97.977 | 98.007 | 29091.0 |
| 2010-06-21 | LBS | Futures | 614.4 | 614.4 | 582.2 | 586.8 | 406.0 |
| 2010-06-21 | LE | Futures | 144.583 | 146.007 | 144.583 | 145.356 | 17854.0 |
> showing 50 of 87 rows — these rows as CSV