PREVIEW / futures_daily / 2019-02-28
file: by_date/futures_daily/2019/2019-02-28.parquet size: 10 KB rows: 116
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-02-28 | ES | Futures | 3026.33 | 3026.87 | 3011.72 | 3014.96 | 1360457.0 |
| 2019-02-28 | NQ | Futures | 8244.65 | 8255.65 | 8188.21 | 8222.94 | 360883.0 |
| 2019-02-28 | YM | Futures | 27453.6 | 27453.6 | 27295.3 | 27332.3 | 179959.0 |
| 2019-02-28 | CL | Futures | 58.92 | 59.37 | 58.33 | 59.15 | 496678.0 |
| 2019-02-28 | GC | Futures | 1652.1 | 1661.1 | 1642.5 | 1645.1 | 252235.0 |
| 2019-02-28 | ZN | Futures | 121.502606 | 121.673781 | 121.113574 | 121.253626 | 280819.0 |
| 2019-02-28 | A6 | Futures | 0.7359 | 0.73858 | 0.73064 | 0.73095 | 117006.0 |
| 2019-02-28 | AD | Futures | 0.77012 | 0.77083 | 0.76683 | 0.77073 | 70915.0 |
| 2019-02-28 | B | Futures | 48.25 | 48.44 | 47.8 | 48.1 | 257536.0 |
| 2019-02-28 | B6 | Futures | 1.3678 | 1.3688 | 1.3619 | 1.3633 | 135157.0 |
| 2019-02-28 | BR | Futures | 0.21241 | 0.21281 | 0.21201 | 0.21245 | 102.0 |
| 2019-02-28 | BTC | Futures | 5788.1 | 5957.2 | 5757.3 | 5826.5 | 6752.0 |
| 2019-02-28 | BZ | Futures | 47.85 | 48.05 | 47.43 | 47.71 | 28959.0 |
| 2019-02-28 | C | Futures | 1531.0 | 1531.0 | 1492.0 | 1496.0 | 9840.0 |
| 2019-02-28 | CB | Futures | 276.63 | 277.228 | 276.63 | 277.228 | 34.0 |
| 2019-02-28 | CC | Futures | 1556.0 | 1563.0 | 1507.0 | 1517.0 | 23800.0 |
| 2019-02-28 | CNH | Futures | 6.6908 | 6.711 | 6.6878 | 6.711 | 748.0 |
| 2019-02-28 | CSC | Futures | 2.824 | 2.835 | 2.801 | 2.812 | 26.0 |
| 2019-02-28 | CT | Futures | 76.61 | 77.64 | 76.49 | 77.31 | 12670.0 |
| 2019-02-28 | DC | Futures | 23.77 | 24.08 | 23.77 | 23.86 | 77.0 |
| 2019-02-28 | DX | Futures | 91.56 | 91.741 | 91.283 | 91.596 | 22309.0 |
| 2019-02-28 | E1 | Futures | 1.17619 | 1.18618 | 1.17619 | 1.18019 | 36176.0 |
| 2019-02-28 | E6 | Futures | 1.25812 | 1.26365 | 1.2568 | 1.25889 | 201724.0 |
| 2019-02-28 | E7 | Futures | 1.2525 | 1.2573 | 1.2506 | 1.2528 | 4788.0 |
| 2019-02-28 | EBM | Futures | 199.46 | 200.49 | 198.43 | 198.69 | 7474.0 |
| 2019-02-28 | ED | Futures | 95.1062 | 95.1111 | 95.1038 | 95.1062 | 223619.0 |
| 2019-02-28 | ER | Futures | 98.406 | 98.411 | 98.406 | 98.411 | 19129.0 |
| 2019-02-28 | EW | Futures | 2045.6 | 2046.1 | 2031.4 | 2034.6 | 13402.0 |
| 2019-02-28 | FBON | Futures | 132.76 | 132.93 | 132.57 | 132.7 | 866.0 |
| 2019-02-28 | FBTP | Futures | 111.91 | 112.34 | 111.81 | 112.19 | 156103.0 |
| 2019-02-28 | FBTS | Futures | 105.228 | 105.36 | 105.171 | 105.323 | 57176.0 |
| 2019-02-28 | FCE | Futures | 4650.0 | 4681.2 | 4640.2 | 4673.6 | 67857.0 |
| 2019-02-28 | FDAX | Futures | 12081.1 | 12124.8 | 11976.6 | 12105.8 | 102087.0 |
| 2019-02-28 | FDIV | Futures | 141.68 | 142.27 | 141.68 | 142.27 | 8.0 |
| 2019-02-28 | FDXM | Futures | 12043.8 | 12095.2 | 11946.4 | 12076.3 | 48782.0 |
| 2019-02-28 | FESX | Futures | 2806.4 | 2820.9 | 2790.2 | 2818.4 | 1049319.0 |
| 2019-02-28 | FGBL | Futures | 157.56 | 157.8 | 157.03 | 157.18 | 999710.0 |
| 2019-02-28 | FGBM | Futures | 132.21 | 132.31 | 132.03 | 132.11 | 631049.0 |
| 2019-02-28 | FGBS | Futures | 112.623 | 112.648 | 112.593 | 112.608 | 624826.0 |
| 2019-02-28 | FGBX | Futures | 187.59 | 188.49 | 186.33 | 186.7 | 65622.0 |
| 2019-02-28 | FMWO | Futures | 7027.2 | 7028.4 | 6998.1 | 7021.4 | 1886.0 |
| 2019-02-28 | FOAT | Futures | 143.48 | 143.55 | 143.07 | 143.23 | 256731.0 |
| 2019-02-28 | FTDX | Futures | 2570.2 | 2586.1 | 2553.3 | 2585.1 | 92.0 |
| 2019-02-28 | FTI | Futures | 506.36 | 508.84 | 504.29 | 508.02 | 23052.0 |
| 2019-02-28 | FTUK | Futures | 6445.2 | 6454.8 | 6400.6 | 6444.8 | 134870.0 |
| 2019-02-28 | FVSA | Futures | 276.12 | 276.12 | 260.39 | 262.14 | 21121.0 |
| 2019-02-28 | FXXP | Futures | 325.9 | 327.4 | 325.0 | 327.2 | 42057.0 |
| 2019-02-28 | G | Futures | 116.41 | 116.52 | 115.87 | 116.0 | 267389.0 |
| 2019-02-28 | GF | Futures | 313.923 | 313.978 | 311.299 | 312.447 | 4536.0 |
| 2019-02-28 | GSCI | Futures | 488.3 | 488.48 | 486.59 | 486.99 | 32.0 |
> showing 50 of 116 rows — these rows as CSV