PREVIEW / futures_daily / 2009-08-06
file: by_date/futures_daily/2009/2009-08-06.parquet size: 8 KB rows: 86
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-06 | ES | Futures | 959.68 | 966.88 | 949.61 | 954.64 | 1731837.0 |
| 2009-08-06 | NQ | Futures | 1819.03 | 1829.45 | 1794.54 | 1803.27 | 271304.0 |
| 2009-08-06 | YM | Futures | 8343.1 | 8418.0 | 8274.5 | 8326.9 | 129409.0 |
| 2009-08-06 | CL | Futures | 184.94 | 186.46 | 180.69 | 185.22 | 328670.0 |
| 2009-08-06 | GC | Futures | 1334.1 | 1346.9 | 1324.7 | 1331.1 | 108950.0 |
| 2009-08-06 | ZN | Futures | 91.076645 | 91.409087 | 90.879643 | 91.212084 | 789475.0 |
| 2009-08-06 | A6 | Futures | 0.67408 | 0.67866 | 0.67063 | 0.67167 | 70275.0 |
| 2009-08-06 | AD | Futures | 0.92272 | 0.92539 | 0.91462 | 0.91581 | 55954.0 |
| 2009-08-06 | B | Futures | 71.47 | 72.22 | 70.38 | 71.26 | 90021.0 |
| 2009-08-06 | B6 | Futures | 1.7693 | 1.7737 | 1.7446 | 1.7471 | 139055.0 |
| 2009-08-06 | BFX | Futures | 2508.6 | 2540.5 | 2500.6 | 2534.0 | 191.0 |
| 2009-08-06 | BR | Futures | 0.21386 | 0.21386 | 0.21129 | 0.21129 | 103.0 |
| 2009-08-06 | BZ | Futures | 74.28 | 74.33 | 74.28 | 74.33 | 2.0 |
| 2009-08-06 | C | Futures | 1863.0 | 1869.0 | 1841.0 | 1842.0 | 2738.0 |
| 2009-08-06 | CB | Futures | 71.905 | 72.189 | 71.621 | 72.189 | 13.0 |
| 2009-08-06 | CC | Futures | 2544.0 | 2567.0 | 2500.0 | 2502.0 | 5107.0 |
| 2009-08-06 | CT | Futures | 53.08 | 54.01 | 51.66 | 52.17 | 112.0 |
| 2009-08-06 | DC | Futures | 21.75 | 22.23 | 21.52 | 22.13 | 181.0 |
| 2009-08-06 | DX | Futures | 79.529 | 80.082 | 79.416 | 79.995 | 4700.0 |
| 2009-08-06 | E1 | Futures | 1.24781 | 1.24886 | 1.23986 | 1.24251 | 32582.0 |
| 2009-08-06 | E6 | Futures | 1.7112 | 1.71334 | 1.701 | 1.70266 | 207832.0 |
| 2009-08-06 | E7 | Futures | 1.6932 | 1.6956 | 1.6831 | 1.6852 | 1971.0 |
| 2009-08-06 | ED | Futures | 93.966 | 93.9755 | 93.9566 | 93.9613 | 93335.0 |
| 2009-08-06 | ER | Futures | 97.076 | 97.095 | 97.066 | 97.095 | 137168.0 |
| 2009-08-06 | EW | Futures | 621.7 | 626.5 | 614.2 | 617.3 | 29974.0 |
| 2009-08-06 | FCE | Futures | 2281.8 | 2302.8 | 2263.1 | 2280.2 | 95722.0 |
| 2009-08-06 | FDAX | Futures | 5924.7 | 5954.3 | 5855.6 | 5892.4 | 109431.0 |
| 2009-08-06 | FESX | Futures | 1588.9 | 1602.1 | 1574.0 | 1587.1 | 773339.0 |
| 2009-08-06 | FEU3 | Futures | 97.648 | 97.672 | 97.648 | 97.672 | 613.0 |
| 2009-08-06 | FGBL | Futures | 92.21 | 92.76 | 92.02 | 92.3 | 839525.0 |
| 2009-08-06 | FGBM | Futures | 97.7 | 98.05 | 97.62 | 97.74 | 472695.0 |
| 2009-08-06 | FGBS | Futures | 103.81 | 103.921 | 103.752 | 103.834 | 566906.0 |
| 2009-08-06 | FGBX | Futures | 85.23 | 86.37 | 85.23 | 85.74 | 2695.0 |
| 2009-08-06 | FTDX | Futures | 601.8 | 606.3 | 593.4 | 598.7 | 335.0 |
| 2009-08-06 | FTI | Futures | 235.53 | 238.24 | 234.91 | 236.64 | 27319.0 |
| 2009-08-06 | FTUK | Futures | 3082.7 | 3125.2 | 3078.1 | 3095.7 | 103835.0 |
| 2009-08-06 | G | Futures | 75.0 | 76.98 | 74.98 | 75.7 | 141974.0 |
| 2009-08-06 | GF | Futures | 279.076 | 280.247 | 276.526 | 278.662 | 630.0 |
| 2009-08-06 | GSCI | Futures | 997.65 | 997.65 | 976.97 | 985.95 | 531.0 |
| 2009-08-06 | HE | Futures | 74.574 | 74.574 | 70.752 | 71.314 | 11216.0 |
| 2009-08-06 | HG | Futures | 3.9582 | 3.9603 | 3.8234 | 3.8641 | 23025.0 |
| 2009-08-06 | HO | Futures | 1.9706 | 1.9976 | 1.947 | 1.96 | 42033.0 |
| 2009-08-06 | HRC | Futures | 2535.8 | 2535.8 | 2535.8 | 2535.8 | 0.0 |
| 2009-08-06 | J1 | Futures | 0.0132677 | 0.0132879 | 0.0131431 | 0.0131947 | 99926.0 |
| 2009-08-06 | J7 | Futures | 0.013102 | 0.013102 | 0.012967 | 0.013013 | 124.0 |
| 2009-08-06 | JB | Futures | 115.85 | 115.97 | 115.77 | 115.81 | 1327.0 |
| 2009-08-06 | KC | Futures | 358.71 | 365.63 | 356.81 | 365.5 | 9345.0 |
| 2009-08-06 | KE | Futures | 2683.56 | 2687.16 | 2561.25 | 2561.25 | 10366.0 |
| 2009-08-06 | L | Futures | 97.367 | 97.475 | 97.367 | 97.435 | 102036.0 |
| 2009-08-06 | LBS | Futures | 828.1 | 850.4 | 821.2 | 833.0 | 398.0 |
> showing 50 of 86 rows — these rows as CSV