PREVIEW / futures_daily / 2011-03-01
file: by_date/futures_daily/2011/2011-03-01.parquet size: 9 KB rows: 92
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-03-01 | ES | Futures | 1305.71 | 1315.55 | 1280.36 | 1280.61 | 3054741.0 |
| 2011-03-01 | NQ | Futures | 2669.1 | 2692.66 | 2619.71 | 2624.26 | 349697.0 |
| 2011-03-01 | YM | Futures | 11431.4 | 11504.4 | 11248.0 | 11251.7 | 136198.0 |
| 2011-03-01 | CL | Futures | 188.41 | 195.64 | 187.24 | 193.58 | 322429.0 |
| 2011-03-01 | GC | Futures | 1915.7 | 1948.3 | 1913.3 | 1942.3 | 169542.0 |
| 2011-03-01 | ZN | Futures | 100.036594 | 100.309563 | 99.659637 | 100.192576 | 239169.0 |
| 2011-03-01 | A6 | Futures | 0.86233 | 0.86386 | 0.85707 | 0.85826 | 92996.0 |
| 2011-03-01 | AD | Futures | 1.02162 | 1.0246 | 1.01706 | 1.01785 | 88154.0 |
| 2011-03-01 | B | Futures | 94.81 | 98.88 | 94.74 | 97.79 | 110394.0 |
| 2011-03-01 | B6 | Futures | 1.6872 | 1.6939 | 1.6857 | 1.687 | 126980.0 |
| 2011-03-01 | BFX | Futures | 3141.9 | 3146.5 | 3123.4 | 3123.4 | 64.0 |
| 2011-03-01 | BR | Futures | 0.2609 | 0.26112 | 0.25958 | 0.25982 | 215.0 |
| 2011-03-01 | BZ | Futures | 100.87 | 103.87 | 100.87 | 103.02 | 1137.0 |
| 2011-03-01 | C | Futures | 2618.0 | 2623.0 | 2546.0 | 2553.0 | 3189.0 |
| 2011-03-01 | CB | Futures | 114.695 | 114.989 | 114.695 | 114.695 | 1.0 |
| 2011-03-01 | CC | Futures | 2970.0 | 2983.0 | 2733.0 | 2909.0 | 12628.0 |
| 2011-03-01 | CT | Futures | 177.26 | 177.26 | 171.31 | 173.12 | 11781.0 |
| 2011-03-01 | DC | Futures | 29.26 | 29.48 | 29.26 | 29.43 | 71.0 |
| 2011-03-01 | DX | Futures | 76.717 | 76.991 | 76.627 | 76.944 | 19641.0 |
| 2011-03-01 | E1 | Futures | 1.41192 | 1.41349 | 1.40615 | 1.40943 | 52362.0 |
| 2011-03-01 | E6 | Futures | 1.63296 | 1.63887 | 1.62799 | 1.62905 | 276952.0 |
| 2011-03-01 | E7 | Futures | 1.6212 | 1.6266 | 1.616 | 1.6169 | 4593.0 |
| 2011-03-01 | EBM | Futures | 235.81 | 236.03 | 233.54 | 233.54 | 3780.0 |
| 2011-03-01 | ED | Futures | 94.8622 | 94.867 | 94.8622 | 94.8622 | 114530.0 |
| 2011-03-01 | ER | Futures | 97.281 | 97.286 | 97.271 | 97.286 | 84981.0 |
| 2011-03-01 | EW | Futures | 952.3 | 958.7 | 932.4 | 933.0 | 27360.0 |
| 2011-03-01 | FBTP | Futures | 63.55 | 63.7 | 63.52 | 63.64 | 9584.0 |
| 2011-03-01 | FCE | Futures | 2744.5 | 2755.5 | 2683.7 | 2702.6 | 165502.0 |
| 2011-03-01 | FDAX | Futures | 7849.4 | 7882.0 | 7676.4 | 7736.4 | 172467.0 |
| 2011-03-01 | FESX | Futures | 1884.9 | 1890.5 | 1837.1 | 1853.3 | 1645015.0 |
| 2011-03-01 | FGBL | Futures | 98.24 | 98.46 | 98.04 | 98.25 | 1313570.0 |
| 2011-03-01 | FGBM | Futures | 103.63 | 103.71 | 103.43 | 103.56 | 690549.0 |
| 2011-03-01 | FGBS | Futures | 106.611 | 106.65 | 106.571 | 106.616 | 651495.0 |
| 2011-03-01 | FGBX | Futures | 95.39 | 95.9 | 95.16 | 95.48 | 5632.0 |
| 2011-03-01 | FTDX | Futures | 799.5 | 804.8 | 785.9 | 791.2 | 630.0 |
| 2011-03-01 | FTI | Futures | 300.16 | 301.34 | 296.04 | 297.98 | 44706.0 |
| 2011-03-01 | FTUK | Futures | 4161.7 | 4184.3 | 4075.2 | 4108.9 | 128047.0 |
| 2011-03-01 | FXXP | Futures | 186.8 | 187.3 | 184.0 | 184.6 | 2448.0 |
| 2011-03-01 | G | Futures | 80.87 | 80.95 | 80.64 | 80.79 | 162326.0 |
| 2011-03-01 | GF | Futures | 321.045 | 321.538 | 316.049 | 317.961 | 3598.0 |
| 2011-03-01 | GSCI | Futures | 1092.54 | 1106.91 | 1091.2 | 1103.69 | 286.0 |
| 2011-03-01 | HE | Futures | 103.672 | 104.489 | 102.388 | 102.797 | 19285.0 |
| 2011-03-01 | HG | Futures | 5.9933 | 6.0272 | 5.9254 | 6.0066 | 32520.0 |
| 2011-03-01 | HO | Futures | 2.4675 | 2.5582 | 2.4656 | 2.5347 | 13675.0 |
| 2011-03-01 | HRC | Futures | 3045.8 | 3045.8 | 3045.8 | 3045.8 | 0.0 |
| 2011-03-01 | J1 | Futures | 0.0153796 | 0.0153796 | 0.0152716 | 0.0153307 | 141510.0 |
| 2011-03-01 | J7 | Futures | 0.015259 | 0.015259 | 0.015166 | 0.015222 | 463.0 |
| 2011-03-01 | JB | Futures | 120.53 | 120.6 | 120.3 | 120.34 | 3471.0 |
| 2011-03-01 | KC | Futures | 659.0 | 666.76 | 643.61 | 652.7 | 10791.0 |
| 2011-03-01 | KE | Futures | 3673.05 | 3685.09 | 3595.77 | 3661.01 | 18135.0 |
> showing 50 of 92 rows — these rows as CSV