PREVIEW / futures_daily / 2020-01-29
file: by_date/futures_daily/2020/2020-01-29.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-01-29 | ES | Futures | 3544.34 | 3556.22 | 3526.51 | 3534.35 | 1665382.0 |
| 2020-01-29 | NQ | Futures | 10460.24 | 10505.26 | 10406.04 | 10436.15 | 578408.0 |
| 2020-01-29 | YM | Futures | 30178.7 | 30338.3 | 30088.4 | 30151.4 | 235907.0 |
| 2020-01-29 | CL | Futures | 55.35 | 55.76 | 54.16 | 54.69 | 624979.0 |
| 2020-01-29 | GC | Futures | 1916.7 | 1930.1 | 1911.7 | 1921.5 | 238019.0 |
| 2020-01-29 | ZN | Futures | 129.356973 | 129.991911 | 129.264056 | 129.852535 | 1757332.0 |
| 2020-01-29 | A6 | Futures | 0.69363 | 0.69538 | 0.69117 | 0.69374 | 104224.0 |
| 2020-01-29 | AD | Futures | 0.76579 | 0.76579 | 0.76282 | 0.76378 | 56884.0 |
| 2020-01-29 | ALI | Futures | 2118.16 | 2119.35 | 2106.76 | 2112.16 | 20.0 |
| 2020-01-29 | B | Futures | 48.92 | 49.6 | 48.39 | 48.83 | 324985.0 |
| 2020-01-29 | B6 | Futures | 1.323 | 1.323 | 1.319 | 1.3226 | 61986.0 |
| 2020-01-29 | BR | Futures | 0.19291 | 0.19368 | 0.19125 | 0.19206 | 9006.0 |
| 2020-01-29 | BTC | Futures | 13940.8 | 14413.5 | 13888.3 | 14293.5 | 1328.0 |
| 2020-01-29 | BZ | Futures | 48.36 | 48.86 | 47.67 | 48.11 | 47388.0 |
| 2020-01-29 | C | Futures | 1837.0 | 1868.0 | 1830.0 | 1857.0 | 9488.0 |
| 2020-01-29 | CB | Futures | 229.443 | 229.443 | 227.468 | 228.234 | 68.0 |
| 2020-01-29 | CC | Futures | 1768.0 | 1794.0 | 1749.0 | 1784.0 | 16992.0 |
| 2020-01-29 | CNH | Futures | 6.9406 | 6.9406 | 6.9252 | 6.937 | 375.0 |
| 2020-01-29 | CSC | Futures | 3.465 | 3.495 | 3.463 | 3.489 | 91.0 |
| 2020-01-29 | CT | Futures | 66.96 | 67.46 | 66.46 | 66.64 | 13506.0 |
| 2020-01-29 | DC | Futures | 28.57 | 29.17 | 28.57 | 29.08 | 295.0 |
| 2020-01-29 | DX | Futures | 94.905 | 95.123 | 94.885 | 94.943 | 10092.0 |
| 2020-01-29 | E1 | Futures | 1.17776 | 1.17821 | 1.1733 | 1.17741 | 24468.0 |
| 2020-01-29 | E6 | Futures | 1.19068 | 1.19149 | 1.18761 | 1.19052 | 162183.0 |
| 2020-01-29 | E7 | Futures | 1.1845 | 1.1852 | 1.1813 | 1.1843 | 1802.0 |
| 2020-01-29 | EBM | Futures | 213.47 | 213.74 | 210.99 | 211.54 | 25958.0 |
| 2020-01-29 | ED | Futures | 95.3471 | 95.352 | 95.3229 | 95.3471 | 288751.0 |
| 2020-01-29 | ER | Futures | 98.391 | 98.396 | 98.386 | 98.391 | 113636.0 |
| 2020-01-29 | ESG | Futures | 293.74 | 293.91 | 292.07 | 292.15 | 213.0 |
| 2020-01-29 | EW | Futures | 2169.7 | 2175.4 | 2152.4 | 2154.7 | 12502.0 |
| 2020-01-29 | FBON | Futures | 144.88 | 145.06 | 144.83 | 145.03 | 408.0 |
| 2020-01-29 | FBTP | Futures | 131.71 | 132.51 | 131.71 | 132.4 | 98592.0 |
| 2020-01-29 | FBTS | Futures | 108.538 | 108.644 | 108.519 | 108.615 | 74441.0 |
| 2020-01-29 | FCE | Futures | 5368.3 | 5409.5 | 5359.2 | 5394.5 | 70112.0 |
| 2020-01-29 | FDAX | Futures | 14075.1 | 14142.8 | 14042.3 | 14117.4 | 86503.0 |
| 2020-01-29 | FDXM | Futures | 13891.6 | 13965.8 | 13866.6 | 13940.2 | 50162.0 |
| 2020-01-29 | FESX | Futures | 3265.1 | 3291.6 | 3257.2 | 3285.4 | 915340.0 |
| 2020-01-29 | FGBL | Futures | 165.87 | 166.46 | 165.63 | 166.25 | 628557.0 |
| 2020-01-29 | FGBM | Futures | 134.06 | 134.25 | 134.01 | 134.18 | 373970.0 |
| 2020-01-29 | FGBS | Futures | 112.694 | 112.734 | 112.684 | 112.724 | 264266.0 |
| 2020-01-29 | FGBX | Futures | 215.83 | 217.96 | 215.33 | 217.38 | 57077.0 |
| 2020-01-29 | FMWO | Futures | 7929.1 | 7941.5 | 7900.7 | 7929.1 | 2894.0 |
| 2020-01-29 | FOAT | Futures | 153.41 | 153.87 | 153.38 | 153.8 | 122430.0 |
| 2020-01-29 | FTDX | Futures | 3175.0 | 3184.0 | 3167.0 | 3173.5 | 53.0 |
| 2020-01-29 | FTI | Futures | 576.9 | 579.87 | 575.7 | 578.49 | 28185.0 |
| 2020-01-29 | FTUK | Futures | 6956.5 | 6989.3 | 6938.7 | 6966.4 | 70791.0 |
| 2020-01-29 | FVSA | Futures | 124.57 | 126.27 | 121.17 | 122.44 | 21723.0 |
| 2020-01-29 | FXXP | Futures | 379.8 | 381.8 | 379.5 | 381.2 | 58477.0 |
| 2020-01-29 | G | Futures | 122.84 | 123.15 | 122.73 | 123.04 | 185863.0 |
| 2020-01-29 | GF | Futures | 286.89 | 287.788 | 284.303 | 285.148 | 5916.0 |
> showing 50 of 119 rows — these rows as CSV