PREVIEW / futures_daily / 2009-05-12
file: by_date/futures_daily/2009/2009-05-12.parquet size: 8 KB rows: 84
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-12 | ES | Futures | 866.12 | 872.32 | 852.07 | 864.22 | 2530397.0 |
| 2009-05-12 | NQ | Futures | 1569.54 | 1580.22 | 1528.82 | 1556.06 | 366820.0 |
| 2009-05-12 | YM | Futures | 7537.4 | 7607.3 | 7469.2 | 7567.0 | 177864.0 |
| 2009-05-12 | CL | Futures | 156.49 | 161.82 | 155.71 | 158.51 | 305957.0 |
| 2009-05-12 | GC | Futures | 1265.4 | 1280.6 | 1263.3 | 1279.2 | 88788.0 |
| 2009-05-12 | ZN | Futures | 94.184526 | 94.37872 | 93.881096 | 94.220937 | 574302.0 |
| 2009-05-12 | A6 | Futures | 0.60268 | 0.61105 | 0.60156 | 0.60866 | 49785.0 |
| 2009-05-12 | AD | Futures | 0.84407 | 0.85322 | 0.8418 | 0.84771 | 52971.0 |
| 2009-05-12 | B | Futures | 56.12 | 57.48 | 55.66 | 56.59 | 133469.0 |
| 2009-05-12 | B6 | Futures | 1.5719 | 1.5973 | 1.5682 | 1.5889 | 94639.0 |
| 2009-05-12 | BFX | Futures | 2334.8 | 2366.4 | 2318.4 | 2357.8 | 1827.0 |
| 2009-05-12 | BZ | Futures | 61.43 | 61.43 | 60.82 | 61.33 | 20.0 |
| 2009-05-12 | C | Futures | 1857.0 | 1859.0 | 1772.0 | 1772.0 | 10275.0 |
| 2009-05-12 | CC | Futures | 2161.0 | 2201.0 | 2073.0 | 2097.0 | 10115.0 |
| 2009-05-12 | CT | Futures | 56.19 | 57.06 | 55.06 | 55.81 | 12353.0 |
| 2009-05-12 | DC | Futures | 25.39 | 25.63 | 25.08 | 25.27 | 172.0 |
| 2009-05-12 | DX | Futures | 85.357 | 85.48 | 84.553 | 84.873 | 6522.0 |
| 2009-05-12 | E1 | Futures | 1.1952 | 1.2054 | 1.1944 | 1.19957 | 31718.0 |
| 2009-05-12 | E6 | Futures | 1.60931 | 1.62472 | 1.60754 | 1.61666 | 190214.0 |
| 2009-05-12 | E7 | Futures | 1.5902 | 1.6058 | 1.5891 | 1.5979 | 2570.0 |
| 2009-05-12 | ED | Futures | 93.5111 | 93.5158 | 93.4828 | 93.5111 | 163765.0 |
| 2009-05-12 | ER | Futures | 96.792 | 96.806 | 96.782 | 96.792 | 79261.0 |
| 2009-05-12 | EW | Futures | 554.5 | 559.7 | 537.8 | 548.2 | 33778.0 |
| 2009-05-12 | FCE | Futures | 2051.9 | 2090.3 | 2050.0 | 2067.2 | 144321.0 |
| 2009-05-12 | FDAX | Futures | 5271.3 | 5372.6 | 5251.1 | 5296.3 | 171349.0 |
| 2009-05-12 | FESX | Futures | 1429.9 | 1457.5 | 1424.5 | 1440.1 | 1267039.0 |
| 2009-05-12 | FEU3 | Futures | 97.367 | 97.372 | 97.367 | 97.372 | 847.0 |
| 2009-05-12 | FGBL | Futures | 91.32 | 91.32 | 90.96 | 91.04 | 632151.0 |
| 2009-05-12 | FGBM | Futures | 97.39 | 97.42 | 97.14 | 97.26 | 378387.0 |
| 2009-05-12 | FGBS | Futures | 103.776 | 103.8 | 103.651 | 103.709 | 491866.0 |
| 2009-05-12 | FGBX | Futures | 81.17 | 81.19 | 80.59 | 80.64 | 1013.0 |
| 2009-05-12 | FTDX | Futures | 535.1 | 557.6 | 528.8 | 547.7 | 1478.0 |
| 2009-05-12 | FTI | Futures | 208.28 | 212.44 | 208.23 | 209.47 | 16256.0 |
| 2009-05-12 | FTUK | Futures | 2916.4 | 2951.7 | 2907.5 | 2927.4 | 103886.0 |
| 2009-05-12 | G | Futures | 75.43 | 75.65 | 75.28 | 75.53 | 91890.0 |
| 2009-05-12 | GF | Futures | 280.04 | 281.143 | 278.938 | 279.627 | 855.0 |
| 2009-05-12 | GSCI | Futures | 897.26 | 897.26 | 876.78 | 887.45 | 229.0 |
| 2009-05-12 | HE | Futures | 101.575 | 104.01 | 101.575 | 103.261 | 12198.0 |
| 2009-05-12 | HG | Futures | 2.9243 | 3.0319 | 2.9025 | 2.9348 | 16011.0 |
| 2009-05-12 | HO | Futures | 1.6327 | 1.6768 | 1.6228 | 1.6442 | 33700.0 |
| 2009-05-12 | HRC | Futures | 2520.0 | 2520.0 | 2520.0 | 2520.0 | 0.0 |
| 2009-05-12 | J1 | Futures | 0.0129417 | 0.0131181 | 0.0128862 | 0.013079 | 90415.0 |
| 2009-05-12 | J7 | Futures | 0.012767 | 0.012939 | 0.01273 | 0.012901 | 76.0 |
| 2009-05-12 | JB | Futures | 114.56 | 114.64 | 114.43 | 114.44 | 1044.0 |
| 2009-05-12 | KC | Futures | 354.95 | 362.29 | 353.14 | 356.89 | 13561.0 |
| 2009-05-12 | KE | Futures | 3088.8 | 3132.68 | 3037.6 | 3108.3 | 9716.0 |
| 2009-05-12 | L | Futures | 96.993 | 97.033 | 96.983 | 97.013 | 49890.0 |
| 2009-05-12 | LBS | Futures | 842.9 | 857.9 | 827.8 | 827.8 | 255.0 |
| 2009-05-12 | LE | Futures | 147.421 | 148.305 | 146.935 | 147.067 | 8126.0 |
| 2009-05-12 | MP | Futures | 0.03862 | 0.03913 | 0.03855 | 0.03881 | 7645.0 |
> showing 50 of 84 rows — these rows as CSV