PREVIEW / futures_daily / 2010-12-22
file: by_date/futures_daily/2010/2010-12-22.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 |
|---|---|---|---|---|---|---|---|
| 2010-12-22 | ES | Futures | 1230.41 | 1235.33 | 1229.42 | 1234.83 | 664450.0 |
| 2010-12-22 | NQ | Futures | 2535.99 | 2541.09 | 2532.01 | 2538.54 | 89776.0 |
| 2010-12-22 | YM | Futures | 10733.2 | 10769.7 | 10723.9 | 10758.5 | 39840.0 |
| 2010-12-22 | CL | Futures | 184.42 | 186.08 | 184.13 | 185.42 | 187386.0 |
| 2010-12-22 | GC | Futures | 1884.3 | 1891.7 | 1880.5 | 1885.8 | 61945.0 |
| 2010-12-22 | ZN | Futures | 100.153581 | 100.192576 | 99.659637 | 99.828618 | 493490.0 |
| 2010-12-22 | A6 | Futures | 0.83698 | 0.84029 | 0.83511 | 0.8391 | 47732.0 |
| 2010-12-22 | AD | Futures | 0.97399 | 0.97974 | 0.97329 | 0.97736 | 45131.0 |
| 2010-12-22 | B | Futures | 79.38 | 79.77 | 79.18 | 79.52 | 105821.0 |
| 2010-12-22 | B6 | Futures | 1.6037 | 1.6064 | 1.5919 | 1.5932 | 71897.0 |
| 2010-12-22 | BFX | Futures | 3037.9 | 3072.4 | 3037.9 | 3043.7 | 69.0 |
| 2010-12-22 | BR | Futures | 0.25002 | 0.25002 | 0.24951 | 0.24951 | 69.0 |
| 2010-12-22 | BZ | Futures | 84.1 | 84.52 | 83.94 | 84.27 | 508.0 |
| 2010-12-22 | C | Futures | 2196.0 | 2196.0 | 2173.0 | 2195.0 | 4829.0 |
| 2010-12-22 | CB | Futures | 100.908 | 101.202 | 100.908 | 100.908 | 23.0 |
| 2010-12-22 | CC | Futures | 2418.0 | 2429.0 | 2391.0 | 2410.0 | 5084.0 |
| 2010-12-22 | CT | Futures | 133.34 | 133.72 | 132.16 | 132.16 | 3180.0 |
| 2010-12-22 | DC | Futures | 22.69 | 22.69 | 22.34 | 22.37 | 92.0 |
| 2010-12-22 | DX | Futures | 80.809 | 80.979 | 80.48 | 80.927 | 11657.0 |
| 2010-12-22 | E1 | Futures | 1.3688 | 1.38138 | 1.36867 | 1.37784 | 29897.0 |
| 2010-12-22 | E6 | Futures | 1.54896 | 1.55913 | 1.54659 | 1.54778 | 215272.0 |
| 2010-12-22 | E7 | Futures | 1.5373 | 1.5475 | 1.5351 | 1.5363 | 3839.0 |
| 2010-12-22 | EBM | Futures | 218.78 | 221.51 | 218.1 | 221.05 | 6106.0 |
| 2010-12-22 | ED | Futures | 94.7718 | 94.7814 | 94.7671 | 94.7718 | 80604.0 |
| 2010-12-22 | ER | Futures | 97.306 | 97.375 | 97.301 | 97.35 | 149409.0 |
| 2010-12-22 | EW | Futures | 894.4 | 899.9 | 894.1 | 897.8 | 12294.0 |
| 2010-12-22 | FBTP | Futures | 64.12 | 64.13 | 63.98 | 64.05 | 1953.0 |
| 2010-12-22 | FCE | Futures | 2620.7 | 2626.7 | 2616.0 | 2618.0 | 46819.0 |
| 2010-12-22 | FDAX | Futures | 7596.7 | 7605.2 | 7586.0 | 7596.7 | 43449.0 |
| 2010-12-22 | FESX | Futures | 1786.2 | 1790.5 | 1779.9 | 1784.3 | 445383.0 |
| 2010-12-22 | FEU3 | Futures | 97.904 | 97.914 | 97.904 | 97.909 | 19.0 |
| 2010-12-22 | FGBL | Futures | 99.08 | 99.48 | 99.0 | 99.37 | 339575.0 |
| 2010-12-22 | FGBM | Futures | 104.45 | 104.93 | 104.41 | 104.86 | 238948.0 |
| 2010-12-22 | FGBS | Futures | 107.178 | 107.375 | 107.163 | 107.366 | 259549.0 |
| 2010-12-22 | FGBX | Futures | 97.81 | 98.41 | 97.5 | 98.3 | 2418.0 |
| 2010-12-22 | FTDX | Futures | 743.8 | 743.8 | 738.5 | 738.9 | 139.0 |
| 2010-12-22 | FTI | Futures | 285.56 | 286.0 | 284.48 | 285.2 | 12034.0 |
| 2010-12-22 | FTUK | Futures | 4106.8 | 4142.3 | 4097.4 | 4134.6 | 44555.0 |
| 2010-12-22 | FXXP | Futures | 182.0 | 182.5 | 181.7 | 182.5 | 239.0 |
| 2010-12-22 | G | Futures | 81.33 | 81.54 | 81.28 | 81.32 | 48895.0 |
| 2010-12-22 | GF | Futures | 302.416 | 305.094 | 300.485 | 303.101 | 1716.0 |
| 2010-12-22 | GSCI | Futures | 1011.29 | 1014.78 | 1007.72 | 1013.97 | 123.0 |
| 2010-12-22 | HE | Futures | 95.313 | 99.013 | 95.188 | 98.919 | 28832.0 |
| 2010-12-22 | HG | Futures | 5.724 | 5.726 | 5.6607 | 5.6974 | 20377.0 |
| 2010-12-22 | HO | Futures | 2.1213 | 2.1332 | 2.1174 | 2.1255 | 14264.0 |
| 2010-12-22 | HRC | Futures | 2596.9 | 2596.9 | 2596.9 | 2596.9 | 5.0 |
| 2010-12-22 | J1 | Futures | 0.0150067 | 0.0150695 | 0.0149916 | 0.0150368 | 69518.0 |
| 2010-12-22 | J7 | Futures | 0.0149 | 0.014964 | 0.014887 | 0.01493 | 77.0 |
| 2010-12-22 | JB | Futures | 120.8 | 121.0 | 120.67 | 120.96 | 985.0 |
| 2010-12-22 | KC | Futures | 573.46 | 594.06 | 560.71 | 564.51 | 12430.0 |
> showing 50 of 93 rows — these rows as CSV