PREVIEW / futures_daily / 2009-04-16
file: by_date/futures_daily/2009/2009-04-16.parquet size: 9 KB rows: 87
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-16 | ES | Futures | 808.7 | 826.33 | 800.84 | 821.09 | 2587100.0 |
| 2009-04-16 | NQ | Futures | 1479.38 | 1526.01 | 1468.71 | 1518.99 | 357821.0 |
| 2009-04-16 | YM | Futures | 7158.9 | 7282.6 | 7094.3 | 7232.4 | 188667.0 |
| 2009-04-16 | CL | Futures | 140.62 | 142.75 | 138.98 | 140.49 | 151035.0 |
| 2009-04-16 | GC | Futures | 1236.5 | 1239.2 | 1208.8 | 1218.2 | 80700.0 |
| 2009-04-16 | ZN | Futures | 96.126475 | 96.150749 | 95.568164 | 95.71381 | 504920.0 |
| 2009-04-16 | A6 | Futures | 0.5782 | 0.58123 | 0.56703 | 0.57118 | 50430.0 |
| 2009-04-16 | AD | Futures | 0.81719 | 0.82388 | 0.81069 | 0.81394 | 50462.0 |
| 2009-04-16 | B | Futures | 51.51 | 52.15 | 50.81 | 51.32 | 93375.0 |
| 2009-04-16 | B6 | Futures | 1.5596 | 1.5677 | 1.5439 | 1.5526 | 58094.0 |
| 2009-04-16 | BFX | Futures | 2019.8 | 2042.8 | 2006.6 | 2036.7 | 1043.0 |
| 2009-04-16 | BR | Futures | 0.17012 | 0.17271 | 0.17012 | 0.17271 | 7.0 |
| 2009-04-16 | BZ | Futures | 53.81 | 54.63 | 53.81 | 54.17 | 10.0 |
| 2009-04-16 | C | Futures | 1801.0 | 1808.0 | 1753.0 | 1756.0 | 3323.0 |
| 2009-04-16 | CB | Futures | 76.436 | 76.436 | 76.135 | 76.135 | 19.0 |
| 2009-04-16 | CC | Futures | 2162.0 | 2163.0 | 2092.0 | 2101.0 | 11573.0 |
| 2009-04-16 | CT | Futures | 45.59 | 46.65 | 44.85 | 46.52 | 6205.0 |
| 2009-04-16 | DC | Futures | 27.45 | 27.79 | 27.05 | 27.17 | 171.0 |
| 2009-04-16 | DX | Futures | 87.663 | 88.312 | 87.426 | 88.044 | 3279.0 |
| 2009-04-16 | E1 | Futures | 1.16059 | 1.16404 | 1.15184 | 1.15648 | 28770.0 |
| 2009-04-16 | E6 | Futures | 1.56592 | 1.57256 | 1.55537 | 1.56071 | 144450.0 |
| 2009-04-16 | E7 | Futures | 1.5475 | 1.5541 | 1.5373 | 1.5426 | 1753.0 |
| 2009-04-16 | EBM | Futures | 210.14 | 212.47 | 210.14 | 211.69 | 5141.0 |
| 2009-04-16 | ED | Futures | 93.299 | 93.3084 | 93.2802 | 93.2943 | 124555.0 |
| 2009-04-16 | ER | Futures | 96.723 | 96.728 | 96.689 | 96.709 | 80873.0 |
| 2009-04-16 | EW | Futures | 509.8 | 527.7 | 505.1 | 522.7 | 38923.0 |
| 2009-04-16 | FCE | Futures | 1867.2 | 1913.9 | 1855.2 | 1893.9 | 83020.0 |
| 2009-04-16 | FDAX | Futures | 4989.2 | 5084.0 | 4942.9 | 5024.1 | 162632.0 |
| 2009-04-16 | FESX | Futures | 1322.5 | 1354.9 | 1309.3 | 1336.3 | 1424610.0 |
| 2009-04-16 | FEU3 | Futures | 97.293 | 97.303 | 97.278 | 97.288 | 265.0 |
| 2009-04-16 | FGBL | Futures | 92.7 | 92.7 | 92.27 | 92.57 | 520956.0 |
| 2009-04-16 | FGBM | Futures | 97.92 | 97.93 | 97.44 | 97.79 | 354301.0 |
| 2009-04-16 | FGBS | Futures | 103.747 | 103.747 | 103.594 | 103.685 | 381366.0 |
| 2009-04-16 | FGBX | Futures | 82.49 | 82.55 | 81.93 | 82.48 | 1236.0 |
| 2009-04-16 | FTDX | Futures | 498.2 | 508.1 | 492.8 | 498.2 | 522.0 |
| 2009-04-16 | FTI | Futures | 193.83 | 196.09 | 191.69 | 194.53 | 13989.0 |
| 2009-04-16 | FTUK | Futures | 2636.8 | 2701.4 | 2606.5 | 2665.1 | 113495.0 |
| 2009-04-16 | G | Futures | 77.7 | 78.01 | 77.45 | 77.97 | 66514.0 |
| 2009-04-16 | GF | Futures | 281.61 | 281.89 | 276.933 | 276.933 | 846.0 |
| 2009-04-16 | GSCI | Futures | 806.8 | 806.8 | 795.74 | 799.57 | 225.0 |
| 2009-04-16 | HE | Futures | 118.161 | 119.028 | 117.749 | 118.615 | 656.0 |
| 2009-04-16 | HG | Futures | 3.1438 | 3.1459 | 3.0206 | 3.0565 | 16962.0 |
| 2009-04-16 | HO | Futures | 1.5656 | 1.584 | 1.5528 | 1.5752 | 21416.0 |
| 2009-04-16 | HRC | Futures | 2595.1 | 2595.1 | 2595.1 | 2595.1 | 0.0 |
| 2009-04-16 | J1 | Futures | 0.0126972 | 0.0128043 | 0.0126745 | 0.0126984 | 68373.0 |
| 2009-04-16 | J7 | Futures | 0.012531 | 0.01262 | 0.012511 | 0.012526 | 150.0 |
| 2009-04-16 | JB | Futures | 114.64 | 114.75 | 114.39 | 114.5 | 1295.0 |
| 2009-04-16 | KC | Futures | 324.9 | 327.29 | 318.85 | 319.97 | 5567.0 |
| 2009-04-16 | KE | Futures | 2775.61 | 2869.28 | 2741.1 | 2810.12 | 7247.0 |
| 2009-04-16 | L | Futures | 96.954 | 96.974 | 96.944 | 96.964 | 19802.0 |
> showing 50 of 87 rows — these rows as CSV