PREVIEW / futures_daily / 2020-01-13
file: by_date/futures_daily/2020/2020-01-13.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-01-13 | ES | Futures | 3527.05 | 3554.33 | 3526.78 | 3552.98 | 1008998.0 |
| 2020-01-13 | NQ | Futures | 10299.09 | 10432.71 | 10299.09 | 10424.4 | 380440.0 |
| 2020-01-13 | YM | Futures | 30219.6 | 30358.3 | 30219.6 | 30320.5 | 141633.0 |
| 2020-01-13 | CL | Futures | 60.53 | 60.76 | 59.37 | 59.54 | 584002.0 |
| 2020-01-13 | GC | Futures | 1922.9 | 1923.0 | 1903.2 | 1907.7 | 311734.0 |
| 2020-01-13 | ZN | Futures | 127.963207 | 127.963207 | 127.668968 | 127.777372 | 1055289.0 |
| 2020-01-13 | A6 | Futures | 0.70829 | 0.71045 | 0.70788 | 0.70901 | 72044.0 |
| 2020-01-13 | AD | Futures | 0.77189 | 0.77325 | 0.77119 | 0.7724 | 52202.0 |
| 2020-01-13 | ALI | Futures | 2185.6 | 2189.52 | 2180.48 | 2185.6 | 110.0 |
| 2020-01-13 | B | Futures | 53.25 | 53.36 | 52.26 | 52.49 | 262472.0 |
| 2020-01-13 | B6 | Futures | 1.3241 | 1.3253 | 1.3168 | 1.3208 | 93322.0 |
| 2020-01-13 | BR | Futures | 0.19766 | 0.19766 | 0.19527 | 0.19551 | 284.0 |
| 2020-01-13 | BTC | Futures | 12483.2 | 12581.7 | 12278.5 | 12430.1 | 3206.0 |
| 2020-01-13 | BZ | Futures | 52.54 | 52.6 | 51.52 | 51.75 | 35430.0 |
| 2020-01-13 | C | Futures | 1787.0 | 1814.0 | 1787.0 | 1806.0 | 14044.0 |
| 2020-01-13 | CB | Futures | 238.168 | 238.757 | 237.578 | 238.463 | 18.0 |
| 2020-01-13 | CC | Futures | 1698.0 | 1701.0 | 1673.0 | 1690.0 | 18971.0 |
| 2020-01-13 | CNH | Futures | 6.8846 | 6.8859 | 6.8543 | 6.8543 | 496.0 |
| 2020-01-13 | CSC | Futures | 3.359 | 3.359 | 3.314 | 3.32 | 89.0 |
| 2020-01-13 | CT | Futures | 67.83 | 68.45 | 67.71 | 68.04 | 19665.0 |
| 2020-01-13 | DC | Futures | 28.07 | 28.07 | 27.8 | 27.96 | 120.0 |
| 2020-01-13 | DX | Futures | 94.245 | 94.385 | 94.167 | 94.206 | 8531.0 |
| 2020-01-13 | E1 | Futures | 1.17844 | 1.18335 | 1.17833 | 1.18175 | 17233.0 |
| 2020-01-13 | E6 | Futures | 1.20243 | 1.20555 | 1.20189 | 1.20463 | 133271.0 |
| 2020-01-13 | E7 | Futures | 1.1961 | 1.1993 | 1.1957 | 1.1983 | 1955.0 |
| 2020-01-13 | EBM | Futures | 210.44 | 212.37 | 210.17 | 212.09 | 22786.0 |
| 2020-01-13 | ED | Futures | 95.3326 | 95.3326 | 95.3132 | 95.318 | 185386.0 |
| 2020-01-13 | ER | Futures | 98.377 | 98.377 | 98.372 | 98.372 | 39542.0 |
| 2020-01-13 | ESG | Futures | 293.02 | 293.21 | 289.29 | 289.29 | 87.0 |
| 2020-01-13 | EW | Futures | 2161.1 | 2180.0 | 2157.7 | 2179.0 | 11665.0 |
| 2020-01-13 | FBON | Futures | 143.06 | 143.11 | 142.56 | 142.6 | 493.0 |
| 2020-01-13 | FBTP | Futures | 128.64 | 128.7 | 127.94 | 128.01 | 78906.0 |
| 2020-01-13 | FBTS | Futures | 108.172 | 108.191 | 108.105 | 108.105 | 35841.0 |
| 2020-01-13 | FCE | Futures | 5465.3 | 5488.4 | 5451.2 | 5467.1 | 18965.0 |
| 2020-01-13 | FDAX | Futures | 14248.5 | 14305.1 | 14169.2 | 14207.8 | 84194.0 |
| 2020-01-13 | FDIV | Futures | 162.05 | 162.05 | 161.03 | 161.03 | 30.0 |
| 2020-01-13 | FDXM | Futures | 14068.1 | 14125.5 | 13990.8 | 14029.5 | 45417.0 |
| 2020-01-13 | FESX | Futures | 3322.4 | 3336.5 | 3308.3 | 3315.4 | 887655.0 |
| 2020-01-13 | FGBL | Futures | 163.68 | 163.74 | 163.05 | 163.1 | 613311.0 |
| 2020-01-13 | FGBM | Futures | 133.46 | 133.49 | 133.28 | 133.31 | 342854.0 |
| 2020-01-13 | FGBS | Futures | 112.634 | 112.639 | 112.603 | 112.608 | 209340.0 |
| 2020-01-13 | FGBX | Futures | 209.37 | 209.51 | 207.07 | 207.3 | 62630.0 |
| 2020-01-13 | FMWO | Futures | 7941.5 | 7966.5 | 7920.0 | 7944.9 | 2923.0 |
| 2020-01-13 | FOAT | Futures | 151.52 | 151.54 | 150.94 | 150.97 | 119763.0 |
| 2020-01-13 | FTDX | Futures | 3142.8 | 3148.4 | 3105.2 | 3106.7 | 57.0 |
| 2020-01-13 | FTI | Futures | 582.77 | 586.24 | 579.53 | 581.96 | 6252.0 |
| 2020-01-13 | FTUK | Futures | 7057.8 | 7103.8 | 7051.3 | 7078.9 | 87109.0 |
| 2020-01-13 | FVSA | Futures | 119.89 | 120.74 | 118.62 | 119.04 | 18179.0 |
| 2020-01-13 | FXXP | Futures | 380.3 | 381.6 | 378.8 | 379.9 | 61040.0 |
| 2020-01-13 | G | Futures | 120.56 | 120.69 | 120.35 | 120.41 | 201622.0 |
> showing 50 of 119 rows — these rows as CSV