PREVIEW / futures_daily / 2009-03-31
file: by_date/futures_daily/2009/2009-03-31.parquet size: 8 KB rows: 86
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-31 | ES | Futures | 747.7 | 769.15 | 747.22 | 757.47 | 2688645.0 |
| 2009-03-31 | NQ | Futures | 1373.77 | 1413.1 | 1372.93 | 1390.34 | 311992.0 |
| 2009-03-31 | YM | Futures | 6710.4 | 6880.8 | 6706.8 | 6783.0 | 186606.0 |
| 2009-03-31 | CL | Futures | 136.55 | 140.37 | 134.11 | 139.41 | 240254.0 |
| 2009-03-31 | GC | Futures | 1272.9 | 1283.4 | 1265.0 | 1280.8 | 93007.0 |
| 2009-03-31 | ZN | Futures | 96.1022 | 96.49059 | 95.93228 | 96.381355 | 437242.0 |
| 2009-03-31 | A6 | Futures | 0.54071 | 0.55323 | 0.53872 | 0.5522 | 42647.0 |
| 2009-03-31 | AD | Futures | 0.78174 | 0.78824 | 0.77859 | 0.78184 | 41995.0 |
| 2009-03-31 | B | Futures | 48.35 | 49.52 | 47.25 | 48.91 | 69191.0 |
| 2009-03-31 | B6 | Futures | 1.4844 | 1.4961 | 1.482 | 1.4929 | 55691.0 |
| 2009-03-31 | BFX | Futures | 1852.7 | 1918.7 | 1852.6 | 1918.7 | 250.0 |
| 2009-03-31 | BZ | Futures | 51.5 | 51.62 | 50.27 | 51.62 | 6.0 |
| 2009-03-31 | C | Futures | 1990.0 | 1997.0 | 1966.0 | 1985.0 | 4122.0 |
| 2009-03-31 | CB | Futures | 75.683 | 75.683 | 75.683 | 75.683 | 1.0 |
| 2009-03-31 | CC | Futures | 2266.0 | 2305.0 | 2254.0 | 2292.0 | 6888.0 |
| 2009-03-31 | CT | Futures | 41.98 | 43.87 | 41.98 | 43.84 | 9263.0 |
| 2009-03-31 | DC | Futures | 30.66 | 31.26 | 30.66 | 31.05 | 149.0 |
| 2009-03-31 | DX | Futures | 88.75 | 88.878 | 88.111 | 88.451 | 4144.0 |
| 2009-03-31 | E1 | Futures | 1.15555 | 1.16947 | 1.15303 | 1.16536 | 29454.0 |
| 2009-03-31 | E6 | Futures | 1.56533 | 1.58205 | 1.56189 | 1.5747 | 154352.0 |
| 2009-03-31 | E7 | Futures | 1.5475 | 1.5637 | 1.5441 | 1.5564 | 1601.0 |
| 2009-03-31 | EBM | Futures | 204.73 | 207.82 | 204.34 | 204.34 | 5026.0 |
| 2009-03-31 | ED | Futures | 93.2 | 93.2472 | 93.1812 | 93.233 | 164192.0 |
| 2009-03-31 | ER | Futures | 96.689 | 96.723 | 96.674 | 96.713 | 105243.0 |
| 2009-03-31 | EW | Futures | 462.6 | 479.2 | 460.3 | 471.6 | 36015.0 |
| 2009-03-31 | FCE | Futures | 1727.6 | 1803.8 | 1727.6 | 1781.9 | 133865.0 |
| 2009-03-31 | FDAX | Futures | 4358.1 | 4511.6 | 4358.1 | 4467.5 | 149352.0 |
| 2009-03-31 | FESX | Futures | 1164.1 | 1210.9 | 1162.3 | 1195.9 | 1378355.0 |
| 2009-03-31 | FEU3 | Futures | 97.268 | 97.293 | 97.264 | 97.293 | 388.0 |
| 2009-03-31 | FGBL | Futures | 93.63 | 94.0 | 93.53 | 93.91 | 518707.0 |
| 2009-03-31 | FGBM | Futures | 98.24 | 98.39 | 98.19 | 98.35 | 368001.0 |
| 2009-03-31 | FGBS | Futures | 103.911 | 103.978 | 103.901 | 103.963 | 335634.0 |
| 2009-03-31 | FGBX | Futures | 84.12 | 84.72 | 83.99 | 84.45 | 2190.0 |
| 2009-03-31 | FTDX | Futures | 423.6 | 432.6 | 423.6 | 430.8 | 315.0 |
| 2009-03-31 | FTI | Futures | 172.42 | 178.59 | 172.42 | 177.77 | 31917.0 |
| 2009-03-31 | FTUK | Futures | 2502.6 | 2606.8 | 2499.0 | 2586.8 | 173429.0 |
| 2009-03-31 | G | Futures | 77.78 | 78.3 | 77.76 | 78.15 | 51701.0 |
| 2009-03-31 | GF | Futures | 258.364 | 260.807 | 256.898 | 260.179 | 357.0 |
| 2009-03-31 | GSCI | Futures | 759.17 | 765.33 | 741.3 | 764.48 | 453.0 |
| 2009-03-31 | HE | Futures | 116.016 | 118.904 | 115.975 | 118.904 | 402.0 |
| 2009-03-31 | HG | Futures | 2.4887 | 2.619 | 2.4873 | 2.5986 | 16707.0 |
| 2009-03-31 | HO | Futures | 1.5007 | 1.5365 | 1.4696 | 1.518 | 14557.0 |
| 2009-03-31 | HRC | Futures | 2684.6 | 2684.6 | 2684.6 | 2684.6 | 0.0 |
| 2009-03-31 | J1 | Futures | 0.012953 | 0.0129706 | 0.0126959 | 0.0127337 | 75619.0 |
| 2009-03-31 | J7 | Futures | 0.012704 | 0.01271 | 0.012528 | 0.012561 | 62.0 |
| 2009-03-31 | JB | Futures | 115.82 | 115.93 | 115.58 | 115.58 | 1562.0 |
| 2009-03-31 | KC | Futures | 318.85 | 326.73 | 318.71 | 325.6 | 8225.0 |
| 2009-03-31 | KE | Futures | 2742.33 | 2829.84 | 2715.22 | 2826.14 | 7006.0 |
| 2009-03-31 | L | Futures | 96.836 | 96.925 | 96.816 | 96.895 | 51372.0 |
| 2009-03-31 | LBS | Futures | 883.6 | 896.5 | 875.8 | 887.7 | 77.0 |
> showing 50 of 86 rows — these rows as CSV