PREVIEW / futures_daily / 2008-01-16
file: by_date/futures_daily/2008/2008-01-16.parquet size: 7 KB rows: 47
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-16 | ES | Futures | 1280.69 | 1295.29 | 1268.41 | 1275.36 | 3222442.0 |
| 2008-01-16 | NQ | Futures | 2110.24 | 2154.3 | 2086.95 | 2111.36 | 707613.0 |
| 2008-01-16 | YM | Futures | 11121.1 | 11230.4 | 11031.4 | 11094.4 | 260928.0 |
| 2008-01-16 | CL | Futures | 391.97 | 393.04 | 381.5 | 387.59 | 190728.0 |
| 2008-01-16 | ZN | Futures | 83.596753 | 83.832459 | 83.170239 | 83.349824 | 1537787.0 |
| 2008-01-16 | A6 | Futures | 0.66112 | 0.66511 | 0.65569 | 0.66067 | 71932.0 |
| 2008-01-16 | AD | Futures | 0.96373 | 0.96747 | 0.95489 | 0.9601 | 59314.0 |
| 2008-01-16 | B6 | Futures | 1.9872 | 2.0012 | 1.9816 | 1.993 | 104843.0 |
| 2008-01-16 | CB | Futures | 88.669 | 88.669 | 87.305 | 87.476 | 43.0 |
| 2008-01-16 | DC | Futures | 42.91 | 43.14 | 41.69 | 41.74 | 425.0 |
| 2008-01-16 | DX | Futures | 81.815 | 82.657 | 81.497 | 82.436 | 9648.0 |
| 2008-01-16 | E1 | Futures | 1.22103 | 1.23302 | 1.21197 | 1.21343 | 73611.0 |
| 2008-01-16 | E6 | Futures | 1.71421 | 1.72338 | 1.69251 | 1.69924 | 295718.0 |
| 2008-01-16 | E7 | Futures | 1.7019 | 1.7102 | 1.6798 | 1.6874 | 2500.0 |
| 2008-01-16 | ED | Futures | 91.1902 | 91.2186 | 91.124 | 91.1429 | 366846.0 |
| 2008-01-16 | ER | Futures | 94.204 | 94.303 | 94.204 | 94.288 | 255857.0 |
| 2008-01-16 | EW | Futures | 781.2 | 789.5 | 770.7 | 778.6 | 41137.0 |
| 2008-01-16 | FDAX | Futures | 8568.0 | 8624.1 | 8502.9 | 8546.0 | 280536.0 |
| 2008-01-16 | FESX | Futures | 2351.5 | 2383.4 | 2343.5 | 2359.4 | 2214567.0 |
| 2008-01-16 | FEU3 | Futures | 94.699 | 94.769 | 94.699 | 94.764 | 2420.0 |
| 2008-01-16 | FTDX | Futures | 770.2 | 770.2 | 741.9 | 746.5 | 3852.0 |
| 2008-01-16 | FTUK | Futures | 3885.2 | 3900.1 | 3816.6 | 3852.2 | 199808.0 |
| 2008-01-16 | G | Futures | 70.44 | 70.56 | 70.21 | 70.42 | 102891.0 |
| 2008-01-16 | GF | Futures | 299.113 | 303.035 | 297.929 | 298.891 | 94.0 |
| 2008-01-16 | HG | Futures | 4.5122 | 4.5452 | 4.4236 | 4.4595 | 11948.0 |
| 2008-01-16 | J1 | Futures | 0.0120569 | 0.0121685 | 0.011939 | 0.0119749 | 187688.0 |
| 2008-01-16 | J7 | Futures | 0.011886 | 0.011951 | 0.011731 | 0.011764 | 140.0 |
| 2008-01-16 | JB | Futures | 115.2 | 115.24 | 115.07 | 115.12 | 2088.0 |
| 2008-01-16 | KC | Futures | 434.71 | 435.34 | 424.21 | 428.98 | 10602.0 |
| 2008-01-16 | KE | Futures | 5178.99 | 5242.64 | 5024.6 | 5195.24 | 10831.0 |
| 2008-01-16 | L | Futures | 94.262 | 94.302 | 94.223 | 94.253 | 92435.0 |
| 2008-01-16 | LE | Futures | 198.795 | 200.43 | 196.633 | 197.002 | 3630.0 |
| 2008-01-16 | MP | Futures | 0.04292 | 0.04298 | 0.04278 | 0.04292 | 16835.0 |
| 2008-01-16 | N6 | Futures | 0.57699 | 0.58029 | 0.56815 | 0.57429 | 3565.0 |
| 2008-01-16 | PA | Futures | 460.63 | 460.63 | 443.23 | 453.25 | 1454.0 |
| 2008-01-16 | PJY | Futures | 166.14 | 166.14 | 166.14 | 166.14 | 0.0 |
| 2008-01-16 | PL | Futures | 1854.1 | 1865.0 | 1838.1 | 1850.6 | 1760.0 |
| 2008-01-16 | PSI | Futures | 9197.4 | 9197.4 | 9040.2 | 9135.3 | 1426.0 |
| 2008-01-16 | RP | Futures | 0.86321 | 0.86384 | 0.84864 | 0.8512 | 575.0 |
| 2008-01-16 | RTY | Futures | 706.5 | 721.3 | 701.0 | 709.9 | 348076.0 |
| 2008-01-16 | RY | Futures | 143.26 | 143.74 | 141.73 | 143.11 | 2579.0 |
| 2008-01-16 | SI | Futures | 27.541 | 27.998 | 27.171 | 27.386 | 43860.0 |
| 2008-01-16 | US | Futures | 91.243333 | 91.647802 | 90.481981 | 90.743696 | 535259.0 |
| 2008-01-16 | ZF | Futures | 92.1661246 | 92.3965079 | 91.9357413 | 92.0893301 | 843788.0 |
| 2008-01-16 | ZL | Futures | 53.07 | 53.16 | 51.7 | 52.58 | 9404.0 |
| 2008-01-16 | ZT | Futures | 98.55446689 | 98.64867336 | 98.39504055 | 98.49649367 | 354300.0 |
| 2008-01-16 | ZW | Futures | 7114.8 | 7198.8 | 6887.63 | 7074.71 | 5134.0 |
> showing 47 of 47 rows — these rows as CSV