PREVIEW / futures_daily / 2009-08-27
file: by_date/futures_daily/2009/2009-08-27.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-08-27 | ES | Futures | 984.63 | 990.86 | 973.59 | 987.5 | 2068535.0 |
| 2009-08-27 | NQ | Futures | 1843.81 | 1850.85 | 1813.68 | 1845.78 | 315245.0 |
| 2009-08-27 | YM | Futures | 8591.2 | 8659.8 | 8520.0 | 8631.8 | 161849.0 |
| 2009-08-27 | CL | Futures | 178.05 | 182.01 | 174.23 | 180.87 | 272730.0 |
| 2009-08-27 | GC | Futures | 1309.0 | 1316.5 | 1303.1 | 1309.6 | 60455.0 |
| 2009-08-27 | ZN | Futures | 92.985105 | 93.231358 | 92.578788 | 92.874292 | 1305522.0 |
| 2009-08-27 | A6 | Futures | 0.66404 | 0.67577 | 0.6613 | 0.67456 | 93279.0 |
| 2009-08-27 | AD | Futures | 0.9 | 0.91215 | 0.89605 | 0.91097 | 64361.0 |
| 2009-08-27 | B | Futures | 68.18 | 69.4 | 67.12 | 69.08 | 59682.0 |
| 2009-08-27 | B6 | Futures | 1.6908 | 1.6983 | 1.6823 | 1.6962 | 100556.0 |
| 2009-08-27 | BFX | Futures | 2738.8 | 2738.8 | 2686.8 | 2701.5 | 117.0 |
| 2009-08-27 | BR | Futures | 0.2087 | 0.21015 | 0.2087 | 0.21015 | 314.0 |
| 2009-08-27 | C | Futures | 2009.0 | 2011.0 | 1890.0 | 1921.0 | 1184.0 |
| 2009-08-27 | CC | Futures | 2603.0 | 2621.0 | 2428.0 | 2475.0 | 10566.0 |
| 2009-08-27 | CT | Futures | 48.91 | 49.27 | 48.62 | 49.13 | 129.0 |
| 2009-08-27 | DC | Futures | 22.75 | 22.75 | 22.37 | 22.39 | 262.0 |
| 2009-08-27 | DX | Futures | 80.563 | 80.65 | 79.723 | 79.892 | 9901.0 |
| 2009-08-27 | E1 | Futures | 1.2392 | 1.258 | 1.23682 | 1.25217 | 44806.0 |
| 2009-08-27 | E6 | Futures | 1.69091 | 1.71049 | 1.68806 | 1.7061 | 229045.0 |
| 2009-08-27 | E7 | Futures | 1.6738 | 1.6929 | 1.671 | 1.6886 | 2080.0 |
| 2009-08-27 | ED | Futures | 94.0746 | 94.103 | 94.0699 | 94.0982 | 94395.0 |
| 2009-08-27 | ER | Futures | 97.144 | 97.179 | 97.135 | 97.159 | 78333.0 |
| 2009-08-27 | EW | Futures | 637.2 | 641.3 | 625.4 | 638.9 | 35554.0 |
| 2009-08-27 | FCE | Futures | 2396.0 | 2414.0 | 2374.8 | 2386.2 | 113460.0 |
| 2009-08-27 | FDAX | Futures | 6049.8 | 6082.2 | 5959.8 | 6003.7 | 137238.0 |
| 2009-08-27 | FESX | Futures | 1660.5 | 1674.9 | 1647.4 | 1656.4 | 972710.0 |
| 2009-08-27 | FEU3 | Futures | 97.717 | 97.736 | 97.717 | 97.736 | 233.0 |
| 2009-08-27 | FGBL | Futures | 93.37 | 93.44 | 93.03 | 93.26 | 620385.0 |
| 2009-08-27 | FGBM | Futures | 98.61 | 98.64 | 98.42 | 98.58 | 335082.0 |
| 2009-08-27 | FGBS | Futures | 104.253 | 104.297 | 104.196 | 104.268 | 382211.0 |
| 2009-08-27 | FGBX | Futures | 87.13 | 87.13 | 86.46 | 86.86 | 1811.0 |
| 2009-08-27 | FTDX | Futures | 626.4 | 633.1 | 614.3 | 621.0 | 581.0 |
| 2009-08-27 | FTI | Futures | 246.0 | 248.39 | 244.22 | 245.13 | 29561.0 |
| 2009-08-27 | FTUK | Futures | 3235.7 | 3263.6 | 3218.5 | 3231.8 | 106310.0 |
| 2009-08-27 | G | Futures | 77.0 | 77.07 | 76.68 | 76.89 | 70970.0 |
| 2009-08-27 | GF | Futures | 274.513 | 274.652 | 272.302 | 273.2 | 918.0 |
| 2009-08-27 | GSCI | Futures | 935.63 | 950.51 | 925.74 | 950.51 | 213.0 |
| 2009-08-27 | HE | Futures | 70.752 | 73.15 | 70.189 | 71.801 | 11991.0 |
| 2009-08-27 | HG | Futures | 4.0273 | 4.0433 | 3.9611 | 4.0022 | 11801.0 |
| 2009-08-27 | HO | Futures | 1.8684 | 1.889 | 1.8357 | 1.882 | 9597.0 |
| 2009-08-27 | HRC | Futures | 2738.7 | 2738.7 | 2586.5 | 2586.5 | 10.0 |
| 2009-08-27 | J1 | Futures | 0.0133634 | 0.0135082 | 0.0133533 | 0.0134704 | 111305.0 |
| 2009-08-27 | J7 | Futures | 0.013169 | 0.013322 | 0.013169 | 0.013285 | 45.0 |
| 2009-08-27 | JB | Futures | 116.99 | 117.2 | 116.95 | 117.1 | 1784.0 |
| 2009-08-27 | KC | Futures | 328.11 | 329.7 | 319.4 | 320.33 | 7791.0 |
| 2009-08-27 | KE | Futures | 2449.83 | 2470.77 | 2396.32 | 2441.68 | 10334.0 |
| 2009-08-27 | L | Futures | 97.651 | 97.671 | 97.632 | 97.651 | 39758.0 |
| 2009-08-27 | LBS | Futures | 729.1 | 736.0 | 722.6 | 729.9 | 362.0 |
| 2009-08-27 | LE | Futures | 145.431 | 146.513 | 145.265 | 145.806 | 14856.0 |
| 2009-08-27 | MP | Futures | 0.03969 | 0.03983 | 0.03932 | 0.03951 | 22513.0 |
> showing 50 of 84 rows — these rows as CSV