PREVIEW / futures_daily / 2010-03-19
file: by_date/futures_daily/2010/2010-03-19.parquet size: 9 KB rows: 90
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-19 | ES | Futures | 1130.81 | 1134.46 | 1120.1 | 1125.94 | 2165925.0 |
| 2010-03-19 | NQ | Futures | 2202.79 | 2210.16 | 2180.66 | 2192.01 | 295754.0 |
| 2010-03-19 | YM | Futures | 9851.8 | 9888.6 | 9773.7 | 9824.2 | 127256.0 |
| 2010-03-19 | CL | Futures | 192.93 | 192.96 | 187.51 | 189.45 | 327502.0 |
| 2010-03-19 | GC | Futures | 1544.6 | 1547.0 | 1510.6 | 1519.7 | 176491.0 |
| 2010-03-19 | ZN | Futures | 95.550233 | 95.71603 | 95.307914 | 95.473711 | 732150.0 |
| 2010-03-19 | A6 | Futures | 0.74799 | 0.74988 | 0.74209 | 0.74455 | 84728.0 |
| 2010-03-19 | AD | Futures | 0.97333 | 0.98103 | 0.96889 | 0.97175 | 85365.0 |
| 2010-03-19 | B | Futures | 72.87 | 72.87 | 70.88 | 71.49 | 163709.0 |
| 2010-03-19 | B6 | Futures | 1.582 | 1.5832 | 1.5555 | 1.5586 | 137104.0 |
| 2010-03-19 | BFX | Futures | 3003.1 | 3009.5 | 2936.5 | 2967.6 | 177.0 |
| 2010-03-19 | BR | Futures | 0.22443 | 0.22443 | 0.22443 | 0.22443 | 30.0 |
| 2010-03-19 | BZ | Futures | 76.08 | 76.57 | 74.57 | 75.18 | 96.0 |
| 2010-03-19 | C | Futures | 2226.0 | 2240.0 | 2189.0 | 2209.0 | 4943.0 |
| 2010-03-19 | CC | Futures | 2440.0 | 2466.0 | 2374.0 | 2399.0 | 5394.0 |
| 2010-03-19 | CT | Futures | 66.94 | 67.36 | 66.37 | 66.83 | 6437.0 |
| 2010-03-19 | DC | Futures | 22.25 | 22.66 | 22.25 | 22.48 | 137.0 |
| 2010-03-19 | DX | Futures | 81.56 | 82.219 | 81.515 | 82.057 | 27091.0 |
| 2010-03-19 | E1 | Futures | 1.24459 | 1.24972 | 1.23854 | 1.24314 | 46772.0 |
| 2010-03-19 | E6 | Futures | 1.60993 | 1.61217 | 1.59739 | 1.60129 | 286789.0 |
| 2010-03-19 | E7 | Futures | 1.5966 | 1.599 | 1.5844 | 1.5882 | 3531.0 |
| 2010-03-19 | EBM | Futures | 205.22 | 207.68 | 205.22 | 207.27 | 4767.0 |
| 2010-03-19 | ED | Futures | 94.366 | 94.3755 | 94.3329 | 94.3518 | 271142.0 |
| 2010-03-19 | ER | Futures | 97.365 | 97.37 | 97.34 | 97.345 | 137037.0 |
| 2010-03-19 | EW | Futures | 769.4 | 772.7 | 758.8 | 761.7 | 26116.0 |
| 2010-03-19 | FBTP | Futures | 64.32 | 64.32 | 64.23 | 64.28 | 4166.0 |
| 2010-03-19 | FCE | Futures | 2533.6 | 2536.5 | 2498.7 | 2513.4 | 127734.0 |
| 2010-03-19 | FDAX | Futures | 6576.3 | 6581.7 | 6484.9 | 6511.0 | 156001.0 |
| 2010-03-19 | FESX | Futures | 1752.7 | 1752.7 | 1721.4 | 1729.4 | 1324272.0 |
| 2010-03-19 | FEU3 | Futures | 97.919 | 97.929 | 97.904 | 97.904 | 1277.0 |
| 2010-03-19 | FGBL | Futures | 96.04 | 96.2 | 95.89 | 96.14 | 723182.0 |
| 2010-03-19 | FGBM | Futures | 101.71 | 101.8 | 101.55 | 101.7 | 445928.0 |
| 2010-03-19 | FGBS | Futures | 106.277 | 106.317 | 106.219 | 106.258 | 469433.0 |
| 2010-03-19 | FGBX | Futures | 90.25 | 90.45 | 89.92 | 90.34 | 3433.0 |
| 2010-03-19 | FTDX | Futures | 733.6 | 733.6 | 719.9 | 721.7 | 1310.0 |
| 2010-03-19 | FTI | Futures | 275.86 | 276.84 | 272.34 | 272.78 | 34606.0 |
| 2010-03-19 | FTUK | Futures | 3799.8 | 3823.8 | 3778.8 | 3791.3 | 170161.0 |
| 2010-03-19 | G | Futures | 76.53 | 76.85 | 76.49 | 76.68 | 79108.0 |
| 2010-03-19 | GF | Futures | 282.469 | 286.644 | 280.707 | 283.578 | 1417.0 |
| 2010-03-19 | GSCI | Futures | 969.8 | 973.85 | 954.34 | 960.6 | 371.0 |
| 2010-03-19 | HE | Futures | 96.663 | 97.884 | 96.663 | 97.518 | 305.0 |
| 2010-03-19 | HG | Futures | 4.6377 | 4.678 | 4.5858 | 4.6077 | 24594.0 |
| 2010-03-19 | HO | Futures | 1.9504 | 1.9522 | 1.8957 | 1.9172 | 19710.0 |
| 2010-03-19 | HRC | Futures | 3037.7 | 3037.7 | 3037.7 | 3037.7 | 0.0 |
| 2010-03-19 | J1 | Futures | 0.0139196 | 0.0139272 | 0.0138655 | 0.013902 | 76693.0 |
| 2010-03-19 | J7 | Futures | 0.013809 | 0.013814 | 0.013757 | 0.013791 | 33.0 |
| 2010-03-19 | JB | Futures | 117.81 | 117.87 | 117.66 | 117.87 | 1092.0 |
| 2010-03-19 | KC | Futures | 347.49 | 348.65 | 335.55 | 340.3 | 12948.0 |
| 2010-03-19 | KE | Futures | 2192.37 | 2200.13 | 2173.54 | 2180.18 | 5447.0 |
| 2010-03-19 | L | Futures | 97.848 | 97.868 | 97.838 | 97.848 | 31654.0 |
> showing 50 of 90 rows — these rows as CSV