PREVIEW / futures_daily / 2019-05-29
file: by_date/futures_daily/2019/2019-05-29.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 |
|---|---|---|---|---|---|---|---|
| 2019-05-29 | ES | Futures | 3029.08 | 3030.97 | 2988.03 | 3002.89 | 2087458.0 |
| 2019-05-29 | NQ | Futures | 8401.3 | 8406.49 | 8276.57 | 8314.31 | 568052.0 |
| 2019-05-29 | YM | Futures | 26763.6 | 26786.9 | 26322.4 | 26504.0 | 300809.0 |
| 2019-05-29 | CL | Futures | 60.63 | 60.7 | 58.38 | 60.36 | 1124959.0 |
| 2019-05-29 | GC | Futures | 1598.5 | 1605.9 | 1597.8 | 1601.0 | 201244.0 |
| 2019-05-29 | ZN | Futures | 124.719868 | 125.154973 | 124.65771 | 124.937421 | 3176520.0 |
| 2019-05-29 | A6 | Futures | 0.71426 | 0.71498 | 0.71209 | 0.71302 | 80472.0 |
| 2019-05-29 | AD | Futures | 0.74958 | 0.75029 | 0.7466 | 0.74801 | 89303.0 |
| 2019-05-29 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-05-29 | B | Futures | 51.0 | 51.08 | 49.63 | 50.52 | 377686.0 |
| 2019-05-29 | B6 | Futures | 1.2974 | 1.2992 | 1.293 | 1.2942 | 96197.0 |
| 2019-05-29 | BR | Futures | 0.19732 | 0.19892 | 0.19732 | 0.19892 | 1612.0 |
| 2019-05-29 | BTC | Futures | 13537.9 | 13553.3 | 13000.1 | 13453.4 | 1876.0 |
| 2019-05-29 | BZ | Futures | 50.45 | 50.45 | 48.98 | 49.87 | 50362.0 |
| 2019-05-29 | C | Futures | 1741.0 | 1748.0 | 1717.0 | 1731.0 | 7222.0 |
| 2019-05-29 | CB | Futures | 284.568 | 284.568 | 284.51 | 284.51 | 23.0 |
| 2019-05-29 | CC | Futures | 1651.0 | 1665.0 | 1621.0 | 1641.0 | 17985.0 |
| 2019-05-29 | CNH | Futures | 6.9324 | 6.9496 | 6.9323 | 6.9452 | 694.0 |
| 2019-05-29 | CSC | Futures | 2.956 | 2.978 | 2.956 | 2.978 | 38.0 |
| 2019-05-29 | CT | Futures | 72.92 | 73.07 | 71.82 | 72.29 | 14394.0 |
| 2019-05-29 | DC | Futures | 24.86 | 25.1 | 24.85 | 25.07 | 120.0 |
| 2019-05-29 | DX | Futures | 93.738 | 94.031 | 93.695 | 93.968 | 12410.0 |
| 2019-05-29 | E1 | Futures | 1.16026 | 1.16294 | 1.15862 | 1.15967 | 20125.0 |
| 2019-05-29 | E6 | Futures | 1.22734 | 1.22811 | 1.22279 | 1.22383 | 183465.0 |
| 2019-05-29 | E7 | Futures | 1.2214 | 1.222 | 1.2168 | 1.2178 | 3276.0 |
| 2019-05-29 | EBM | Futures | 215.63 | 218.79 | 209.0 | 212.17 | 53852.0 |
| 2019-05-29 | ED | Futures | 95.1868 | 95.199 | 95.1868 | 95.1941 | 294510.0 |
| 2019-05-29 | ER | Futures | 98.426 | 98.43 | 98.421 | 98.426 | 47244.0 |
| 2019-05-29 | EW | Futures | 1958.4 | 1959.7 | 1931.3 | 1944.4 | 15509.0 |
| 2019-05-29 | FBON | Futures | 138.87 | 139.52 | 138.87 | 139.44 | 1502.0 |
| 2019-05-29 | FBTP | Futures | 114.93 | 115.68 | 114.73 | 115.48 | 114774.0 |
| 2019-05-29 | FBTS | Futures | 105.551 | 105.779 | 105.512 | 105.712 | 79174.0 |
| 2019-05-29 | FCE | Futures | 4761.2 | 4765.3 | 4703.6 | 4720.8 | 101633.0 |
| 2019-05-29 | FDAX | Futures | 12571.7 | 12587.4 | 12427.4 | 12460.6 | 140287.0 |
| 2019-05-29 | FDIV | Futures | 142.05 | 142.05 | 141.45 | 141.64 | 77.0 |
| 2019-05-29 | FDXM | Futures | 12477.3 | 12479.4 | 12319.7 | 12352.6 | 55439.0 |
| 2019-05-29 | FESX | Futures | 2898.1 | 2900.7 | 2867.5 | 2873.6 | 1154036.0 |
| 2019-05-29 | FGBL | Futures | 162.06 | 162.27 | 162.0 | 162.16 | 843692.0 |
| 2019-05-29 | FGBM | Futures | 133.83 | 133.86 | 133.78 | 133.83 | 486673.0 |
| 2019-05-29 | FGBS | Futures | 112.895 | 112.905 | 112.885 | 112.895 | 385243.0 |
| 2019-05-29 | FGBX | Futures | 199.97 | 200.93 | 199.93 | 200.52 | 158927.0 |
| 2019-05-29 | FMWO | Futures | 6961.6 | 6970.8 | 6901.4 | 6923.4 | 1979.0 |
| 2019-05-29 | FOAT | Futures | 148.39 | 148.64 | 148.32 | 148.55 | 268059.0 |
| 2019-05-29 | FTDX | Futures | 2816.7 | 2816.7 | 2727.4 | 2751.6 | 436.0 |
| 2019-05-29 | FTI | Futures | 514.47 | 514.8 | 508.33 | 509.82 | 34083.0 |
| 2019-05-29 | FTUK | Futures | 6636.7 | 6636.7 | 6545.0 | 6571.1 | 106594.0 |
| 2019-05-29 | FVSA | Futures | 236.66 | 244.5 | 235.23 | 240.94 | 42910.0 |
| 2019-05-29 | FXXP | Futures | 333.5 | 333.7 | 330.0 | 330.9 | 67209.0 |
| 2019-05-29 | G | Futures | 119.07 | 119.28 | 118.97 | 119.11 | 189644.0 |
| 2019-05-29 | GF | Futures | 276.894 | 280.672 | 274.981 | 280.083 | 8865.0 |
> showing 50 of 120 rows — these rows as CSV