PREVIEW / futures_daily / 2022-10-19
file: by_date/futures_daily/2022/2022-10-19.parquet size: 10 KB rows: 124
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 |
|---|---|---|---|---|---|---|---|
| 2022-10-19 | ES | Futures | 4190.53 | 4206.69 | 4098.02 | 4132.02 | 2348844.0 |
| 2022-10-19 | NQ | Futures | 12828.67 | 12899.5 | 12521.28 | 12639.42 | 733776.0 |
| 2022-10-19 | YM | Futures | 33418.3 | 33534.7 | 32921.0 | 33145.2 | 183779.0 |
| 2022-10-19 | CL | Futures | 71.64 | 73.47 | 70.61 | 73.03 | 357715.0 |
| 2022-10-19 | GC | Futures | 1896.5 | 1899.5 | 1867.9 | 1870.2 | 179246.0 |
| 2022-10-19 | ZN | Futures | 114.017498 | 114.097872 | 113.053019 | 113.165542 | 1487367.0 |
| 2022-10-19 | A6 | Futures | 0.6464 | 0.64799 | 0.64042 | 0.64164 | 72090.0 |
| 2022-10-19 | AD | Futures | 0.7383 | 0.73947 | 0.73445 | 0.73612 | 82733.0 |
| 2022-10-19 | ALI | Futures | 2485.46 | 2495.64 | 2457.76 | 2478.96 | 724.0 |
| 2022-10-19 | B | Futures | 77.86 | 79.62 | 76.6 | 79.25 | 272350.0 |
| 2022-10-19 | B6 | Futures | 1.1446 | 1.1481 | 1.1305 | 1.1326 | 106685.0 |
| 2022-10-19 | BR | Futures | 0.16573 | 0.16591 | 0.16481 | 0.16534 | 146.0 |
| 2022-10-19 | BTC | Futures | 26802.2 | 26920.5 | 26496.0 | 26725.6 | 5612.0 |
| 2022-10-19 | BZ | Futures | 76.27 | 78.0 | 75.09 | 77.64 | 43364.0 |
| 2022-10-19 | C | Futures | 1376.0 | 1389.0 | 1368.0 | 1387.0 | 7333.0 |
| 2022-10-19 | CB | Futures | 240.878 | 241.791 | 240.878 | 240.878 | 4.0 |
| 2022-10-19 | CC | Futures | 1349.0 | 1354.0 | 1332.0 | 1351.0 | 28388.0 |
| 2022-10-19 | CNH | Futures | 6.806 | 6.8493 | 6.793 | 6.8468 | 1966.0 |
| 2022-10-19 | CSC | Futures | 2.465 | 2.505 | 2.461 | 2.497 | 188.0 |
| 2022-10-19 | CT | Futures | 106.95 | 108.38 | 101.39 | 101.39 | 25444.0 |
| 2022-10-19 | DC | Futures | 23.7 | 24.33 | 23.61 | 24.19 | 307.0 |
| 2022-10-19 | DX | Futures | 108.492 | 109.637 | 108.458 | 109.525 | 34230.0 |
| 2022-10-19 | E1 | Futures | 1.10927 | 1.11074 | 1.09578 | 1.0965 | 20359.0 |
| 2022-10-19 | E6 | Futures | 1.03077 | 1.03197 | 1.01995 | 1.02088 | 196749.0 |
| 2022-10-19 | E7 | Futures | 1.0291 | 1.0301 | 1.0182 | 1.0192 | 5603.0 |
| 2022-10-19 | EBM | Futures | 476.64 | 483.73 | 475.22 | 476.64 | 28618.0 |
| 2022-10-19 | ED | Futures | 94.0623 | 94.0673 | 94.0029 | 94.0078 | 153476.0 |
| 2022-10-19 | ER | Futures | 97.671 | 97.691 | 97.646 | 97.666 | 118682.0 |
| 2022-10-19 | ESG | Futures | 359.11 | 359.77 | 352.9 | 355.62 | 703.0 |
| 2022-10-19 | EW | Futures | 2549.7 | 2559.6 | 2469.6 | 2495.2 | 13104.0 |
| 2022-10-19 | FBON | Futures | 120.12 | 120.19 | 119.32 | 119.52 | 100.0 |
| 2022-10-19 | FBTP | Futures | 104.74 | 104.82 | 103.75 | 104.14 | 113566.0 |
| 2022-10-19 | FBTS | Futures | 105.15 | 105.16 | 104.831 | 104.94 | 90565.0 |
| 2022-10-19 | FCE | Futures | 6665.3 | 6669.7 | 6555.1 | 6593.3 | 46309.0 |
| 2022-10-19 | FDAX | Futures | 14066.8 | 14151.9 | 13848.5 | 13942.3 | 60374.0 |
| 2022-10-19 | FDXM | Futures | 13855.5 | 13942.6 | 13642.6 | 13735.1 | 43939.0 |
| 2022-10-19 | FDXS | Futures | 13767.4 | 13875.4 | 13575.8 | 13666.8 | 26176.0 |
| 2022-10-19 | FESX | Futures | 3449.8 | 3466.6 | 3409.2 | 3435.0 | 823806.0 |
| 2022-10-19 | FGBL | Futures | 136.99 | 137.07 | 135.39 | 135.89 | 759337.0 |
| 2022-10-19 | FGBM | Futures | 120.98 | 121.01 | 120.12 | 120.28 | 505270.0 |
| 2022-10-19 | FGBS | Futures | 109.111 | 109.126 | 108.82 | 108.891 | 618713.0 |
| 2022-10-19 | FGBX | Futures | 144.27 | 144.27 | 140.93 | 142.47 | 71846.0 |
| 2022-10-19 | FMWO | Futures | 8849.5 | 8855.3 | 8638.1 | 8731.0 | 5694.0 |
| 2022-10-19 | FOAT | Futures | 126.37 | 126.44 | 124.81 | 125.27 | 138453.0 |
| 2022-10-19 | FSMX | Futures | 24786.5 | 24786.5 | 24128.8 | 24322.3 | 365.0 |
| 2022-10-19 | FTDX | Futures | 2971.5 | 2976.3 | 2884.7 | 2899.1 | 143.0 |
| 2022-10-19 | FTI | Futures | 657.47 | 659.61 | 650.65 | 655.06 | 17275.0 |
| 2022-10-19 | FTUK | Futures | 7042.9 | 7066.6 | 6956.1 | 6995.4 | 84254.0 |
| 2022-10-19 | FVSA | Futures | 66.79 | 69.0 | 66.45 | 67.6 | 32121.0 |
| 2022-10-19 | FXXP | Futures | 397.1 | 397.8 | 390.8 | 393.5 | 74505.0 |
> showing 50 of 124 rows — these rows as CSV