PREVIEW / futures_daily / 2021-11-12
file: by_date/futures_daily/2021/2021-11-12.parquet size: 10 KB rows: 121
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-12 | ES | Futures | 5227.37 | 5270.68 | 5223.72 | 5262.52 | 1155591.0 |
| 2021-11-12 | NQ | Futures | 18500.78 | 18696.24 | 18452.35 | 18672.6 | 422493.0 |
| 2021-11-12 | YM | Futures | 39027.7 | 39236.6 | 38994.0 | 39183.3 | 126135.0 |
| 2021-11-12 | CL | Futures | 60.17 | 60.48 | 59.11 | 59.86 | 390304.0 |
| 2021-11-12 | GC | Futures | 2175.0 | 2183.3 | 2155.4 | 2179.9 | 201358.0 |
| 2021-11-12 | ZN | Futures | 132.573749 | 133.034571 | 132.526078 | 132.748544 | 1363018.0 |
| 2021-11-12 | A6 | Futures | 0.74742 | 0.75203 | 0.74598 | 0.75152 | 72729.0 |
| 2021-11-12 | AD | Futures | 0.80643 | 0.80943 | 0.80537 | 0.80872 | 65927.0 |
| 2021-11-12 | ALI | Futures | 2951.37 | 3005.85 | 2951.37 | 2973.61 | 30.0 |
| 2021-11-12 | B | Futures | 56.62 | 56.65 | 55.55 | 56.17 | 289298.0 |
| 2021-11-12 | B6 | Futures | 1.3568 | 1.3629 | 1.3554 | 1.3618 | 102352.0 |
| 2021-11-12 | BR | Futures | 0.15052 | 0.1508 | 0.14808 | 0.14837 | 11620.0 |
| 2021-11-12 | BTC | Futures | 86153.9 | 86575.4 | 82182.1 | 84619.2 | 6895.0 |
| 2021-11-12 | BZ | Futures | 55.19 | 55.32 | 54.25 | 54.85 | 27167.0 |
| 2021-11-12 | C | Futures | 1463.0 | 1465.0 | 1440.0 | 1448.0 | 2232.0 |
| 2021-11-12 | CB | Futures | 153.619 | 153.619 | 152.871 | 153.068 | 10.0 |
| 2021-11-12 | CC | Futures | 1595.0 | 1595.0 | 1579.0 | 1589.0 | 17369.0 |
| 2021-11-12 | CNH | Futures | 6.1347 | 6.1347 | 6.1136 | 6.1232 | 1192.0 |
| 2021-11-12 | CSC | Futures | 2.424 | 2.424 | 2.354 | 2.368 | 97.0 |
| 2021-11-12 | CT | Futures | 110.74 | 110.98 | 108.76 | 109.84 | 23517.0 |
| 2021-11-12 | DC | Futures | 23.39 | 23.53 | 22.48 | 22.72 | 463.0 |
| 2021-11-12 | DX | Futures | 91.999 | 92.052 | 91.786 | 91.915 | 13252.0 |
| 2021-11-12 | E1 | Futures | 1.21642 | 1.21799 | 1.21328 | 1.21732 | 19780.0 |
| 2021-11-12 | E6 | Futures | 1.21727 | 1.2185 | 1.21536 | 1.21653 | 134180.0 |
| 2021-11-12 | E7 | Futures | 1.2104 | 1.2119 | 1.2087 | 1.2099 | 3628.0 |
| 2021-11-12 | EBM | Futures | 439.04 | 439.77 | 432.79 | 436.83 | 24654.0 |
| 2021-11-12 | ED | Futures | 96.5199 | 96.5296 | 96.515 | 96.5199 | 181915.0 |
| 2021-11-12 | ER | Futures | 98.499 | 98.499 | 98.489 | 98.499 | 103907.0 |
| 2021-11-12 | ESG | Futures | 437.83 | 440.54 | 437.22 | 440.13 | 224.0 |
| 2021-11-12 | EW | Futures | 3111.3 | 3124.4 | 3107.8 | 3120.5 | 8715.0 |
| 2021-11-12 | FBON | Futures | 148.99 | 149.09 | 148.37 | 148.94 | 190.0 |
| 2021-11-12 | FBTP | Futures | 138.16 | 138.25 | 137.29 | 138.04 | 159793.0 |
| 2021-11-12 | FBTS | Futures | 110.283 | 110.332 | 110.177 | 110.312 | 82895.0 |
| 2021-11-12 | FCE | Futures | 7138.9 | 7169.8 | 7126.2 | 7164.2 | 13506.0 |
| 2021-11-12 | FDAX | Futures | 17207.3 | 17229.8 | 17164.6 | 17203.1 | 42414.0 |
| 2021-11-12 | FDXM | Futures | 17252.0 | 17279.9 | 17213.4 | 17252.0 | 24348.0 |
| 2021-11-12 | FDXS | Futures | 17075.9 | 17117.3 | 17052.5 | 17091.8 | 11754.0 |
| 2021-11-12 | FESX | Futures | 4171.0 | 4181.5 | 4160.9 | 4180.6 | 456079.0 |
| 2021-11-12 | FGBL | Futures | 167.98 | 168.54 | 167.8 | 168.33 | 679367.0 |
| 2021-11-12 | FGBM | Futures | 134.45 | 134.88 | 134.44 | 134.79 | 457849.0 |
| 2021-11-12 | FGBS | Futures | 112.699 | 112.805 | 112.699 | 112.805 | 325176.0 |
| 2021-11-12 | FGBX | Futures | 229.73 | 230.38 | 229.06 | 229.67 | 72750.0 |
| 2021-11-12 | FMWO | Futures | 11402.9 | 11469.0 | 11388.8 | 11453.6 | 5832.0 |
| 2021-11-12 | FOAT | Futures | 155.41 | 155.87 | 155.17 | 155.71 | 158935.0 |
| 2021-11-12 | FTDX | Futures | 3980.1 | 4000.6 | 3977.5 | 4000.6 | 17.0 |
| 2021-11-12 | FTI | Futures | 776.7 | 782.76 | 775.41 | 782.26 | 889.0 |
| 2021-11-12 | FTUK | Futures | 7295.2 | 7297.6 | 7234.4 | 7244.3 | 88941.0 |
| 2021-11-12 | FVSA | Futures | 62.21 | 62.69 | 60.31 | 60.47 | 22828.0 |
| 2021-11-12 | FXXP | Futures | 461.7 | 464.0 | 461.7 | 463.9 | 51834.0 |
| 2021-11-12 | G | Futures | 121.54 | 121.82 | 121.34 | 121.58 | 194761.0 |
> showing 50 of 121 rows — these rows as CSV