PREVIEW / futures_daily / 2020-06-12
file: by_date/futures_daily/2020/2020-06-12.parquet size: 10 KB rows: 119
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-06-12 | ES | Futures | 3332.46 | 3416.55 | 3299.54 | 3357.91 | 2872339.0 |
| 2020-06-12 | NQ | Futures | 11024.17 | 11291.57 | 10885.16 | 11057.41 | 508840.0 |
| 2020-06-12 | YM | Futures | 26859.8 | 27666.8 | 26721.6 | 27218.8 | 212236.0 |
| 2020-06-12 | CL | Futures | 26.29 | 26.82 | 25.0 | 26.29 | 406508.0 |
| 2020-06-12 | GC | Futures | 2081.4 | 2104.7 | 2074.9 | 2085.8 | 151397.0 |
| 2020-06-12 | ZN | Futures | 137.645068 | 137.722492 | 137.319885 | 137.490219 | 1110376.0 |
| 2020-06-12 | A6 | Futures | 0.70424 | 0.71113 | 0.6995 | 0.70383 | 155140.0 |
| 2020-06-12 | AD | Futures | 0.74525 | 0.75048 | 0.74276 | 0.74556 | 99743.0 |
| 2020-06-12 | ALI | Futures | 1921.11 | 1921.11 | 1921.11 | 1921.11 | 5.0 |
| 2020-06-12 | B | Futures | 24.8 | 25.82 | 24.23 | 25.35 | 237894.0 |
| 2020-06-12 | B6 | Futures | 1.2799 | 1.2855 | 1.2672 | 1.2688 | 134274.0 |
| 2020-06-12 | BR | Futures | 0.15649 | 0.15649 | 0.15558 | 0.15558 | 9.0 |
| 2020-06-12 | BTC | Futures | 13046.0 | 13365.9 | 12886.0 | 13164.2 | 3848.0 |
| 2020-06-12 | BZ | Futures | 24.54 | 25.21 | 23.65 | 24.76 | 29653.0 |
| 2020-06-12 | C | Futures | 1763.0 | 1809.0 | 1760.0 | 1795.0 | 7446.0 |
| 2020-06-12 | CB | Futures | 213.603 | 213.603 | 213.549 | 213.549 | 16.0 |
| 2020-06-12 | CC | Futures | 1505.0 | 1539.0 | 1497.0 | 1521.0 | 19777.0 |
| 2020-06-12 | CNH | Futures | 7.0094 | 7.0146 | 6.9956 | 7.0079 | 431.0 |
| 2020-06-12 | CSC | Futures | 3.459 | 3.461 | 3.41 | 3.416 | 72.0 |
| 2020-06-12 | CT | Futures | 58.51 | 58.86 | 57.98 | 58.33 | 10003.0 |
| 2020-06-12 | DC | Futures | 28.67 | 28.67 | 28.3 | 28.35 | 131.0 |
| 2020-06-12 | DX | Futures | 93.546 | 94.145 | 93.198 | 94.014 | 23759.0 |
| 2020-06-12 | E1 | Futures | 1.20581 | 1.20695 | 1.19218 | 1.19321 | 30075.0 |
| 2020-06-12 | E6 | Futures | 1.21466 | 1.21948 | 1.2057 | 1.20768 | 301427.0 |
| 2020-06-12 | E7 | Futures | 1.2085 | 1.2135 | 1.1997 | 1.2016 | 7050.0 |
| 2020-06-12 | EBM | Futures | 217.96 | 220.05 | 217.96 | 219.75 | 15690.0 |
| 2020-06-12 | ED | Futures | 96.346 | 96.375 | 96.346 | 96.3702 | 243266.0 |
| 2020-06-12 | ER | Futures | 98.318 | 98.333 | 98.313 | 98.333 | 99512.0 |
| 2020-06-12 | ESG | Futures | 277.57 | 277.57 | 270.03 | 274.06 | 160.0 |
| 2020-06-12 | EW | Futures | 1832.7 | 1899.8 | 1809.4 | 1862.6 | 62661.0 |
| 2020-06-12 | FBON | Futures | 142.94 | 143.39 | 142.67 | 143.26 | 294.0 |
| 2020-06-12 | FBTP | Futures | 127.53 | 128.23 | 127.18 | 128.07 | 69630.0 |
| 2020-06-12 | FBTS | Futures | 108.037 | 108.173 | 107.901 | 108.144 | 52581.0 |
| 2020-06-12 | FCE | Futures | 4675.3 | 4809.5 | 4627.2 | 4705.1 | 9744.0 |
| 2020-06-12 | FDAX | Futures | 12542.6 | 12877.3 | 12474.4 | 12627.2 | 133443.0 |
| 2020-06-12 | FDIV | Futures | 139.62 | 139.62 | 137.91 | 137.91 | 100.0 |
| 2020-06-12 | FDXM | Futures | 12533.3 | 12861.4 | 12493.0 | 12615.8 | 656.0 |
| 2020-06-12 | FESX | Futures | 2845.9 | 2939.2 | 2832.0 | 2875.4 | 602001.0 |
| 2020-06-12 | FEU3 | Futures | 99.07 | 99.08 | 99.07 | 99.08 | 200.0 |
| 2020-06-12 | FGBL | Futures | 167.44 | 167.78 | 167.11 | 167.75 | 513949.0 |
| 2020-06-12 | FGBM | Futures | 134.47 | 134.67 | 134.42 | 134.66 | 353564.0 |
| 2020-06-12 | FGBS | Futures | 112.719 | 112.774 | 112.699 | 112.769 | 242889.0 |
| 2020-06-12 | FGBX | Futures | 223.84 | 224.39 | 222.42 | 224.27 | 49252.0 |
| 2020-06-12 | FMWO | Futures | 7498.6 | 7640.9 | 7444.5 | 7480.9 | 18146.0 |
| 2020-06-12 | FOAT | Futures | 153.82 | 154.46 | 153.75 | 154.42 | 127578.0 |
| 2020-06-12 | FTDX | Futures | 3149.7 | 3149.7 | 3120.6 | 3120.6 | 67.0 |
| 2020-06-12 | FTI | Futures | 499.74 | 509.61 | 495.98 | 504.7 | 2301.0 |
| 2020-06-12 | FTUK | Futures | 5657.1 | 5802.7 | 5627.3 | 5718.5 | 54051.0 |
| 2020-06-12 | FVSA | Futures | 310.8 | 340.85 | 290.17 | 332.33 | 22639.0 |
| 2020-06-12 | FXXP | Futures | 323.5 | 329.1 | 319.9 | 324.0 | 16278.0 |
> showing 50 of 119 rows — these rows as CSV