PREVIEW / futures_daily / 2020-06-26
file: by_date/futures_daily/2020/2020-06-26.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-06-26 | ES | Futures | 3456.96 | 3469.06 | 3368.32 | 3384.64 | 2208418.0 |
| 2020-06-26 | NQ | Futures | 11707.37 | 11746.25 | 11402.41 | 11450.29 | 576150.0 |
| 2020-06-26 | YM | Futures | 27371.0 | 27492.1 | 26617.6 | 26738.7 | 262641.0 |
| 2020-06-26 | CL | Futures | 28.34 | 28.53 | 27.4 | 27.9 | 356712.0 |
| 2020-06-26 | GC | Futures | 2130.9 | 2144.5 | 2105.9 | 2137.5 | 201233.0 |
| 2020-06-26 | ZN | Futures | 137.598613 | 138.016705 | 137.583128 | 137.97025 | 924291.0 |
| 2020-06-26 | A6 | Futures | 0.70856 | 0.70948 | 0.70383 | 0.70629 | 69208.0 |
| 2020-06-26 | AD | Futures | 0.74449 | 0.74495 | 0.74018 | 0.74337 | 54648.0 |
| 2020-06-26 | ALI | Futures | 1957.09 | 1961.32 | 1954.37 | 1954.67 | 25.0 |
| 2020-06-26 | B | Futures | 26.98 | 27.24 | 26.24 | 26.67 | 249232.0 |
| 2020-06-26 | B6 | Futures | 1.2612 | 1.2634 | 1.251 | 1.2538 | 75364.0 |
| 2020-06-26 | BR | Futures | 0.14706 | 0.14726 | 0.14421 | 0.14472 | 129.0 |
| 2020-06-26 | BTC | Futures | 13001.6 | 13001.6 | 12492.0 | 12698.6 | 4195.0 |
| 2020-06-26 | BZ | Futures | 26.42 | 26.62 | 25.66 | 26.07 | 26921.0 |
| 2020-06-26 | C | Futures | 1811.0 | 1818.0 | 1703.0 | 1712.0 | 5823.0 |
| 2020-06-26 | CB | Futures | 202.743 | 202.743 | 202.743 | 202.743 | 1.0 |
| 2020-06-26 | CC | Futures | 1565.0 | 1572.0 | 1484.0 | 1493.0 | 21059.0 |
| 2020-06-26 | CNH | Futures | 7.0054 | 7.0111 | 7.0007 | 7.0064 | 39.0 |
| 2020-06-26 | CSC | Futures | 3.671 | 3.716 | 3.589 | 3.603 | 87.0 |
| 2020-06-26 | CT | Futures | 60.43 | 61.29 | 60.35 | 60.94 | 5.0 |
| 2020-06-26 | DC | Futures | 30.36 | 30.63 | 29.52 | 29.81 | 272.0 |
| 2020-06-26 | DX | Futures | 94.019 | 94.338 | 93.922 | 94.086 | 10764.0 |
| 2020-06-26 | E1 | Futures | 1.19968 | 1.20241 | 1.19832 | 1.20138 | 15025.0 |
| 2020-06-26 | E6 | Futures | 1.20564 | 1.20811 | 1.20334 | 1.20677 | 128145.0 |
| 2020-06-26 | E7 | Futures | 1.1999 | 1.2021 | 1.1974 | 1.2008 | 4078.0 |
| 2020-06-26 | EBM | Futures | 212.27 | 212.87 | 210.47 | 211.07 | 14528.0 |
| 2020-06-26 | ED | Futures | 96.3895 | 96.404 | 96.3895 | 96.404 | 135419.0 |
| 2020-06-26 | ER | Futures | 98.362 | 98.377 | 98.362 | 98.377 | 83278.0 |
| 2020-06-26 | ESG | Futures | 276.84 | 276.84 | 271.98 | 272.0 | 84.0 |
| 2020-06-26 | EW | Futures | 1860.3 | 1865.2 | 1818.5 | 1823.4 | 15339.0 |
| 2020-06-26 | FBON | Futures | 144.79 | 145.3 | 144.79 | 145.02 | 288.0 |
| 2020-06-26 | FBTP | Futures | 129.63 | 129.99 | 129.54 | 129.76 | 62638.0 |
| 2020-06-26 | FBTS | Futures | 108.376 | 108.434 | 108.337 | 108.376 | 31965.0 |
| 2020-06-26 | FCE | Futures | 4857.5 | 4884.5 | 4761.0 | 4780.1 | 64930.0 |
| 2020-06-26 | FDAX | Futures | 13039.2 | 13108.8 | 12763.0 | 12814.5 | 97044.0 |
| 2020-06-26 | FDXM | Futures | 12974.7 | 13061.5 | 12718.5 | 12768.3 | 52748.0 |
| 2020-06-26 | FESX | Futures | 2984.4 | 3001.9 | 2926.2 | 2938.2 | 919216.0 |
| 2020-06-26 | FEU3 | Futures | 99.124 | 99.124 | 99.124 | 99.124 | 100.0 |
| 2020-06-26 | FGBL | Futures | 168.53 | 168.92 | 168.47 | 168.83 | 399577.0 |
| 2020-06-26 | FGBM | Futures | 134.89 | 135.02 | 134.87 | 135.0 | 278924.0 |
| 2020-06-26 | FGBS | Futures | 112.795 | 112.835 | 112.79 | 112.83 | 233778.0 |
| 2020-06-26 | FGBX | Futures | 227.32 | 228.27 | 227.1 | 227.92 | 36717.0 |
| 2020-06-26 | FMWO | Futures | 7692.4 | 7735.1 | 7538.4 | 7587.0 | 6211.0 |
| 2020-06-26 | FOAT | Futures | 155.54 | 155.74 | 155.51 | 155.66 | 107304.0 |
| 2020-06-26 | FTDX | Futures | 2994.9 | 3005.6 | 2961.7 | 2966.3 | 2366.0 |
| 2020-06-26 | FTI | Futures | 525.06 | 527.14 | 516.62 | 518.4 | 22731.0 |
| 2020-06-26 | FTUK | Futures | 5832.9 | 5881.6 | 5759.2 | 5798.9 | 90891.0 |
| 2020-06-26 | FVSA | Futures | 285.24 | 302.73 | 277.16 | 298.24 | 10233.0 |
| 2020-06-26 | FXXP | Futures | 333.5 | 334.9 | 327.6 | 329.0 | 46390.0 |
| 2020-06-26 | G | Futures | 127.37 | 127.41 | 127.03 | 127.19 | 141022.0 |
> showing 50 of 119 rows — these rows as CSV