PREVIEW / futures_daily / 2021-04-05
file: by_date/futures_daily/2021/2021-04-05.parquet size: 9 KB rows: 95
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-04-05 | ES | Futures | 4522.28 | 4571.38 | 4512.18 | 4564.64 | 1250666.0 |
| 2021-04-05 | NQ | Futures | 15385.46 | 15703.8 | 15345.38 | 15669.78 | 356725.0 |
| 2021-04-05 | YM | Futures | 35972.5 | 36262.6 | 35887.0 | 36166.2 | 120599.0 |
| 2021-04-05 | CL | Futures | 43.78 | 43.78 | 41.03 | 41.75 | 438864.0 |
| 2021-04-05 | GC | Futures | 2028.2 | 2033.3 | 2018.3 | 2026.7 | 101746.0 |
| 2021-04-05 | ZN | Futures | 131.62064 | 131.934733 | 131.463594 | 131.777687 | 919100.0 |
| 2021-04-05 | A6 | Futures | 0.78029 | 0.78572 | 0.77936 | 0.785 | 45804.0 |
| 2021-04-05 | AD | Futures | 0.80498 | 0.8105 | 0.80452 | 0.80903 | 45641.0 |
| 2021-04-05 | ALI | Futures | 2593.76 | 2593.76 | 2593.76 | 2593.76 | 0.0 |
| 2021-04-05 | B | Futures | 41.76 | 41.91 | 39.61 | 40.19 | 231780.0 |
| 2021-04-05 | B6 | Futures | 1.4035 | 1.4132 | 1.4029 | 1.4122 | 41749.0 |
| 2021-04-05 | BR | Futures | 0.13683 | 0.13984 | 0.13683 | 0.13893 | 98.0 |
| 2021-04-05 | BTC | Futures | 76166.4 | 78182.8 | 74351.7 | 77844.6 | 5908.0 |
| 2021-04-05 | BZ | Futures | 40.89 | 40.89 | 38.63 | 39.21 | 37285.0 |
| 2021-04-05 | CB | Futures | 152.544 | 154.402 | 152.544 | 154.402 | 22.0 |
| 2021-04-05 | CC | Futures | 1612.0 | 1632.0 | 1572.0 | 1575.0 | 16847.0 |
| 2021-04-05 | CNH | Futures | 6.4072 | 6.4072 | 6.3857 | 6.3857 | 35.0 |
| 2021-04-05 | CSC | Futures | 2.901 | 2.941 | 2.901 | 2.933 | 22.0 |
| 2021-04-05 | CT | Futures | 74.51 | 75.31 | 73.47 | 73.69 | 10987.0 |
| 2021-04-05 | DC | Futures | 26.24 | 26.53 | 26.17 | 26.39 | 239.0 |
| 2021-04-05 | DX | Futures | 89.881 | 89.997 | 89.446 | 89.48 | 27775.0 |
| 2021-04-05 | E1 | Futures | 1.19605 | 1.20528 | 1.19448 | 1.20427 | 12006.0 |
| 2021-04-05 | E6 | Futures | 1.25486 | 1.26136 | 1.25241 | 1.26045 | 97590.0 |
| 2021-04-05 | E7 | Futures | 1.2481 | 1.2548 | 1.2461 | 1.2541 | 2631.0 |
| 2021-04-05 | ED | Futures | 96.5028 | 96.5028 | 96.498 | 96.498 | 56372.0 |
| 2021-04-05 | ER | Futures | 98.465 | 98.465 | 98.465 | 98.465 | 0.0 |
| 2021-04-05 | ESG | Futures | 372.72 | 377.34 | 372.72 | 376.88 | 235.0 |
| 2021-04-05 | EW | Futures | 2868.6 | 2868.6 | 2828.9 | 2847.5 | 9396.0 |
| 2021-04-05 | GF | Futures | 269.008 | 275.173 | 269.008 | 273.585 | 1288.0 |
| 2021-04-05 | GSCI | Futures | 435.58 | 436.78 | 430.44 | 431.41 | 16.0 |
| 2021-04-05 | HE | Futures | 76.587 | 77.575 | 76.158 | 76.438 | 286.0 |
| 2021-04-05 | HG | Futures | 4.4317 | 4.5769 | 4.4273 | 4.5522 | 54601.0 |
| 2021-04-05 | HH | Futures | 8.438 | 8.438 | 8.047 | 8.124 | 13800.0 |
| 2021-04-05 | HO | Futures | 0.9899 | 0.9912 | 0.946 | 0.9586 | 22723.0 |
| 2021-04-05 | HRC | Futures | 1843.5 | 1843.5 | 1843.5 | 1843.5 | 0.0 |
| 2021-04-05 | J1 | Futures | 0.0104105 | 0.0104767 | 0.0104018 | 0.0104571 | 75715.0 |
| 2021-04-05 | J7 | Futures | 0.010399 | 0.010462 | 0.010392 | 0.010445 | 331.0 |
| 2021-04-05 | JB | Futures | 138.8 | 138.85 | 138.72 | 138.82 | 353.0 |
| 2021-04-05 | KC | Futures | 106.53 | 107.85 | 105.78 | 107.14 | 16091.0 |
| 2021-04-05 | KE | Futures | 701.25 | 714.33 | 699.39 | 700.94 | 13858.0 |
| 2021-04-05 | KRW | Futures | 0.00087 | 0.0008728 | 0.0008699 | 0.0008728 | 10.0 |
| 2021-04-05 | LBS | Futures | 2664.2 | 2715.8 | 2664.2 | 2684.7 | 179.0 |
| 2021-04-05 | LE | Futures | 149.626 | 151.6 | 149.596 | 151.175 | 25941.0 |
| 2021-04-05 | M2K | Futures | 2524.0 | 2532.9 | 2478.2 | 2493.6 | 120572.0 |
| 2021-04-05 | MES | Futures | 4395.41 | 4444.78 | 4387.23 | 4438.24 | 589360.0 |
| 2021-04-05 | MFS | Futures | 2281.1 | 2310.4 | 2277.0 | 2306.7 | 21345.0 |
| 2021-04-05 | MGC | Futures | 1973.0 | 1976.4 | 1961.8 | 1970.0 | 26191.0 |
| 2021-04-05 | MME | Futures | 1375.0 | 1379.0 | 1366.5 | 1375.3 | 52082.0 |
| 2021-04-05 | MNQ | Futures | 15210.16 | 15518.77 | 15164.85 | 15485.43 | 672584.0 |
| 2021-04-05 | MP | Futures | 0.03869 | 0.0388 | 0.03852 | 0.03856 | 27800.0 |
> showing 50 of 95 rows — these rows as CSV