PREVIEW / futures_daily / 2011-04-01
file: by_date/futures_daily/2011/2011-04-01.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-04-01 | ES | Futures | 1308.05 | 1320.43 | 1307.31 | 1314.49 | 1660075.0 |
| 2011-04-01 | NQ | Futures | 2663.85 | 2685.49 | 2657.31 | 2663.28 | 227985.0 |
| 2011-04-01 | YM | Futures | 11529.4 | 11618.7 | 11524.7 | 11581.1 | 83890.0 |
| 2011-04-01 | CL | Futures | 206.18 | 209.76 | 205.56 | 208.73 | 283710.0 |
| 2011-04-01 | GC | Futures | 1940.7 | 1946.1 | 1913.2 | 1934.0 | 165275.0 |
| 2011-04-01 | ZN | Futures | 100.104811 | 100.315503 | 99.683428 | 100.26283 | 1225517.0 |
| 2011-04-01 | A6 | Futures | 0.87843 | 0.88384 | 0.8768 | 0.88306 | 94695.0 |
| 2011-04-01 | AD | Futures | 1.0253 | 1.03277 | 1.0244 | 1.03048 | 88173.0 |
| 2011-04-01 | B | Futures | 99.61 | 100.81 | 98.85 | 100.44 | 141144.0 |
| 2011-04-01 | B6 | Futures | 1.6643 | 1.6745 | 1.6574 | 1.673 | 153680.0 |
| 2011-04-01 | BFX | Futures | 3101.4 | 3107.2 | 3080.1 | 3095.7 | 67.0 |
| 2011-04-01 | BR | Futures | 0.26891 | 0.26974 | 0.2686 | 0.26902 | 840.0 |
| 2011-04-01 | BZ | Futures | 105.32 | 105.9 | 104.34 | 105.9 | 678.0 |
| 2011-04-01 | C | Futures | 2121.0 | 2168.0 | 2088.0 | 2150.0 | 6575.0 |
| 2011-04-01 | CB | Futures | 115.282 | 115.282 | 115.282 | 115.282 | 2.0 |
| 2011-04-01 | CC | Futures | 2361.0 | 2439.0 | 2351.0 | 2420.0 | 14541.0 |
| 2011-04-01 | CSC | Futures | 4.358 | 4.358 | 4.343 | 4.343 | 2.0 |
| 2011-04-01 | CT | Futures | 174.6 | 179.74 | 174.43 | 174.86 | 10709.0 |
| 2011-04-01 | DC | Futures | 28.95 | 29.46 | 28.72 | 28.83 | 79.0 |
| 2011-04-01 | DX | Futures | 75.919 | 76.486 | 75.656 | 75.703 | 32445.0 |
| 2011-04-01 | E1 | Futures | 1.42606 | 1.42658 | 1.40236 | 1.4182 | 70180.0 |
| 2011-04-01 | E6 | Futures | 1.67618 | 1.68518 | 1.66315 | 1.68388 | 402264.0 |
| 2011-04-01 | E7 | Futures | 1.6635 | 1.6726 | 1.6509 | 1.6713 | 6601.0 |
| 2011-04-01 | EBM | Futures | 228.27 | 228.27 | 224.51 | 225.22 | 9674.0 |
| 2011-04-01 | ED | Futures | 94.8597 | 94.893 | 94.8502 | 94.8835 | 355283.0 |
| 2011-04-01 | ER | Futures | 97.281 | 97.296 | 97.257 | 97.272 | 124908.0 |
| 2011-04-01 | EW | Futures | 980.9 | 990.8 | 980.7 | 988.6 | 22771.0 |
| 2011-04-01 | FBTP | Futures | 64.0 | 64.0 | 63.79 | 63.95 | 6726.0 |
| 2011-04-01 | FCE | Futures | 2668.2 | 2701.5 | 2665.5 | 2699.8 | 113630.0 |
| 2011-04-01 | FDAX | Futures | 7581.6 | 7702.8 | 7571.5 | 7686.8 | 121898.0 |
| 2011-04-01 | FESX | Futures | 1823.5 | 1851.0 | 1822.8 | 1848.5 | 1108509.0 |
| 2011-04-01 | FEU3 | Futures | 97.81 | 97.815 | 97.81 | 97.815 | 181.0 |
| 2011-04-01 | FGBL | Futures | 96.9 | 96.95 | 96.6 | 96.82 | 888943.0 |
| 2011-04-01 | FGBM | Futures | 102.38 | 102.47 | 102.22 | 102.41 | 560152.0 |
| 2011-04-01 | FGBS | Futures | 106.176 | 106.211 | 106.102 | 106.171 | 752102.0 |
| 2011-04-01 | FGBX | Futures | 92.87 | 92.87 | 92.16 | 92.56 | 3718.0 |
| 2011-04-01 | FTDX | Futures | 831.5 | 840.9 | 831.5 | 839.1 | 365.0 |
| 2011-04-01 | FTI | Futures | 298.07 | 299.87 | 297.46 | 299.62 | 30520.0 |
| 2011-04-01 | FTUK | Futures | 4120.3 | 4182.6 | 4115.4 | 4180.5 | 95227.0 |
| 2011-04-01 | FXXP | Futures | 183.1 | 184.4 | 182.4 | 184.3 | 2153.0 |
| 2011-04-01 | G | Futures | 81.06 | 81.16 | 80.76 | 81.05 | 144218.0 |
| 2011-04-01 | GF | Futures | 332.575 | 335.237 | 332.151 | 334.208 | 712.0 |
| 2011-04-01 | GSCI | Futures | 1138.82 | 1145.71 | 1133.49 | 1142.89 | 352.0 |
| 2011-04-01 | HE | Futures | 109.443 | 109.602 | 107.982 | 109.523 | 674.0 |
| 2011-04-01 | HG | Futures | 5.7122 | 5.7409 | 5.6103 | 5.6723 | 33624.0 |
| 2011-04-01 | HO | Futures | 2.5904 | 2.6175 | 2.5794 | 2.6134 | 16524.0 |
| 2011-04-01 | HRC | Futures | 3106.0 | 3106.0 | 3106.0 | 3106.0 | 0.0 |
| 2011-04-01 | J1 | Futures | 0.0151084 | 0.0151109 | 0.014832 | 0.0149463 | 220454.0 |
| 2011-04-01 | J7 | Futures | 0.015006 | 0.015006 | 0.014744 | 0.014855 | 1098.0 |
| 2011-04-01 | JB | Futures | 121.17 | 121.18 | 121.06 | 121.13 | 68.0 |
> showing 50 of 94 rows — these rows as CSV