PREVIEW / futures_daily / 2020-02-04
file: by_date/futures_daily/2020/2020-02-04.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-02-04 | ES | Futures | 3503.83 | 3569.72 | 3494.92 | 3563.51 | 1698403.0 |
| 2020-02-04 | NQ | Futures | 10436.73 | 10746.71 | 10406.9 | 10730.36 | 563913.0 |
| 2020-02-04 | YM | Futures | 29790.1 | 30295.3 | 29707.1 | 30234.4 | 222741.0 |
| 2020-02-04 | CL | Futures | 51.22 | 52.87 | 50.57 | 50.88 | 859357.0 |
| 2020-02-04 | GC | Futures | 1928.3 | 1931.9 | 1893.3 | 1896.6 | 349002.0 |
| 2020-02-04 | ZN | Futures | 130.379068 | 130.471986 | 129.589268 | 129.728644 | 2200574.0 |
| 2020-02-04 | A6 | Futures | 0.68625 | 0.69169 | 0.68523 | 0.69117 | 131948.0 |
| 2020-02-04 | AD | Futures | 0.75793 | 0.7597 | 0.75753 | 0.75844 | 86275.0 |
| 2020-02-04 | ALI | Futures | 2070.49 | 2083.98 | 2060.0 | 2060.0 | 170.0 |
| 2020-02-04 | B | Futures | 45.03 | 46.12 | 44.5 | 44.72 | 409857.0 |
| 2020-02-04 | B6 | Futures | 1.3194 | 1.3246 | 1.3137 | 1.3236 | 112144.0 |
| 2020-02-04 | BR | Futures | 0.19088 | 0.19299 | 0.19007 | 0.1906 | 6666.0 |
| 2020-02-04 | BTC | Futures | 14038.4 | 14165.9 | 13700.7 | 13888.3 | 8189.0 |
| 2020-02-04 | BZ | Futures | 44.22 | 45.44 | 43.84 | 44.06 | 52393.0 |
| 2020-02-04 | C | Futures | 1835.0 | 1844.0 | 1818.0 | 1833.0 | 7427.0 |
| 2020-02-04 | CB | Futures | 235.751 | 236.223 | 232.862 | 235.81 | 34.0 |
| 2020-02-04 | CC | Futures | 1799.0 | 1831.0 | 1795.0 | 1821.0 | 26609.0 |
| 2020-02-04 | CNH | Futures | 6.9874 | 6.996 | 6.9588 | 6.9609 | 580.0 |
| 2020-02-04 | CSC | Futures | 3.377 | 3.394 | 3.327 | 3.359 | 148.0 |
| 2020-02-04 | CT | Futures | 63.59 | 64.9 | 63.59 | 64.06 | 36866.0 |
| 2020-02-04 | DC | Futures | 27.91 | 28.3 | 27.65 | 27.98 | 1009.0 |
| 2020-02-04 | DX | Futures | 94.774 | 94.977 | 94.764 | 94.933 | 11601.0 |
| 2020-02-04 | E1 | Futures | 1.18598 | 1.18621 | 1.18027 | 1.1813 | 24583.0 |
| 2020-02-04 | E6 | Futures | 1.19445 | 1.19494 | 1.19155 | 1.19257 | 145542.0 |
| 2020-02-04 | E7 | Futures | 1.1885 | 1.1887 | 1.1854 | 1.1863 | 2470.0 |
| 2020-02-04 | EBM | Futures | 209.35 | 210.99 | 209.35 | 209.62 | 17894.0 |
| 2020-02-04 | ED | Futures | 95.3859 | 95.3956 | 95.3617 | 95.3665 | 245259.0 |
| 2020-02-04 | ER | Futures | 98.396 | 98.396 | 98.382 | 98.396 | 130787.0 |
| 2020-02-04 | ESG | Futures | 293.83 | 295.38 | 293.83 | 295.38 | 4.0 |
| 2020-02-04 | EW | Futures | 2133.1 | 2174.1 | 2131.3 | 2164.9 | 13766.0 |
| 2020-02-04 | FBON | Futures | 145.73 | 145.73 | 145.24 | 145.43 | 400.0 |
| 2020-02-04 | FBTP | Futures | 132.41 | 132.61 | 132.23 | 132.54 | 93231.0 |
| 2020-02-04 | FBTS | Futures | 108.624 | 108.692 | 108.605 | 108.644 | 46516.0 |
| 2020-02-04 | FCE | Futures | 5324.3 | 5380.0 | 5306.2 | 5378.7 | 76561.0 |
| 2020-02-04 | FDAX | Futures | 13793.3 | 14056.6 | 13762.1 | 14037.5 | 98352.0 |
| 2020-02-04 | FDIV | Futures | 155.42 | 155.83 | 155.42 | 155.83 | 90.0 |
| 2020-02-04 | FDXM | Futures | 13614.9 | 13880.1 | 13588.8 | 13861.3 | 57700.0 |
| 2020-02-04 | FESX | Futures | 3214.9 | 3281.9 | 3208.8 | 3278.4 | 1146304.0 |
| 2020-02-04 | FGBL | Futures | 167.21 | 167.22 | 166.44 | 166.7 | 838247.0 |
| 2020-02-04 | FGBM | Futures | 134.52 | 134.53 | 134.29 | 134.38 | 462059.0 |
| 2020-02-04 | FGBS | Futures | 112.8 | 112.8 | 112.734 | 112.754 | 344095.0 |
| 2020-02-04 | FGBX | Futures | 220.22 | 220.28 | 217.65 | 218.55 | 71865.0 |
| 2020-02-04 | FMWO | Futures | 7838.3 | 7964.2 | 7838.3 | 7955.1 | 5234.0 |
| 2020-02-04 | FOAT | Futures | 154.33 | 154.44 | 153.95 | 154.16 | 153928.0 |
| 2020-02-04 | FTDX | Futures | 3099.1 | 3137.3 | 3099.1 | 3137.3 | 82.0 |
| 2020-02-04 | FTI | Futures | 570.14 | 579.25 | 569.33 | 578.7 | 32963.0 |
| 2020-02-04 | FTUK | Futures | 6811.6 | 6922.3 | 6811.6 | 6919.0 | 107083.0 |
| 2020-02-04 | FVSA | Futures | 128.82 | 128.82 | 122.02 | 123.29 | 31614.0 |
| 2020-02-04 | FXXP | Futures | 375.7 | 380.5 | 375.6 | 380.3 | 65718.0 |
| 2020-02-04 | G | Futures | 122.87 | 122.99 | 122.45 | 122.67 | 222163.0 |
> showing 50 of 119 rows — these rows as CSV