PREVIEW / futures_daily / 2020-05-20
file: by_date/futures_daily/2020/2020-05-20.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-20 | ES | Futures | 3223.75 | 3292.62 | 3218.21 | 3284.6 | 1532404.0 |
| 2020-05-20 | NQ | Futures | 10650.14 | 10888.89 | 10630.94 | 10874.56 | 369922.0 |
| 2020-05-20 | YM | Futures | 25742.7 | 26231.4 | 25690.4 | 26163.1 | 192898.0 |
| 2020-05-20 | CL | Futures | 23.12 | 24.49 | 22.88 | 24.28 | 406431.0 |
| 2020-05-20 | GC | Futures | 2121.3 | 2131.5 | 2115.0 | 2124.8 | 184460.0 |
| 2020-05-20 | ZN | Futures | 137.361612 | 137.469661 | 137.099206 | 137.392483 | 1199320.0 |
| 2020-05-20 | A6 | Futures | 0.67117 | 0.6798 | 0.67045 | 0.67816 | 84267.0 |
| 2020-05-20 | AD | Futures | 0.72637 | 0.73073 | 0.72592 | 0.72951 | 50649.0 |
| 2020-05-20 | ALI | Futures | 1785.65 | 1821.6 | 1784.47 | 1817.44 | 211.0 |
| 2020-05-20 | B | Futures | 22.75 | 24.08 | 22.7 | 23.61 | 191265.0 |
| 2020-05-20 | B6 | Futures | 1.2429 | 1.2475 | 1.2407 | 1.2415 | 64779.0 |
| 2020-05-20 | BR | Futures | 0.14235 | 0.1444 | 0.14222 | 0.14415 | 4663.0 |
| 2020-05-20 | BTC | Futures | 13567.5 | 13762.3 | 12976.4 | 13310.2 | 6276.0 |
| 2020-05-20 | BZ | Futures | 22.01 | 23.27 | 21.97 | 22.86 | 25571.0 |
| 2020-05-20 | C | Futures | 1881.0 | 1899.0 | 1871.0 | 1874.0 | 4296.0 |
| 2020-05-20 | CB | Futures | 187.932 | 190.274 | 187.932 | 187.96 | 22.0 |
| 2020-05-20 | CC | Futures | 1588.0 | 1608.0 | 1564.0 | 1569.0 | 11534.0 |
| 2020-05-20 | CNH | Futures | 7.0582 | 7.0586 | 7.0397 | 7.0438 | 155.0 |
| 2020-05-20 | CSC | Futures | 3.356 | 3.477 | 3.356 | 3.411 | 257.0 |
| 2020-05-20 | CT | Futures | 57.89 | 58.34 | 56.63 | 56.74 | 14289.0 |
| 2020-05-20 | DC | Futures | 27.47 | 28.63 | 27.47 | 28.17 | 948.0 |
| 2020-05-20 | DX | Futures | 96.272 | 96.282 | 95.735 | 95.861 | 13167.0 |
| 2020-05-20 | E1 | Futures | 1.17281 | 1.18237 | 1.17269 | 1.18146 | 20868.0 |
| 2020-05-20 | E6 | Futures | 1.17456 | 1.18278 | 1.17408 | 1.18133 | 133456.0 |
| 2020-05-20 | E7 | Futures | 1.1681 | 1.1767 | 1.168 | 1.1752 | 4976.0 |
| 2020-05-20 | EBM | Futures | 220.95 | 225.44 | 220.65 | 225.14 | 21391.0 |
| 2020-05-20 | ED | Futures | 96.3847 | 96.4065 | 96.375 | 96.4016 | 281694.0 |
| 2020-05-20 | ER | Futures | 98.274 | 98.289 | 98.274 | 98.284 | 50470.0 |
| 2020-05-20 | ESG | Futures | 268.22 | 268.84 | 268.22 | 268.73 | 25.0 |
| 2020-05-20 | EW | Futures | 1745.0 | 1797.9 | 1742.6 | 1786.0 | 9384.0 |
| 2020-05-20 | FBON | Futures | 141.6 | 141.6 | 141.08 | 141.43 | 842.0 |
| 2020-05-20 | FBTP | Futures | 125.24 | 125.54 | 124.77 | 125.32 | 85819.0 |
| 2020-05-20 | FBTS | Futures | 107.306 | 107.422 | 107.229 | 107.355 | 52261.0 |
| 2020-05-20 | FCE | Futures | 4302.8 | 4365.5 | 4258.7 | 4358.2 | 61364.0 |
| 2020-05-20 | FDAX | Futures | 11632.0 | 11894.8 | 11605.5 | 11891.6 | 71751.0 |
| 2020-05-20 | FDIV | Futures | 124.56 | 125.96 | 124.56 | 125.96 | 152.0 |
| 2020-05-20 | FDXM | Futures | 11688.6 | 11951.1 | 11662.0 | 11948.4 | 66623.0 |
| 2020-05-20 | FESX | Futures | 2635.1 | 2694.7 | 2627.7 | 2693.8 | 1065590.0 |
| 2020-05-20 | FEU3 | Futures | 99.021 | 99.03 | 99.021 | 99.021 | 2.0 |
| 2020-05-20 | FGBL | Futures | 167.93 | 168.13 | 167.69 | 167.89 | 548068.0 |
| 2020-05-20 | FGBM | Futures | 134.61 | 134.67 | 134.49 | 134.59 | 400603.0 |
| 2020-05-20 | FGBS | Futures | 112.78 | 112.805 | 112.764 | 112.79 | 328608.0 |
| 2020-05-20 | FGBX | Futures | 226.57 | 227.46 | 225.93 | 226.67 | 41862.0 |
| 2020-05-20 | FMWO | Futures | 7183.3 | 7290.3 | 7172.7 | 7286.8 | 4829.0 |
| 2020-05-20 | FOAT | Futures | 152.75 | 153.09 | 152.52 | 152.96 | 130231.0 |
| 2020-05-20 | FTDX | Futures | 3076.0 | 3142.8 | 3076.0 | 3138.2 | 174.0 |
| 2020-05-20 | FTI | Futures | 481.81 | 494.34 | 480.97 | 494.0 | 24639.0 |
| 2020-05-20 | FTUK | Futures | 5601.2 | 5725.2 | 5598.9 | 5720.5 | 105195.0 |
| 2020-05-20 | FVSA | Futures | 279.13 | 280.49 | 257.87 | 259.68 | 24742.0 |
| 2020-05-20 | FXXP | Futures | 312.4 | 317.4 | 311.1 | 317.2 | 77644.0 |
> showing 50 of 120 rows — these rows as CSV