PREVIEW / futures_daily / 2008-03-20
file: by_date/futures_daily/2008/2008-03-20.parquet size: 8 KB rows: 82
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-20 | ES | Futures | 1204.24 | 1233.87 | 1191.28 | 1226.69 | 2162947.0 |
| 2008-03-20 | NQ | Futures | 1928.82 | 1966.55 | 1911.22 | 1956.21 | 387747.0 |
| 2008-03-20 | YM | Futures | 11001.9 | 11001.9 | 10696.5 | 10946.9 | 182539.0 |
| 2008-03-20 | CL | Futures | 443.96 | 446.53 | 428.96 | 442.83 | 332794.0 |
| 2008-03-20 | GC | Futures | 1348.0 | 1349.3 | 1293.4 | 1315.2 | 230124.0 |
| 2008-03-20 | ZN | Futures | 87.255452 | 87.426251 | 87.02772 | 87.323772 | 602753.0 |
| 2008-03-20 | A6 | Futures | 0.68905 | 0.69218 | 0.67607 | 0.67714 | 51748.0 |
| 2008-03-20 | AD | Futures | 0.96864 | 0.97021 | 0.95281 | 0.9535 | 58999.0 |
| 2008-03-20 | B | Futures | 119.43 | 120.42 | 116.96 | 119.8 | 113357.0 |
| 2008-03-20 | B6 | Futures | 2.0119 | 2.0178 | 2.0014 | 2.0128 | 65750.0 |
| 2008-03-20 | BFX | Futures | 4071.7 | 4099.6 | 4034.0 | 4096.2 | 713.0 |
| 2008-03-20 | BR | Futures | 0.20546 | 0.20546 | 0.20391 | 0.20391 | 2.0 |
| 2008-03-20 | BZ | Futures | 116.99 | 117.96 | 114.7 | 117.51 | 1843.0 |
| 2008-03-20 | C | Futures | 1149.0 | 1150.0 | 1046.0 | 1105.0 | 14801.0 |
| 2008-03-20 | CB | Futures | 88.378 | 88.853 | 88.378 | 88.853 | 20.0 |
| 2008-03-20 | CC | Futures | 2236.0 | 2247.0 | 2072.0 | 2109.0 | 70.0 |
| 2008-03-20 | CT | Futures | 84.39 | 88.39 | 81.36 | 83.71 | 21333.0 |
| 2008-03-20 | DC | Futures | 46.13 | 46.29 | 45.96 | 46.02 | 62.0 |
| 2008-03-20 | DX | Futures | 78.013 | 79.089 | 77.97 | 78.798 | 5283.0 |
| 2008-03-20 | E1 | Futures | 1.33588 | 1.33668 | 1.3099 | 1.31909 | 52520.0 |
| 2008-03-20 | E6 | Futures | 1.81354 | 1.81435 | 1.78547 | 1.78908 | 204361.0 |
| 2008-03-20 | E7 | Futures | 1.7981 | 1.7985 | 1.7702 | 1.7737 | 2991.0 |
| 2008-03-20 | EBM | Futures | 239.46 | 239.67 | 230.97 | 232.49 | 2063.0 |
| 2008-03-20 | ED | Futures | 92.0872 | 92.1202 | 91.9226 | 91.9837 | 280123.0 |
| 2008-03-20 | ER | Futures | 94.022 | 94.022 | 93.943 | 93.948 | 145735.0 |
| 2008-03-20 | EW | Futures | 744.6 | 761.8 | 739.3 | 755.6 | 34076.0 |
| 2008-03-20 | FCE | Futures | 2909.9 | 2949.1 | 2882.3 | 2918.5 | 174090.0 |
| 2008-03-20 | FDAX | Futures | 7239.7 | 7347.5 | 7196.0 | 7347.5 | 182796.0 |
| 2008-03-20 | FESX | Futures | 2003.3 | 2041.4 | 1984.5 | 2041.4 | 1734698.0 |
| 2008-03-20 | FEU3 | Futures | 94.516 | 94.521 | 94.477 | 94.482 | 2786.0 |
| 2008-03-20 | FGBL | Futures | 88.78 | 88.81 | 88.4 | 88.55 | 814652.0 |
| 2008-03-20 | FGBM | Futures | 94.35 | 94.46 | 93.94 | 94.01 | 540062.0 |
| 2008-03-20 | FGBS | Futures | 101.751 | 101.853 | 101.553 | 101.567 | 707747.0 |
| 2008-03-20 | FGBX | Futures | 78.74 | 79.4 | 78.56 | 79.4 | 5593.0 |
| 2008-03-20 | FTDX | Futures | 627.5 | 645.6 | 627.5 | 638.3 | 3014.0 |
| 2008-03-20 | FTI | Futures | 314.8 | 318.39 | 314.01 | 317.49 | 45546.0 |
| 2008-03-20 | FTUK | Futures | 3572.1 | 3600.6 | 3544.3 | 3572.5 | 152494.0 |
| 2008-03-20 | G | Futures | 70.96 | 71.16 | 70.75 | 70.96 | 73236.0 |
| 2008-03-20 | GF | Futures | 291.774 | 299.068 | 290.844 | 297.567 | 148.0 |
| 2008-03-20 | GSCI | Futures | 1726.4 | 1763.47 | 1716.34 | 1748.91 | 418.0 |
| 2008-03-20 | HE | Futures | 129.591 | 134.437 | 129.542 | 134.437 | 58.0 |
| 2008-03-20 | HG | Futures | 5.0498 | 5.0498 | 4.828 | 4.9849 | 17088.0 |
| 2008-03-20 | HO | Futures | 3.3632 | 3.3732 | 3.2768 | 3.3185 | 13232.0 |
| 2008-03-20 | J1 | Futures | 0.0129764 | 0.013016 | 0.012785 | 0.0129994 | 113329.0 |
| 2008-03-20 | J7 | Futures | 0.012697 | 0.012731 | 0.012524 | 0.012726 | 62.0 |
| 2008-03-20 | KC | Futures | 419.09 | 422.88 | 397.16 | 413.09 | 15724.0 |
| 2008-03-20 | KE | Futures | 6038.64 | 6147.38 | 5464.04 | 5541.91 | 7370.0 |
| 2008-03-20 | L | Futures | 93.854 | 93.864 | 93.666 | 93.696 | 111620.0 |
| 2008-03-20 | LE | Futures | 188.836 | 192.304 | 188.784 | 191.201 | 3956.0 |
| 2008-03-20 | MP | Futures | 0.04406 | 0.0441 | 0.04395 | 0.04397 | 22797.0 |
> showing 50 of 82 rows — these rows as CSV