PREVIEW / futures_daily / 2010-03-24
file: by_date/futures_daily/2010/2010-03-24.parquet size: 9 KB rows: 91
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-24 | ES | Futures | 1138.6 | 1139.33 | 1130.57 | 1133.97 | 1992386.0 |
| 2010-03-24 | NQ | Futures | 2224.62 | 2225.76 | 2207.61 | 2213.85 | 232925.0 |
| 2010-03-24 | YM | Futures | 9952.9 | 9954.7 | 9893.2 | 9916.1 | 124163.0 |
| 2010-03-24 | CL | Futures | 190.87 | 191.01 | 186.9 | 188.6 | 307763.0 |
| 2010-03-24 | GC | Futures | 1512.3 | 1517.5 | 1488.4 | 1493.9 | 178057.0 |
| 2010-03-24 | ZN | Futures | 95.665015 | 95.741537 | 94.59371 | 94.759507 | 1676497.0 |
| 2010-03-24 | A6 | Futures | 0.74725 | 0.74783 | 0.73749 | 0.73897 | 100278.0 |
| 2010-03-24 | AD | Futures | 0.97126 | 0.97175 | 0.95991 | 0.96327 | 92498.0 |
| 2010-03-24 | B | Futures | 71.93 | 71.93 | 70.61 | 71.26 | 162918.0 |
| 2010-03-24 | B6 | Futures | 1.5613 | 1.5613 | 1.5424 | 1.5452 | 130114.0 |
| 2010-03-24 | BFX | Futures | 2989.0 | 2996.5 | 2967.4 | 2986.4 | 31.0 |
| 2010-03-24 | BR | Futures | 0.22431 | 0.22431 | 0.22431 | 0.22431 | 87.0 |
| 2010-03-24 | BZ | Futures | 74.71 | 75.18 | 74.34 | 74.93 | 29.0 |
| 2010-03-24 | C | Futures | 2219.0 | 2226.0 | 2183.0 | 2212.0 | 3546.0 |
| 2010-03-24 | CB | Futures | 74.024 | 74.024 | 74.024 | 74.024 | 10.0 |
| 2010-03-24 | CC | Futures | 2443.0 | 2443.0 | 2374.0 | 2398.0 | 7146.0 |
| 2010-03-24 | CT | Futures | 67.33 | 67.46 | 65.79 | 66.2 | 8497.0 |
| 2010-03-24 | DC | Futures | 22.16 | 22.57 | 22.13 | 22.54 | 291.0 |
| 2010-03-24 | DX | Futures | 82.27 | 83.41 | 82.209 | 83.203 | 29866.0 |
| 2010-03-24 | E1 | Futures | 1.24577 | 1.24749 | 1.2263 | 1.22866 | 61753.0 |
| 2010-03-24 | E6 | Futures | 1.59656 | 1.59715 | 1.57479 | 1.57787 | 413012.0 |
| 2010-03-24 | E7 | Futures | 1.5834 | 1.5838 | 1.562 | 1.5649 | 6828.0 |
| 2010-03-24 | EBM | Futures | 205.22 | 205.63 | 203.98 | 205.22 | 8529.0 |
| 2010-03-24 | ED | Futures | 94.3802 | 94.3897 | 94.3708 | 94.3755 | 208528.0 |
| 2010-03-24 | ER | Futures | 97.394 | 97.399 | 97.384 | 97.394 | 114289.0 |
| 2010-03-24 | EW | Futures | 776.4 | 777.3 | 770.2 | 771.6 | 24414.0 |
| 2010-03-24 | FBTP | Futures | 64.53 | 64.63 | 64.43 | 64.52 | 6209.0 |
| 2010-03-24 | FCE | Futures | 2534.5 | 2538.7 | 2500.3 | 2528.5 | 154966.0 |
| 2010-03-24 | FDAX | Futures | 6568.1 | 6586.1 | 6494.2 | 6577.4 | 175599.0 |
| 2010-03-24 | FESX | Futures | 1741.7 | 1745.3 | 1712.9 | 1734.9 | 1444486.0 |
| 2010-03-24 | FEU3 | Futures | 97.948 | 97.958 | 97.948 | 97.953 | 384.0 |
| 2010-03-24 | FGBL | Futures | 96.51 | 96.59 | 96.18 | 96.4 | 1102593.0 |
| 2010-03-24 | FGBM | Futures | 101.91 | 101.97 | 101.7 | 101.84 | 686047.0 |
| 2010-03-24 | FGBS | Futures | 106.346 | 106.39 | 106.307 | 106.366 | 612240.0 |
| 2010-03-24 | FGBX | Futures | 91.26 | 91.48 | 90.81 | 91.12 | 3124.0 |
| 2010-03-24 | FTDX | Futures | 726.1 | 731.8 | 724.3 | 728.7 | 634.0 |
| 2010-03-24 | FTI | Futures | 276.07 | 276.55 | 272.94 | 275.38 | 32414.0 |
| 2010-03-24 | FTUK | Futures | 3820.1 | 3824.8 | 3782.2 | 3815.4 | 118407.0 |
| 2010-03-24 | G | Futures | 76.9 | 76.99 | 76.25 | 76.54 | 128033.0 |
| 2010-03-24 | GF | Futures | 279.337 | 282.991 | 279.272 | 281.882 | 1683.0 |
| 2010-03-24 | GSCI | Futures | 950.3 | 953.7 | 946.25 | 951.4 | 168.0 |
| 2010-03-24 | HE | Futures | 95.931 | 96.267 | 95.046 | 95.687 | 215.0 |
| 2010-03-24 | HG | Futures | 4.6111 | 4.6282 | 4.5373 | 4.5708 | 24150.0 |
| 2010-03-24 | HO | Futures | 1.9299 | 1.9299 | 1.9003 | 1.9116 | 15208.0 |
| 2010-03-24 | HRC | Futures | 3037.7 | 3037.7 | 3037.7 | 3037.7 | 62.0 |
| 2010-03-24 | J1 | Futures | 0.013907 | 0.0139234 | 0.0136128 | 0.0136581 | 182041.0 |
| 2010-03-24 | J7 | Futures | 0.013802 | 0.013811 | 0.013509 | 0.013549 | 296.0 |
| 2010-03-24 | JB | Futures | 118.04 | 118.1 | 117.93 | 118.05 | 1464.0 |
| 2010-03-24 | KC | Futures | 345.31 | 347.23 | 342.35 | 344.92 | 7845.0 |
| 2010-03-24 | KE | Futures | 2150.27 | 2162.46 | 2132.55 | 2150.27 | 4991.0 |
> showing 50 of 91 rows — these rows as CSV