PREVIEW / futures_daily / 2011-02-02
file: by_date/futures_daily/2011/2011-02-02.parquet size: 9 KB rows: 94
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-02 | ES | Futures | 1281.84 | 1285.04 | 1277.65 | 1279.62 | 1396167.0 |
| 2011-02-02 | NQ | Futures | 2634.76 | 2642.7 | 2624.82 | 2633.62 | 193313.0 |
| 2011-02-02 | YM | Futures | 11201.2 | 11240.5 | 11180.6 | 11217.1 | 73240.0 |
| 2011-02-02 | CL | Futures | 184.13 | 186.71 | 183.3 | 184.84 | 312107.0 |
| 2011-02-02 | GC | Futures | 1823.3 | 1826.1 | 1801.3 | 1807.8 | 109740.0 |
| 2011-02-02 | ZN | Futures | 100.101587 | 100.413551 | 99.581646 | 99.737628 | 1163674.0 |
| 2011-02-02 | A6 | Futures | 0.8525 | 0.85504 | 0.84843 | 0.8508 | 72225.0 |
| 2011-02-02 | AD | Futures | 1.00078 | 1.00575 | 0.99999 | 1.00336 | 68392.0 |
| 2011-02-02 | B | Futures | 86.9 | 87.67 | 86.52 | 87.46 | 138346.0 |
| 2011-02-02 | B6 | Futures | 1.6734 | 1.6831 | 1.6726 | 1.6771 | 107798.0 |
| 2011-02-02 | BFX | Futures | 3095.7 | 3120.8 | 3084.1 | 3100.9 | 275.0 |
| 2011-02-02 | BR | Futures | 0.25728 | 0.25728 | 0.2567 | 0.25689 | 24.0 |
| 2011-02-02 | BZ | Futures | 92.69 | 93.53 | 92.67 | 93.45 | 969.0 |
| 2011-02-02 | C | Futures | 2374.0 | 2392.0 | 2370.0 | 2389.0 | 4296.0 |
| 2011-02-02 | CB | Futures | 117.922 | 117.922 | 114.989 | 114.989 | 16.0 |
| 2011-02-02 | CC | Futures | 2688.0 | 2713.0 | 2676.0 | 2698.0 | 10949.0 |
| 2011-02-02 | CSC | Futures | 4.183 | 4.183 | 4.171 | 4.171 | 3.0 |
| 2011-02-02 | CT | Futures | 148.35 | 151.11 | 148.35 | 151.11 | 9450.0 |
| 2011-02-02 | DC | Futures | 30.18 | 30.28 | 29.39 | 29.59 | 768.0 |
| 2011-02-02 | DX | Futures | 77.001 | 77.291 | 76.861 | 77.139 | 15904.0 |
| 2011-02-02 | E1 | Futures | 1.40196 | 1.4055 | 1.38846 | 1.39213 | 44960.0 |
| 2011-02-02 | E6 | Futures | 1.63438 | 1.63923 | 1.62787 | 1.63166 | 276187.0 |
| 2011-02-02 | E7 | Futures | 1.6226 | 1.627 | 1.6159 | 1.6195 | 5108.0 |
| 2011-02-02 | EBM | Futures | 245.79 | 248.06 | 245.79 | 247.83 | 8152.0 |
| 2011-02-02 | ED | Futures | 94.8384 | 94.8432 | 94.8337 | 94.8384 | 177283.0 |
| 2011-02-02 | ER | Futures | 97.237 | 97.271 | 97.222 | 97.237 | 190028.0 |
| 2011-02-02 | EW | Futures | 922.0 | 927.3 | 919.6 | 921.2 | 14787.0 |
| 2011-02-02 | FBTP | Futures | 64.44 | 65.04 | 64.42 | 65.0 | 18289.0 |
| 2011-02-02 | FCE | Futures | 2725.5 | 2730.5 | 2704.1 | 2713.2 | 111881.0 |
| 2011-02-02 | FDAX | Futures | 7709.6 | 7740.2 | 7674.3 | 7695.2 | 118380.0 |
| 2011-02-02 | FESX | Futures | 1874.4 | 1879.3 | 1862.6 | 1870.7 | 1078259.0 |
| 2011-02-02 | FEU3 | Futures | 97.82 | 97.82 | 97.795 | 97.795 | 148.0 |
| 2011-02-02 | FGBL | Futures | 97.49 | 97.64 | 97.16 | 97.31 | 823705.0 |
| 2011-02-02 | FGBM | Futures | 103.14 | 103.3 | 102.89 | 103.03 | 629249.0 |
| 2011-02-02 | FGBS | Futures | 106.586 | 106.64 | 106.438 | 106.492 | 724789.0 |
| 2011-02-02 | FGBX | Futures | 94.56 | 94.87 | 94.1 | 94.32 | 6436.0 |
| 2011-02-02 | FTDX | Futures | 770.1 | 778.9 | 764.0 | 768.4 | 599.0 |
| 2011-02-02 | FTI | Futures | 295.4 | 296.65 | 294.03 | 295.24 | 27832.0 |
| 2011-02-02 | FTUK | Futures | 4128.7 | 4161.0 | 4123.5 | 4143.3 | 89600.0 |
| 2011-02-02 | FXXP | Futures | 184.6 | 185.1 | 184.0 | 184.2 | 3490.0 |
| 2011-02-02 | G | Futures | 80.27 | 80.38 | 79.89 | 80.0 | 109214.0 |
| 2011-02-02 | GF | Futures | 314.878 | 316.604 | 307.478 | 310.314 | 4173.0 |
| 2011-02-02 | GSCI | Futures | 1042.22 | 1051.62 | 1042.22 | 1050.58 | 168.0 |
| 2011-02-02 | HE | Futures | 108.427 | 109.652 | 106.618 | 106.647 | 15784.0 |
| 2011-02-02 | HG | Futures | 6.0612 | 6.0799 | 6.0186 | 6.0559 | 23109.0 |
| 2011-02-02 | HO | Futures | 2.3041 | 2.33 | 2.2986 | 2.3255 | 57347.0 |
| 2011-02-02 | HRC | Futures | 2833.3 | 2833.3 | 2833.3 | 2833.3 | 0.0 |
| 2011-02-02 | J1 | Futures | 0.0154324 | 0.0154462 | 0.0153445 | 0.0153909 | 100759.0 |
| 2011-02-02 | J7 | Futures | 0.015319 | 0.01533 | 0.015238 | 0.015281 | 163.0 |
| 2011-02-02 | JB | Futures | 120.72 | 120.84 | 120.63 | 120.75 | 1681.0 |
> showing 50 of 94 rows — these rows as CSV