PREVIEW / futures_daily / 2011-01-10
file: by_date/futures_daily/2011/2011-01-10.parquet size: 9 KB rows: 91
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-01-10 | ES | Futures | 1246.4 | 1248.12 | 1238.28 | 1245.66 | 1876415.0 |
| 2011-01-10 | NQ | Futures | 2579.69 | 2596.44 | 2566.64 | 2591.33 | 197994.0 |
| 2011-01-10 | YM | Futures | 10869.9 | 10883.0 | 10781.9 | 10844.6 | 101671.0 |
| 2011-01-10 | CL | Futures | 182.39 | 184.39 | 180.6 | 182.9 | 430277.0 |
| 2011-01-10 | GC | Futures | 1861.9 | 1870.9 | 1855.4 | 1867.8 | 118859.0 |
| 2011-01-10 | ZN | Futures | 100.465545 | 100.673522 | 100.33556 | 100.556535 | 773576.0 |
| 2011-01-10 | A6 | Futures | 0.83689 | 0.83986 | 0.83147 | 0.83817 | 90065.0 |
| 2011-01-10 | AD | Futures | 0.9983 | 0.99989 | 0.99265 | 0.99761 | 62680.0 |
| 2011-01-10 | B | Futures | 79.67 | 81.44 | 79.59 | 81.32 | 159988.0 |
| 2011-01-10 | B6 | Futures | 1.6106 | 1.6177 | 1.6044 | 1.6156 | 90933.0 |
| 2011-01-10 | BR | Futures | 0.25175 | 0.25231 | 0.25172 | 0.25231 | 260.0 |
| 2011-01-10 | BZ | Futures | 86.11 | 86.64 | 86.03 | 86.62 | 1132.0 |
| 2011-01-10 | C | Futures | 2099.0 | 2121.0 | 2084.0 | 2120.0 | 5572.0 |
| 2011-01-10 | CB | Futures | 117.335 | 117.335 | 116.734 | 116.734 | 5.0 |
| 2011-01-10 | CC | Futures | 2297.0 | 2343.0 | 2291.0 | 2338.0 | 6734.0 |
| 2011-01-10 | CT | Futures | 120.48 | 123.99 | 120.48 | 122.84 | 9794.0 |
| 2011-01-10 | DC | Futures | 23.75 | 24.03 | 23.75 | 23.95 | 184.0 |
| 2011-01-10 | DX | Futures | 81.343 | 81.488 | 80.969 | 81.017 | 19045.0 |
| 2011-01-10 | E1 | Futures | 1.35372 | 1.36172 | 1.34783 | 1.3549 | 36159.0 |
| 2011-01-10 | E6 | Futures | 1.5253 | 1.53334 | 1.52258 | 1.53192 | 301045.0 |
| 2011-01-10 | E7 | Futures | 1.5125 | 1.5219 | 1.5114 | 1.5205 | 4728.0 |
| 2011-01-10 | EBM | Futures | 227.86 | 230.81 | 227.18 | 230.59 | 6728.0 |
| 2011-01-10 | ED | Futures | 94.7861 | 94.7956 | 94.7766 | 94.7861 | 153488.0 |
| 2011-01-10 | ER | Futures | 97.365 | 97.365 | 97.35 | 97.355 | 66642.0 |
| 2011-01-10 | EW | Futures | 892.6 | 902.9 | 885.0 | 899.6 | 26221.0 |
| 2011-01-10 | FBTP | Futures | 63.74 | 63.74 | 63.29 | 63.37 | 4899.0 |
| 2011-01-10 | FCE | Futures | 2571.6 | 2573.3 | 2529.3 | 2538.3 | 139471.0 |
| 2011-01-10 | FDAX | Futures | 7437.1 | 7444.6 | 7327.3 | 7367.5 | 142049.0 |
| 2011-01-10 | FESX | Futures | 1736.5 | 1737.1 | 1709.1 | 1715.3 | 1289023.0 |
| 2011-01-10 | FEU3 | Futures | 97.914 | 97.914 | 97.909 | 97.914 | 194.0 |
| 2011-01-10 | FGBL | Futures | 100.03 | 100.15 | 99.77 | 100.01 | 634735.0 |
| 2011-01-10 | FGBM | Futures | 105.38 | 105.46 | 105.22 | 105.37 | 364327.0 |
| 2011-01-10 | FGBS | Futures | 107.578 | 107.593 | 107.509 | 107.578 | 272923.0 |
| 2011-01-10 | FGBX | Futures | 98.92 | 99.03 | 98.27 | 98.74 | 3118.0 |
| 2011-01-10 | FTDX | Futures | 764.0 | 764.0 | 750.8 | 751.2 | 519.0 |
| 2011-01-10 | FTI | Futures | 285.2 | 285.92 | 284.92 | 285.0 | 105.0 |
| 2011-01-10 | FTUK | Futures | 4127.3 | 4132.9 | 4097.4 | 4114.8 | 84720.0 |
| 2011-01-10 | FXXP | Futures | 180.2 | 180.3 | 180.1 | 180.3 | 1386.0 |
| 2011-01-10 | G | Futures | 81.43 | 81.57 | 81.1 | 81.48 | 81116.0 |
| 2011-01-10 | GF | Futures | 302.914 | 305.874 | 302.791 | 304.456 | 1800.0 |
| 2011-01-10 | GSCI | Futures | 1000.42 | 1000.42 | 1000.42 | 1000.42 | 2027.0 |
| 2011-01-10 | HE | Futures | 99.797 | 100.957 | 99.703 | 99.953 | 23402.0 |
| 2011-01-10 | HG | Futures | 5.7121 | 5.7674 | 5.6694 | 5.6834 | 26975.0 |
| 2011-01-10 | HO | Futures | 2.1053 | 2.1456 | 2.0882 | 2.1391 | 27214.0 |
| 2011-01-10 | HRC | Futures | 2729.6 | 2729.6 | 2729.6 | 2729.6 | 0.0 |
| 2011-01-10 | J1 | Futures | 0.0151084 | 0.0152001 | 0.0150883 | 0.0151762 | 87756.0 |
| 2011-01-10 | J7 | Futures | 0.015012 | 0.015091 | 0.014981 | 0.015068 | 98.0 |
| 2011-01-10 | KC | Futures | 566.97 | 576.65 | 565.37 | 567.09 | 10219.0 |
| 2011-01-10 | KE | Futures | 3454.33 | 3489.99 | 3424.79 | 3428.87 | 18233.0 |
| 2011-01-10 | L | Futures | 98.096 | 98.105 | 98.036 | 98.076 | 124244.0 |
> showing 50 of 91 rows — these rows as CSV