PREVIEW / futures_daily / 2020-01-10
file: by_date/futures_daily/2020/2020-01-10.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-10 | ES | Futures | 3537.59 | 3550.01 | 3521.65 | 3525.97 | 1533121.0 |
| 2020-01-10 | NQ | Futures | 10334.64 | 10386.83 | 10284.46 | 10298.22 | 472166.0 |
| 2020-01-10 | YM | Futures | 30382.4 | 30479.1 | 30194.4 | 30221.7 | 183361.0 |
| 2020-01-10 | CL | Futures | 61.11 | 61.29 | 60.33 | 60.53 | 596186.0 |
| 2020-01-10 | GC | Futures | 1911.1 | 1924.3 | 1902.9 | 1919.3 | 344342.0 |
| 2020-01-10 | ZN | Futures | 127.715427 | 128.025152 | 127.622509 | 127.932235 | 1369615.0 |
| 2020-01-10 | A6 | Futures | 0.70378 | 0.70952 | 0.70348 | 0.70942 | 105871.0 |
| 2020-01-10 | AD | Futures | 0.77169 | 0.77345 | 0.77073 | 0.77164 | 72993.0 |
| 2020-01-10 | ALI | Futures | 2188.62 | 2201.89 | 2188.62 | 2201.89 | 50.0 |
| 2020-01-10 | B | Futures | 53.38 | 53.68 | 53.03 | 53.13 | 272171.0 |
| 2020-01-10 | B6 | Futures | 1.3274 | 1.3306 | 1.325 | 1.3269 | 79686.0 |
| 2020-01-10 | BR | Futures | 0.19879 | 0.19928 | 0.19851 | 0.19851 | 194.0 |
| 2020-01-10 | BTC | Futures | 11907.1 | 12460.4 | 11672.2 | 12331.6 | 13111.0 |
| 2020-01-10 | BZ | Futures | 52.73 | 52.93 | 52.28 | 52.38 | 46595.0 |
| 2020-01-10 | C | Futures | 1753.0 | 1804.0 | 1753.0 | 1787.0 | 11671.0 |
| 2020-01-10 | CB | Futures | 239.023 | 239.052 | 238.757 | 238.964 | 22.0 |
| 2020-01-10 | CC | Futures | 1677.0 | 1707.0 | 1672.0 | 1694.0 | 21537.0 |
| 2020-01-10 | CNH | Futures | 6.9005 | 6.9053 | 6.8842 | 6.8846 | 271.0 |
| 2020-01-10 | CSC | Futures | 3.338 | 3.348 | 3.322 | 3.344 | 137.0 |
| 2020-01-10 | CT | Futures | 67.06 | 67.91 | 66.92 | 67.83 | 25520.0 |
| 2020-01-10 | DC | Futures | 27.9 | 27.99 | 27.73 | 27.99 | 235.0 |
| 2020-01-10 | DX | Futures | 94.288 | 94.439 | 94.152 | 94.223 | 10771.0 |
| 2020-01-10 | E1 | Futures | 1.17901 | 1.18027 | 1.17536 | 1.17981 | 24914.0 |
| 2020-01-10 | E6 | Futures | 1.20135 | 1.20372 | 1.19892 | 1.20291 | 161272.0 |
| 2020-01-10 | E7 | Futures | 1.195 | 1.1974 | 1.1925 | 1.1966 | 2770.0 |
| 2020-01-10 | EBM | Futures | 211.27 | 211.27 | 209.35 | 210.44 | 26618.0 |
| 2020-01-10 | ED | Futures | 95.3326 | 95.3326 | 95.3229 | 95.3277 | 182563.0 |
| 2020-01-10 | ER | Futures | 98.377 | 98.382 | 98.372 | 98.372 | 59779.0 |
| 2020-01-10 | EW | Futures | 2168.0 | 2173.2 | 2155.7 | 2161.5 | 10497.0 |
| 2020-01-10 | FBON | Futures | 143.03 | 143.26 | 142.8 | 143.1 | 399.0 |
| 2020-01-10 | FBTP | Futures | 128.12 | 128.93 | 128.11 | 128.65 | 97919.0 |
| 2020-01-10 | FBTS | Futures | 108.201 | 108.278 | 108.153 | 108.201 | 63511.0 |
| 2020-01-10 | FCE | Futures | 5488.3 | 5488.8 | 5441.7 | 5465.3 | 51460.0 |
| 2020-01-10 | FDAX | Futures | 14291.9 | 14326.3 | 14199.3 | 14267.0 | 94696.0 |
| 2020-01-10 | FDIV | Futures | 162.24 | 162.24 | 162.05 | 162.05 | 6.0 |
| 2020-01-10 | FDXM | Futures | 14104.7 | 14145.4 | 14022.2 | 14087.9 | 41677.0 |
| 2020-01-10 | FESX | Futures | 3340.0 | 3343.5 | 3314.5 | 3329.4 | 746594.0 |
| 2020-01-10 | FEU3 | Futures | 99.085 | 99.085 | 99.085 | 99.085 | 117.0 |
| 2020-01-10 | FGBL | Futures | 163.63 | 163.74 | 163.19 | 163.67 | 555738.0 |
| 2020-01-10 | FGBM | Futures | 133.41 | 133.49 | 133.31 | 133.46 | 338079.0 |
| 2020-01-10 | FGBS | Futures | 112.629 | 112.639 | 112.608 | 112.629 | 217302.0 |
| 2020-01-10 | FGBX | Futures | 209.51 | 209.7 | 208.01 | 209.32 | 50391.0 |
| 2020-01-10 | FMWO | Futures | 7950.6 | 7958.6 | 7926.8 | 7942.7 | 2954.0 |
| 2020-01-10 | FOAT | Futures | 151.37 | 151.62 | 151.16 | 151.56 | 122418.0 |
| 2020-01-10 | FTDX | Futures | 3132.8 | 3132.8 | 3119.2 | 3122.7 | 156.0 |
| 2020-01-10 | FTI | Futures | 586.63 | 586.63 | 581.88 | 583.47 | 302.0 |
| 2020-01-10 | FTUK | Futures | 7097.2 | 7101.9 | 7035.3 | 7063.9 | 78929.0 |
| 2020-01-10 | FVSA | Futures | 119.89 | 122.23 | 118.49 | 119.89 | 27041.0 |
| 2020-01-10 | FXXP | Futures | 382.2 | 382.3 | 379.1 | 380.7 | 37705.0 |
| 2020-01-10 | G | Futures | 119.87 | 120.33 | 119.77 | 120.19 | 181616.0 |
> showing 50 of 119 rows — these rows as CSV