PREVIEW / futures_daily / 2019-12-16
file: by_date/futures_daily/2019/2019-12-16.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 |
|---|---|---|---|---|---|---|---|
| 2019-12-16 | ES | Futures | 3433.9 | 3458.74 | 3431.2 | 3454.42 | 1973586.0 |
| 2019-12-16 | NQ | Futures | 9788.66 | 9884.44 | 9784.07 | 9871.25 | 311959.0 |
| 2019-12-16 | YM | Futures | 29603.2 | 29773.3 | 29567.5 | 29681.9 | 145650.0 |
| 2019-12-16 | CL | Futures | 61.34 | 61.81 | 61.12 | 61.65 | 234083.0 |
| 2019-12-16 | GC | Futures | 1820.8 | 1826.3 | 1817.6 | 1821.4 | 165853.0 |
| 2019-12-16 | ZN | Futures | 127.746399 | 127.792858 | 127.266324 | 127.281811 | 1148417.0 |
| 2019-12-16 | A6 | Futures | 0.70604 | 0.7087 | 0.70563 | 0.70799 | 89036.0 |
| 2019-12-16 | AD | Futures | 0.76504 | 0.76877 | 0.76454 | 0.7664 | 73538.0 |
| 2019-12-16 | ALI | Futures | 2157.56 | 2167.81 | 2155.45 | 2160.58 | 154.0 |
| 2019-12-16 | B | Futures | 52.46 | 52.96 | 52.33 | 52.7 | 186087.0 |
| 2019-12-16 | B6 | Futures | 1.3574 | 1.365 | 1.3548 | 1.3577 | 117118.0 |
| 2019-12-16 | BR | Futures | 0.19823 | 0.19961 | 0.19823 | 0.19952 | 656.0 |
| 2019-12-16 | BTC | Futures | 10712.9 | 10750.5 | 10216.3 | 10321.7 | 7720.0 |
| 2019-12-16 | BZ | Futures | 51.71 | 52.24 | 51.63 | 52.0 | 31476.0 |
| 2019-12-16 | C | Futures | 1707.0 | 1711.0 | 1679.0 | 1681.0 | 14575.0 |
| 2019-12-16 | CB | Futures | 245.537 | 246.156 | 245.242 | 245.242 | 19.0 |
| 2019-12-16 | CC | Futures | 1672.0 | 1709.0 | 1663.0 | 1665.0 | 22155.0 |
| 2019-12-16 | CNH | Futures | 6.9816 | 6.9892 | 6.9689 | 6.9714 | 773.0 |
| 2019-12-16 | CSC | Futures | 3.292 | 3.298 | 3.264 | 3.273 | 55.0 |
| 2019-12-16 | CT | Futures | 63.54 | 64.14 | 63.19 | 63.7 | 19347.0 |
| 2019-12-16 | DC | Futures | 27.6 | 27.62 | 27.25 | 27.36 | 226.0 |
| 2019-12-16 | DX | Futures | 93.871 | 93.886 | 93.657 | 93.74 | 12419.0 |
| 2019-12-16 | E1 | Futures | 1.1693 | 1.17125 | 1.16805 | 1.17067 | 23474.0 |
| 2019-12-16 | E6 | Futures | 1.20625 | 1.20954 | 1.20566 | 1.20846 | 173496.0 |
| 2019-12-16 | E7 | Futures | 1.2 | 1.2032 | 1.1988 | 1.2022 | 2681.0 |
| 2019-12-16 | EBM | Futures | 202.75 | 205.5 | 202.2 | 204.95 | 28478.0 |
| 2019-12-16 | ED | Futures | 95.3083 | 95.3229 | 95.2986 | 95.3035 | 238208.0 |
| 2019-12-16 | ER | Futures | 98.372 | 98.382 | 98.372 | 98.377 | 51679.0 |
| 2019-12-16 | ESG | Futures | 284.89 | 284.89 | 284.89 | 284.89 | 67.0 |
| 2019-12-16 | EW | Futures | 2138.3 | 2160.2 | 2138.0 | 2150.3 | 49833.0 |
| 2019-12-16 | FBON | Futures | 143.47 | 143.55 | 143.25 | 143.46 | 524.0 |
| 2019-12-16 | FBTP | Futures | 129.31 | 129.45 | 128.84 | 129.01 | 70190.0 |
| 2019-12-16 | FBTS | Futures | 108.307 | 108.317 | 108.172 | 108.22 | 23707.0 |
| 2019-12-16 | FCE | Futures | 5378.3 | 5428.6 | 5372.9 | 5418.2 | 81794.0 |
| 2019-12-16 | FDAX | Futures | 14095.8 | 14170.2 | 14056.3 | 14148.6 | 98816.0 |
| 2019-12-16 | FDXM | Futures | 13903.1 | 14021.1 | 13903.1 | 14000.8 | 1962.0 |
| 2019-12-16 | FESX | Futures | 3302.1 | 3316.2 | 3286.3 | 3310.9 | 1466988.0 |
| 2019-12-16 | FGBL | Futures | 164.44 | 164.7 | 164.1 | 164.21 | 511519.0 |
| 2019-12-16 | FGBM | Futures | 133.64 | 133.75 | 133.6 | 133.63 | 349068.0 |
| 2019-12-16 | FGBS | Futures | 112.649 | 112.689 | 112.649 | 112.664 | 180822.0 |
| 2019-12-16 | FGBX | Futures | 212.98 | 213.97 | 211.77 | 212.08 | 41134.0 |
| 2019-12-16 | FMWO | Futures | 7760.0 | 7807.8 | 7758.9 | 7806.7 | 9938.0 |
| 2019-12-16 | FOAT | Futures | 151.96 | 152.22 | 151.69 | 151.79 | 86246.0 |
| 2019-12-16 | FTDX | Futures | 3081.5 | 3100.1 | 3081.5 | 3098.6 | 423.0 |
| 2019-12-16 | FTI | Futures | 580.69 | 586.63 | 579.83 | 584.86 | 11182.0 |
| 2019-12-16 | FTUK | Futures | 6871.6 | 7029.2 | 6858.9 | 7022.2 | 303907.0 |
| 2019-12-16 | FVSA | Futures | 130.2 | 130.2 | 123.64 | 124.58 | 47061.0 |
| 2019-12-16 | FXXP | Futures | 376.4 | 380.1 | 375.7 | 379.7 | 183910.0 |
| 2019-12-16 | G | Futures | 120.01 | 120.51 | 119.61 | 119.74 | 173369.0 |
| 2019-12-16 | GF | Futures | 307.547 | 308.705 | 305.23 | 305.967 | 4946.0 |
> showing 50 of 118 rows — these rows as CSV