PREVIEW / futures_daily / 2020-01-16
file: by_date/futures_daily/2020/2020-01-16.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-16 | ES | Futures | 3557.84 | 3583.49 | 3557.57 | 3581.87 | 1335246.0 |
| 2020-01-16 | NQ | Futures | 10394.0 | 10484.04 | 10393.71 | 10476.3 | 397881.0 |
| 2020-01-16 | YM | Futures | 30491.7 | 30732.1 | 30489.6 | 30708.0 | 152873.0 |
| 2020-01-16 | CL | Futures | 59.6 | 60.38 | 59.07 | 60.03 | 426333.0 |
| 2020-01-16 | GC | Futures | 1915.0 | 1917.0 | 1904.5 | 1907.5 | 260054.0 |
| 2020-01-16 | ZN | Futures | 128.210988 | 128.288419 | 127.932235 | 128.009666 | 1373300.0 |
| 2020-01-16 | A6 | Futures | 0.70881 | 0.71178 | 0.70706 | 0.70778 | 76664.0 |
| 2020-01-16 | AD | Futures | 0.77265 | 0.77315 | 0.77179 | 0.77229 | 41491.0 |
| 2020-01-16 | ALI | Futures | 2193.7 | 2195.5 | 2188.0 | 2193.7 | 73.0 |
| 2020-01-16 | B | Futures | 52.54 | 53.12 | 52.24 | 52.83 | 220168.0 |
| 2020-01-16 | B6 | Futures | 1.3255 | 1.329 | 1.3233 | 1.3274 | 71759.0 |
| 2020-01-16 | BFX | Futures | 4694.7 | 4712.6 | 4694.7 | 4712.6 | 7.0 |
| 2020-01-16 | BR | Futures | 0.19352 | 0.19445 | 0.19283 | 0.19295 | 1262.0 |
| 2020-01-16 | BTC | Futures | 13529.1 | 13574.6 | 13059.2 | 13324.5 | 5818.0 |
| 2020-01-16 | BZ | Futures | 51.84 | 52.36 | 51.52 | 52.09 | 38391.0 |
| 2020-01-16 | C | Futures | 1893.0 | 1900.0 | 1854.0 | 1859.0 | 14617.0 |
| 2020-01-16 | CB | Futures | 237.932 | 238.61 | 236.842 | 237.343 | 62.0 |
| 2020-01-16 | CC | Futures | 1774.0 | 1785.0 | 1762.0 | 1774.0 | 25399.0 |
| 2020-01-16 | CNH | Futures | 6.8582 | 6.8676 | 6.8469 | 6.8541 | 388.0 |
| 2020-01-16 | CSC | Futures | 3.35 | 3.392 | 3.35 | 3.383 | 45.0 |
| 2020-01-16 | CT | Futures | 66.82 | 66.94 | 66.33 | 66.79 | 15939.0 |
| 2020-01-16 | DC | Futures | 28.17 | 28.49 | 28.17 | 28.43 | 162.0 |
| 2020-01-16 | DX | Futures | 94.085 | 94.259 | 93.968 | 94.208 | 11834.0 |
| 2020-01-16 | E1 | Futures | 1.18998 | 1.19295 | 1.18815 | 1.18872 | 29931.0 |
| 2020-01-16 | E6 | Futures | 1.20571 | 1.20792 | 1.20296 | 1.20377 | 147897.0 |
| 2020-01-16 | E7 | Futures | 1.1994 | 1.2015 | 1.1966 | 1.1975 | 2370.0 |
| 2020-01-16 | EBM | Futures | 213.19 | 213.47 | 211.82 | 212.09 | 28564.0 |
| 2020-01-16 | ED | Futures | 95.3132 | 95.318 | 95.3035 | 95.3083 | 139641.0 |
| 2020-01-16 | ER | Futures | 98.372 | 98.377 | 98.372 | 98.372 | 22235.0 |
| 2020-01-16 | ESG | Futures | 289.29 | 289.29 | 289.29 | 289.29 | 30.0 |
| 2020-01-16 | EW | Futures | 2191.6 | 2212.6 | 2191.6 | 2212.0 | 18737.0 |
| 2020-01-16 | FBON | Futures | 142.94 | 143.1 | 142.73 | 142.78 | 445.0 |
| 2020-01-16 | FBTP | Futures | 127.98 | 128.13 | 127.47 | 127.52 | 136240.0 |
| 2020-01-16 | FBTS | Futures | 108.115 | 108.143 | 107.97 | 107.999 | 68244.0 |
| 2020-01-16 | FCE | Futures | 5477.5 | 5495.6 | 5453.0 | 5469.8 | 62358.0 |
| 2020-01-16 | FDAX | Futures | 14200.4 | 14268.6 | 14146.5 | 14195.1 | 95617.0 |
| 2020-01-16 | FDIV | Futures | 159.87 | 159.96 | 159.64 | 159.96 | 60.0 |
| 2020-01-16 | FDXM | Futures | 14013.8 | 14089.0 | 13968.9 | 14016.9 | 50348.0 |
| 2020-01-16 | FESX | Futures | 3309.2 | 3325.9 | 3300.4 | 3313.6 | 886677.0 |
| 2020-01-16 | FGBL | Futures | 163.92 | 164.1 | 163.67 | 164.02 | 637822.0 |
| 2020-01-16 | FGBM | Futures | 133.5 | 133.59 | 133.43 | 133.57 | 391383.0 |
| 2020-01-16 | FGBS | Futures | 112.624 | 112.634 | 112.608 | 112.624 | 238661.0 |
| 2020-01-16 | FGBX | Futures | 209.87 | 210.64 | 209.34 | 210.41 | 49627.0 |
| 2020-01-16 | FMWO | Futures | 7985.8 | 8028.9 | 7981.2 | 8002.8 | 3291.0 |
| 2020-01-16 | FOAT | Futures | 151.48 | 151.77 | 151.44 | 151.67 | 126380.0 |
| 2020-01-16 | FTDX | Futures | 3130.3 | 3153.4 | 3130.3 | 3141.3 | 88.0 |
| 2020-01-16 | FTI | Futures | 585.62 | 587.44 | 584.37 | 585.09 | 16400.0 |
| 2020-01-16 | FTUK | Futures | 7105.2 | 7123.0 | 7065.3 | 7075.7 | 89596.0 |
| 2020-01-16 | FVSA | Futures | 116.49 | 117.34 | 113.94 | 113.94 | 23564.0 |
| 2020-01-16 | FXXP | Futures | 381.7 | 382.9 | 380.7 | 382.0 | 53170.0 |
> showing 50 of 121 rows — these rows as CSV