PREVIEW / futures_daily / 2020-02-12
file: by_date/futures_daily/2020/2020-02-12.parquet size: 10 KB rows: 118
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-02-12 | ES | Futures | 3629.39 | 3652.07 | 3623.99 | 3650.99 | 1229231.0 |
| 2020-02-12 | NQ | Futures | 10938.26 | 11043.79 | 10923.92 | 11040.92 | 454472.0 |
| 2020-02-12 | YM | Futures | 30730.0 | 31021.0 | 30675.4 | 31005.2 | 172696.0 |
| 2020-02-12 | CL | Futures | 51.22 | 53.02 | 51.22 | 52.49 | 292195.0 |
| 2020-02-12 | GC | Futures | 1915.7 | 1918.6 | 1907.4 | 1916.2 | 189550.0 |
| 2020-02-12 | ZN | Futures | 129.728644 | 129.775103 | 129.449891 | 129.527323 | 1700284.0 |
| 2020-02-12 | A6 | Futures | 0.68882 | 0.6924 | 0.68851 | 0.69076 | 88828.0 |
| 2020-02-12 | AD | Futures | 0.75849 | 0.76126 | 0.75788 | 0.7598 | 92612.0 |
| 2020-02-12 | ALI | Futures | 2108.26 | 2121.45 | 2104.37 | 2108.56 | 380.0 |
| 2020-02-12 | B | Futures | 45.1 | 46.71 | 45.08 | 46.24 | 305454.0 |
| 2020-02-12 | B6 | Futures | 1.3147 | 1.3186 | 1.3146 | 1.3153 | 87282.0 |
| 2020-02-12 | BR | Futures | 0.18723 | 0.18796 | 0.18601 | 0.18666 | 2688.0 |
| 2020-02-12 | BTC | Futures | 15494.0 | 15936.7 | 15479.0 | 15794.1 | 13010.0 |
| 2020-02-12 | BZ | Futures | 44.24 | 45.98 | 44.24 | 45.56 | 43350.0 |
| 2020-02-12 | C | Futures | 1916.0 | 1920.0 | 1872.0 | 1878.0 | 5418.0 |
| 2020-02-12 | CB | Futures | 226.672 | 226.672 | 224.167 | 224.167 | 65.0 |
| 2020-02-12 | CC | Futures | 1885.0 | 1905.0 | 1870.0 | 1878.0 | 29336.0 |
| 2020-02-12 | CNH | Futures | 6.9394 | 6.9447 | 6.9287 | 6.942 | 290.0 |
| 2020-02-12 | CSC | Futures | 3.353 | 3.361 | 3.335 | 3.35 | 50.0 |
| 2020-02-12 | CT | Futures | 64.92 | 65.43 | 64.46 | 65.23 | 22534.0 |
| 2020-02-12 | DC | Futures | 27.91 | 28.04 | 27.8 | 27.96 | 377.0 |
| 2020-02-12 | DX | Futures | 95.764 | 96.016 | 95.681 | 96.013 | 14974.0 |
| 2020-02-12 | E1 | Futures | 1.1733 | 1.17524 | 1.16987 | 1.1701 | 22164.0 |
| 2020-02-12 | E6 | Futures | 1.17856 | 1.17937 | 1.17285 | 1.17302 | 188198.0 |
| 2020-02-12 | E7 | Futures | 1.1726 | 1.1732 | 1.1668 | 1.1669 | 4281.0 |
| 2020-02-12 | EBM | Futures | 210.44 | 212.09 | 210.17 | 211.54 | 15526.0 |
| 2020-02-12 | ED | Futures | 95.3956 | 95.3956 | 95.3811 | 95.3908 | 195848.0 |
| 2020-02-12 | ER | Futures | 98.396 | 98.401 | 98.391 | 98.401 | 35608.0 |
| 2020-02-12 | ESG | Futures | 302.39 | 302.83 | 301.83 | 302.83 | 73.0 |
| 2020-02-12 | EW | Futures | 2188.0 | 2202.6 | 2185.2 | 2201.5 | 11494.0 |
| 2020-02-12 | FBON | Futures | 145.21 | 145.64 | 145.1 | 145.52 | 452.0 |
| 2020-02-12 | FBTP | Futures | 132.28 | 133.03 | 132.14 | 132.85 | 128265.0 |
| 2020-02-12 | FBTS | Futures | 108.653 | 108.73 | 108.624 | 108.711 | 55318.0 |
| 2020-02-12 | FCE | Futures | 5487.9 | 5530.0 | 5481.6 | 5518.2 | 655.0 |
| 2020-02-12 | FDAX | Futures | 14423.0 | 14571.6 | 14387.6 | 14528.8 | 83359.0 |
| 2020-02-12 | FDIV | Futures | 160.75 | 161.45 | 160.75 | 161.45 | 72.0 |
| 2020-02-12 | FDXM | Futures | 14234.1 | 14387.6 | 14207.0 | 14346.4 | 61681.0 |
| 2020-02-12 | FESX | Futures | 3366.4 | 3398.1 | 3361.2 | 3388.5 | 915012.0 |
| 2020-02-12 | FGBL | Futures | 166.36 | 166.39 | 165.93 | 166.22 | 738174.0 |
| 2020-02-12 | FGBM | Futures | 134.21 | 134.25 | 134.11 | 134.18 | 350530.0 |
| 2020-02-12 | FGBS | Futures | 112.729 | 112.729 | 112.699 | 112.719 | 253839.0 |
| 2020-02-12 | FGBX | Futures | 216.94 | 217.23 | 215.43 | 216.64 | 57515.0 |
| 2020-02-12 | FMWO | Futures | 8085.6 | 8117.3 | 8082.2 | 8108.2 | 9297.0 |
| 2020-02-12 | FOAT | Futures | 153.91 | 154.17 | 153.69 | 154.0 | 158133.0 |
| 2020-02-12 | FTDX | Futures | 3266.9 | 3333.8 | 3266.9 | 3285.0 | 92.0 |
| 2020-02-12 | FTI | Futures | 598.92 | 603.43 | 597.96 | 602.04 | 588.0 |
| 2020-02-12 | FTUK | Futures | 6968.7 | 7028.7 | 6968.7 | 7007.2 | 80996.0 |
| 2020-02-12 | FVSA | Futures | 112.67 | 113.48 | 109.82 | 111.85 | 16500.0 |
| 2020-02-12 | FXXP | Futures | 390.6 | 393.4 | 389.9 | 392.1 | 58990.0 |
| 2020-02-12 | G | Futures | 122.23 | 122.35 | 121.97 | 122.01 | 186482.0 |
> showing 50 of 118 rows — these rows as CSV