PREVIEW / futures_daily / 2009-04-20
file: by_date/futures_daily/2009/2009-04-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-04-20 | ES | Futures | 824.9 | 824.9 | 789.88 | 793.93 | 2217804.0 |
| 2009-04-20 | NQ | Futures | 1516.18 | 1516.18 | 1462.25 | 1475.73 | 280756.0 |
| 2009-04-20 | YM | Futures | 7237.8 | 7241.4 | 6983.0 | 7014.4 | 150956.0 |
| 2009-04-20 | CL | Futures | 140.76 | 141.16 | 129.79 | 130.66 | 255098.0 |
| 2009-04-20 | GC | Futures | 1204.9 | 1231.9 | 1198.5 | 1228.8 | 75861.0 |
| 2009-04-20 | ZN | Futures | 94.937031 | 95.701673 | 94.888482 | 95.568164 | 501166.0 |
| 2009-04-20 | A6 | Futures | 0.57453 | 0.57525 | 0.55252 | 0.55379 | 53616.0 |
| 2009-04-20 | AD | Futures | 0.81118 | 0.81226 | 0.79444 | 0.79572 | 47390.0 |
| 2009-04-20 | B | Futures | 51.32 | 51.32 | 47.98 | 48.23 | 116597.0 |
| 2009-04-20 | B6 | Futures | 1.538 | 1.5416 | 1.5083 | 1.5132 | 77307.0 |
| 2009-04-20 | BFX | Futures | 2103.3 | 2104.2 | 2002.8 | 2007.4 | 235.0 |
| 2009-04-20 | BZ | Futures | 52.22 | 52.22 | 50.81 | 50.91 | 32.0 |
| 2009-04-20 | C | Futures | 1798.0 | 1816.0 | 1782.0 | 1801.0 | 2145.0 |
| 2009-04-20 | CB | Futures | 75.698 | 75.698 | 75.683 | 75.683 | 8.0 |
| 2009-04-20 | CC | Futures | 2111.0 | 2118.0 | 2081.0 | 2099.0 | 3900.0 |
| 2009-04-20 | CT | Futures | 47.11 | 47.11 | 44.89 | 45.08 | 5244.0 |
| 2009-04-20 | DC | Futures | 27.55 | 28.0 | 27.19 | 27.24 | 118.0 |
| 2009-04-20 | DX | Futures | 88.93 | 89.815 | 88.703 | 89.568 | 9443.0 |
| 2009-04-20 | E1 | Futures | 1.13791 | 1.13911 | 1.13009 | 1.1354 | 26362.0 |
| 2009-04-20 | E6 | Futures | 1.54624 | 1.54624 | 1.52716 | 1.53131 | 141224.0 |
| 2009-04-20 | E7 | Futures | 1.5267 | 1.5287 | 1.5094 | 1.5135 | 2139.0 |
| 2009-04-20 | EBM | Futures | 214.4 | 215.18 | 211.69 | 214.01 | 5247.0 |
| 2009-04-20 | ED | Futures | 93.2566 | 93.2802 | 93.1953 | 93.2425 | 223625.0 |
| 2009-04-20 | ER | Futures | 96.664 | 96.664 | 96.606 | 96.645 | 156273.0 |
| 2009-04-20 | EW | Futures | 527.6 | 527.6 | 501.3 | 505.7 | 30931.0 |
| 2009-04-20 | FCE | Futures | 1923.7 | 1927.2 | 1832.0 | 1848.8 | 135561.0 |
| 2009-04-20 | FDAX | Futures | 5082.9 | 5090.5 | 4865.1 | 4899.9 | 158547.0 |
| 2009-04-20 | FESX | Futures | 1355.5 | 1358.5 | 1292.5 | 1303.9 | 1299017.0 |
| 2009-04-20 | FEU3 | Futures | 97.229 | 97.239 | 97.195 | 97.224 | 214.0 |
| 2009-04-20 | FGBL | Futures | 91.91 | 92.86 | 91.87 | 92.75 | 610284.0 |
| 2009-04-20 | FGBM | Futures | 97.34 | 97.87 | 97.3 | 97.81 | 332480.0 |
| 2009-04-20 | FGBS | Futures | 103.517 | 103.699 | 103.483 | 103.671 | 418336.0 |
| 2009-04-20 | FGBX | Futures | 82.1 | 83.2 | 81.93 | 83.04 | 1142.0 |
| 2009-04-20 | FTDX | Futures | 517.1 | 521.6 | 485.6 | 491.0 | 1356.0 |
| 2009-04-20 | FTI | Futures | 199.18 | 199.18 | 190.04 | 190.95 | 33457.0 |
| 2009-04-20 | FTUK | Futures | 2686.4 | 2709.0 | 2601.5 | 2622.5 | 107793.0 |
| 2009-04-20 | G | Futures | 77.41 | 78.18 | 77.31 | 78.16 | 74283.0 |
| 2009-04-20 | GF | Futures | 276.724 | 276.724 | 273.792 | 274.56 | 795.0 |
| 2009-04-20 | GSCI | Futures | 781.07 | 781.07 | 757.57 | 757.57 | 291.0 |
| 2009-04-20 | HE | Futures | 118.203 | 118.203 | 115.933 | 117.047 | 441.0 |
| 2009-04-20 | HG | Futures | 3.091 | 3.0952 | 2.913 | 2.9616 | 11343.0 |
| 2009-04-20 | HO | Futures | 1.5753 | 1.5852 | 1.4669 | 1.4759 | 26976.0 |
| 2009-04-20 | HRC | Futures | 2595.1 | 2595.1 | 2595.1 | 2595.1 | 0.0 |
| 2009-04-20 | J1 | Futures | 0.0127123 | 0.0129165 | 0.0126858 | 0.012895 | 75268.0 |
| 2009-04-20 | J7 | Futures | 0.012545 | 0.012739 | 0.01254 | 0.01272 | 361.0 |
| 2009-04-20 | JB | Futures | 114.38 | 114.59 | 114.33 | 114.5 | 913.0 |
| 2009-04-20 | KC | Futures | 314.63 | 316.85 | 312.55 | 314.77 | 9979.0 |
| 2009-04-20 | KE | Futures | 2806.42 | 2815.05 | 2721.38 | 2755.89 | 7626.0 |
| 2009-04-20 | L | Futures | 96.905 | 96.944 | 96.866 | 96.934 | 78440.0 |
| 2009-04-20 | LBS | Futures | 903.2 | 905.8 | 884.6 | 896.5 | 269.0 |
> showing 50 of 85 rows — these rows as CSV