PREVIEW / futures_daily / 2009-07-28
file: by_date/futures_daily/2009/2009-07-28.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-07-28 | ES | Futures | 938.81 | 941.69 | 926.82 | 936.41 | 1932201.0 |
| 2009-07-28 | NQ | Futures | 1799.89 | 1810.87 | 1781.03 | 1803.55 | 307330.0 |
| 2009-07-28 | YM | Futures | 8178.9 | 8199.7 | 8086.0 | 8165.4 | 127945.0 |
| 2009-07-28 | CL | Futures | 175.75 | 177.29 | 171.16 | 173.09 | 253558.0 |
| 2009-07-28 | GC | Futures | 1321.7 | 1326.3 | 1294.7 | 1301.8 | 83800.0 |
| 2009-07-28 | ZN | Futures | 91.359836 | 91.975468 | 91.23671 | 91.47065 | 730450.0 |
| 2009-07-28 | A6 | Futures | 0.65881 | 0.66773 | 0.65664 | 0.66259 | 84741.0 |
| 2009-07-28 | AD | Futures | 0.91373 | 0.91917 | 0.90573 | 0.91255 | 67270.0 |
| 2009-07-28 | B | Futures | 67.22 | 68.01 | 65.82 | 66.6 | 64876.0 |
| 2009-07-28 | B6 | Futures | 1.7178 | 1.7244 | 1.707 | 1.7119 | 104619.0 |
| 2009-07-28 | BFX | Futures | 2432.2 | 2432.2 | 2394.6 | 2395.3 | 85.0 |
| 2009-07-28 | BR | Futures | 0.20591 | 0.20645 | 0.20423 | 0.20494 | 40.0 |
| 2009-07-28 | C | Futures | 1907.0 | 1956.0 | 1905.0 | 1926.0 | 3364.0 |
| 2009-07-28 | CB | Futures | 74.179 | 74.463 | 73.326 | 73.326 | 12.0 |
| 2009-07-28 | CC | Futures | 2562.0 | 2610.0 | 2545.0 | 2561.0 | 5036.0 |
| 2009-07-28 | CT | Futures | 50.73 | 51.21 | 50.21 | 50.39 | 125.0 |
| 2009-07-28 | DC | Futures | 21.61 | 21.97 | 21.54 | 21.84 | 152.0 |
| 2009-07-28 | DX | Futures | 80.604 | 81.074 | 80.266 | 80.859 | 5962.0 |
| 2009-07-28 | E1 | Futures | 1.23722 | 1.24304 | 1.22649 | 1.23245 | 46856.0 |
| 2009-07-28 | E6 | Futures | 1.69067 | 1.69827 | 1.67749 | 1.68295 | 257173.0 |
| 2009-07-28 | E7 | Futures | 1.6732 | 1.6808 | 1.6603 | 1.6657 | 2100.0 |
| 2009-07-28 | ED | Futures | 93.9377 | 93.9519 | 93.9283 | 93.9377 | 112916.0 |
| 2009-07-28 | ER | Futures | 97.071 | 97.09 | 97.071 | 97.086 | 65183.0 |
| 2009-07-28 | EW | Futures | 602.6 | 604.9 | 594.5 | 600.6 | 28393.0 |
| 2009-07-28 | FCE | Futures | 2224.8 | 2229.4 | 2176.6 | 2182.5 | 114788.0 |
| 2009-07-28 | FDAX | Futures | 5799.1 | 5821.6 | 5667.4 | 5681.2 | 132786.0 |
| 2009-07-28 | FESX | Futures | 1560.3 | 1565.7 | 1528.1 | 1533.4 | 1035023.0 |
| 2009-07-28 | FEU3 | Futures | 97.648 | 97.663 | 97.648 | 97.663 | 168.0 |
| 2009-07-28 | FGBL | Futures | 91.3 | 91.95 | 91.19 | 91.79 | 672474.0 |
| 2009-07-28 | FGBM | Futures | 97.54 | 98.0 | 97.48 | 97.9 | 336709.0 |
| 2009-07-28 | FGBS | Futures | 103.95 | 104.075 | 103.911 | 104.056 | 458752.0 |
| 2009-07-28 | FGBX | Futures | 82.68 | 83.97 | 82.57 | 83.73 | 1585.0 |
| 2009-07-28 | FTDX | Futures | 601.4 | 601.4 | 573.7 | 576.4 | 704.0 |
| 2009-07-28 | FTI | Futures | 229.16 | 229.16 | 223.66 | 224.35 | 32600.0 |
| 2009-07-28 | FTUK | Futures | 3030.6 | 3043.2 | 2976.2 | 2982.8 | 96071.0 |
| 2009-07-28 | G | Futures | 74.14 | 74.57 | 74.1 | 74.49 | 45066.0 |
| 2009-07-28 | GF | Futures | 282.797 | 284.313 | 280.867 | 283.486 | 1062.0 |
| 2009-07-28 | GSCI | Futures | 936.02 | 938.11 | 923.38 | 930.38 | 332.0 |
| 2009-07-28 | HE | Futures | 84.207 | 84.567 | 80.861 | 81.832 | 8879.0 |
| 2009-07-28 | HG | Futures | 3.5735 | 3.6107 | 3.5068 | 3.5391 | 20230.0 |
| 2009-07-28 | HO | Futures | 1.8303 | 1.8526 | 1.8018 | 1.8099 | 30186.0 |
| 2009-07-28 | HRC | Futures | 2434.4 | 2434.4 | 2434.4 | 2434.4 | 0.0 |
| 2009-07-28 | J1 | Futures | 0.0132325 | 0.0133949 | 0.0132186 | 0.0133218 | 105772.0 |
| 2009-07-28 | J7 | Futures | 0.013071 | 0.013207 | 0.013053 | 0.013138 | 60.0 |
| 2009-07-28 | JB | Futures | 116.53 | 116.53 | 116.48 | 116.5 | 1344.0 |
| 2009-07-28 | KC | Futures | 339.18 | 342.7 | 326.42 | 333.21 | 11286.0 |
| 2009-07-28 | KE | Futures | 2642.79 | 2695.55 | 2626.0 | 2638.0 | 9736.0 |
| 2009-07-28 | L | Futures | 97.347 | 97.396 | 97.337 | 97.367 | 28652.0 |
| 2009-07-28 | LBS | Futures | 807.8 | 840.3 | 807.8 | 840.3 | 967.0 |
| 2009-07-28 | LE | Futures | 150.01 | 151.675 | 150.01 | 150.8 | 13731.0 |
> showing 50 of 85 rows — these rows as CSV