PREVIEW / futures_daily / 2011-08-22
file: by_date/futures_daily/2011/2011-08-22.parquet size: 9 KB rows: 96
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-08-22 | ES | Futures | 1114.3 | 1138.63 | 1103.62 | 1115.54 | 2714560.0 |
| 2011-08-22 | NQ | Futures | 2324.2 | 2374.88 | 2302.85 | 2327.62 | 254177.0 |
| 2011-08-22 | YM | Futures | 10213.2 | 10431.6 | 10128.1 | 10254.8 | 127065.0 |
| 2011-08-22 | CL | Futures | 156.71 | 161.53 | 154.64 | 160.81 | 374045.0 |
| 2011-08-22 | GC | Futures | 2515.2 | 2570.7 | 2508.6 | 2554.4 | 253907.0 |
| 2011-08-22 | ZN | Futures | 111.442449 | 111.535584 | 110.91025 | 111.202959 | 928495.0 |
| 2011-08-22 | A6 | Futures | 0.90039 | 0.90778 | 0.89804 | 0.90343 | 81485.0 |
| 2011-08-22 | AD | Futures | 1.00644 | 1.01483 | 1.00524 | 1.00824 | 71191.0 |
| 2011-08-22 | B | Futures | 92.81 | 93.02 | 89.95 | 92.69 | 241049.0 |
| 2011-08-22 | B6 | Futures | 1.7144 | 1.7182 | 1.7093 | 1.7144 | 63539.0 |
| 2011-08-22 | BFX | Futures | 2588.8 | 2593.8 | 2573.6 | 2582.5 | 152.0 |
| 2011-08-22 | BR | Futures | 0.27824 | 0.27862 | 0.27655 | 0.27715 | 593.0 |
| 2011-08-22 | BZ | Futures | 93.96 | 96.02 | 93.06 | 95.73 | 1287.0 |
| 2011-08-22 | C | Futures | 2032.0 | 2066.0 | 2032.0 | 2063.0 | 2167.0 |
| 2011-08-22 | CC | Futures | 2359.0 | 2394.0 | 2355.0 | 2388.0 | 6688.0 |
| 2011-08-22 | CT | Futures | 136.91 | 138.65 | 136.65 | 138.35 | 49.0 |
| 2011-08-22 | DC | Futures | 30.6 | 31.32 | 30.5 | 31.07 | 329.0 |
| 2011-08-22 | DX | Futures | 73.425 | 73.534 | 73.162 | 73.452 | 13940.0 |
| 2011-08-22 | E1 | Futures | 1.6577 | 1.6713 | 1.65626 | 1.65744 | 16684.0 |
| 2011-08-22 | E6 | Futures | 1.70694 | 1.71383 | 1.70338 | 1.70635 | 182568.0 |
| 2011-08-22 | E7 | Futures | 1.6945 | 1.7013 | 1.6909 | 1.6939 | 2510.0 |
| 2011-08-22 | ED | Futures | 94.8953 | 94.9144 | 94.8763 | 94.9001 | 210413.0 |
| 2011-08-22 | ER | Futures | 97.583 | 97.598 | 97.539 | 97.544 | 131485.0 |
| 2011-08-22 | EW | Futures | 782.6 | 801.6 | 774.8 | 780.4 | 30112.0 |
| 2011-08-22 | FBTP | Futures | 64.76 | 64.86 | 64.47 | 64.62 | 4193.0 |
| 2011-08-22 | FCE | Futures | 2095.1 | 2182.9 | 2086.7 | 2136.2 | 89362.0 |
| 2011-08-22 | FDAX | Futures | 5781.7 | 5978.3 | 5762.5 | 5850.6 | 164628.0 |
| 2011-08-22 | FESX | Futures | 1369.4 | 1428.4 | 1359.1 | 1398.9 | 1317391.0 |
| 2011-08-22 | FEU3 | Futures | 98.119 | 98.119 | 98.084 | 98.084 | 4.0 |
| 2011-08-22 | FGBL | Futures | 108.59 | 108.97 | 108.09 | 108.44 | 597737.0 |
| 2011-08-22 | FGBM | Futures | 109.96 | 110.22 | 109.62 | 109.86 | 367637.0 |
| 2011-08-22 | FGBS | Futures | 108.949 | 109.059 | 108.845 | 108.92 | 370593.0 |
| 2011-08-22 | FGBX | Futures | 107.71 | 108.48 | 107.0 | 107.45 | 5127.0 |
| 2011-08-22 | FTDX | Futures | 614.9 | 626.1 | 602.8 | 615.8 | 306.0 |
| 2011-08-22 | FTI | Futures | 221.36 | 230.62 | 220.91 | 225.52 | 41351.0 |
| 2011-08-22 | FTUK | Futures | 3520.2 | 3654.2 | 3496.9 | 3592.5 | 126805.0 |
| 2011-08-22 | FVSA | Futures | 15446.06 | 15446.06 | 14514.64 | 15252.01 | 2713.0 |
| 2011-08-22 | FXXP | Futures | 149.6 | 154.8 | 149.6 | 152.1 | 3518.0 |
| 2011-08-22 | G | Futures | 90.68 | 90.68 | 90.1 | 90.35 | 82010.0 |
| 2011-08-22 | GF | Futures | 305.84 | 308.359 | 305.84 | 307.271 | 902.0 |
| 2011-08-22 | GSCI | Futures | 1010.13 | 1015.61 | 999.87 | 1014.2 | 79.0 |
| 2011-08-22 | HE | Futures | 108.153 | 109.13 | 107.817 | 108.703 | 10422.0 |
| 2011-08-22 | HG | Futures | 5.2792 | 5.3401 | 5.2263 | 5.2601 | 9643.0 |
| 2011-08-22 | HO | Futures | 2.3403 | 2.3653 | 2.3018 | 2.3584 | 16135.0 |
| 2011-08-22 | HRC | Futures | 2868.4 | 2868.4 | 2868.4 | 2868.4 | 0.0 |
| 2011-08-22 | J1 | Futures | 0.0163713 | 0.0164241 | 0.0162808 | 0.0163826 | 75387.0 |
| 2011-08-22 | J7 | Futures | 0.016274 | 0.016312 | 0.016179 | 0.016273 | 376.0 |
| 2011-08-22 | JB | Futures | 124.3 | 124.41 | 124.23 | 124.24 | 1527.0 |
| 2011-08-22 | KC | Futures | 629.64 | 643.9 | 628.11 | 632.35 | 15138.0 |
| 2011-08-22 | KE | Futures | 3145.79 | 3203.4 | 3135.22 | 3156.35 | 7107.0 |
> showing 50 of 96 rows — these rows as CSV