PREVIEW / futures_daily / 2009-08-28
file: by_date/futures_daily/2009/2009-08-28.parquet size: 8 KB rows: 85
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-28 | ES | Futures | 987.5 | 996.62 | 980.55 | 985.82 | 1570206.0 |
| 2009-08-28 | NQ | Futures | 1845.78 | 1879.0 | 1836.21 | 1849.72 | 304044.0 |
| 2009-08-28 | YM | Futures | 8633.6 | 8695.9 | 8557.8 | 8603.9 | 136892.0 |
| 2009-08-28 | CL | Futures | 181.79 | 183.44 | 179.09 | 181.49 | 239217.0 |
| 2009-08-28 | GC | Futures | 1312.6 | 1333.5 | 1312.6 | 1325.5 | 87231.0 |
| 2009-08-28 | ZN | Futures | 92.923542 | 93.132857 | 92.54185 | 93.009731 | 839546.0 |
| 2009-08-28 | A6 | Futures | 0.67352 | 0.68011 | 0.67264 | 0.67505 | 82325.0 |
| 2009-08-28 | AD | Futures | 0.9082 | 0.91531 | 0.90297 | 0.90366 | 60106.0 |
| 2009-08-28 | B | Futures | 69.05 | 69.86 | 68.51 | 69.35 | 40821.0 |
| 2009-08-28 | B6 | Futures | 1.6949 | 1.7064 | 1.6932 | 1.6945 | 90629.0 |
| 2009-08-28 | BFX | Futures | 2717.2 | 2733.4 | 2712.0 | 2721.7 | 131.0 |
| 2009-08-28 | BR | Futures | 0.21029 | 0.21029 | 0.20794 | 0.20854 | 29.0 |
| 2009-08-28 | BZ | Futures | 72.76 | 72.76 | 72.18 | 72.18 | 2.0 |
| 2009-08-28 | C | Futures | 1943.0 | 1944.0 | 1892.0 | 1907.0 | 1193.0 |
| 2009-08-28 | CC | Futures | 2492.0 | 2510.0 | 2435.0 | 2456.0 | 4715.0 |
| 2009-08-28 | CT | Futures | 49.14 | 49.83 | 49.09 | 49.8 | 82.0 |
| 2009-08-28 | DC | Futures | 22.42 | 22.56 | 22.24 | 22.41 | 72.0 |
| 2009-08-28 | DX | Futures | 79.923 | 80.281 | 79.744 | 80.23 | 3943.0 |
| 2009-08-28 | E1 | Futures | 1.25098 | 1.25641 | 1.24688 | 1.2482 | 29934.0 |
| 2009-08-28 | E6 | Futures | 1.70313 | 1.70824 | 1.6953 | 1.69601 | 176381.0 |
| 2009-08-28 | E7 | Futures | 1.6864 | 1.6905 | 1.6778 | 1.6786 | 1912.0 |
| 2009-08-28 | ED | Futures | 94.0982 | 94.1195 | 94.0912 | 94.11 | 102973.0 |
| 2009-08-28 | ER | Futures | 97.179 | 97.184 | 97.169 | 97.179 | 72105.0 |
| 2009-08-28 | EW | Futures | 638.6 | 647.6 | 634.9 | 640.2 | 28419.0 |
| 2009-08-28 | FCE | Futures | 2400.3 | 2439.6 | 2400.0 | 2419.3 | 125624.0 |
| 2009-08-28 | FDAX | Futures | 6041.6 | 6117.8 | 6026.8 | 6052.0 | 111947.0 |
| 2009-08-28 | FESX | Futures | 1666.5 | 1690.4 | 1665.3 | 1673.1 | 916176.0 |
| 2009-08-28 | FEU3 | Futures | 97.756 | 97.756 | 97.751 | 97.756 | 36.0 |
| 2009-08-28 | FGBL | Futures | 93.16 | 93.37 | 92.87 | 93.21 | 500754.0 |
| 2009-08-28 | FGBM | Futures | 98.57 | 98.64 | 98.38 | 98.56 | 260309.0 |
| 2009-08-28 | FGBS | Futures | 104.301 | 104.301 | 104.21 | 104.277 | 429336.0 |
| 2009-08-28 | FGBX | Futures | 86.53 | 86.72 | 86.02 | 86.58 | 1868.0 |
| 2009-08-28 | FTDX | Futures | 629.0 | 635.3 | 625.5 | 630.4 | 411.0 |
| 2009-08-28 | FTI | Futures | 246.82 | 250.08 | 246.41 | 247.89 | 33595.0 |
| 2009-08-28 | FTUK | Futures | 3260.0 | 3279.5 | 3241.7 | 3264.6 | 108318.0 |
| 2009-08-28 | G | Futures | 76.76 | 77.04 | 76.54 | 76.9 | 52537.0 |
| 2009-08-28 | GF | Futures | 273.546 | 274.444 | 271.058 | 271.334 | 514.0 |
| 2009-08-28 | GSCI | Futures | 953.87 | 957.74 | 943.48 | 950.2 | 697.0 |
| 2009-08-28 | HE | Futures | 72.775 | 74.237 | 71.576 | 72.063 | 9619.0 |
| 2009-08-28 | HG | Futures | 4.0224 | 4.1659 | 4.0217 | 4.1116 | 18600.0 |
| 2009-08-28 | HO | Futures | 1.8829 | 1.91 | 1.8669 | 1.8851 | 6644.0 |
| 2009-08-28 | HRC | Futures | 2662.6 | 2662.6 | 2662.6 | 2662.6 | 0.0 |
| 2009-08-28 | J1 | Futures | 0.0134691 | 0.0134779 | 0.0133798 | 0.0134503 | 68749.0 |
| 2009-08-28 | J7 | Futures | 0.013248 | 0.013287 | 0.013202 | 0.013265 | 29.0 |
| 2009-08-28 | JB | Futures | 117.11 | 117.19 | 116.86 | 117.09 | 3465.0 |
| 2009-08-28 | KC | Futures | 322.04 | 326.27 | 321.25 | 322.84 | 5035.0 |
| 2009-08-28 | KE | Futures | 2438.19 | 2467.28 | 2384.68 | 2404.46 | 11223.0 |
| 2009-08-28 | L | Futures | 97.651 | 97.661 | 97.622 | 97.651 | 36114.0 |
| 2009-08-28 | LBS | Futures | 729.5 | 731.5 | 692.5 | 698.6 | 703.0 |
| 2009-08-28 | LE | Futures | 146.097 | 146.721 | 144.182 | 144.349 | 20632.0 |
> showing 50 of 85 rows — these rows as CSV