PREVIEW / futures_daily / 2009-07-31
file: by_date/futures_daily/2009/2009-07-31.parquet size: 8 KB rows: 85
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-31 | ES | Futures | 942.41 | 950.33 | 938.57 | 944.57 | 2082892.0 |
| 2009-07-31 | NQ | Futures | 1808.05 | 1822.98 | 1800.17 | 1804.11 | 258709.0 |
| 2009-07-31 | YM | Futures | 8202.4 | 8299.8 | 8184.3 | 8233.9 | 135643.0 |
| 2009-07-31 | CL | Futures | 171.7 | 179.56 | 167.25 | 178.81 | 400836.0 |
| 2009-07-31 | GC | Futures | 1295.5 | 1327.1 | 1290.9 | 1321.3 | 98489.0 |
| 2009-07-31 | ZN | Futures | 91.70459 | 92.554163 | 91.446025 | 92.418724 | 842917.0 |
| 2009-07-31 | A6 | Futures | 0.6613 | 0.67047 | 0.66002 | 0.6687 | 91603.0 |
| 2009-07-31 | AD | Futures | 0.91077 | 0.91778 | 0.90968 | 0.91561 | 76125.0 |
| 2009-07-31 | B | Futures | 66.45 | 68.77 | 64.84 | 68.39 | 85135.0 |
| 2009-07-31 | B6 | Futures | 1.7175 | 1.7428 | 1.7157 | 1.738 | 143783.0 |
| 2009-07-31 | BFX | Futures | 2467.2 | 2480.1 | 2456.4 | 2467.5 | 102.0 |
| 2009-07-31 | BR | Futures | 0.20831 | 0.20831 | 0.20831 | 0.20831 | 10.0 |
| 2009-07-31 | BZ | Futures | 69.45 | 71.34 | 69.45 | 71.34 | 263.0 |
| 2009-07-31 | C | Futures | 1927.0 | 1932.0 | 1905.0 | 1911.0 | 2876.0 |
| 2009-07-31 | CC | Futures | 2578.0 | 2582.0 | 2530.0 | 2572.0 | 4452.0 |
| 2009-07-31 | CT | Futures | 51.97 | 51.97 | 50.8 | 51.24 | 54.0 |
| 2009-07-31 | DC | Futures | 21.24 | 22.25 | 21.24 | 22.06 | 343.0 |
| 2009-07-31 | DX | Futures | 81.243 | 81.269 | 80.153 | 80.297 | 9519.0 |
| 2009-07-31 | E1 | Futures | 1.21736 | 1.24251 | 1.21603 | 1.23933 | 64452.0 |
| 2009-07-31 | E6 | Futures | 1.67025 | 1.69542 | 1.66966 | 1.69209 | 284727.0 |
| 2009-07-31 | E7 | Futures | 1.6531 | 1.678 | 1.6525 | 1.6747 | 2731.0 |
| 2009-07-31 | ED | Futures | 93.9519 | 93.9613 | 93.9472 | 93.9566 | 115170.0 |
| 2009-07-31 | ER | Futures | 97.135 | 97.149 | 97.12 | 97.135 | 76832.0 |
| 2009-07-31 | EW | Futures | 603.4 | 610.8 | 600.7 | 606.1 | 37358.0 |
| 2009-07-31 | FCE | Futures | 2246.7 | 2264.1 | 2233.0 | 2243.5 | 134595.0 |
| 2009-07-31 | FDAX | Futures | 5869.9 | 5913.2 | 5821.0 | 5861.1 | 120657.0 |
| 2009-07-31 | FESX | Futures | 1576.4 | 1591.9 | 1564.5 | 1572.8 | 1063615.0 |
| 2009-07-31 | FEU3 | Futures | 97.707 | 97.717 | 97.707 | 97.717 | 685.0 |
| 2009-07-31 | FGBL | Futures | 92.11 | 92.94 | 92.08 | 92.76 | 822792.0 |
| 2009-07-31 | FGBM | Futures | 98.05 | 98.53 | 98.02 | 98.45 | 372327.0 |
| 2009-07-31 | FGBS | Futures | 104.056 | 104.234 | 104.046 | 104.176 | 423011.0 |
| 2009-07-31 | FGBX | Futures | 84.71 | 86.36 | 84.66 | 85.86 | 1974.0 |
| 2009-07-31 | FTDX | Futures | 596.9 | 604.1 | 593.8 | 600.5 | 302.0 |
| 2009-07-31 | FTI | Futures | 231.58 | 233.76 | 230.19 | 231.99 | 32375.0 |
| 2009-07-31 | FTUK | Futures | 3041.9 | 3066.1 | 3025.0 | 3037.3 | 121451.0 |
| 2009-07-31 | G | Futures | 74.71 | 75.46 | 74.53 | 75.32 | 103459.0 |
| 2009-07-31 | GF | Futures | 282.383 | 282.797 | 280.592 | 282.108 | 1110.0 |
| 2009-07-31 | GSCI | Futures | 935.29 | 960.25 | 916.69 | 952.73 | 498.0 |
| 2009-07-31 | HE | Futures | 79.025 | 82.192 | 78.846 | 80.645 | 4648.0 |
| 2009-07-31 | HG | Futures | 3.5868 | 3.6956 | 3.5742 | 3.6837 | 21964.0 |
| 2009-07-31 | HO | Futures | 1.8107 | 1.8609 | 1.7551 | 1.8546 | 44192.0 |
| 2009-07-31 | HRC | Futures | 2434.4 | 2434.4 | 2434.4 | 2434.4 | 0.0 |
| 2009-07-31 | J1 | Futures | 0.0131821 | 0.0133281 | 0.0131343 | 0.0132853 | 110187.0 |
| 2009-07-31 | J7 | Futures | 0.013017 | 0.013142 | 0.012962 | 0.013102 | 62.0 |
| 2009-07-31 | JB | Futures | 116.57 | 116.69 | 116.24 | 116.28 | 4278.0 |
| 2009-07-31 | KC | Futures | 339.45 | 347.32 | 335.38 | 346.91 | 10290.0 |
| 2009-07-31 | KE | Futures | 2633.2 | 2687.16 | 2628.4 | 2682.36 | 7352.0 |
| 2009-07-31 | L | Futures | 97.426 | 97.426 | 97.406 | 97.416 | 30097.0 |
| 2009-07-31 | LBS | Futures | 793.2 | 807.8 | 793.2 | 796.1 | 1246.0 |
| 2009-07-31 | LE | Futures | 149.344 | 150.343 | 148.844 | 150.176 | 9324.0 |
> showing 50 of 85 rows — these rows as CSV