PREVIEW / futures_daily / 2020-04-29
file: by_date/futures_daily/2020/2020-04-29.parquet size: 10 KB rows: 120
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 |
|---|---|---|---|---|---|---|---|
| 2020-04-29 | ES | Futures | 3176.17 | 3274.92 | 3165.38 | 3254.17 | 1737371.0 |
| 2020-04-29 | NQ | Futures | 10041.95 | 10454.1 | 10012.72 | 10359.8 | 432414.0 |
| 2020-04-29 | YM | Futures | 25647.7 | 26343.4 | 25578.3 | 26213.2 | 178479.0 |
| 2020-04-29 | CL | Futures | 9.94 | 12.49 | 9.43 | 11.21 | 554134.0 |
| 2020-04-29 | GC | Futures | 2091.7 | 2102.3 | 2071.6 | 2077.9 | 159603.0 |
| 2020-04-29 | ZN | Futures | 137.315305 | 137.593146 | 137.145513 | 137.284433 | 1073167.0 |
| 2020-04-29 | A6 | Futures | 0.66706 | 0.67384 | 0.66686 | 0.6722 | 59844.0 |
| 2020-04-29 | AD | Futures | 0.72399 | 0.73037 | 0.72379 | 0.72921 | 50938.0 |
| 2020-04-29 | ALI | Futures | 1829.3 | 1829.3 | 1824.22 | 1824.22 | 12.0 |
| 2020-04-29 | B | Futures | 15.14 | 16.66 | 15.01 | 16.0 | 328811.0 |
| 2020-04-29 | B6 | Futures | 1.2614 | 1.2676 | 1.2578 | 1.2642 | 49905.0 |
| 2020-04-29 | BR | Futures | 0.14587 | 0.15308 | 0.14587 | 0.15243 | 7738.0 |
| 2020-04-29 | BTC | Futures | 10848.5 | 12607.9 | 10820.7 | 12274.1 | 9729.0 |
| 2020-04-29 | BZ | Futures | 14.65 | 16.1 | 14.48 | 15.49 | 36184.0 |
| 2020-04-29 | C | Futures | 1794.0 | 1864.0 | 1794.0 | 1854.0 | 7073.0 |
| 2020-04-29 | CB | Futures | 138.3 | 138.3 | 135.596 | 137.157 | 92.0 |
| 2020-04-29 | CC | Futures | 1539.0 | 1558.0 | 1536.0 | 1553.0 | 7915.0 |
| 2020-04-29 | CNH | Futures | 7.0209 | 7.0223 | 7.0088 | 7.0106 | 192.0 |
| 2020-04-29 | CSC | Futures | 2.402 | 2.475 | 2.395 | 2.475 | 27.0 |
| 2020-04-29 | CT | Futures | 54.38 | 55.8 | 54.38 | 55.68 | 13584.0 |
| 2020-04-29 | DC | Futures | 19.47 | 20.25 | 19.32 | 20.09 | 322.0 |
| 2020-04-29 | DX | Futures | 96.635 | 96.654 | 96.229 | 96.353 | 10391.0 |
| 2020-04-29 | E1 | Futures | 1.17007 | 1.17394 | 1.16745 | 1.16893 | 17276.0 |
| 2020-04-29 | E6 | Futures | 1.16424 | 1.17096 | 1.16403 | 1.1694 | 117506.0 |
| 2020-04-29 | E7 | Futures | 1.158 | 1.1648 | 1.1575 | 1.1633 | 5746.0 |
| 2020-04-29 | EBM | Futures | 218.93 | 220.05 | 217.81 | 218.09 | 11903.0 |
| 2020-04-29 | ED | Futures | 96.3388 | 96.3726 | 96.3339 | 96.3629 | 380956.0 |
| 2020-04-29 | ER | Futures | 98.293 | 98.318 | 98.289 | 98.308 | 118036.0 |
| 2020-04-29 | ESG | Futures | 264.15 | 266.02 | 264.13 | 265.0 | 63.0 |
| 2020-04-29 | EW | Futures | 1724.3 | 1809.2 | 1720.4 | 1797.1 | 11045.0 |
| 2020-04-29 | FBON | Futures | 138.59 | 139.68 | 138.53 | 139.36 | 311.0 |
| 2020-04-29 | FBTP | Futures | 122.85 | 124.14 | 122.54 | 123.94 | 101861.0 |
| 2020-04-29 | FBTS | Futures | 106.489 | 106.97 | 106.47 | 106.922 | 78924.0 |
| 2020-04-29 | FCE | Futures | 4417.2 | 4513.1 | 4381.9 | 4497.6 | 37002.0 |
| 2020-04-29 | FDAX | Futures | 11389.8 | 11798.0 | 11379.7 | 11756.2 | 98759.0 |
| 2020-04-29 | FDIV | Futures | 123.31 | 128.09 | 123.31 | 127.3 | 348.0 |
| 2020-04-29 | FDXM | Futures | 11450.6 | 11854.4 | 11433.5 | 11812.4 | 63293.0 |
| 2020-04-29 | FESX | Futures | 2647.0 | 2731.5 | 2644.3 | 2722.3 | 1064689.0 |
| 2020-04-29 | FEU3 | Futures | 99.04 | 99.045 | 99.04 | 99.045 | 150.0 |
| 2020-04-29 | FGBL | Futures | 167.92 | 168.44 | 167.75 | 168.22 | 531309.0 |
| 2020-04-29 | FGBM | Futures | 134.58 | 134.84 | 134.58 | 134.74 | 298277.0 |
| 2020-04-29 | FGBS | Futures | 112.84 | 112.915 | 112.84 | 112.89 | 198185.0 |
| 2020-04-29 | FGBX | Futures | 226.82 | 228.84 | 226.63 | 228.05 | 54348.0 |
| 2020-04-29 | FMWO | Futures | 7102.1 | 7222.1 | 7086.8 | 7189.2 | 4843.0 |
| 2020-04-29 | FOAT | Futures | 152.42 | 153.2 | 152.2 | 153.01 | 114921.0 |
| 2020-04-29 | FTDX | Futures | 2916.3 | 2916.3 | 2859.7 | 2904.2 | 81.0 |
| 2020-04-29 | FTI | Futures | 486.17 | 494.74 | 484.06 | 492.04 | 23495.0 |
| 2020-04-29 | FTUK | Futures | 5574.8 | 5769.1 | 5574.8 | 5759.7 | 93956.0 |
| 2020-04-29 | FVSA | Futures | 292.11 | 295.26 | 278.61 | 280.86 | 14239.0 |
| 2020-04-29 | FXXP | Futures | 314.6 | 320.4 | 313.0 | 319.5 | 89318.0 |
> showing 50 of 120 rows — these rows as CSV