PREVIEW / futures_daily / 2008-01-04
file: by_date/futures_daily/2008/2008-01-04.parquet size: 7 KB rows: 45
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-01-04 | ES | Futures | 1352.06 | 1356.23 | 1313.83 | 1318.93 | 2199479.0 |
| 2008-01-04 | NQ | Futures | 2329.68 | 2337.82 | 2218.84 | 2228.1 | 524481.0 |
| 2008-01-04 | YM | Futures | 11669.2 | 11708.2 | 11407.1 | 11447.1 | 182015.0 |
| 2008-01-04 | CL | Futures | 423.32 | 424.34 | 414.48 | 417.94 | 231790.0 |
| 2008-01-04 | ZN | Futures | 82.193747 | 82.777398 | 82.070282 | 82.597813 | 1230992.0 |
| 2008-01-04 | A6 | Futures | 0.66044 | 0.66338 | 0.65275 | 0.65501 | 43818.0 |
| 2008-01-04 | AD | Futures | 0.99399 | 0.99881 | 0.97857 | 0.98122 | 50990.0 |
| 2008-01-04 | B6 | Futures | 2.0022 | 2.0152 | 1.9971 | 2.0024 | 74797.0 |
| 2008-01-04 | CB | Futures | 88.328 | 89.01 | 87.987 | 87.987 | 18.0 |
| 2008-01-04 | DC | Futures | 46.31 | 46.49 | 44.86 | 45.11 | 205.0 |
| 2008-01-04 | DX | Futures | 81.956 | 82.145 | 81.454 | 81.853 | 3923.0 |
| 2008-01-04 | E1 | Futures | 1.20304 | 1.2137 | 1.19825 | 1.20997 | 60206.0 |
| 2008-01-04 | E6 | Futures | 1.71119 | 1.72071 | 1.70562 | 1.71456 | 184253.0 |
| 2008-01-04 | E7 | Futures | 1.6984 | 1.7077 | 1.693 | 1.7016 | 1763.0 |
| 2008-01-04 | ED | Futures | 90.6608 | 90.779 | 90.6325 | 90.7696 | 347575.0 |
| 2008-01-04 | ER | Futures | 94.12 | 94.135 | 94.101 | 94.125 | 108185.0 |
| 2008-01-04 | EW | Futures | 841.3 | 843.8 | 813.6 | 818.2 | 30427.0 |
| 2008-01-04 | FDAX | Futures | 9038.4 | 9042.9 | 8871.4 | 8930.3 | 165763.0 |
| 2008-01-04 | FESX | Futures | 2488.1 | 2493.3 | 2430.1 | 2452.3 | 1241985.0 |
| 2008-01-04 | FEU3 | Futures | 94.59 | 94.61 | 94.581 | 94.6 | 947.0 |
| 2008-01-04 | FTDX | Futures | 883.3 | 889.7 | 845.0 | 866.0 | 1465.0 |
| 2008-01-04 | FTUK | Futures | 4214.4 | 4238.3 | 4104.3 | 4111.4 | 146406.0 |
| 2008-01-04 | G | Futures | 69.92 | 70.25 | 69.9 | 70.18 | 88838.0 |
| 2008-01-04 | HG | Futures | 4.4728 | 4.5473 | 4.3646 | 4.4384 | 16171.0 |
| 2008-01-04 | J1 | Futures | 0.0117942 | 0.0119685 | 0.0117826 | 0.0119044 | 138301.0 |
| 2008-01-04 | J7 | Futures | 0.011579 | 0.011754 | 0.011579 | 0.011694 | 135.0 |
| 2008-01-04 | JB | Futures | 114.32 | 114.48 | 114.24 | 114.42 | 4328.0 |
| 2008-01-04 | KC | Futures | 429.94 | 432.32 | 414.04 | 421.99 | 11121.0 |
| 2008-01-04 | KE | Futures | 5234.52 | 5280.57 | 5067.93 | 5123.46 | 7931.0 |
| 2008-01-04 | L | Futures | 94.053 | 94.073 | 94.024 | 94.073 | 91308.0 |
| 2008-01-04 | MP | Futures | 0.04326 | 0.04326 | 0.04292 | 0.04295 | 31363.0 |
| 2008-01-04 | N6 | Futures | 0.57242 | 0.57579 | 0.5683 | 0.5695 | 2415.0 |
| 2008-01-04 | PA | Futures | 452.23 | 456.43 | 431.96 | 453.13 | 714.0 |
| 2008-01-04 | PJY | Futures | 167.91 | 167.91 | 167.91 | 167.91 | 0.0 |
| 2008-01-04 | PL | Futures | 1836.2 | 1844.6 | 1820.4 | 1827.0 | 1205.0 |
| 2008-01-04 | PSI | Futures | 10113.2 | 10148.6 | 9944.2 | 10022.8 | 1171.0 |
| 2008-01-04 | RP | Futures | 0.85291 | 0.85462 | 0.84711 | 0.85433 | 369.0 |
| 2008-01-04 | RTY | Futures | 759.7 | 762.9 | 731.5 | 736.6 | 322061.0 |
| 2008-01-04 | RY | Futures | 146.24 | 146.31 | 144.74 | 145.16 | 2951.0 |
| 2008-01-04 | SI | Futures | 26.628 | 26.826 | 26.258 | 26.64 | 22544.0 |
| 2008-01-04 | US | Futures | 89.74442 | 90.26785 | 89.387536 | 89.910966 | 374593.0 |
| 2008-01-04 | ZF | Futures | 91.0014089 | 91.53897 | 90.9118154 | 91.3853811 | 646342.0 |
| 2008-01-04 | ZL | Futures | 51.03 | 51.3 | 47.11 | 51.03 | 30122.0 |
| 2008-01-04 | ZT | Futures | 97.96024143 | 98.32257403 | 97.90226821 | 98.13416107 | 378777.0 |
| 2008-01-04 | ZW | Futures | 7231.25 | 7315.25 | 6996.44 | 7112.89 | 49604.0 |
> showing 45 of 45 rows — these rows as CSV