PREVIEW / futures_daily / 2022-10-31
file: by_date/futures_daily/2022/2022-10-31.parquet size: 10 KB rows: 126
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-31 | ES | Futures | 4359.67 | 4363.29 | 4315.92 | 4327.91 | 2002625.0 |
| 2022-10-31 | NQ | Futures | 13137.2 | 13140.03 | 12881.93 | 12972.59 | 607680.0 |
| 2022-10-31 | YM | Futures | 35822.0 | 35844.9 | 35492.3 | 35664.2 | 201242.0 |
| 2022-10-31 | CL | Futures | 76.38 | 76.6 | 73.71 | 74.77 | 285342.0 |
| 2022-10-31 | GC | Futures | 1885.1 | 1886.6 | 1870.5 | 1877.6 | 128413.0 |
| 2022-10-31 | ZN | Futures | 114.097872 | 114.146096 | 113.551334 | 113.776379 | 1866622.0 |
| 2022-10-31 | A6 | Futures | 0.65642 | 0.65832 | 0.65218 | 0.65469 | 68582.0 |
| 2022-10-31 | AD | Futures | 0.74555 | 0.74616 | 0.74139 | 0.74454 | 77780.0 |
| 2022-10-31 | ALI | Futures | 2524.19 | 2539.17 | 2487.16 | 2520.8 | 1091.0 |
| 2022-10-31 | B | Futures | 82.63 | 82.67 | 80.03 | 81.21 | 304529.0 |
| 2022-10-31 | B6 | Futures | 1.1729 | 1.1739 | 1.1584 | 1.1595 | 103558.0 |
| 2022-10-31 | BR | Futures | 0.16323 | 0.16961 | 0.16059 | 0.16921 | 29772.0 |
| 2022-10-31 | BTC | Futures | 28405.3 | 28645.3 | 27726.5 | 27945.9 | 7208.0 |
| 2022-10-31 | BZ | Futures | 80.94 | 81.11 | 78.46 | 79.62 | 23096.0 |
| 2022-10-31 | C | Futures | 1358.0 | 1379.0 | 1353.0 | 1376.0 | 6801.0 |
| 2022-10-31 | CB | Futures | 240.582 | 240.65 | 232.667 | 232.667 | 66.0 |
| 2022-10-31 | CC | Futures | 1345.0 | 1379.0 | 1344.0 | 1367.0 | 27986.0 |
| 2022-10-31 | CNH | Futures | 6.8519 | 6.9106 | 6.85 | 6.9106 | 1680.0 |
| 2022-10-31 | CSC | Futures | 2.369 | 2.388 | 2.354 | 2.384 | 59.0 |
| 2022-10-31 | CT | Futures | 93.39 | 94.82 | 90.93 | 93.24 | 22708.0 |
| 2022-10-31 | DC | Futures | 22.78 | 23.15 | 22.67 | 22.97 | 344.0 |
| 2022-10-31 | DX | Futures | 107.386 | 108.221 | 107.299 | 108.109 | 24963.0 |
| 2022-10-31 | E1 | Futures | 1.10642 | 1.10685 | 1.09825 | 1.10044 | 19850.0 |
| 2022-10-31 | E6 | Futures | 1.0406 | 1.04076 | 1.03113 | 1.03269 | 165706.0 |
| 2022-10-31 | E7 | Futures | 1.0389 | 1.0394 | 1.0293 | 1.031 | 5258.0 |
| 2022-10-31 | EBM | Futures | 498.98 | 501.11 | 488.69 | 499.69 | 41944.0 |
| 2022-10-31 | ED | Futures | 94.0623 | 94.0623 | 94.0078 | 94.0227 | 91756.0 |
| 2022-10-31 | ER | Futures | 97.716 | 97.716 | 97.671 | 97.696 | 87302.0 |
| 2022-10-31 | ESG | Futures | 372.75 | 374.04 | 370.97 | 371.91 | 721.0 |
| 2022-10-31 | EW | Futures | 2638.6 | 2653.7 | 2620.3 | 2639.3 | 17701.0 |
| 2022-10-31 | FBON | Futures | 122.94 | 123.22 | 122.46 | 122.46 | 146.0 |
| 2022-10-31 | FBTP | Futures | 109.65 | 109.66 | 108.06 | 108.28 | 119672.0 |
| 2022-10-31 | FBTS | Futures | 106.058 | 106.068 | 105.809 | 105.859 | 88546.0 |
| 2022-10-31 | FCE | Futures | 6858.4 | 6870.4 | 6812.6 | 6838.8 | 48929.0 |
| 2022-10-31 | FDAX | Futures | 14562.4 | 14570.0 | 14446.7 | 14506.7 | 45006.0 |
| 2022-10-31 | FDIV | Futures | 157.49 | 157.83 | 157.19 | 157.83 | 36.0 |
| 2022-10-31 | FDXM | Futures | 14356.7 | 14356.7 | 14230.8 | 14291.1 | 38593.0 |
| 2022-10-31 | FDXS | Futures | 14263.9 | 14281.0 | 14160.1 | 14220.0 | 12182.0 |
| 2022-10-31 | FESX | Futures | 3595.3 | 3598.3 | 3567.6 | 3580.4 | 776791.0 |
| 2022-10-31 | FEU3 | Futures | 97.757 | 97.767 | 97.757 | 97.767 | 20.0 |
| 2022-10-31 | FGBL | Futures | 138.64 | 138.94 | 137.91 | 138.23 | 662652.0 |
| 2022-10-31 | FGBM | Futures | 121.5 | 121.68 | 121.18 | 121.46 | 454196.0 |
| 2022-10-31 | FGBS | Futures | 109.223 | 109.284 | 109.141 | 109.208 | 486900.0 |
| 2022-10-31 | FGBX | Futures | 149.48 | 150.3 | 146.8 | 147.46 | 72676.0 |
| 2022-10-31 | FMWO | Futures | 9161.9 | 9161.9 | 9081.8 | 9115.5 | 3294.0 |
| 2022-10-31 | FOAT | Futures | 128.72 | 129.08 | 127.81 | 128.12 | 166190.0 |
| 2022-10-31 | FSMX | Futures | 25217.9 | 25429.4 | 25055.1 | 25130.1 | 617.0 |
| 2022-10-31 | FTDX | Futures | 3042.8 | 3042.8 | 3029.0 | 3038.0 | 7.0 |
| 2022-10-31 | FTI | Futures | 679.76 | 683.37 | 677.16 | 680.71 | 15904.0 |
| 2022-10-31 | FTUK | Futures | 7122.0 | 7197.2 | 7090.3 | 7169.4 | 116063.0 |
> showing 50 of 126 rows — these rows as CSV