PREVIEW / futures_daily / 2011-05-24
file: by_date/futures_daily/2011/2011-05-24.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-05-24 | ES | Futures | 1301.62 | 1309.29 | 1298.65 | 1300.38 | 1860600.0 |
| 2011-05-24 | NQ | Futures | 2637.09 | 2647.06 | 2618.01 | 2621.43 | 244139.0 |
| 2011-05-24 | YM | Futures | 11612.1 | 11668.5 | 11582.0 | 11589.6 | 123571.0 |
| 2011-05-24 | CL | Futures | 187.38 | 192.28 | 185.6 | 191.32 | 323171.0 |
| 2011-05-24 | GC | Futures | 2053.5 | 2069.5 | 2048.1 | 2061.8 | 234391.0 |
| 2011-05-24 | ZN | Futures | 103.673399 | 103.818249 | 103.449539 | 103.726072 | 1320691.0 |
| 2011-05-24 | A6 | Futures | 0.89902 | 0.90528 | 0.89636 | 0.90339 | 131567.0 |
| 2011-05-24 | AD | Futures | 1.01813 | 1.02022 | 1.01624 | 1.01843 | 72795.0 |
| 2011-05-24 | B | Futures | 92.96 | 95.6 | 92.93 | 95.5 | 185478.0 |
| 2011-05-24 | B6 | Futures | 1.6747 | 1.6836 | 1.6677 | 1.6807 | 105695.0 |
| 2011-05-24 | BFX | Futures | 3148.8 | 3161.5 | 3148.8 | 3156.8 | 120.0 |
| 2011-05-24 | BR | Futures | 0.27036 | 0.27078 | 0.26987 | 0.2702 | 1363.0 |
| 2011-05-24 | BZ | Futures | 99.01 | 100.76 | 98.8 | 100.63 | 398.0 |
| 2011-05-24 | C | Futures | 1947.0 | 1969.0 | 1940.0 | 1948.0 | 7155.0 |
| 2011-05-24 | CB | Futures | 119.998 | 120.272 | 119.463 | 119.532 | 43.0 |
| 2011-05-24 | CC | Futures | 2291.0 | 2327.0 | 2277.0 | 2296.0 | 11490.0 |
| 2011-05-24 | CT | Futures | 152.31 | 156.13 | 151.93 | 152.3 | 7919.0 |
| 2011-05-24 | DC | Futures | 30.9 | 31.05 | 30.57 | 31.0 | 1.0 |
| 2011-05-24 | DX | Futures | 76.063 | 76.068 | 75.581 | 75.644 | 27148.0 |
| 2011-05-24 | E1 | Futures | 1.48184 | 1.49114 | 1.47176 | 1.4893 | 42897.0 |
| 2011-05-24 | E6 | Futures | 1.6635 | 1.67333 | 1.6577 | 1.67049 | 310004.0 |
| 2011-05-24 | E7 | Futures | 1.6508 | 1.6609 | 1.6456 | 1.6581 | 7752.0 |
| 2011-05-24 | ED | Futures | 94.9454 | 94.9549 | 94.943 | 94.9525 | 668.0 |
| 2011-05-24 | ER | Futures | 97.296 | 97.306 | 97.286 | 97.291 | 143751.0 |
| 2011-05-24 | EW | Futures | 964.4 | 969.9 | 958.8 | 961.5 | 21002.0 |
| 2011-05-24 | FBTP | Futures | 64.8 | 64.94 | 64.74 | 64.93 | 4295.0 |
| 2011-05-24 | FCE | Futures | 2695.7 | 2714.5 | 2690.2 | 2702.7 | 104495.0 |
| 2011-05-24 | FDAX | Futures | 7613.6 | 7698.0 | 7604.0 | 7635.0 | 141285.0 |
| 2011-05-24 | FESX | Futures | 1787.0 | 1799.8 | 1780.5 | 1789.5 | 1159980.0 |
| 2011-05-24 | FEU3 | Futures | 97.84 | 97.845 | 97.835 | 97.835 | 313.0 |
| 2011-05-24 | FGBL | Futures | 100.11 | 100.16 | 99.79 | 99.8 | 965413.0 |
| 2011-05-24 | FGBM | Futures | 104.35 | 104.4 | 104.21 | 104.23 | 596987.0 |
| 2011-05-24 | FGBS | Futures | 106.702 | 106.736 | 106.657 | 106.672 | 692072.0 |
| 2011-05-24 | FGBX | Futures | 97.44 | 97.53 | 96.76 | 96.79 | 10511.0 |
| 2011-05-24 | FTDX | Futures | 802.5 | 806.9 | 795.8 | 801.6 | 489.0 |
| 2011-05-24 | FTI | Futures | 281.19 | 282.95 | 280.29 | 281.4 | 34817.0 |
| 2011-05-24 | FTUK | Futures | 4073.1 | 4108.4 | 4063.3 | 4084.7 | 99908.0 |
| 2011-05-24 | FXXP | Futures | 184.0 | 184.5 | 183.7 | 183.8 | 3310.0 |
| 2011-05-24 | G | Futures | 84.06 | 84.08 | 83.87 | 83.9 | 251782.0 |
| 2011-05-24 | GF | Futures | 282.95 | 287.947 | 279.929 | 285.332 | 38.0 |
| 2011-05-24 | GSCI | Futures | 1070.77 | 1077.5 | 1060.99 | 1070.77 | 145.0 |
| 2011-05-24 | HE | Futures | 93.928 | 94.219 | 92.048 | 92.604 | 70.0 |
| 2011-05-24 | HG | Futures | 5.2843 | 5.3913 | 5.2637 | 5.3315 | 33378.0 |
| 2011-05-24 | HO | Futures | 2.339 | 2.396 | 2.3329 | 2.3897 | 8001.0 |
| 2011-05-24 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-24 | J1 | Futures | 0.0153358 | 0.0153948 | 0.0152805 | 0.0153395 | 98554.0 |
| 2011-05-24 | J7 | Futures | 0.015236 | 0.015299 | 0.015189 | 0.015246 | 7.0 |
| 2011-05-24 | JB | Futures | 122.68 | 122.72 | 122.55 | 122.55 | 233.0 |
| 2011-05-24 | KC | Futures | 631.63 | 636.66 | 625.15 | 626.35 | 9788.0 |
| 2011-05-24 | KE | Futures | 3679.12 | 3701.83 | 3602.1 | 3602.1 | 358.0 |
> showing 50 of 94 rows — these rows as CSV