PREVIEW / futures_daily / 2020-12-24
file: by_date/futures_daily/2020/2020-12-24.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-24 | ES | Futures | 4130.44 | 4142.48 | 4122.87 | 4141.36 | 369650.0 |
| 2020-12-24 | NQ | Futures | 14603.15 | 14676.1 | 14569.41 | 14653.61 | 173464.0 |
| 2020-12-24 | YM | Futures | 32487.2 | 32560.7 | 32394.4 | 32515.3 | 51433.0 |
| 2020-12-24 | CL | Futures | 33.95 | 34.32 | 33.58 | 34.05 | 167390.0 |
| 2020-12-24 | GC | Futures | 2208.1 | 2219.9 | 2203.1 | 2215.0 | 89405.0 |
| 2020-12-24 | ZN | Futures | 137.056068 | 137.195937 | 136.993904 | 137.133773 | 256470.0 |
| 2020-12-24 | A6 | Futures | 0.77787 | 0.78095 | 0.77751 | 0.78054 | 49796.0 |
| 2020-12-24 | AD | Futures | 0.78872 | 0.7909 | 0.78841 | 0.7908 | 26930.0 |
| 2020-12-24 | ALI | Futures | 2368.62 | 2368.62 | 2368.62 | 2368.62 | 0.0 |
| 2020-12-24 | B | Futures | 32.3 | 32.71 | 31.99 | 32.41 | 96688.0 |
| 2020-12-24 | B6 | Futures | 1.3728 | 1.3845 | 1.3722 | 1.3762 | 65288.0 |
| 2020-12-24 | BR | Futures | 0.15004 | 0.15086 | 0.15004 | 0.15086 | 12.0 |
| 2020-12-24 | BTC | Futures | 30627.5 | 30946.2 | 29860.2 | 30803.1 | 4309.0 |
| 2020-12-24 | BZ | Futures | 31.58 | 31.99 | 31.3 | 31.7 | 11666.0 |
| 2020-12-24 | C | Futures | 1452.0 | 1456.0 | 1440.0 | 1443.0 | 1301.0 |
| 2020-12-24 | CB | Futures | 152.268 | 153.191 | 152.268 | 153.168 | 34.0 |
| 2020-12-24 | CC | Futures | 1683.0 | 1709.0 | 1664.0 | 1704.0 | 6074.0 |
| 2020-12-24 | CNH | Futures | 6.408 | 6.408 | 6.3843 | 6.391 | 626.0 |
| 2020-12-24 | CSC | Futures | 3.122 | 3.148 | 3.117 | 3.148 | 65.0 |
| 2020-12-24 | CT | Futures | 73.48 | 74.0 | 73.34 | 73.62 | 5143.0 |
| 2020-12-24 | DC | Futures | 26.79 | 26.79 | 26.28 | 26.79 | 373.0 |
| 2020-12-24 | DX | Futures | 87.195 | 87.316 | 87.089 | 87.258 | 10826.0 |
| 2020-12-24 | E1 | Futures | 1.27443 | 1.27612 | 1.26879 | 1.26924 | 8357.0 |
| 2020-12-24 | E6 | Futures | 1.30447 | 1.30725 | 1.30314 | 1.30378 | 56166.0 |
| 2020-12-24 | E7 | Futures | 1.298 | 1.3007 | 1.2967 | 1.2973 | 3135.0 |
| 2020-12-24 | EBM | Futures | 260.69 | 261.31 | 259.77 | 261.0 | 4434.0 |
| 2020-12-24 | ED | Futures | 96.5131 | 96.5325 | 96.5131 | 96.5228 | 130532.0 |
| 2020-12-24 | ER | Futures | 98.45 | 98.455 | 98.445 | 98.455 | 12639.0 |
| 2020-12-24 | ESG | Futures | 341.27 | 342.12 | 341.27 | 342.12 | 1289.0 |
| 2020-12-24 | EW | Futures | 2472.9 | 2482.4 | 2459.0 | 2474.0 | 6034.0 |
| 2020-12-24 | FCE | Futures | 5388.8 | 5392.7 | 5352.8 | 5358.2 | 8977.0 |
| 2020-12-24 | FTI | Futures | 582.95 | 585.2 | 581.74 | 584.77 | 3535.0 |
| 2020-12-24 | FTUK | Futures | 6208.6 | 6249.1 | 6190.3 | 6216.3 | 29940.0 |
| 2020-12-24 | G | Futures | 125.86 | 126.67 | 125.86 | 126.62 | 59404.0 |
| 2020-12-24 | GF | Futures | 274.101 | 275.321 | 273.76 | 275.028 | 1039.0 |
| 2020-12-24 | GSCI | Futures | 372.31 | 373.33 | 372.31 | 373.33 | 12.0 |
| 2020-12-24 | HE | Futures | 51.678 | 51.907 | 50.971 | 51.181 | 8618.0 |
| 2020-12-24 | HG | Futures | 3.9137 | 3.9441 | 3.8972 | 3.932 | 31650.0 |
| 2020-12-24 | HH | Futures | 8.177 | 8.424 | 8.061 | 8.074 | 5175.0 |
| 2020-12-24 | HO | Futures | 0.8116 | 0.8176 | 0.8017 | 0.808 | 14395.0 |
| 2020-12-24 | HRC | Futures | 1655.3 | 1655.3 | 1655.3 | 1655.3 | 0.0 |
| 2020-12-24 | J1 | Futures | 0.0111405 | 0.0111423 | 0.0111129 | 0.0111244 | 46734.0 |
| 2020-12-24 | J7 | Futures | 0.011115 | 0.011118 | 0.011085 | 0.011102 | 300.0 |
| 2020-12-24 | JB | Futures | 139.55 | 139.61 | 139.47 | 139.56 | 169.0 |
| 2020-12-24 | KC | Futures | 111.27 | 114.08 | 111.27 | 112.57 | 8991.0 |
| 2020-12-24 | KE | Futures | 742.21 | 746.63 | 738.42 | 743.47 | 7066.0 |
| 2020-12-24 | KRW | Futures | 0.0008876 | 0.0008882 | 0.0008873 | 0.0008873 | 3.0 |
| 2020-12-24 | LBS | Futures | 1877.4 | 1921.1 | 1877.4 | 1894.1 | 139.0 |
| 2020-12-24 | LE | Futures | 147.422 | 147.904 | 147.069 | 147.711 | 8397.0 |
| 2020-12-24 | M2K | Futures | 2207.9 | 2219.7 | 2194.0 | 2205.2 | 35592.0 |
> showing 50 of 102 rows — these rows as CSV