PREVIEW / futures_daily / 2021-05-20
file: by_date/futures_daily/2021/2021-05-20.parquet size: 10 KB rows: 124
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-05-20 | ES | Futures | 4609.53 | 4678.54 | 4583.44 | 4661.71 | 1486599.0 |
| 2021-05-20 | NQ | Futures | 15248.78 | 15597.4 | 15168.33 | 15555.59 | 465782.0 |
| 2021-05-20 | YM | Futures | 36562.4 | 37001.8 | 36350.2 | 36829.7 | 160628.0 |
| 2021-05-20 | CL | Futures | 45.09 | 45.52 | 43.9 | 44.09 | 524168.0 |
| 2021-05-20 | GC | Futures | 2192.2 | 2210.2 | 2185.5 | 2206.2 | 223568.0 |
| 2021-05-20 | ZN | Futures | 132.76708 | 133.20681 | 132.704261 | 133.159696 | 1619543.0 |
| 2021-05-20 | A6 | Futures | 0.79197 | 0.79797 | 0.79126 | 0.79695 | 78087.0 |
| 2021-05-20 | AD | Futures | 0.83532 | 0.84084 | 0.83426 | 0.84013 | 68428.0 |
| 2021-05-20 | ALI | Futures | 2766.62 | 2773.38 | 2740.12 | 2740.12 | 822.0 |
| 2021-05-20 | B | Futures | 43.58 | 43.93 | 42.38 | 42.58 | 388162.0 |
| 2021-05-20 | B6 | Futures | 1.4336 | 1.4412 | 1.4319 | 1.4406 | 71758.0 |
| 2021-05-20 | BFX | Futures | 4108.2 | 4119.8 | 4108.2 | 4119.8 | 24.0 |
| 2021-05-20 | BR | Futures | 0.14886 | 0.15001 | 0.14874 | 0.14973 | 3368.0 |
| 2021-05-20 | BTC | Futures | 53755.6 | 58582.2 | 48266.1 | 55682.1 | 13391.0 |
| 2021-05-20 | BZ | Futures | 42.59 | 42.86 | 41.35 | 41.56 | 35448.0 |
| 2021-05-20 | C | Futures | 1499.0 | 1500.0 | 1472.0 | 1479.0 | 5467.0 |
| 2021-05-20 | CB | Futures | 154.525 | 154.525 | 153.576 | 154.422 | 16.0 |
| 2021-05-20 | CC | Futures | 1641.0 | 1650.0 | 1615.0 | 1628.0 | 14628.0 |
| 2021-05-20 | CNH | Futures | 6.2503 | 6.2521 | 6.2424 | 6.2427 | 831.0 |
| 2021-05-20 | CSC | Futures | 2.798 | 2.811 | 2.771 | 2.795 | 199.0 |
| 2021-05-20 | CT | Futures | 77.61 | 78.13 | 75.99 | 76.02 | 21349.0 |
| 2021-05-20 | DC | Futures | 25.83 | 25.98 | 25.69 | 25.88 | 328.0 |
| 2021-05-20 | DX | Futures | 87.171 | 87.19 | 86.716 | 86.774 | 18129.0 |
| 2021-05-20 | E1 | Futures | 1.24647 | 1.25491 | 1.24467 | 1.25356 | 18073.0 |
| 2021-05-20 | E6 | Futures | 1.29801 | 1.30366 | 1.29721 | 1.30265 | 122935.0 |
| 2021-05-20 | E7 | Futures | 1.2917 | 1.2971 | 1.2908 | 1.2961 | 3452.0 |
| 2021-05-20 | EBM | Futures | 311.5 | 315.92 | 310.4 | 314.45 | 18739.0 |
| 2021-05-20 | ED | Futures | 96.527 | 96.5318 | 96.527 | 96.5318 | 94633.0 |
| 2021-05-20 | ER | Futures | 98.465 | 98.465 | 98.455 | 98.46 | 41092.0 |
| 2021-05-20 | ESG | Futures | 381.33 | 386.36 | 379.96 | 385.4 | 740.0 |
| 2021-05-20 | EW | Futures | 2854.8 | 2877.7 | 2830.9 | 2869.2 | 8200.0 |
| 2021-05-20 | FBON | Futures | 145.27 | 145.87 | 145.13 | 145.77 | 713.0 |
| 2021-05-20 | FBTP | Futures | 134.9 | 135.74 | 134.82 | 135.64 | 165438.0 |
| 2021-05-20 | FBTS | Futures | 109.777 | 109.903 | 109.777 | 109.893 | 82973.0 |
| 2021-05-20 | FCE | Futures | 6255.3 | 6321.1 | 6222.1 | 6298.2 | 52888.0 |
| 2021-05-20 | FDAX | Futures | 16133.7 | 16409.8 | 16092.1 | 16350.1 | 56397.0 |
| 2021-05-20 | FDIV | Futures | 184.41 | 185.59 | 183.63 | 185.59 | 95.0 |
| 2021-05-20 | FDXM | Futures | 16124.7 | 16388.7 | 16072.5 | 16330.2 | 46008.0 |
| 2021-05-20 | FDXS | Futures | 16143.6 | 16304.5 | 15990.0 | 16243.1 | 2533.0 |
| 2021-05-20 | FESX | Futures | 3721.4 | 3783.8 | 3711.9 | 3766.7 | 911132.0 |
| 2021-05-20 | FGBL | Futures | 164.88 | 165.16 | 164.73 | 165.08 | 705685.0 |
| 2021-05-20 | FGBM | Futures | 134.01 | 134.08 | 133.94 | 134.05 | 409951.0 |
| 2021-05-20 | FGBS | Futures | 112.564 | 112.574 | 112.549 | 112.564 | 248696.0 |
| 2021-05-20 | FGBX | Futures | 209.96 | 211.14 | 209.64 | 210.95 | 75012.0 |
| 2021-05-20 | FMWO | Futures | 10225.3 | 10390.9 | 10186.5 | 10348.6 | 3117.0 |
| 2021-05-20 | FOAT | Futures | 152.65 | 153.24 | 152.63 | 153.14 | 250726.0 |
| 2021-05-20 | FTDX | Futures | 3412.4 | 3464.3 | 3406.7 | 3460.2 | 131.0 |
| 2021-05-20 | FTI | Futures | 664.02 | 672.4 | 659.21 | 669.69 | 15591.0 |
| 2021-05-20 | FTUK | Futures | 6769.1 | 6838.2 | 6736.9 | 6823.6 | 94861.0 |
| 2021-05-20 | FVSA | Futures | 121.35 | 122.13 | 110.67 | 113.02 | 31322.0 |
> showing 50 of 124 rows — these rows as CSV