PREVIEW / futures_daily / 2009-08-07
file: by_date/futures_daily/2009/2009-08-07.parquet size: 8 KB rows: 84
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-08-07 | ES | Futures | 954.4 | 974.79 | 949.85 | 965.68 | 1979123.0 |
| 2009-08-07 | NQ | Futures | 1802.14 | 1833.11 | 1796.51 | 1824.1 | 280789.0 |
| 2009-08-07 | YM | Futures | 8322.4 | 8484.8 | 8292.6 | 8413.5 | 126368.0 |
| 2009-08-07 | CL | Futures | 184.89 | 187.54 | 181.2 | 182.62 | 367023.0 |
| 2009-08-07 | GC | Futures | 1334.3 | 1338.2 | 1320.9 | 1326.4 | 87106.0 |
| 2009-08-07 | ZN | Futures | 91.175146 | 91.298273 | 90.350199 | 90.571827 | 856785.0 |
| 2009-08-07 | A6 | Futures | 0.6732 | 0.6777 | 0.66886 | 0.67055 | 93440.0 |
| 2009-08-07 | AD | Futures | 0.9167 | 0.91857 | 0.90899 | 0.91225 | 71161.0 |
| 2009-08-07 | B | Futures | 71.12 | 71.91 | 69.72 | 70.15 | 73722.0 |
| 2009-08-07 | B6 | Futures | 1.7475 | 1.7535 | 1.7341 | 1.7357 | 127462.0 |
| 2009-08-07 | BFX | Futures | 2517.7 | 2565.5 | 2516.3 | 2565.5 | 950.0 |
| 2009-08-07 | BZ | Futures | 74.88 | 74.88 | 73.18 | 73.18 | 3.0 |
| 2009-08-07 | C | Futures | 1842.0 | 1878.0 | 1838.0 | 1874.0 | 2241.0 |
| 2009-08-07 | CC | Futures | 2499.0 | 2532.0 | 2482.0 | 2520.0 | 4930.0 |
| 2009-08-07 | CT | Futures | 51.97 | 54.82 | 51.81 | 53.54 | 127.0 |
| 2009-08-07 | DC | Futures | 22.23 | 22.68 | 22.13 | 22.57 | 250.0 |
| 2009-08-07 | DX | Futures | 79.882 | 81.074 | 79.728 | 80.967 | 13091.0 |
| 2009-08-07 | E1 | Futures | 1.2437 | 1.25284 | 1.22093 | 1.22265 | 61279.0 |
| 2009-08-07 | E6 | Futures | 1.70384 | 1.71168 | 1.68034 | 1.68236 | 273006.0 |
| 2009-08-07 | E7 | Futures | 1.6866 | 1.6938 | 1.6632 | 1.6651 | 2471.0 |
| 2009-08-07 | ED | Futures | 93.9613 | 93.9708 | 93.9283 | 93.9519 | 159203.0 |
| 2009-08-07 | ER | Futures | 97.09 | 97.095 | 97.066 | 97.076 | 78132.0 |
| 2009-08-07 | EW | Futures | 617.5 | 635.9 | 614.4 | 629.6 | 32240.0 |
| 2009-08-07 | FCE | Futures | 2274.3 | 2320.5 | 2252.6 | 2308.3 | 127644.0 |
| 2009-08-07 | FDAX | Futures | 5885.2 | 6016.3 | 5832.0 | 5994.4 | 145215.0 |
| 2009-08-07 | FESX | Futures | 1581.2 | 1621.8 | 1571.6 | 1614.6 | 1088928.0 |
| 2009-08-07 | FEU3 | Futures | 97.663 | 97.663 | 97.648 | 97.653 | 426.0 |
| 2009-08-07 | FGBL | Futures | 92.12 | 92.35 | 91.21 | 91.41 | 713540.0 |
| 2009-08-07 | FGBM | Futures | 97.67 | 97.8 | 96.98 | 97.11 | 404951.0 |
| 2009-08-07 | FGBS | Futures | 103.791 | 103.858 | 103.56 | 103.594 | 527725.0 |
| 2009-08-07 | FGBX | Futures | 85.74 | 85.74 | 84.15 | 84.41 | 1386.0 |
| 2009-08-07 | FTDX | Futures | 595.6 | 606.7 | 586.7 | 604.1 | 708.0 |
| 2009-08-07 | FTI | Futures | 235.07 | 239.72 | 233.8 | 238.57 | 34750.0 |
| 2009-08-07 | FTUK | Futures | 3082.7 | 3135.5 | 3058.8 | 3121.2 | 120478.0 |
| 2009-08-07 | G | Futures | 76.02 | 76.18 | 75.16 | 75.41 | 82358.0 |
| 2009-08-07 | GF | Futures | 276.595 | 279.765 | 276.319 | 279.351 | 635.0 |
| 2009-08-07 | GSCI | Futures | 983.24 | 995.15 | 971.75 | 974.25 | 2875.0 |
| 2009-08-07 | HE | Futures | 70.414 | 70.639 | 66.892 | 67.304 | 16239.0 |
| 2009-08-07 | HG | Futures | 3.8501 | 3.9435 | 3.7897 | 3.9112 | 26368.0 |
| 2009-08-07 | HO | Futures | 1.974 | 1.9857 | 1.9284 | 1.9352 | 36158.0 |
| 2009-08-07 | HRC | Futures | 2535.8 | 2535.8 | 2535.8 | 2535.8 | 0.0 |
| 2009-08-07 | J1 | Futures | 0.0131947 | 0.0132501 | 0.0128762 | 0.0129039 | 167275.0 |
| 2009-08-07 | J7 | Futures | 0.013023 | 0.013061 | 0.012704 | 0.012726 | 299.0 |
| 2009-08-07 | JB | Futures | 115.81 | 115.97 | 115.74 | 115.93 | 1200.0 |
| 2009-08-07 | KC | Futures | 364.68 | 374.59 | 361.15 | 374.18 | 15787.0 |
| 2009-08-07 | KE | Futures | 2567.25 | 2587.63 | 2507.29 | 2519.29 | 9098.0 |
| 2009-08-07 | L | Futures | 97.435 | 97.455 | 97.416 | 97.426 | 53869.0 |
| 2009-08-07 | LBS | Futures | 828.9 | 841.5 | 792.4 | 800.1 | 1016.0 |
| 2009-08-07 | LE | Futures | 147.845 | 149.177 | 146.846 | 148.386 | 16347.0 |
| 2009-08-07 | MP | Futures | 0.03999 | 0.04045 | 0.03991 | 0.04025 | 13501.0 |
> showing 50 of 84 rows — these rows as CSV