PREVIEW / futures_daily / 2020-04-28
file: by_date/futures_daily/2020/2020-04-28.parquet size: 10 KB rows: 120
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-04-28 | ES | Futures | 3173.12 | 3223.75 | 3154.59 | 3172.57 | 1614021.0 |
| 2020-04-28 | NQ | Futures | 10110.45 | 10255.76 | 9921.86 | 9996.67 | 440939.0 |
| 2020-04-28 | YM | Futures | 25625.3 | 26073.4 | 25479.1 | 25657.3 | 192238.0 |
| 2020-04-28 | CL | Futures | 9.65 | 10.19 | 7.5 | 9.19 | 897087.0 |
| 2020-04-28 | GC | Futures | 2091.2 | 2100.3 | 2066.6 | 2088.6 | 171343.0 |
| 2020-04-28 | ZN | Futures | 136.94485 | 137.423354 | 136.852236 | 137.33074 | 989863.0 |
| 2020-04-28 | A6 | Futures | 0.66429 | 0.66932 | 0.6611 | 0.66788 | 65805.0 |
| 2020-04-28 | AD | Futures | 0.72262 | 0.72728 | 0.72019 | 0.72465 | 57044.0 |
| 2020-04-28 | ALI | Futures | 1828.7 | 1831.69 | 1823.62 | 1823.62 | 35.0 |
| 2020-04-28 | B | Futures | 15.07 | 15.71 | 14.47 | 15.02 | 324976.0 |
| 2020-04-28 | B6 | Futures | 1.2618 | 1.2712 | 1.2594 | 1.2624 | 59434.0 |
| 2020-04-28 | BR | Futures | 0.14452 | 0.14927 | 0.14337 | 0.14833 | 7273.0 |
| 2020-04-28 | BTC | Futures | 10911.1 | 10952.8 | 10758.1 | 10820.7 | 1762.0 |
| 2020-04-28 | BZ | Futures | 14.65 | 15.22 | 14.02 | 14.54 | 33699.0 |
| 2020-04-28 | C | Futures | 1827.0 | 1829.0 | 1790.0 | 1794.0 | 2151.0 |
| 2020-04-28 | CB | Futures | 139.36 | 139.36 | 138.858 | 138.858 | 35.0 |
| 2020-04-28 | CC | Futures | 1520.0 | 1557.0 | 1517.0 | 1530.0 | 11417.0 |
| 2020-04-28 | CNH | Futures | 7.0322 | 7.0372 | 7.0132 | 7.0201 | 216.0 |
| 2020-04-28 | CSC | Futures | 2.413 | 2.472 | 2.369 | 2.376 | 175.0 |
| 2020-04-28 | CT | Futures | 53.72 | 55.55 | 53.17 | 54.37 | 16216.0 |
| 2020-04-28 | DC | Futures | 19.08 | 19.96 | 19.04 | 19.28 | 505.0 |
| 2020-04-28 | DX | Futures | 96.847 | 96.983 | 96.2 | 96.634 | 13656.0 |
| 2020-04-28 | E1 | Futures | 1.1695 | 1.17315 | 1.16369 | 1.17076 | 19372.0 |
| 2020-04-28 | E6 | Futures | 1.16521 | 1.17155 | 1.16295 | 1.1658 | 130730.0 |
| 2020-04-28 | E7 | Futures | 1.1592 | 1.1654 | 1.1569 | 1.1597 | 6322.0 |
| 2020-04-28 | EBM | Futures | 219.49 | 221.45 | 218.65 | 219.77 | 11142.0 |
| 2020-04-28 | ED | Futures | 96.3098 | 96.3436 | 96.3049 | 96.3339 | 341182.0 |
| 2020-04-28 | ER | Futures | 98.244 | 98.298 | 98.244 | 98.284 | 122838.0 |
| 2020-04-28 | ESG | Futures | 262.21 | 262.34 | 257.76 | 257.76 | 679.0 |
| 2020-04-28 | EW | Futures | 1705.3 | 1759.1 | 1693.5 | 1722.0 | 12934.0 |
| 2020-04-28 | FBON | Futures | 138.66 | 139.18 | 138.5 | 138.99 | 100.0 |
| 2020-04-28 | FBTP | Futures | 123.91 | 124.65 | 123.74 | 124.13 | 68984.0 |
| 2020-04-28 | FBTS | Futures | 106.777 | 106.989 | 106.739 | 106.902 | 66338.0 |
| 2020-04-28 | FCE | Futures | 4340.7 | 4430.8 | 4323.8 | 4398.8 | 35046.0 |
| 2020-04-28 | FDAX | Futures | 11300.9 | 11525.7 | 11242.7 | 11417.3 | 94979.0 |
| 2020-04-28 | FDIV | Futures | 119.97 | 122.57 | 119.97 | 122.52 | 355.0 |
| 2020-04-28 | FDXM | Futures | 11356.0 | 11579.1 | 11298.6 | 11471.8 | 56534.0 |
| 2020-04-28 | FESX | Futures | 2622.2 | 2677.3 | 2603.0 | 2655.3 | 1032097.0 |
| 2020-04-28 | FGBL | Futures | 167.58 | 168.01 | 167.28 | 167.92 | 423808.0 |
| 2020-04-28 | FGBM | Futures | 134.45 | 134.65 | 134.37 | 134.62 | 269017.0 |
| 2020-04-28 | FGBS | Futures | 112.81 | 112.87 | 112.785 | 112.855 | 163215.0 |
| 2020-04-28 | FGBX | Futures | 226.25 | 227.24 | 225.12 | 226.99 | 42417.0 |
| 2020-04-28 | FMWO | Futures | 7002.1 | 7135.1 | 7002.1 | 7048.0 | 2725.0 |
| 2020-04-28 | FOAT | Futures | 152.3 | 152.56 | 151.89 | 152.51 | 92840.0 |
| 2020-04-28 | FTDX | Futures | 2934.5 | 2936.5 | 2877.9 | 2881.9 | 180.0 |
| 2020-04-28 | FTI | Futures | 479.09 | 487.2 | 478.01 | 485.54 | 22977.0 |
| 2020-04-28 | FTUK | Futures | 5510.7 | 5622.4 | 5484.8 | 5597.5 | 88564.0 |
| 2020-04-28 | FVSA | Futures | 305.17 | 307.42 | 288.96 | 296.61 | 20711.0 |
| 2020-04-28 | FXXP | Futures | 308.9 | 315.6 | 308.7 | 313.3 | 60814.0 |
| 2020-04-28 | G | Futures | 125.43 | 125.63 | 125.28 | 125.52 | 177172.0 |
> showing 50 of 120 rows — these rows as CSV