PREVIEW / futures_daily / 2020-01-30
file: by_date/futures_daily/2020/2020-01-30.parquet size: 10 KB rows: 121
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-01-30 | ES | Futures | 3533.27 | 3558.92 | 3498.97 | 3552.98 | 2421276.0 |
| 2020-01-30 | NQ | Futures | 10450.78 | 10598.46 | 10327.19 | 10571.22 | 846585.0 |
| 2020-01-30 | YM | Futures | 30159.8 | 30291.1 | 29859.4 | 30236.5 | 347453.0 |
| 2020-01-30 | CL | Futures | 54.45 | 54.56 | 52.98 | 53.47 | 720123.0 |
| 2020-01-30 | GC | Futures | 1929.4 | 1939.5 | 1922.5 | 1937.6 | 382595.0 |
| 2020-01-30 | ZN | Futures | 129.898993 | 130.363582 | 129.837048 | 130.146774 | 2694207.0 |
| 2020-01-30 | A6 | Futures | 0.6924 | 0.69312 | 0.68748 | 0.6883 | 120731.0 |
| 2020-01-30 | AD | Futures | 0.76348 | 0.76388 | 0.76186 | 0.76232 | 78352.0 |
| 2020-01-30 | ALI | Futures | 2107.66 | 2107.66 | 2107.66 | 2107.66 | 5.0 |
| 2020-01-30 | B | Futures | 48.66 | 48.69 | 47.03 | 47.52 | 460251.0 |
| 2020-01-30 | B6 | Futures | 1.3215 | 1.331 | 1.3178 | 1.3282 | 147060.0 |
| 2020-01-30 | BR | Futures | 0.19165 | 0.19178 | 0.18971 | 0.19003 | 7777.0 |
| 2020-01-30 | BTC | Futures | 14241.0 | 14601.1 | 13993.4 | 14601.1 | 2737.0 |
| 2020-01-30 | BZ | Futures | 47.95 | 47.97 | 46.33 | 46.82 | 67928.0 |
| 2020-01-30 | C | Futures | 1863.0 | 1918.0 | 1862.0 | 1893.0 | 7719.0 |
| 2020-01-30 | CB | Futures | 229.915 | 230.504 | 229.915 | 230.504 | 32.0 |
| 2020-01-30 | CC | Futures | 1796.0 | 1849.0 | 1793.0 | 1832.0 | 24487.0 |
| 2020-01-30 | CNH | Futures | 6.9458 | 6.9742 | 6.9458 | 6.9621 | 537.0 |
| 2020-01-30 | CSC | Futures | 3.459 | 3.469 | 3.431 | 3.444 | 92.0 |
| 2020-01-30 | CT | Futures | 66.64 | 66.64 | 65.19 | 65.68 | 16499.0 |
| 2020-01-30 | DC | Futures | 29.08 | 29.08 | 28.56 | 28.72 | 162.0 |
| 2020-01-30 | DX | Futures | 94.982 | 95.031 | 94.749 | 94.833 | 15514.0 |
| 2020-01-30 | E1 | Futures | 1.1765 | 1.18358 | 1.1765 | 1.18164 | 32908.0 |
| 2020-01-30 | E6 | Futures | 1.1895 | 1.19241 | 1.18896 | 1.19138 | 165288.0 |
| 2020-01-30 | E7 | Futures | 1.1832 | 1.1861 | 1.1828 | 1.1852 | 1971.0 |
| 2020-01-30 | EBM | Futures | 210.72 | 212.37 | 209.62 | 211.27 | 33414.0 |
| 2020-01-30 | ED | Futures | 95.3471 | 95.3811 | 95.3471 | 95.3665 | 358671.0 |
| 2020-01-30 | ER | Futures | 98.396 | 98.401 | 98.391 | 98.396 | 76672.0 |
| 2020-01-30 | ESG | Futures | 289.77 | 294.28 | 289.77 | 294.28 | 85.0 |
| 2020-01-30 | EW | Futures | 2158.5 | 2160.2 | 2132.6 | 2156.9 | 16716.0 |
| 2020-01-30 | FBON | Futures | 145.36 | 145.37 | 145.11 | 145.36 | 359.0 |
| 2020-01-30 | FBTP | Futures | 132.56 | 132.73 | 132.21 | 132.71 | 112143.0 |
| 2020-01-30 | FBTS | Futures | 108.653 | 108.663 | 108.557 | 108.624 | 67841.0 |
| 2020-01-30 | FCE | Futures | 5353.8 | 5357.4 | 5296.6 | 5321.1 | 96929.0 |
| 2020-01-30 | FDAX | Futures | 14087.3 | 14087.8 | 13869.4 | 13905.4 | 146077.0 |
| 2020-01-30 | FDIV | Futures | 156.2 | 156.2 | 155.14 | 155.14 | 30.0 |
| 2020-01-30 | FDXM | Futures | 13912.5 | 13912.5 | 13695.3 | 13730.8 | 85117.0 |
| 2020-01-30 | FESX | Futures | 3278.4 | 3278.4 | 3229.9 | 3240.5 | 1395737.0 |
| 2020-01-30 | FGBL | Futures | 166.42 | 166.82 | 166.42 | 166.74 | 761982.0 |
| 2020-01-30 | FGBM | Futures | 134.23 | 134.39 | 134.23 | 134.35 | 441509.0 |
| 2020-01-30 | FGBS | Futures | 112.729 | 112.769 | 112.729 | 112.764 | 351344.0 |
| 2020-01-30 | FGBX | Futures | 217.88 | 219.38 | 217.84 | 219.09 | 60992.0 |
| 2020-01-30 | FMWO | Futures | 7867.8 | 7880.3 | 7830.4 | 7856.5 | 2629.0 |
| 2020-01-30 | FOAT | Futures | 154.1 | 154.24 | 153.88 | 154.2 | 140820.0 |
| 2020-01-30 | FTDX | Futures | 3140.8 | 3153.4 | 3110.7 | 3119.2 | 122.0 |
| 2020-01-30 | FTI | Futures | 575.03 | 576.27 | 570.33 | 572.52 | 36964.0 |
| 2020-01-30 | FTUK | Futures | 6945.7 | 6946.2 | 6840.2 | 6863.6 | 136248.0 |
| 2020-01-30 | FVSA | Futures | 127.55 | 133.92 | 124.99 | 130.95 | 45652.0 |
| 2020-01-30 | FXXP | Futures | 378.3 | 379.9 | 376.0 | 377.0 | 74562.0 |
| 2020-01-30 | G | Futures | 123.42 | 123.61 | 122.59 | 122.89 | 335842.0 |
> showing 50 of 121 rows — these rows as CSV