PREVIEW / futures_daily / 2020-01-28
file: by_date/futures_daily/2020/2020-01-28.parquet size: 10 KB rows: 121
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-28 | ES | Futures | 3498.7 | 3547.85 | 3497.89 | 3540.56 | 1910878.0 |
| 2020-01-28 | NQ | Futures | 10268.69 | 10479.45 | 10268.69 | 10443.9 | 632550.0 |
| 2020-01-28 | YM | Futures | 29908.8 | 30224.9 | 29900.4 | 30151.4 | 261243.0 |
| 2020-01-28 | CL | Futures | 54.12 | 55.44 | 54.03 | 54.85 | 633963.0 |
| 2020-01-28 | GC | Futures | 1935.1 | 1936.8 | 1914.7 | 1921.3 | 194664.0 |
| 2020-01-28 | ZN | Futures | 129.651213 | 130.022884 | 129.295028 | 129.449891 | 2306819.0 |
| 2020-01-28 | A6 | Futures | 0.69374 | 0.69415 | 0.69138 | 0.69281 | 111032.0 |
| 2020-01-28 | AD | Futures | 0.76378 | 0.76595 | 0.76302 | 0.76504 | 68236.0 |
| 2020-01-28 | ALI | Futures | 2132.24 | 2138.24 | 2132.24 | 2137.94 | 45.0 |
| 2020-01-28 | B | Futures | 48.27 | 49.22 | 47.99 | 48.74 | 308813.0 |
| 2020-01-28 | B6 | Futures | 1.3259 | 1.3269 | 1.3177 | 1.3208 | 87677.0 |
| 2020-01-28 | BR | Futures | 0.19186 | 0.19332 | 0.19186 | 0.19295 | 9067.0 |
| 2020-01-28 | BTC | Futures | 13513.2 | 13970.9 | 13483.2 | 13768.3 | 1182.0 |
| 2020-01-28 | BZ | Futures | 47.59 | 48.47 | 47.27 | 48.02 | 42612.0 |
| 2020-01-28 | C | Futures | 1861.0 | 1881.0 | 1842.0 | 1843.0 | 5405.0 |
| 2020-01-28 | CB | Futures | 233.452 | 233.452 | 229.03 | 229.03 | 38.0 |
| 2020-01-28 | CC | Futures | 1792.0 | 1810.0 | 1753.0 | 1768.0 | 20724.0 |
| 2020-01-28 | CNH | Futures | 6.9549 | 6.9586 | 6.9381 | 6.9406 | 279.0 |
| 2020-01-28 | CSC | Futures | 3.43 | 3.437 | 3.394 | 3.437 | 35.0 |
| 2020-01-28 | CT | Futures | 65.66 | 67.15 | 65.65 | 66.93 | 18256.0 |
| 2020-01-28 | DC | Futures | 28.59 | 28.83 | 28.3 | 28.67 | 346.0 |
| 2020-01-28 | DX | Futures | 94.871 | 95.094 | 94.842 | 94.958 | 10150.0 |
| 2020-01-28 | E1 | Futures | 1.18187 | 1.18404 | 1.17639 | 1.17764 | 26429.0 |
| 2020-01-28 | E6 | Futures | 1.19052 | 1.19128 | 1.18826 | 1.19031 | 142025.0 |
| 2020-01-28 | E7 | Futures | 1.1843 | 1.1849 | 1.182 | 1.1841 | 1617.0 |
| 2020-01-28 | EBM | Futures | 212.92 | 214.29 | 212.37 | 213.74 | 16719.0 |
| 2020-01-28 | ED | Futures | 95.3617 | 95.3617 | 95.3423 | 95.3471 | 253766.0 |
| 2020-01-28 | ER | Futures | 98.382 | 98.396 | 98.382 | 98.391 | 177808.0 |
| 2020-01-28 | ESG | Futures | 290.73 | 292.56 | 290.71 | 292.56 | 193.0 |
| 2020-01-28 | EW | Futures | 2144.4 | 2171.8 | 2143.2 | 2166.0 | 13687.0 |
| 2020-01-28 | FBON | Futures | 145.09 | 145.35 | 144.74 | 144.83 | 573.0 |
| 2020-01-28 | FBTP | Futures | 131.49 | 132.17 | 131.44 | 131.8 | 134275.0 |
| 2020-01-28 | FBTS | Futures | 108.49 | 108.576 | 108.47 | 108.538 | 95131.0 |
| 2020-01-28 | FCE | Futures | 5338.8 | 5376.4 | 5306.2 | 5368.7 | 106594.0 |
| 2020-01-28 | FDAX | Futures | 13963.5 | 14101.0 | 13914.3 | 14077.2 | 127050.0 |
| 2020-01-28 | FDIV | Futures | 156.99 | 157.64 | 156.99 | 157.55 | 81.0 |
| 2020-01-28 | FDXM | Futures | 13791.4 | 13923.0 | 13741.3 | 13900.5 | 75998.0 |
| 2020-01-28 | FESX | Futures | 3229.9 | 3272.2 | 3226.4 | 3266.9 | 1366218.0 |
| 2020-01-28 | FGBL | Futures | 166.3 | 166.66 | 165.7 | 165.89 | 885015.0 |
| 2020-01-28 | FGBM | Futures | 134.21 | 134.3 | 134.03 | 134.11 | 545470.0 |
| 2020-01-28 | FGBS | Futures | 112.689 | 112.719 | 112.684 | 112.704 | 412388.0 |
| 2020-01-28 | FGBX | Futures | 217.46 | 218.53 | 215.58 | 216.18 | 86555.0 |
| 2020-01-28 | FMWO | Futures | 7850.8 | 7917.7 | 7830.4 | 7907.5 | 4336.0 |
| 2020-01-28 | FOAT | Futures | 153.64 | 154.06 | 153.3 | 153.45 | 193609.0 |
| 2020-01-28 | FTDX | Futures | 3164.9 | 3173.0 | 3121.2 | 3162.9 | 103.0 |
| 2020-01-28 | FTI | Futures | 574.89 | 576.85 | 570.38 | 576.36 | 37761.0 |
| 2020-01-28 | FTUK | Futures | 6885.7 | 6967.3 | 6885.7 | 6958.9 | 105906.0 |
| 2020-01-28 | FVSA | Futures | 130.1 | 133.5 | 123.29 | 124.99 | 42196.0 |
| 2020-01-28 | FXXP | Futures | 377.7 | 379.7 | 375.3 | 379.4 | 94097.0 |
| 2020-01-28 | G | Futures | 123.16 | 123.39 | 122.62 | 122.79 | 242010.0 |
> showing 50 of 121 rows — these rows as CSV