PREVIEW / futures_daily / 2009-02-20
file: by_date/futures_daily/2009/2009-02-20.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-02-20 | ES | Futures | 735.13 | 736.07 | 710.58 | 726.63 | 3142066.0 |
| 2009-02-20 | NQ | Futures | 1308.6 | 1323.14 | 1285.68 | 1310.0 | 442366.0 |
| 2009-02-20 | YM | Futures | 6637.0 | 6646.8 | 6435.7 | 6546.2 | 274345.0 |
| 2009-02-20 | CL | Futures | 111.48 | 112.98 | 105.68 | 112.69 | 244809.0 |
| 2009-02-20 | GC | Futures | 1350.5 | 1398.4 | 1348.2 | 1390.8 | 163165.0 |
| 2009-02-20 | ZN | Futures | 93.793953 | 94.977284 | 93.758094 | 94.331831 | 823669.0 |
| 2009-02-20 | A6 | Futures | 0.51107 | 0.51456 | 0.50322 | 0.51242 | 34953.0 |
| 2009-02-20 | AD | Futures | 0.78287 | 0.79092 | 0.77629 | 0.7865 | 44023.0 |
| 2009-02-20 | B | Futures | 41.52 | 42.21 | 39.89 | 42.0 | 100395.0 |
| 2009-02-20 | B6 | Futures | 1.4853 | 1.5048 | 1.4698 | 1.5002 | 69648.0 |
| 2009-02-20 | BFX | Futures | 1927.5 | 1935.2 | 1904.8 | 1908.8 | 314.0 |
| 2009-02-20 | BZ | Futures | 42.32 | 43.19 | 41.22 | 43.17 | 37.0 |
| 2009-02-20 | C | Futures | 1846.0 | 1849.0 | 1776.0 | 1778.0 | 4052.0 |
| 2009-02-20 | CC | Futures | 2249.0 | 2249.0 | 2128.0 | 2138.0 | 8908.0 |
| 2009-02-20 | CT | Futures | 42.29 | 42.73 | 41.47 | 41.88 | 2803.0 |
| 2009-02-20 | DC | Futures | 28.1 | 28.58 | 27.88 | 27.91 | 260.0 |
| 2009-02-20 | DX | Futures | 91.239 | 91.659 | 89.627 | 89.902 | 8397.0 |
| 2009-02-20 | E1 | Futures | 1.13364 | 1.15996 | 1.11862 | 1.15158 | 52160.0 |
| 2009-02-20 | E6 | Futures | 1.50119 | 1.52498 | 1.48603 | 1.51966 | 254614.0 |
| 2009-02-20 | E7 | Futures | 1.484 | 1.5074 | 1.469 | 1.5023 | 2510.0 |
| 2009-02-20 | EBM | Futures | 218.58 | 218.58 | 214.37 | 215.9 | 3240.0 |
| 2009-02-20 | ED | Futures | 92.98 | 93.053 | 92.9683 | 93.0224 | 213235.0 |
| 2009-02-20 | ER | Futures | 96.351 | 96.405 | 96.351 | 96.385 | 93278.0 |
| 2009-02-20 | EW | Futures | 460.2 | 460.2 | 442.5 | 453.1 | 45293.0 |
| 2009-02-20 | FCE | Futures | 1759.0 | 1765.2 | 1691.6 | 1716.0 | 165647.0 |
| 2009-02-20 | FDAX | Futures | 4501.0 | 4523.4 | 4337.8 | 4421.3 | 214679.0 |
| 2009-02-20 | FESX | Futures | 1191.0 | 1194.4 | 1141.6 | 1163.4 | 1984267.0 |
| 2009-02-20 | FEU3 | Futures | 96.938 | 96.963 | 96.938 | 96.953 | 212.0 |
| 2009-02-20 | FGBL | Futures | 93.33 | 93.91 | 93.3 | 93.74 | 698463.0 |
| 2009-02-20 | FGBM | Futures | 98.11 | 98.54 | 98.06 | 98.32 | 429432.0 |
| 2009-02-20 | FGBS | Futures | 103.771 | 103.968 | 103.724 | 103.824 | 551749.0 |
| 2009-02-20 | FGBX | Futures | 85.0 | 85.68 | 85.0 | 85.67 | 1180.0 |
| 2009-02-20 | FTDX | Futures | 421.5 | 423.3 | 407.2 | 411.7 | 719.0 |
| 2009-02-20 | FTI | Futures | 190.19 | 191.04 | 186.07 | 186.52 | 35542.0 |
| 2009-02-20 | FTUK | Futures | 2581.0 | 2591.8 | 2505.0 | 2545.0 | 142664.0 |
| 2009-02-20 | G | Futures | 75.97 | 76.56 | 75.94 | 76.48 | 85812.0 |
| 2009-02-20 | GF | Futures | 252.491 | 252.491 | 245.828 | 247.932 | 763.0 |
| 2009-02-20 | GSCI | Futures | 687.95 | 692.54 | 669.14 | 691.23 | 338.0 |
| 2009-02-20 | HE | Futures | 117.339 | 117.919 | 111.926 | 112.023 | 5923.0 |
| 2009-02-20 | HG | Futures | 2.078 | 2.0893 | 1.9914 | 2.0189 | 6240.0 |
| 2009-02-20 | HO | Futures | 1.3239 | 1.3365 | 1.2799 | 1.3349 | 6722.0 |
| 2009-02-20 | HRC | Futures | 2982.9 | 2982.9 | 2982.9 | 2982.9 | 0.0 |
| 2009-02-20 | J1 | Futures | 0.0134321 | 0.013662 | 0.0133866 | 0.0135546 | 91907.0 |
| 2009-02-20 | J7 | Futures | 0.013257 | 0.01349 | 0.013227 | 0.013392 | 205.0 |
| 2009-02-20 | JB | Futures | 116.89 | 116.9 | 116.67 | 116.89 | 1.0 |
| 2009-02-20 | KC | Futures | 315.61 | 316.6 | 310.97 | 312.8 | 7217.0 |
| 2009-02-20 | KE | Futures | 2788.05 | 2813.03 | 2713.1 | 2779.31 | 7391.0 |
| 2009-02-20 | L | Futures | 96.566 | 96.586 | 96.527 | 96.541 | 65138.0 |
| 2009-02-20 | LBS | Futures | 842.5 | 844.8 | 814.5 | 820.6 | 199.0 |
| 2009-02-20 | LE | Futures | 144.611 | 144.611 | 141.351 | 143.11 | 9836.0 |
> showing 50 of 85 rows — these rows as CSV