PREVIEW / futures_daily / 2009-12-28
file: by_date/futures_daily/2009/2009-12-28.parquet size: 8 KB rows: 83
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-28 | ES | Futures | 1086.15 | 1091.73 | 1083.24 | 1088.57 | 474293.0 |
| 2009-12-28 | NQ | Futures | 2112.23 | 2128.07 | 2106.86 | 2120.15 | 120920.0 |
| 2009-12-28 | YM | Futures | 9550.0 | 9585.6 | 9526.2 | 9579.2 | 34475.0 |
| 2009-12-28 | CL | Futures | 184.79 | 187.63 | 184.41 | 186.8 | 108895.0 |
| 2009-12-28 | GC | Futures | 1525.1 | 1534.0 | 1516.9 | 1524.9 | 73189.0 |
| 2009-12-28 | ZN | Futures | 93.295449 | 93.320637 | 92.955414 | 93.106541 | 251644.0 |
| 2009-12-28 | A6 | Futures | 0.71226 | 0.71673 | 0.71153 | 0.71502 | 17352.0 |
| 2009-12-28 | AD | Futures | 0.94164 | 0.94767 | 0.94006 | 0.94668 | 26089.0 |
| 2009-12-28 | B | Futures | 70.1 | 70.83 | 69.89 | 70.74 | 16208.0 |
| 2009-12-28 | B6 | Futures | 1.6555 | 1.6627 | 1.6539 | 1.6612 | 21508.0 |
| 2009-12-28 | BFX | Futures | 2842.4 | 2850.9 | 2839.0 | 2850.9 | 297.0 |
| 2009-12-28 | BR | Futures | 0.22881 | 0.22881 | 0.22853 | 0.22853 | 27.0 |
| 2009-12-28 | CB | Futures | 71.68 | 71.828 | 71.557 | 71.828 | 6.0 |
| 2009-12-28 | CC | Futures | 2824.0 | 2834.0 | 2769.0 | 2775.0 | 2798.0 |
| 2009-12-28 | CT | Futures | 60.53 | 62.4 | 60.53 | 61.81 | 10696.0 |
| 2009-12-28 | DC | Futures | 24.35 | 24.41 | 23.95 | 24.05 | 391.0 |
| 2009-12-28 | DX | Futures | 79.423 | 79.54 | 79.22 | 79.337 | 4697.0 |
| 2009-12-28 | E1 | Futures | 1.27297 | 1.27733 | 1.26981 | 1.27443 | 15252.0 |
| 2009-12-28 | E6 | Futures | 1.70144 | 1.70606 | 1.69872 | 1.70239 | 59279.0 |
| 2009-12-28 | E7 | Futures | 1.689 | 1.6943 | 1.687 | 1.6905 | 935.0 |
| 2009-12-28 | EBM | Futures | 222.24 | 226.89 | 222.24 | 226.47 | 2902.0 |
| 2009-12-28 | ED | Futures | 94.3063 | 94.3063 | 94.2731 | 94.2826 | 61420.0 |
| 2009-12-28 | ER | Futures | 97.233 | 97.233 | 97.218 | 97.228 | 23584.0 |
| 2009-12-28 | EW | Futures | 717.2 | 720.2 | 714.6 | 715.7 | 11201.0 |
| 2009-12-28 | FBTP | Futures | 63.02 | 63.17 | 63.0 | 63.1 | 2146.0 |
| 2009-12-28 | FCE | Futures | 2582.2 | 2586.1 | 2571.1 | 2578.9 | 24824.0 |
| 2009-12-28 | FDAX | Futures | 6592.4 | 6593.5 | 6540.5 | 6565.6 | 37117.0 |
| 2009-12-28 | FESX | Futures | 1795.7 | 1795.7 | 1780.8 | 1787.4 | 230829.0 |
| 2009-12-28 | FEU3 | Futures | 97.781 | 97.791 | 97.781 | 97.791 | 226.0 |
| 2009-12-28 | FGBL | Futures | 93.61 | 93.84 | 93.51 | 93.62 | 109855.0 |
| 2009-12-28 | FGBM | Futures | 99.77 | 99.84 | 99.59 | 99.72 | 92669.0 |
| 2009-12-28 | FGBS | Futures | 105.377 | 105.386 | 105.289 | 105.343 | 106576.0 |
| 2009-12-28 | FGBX | Futures | 87.26 | 87.26 | 86.75 | 86.77 | 858.0 |
| 2009-12-28 | FTDX | Futures | 720.8 | 722.1 | 705.8 | 711.1 | 322.0 |
| 2009-12-28 | FTI | Futures | 273.2 | 275.77 | 273.08 | 274.1 | 9484.0 |
| 2009-12-28 | GF | Futures | 256.119 | 259.51 | 255.644 | 259.103 | 1237.0 |
| 2009-12-28 | GSCI | Futures | 988.87 | 996.26 | 988.11 | 990.57 | 346.0 |
| 2009-12-28 | HE | Futures | 85.573 | 86.81 | 85.573 | 86.576 | 6799.0 |
| 2009-12-28 | HG | Futures | 4.5442 | 4.6132 | 4.5249 | 4.6028 | 8525.0 |
| 2009-12-28 | HO | Futures | 1.9275 | 1.9654 | 1.9275 | 1.9594 | 7073.0 |
| 2009-12-28 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-28 | J1 | Futures | 0.0137484 | 0.0137723 | 0.0137119 | 0.0137434 | 27871.0 |
| 2009-12-28 | J7 | Futures | 0.013545 | 0.013592 | 0.013545 | 0.013571 | 53.0 |
| 2009-12-28 | JB | Futures | 117.97 | 117.99 | 117.64 | 117.67 | 1810.0 |
| 2009-12-28 | KC | Futures | 364.02 | 365.97 | 356.21 | 356.47 | 8866.0 |
| 2009-12-28 | KE | Futures | 2359.58 | 2488.47 | 2348.27 | 2469.25 | 6700.0 |
| 2009-12-28 | LBS | Futures | 781.0 | 791.6 | 777.1 | 779.7 | 487.0 |
| 2009-12-28 | LE | Futures | 138.835 | 139.858 | 138.835 | 139.694 | 10223.0 |
| 2009-12-28 | MFS | Futures | 1271.5 | 1272.6 | 1268.3 | 1271.7 | 625.0 |
| 2009-12-28 | MME | Futures | 830.8 | 832.5 | 827.0 | 832.5 | 464.0 |
> showing 50 of 83 rows — these rows as CSV