PREVIEW / futures_daily / 2021-03-24
file: by_date/futures_daily/2021/2021-03-24.parquet size: 10 KB rows: 121
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-03-24 | ES | Futures | 4382.85 | 4411.75 | 4351.15 | 4354.8 | 2063480.0 |
| 2021-03-24 | NQ | Futures | 15052.41 | 15161.98 | 14745.31 | 14756.84 | 626538.0 |
| 2021-03-24 | YM | Futures | 35011.4 | 35358.8 | 34885.8 | 34980.0 | 206190.0 |
| 2021-03-24 | CL | Futures | 40.86 | 43.67 | 40.78 | 43.55 | 566291.0 |
| 2021-03-24 | GC | Futures | 2026.2 | 2040.0 | 2021.9 | 2034.7 | 186524.0 |
| 2021-03-24 | ZN | Futures | 132.688556 | 132.955535 | 132.484396 | 132.76708 | 1694888.0 |
| 2021-03-24 | A6 | Futures | 0.78275 | 0.78305 | 0.77731 | 0.77926 | 96707.0 |
| 2021-03-24 | AD | Futures | 0.80518 | 0.80786 | 0.80361 | 0.8065 | 63210.0 |
| 2021-03-24 | ALI | Futures | 2614.84 | 2625.51 | 2609.64 | 2609.64 | 145.0 |
| 2021-03-24 | B | Futures | 38.73 | 41.33 | 38.71 | 41.23 | 255118.0 |
| 2021-03-24 | B6 | Futures | 1.3965 | 1.3973 | 1.3889 | 1.3908 | 78303.0 |
| 2021-03-24 | BFX | Futures | 3890.5 | 3899.6 | 3881.9 | 3899.6 | 4.0 |
| 2021-03-24 | BR | Futures | 0.14202 | 0.14348 | 0.13996 | 0.14083 | 162.0 |
| 2021-03-24 | BTC | Futures | 71405.2 | 75015.1 | 69662.0 | 71522.3 | 4904.0 |
| 2021-03-24 | BZ | Futures | 37.82 | 40.46 | 37.81 | 40.36 | 36451.0 |
| 2021-03-24 | C | Futures | 1578.0 | 1590.0 | 1569.0 | 1583.0 | 7420.0 |
| 2021-03-24 | CB | Futures | 144.494 | 144.494 | 144.494 | 144.494 | 2.0 |
| 2021-03-24 | CC | Futures | 1648.0 | 1654.0 | 1628.0 | 1641.0 | 17815.0 |
| 2021-03-24 | CNH | Futures | 6.3533 | 6.367 | 6.3533 | 6.3637 | 148.0 |
| 2021-03-24 | CSC | Futures | 2.792 | 2.792 | 2.771 | 2.772 | 65.0 |
| 2021-03-24 | CT | Futures | 79.03 | 79.2 | 77.5 | 78.0 | 15536.0 |
| 2021-03-24 | DC | Futures | 24.74 | 24.78 | 24.57 | 24.64 | 107.0 |
| 2021-03-24 | DX | Futures | 89.321 | 89.514 | 89.243 | 89.417 | 19001.0 |
| 2021-03-24 | E1 | Futures | 1.20776 | 1.2081 | 1.20382 | 1.20573 | 16724.0 |
| 2021-03-24 | E6 | Futures | 1.26472 | 1.26514 | 1.26061 | 1.26189 | 166482.0 |
| 2021-03-24 | E7 | Futures | 1.2582 | 1.2587 | 1.2542 | 1.2556 | 4062.0 |
| 2021-03-24 | EBM | Futures | 282.58 | 283.85 | 277.79 | 279.06 | 27782.0 |
| 2021-03-24 | ED | Futures | 96.5077 | 96.5125 | 96.5077 | 96.5077 | 60549.0 |
| 2021-03-24 | ER | Futures | 98.455 | 98.465 | 98.455 | 98.46 | 54285.0 |
| 2021-03-24 | ESG | Futures | 362.42 | 363.64 | 359.33 | 359.33 | 647.0 |
| 2021-03-24 | EW | Futures | 2708.1 | 2751.9 | 2683.7 | 2685.3 | 9293.0 |
| 2021-03-24 | FBON | Futures | 149.28 | 149.43 | 149.1 | 149.38 | 647.0 |
| 2021-03-24 | FBTP | Futures | 139.77 | 139.92 | 139.53 | 139.77 | 107191.0 |
| 2021-03-24 | FBTS | Futures | 110.195 | 110.195 | 110.146 | 110.175 | 87446.0 |
| 2021-03-24 | FCE | Futures | 5766.3 | 5798.0 | 5735.5 | 5793.1 | 46052.0 |
| 2021-03-24 | FDAX | Futures | 15572.9 | 15597.4 | 15489.8 | 15581.4 | 59917.0 |
| 2021-03-24 | FDIV | Futures | 177.21 | 177.45 | 176.86 | 177.45 | 55.0 |
| 2021-03-24 | FDXM | Futures | 15575.3 | 15580.6 | 15472.0 | 15562.5 | 52543.0 |
| 2021-03-24 | FESX | Futures | 3541.8 | 3568.2 | 3536.1 | 3565.4 | 808481.0 |
| 2021-03-24 | FGBL | Futures | 168.36 | 168.6 | 168.1 | 168.34 | 700316.0 |
| 2021-03-24 | FGBM | Futures | 135.12 | 135.18 | 135.06 | 135.13 | 358027.0 |
| 2021-03-24 | FGBS | Futures | 112.689 | 112.704 | 112.679 | 112.699 | 269375.0 |
| 2021-03-24 | FGBX | Futures | 220.8 | 221.93 | 220.19 | 220.86 | 62928.0 |
| 2021-03-24 | FMWO | Futures | 9734.3 | 9803.6 | 9701.4 | 9794.2 | 2950.0 |
| 2021-03-24 | FOAT | Futures | 156.66 | 156.81 | 156.33 | 156.6 | 172180.0 |
| 2021-03-24 | FTDX | Futures | 3492.6 | 3511.1 | 3468.9 | 3468.9 | 117.0 |
| 2021-03-24 | FTI | Futures | 636.86 | 644.6 | 636.25 | 642.85 | 20689.0 |
| 2021-03-24 | FTUK | Futures | 6442.8 | 6494.4 | 6422.3 | 6489.5 | 72834.0 |
| 2021-03-24 | FVSA | Futures | 113.16 | 114.87 | 108.88 | 109.74 | 19198.0 |
| 2021-03-24 | FXXP | Futures | 394.3 | 396.6 | 393.1 | 396.4 | 50783.0 |
> showing 50 of 121 rows — these rows as CSV