PREVIEW / futures_daily / 2020-05-19
file: by_date/futures_daily/2020/2020-05-19.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-05-19 | ES | Futures | 3258.6 | 3293.18 | 3224.58 | 3229.56 | 1567224.0 |
| 2020-05-19 | NQ | Futures | 10680.52 | 10796.31 | 10643.26 | 10662.75 | 392499.0 |
| 2020-05-19 | YM | Futures | 26120.4 | 26425.6 | 25737.3 | 25777.9 | 235950.0 |
| 2020-05-19 | CL | Futures | 23.48 | 23.86 | 22.57 | 23.17 | 430823.0 |
| 2020-05-19 | GC | Futures | 2103.8 | 2124.2 | 2094.6 | 2116.9 | 185258.0 |
| 2020-05-19 | ZN | Futures | 136.991157 | 137.361612 | 136.898543 | 137.176384 | 1271689.0 |
| 2020-05-19 | A6 | Futures | 0.66973 | 0.67662 | 0.66881 | 0.67466 | 90886.0 |
| 2020-05-19 | AD | Futures | 0.72688 | 0.73083 | 0.72541 | 0.72967 | 57066.0 |
| 2020-05-19 | ALI | Futures | 1793.08 | 1803.48 | 1784.17 | 1793.38 | 129.0 |
| 2020-05-19 | B | Futures | 23.55 | 23.61 | 22.58 | 22.88 | 188927.0 |
| 2020-05-19 | B6 | Futures | 1.2384 | 1.2482 | 1.2369 | 1.2467 | 85840.0 |
| 2020-05-19 | BR | Futures | 0.14313 | 0.14448 | 0.14198 | 0.1428 | 5033.0 |
| 2020-05-19 | BTC | Futures | 13553.6 | 13845.7 | 13219.8 | 13463.2 | 6700.0 |
| 2020-05-19 | BZ | Futures | 22.66 | 22.93 | 21.86 | 22.15 | 24952.0 |
| 2020-05-19 | C | Futures | 1867.0 | 1888.0 | 1862.0 | 1884.0 | 3610.0 |
| 2020-05-19 | CB | Futures | 184.307 | 187.932 | 184.307 | 187.932 | 19.0 |
| 2020-05-19 | CC | Futures | 1569.0 | 1598.0 | 1563.0 | 1591.0 | 7914.0 |
| 2020-05-19 | CNH | Futures | 7.0578 | 7.0659 | 7.0531 | 7.0538 | 194.0 |
| 2020-05-19 | CSC | Futures | 3.247 | 3.365 | 3.247 | 3.346 | 154.0 |
| 2020-05-19 | CT | Futures | 56.53 | 57.99 | 56.46 | 57.71 | 14707.0 |
| 2020-05-19 | DC | Futures | 26.56 | 27.69 | 26.46 | 27.48 | 636.0 |
| 2020-05-19 | DX | Futures | 96.345 | 96.461 | 95.967 | 96.084 | 18179.0 |
| 2020-05-19 | E1 | Futures | 1.17235 | 1.1752 | 1.17144 | 1.17372 | 18175.0 |
| 2020-05-19 | E6 | Futures | 1.17375 | 1.18026 | 1.17236 | 1.17708 | 154098.0 |
| 2020-05-19 | E7 | Futures | 1.1679 | 1.174 | 1.1662 | 1.1709 | 5750.0 |
| 2020-05-19 | EBM | Futures | 220.65 | 222.45 | 219.75 | 221.55 | 10700.0 |
| 2020-05-19 | ED | Futures | 96.3678 | 96.3871 | 96.3581 | 96.3847 | 198088.0 |
| 2020-05-19 | ER | Futures | 98.274 | 98.279 | 98.264 | 98.274 | 72572.0 |
| 2020-05-19 | ESG | Futures | 266.12 | 266.97 | 264.13 | 264.15 | 205.0 |
| 2020-05-19 | EW | Futures | 1772.5 | 1794.2 | 1746.7 | 1748.5 | 12771.0 |
| 2020-05-19 | FBON | Futures | 140.78 | 142.02 | 140.78 | 141.49 | 612.0 |
| 2020-05-19 | FBTP | Futures | 125.25 | 125.83 | 124.84 | 125.27 | 116070.0 |
| 2020-05-19 | FBTS | Futures | 107.364 | 107.528 | 107.278 | 107.345 | 90316.0 |
| 2020-05-19 | FCE | Futures | 4372.8 | 4422.3 | 4275.7 | 4318.9 | 81552.0 |
| 2020-05-19 | FDAX | Futures | 11748.8 | 11877.9 | 11560.6 | 11731.4 | 93994.0 |
| 2020-05-19 | FDIV | Futures | 125.35 | 125.35 | 124.56 | 124.56 | 100.0 |
| 2020-05-19 | FDXM | Futures | 11798.1 | 11933.0 | 11616.3 | 11787.4 | 73982.0 |
| 2020-05-19 | FESX | Futures | 2671.8 | 2703.0 | 2625.0 | 2657.1 | 1238230.0 |
| 2020-05-19 | FGBL | Futures | 167.99 | 168.27 | 167.44 | 167.87 | 685895.0 |
| 2020-05-19 | FGBM | Futures | 134.73 | 134.83 | 134.47 | 134.6 | 508284.0 |
| 2020-05-19 | FGBS | Futures | 112.815 | 112.855 | 112.775 | 112.785 | 488873.0 |
| 2020-05-19 | FGBX | Futures | 225.59 | 226.84 | 224.57 | 226.16 | 48322.0 |
| 2020-05-19 | FMWO | Futures | 7252.7 | 7253.9 | 7145.6 | 7219.8 | 2582.0 |
| 2020-05-19 | FOAT | Futures | 152.74 | 153.06 | 152.46 | 152.76 | 140636.0 |
| 2020-05-19 | FTDX | Futures | 3080.1 | 3085.1 | 3054.3 | 3084.6 | 95.0 |
| 2020-05-19 | FTI | Futures | 485.72 | 489.87 | 479.06 | 484.2 | 28548.0 |
| 2020-05-19 | FTUK | Futures | 5728.1 | 5764.4 | 5592.3 | 5658.3 | 109706.0 |
| 2020-05-19 | FVSA | Futures | 261.49 | 282.75 | 254.7 | 263.3 | 20451.0 |
| 2020-05-19 | FXXP | Futures | 315.0 | 318.8 | 310.5 | 314.1 | 103991.0 |
| 2020-05-19 | G | Futures | 125.85 | 126.23 | 125.44 | 126.01 | 342743.0 |
> showing 50 of 120 rows — these rows as CSV