PREVIEW / futures_daily / 2020-01-14
file: by_date/futures_daily/2020/2020-01-14.parquet size: 10 KB rows: 118
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-14 | ES | Futures | 3552.44 | 3560.54 | 3537.32 | 3551.09 | 1694799.0 |
| 2020-01-14 | NQ | Futures | 10423.82 | 10454.79 | 10363.32 | 10394.86 | 553343.0 |
| 2020-01-14 | YM | Futures | 30323.6 | 30471.7 | 30179.7 | 30386.6 | 232554.0 |
| 2020-01-14 | CL | Futures | 59.54 | 60.23 | 59.21 | 59.75 | 262787.0 |
| 2020-01-14 | GC | Futures | 1905.2 | 1906.3 | 1890.2 | 1900.3 | 340913.0 |
| 2020-01-14 | ZN | Futures | 127.777372 | 128.087098 | 127.637995 | 127.99418 | 1421799.0 |
| 2020-01-14 | A6 | Futures | 0.7086 | 0.70932 | 0.70686 | 0.70881 | 83148.0 |
| 2020-01-14 | AD | Futures | 0.77184 | 0.7724 | 0.77038 | 0.77179 | 50653.0 |
| 2020-01-14 | ALI | Futures | 2185.6 | 2194.6 | 2185.3 | 2194.6 | 20.0 |
| 2020-01-14 | B | Futures | 52.56 | 53.18 | 52.26 | 52.73 | 270499.0 |
| 2020-01-14 | B6 | Futures | 1.3196 | 1.3241 | 1.3161 | 1.3235 | 78270.0 |
| 2020-01-14 | BR | Futures | 0.19547 | 0.19636 | 0.19466 | 0.19579 | 1086.0 |
| 2020-01-14 | BTC | Futures | 12377.1 | 13574.6 | 12354.3 | 13263.8 | 13502.0 |
| 2020-01-14 | BZ | Futures | 51.77 | 52.43 | 51.52 | 51.98 | 34682.0 |
| 2020-01-14 | C | Futures | 1810.0 | 1872.0 | 1810.0 | 1868.0 | 16066.0 |
| 2020-01-14 | CB | Futures | 238.345 | 238.345 | 237.991 | 238.286 | 5.0 |
| 2020-01-14 | CC | Futures | 1713.0 | 1745.0 | 1704.0 | 1737.0 | 22593.0 |
| 2020-01-14 | CNH | Futures | 6.8543 | 6.8666 | 6.8404 | 6.8619 | 548.0 |
| 2020-01-14 | CSC | Futures | 3.309 | 3.311 | 3.281 | 3.296 | 232.0 |
| 2020-01-14 | CT | Futures | 68.01 | 68.25 | 67.44 | 67.9 | 19646.0 |
| 2020-01-14 | DC | Futures | 27.96 | 27.98 | 27.69 | 27.91 | 240.0 |
| 2020-01-14 | DX | Futures | 94.235 | 94.444 | 94.191 | 94.239 | 8810.0 |
| 2020-01-14 | E1 | Futures | 1.18175 | 1.18678 | 1.18095 | 1.18609 | 30906.0 |
| 2020-01-14 | E6 | Futures | 1.20415 | 1.20523 | 1.20081 | 1.20345 | 141237.0 |
| 2020-01-14 | E7 | Futures | 1.198 | 1.1989 | 1.1945 | 1.1972 | 1984.0 |
| 2020-01-14 | EBM | Futures | 211.82 | 214.29 | 211.82 | 213.47 | 28616.0 |
| 2020-01-14 | ED | Futures | 95.318 | 95.3229 | 95.3035 | 95.3132 | 263184.0 |
| 2020-01-14 | ER | Futures | 98.372 | 98.377 | 98.372 | 98.372 | 57237.0 |
| 2020-01-14 | ESG | Futures | 292.94 | 293.64 | 289.29 | 289.29 | 55.0 |
| 2020-01-14 | EW | Futures | 2177.4 | 2191.4 | 2166.9 | 2184.5 | 13224.0 |
| 2020-01-14 | FBON | Futures | 142.66 | 142.93 | 142.58 | 142.68 | 687.0 |
| 2020-01-14 | FBTP | Futures | 128.08 | 128.3 | 127.9 | 128.05 | 111820.0 |
| 2020-01-14 | FBTS | Futures | 108.124 | 108.134 | 108.105 | 108.124 | 47588.0 |
| 2020-01-14 | FCE | Futures | 5473.6 | 5477.5 | 5417.2 | 5473.0 | 65122.0 |
| 2020-01-14 | FDAX | Futures | 14269.7 | 14280.8 | 14125.3 | 14220.0 | 110859.0 |
| 2020-01-14 | FDXM | Futures | 14065.0 | 14101.5 | 13949.1 | 14041.5 | 57056.0 |
| 2020-01-14 | FESX | Futures | 3327.7 | 3329.4 | 3288.0 | 3313.6 | 1077167.0 |
| 2020-01-14 | FGBL | Futures | 163.08 | 163.41 | 163.0 | 163.34 | 694365.0 |
| 2020-01-14 | FGBM | Futures | 133.32 | 133.39 | 133.26 | 133.36 | 365705.0 |
| 2020-01-14 | FGBS | Futures | 112.603 | 112.613 | 112.593 | 112.603 | 262758.0 |
| 2020-01-14 | FGBX | Futures | 207.3 | 208.42 | 206.92 | 208.36 | 57895.0 |
| 2020-01-14 | FMWO | Futures | 7976.7 | 7986.9 | 7932.5 | 7966.5 | 2679.0 |
| 2020-01-14 | FOAT | Futures | 150.91 | 151.31 | 150.91 | 151.2 | 134928.0 |
| 2020-01-14 | FTDX | Futures | 3102.6 | 3117.7 | 3093.6 | 3111.2 | 42.0 |
| 2020-01-14 | FTI | Futures | 583.58 | 586.1 | 578.1 | 584.17 | 17670.0 |
| 2020-01-14 | FTUK | Futures | 7108.5 | 7117.4 | 7056.9 | 7094.4 | 101306.0 |
| 2020-01-14 | FVSA | Futures | 118.62 | 122.02 | 117.34 | 117.77 | 18633.0 |
| 2020-01-14 | FXXP | Futures | 380.6 | 381.6 | 377.4 | 381.0 | 62133.0 |
| 2020-01-14 | G | Futures | 120.51 | 120.83 | 120.49 | 120.77 | 202599.0 |
| 2020-01-14 | GF | Futures | 308.122 | 308.703 | 306.59 | 307.858 | 4277.0 |
> showing 50 of 118 rows — these rows as CSV