PREVIEW / futures_daily / 2021-04-22
file: by_date/futures_daily/2021/2021-04-22.parquet size: 10 KB rows: 123
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-22 | ES | Futures | 4665.36 | 4681.35 | 4617.95 | 4631.97 | 1944942.0 |
| 2021-04-22 | NQ | Futures | 16028.49 | 16084.14 | 15803.86 | 15859.8 | 623942.0 |
| 2021-04-22 | YM | Futures | 36784.3 | 36841.6 | 36371.9 | 36484.5 | 181670.0 |
| 2021-04-22 | CL | Futures | 43.51 | 44.05 | 43.15 | 43.74 | 344700.0 |
| 2021-04-22 | GC | Futures | 2103.8 | 2108.0 | 2083.4 | 2089.1 | 163753.0 |
| 2021-04-22 | ZN | Futures | 133.20681 | 133.442379 | 132.955535 | 133.222514 | 1465180.0 |
| 2021-04-22 | A6 | Futures | 0.795 | 0.79628 | 0.78874 | 0.79054 | 91951.0 |
| 2021-04-22 | AD | Futures | 0.81065 | 0.81232 | 0.80832 | 0.8109 | 74629.0 |
| 2021-04-22 | ALI | Futures | 2722.38 | 2736.66 | 2714.67 | 2723.52 | 306.0 |
| 2021-04-22 | B | Futures | 42.12 | 42.57 | 41.77 | 42.3 | 242474.0 |
| 2021-04-22 | B6 | Futures | 1.4149 | 1.4167 | 1.4038 | 1.4054 | 92619.0 |
| 2021-04-22 | BFX | Futures | 4069.7 | 4083.0 | 4069.7 | 4078.9 | 5.0 |
| 2021-04-22 | BR | Futures | 0.14265 | 0.14506 | 0.14182 | 0.14435 | 1318.0 |
| 2021-04-22 | BTC | Futures | 71320.6 | 72387.4 | 66819.6 | 68764.4 | 13161.0 |
| 2021-04-22 | BZ | Futures | 41.08 | 41.54 | 40.74 | 41.26 | 26722.0 |
| 2021-04-22 | C | Futures | 1470.0 | 1494.0 | 1470.0 | 1484.0 | 1123.0 |
| 2021-04-22 | CB | Futures | 150.996 | 151.099 | 148.457 | 148.457 | 12.0 |
| 2021-04-22 | CC | Futures | 1625.0 | 1639.0 | 1610.0 | 1627.0 | 10974.0 |
| 2021-04-22 | CNH | Futures | 6.3103 | 6.3198 | 6.3035 | 6.3167 | 403.0 |
| 2021-04-22 | CSC | Futures | 2.923 | 2.937 | 2.894 | 2.902 | 84.0 |
| 2021-04-22 | CT | Futures | 80.42 | 81.17 | 79.74 | 80.08 | 3159.0 |
| 2021-04-22 | DC | Futures | 26.86 | 27.01 | 26.43 | 26.56 | 246.0 |
| 2021-04-22 | DX | Futures | 88.021 | 88.34 | 87.91 | 88.249 | 21688.0 |
| 2021-04-22 | E1 | Futures | 1.22959 | 1.2324 | 1.2261 | 1.22723 | 18036.0 |
| 2021-04-22 | E6 | Futures | 1.28368 | 1.28752 | 1.27937 | 1.28081 | 174686.0 |
| 2021-04-22 | E7 | Futures | 1.2772 | 1.281 | 1.2728 | 1.2743 | 5123.0 |
| 2021-04-22 | EBM | Futures | 297.58 | 306.52 | 296.95 | 304.61 | 15763.0 |
| 2021-04-22 | ED | Futures | 96.498 | 96.498 | 96.4932 | 96.498 | 148920.0 |
| 2021-04-22 | ER | Futures | 98.455 | 98.465 | 98.455 | 98.46 | 55898.0 |
| 2021-04-22 | ESG | Futures | 386.25 | 386.77 | 381.76 | 382.74 | 456.0 |
| 2021-04-22 | EW | Futures | 2894.2 | 2922.3 | 2875.6 | 2884.4 | 9018.0 |
| 2021-04-22 | FBON | Futures | 148.21 | 148.31 | 147.76 | 148.07 | 736.0 |
| 2021-04-22 | FBTP | Futures | 138.36 | 138.43 | 137.77 | 138.15 | 141533.0 |
| 2021-04-22 | FBTS | Futures | 110.068 | 110.068 | 110.0 | 110.049 | 56088.0 |
| 2021-04-22 | FCE | Futures | 6110.8 | 6142.4 | 6088.6 | 6130.5 | 47885.0 |
| 2021-04-22 | FDAX | Futures | 16262.6 | 16369.3 | 16233.9 | 16345.8 | 48270.0 |
| 2021-04-22 | FDXM | Futures | 16233.3 | 16348.3 | 16214.1 | 16325.9 | 51529.0 |
| 2021-04-22 | FDXS | Futures | 16180.6 | 16253.7 | 16133.0 | 16238.9 | 153.0 |
| 2021-04-22 | FESX | Futures | 3728.9 | 3756.3 | 3726.1 | 3750.7 | 730750.0 |
| 2021-04-22 | FEU3 | Futures | 99.203 | 99.203 | 99.203 | 99.203 | 100.0 |
| 2021-04-22 | FGBL | Futures | 167.21 | 167.46 | 166.73 | 167.13 | 845848.0 |
| 2021-04-22 | FGBM | Futures | 134.7 | 134.79 | 134.54 | 134.65 | 463685.0 |
| 2021-04-22 | FGBS | Futures | 112.654 | 112.664 | 112.624 | 112.644 | 242756.0 |
| 2021-04-22 | FGBX | Futures | 218.08 | 218.95 | 217.13 | 218.08 | 82168.0 |
| 2021-04-22 | FMWO | Futures | 10302.8 | 10346.3 | 10231.2 | 10332.2 | 1574.0 |
| 2021-04-22 | FOAT | Futures | 155.57 | 155.76 | 155.1 | 155.45 | 224318.0 |
| 2021-04-22 | FTDX | Futures | 3587.6 | 3627.7 | 3587.6 | 3622.6 | 90.0 |
| 2021-04-22 | FTI | Futures | 673.02 | 673.64 | 666.52 | 671.64 | 16367.0 |
| 2021-04-22 | FTUK | Futures | 6704.3 | 6728.7 | 6675.6 | 6725.2 | 75340.0 |
| 2021-04-22 | FVSA | Futures | 100.36 | 106.15 | 98.25 | 98.78 | 13673.0 |
> showing 50 of 123 rows — these rows as CSV