PREVIEW / futures_daily / 2009-03-26
file: by_date/futures_daily/2009/2009-03-26.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-03-26 | ES | Futures | 769.62 | 791.54 | 769.38 | 788.45 | 2733189.0 |
| 2009-03-26 | NQ | Futures | 1383.04 | 1440.06 | 1383.04 | 1430.23 | 386569.0 |
| 2009-03-26 | YM | Futures | 6884.4 | 7068.3 | 6879.9 | 7040.4 | 229949.0 |
| 2009-03-26 | CL | Futures | 148.34 | 153.45 | 148.12 | 152.55 | 196916.0 |
| 2009-03-26 | GC | Futures | 1298.6 | 1313.3 | 1293.6 | 1304.6 | 64228.0 |
| 2009-03-26 | ZN | Futures | 95.580301 | 96.150749 | 95.349695 | 96.053651 | 667485.0 |
| 2009-03-26 | A6 | Futures | 0.55395 | 0.55953 | 0.55371 | 0.55642 | 36918.0 |
| 2009-03-26 | AD | Futures | 0.80045 | 0.80527 | 0.79878 | 0.80104 | 37692.0 |
| 2009-03-26 | B | Futures | 51.97 | 53.35 | 51.97 | 53.04 | 49599.0 |
| 2009-03-26 | B6 | Futures | 1.5143 | 1.5233 | 1.501 | 1.5023 | 59509.0 |
| 2009-03-26 | BFX | Futures | 1912.1 | 1944.5 | 1912.0 | 1944.5 | 2241.0 |
| 2009-03-26 | C | Futures | 1961.0 | 1971.0 | 1943.0 | 1946.0 | 3153.0 |
| 2009-03-26 | CB | Futures | 75.533 | 75.683 | 75.533 | 75.683 | 24.0 |
| 2009-03-26 | CC | Futures | 2285.0 | 2310.0 | 2254.0 | 2280.0 | 4971.0 |
| 2009-03-26 | CT | Futures | 41.97 | 42.39 | 41.24 | 41.47 | 4753.0 |
| 2009-03-26 | DC | Futures | 31.62 | 32.22 | 31.5 | 31.57 | 213.0 |
| 2009-03-26 | DX | Futures | 86.721 | 87.256 | 86.412 | 87.128 | 2977.0 |
| 2009-03-26 | E1 | Futures | 1.18499 | 1.18777 | 1.17663 | 1.17809 | 25732.0 |
| 2009-03-26 | E6 | Futures | 1.61014 | 1.61726 | 1.59959 | 1.60208 | 168301.0 |
| 2009-03-26 | E7 | Futures | 1.5919 | 1.5993 | 1.5809 | 1.5835 | 1495.0 |
| 2009-03-26 | EBM | Futures | 206.66 | 206.66 | 203.18 | 204.73 | 7789.0 |
| 2009-03-26 | ED | Futures | 93.0775 | 93.1482 | 93.0681 | 93.134 | 167262.0 |
| 2009-03-26 | ER | Futures | 96.576 | 96.615 | 96.576 | 96.606 | 103192.0 |
| 2009-03-26 | EW | Futures | 472.2 | 495.1 | 472.2 | 492.5 | 38159.0 |
| 2009-03-26 | FCE | Futures | 1845.0 | 1853.3 | 1812.3 | 1834.9 | 110214.0 |
| 2009-03-26 | FDAX | Futures | 4634.2 | 4694.6 | 4604.2 | 4653.2 | 165388.0 |
| 2009-03-26 | FESX | Futures | 1251.1 | 1264.9 | 1234.9 | 1249.9 | 1196986.0 |
| 2009-03-26 | FEU3 | Futures | 97.165 | 97.19 | 97.165 | 97.185 | 1650.0 |
| 2009-03-26 | FGBL | Futures | 92.6 | 93.06 | 92.48 | 92.89 | 534558.0 |
| 2009-03-26 | FGBM | Futures | 97.39 | 97.72 | 97.32 | 97.62 | 379918.0 |
| 2009-03-26 | FGBS | Futures | 103.551 | 103.632 | 103.512 | 103.599 | 433707.0 |
| 2009-03-26 | FGBX | Futures | 81.64 | 82.72 | 81.43 | 82.41 | 1340.0 |
| 2009-03-26 | FTDX | Futures | 427.2 | 443.4 | 417.3 | 438.9 | 595.0 |
| 2009-03-26 | FTI | Futures | 185.18 | 185.92 | 181.44 | 183.53 | 31973.0 |
| 2009-03-26 | FTUK | Futures | 2580.9 | 2609.5 | 2551.2 | 2578.9 | 103406.0 |
| 2009-03-26 | G | Futures | 76.81 | 77.28 | 76.72 | 77.12 | 74683.0 |
| 2009-03-26 | GF | Futures | 262.203 | 264.158 | 259.9 | 260.877 | 307.0 |
| 2009-03-26 | GSCI | Futures | 810.2 | 814.46 | 798.72 | 807.01 | 141.0 |
| 2009-03-26 | HE | Futures | 117.666 | 118.821 | 117.171 | 118.12 | 205.0 |
| 2009-03-26 | HG | Futures | 2.5359 | 2.6444 | 2.5324 | 2.6134 | 11753.0 |
| 2009-03-26 | HO | Futures | 1.642 | 1.6692 | 1.6216 | 1.6435 | 13039.0 |
| 2009-03-26 | HRC | Futures | 2714.4 | 2714.4 | 2714.4 | 2714.4 | 0.0 |
| 2009-03-26 | J1 | Futures | 0.012924 | 0.0129517 | 0.0127602 | 0.0128081 | 50259.0 |
| 2009-03-26 | J7 | Futures | 0.012758 | 0.012758 | 0.012591 | 0.012634 | 84.0 |
| 2009-03-26 | JB | Futures | 116.28 | 116.4 | 115.89 | 116.02 | 2336.0 |
| 2009-03-26 | KC | Futures | 329.12 | 335.31 | 329.12 | 330.1 | 9351.0 |
| 2009-03-26 | KE | Futures | 2749.73 | 2775.61 | 2723.84 | 2760.82 | 6495.0 |
| 2009-03-26 | L | Futures | 96.738 | 96.777 | 96.738 | 96.748 | 21229.0 |
| 2009-03-26 | LBS | Futures | 907.9 | 920.9 | 899.1 | 914.1 | 227.0 |
| 2009-03-26 | LE | Futures | 145.653 | 146.228 | 144.504 | 144.681 | 6375.0 |
> showing 50 of 85 rows — these rows as CSV