PREVIEW / futures_daily / 2009-08-20
file: by_date/futures_daily/2009/2009-08-20.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-08-20 | ES | Futures | 956.32 | 966.88 | 953.92 | 964.0 | 1639885.0 |
| 2009-08-20 | NQ | Futures | 1799.61 | 1824.66 | 1791.72 | 1817.63 | 258289.0 |
| 2009-08-20 | YM | Futures | 8370.2 | 8434.2 | 8340.4 | 8409.0 | 110512.0 |
| 2009-08-20 | CL | Futures | 183.51 | 184.81 | 180.97 | 181.91 | 241477.0 |
| 2009-08-20 | GC | Futures | 1305.3 | 1309.6 | 1297.4 | 1301.8 | 52319.0 |
| 2009-08-20 | ZN | Futures | 93.022043 | 93.157482 | 92.664977 | 93.071294 | 643131.0 |
| 2009-08-20 | A6 | Futures | 0.66572 | 0.66854 | 0.66347 | 0.66661 | 57839.0 |
| 2009-08-20 | AD | Futures | 0.90198 | 0.90929 | 0.89823 | 0.90731 | 55383.0 |
| 2009-08-20 | B | Futures | 70.79 | 70.83 | 69.23 | 69.45 | 91800.0 |
| 2009-08-20 | B6 | Futures | 1.7224 | 1.7298 | 1.7134 | 1.7192 | 79835.0 |
| 2009-08-20 | BFX | Futures | 2594.2 | 2632.9 | 2594.1 | 2632.0 | 946.0 |
| 2009-08-20 | BR | Futures | 0.21105 | 0.21105 | 0.21105 | 0.21105 | 85.0 |
| 2009-08-20 | C | Futures | 1915.0 | 1937.0 | 1899.0 | 1935.0 | 2127.0 |
| 2009-08-20 | CB | Futures | 66.505 | 67.074 | 66.505 | 67.074 | 5.0 |
| 2009-08-20 | CC | Futures | 2532.0 | 2567.0 | 2526.0 | 2558.0 | 3929.0 |
| 2009-08-20 | CT | Futures | 50.46 | 51.1 | 50.06 | 50.08 | 74.0 |
| 2009-08-20 | DC | Futures | 22.89 | 23.3 | 22.59 | 22.94 | 416.0 |
| 2009-08-20 | DX | Futures | 80.348 | 80.598 | 80.21 | 80.297 | 3909.0 |
| 2009-08-20 | E1 | Futures | 1.24357 | 1.24701 | 1.2392 | 1.24582 | 23682.0 |
| 2009-08-20 | E6 | Futures | 1.68912 | 1.69506 | 1.6858 | 1.69233 | 163412.0 |
| 2009-08-20 | E7 | Futures | 1.6721 | 1.6778 | 1.6685 | 1.675 | 1401.0 |
| 2009-08-20 | ED | Futures | 94.0156 | 94.0416 | 94.0109 | 94.0298 | 106873.0 |
| 2009-08-20 | ER | Futures | 97.125 | 97.139 | 97.12 | 97.139 | 86071.0 |
| 2009-08-20 | EW | Futures | 618.7 | 625.9 | 615.5 | 625.0 | 22981.0 |
| 2009-08-20 | FCE | Futures | 2271.3 | 2299.5 | 2271.3 | 2291.9 | 95471.0 |
| 2009-08-20 | FDAX | Futures | 5801.8 | 5854.5 | 5777.7 | 5821.0 | 121311.0 |
| 2009-08-20 | FESX | Futures | 1581.2 | 1596.1 | 1574.6 | 1587.1 | 941038.0 |
| 2009-08-20 | FEU3 | Futures | 97.707 | 97.717 | 97.707 | 97.717 | 85.0 |
| 2009-08-20 | FGBL | Futures | 93.03 | 93.26 | 92.83 | 93.13 | 541456.0 |
| 2009-08-20 | FGBM | Futures | 98.36 | 98.6 | 98.29 | 98.49 | 329261.0 |
| 2009-08-20 | FGBS | Futures | 104.138 | 104.215 | 104.104 | 104.196 | 432013.0 |
| 2009-08-20 | FGBX | Futures | 86.62 | 86.99 | 86.44 | 86.81 | 1152.0 |
| 2009-08-20 | FTDX | Futures | 619.2 | 626.8 | 619.2 | 622.4 | 412.0 |
| 2009-08-20 | FTI | Futures | 237.16 | 238.4 | 235.68 | 237.91 | 21612.0 |
| 2009-08-20 | FTUK | Futures | 3142.8 | 3163.1 | 3135.5 | 3154.8 | 106399.0 |
| 2009-08-20 | G | Futures | 76.63 | 76.7 | 76.47 | 76.62 | 53443.0 |
| 2009-08-20 | GF | Futures | 279.006 | 280.595 | 278.868 | 279.49 | 473.0 |
| 2009-08-20 | GSCI | Futures | 961.0 | 961.0 | 948.57 | 951.83 | 182.0 |
| 2009-08-20 | HE | Futures | 68.578 | 70.452 | 67.754 | 70.339 | 10187.0 |
| 2009-08-20 | HG | Futures | 3.8621 | 3.9158 | 3.8043 | 3.8378 | 10043.0 |
| 2009-08-20 | HO | Futures | 1.938 | 1.938 | 1.8965 | 1.9012 | 7639.0 |
| 2009-08-20 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-20 | J1 | Futures | 0.0133835 | 0.013415 | 0.0133168 | 0.013381 | 64996.0 |
| 2009-08-20 | J7 | Futures | 0.013207 | 0.013229 | 0.013136 | 0.013197 | 36.0 |
| 2009-08-20 | JB | Futures | 117.06 | 117.14 | 116.78 | 116.84 | 1520.0 |
| 2009-08-20 | KC | Futures | 340.13 | 340.13 | 331.55 | 332.07 | 9739.0 |
| 2009-08-20 | KE | Futures | 2383.79 | 2405.37 | 2368.2 | 2392.18 | 4799.0 |
| 2009-08-20 | L | Futures | 97.573 | 97.622 | 97.563 | 97.612 | 64773.0 |
| 2009-08-20 | LBS | Futures | 738.8 | 764.8 | 738.8 | 746.5 | 707.0 |
| 2009-08-20 | LE | Futures | 147.637 | 148.261 | 147.471 | 147.887 | 6537.0 |
> showing 50 of 85 rows — these rows as CSV