PREVIEW / futures_daily / 2009-05-22
file: by_date/futures_daily/2009/2009-05-22.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-05-22 | ES | Futures | 847.06 | 853.97 | 840.63 | 843.49 | 1651521.0 |
| 2009-05-22 | NQ | Futures | 1537.24 | 1549.6 | 1519.27 | 1528.82 | 211742.0 |
| 2009-05-22 | YM | Futures | 7440.5 | 7493.4 | 7393.0 | 7409.1 | 112949.0 |
| 2009-05-22 | CL | Futures | 162.53 | 165.0 | 161.06 | 164.18 | 186302.0 |
| 2009-05-22 | GC | Futures | 1322.4 | 1333.5 | 1315.5 | 1327.7 | 117824.0 |
| 2009-05-22 | ZN | Futures | 93.043631 | 93.298511 | 92.497457 | 92.57028 | 673648.0 |
| 2009-05-22 | A6 | Futures | 0.61975 | 0.62653 | 0.61847 | 0.62469 | 39752.0 |
| 2009-05-22 | AD | Futures | 0.86632 | 0.8802 | 0.86582 | 0.87695 | 66237.0 |
| 2009-05-22 | B | Futures | 57.91 | 58.7 | 57.41 | 58.54 | 70723.0 |
| 2009-05-22 | B6 | Futures | 1.6488 | 1.6588 | 1.6393 | 1.6561 | 69942.0 |
| 2009-05-22 | BFX | Futures | 2354.1 | 2368.0 | 2334.3 | 2350.0 | 156.0 |
| 2009-05-22 | BZ | Futures | 62.96 | 63.44 | 62.62 | 63.44 | 18.0 |
| 2009-05-22 | C | Futures | 1718.0 | 1748.0 | 1704.0 | 1741.0 | 3230.0 |
| 2009-05-22 | CB | Futures | 76.737 | 76.737 | 76.737 | 76.737 | 5.0 |
| 2009-05-22 | CC | Futures | 2101.0 | 2148.0 | 2092.0 | 2135.0 | 6002.0 |
| 2009-05-22 | CT | Futures | 52.35 | 53.21 | 52.35 | 52.84 | 5788.0 |
| 2009-05-22 | DC | Futures | 24.27 | 24.39 | 24.15 | 24.24 | 78.0 |
| 2009-05-22 | DX | Futures | 82.849 | 82.967 | 82.283 | 82.437 | 11456.0 |
| 2009-05-22 | E1 | Futures | 1.21376 | 1.22649 | 1.2131 | 1.22344 | 32443.0 |
| 2009-05-22 | E6 | Futures | 1.64772 | 1.66539 | 1.64618 | 1.66124 | 182514.0 |
| 2009-05-22 | E7 | Futures | 1.6283 | 1.6461 | 1.628 | 1.642 | 2165.0 |
| 2009-05-22 | ED | Futures | 93.6572 | 93.6879 | 93.5936 | 93.6101 | 306839.0 |
| 2009-05-22 | ER | Futures | 96.767 | 96.772 | 96.733 | 96.743 | 121671.0 |
| 2009-05-22 | EW | Futures | 537.1 | 541.7 | 528.8 | 529.9 | 21501.0 |
| 2009-05-22 | FCE | Futures | 2087.1 | 2108.5 | 2067.2 | 2087.7 | 91844.0 |
| 2009-05-22 | FDAX | Futures | 5349.2 | 5409.6 | 5304.0 | 5357.9 | 119562.0 |
| 2009-05-22 | FESX | Futures | 1451.5 | 1471.9 | 1443.7 | 1456.9 | 956286.0 |
| 2009-05-22 | FEU3 | Futures | 97.347 | 97.347 | 97.323 | 97.323 | 99.0 |
| 2009-05-22 | FGBL | Futures | 90.81 | 90.97 | 90.39 | 90.76 | 513329.0 |
| 2009-05-22 | FGBM | Futures | 97.37 | 97.47 | 97.18 | 97.34 | 315142.0 |
| 2009-05-22 | FGBS | Futures | 103.843 | 103.896 | 103.805 | 103.829 | 308957.0 |
| 2009-05-22 | FGBX | Futures | 79.66 | 80.19 | 79.66 | 79.78 | 1313.0 |
| 2009-05-22 | FTDX | Futures | 554.0 | 565.7 | 549.5 | 558.5 | 985.0 |
| 2009-05-22 | FTI | Futures | 214.08 | 216.35 | 212.68 | 214.58 | 25931.0 |
| 2009-05-22 | FTUK | Futures | 2893.1 | 2915.8 | 2873.5 | 2892.5 | 76444.0 |
| 2009-05-22 | G | Futures | 75.32 | 75.42 | 75.11 | 75.26 | 72572.0 |
| 2009-05-22 | GF | Futures | 280.661 | 281.832 | 279.903 | 280.936 | 703.0 |
| 2009-05-22 | GSCI | Futures | 885.1 | 899.18 | 885.1 | 895.98 | 217.0 |
| 2009-05-22 | HE | Futures | 98.579 | 99.178 | 98.242 | 98.841 | 2777.0 |
| 2009-05-22 | HG | Futures | 2.8982 | 2.9848 | 2.8715 | 2.951 | 13453.0 |
| 2009-05-22 | HO | Futures | 1.6527 | 1.6605 | 1.6247 | 1.659 | 5584.0 |
| 2009-05-22 | HRC | Futures | 2495.0 | 2495.0 | 2495.0 | 2495.0 | 0.0 |
| 2009-05-22 | J1 | Futures | 0.0133613 | 0.0134306 | 0.0132769 | 0.01335 | 72961.0 |
| 2009-05-22 | J7 | Futures | 0.013182 | 0.013241 | 0.013103 | 0.013169 | 40.0 |
| 2009-05-22 | JB | Futures | 114.71 | 114.8 | 114.47 | 114.7 | 2587.0 |
| 2009-05-22 | KC | Futures | 375.73 | 380.71 | 370.32 | 374.06 | 8900.0 |
| 2009-05-22 | KE | Futures | 3149.74 | 3254.57 | 3149.74 | 3220.44 | 9031.0 |
| 2009-05-22 | L | Futures | 97.151 | 97.17 | 97.111 | 97.131 | 29023.0 |
| 2009-05-22 | LBS | Futures | 787.6 | 800.0 | 787.6 | 797.2 | 92.0 |
| 2009-05-22 | LE | Futures | 146.977 | 147.902 | 146.272 | 147.638 | 5967.0 |
> showing 50 of 85 rows — these rows as CSV