PREVIEW / futures_daily / 2011-02-04
file: by_date/futures_daily/2011/2011-02-04.parquet size: 9 KB rows: 93
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-04 | ES | Futures | 1282.82 | 1287.99 | 1277.65 | 1286.76 | 1585618.0 |
| 2011-02-04 | NQ | Futures | 2636.46 | 2656.04 | 2629.93 | 2653.77 | 224139.0 |
| 2011-02-04 | YM | Futures | 11237.7 | 11280.7 | 11212.4 | 11273.3 | 80162.0 |
| 2011-02-04 | CL | Futures | 184.38 | 186.49 | 179.94 | 181.12 | 359925.0 |
| 2011-02-04 | GC | Futures | 1840.8 | 1847.0 | 1826.0 | 1830.8 | 141182.0 |
| 2011-02-04 | ZN | Futures | 99.28268 | 99.581646 | 98.489771 | 98.645753 | 1624263.0 |
| 2011-02-04 | A6 | Futures | 0.85716 | 0.86114 | 0.85343 | 0.85572 | 92552.0 |
| 2011-02-04 | AD | Futures | 1.00088 | 1.00862 | 0.99592 | 1.00386 | 107070.0 |
| 2011-02-04 | B | Futures | 87.08 | 87.6 | 85.11 | 85.41 | 105052.0 |
| 2011-02-04 | B6 | Futures | 1.6735 | 1.6773 | 1.6631 | 1.6692 | 121311.0 |
| 2011-02-04 | BFX | Futures | 3109.5 | 3123.6 | 3104.9 | 3110.7 | 133.0 |
| 2011-02-04 | BR | Futures | 0.25704 | 0.2573 | 0.25601 | 0.2561 | 87.0 |
| 2011-02-04 | BZ | Futures | 93.03 | 93.03 | 91.25 | 91.25 | 745.0 |
| 2011-02-04 | C | Futures | 2377.0 | 2385.0 | 2325.0 | 2337.0 | 7266.0 |
| 2011-02-04 | CB | Futures | 116.749 | 116.749 | 116.162 | 116.749 | 3.0 |
| 2011-02-04 | CC | Futures | 2708.0 | 2708.0 | 2612.0 | 2623.0 | 13867.0 |
| 2011-02-04 | CT | Futures | 147.37 | 147.87 | 143.94 | 143.94 | 14524.0 |
| 2011-02-04 | DC | Futures | 30.02 | 30.35 | 29.89 | 30.35 | 519.0 |
| 2011-02-04 | DX | Futures | 77.79 | 78.184 | 77.425 | 78.016 | 26210.0 |
| 2011-02-04 | E1 | Futures | 1.3861 | 1.38702 | 1.36657 | 1.37234 | 60000.0 |
| 2011-02-04 | E6 | Futures | 1.61154 | 1.61793 | 1.60161 | 1.60646 | 368615.0 |
| 2011-02-04 | E7 | Futures | 1.5998 | 1.6057 | 1.5896 | 1.5945 | 4716.0 |
| 2011-02-04 | EBM | Futures | 249.88 | 249.88 | 247.83 | 249.42 | 4777.0 |
| 2011-02-04 | ED | Futures | 94.8432 | 94.848 | 94.8384 | 94.8432 | 156205.0 |
| 2011-02-04 | ER | Futures | 97.257 | 97.262 | 97.247 | 97.247 | 128013.0 |
| 2011-02-04 | EW | Futures | 924.4 | 930.8 | 922.4 | 930.2 | 17659.0 |
| 2011-02-04 | FBTP | Futures | 64.55 | 64.88 | 64.55 | 64.64 | 8326.0 |
| 2011-02-04 | FCE | Futures | 2703.5 | 2712.2 | 2687.8 | 2700.5 | 98708.0 |
| 2011-02-04 | FDAX | Futures | 7723.6 | 7748.7 | 7701.6 | 7727.8 | 107617.0 |
| 2011-02-04 | FESX | Futures | 1868.2 | 1873.8 | 1855.7 | 1863.8 | 977861.0 |
| 2011-02-04 | FEU3 | Futures | 97.81 | 97.81 | 97.805 | 97.805 | 3.0 |
| 2011-02-04 | FGBL | Futures | 97.44 | 97.54 | 97.08 | 97.14 | 843943.0 |
| 2011-02-04 | FGBM | Futures | 103.31 | 103.4 | 103.0 | 103.03 | 540543.0 |
| 2011-02-04 | FGBS | Futures | 106.665 | 106.69 | 106.502 | 106.522 | 642478.0 |
| 2011-02-04 | FGBX | Futures | 94.21 | 94.56 | 93.65 | 93.94 | 3223.0 |
| 2011-02-04 | FTDX | Futures | 771.4 | 781.5 | 771.0 | 774.1 | 278.0 |
| 2011-02-04 | FTI | Futures | 294.83 | 294.99 | 292.78 | 293.91 | 26440.0 |
| 2011-02-04 | FTUK | Futures | 4144.3 | 4163.8 | 4136.0 | 4139.1 | 71382.0 |
| 2011-02-04 | FXXP | Futures | 185.3 | 185.5 | 184.5 | 185.1 | 2642.0 |
| 2011-02-04 | G | Futures | 79.8 | 79.99 | 79.43 | 79.59 | 90942.0 |
| 2011-02-04 | GF | Futures | 309.636 | 309.821 | 307.786 | 308.341 | 2524.0 |
| 2011-02-04 | GSCI | Futures | 1044.61 | 1047.96 | 1028.69 | 1034.26 | 270.0 |
| 2011-02-04 | HE | Futures | 106.91 | 107.377 | 105.86 | 106.939 | 12934.0 |
| 2011-02-04 | HG | Futures | 6.0599 | 6.1492 | 6.0452 | 6.1032 | 29839.0 |
| 2011-02-04 | HO | Futures | 2.3107 | 2.3285 | 2.262 | 2.272 | 57114.0 |
| 2011-02-04 | HRC | Futures | 2833.3 | 2833.3 | 2833.3 | 2833.3 | 0.0 |
| 2011-02-04 | J1 | Futures | 0.015396 | 0.0154977 | 0.0152289 | 0.0152729 | 168723.0 |
| 2011-02-04 | J7 | Futures | 0.015267 | 0.015374 | 0.015123 | 0.015164 | 224.0 |
| 2011-02-04 | JB | Futures | 120.47 | 120.48 | 120.04 | 120.19 | 2303.0 |
| 2011-02-04 | KC | Futures | 613.07 | 615.77 | 606.45 | 611.35 | 12608.0 |
> showing 50 of 93 rows — these rows as CSV