PREVIEW / futures_daily / 2022-07-22
file: by_date/futures_daily/2022/2022-07-22.parquet size: 10 KB rows: 127
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-07-22 | ES | Futures | 4473.77 | 4505.46 | 4421.6 | 4447.97 | 1736592.0 |
| 2022-07-22 | NQ | Futures | 14340.96 | 14499.97 | 14094.89 | 14185.96 | 634548.0 |
| 2022-07-22 | YM | Futures | 34967.9 | 35198.6 | 34664.0 | 34851.0 | 155954.0 |
| 2022-07-22 | CL | Futures | 81.83 | 83.05 | 79.89 | 80.29 | 307568.0 |
| 2022-07-22 | GC | Futures | 1984.4 | 2008.8 | 1978.0 | 1996.2 | 200622.0 |
| 2022-07-22 | ZN | Futures | 122.487205 | 123.740353 | 122.294413 | 123.274439 | 1799046.0 |
| 2022-07-22 | A6 | Futures | 0.7107 | 0.71531 | 0.70665 | 0.70865 | 92845.0 |
| 2022-07-22 | AD | Futures | 0.7881 | 0.79089 | 0.7844 | 0.78481 | 92986.0 |
| 2022-07-22 | ALI | Futures | 2744.38 | 2790.5 | 2743.81 | 2784.03 | 668.0 |
| 2022-07-22 | B | Futures | 83.54 | 85.03 | 81.96 | 83.0 | 137242.0 |
| 2022-07-22 | B6 | Futures | 1.2192 | 1.2258 | 1.2106 | 1.217 | 125643.0 |
| 2022-07-22 | BR | Futures | 0.15635 | 0.15809 | 0.156 | 0.15635 | 1646.0 |
| 2022-07-22 | BTC | Futures | 32352.0 | 33174.4 | 31418.1 | 31522.7 | 6639.0 |
| 2022-07-22 | BZ | Futures | 81.87 | 83.0 | 80.04 | 81.05 | 17586.0 |
| 2022-07-22 | C | Futures | 1281.0 | 1291.0 | 1271.0 | 1273.0 | 5015.0 |
| 2022-07-22 | CB | Futures | 216.757 | 218.772 | 216.757 | 217.563 | 42.0 |
| 2022-07-22 | CC | Futures | 1374.0 | 1387.0 | 1367.0 | 1373.0 | 16258.0 |
| 2022-07-22 | CNH | Futures | 6.3888 | 6.3952 | 6.3639 | 6.3746 | 495.0 |
| 2022-07-22 | CSC | Futures | 2.733 | 2.733 | 2.706 | 2.724 | 70.0 |
| 2022-07-22 | CT | Futures | 127.02 | 127.2 | 125.83 | 126.06 | 8.0 |
| 2022-07-22 | DC | Futures | 25.83 | 25.9 | 25.51 | 25.62 | 341.0 |
| 2022-07-22 | DX | Futures | 102.76 | 103.459 | 102.244 | 102.853 | 39753.0 |
| 2022-07-22 | E1 | Futures | 1.14886 | 1.15682 | 1.14433 | 1.15235 | 29894.0 |
| 2022-07-22 | E6 | Futures | 1.08003 | 1.08298 | 1.06967 | 1.07661 | 232002.0 |
| 2022-07-22 | E7 | Futures | 1.0734 | 1.0765 | 1.0634 | 1.0702 | 8737.0 |
| 2022-07-22 | EBM | Futures | 477.43 | 477.43 | 455.69 | 456.74 | 26064.0 |
| 2022-07-22 | ED | Futures | 94.8874 | 95.0201 | 94.8727 | 94.9562 | 120782.0 |
| 2022-07-22 | ER | Futures | 98.065 | 98.213 | 98.065 | 98.173 | 174453.0 |
| 2022-07-22 | ESG | Futures | 386.38 | 388.19 | 381.28 | 383.32 | 461.0 |
| 2022-07-22 | EW | Futures | 2632.0 | 2650.9 | 2592.7 | 2609.7 | 11306.0 |
| 2022-07-22 | FBON | Futures | 129.46 | 131.62 | 128.95 | 131.18 | 114.0 |
| 2022-07-22 | FBTP | Futures | 113.13 | 115.3 | 112.46 | 114.69 | 155618.0 |
| 2022-07-22 | FBTS | Futures | 106.222 | 107.059 | 106.065 | 106.902 | 111200.0 |
| 2022-07-22 | FCE | Futures | 6769.0 | 6856.9 | 6763.0 | 6821.2 | 51316.0 |
| 2022-07-22 | FDAX | Futures | 14203.0 | 14376.2 | 14142.7 | 14272.9 | 55223.0 |
| 2022-07-22 | FDIV | Futures | 157.44 | 157.44 | 157.04 | 157.19 | 12.0 |
| 2022-07-22 | FDXM | Futures | 14304.9 | 14464.1 | 14229.1 | 14360.1 | 29078.0 |
| 2022-07-22 | FDXS | Futures | 14169.1 | 14346.3 | 14114.3 | 14243.2 | 27239.0 |
| 2022-07-22 | FESX | Futures | 3550.8 | 3591.5 | 3531.9 | 3567.6 | 789947.0 |
| 2022-07-22 | FEU3 | Futures | 98.14 | 98.14 | 98.13 | 98.13 | 20.0 |
| 2022-07-22 | FGBL | Futures | 150.33 | 153.13 | 150.14 | 152.44 | 796397.0 |
| 2022-07-22 | FGBM | Futures | 127.04 | 128.73 | 127.0 | 128.4 | 590476.0 |
| 2022-07-22 | FGBS | Futures | 111.171 | 111.74 | 111.146 | 111.618 | 663581.0 |
| 2022-07-22 | FGBX | Futures | 176.98 | 181.8 | 175.88 | 180.27 | 62269.0 |
| 2022-07-22 | FMWO | Futures | 9506.3 | 9597.7 | 9430.2 | 9536.8 | 6206.0 |
| 2022-07-22 | FOAT | Futures | 137.87 | 140.29 | 137.56 | 139.65 | 184958.0 |
| 2022-07-22 | FSMX | Futures | 28386.2 | 28913.3 | 28360.6 | 28592.6 | 594.0 |
| 2022-07-22 | FTDX | Futures | 3236.2 | 3290.3 | 3236.2 | 3265.1 | 19.0 |
| 2022-07-22 | FTI | Futures | 708.29 | 716.35 | 704.69 | 710.26 | 20198.0 |
| 2022-07-22 | FTUK | Futures | 7322.0 | 7366.6 | 7279.5 | 7334.2 | 85773.0 |
> showing 50 of 127 rows — these rows as CSV