PREVIEW / futures_daily / 2008-01-28
file: by_date/futures_daily/2008/2008-01-28.parquet size: 7 KB rows: 49
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-28 | ES | Futures | 1238.29 | 1258.91 | 1214.42 | 1255.44 | 2013859.0 |
| 2008-01-28 | NQ | Futures | 2016.52 | 2037.0 | 1977.23 | 2031.95 | 399003.0 |
| 2008-01-28 | YM | Futures | 10873.3 | 11013.6 | 10732.9 | 10994.1 | 183631.0 |
| 2008-01-28 | CL | Futures | 388.71 | 391.88 | 380.81 | 390.29 | 261940.0 |
| 2008-01-28 | GC | Futures | 1312.4 | 1337.3 | 1311.0 | 1333.5 | 79138.0 |
| 2008-01-28 | ZN | Futures | 84.157956 | 84.404885 | 83.866131 | 84.045716 | 946792.0 |
| 2008-01-28 | A6 | Futures | 0.65999 | 0.66707 | 0.6575 | 0.66594 | 37310.0 |
| 2008-01-28 | AD | Futures | 0.97287 | 0.97916 | 0.96982 | 0.97709 | 30480.0 |
| 2008-01-28 | B6 | Futures | 2.0123 | 2.0184 | 2.0008 | 2.012 | 47363.0 |
| 2008-01-28 | CB | Futures | 89.351 | 89.351 | 87.646 | 87.987 | 4.0 |
| 2008-01-28 | DC | Futures | 42.51 | 43.96 | 42.39 | 43.36 | 328.0 |
| 2008-01-28 | DX | Futures | 82.28 | 82.28 | 81.648 | 81.724 | 1936.0 |
| 2008-01-28 | E1 | Futures | 1.21597 | 1.22689 | 1.21583 | 1.22396 | 32355.0 |
| 2008-01-28 | E6 | Futures | 1.70191 | 1.71502 | 1.69901 | 1.71259 | 118513.0 |
| 2008-01-28 | E7 | Futures | 1.6892 | 1.7018 | 1.6864 | 1.6996 | 1114.0 |
| 2008-01-28 | ED | Futures | 91.6297 | 91.7243 | 91.6297 | 91.6865 | 269505.0 |
| 2008-01-28 | ER | Futures | 94.327 | 94.337 | 94.253 | 94.273 | 161358.0 |
| 2008-01-28 | EW | Futures | 768.1 | 787.7 | 753.3 | 786.3 | 28559.0 |
| 2008-01-28 | FDAX | Futures | 7488.6 | 7845.8 | 7480.7 | 7845.8 | 221441.0 |
| 2008-01-28 | FESX | Futures | 2087.9 | 2175.0 | 2078.8 | 2175.0 | 1497588.0 |
| 2008-01-28 | FEU3 | Futures | 94.764 | 94.764 | 94.749 | 94.749 | 112.0 |
| 2008-01-28 | FTDX | Futures | 695.4 | 722.7 | 684.4 | 722.7 | 2287.0 |
| 2008-01-28 | FTUK | Futures | 3766.1 | 3770.9 | 3679.0 | 3725.6 | 139510.0 |
| 2008-01-28 | G | Futures | 69.76 | 69.96 | 69.75 | 69.87 | 58402.0 |
| 2008-01-28 | GF | Futures | 302.517 | 306.069 | 302.147 | 303.923 | 107.0 |
| 2008-01-28 | HE | Futures | 145.61 | 149.065 | 144.321 | 148.773 | 4824.0 |
| 2008-01-28 | HG | Futures | 4.4841 | 4.496 | 4.3807 | 4.4834 | 9642.0 |
| 2008-01-28 | J1 | Futures | 0.0120557 | 0.0121364 | 0.0120185 | 0.0120454 | 97846.0 |
| 2008-01-28 | J7 | Futures | 0.011824 | 0.011921 | 0.011809 | 0.011833 | 149.0 |
| 2008-01-28 | JB | Futures | 114.57 | 115.14 | 114.49 | 114.92 | 1684.0 |
| 2008-01-28 | KC | Futures | 417.22 | 427.87 | 415.63 | 426.76 | 11159.0 |
| 2008-01-28 | KE | Futures | 5279.21 | 5417.35 | 5272.44 | 5417.35 | 5373.0 |
| 2008-01-28 | L | Futures | 94.113 | 94.143 | 94.073 | 94.103 | 72495.0 |
| 2008-01-28 | LE | Futures | 198.742 | 198.742 | 197.582 | 197.899 | 1616.0 |
| 2008-01-28 | MP | Futures | 0.04315 | 0.04326 | 0.04306 | 0.04318 | 14083.0 |
| 2008-01-28 | N6 | Futures | 0.57257 | 0.57834 | 0.57055 | 0.57774 | 1441.0 |
| 2008-01-28 | PA | Futures | 459.43 | 470.22 | 455.59 | 469.44 | 2132.0 |
| 2008-01-28 | PJY | Futures | 166.74 | 166.74 | 166.74 | 166.74 | 0.0 |
| 2008-01-28 | PL | Futures | 1986.4 | 2046.5 | 1957.9 | 2041.4 | 4108.0 |
| 2008-01-28 | PSI | Futures | 8627.5 | 8728.9 | 8627.5 | 8728.9 | 175.0 |
| 2008-01-28 | RP | Futures | 0.84477 | 0.85035 | 0.84415 | 0.84921 | 40.0 |
| 2008-01-28 | RTY | Futures | 697.7 | 713.9 | 684.7 | 712.9 | 250699.0 |
| 2008-01-28 | RY | Futures | 142.46 | 143.65 | 141.27 | 143.3 | 732.0 |
| 2008-01-28 | SI | Futures | 28.48 | 28.937 | 28.282 | 28.859 | 22956.0 |
| 2008-01-28 | US | Futures | 91.338502 | 91.742971 | 91.076787 | 91.338502 | 335656.0 |
| 2008-01-28 | ZF | Futures | 92.7420829 | 92.9724662 | 92.4861014 | 92.6780875 | 476446.0 |
| 2008-01-28 | ZL | Futures | 51.92 | 52.45 | 51.31 | 52.4 | 71353.0 |
| 2008-01-28 | ZT | Futures | 98.82983966 | 98.98926601 | 98.71389323 | 98.82983966 | 223420.0 |
| 2008-01-28 | ZW | Futures | 7175.89 | 7353.43 | 7124.35 | 7353.43 | 90833.0 |
> showing 49 of 49 rows — these rows as CSV