PREVIEW / futures_daily / 2008-01-02
file: by_date/futures_daily/2008/2008-01-02.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-02 | ES | Futures | 1370.6 | 1374.31 | 1343.02 | 1351.83 | 1623508.0 |
| 2008-01-02 | NQ | Futures | 2369.81 | 2376.27 | 2308.36 | 2323.51 | 390997.0 |
| 2008-01-02 | YM | Futures | 11844.1 | 11881.5 | 11591.9 | 11668.3 | 166143.0 |
| 2008-01-02 | CL | Futures | 410.0 | 426.86 | 410.0 | 425.24 | 227099.0 |
| 2008-01-02 | ZN | Futures | 81.486631 | 82.249867 | 81.217254 | 82.171299 | 816994.0 |
| 2008-01-02 | A6 | Futures | 0.6618 | 0.66361 | 0.65954 | 0.66293 | 19734.0 |
| 2008-01-02 | AD | Futures | 0.99478 | 0.99615 | 0.98574 | 0.99252 | 35189.0 |
| 2008-01-02 | B6 | Futures | 2.015 | 2.0165 | 2.0069 | 2.0102 | 47489.0 |
| 2008-01-02 | CB | Futures | 89.351 | 89.351 | 89.01 | 89.351 | 27.0 |
| 2008-01-02 | DC | Futures | 43.51 | 45.14 | 43.51 | 44.91 | 100.0 |
| 2008-01-02 | DX | Futures | 82.846 | 82.846 | 81.939 | 82.058 | 2563.0 |
| 2008-01-02 | E1 | Futures | 1.18799 | 1.20011 | 1.18612 | 1.19665 | 43211.0 |
| 2008-01-02 | E6 | Futures | 1.70307 | 1.71247 | 1.70017 | 1.70945 | 107899.0 |
| 2008-01-02 | E7 | Futures | 1.6895 | 1.6994 | 1.6876 | 1.6965 | 1151.0 |
| 2008-01-02 | ED | Futures | 90.5238 | 90.6703 | 90.5096 | 90.6467 | 219179.0 |
| 2008-01-02 | ER | Futures | 94.081 | 94.116 | 94.056 | 94.111 | 143238.0 |
| 2008-01-02 | EW | Futures | 855.6 | 858.5 | 841.8 | 847.6 | 27889.0 |
| 2008-01-02 | FDAX | Futures | 9176.0 | 9260.9 | 9025.4 | 9088.8 | 134934.0 |
| 2008-01-02 | FESX | Futures | 2512.6 | 2532.5 | 2473.3 | 2492.7 | 923795.0 |
| 2008-01-02 | FEU3 | Futures | 94.551 | 94.581 | 94.551 | 94.581 | 2091.0 |
| 2008-01-02 | FTDX | Futures | 898.9 | 908.9 | 886.1 | 890.6 | 722.0 |
| 2008-01-02 | FTUK | Futures | 4174.9 | 4227.0 | 4146.4 | 4165.5 | 82918.0 |
| 2008-01-02 | G | Futures | 69.46 | 70.16 | 69.46 | 69.99 | 68924.0 |
| 2008-01-02 | HG | Futures | 4.2746 | 4.3857 | 4.2669 | 4.3069 | 8856.0 |
| 2008-01-02 | J1 | Futures | 0.011575 | 0.0118262 | 0.0115647 | 0.0118019 | 107375.0 |
| 2008-01-02 | J7 | Futures | 0.011382 | 0.011616 | 0.011367 | 0.011594 | 68.0 |
| 2008-01-02 | JB | Futures | 113.85 | 113.96 | 113.85 | 113.96 | 0.0 |
| 2008-01-02 | KC | Futures | 432.48 | 435.5 | 422.94 | 426.12 | 9368.0 |
| 2008-01-02 | KE | Futures | 4967.71 | 5111.27 | 4944.69 | 5070.64 | 6146.0 |
| 2008-01-02 | L | Futures | 94.004 | 94.063 | 93.974 | 94.043 | 65548.0 |
| 2008-01-02 | MP | Futures | 0.04302 | 0.04323 | 0.043 | 0.04306 | 20462.0 |
| 2008-01-02 | N6 | Futures | 0.57632 | 0.57639 | 0.57287 | 0.57564 | 1216.0 |
| 2008-01-02 | PA | Futures | 449.89 | 456.43 | 448.15 | 455.71 | 993.0 |
| 2008-01-02 | PJY | Futures | 170.03 | 170.03 | 170.03 | 170.03 | 0.0 |
| 2008-01-02 | PL | Futures | 1805.5 | 1832.8 | 1801.3 | 1825.7 | 1735.0 |
| 2008-01-02 | PSI | Futures | 10364.0 | 10384.4 | 10231.1 | 10235.8 | 713.0 |
| 2008-01-02 | RP | Futures | 0.845 | 0.84978 | 0.84392 | 0.84847 | 257.0 |
| 2008-01-02 | RTY | Futures | 779.0 | 781.9 | 762.0 | 768.3 | 233194.0 |
| 2008-01-02 | RY | Futures | 148.02 | 148.89 | 145.82 | 146.0 | 1969.0 |
| 2008-01-02 | SI | Futures | 25.689 | 26.559 | 25.689 | 26.344 | 26487.0 |
| 2008-01-02 | US | Futures | 88.626184 | 89.910966 | 88.316885 | 89.768213 | 267629.0 |
| 2008-01-02 | ZF | Futures | 90.3870534 | 91.0398062 | 90.1566701 | 90.9630117 | 475565.0 |
| 2008-01-02 | ZL | Futures | 49.61 | 51.05 | 49.48 | 50.66 | 45092.0 |
| 2008-01-02 | ZT | Futures | 97.510949 | 97.90951486 | 97.41674253 | 97.86603495 | 221082.0 |
| 2008-01-02 | ZW | Futures | 6815.09 | 6986.9 | 6782.64 | 6986.9 | 23846.0 |
> showing 45 of 45 rows — these rows as CSV