PREVIEW / futures_daily / 2020-01-21
file: by_date/futures_daily/2020/2020-01-21.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-21 | ES | Futures | 3591.05 | 3596.18 | 3571.88 | 3585.11 | 1573187.0 |
| 2020-01-21 | NQ | Futures | 10522.75 | 10552.29 | 10454.79 | 10517.88 | 532160.0 |
| 2020-01-21 | YM | Futures | 30750.0 | 30789.9 | 30569.4 | 30643.9 | 238628.0 |
| 2020-01-21 | CL | Futures | 60.87 | 61.3 | 59.18 | 59.87 | 648335.0 |
| 2020-01-21 | GC | Futures | 1915.9 | 1930.0 | 1902.0 | 1916.6 | 462622.0 |
| 2020-01-21 | ZN | Futures | 127.978694 | 128.458769 | 127.963207 | 128.427796 | 1664597.0 |
| 2020-01-21 | A6 | Futures | 0.70583 | 0.70717 | 0.70235 | 0.70266 | 125648.0 |
| 2020-01-21 | AD | Futures | 0.77124 | 0.7725 | 0.77033 | 0.77093 | 73590.0 |
| 2020-01-21 | ALI | Futures | 2196.4 | 2225.77 | 2196.4 | 2212.88 | 92.0 |
| 2020-01-21 | B | Futures | 53.36 | 53.43 | 52.38 | 52.81 | 248555.0 |
| 2020-01-21 | B6 | Futures | 1.3207 | 1.3289 | 1.3167 | 1.3256 | 124405.0 |
| 2020-01-21 | BR | Futures | 0.19498 | 0.19498 | 0.19222 | 0.19299 | 711.0 |
| 2020-01-21 | BTC | Futures | 13218.4 | 13377.5 | 12907.6 | 13263.8 | 7456.0 |
| 2020-01-21 | BZ | Futures | 52.72 | 53.2 | 51.64 | 52.06 | 50484.0 |
| 2020-01-21 | C | Futures | 1896.0 | 1929.0 | 1885.0 | 1927.0 | 10142.0 |
| 2020-01-21 | CB | Futures | 236.989 | 237.578 | 236.694 | 236.783 | 23.0 |
| 2020-01-21 | CC | Futures | 1834.0 | 1851.0 | 1816.0 | 1843.0 | 22556.0 |
| 2020-01-21 | CNH | Futures | 6.8402 | 6.8828 | 6.8218 | 6.8817 | 1828.0 |
| 2020-01-21 | CSC | Futures | 3.404 | 3.422 | 3.376 | 3.422 | 81.0 |
| 2020-01-21 | CT | Futures | 67.77 | 67.77 | 65.75 | 65.86 | 31895.0 |
| 2020-01-21 | DC | Futures | 28.59 | 28.75 | 28.36 | 28.72 | 359.0 |
| 2020-01-21 | DX | Futures | 94.521 | 94.555 | 94.293 | 94.433 | 11007.0 |
| 2020-01-21 | E1 | Futures | 1.18461 | 1.18678 | 1.1821 | 1.18438 | 26296.0 |
| 2020-01-21 | E6 | Futures | 1.19892 | 1.20183 | 1.19742 | 1.1993 | 242557.0 |
| 2020-01-21 | E7 | Futures | 1.1925 | 1.1955 | 1.1912 | 1.1931 | 3823.0 |
| 2020-01-21 | EBM | Futures | 214.57 | 218.14 | 214.29 | 217.86 | 27901.0 |
| 2020-01-21 | ED | Futures | 95.3132 | 95.3277 | 95.3083 | 95.3229 | 183109.0 |
| 2020-01-21 | ER | Futures | 98.372 | 98.377 | 98.372 | 98.372 | 44795.0 |
| 2020-01-21 | ESG | Futures | 296.63 | 297.25 | 296.63 | 297.25 | 50.0 |
| 2020-01-21 | EW | Futures | 2204.6 | 2209.4 | 2190.5 | 2194.5 | 14440.0 |
| 2020-01-21 | FBON | Futures | 143.16 | 143.43 | 142.98 | 143.4 | 392.0 |
| 2020-01-21 | FBTP | Futures | 128.48 | 128.48 | 127.9 | 128.32 | 90800.0 |
| 2020-01-21 | FBTS | Futures | 108.124 | 108.124 | 108.018 | 108.076 | 38945.0 |
| 2020-01-21 | FCE | Futures | 5478.8 | 5482.9 | 5426.7 | 5477.0 | 83635.0 |
| 2020-01-21 | FDAX | Futures | 14345.8 | 14351.1 | 14206.2 | 14325.7 | 102143.0 |
| 2020-01-21 | FDIV | Futures | 160.33 | 160.89 | 160.33 | 160.89 | 20.0 |
| 2020-01-21 | FDXM | Futures | 14155.8 | 14168.4 | 14027.4 | 14145.9 | 52747.0 |
| 2020-01-21 | FESX | Futures | 3340.0 | 3342.7 | 3303.9 | 3327.7 | 931467.0 |
| 2020-01-21 | FGBL | Futures | 164.05 | 164.54 | 163.86 | 164.49 | 753057.0 |
| 2020-01-21 | FGBM | Futures | 133.52 | 133.65 | 133.44 | 133.63 | 394883.0 |
| 2020-01-21 | FGBS | Futures | 112.608 | 112.619 | 112.588 | 112.613 | 355532.0 |
| 2020-01-21 | FGBX | Futures | 210.27 | 212.17 | 209.97 | 211.98 | 66826.0 |
| 2020-01-21 | FMWO | Futures | 8018.7 | 8043.6 | 7993.7 | 8035.7 | 1588.0 |
| 2020-01-21 | FOAT | Futures | 151.89 | 152.21 | 151.58 | 152.15 | 131224.0 |
| 2020-01-21 | FTDX | Futures | 3165.5 | 3198.1 | 3152.9 | 3183.5 | 139.0 |
| 2020-01-21 | FTI | Futures | 584.57 | 585.14 | 580.35 | 584.87 | 29620.0 |
| 2020-01-21 | FTUK | Futures | 7124.4 | 7124.4 | 7021.7 | 7078.0 | 100166.0 |
| 2020-01-21 | FVSA | Futures | 115.22 | 117.34 | 111.81 | 112.24 | 76963.0 |
| 2020-01-21 | FXXP | Futures | 383.3 | 385.0 | 381.3 | 384.6 | 45802.0 |
| 2020-01-21 | G | Futures | 121.66 | 121.9 | 121.35 | 121.82 | 240212.0 |
> showing 50 of 121 rows — these rows as CSV