PREVIEW / futures_daily / 2008-01-31
file: by_date/futures_daily/2008/2008-01-31.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-31 | ES | Futures | 1251.03 | 1285.79 | 1234.12 | 1278.61 | 3192392.0 |
| 2008-01-31 | NQ | Futures | 2028.3 | 2088.35 | 2001.92 | 2074.04 | 580744.0 |
| 2008-01-31 | YM | Futures | 11005.6 | 11279.2 | 10871.5 | 11204.6 | 248859.0 |
| 2008-01-31 | CL | Futures | 393.64 | 395.91 | 384.24 | 393.55 | 316987.0 |
| 2008-01-31 | GC | Futures | 1334.0 | 1335.3 | 1319.5 | 1326.7 | 101345.0 |
| 2008-01-31 | ZN | Futures | 83.877355 | 84.281421 | 83.69777 | 83.843683 | 1461639.0 |
| 2008-01-31 | A6 | Futures | 0.66888 | 0.67401 | 0.66172 | 0.67303 | 58190.0 |
| 2008-01-31 | AD | Futures | 0.98692 | 0.98869 | 0.97277 | 0.97759 | 61209.0 |
| 2008-01-31 | B6 | Futures | 2.0163 | 2.0233 | 2.0109 | 2.0189 | 61510.0 |
| 2008-01-31 | CB | Futures | 87.646 | 87.646 | 87.646 | 87.646 | 2.0 |
| 2008-01-31 | DC | Futures | 42.26 | 43.24 | 42.06 | 42.21 | 369.0 |
| 2008-01-31 | DX | Futures | 81.373 | 81.599 | 81.076 | 81.276 | 3869.0 |
| 2008-01-31 | E1 | Futures | 1.23169 | 1.23968 | 1.22796 | 1.23329 | 57789.0 |
| 2008-01-31 | E6 | Futures | 1.72152 | 1.72837 | 1.71525 | 1.72407 | 166409.0 |
| 2008-01-31 | E7 | Futures | 1.7089 | 1.7153 | 1.7025 | 1.711 | 1705.0 |
| 2008-01-31 | ED | Futures | 91.7715 | 91.8708 | 91.7574 | 91.781 | 376422.0 |
| 2008-01-31 | ER | Futures | 94.313 | 94.357 | 94.283 | 94.332 | 166838.0 |
| 2008-01-31 | EW | Futures | 778.2 | 804.1 | 767.5 | 800.4 | 38529.0 |
| 2008-01-31 | FDAX | Futures | 7760.3 | 7916.0 | 7616.0 | 7916.0 | 235676.0 |
| 2008-01-31 | FESX | Futures | 2154.5 | 2200.0 | 2118.0 | 2200.0 | 1978434.0 |
| 2008-01-31 | FEU3 | Futures | 94.779 | 94.818 | 94.779 | 94.808 | 1734.0 |
| 2008-01-31 | FTDX | Futures | 716.3 | 734.6 | 701.7 | 734.6 | 3950.0 |
| 2008-01-31 | FTUK | Futures | 3758.0 | 3815.3 | 3666.4 | 3802.7 | 188931.0 |
| 2008-01-31 | G | Futures | 69.59 | 70.02 | 69.59 | 69.9 | 111641.0 |
| 2008-01-31 | GF | Futures | 310.805 | 313.173 | 307.253 | 311.545 | 130.0 |
| 2008-01-31 | HE | Futures | 154.981 | 156.27 | 153.166 | 155.684 | 4679.0 |
| 2008-01-31 | HG | Futures | 4.5403 | 4.6703 | 4.4967 | 4.6359 | 11507.0 |
| 2008-01-31 | J1 | Futures | 0.0121069 | 0.0121646 | 0.01203 | 0.0120813 | 177974.0 |
| 2008-01-31 | J7 | Futures | 0.011892 | 0.011945 | 0.011819 | 0.011868 | 137.0 |
| 2008-01-31 | JB | Futures | 114.89 | 115.02 | 114.67 | 114.78 | 2878.0 |
| 2008-01-31 | KC | Futures | 434.23 | 440.11 | 433.28 | 439.32 | 15637.0 |
| 2008-01-31 | KE | Futures | 5239.94 | 5303.59 | 5153.26 | 5239.94 | 6827.0 |
| 2008-01-31 | L | Futures | 94.113 | 94.183 | 94.093 | 94.153 | 98843.0 |
| 2008-01-31 | LE | Futures | 199.217 | 199.533 | 196.897 | 198.848 | 2710.0 |
| 2008-01-31 | MP | Futures | 0.0432 | 0.0435 | 0.0432 | 0.04346 | 21626.0 |
| 2008-01-31 | N6 | Futures | 0.58269 | 0.58793 | 0.57714 | 0.58696 | 1867.0 |
| 2008-01-31 | PA | Futures | 467.76 | 476.04 | 459.73 | 473.22 | 1564.0 |
| 2008-01-31 | PJY | Futures | 166.82 | 166.82 | 166.82 | 166.82 | 0.0 |
| 2008-01-31 | PL | Futures | 2002.3 | 2060.0 | 1991.0 | 2051.7 | 3182.0 |
| 2008-01-31 | PSI | Futures | 8901.0 | 8901.0 | 8796.5 | 8823.2 | 77.0 |
| 2008-01-31 | RP | Futures | 0.85194 | 0.85388 | 0.8487 | 0.85206 | 72.0 |
| 2008-01-31 | RTY | Futures | 700.5 | 728.8 | 691.4 | 724.3 | 360433.0 |
| 2008-01-31 | RY | Futures | 143.24 | 144.19 | 142.36 | 143.84 | 6013.0 |
| 2008-01-31 | SI | Futures | 29.049 | 29.445 | 28.833 | 29.281 | 29420.0 |
| 2008-01-31 | US | Futures | 90.672319 | 91.338502 | 90.434396 | 90.838865 | 549480.0 |
| 2008-01-31 | ZF | Futures | 92.6652884 | 93.0108634 | 92.5116995 | 92.5628958 | 1040826.0 |
| 2008-01-31 | ZL | Futures | 53.23 | 53.65 | 52.8 | 53.57 | 68988.0 |
| 2008-01-31 | ZT | Futures | 98.93853944 | 99.11245909 | 98.85157962 | 98.88781288 | 374691.0 |
| 2008-01-31 | ZW | Futures | 7047.99 | 7194.98 | 6941.08 | 7097.62 | 98453.0 |
> showing 49 of 49 rows — these rows as CSV