PREVIEW / futures_daily / 2011-05-06
file: by_date/futures_daily/2011/2011-05-06.parquet size: 9 KB rows: 95
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-05-06 | ES | Futures | 1320.92 | 1338.25 | 1318.45 | 1321.17 | 2673077.0 |
| 2011-05-06 | NQ | Futures | 2708.84 | 2744.43 | 2702.29 | 2703.15 | 358939.0 |
| 2011-05-06 | YM | Futures | 11805.8 | 11953.4 | 11796.4 | 11817.1 | 166175.0 |
| 2011-05-06 | CL | Futures | 192.25 | 197.29 | 182.36 | 187.27 | 606528.0 |
| 2011-05-06 | GC | Futures | 1997.6 | 2028.2 | 1991.1 | 2018.9 | 264796.0 |
| 2011-05-06 | ZN | Futures | 102.949147 | 103.212511 | 102.422418 | 103.054493 | 1738117.0 |
| 2011-05-06 | A6 | Futures | 0.90476 | 0.92226 | 0.90468 | 0.91102 | 197500.0 |
| 2011-05-06 | AD | Futures | 1.02908 | 1.03924 | 1.0253 | 1.02639 | 154811.0 |
| 2011-05-06 | B | Futures | 94.19 | 96.7 | 89.11 | 92.38 | 179739.0 |
| 2011-05-06 | B6 | Futures | 1.7018 | 1.7096 | 1.6982 | 1.6994 | 150109.0 |
| 2011-05-06 | BFX | Futures | 3174.9 | 3191.5 | 3158.8 | 3190.3 | 147.0 |
| 2011-05-06 | BR | Futures | 0.26948 | 0.27238 | 0.26948 | 0.2708 | 298.0 |
| 2011-05-06 | BZ | Futures | 97.61 | 97.61 | 97.34 | 97.34 | 1581.0 |
| 2011-05-06 | C | Futures | 2062.0 | 2067.0 | 2032.0 | 2061.0 | 3307.0 |
| 2011-05-06 | CC | Futures | 2429.0 | 2472.0 | 2401.0 | 2453.0 | 9451.0 |
| 2011-05-06 | CSC | Futures | 4.374 | 4.389 | 4.374 | 4.374 | 1.0 |
| 2011-05-06 | CT | Futures | 145.36 | 147.57 | 142.33 | 144.07 | 8050.0 |
| 2011-05-06 | DC | Futures | 29.52 | 29.76 | 29.45 | 29.67 | 221.0 |
| 2011-05-06 | DX | Futures | 73.889 | 74.805 | 73.74 | 74.705 | 66749.0 |
| 2011-05-06 | E1 | Futures | 1.50489 | 1.5096 | 1.48826 | 1.49035 | 65456.0 |
| 2011-05-06 | E6 | Futures | 1.72036 | 1.7264 | 1.69311 | 1.69655 | 541290.0 |
| 2011-05-06 | E7 | Futures | 1.7077 | 1.7136 | 1.6812 | 1.6839 | 9252.0 |
| 2011-05-06 | ED | Futures | 94.9502 | 94.9597 | 94.9359 | 94.9406 | 262616.0 |
| 2011-05-06 | ER | Futures | 97.296 | 97.301 | 97.267 | 97.277 | 238632.0 |
| 2011-05-06 | EW | Futures | 980.9 | 993.4 | 977.0 | 978.5 | 30985.0 |
| 2011-05-06 | FBTP | Futures | 64.99 | 65.05 | 64.7 | 64.94 | 7070.0 |
| 2011-05-06 | FCE | Futures | 2701.8 | 2743.0 | 2689.9 | 2738.9 | 170795.0 |
| 2011-05-06 | FDAX | Futures | 7888.6 | 8029.0 | 7878.5 | 8013.5 | 150938.0 |
| 2011-05-06 | FESX | Futures | 1847.2 | 1872.8 | 1835.6 | 1869.0 | 1401498.0 |
| 2011-05-06 | FEU3 | Futures | 97.83 | 97.835 | 97.815 | 97.82 | 19.0 |
| 2011-05-06 | FGBL | Futures | 98.55 | 99.18 | 98.42 | 98.77 | 1238964.0 |
| 2011-05-06 | FGBM | Futures | 103.33 | 103.7 | 103.16 | 103.35 | 711189.0 |
| 2011-05-06 | FGBS | Futures | 106.404 | 106.513 | 106.32 | 106.375 | 967481.0 |
| 2011-05-06 | FGBX | Futures | 94.78 | 96.06 | 94.67 | 95.18 | 5300.0 |
| 2011-05-06 | FTDX | Futures | 817.2 | 829.7 | 794.9 | 829.2 | 1065.0 |
| 2011-05-06 | FTI | Futures | 291.03 | 295.14 | 289.92 | 294.57 | 37824.0 |
| 2011-05-06 | FTUK | Futures | 4115.8 | 4170.4 | 4088.5 | 4165.8 | 127705.0 |
| 2011-05-06 | FXXP | Futures | 184.1 | 186.9 | 184.0 | 186.9 | 850.0 |
| 2011-05-06 | G | Futures | 83.34 | 83.65 | 83.24 | 83.47 | 123536.0 |
| 2011-05-06 | GF | Futures | 309.494 | 312.201 | 306.425 | 310.757 | 1338.0 |
| 2011-05-06 | GSCI | Futures | 1054.42 | 1089.41 | 1048.17 | 1048.17 | 2713.0 |
| 2011-05-06 | HE | Futures | 98.19 | 98.376 | 97.317 | 97.82 | 25032.0 |
| 2011-05-06 | HG | Futures | 5.2956 | 5.3933 | 5.2186 | 5.2817 | 51081.0 |
| 2011-05-06 | HO | Futures | 2.4035 | 2.464 | 2.3012 | 2.3646 | 85959.0 |
| 2011-05-06 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-06 | J1 | Futures | 0.0156486 | 0.0156662 | 0.0155229 | 0.0156147 | 157252.0 |
| 2011-05-06 | J7 | Futures | 0.015545 | 0.015568 | 0.015429 | 0.015519 | 924.0 |
| 2011-05-06 | JB | Futures | 122.55 | 122.59 | 122.48 | 122.59 | 7.0 |
| 2011-05-06 | KC | Futures | 688.34 | 707.17 | 679.83 | 689.54 | 11393.0 |
| 2011-05-06 | KE | Futures | 3393.75 | 3492.49 | 3338.46 | 3452.01 | 14255.0 |
> showing 50 of 95 rows — these rows as CSV