PREVIEW / futures_daily / 2019-10-03
file: by_date/futures_daily/2019/2019-10-03.parquet size: 10 KB rows: 120
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-10-03 | ES | Futures | 3121.85 | 3152.98 | 3090.73 | 3152.17 | 2037970.0 |
| 2019-10-03 | NQ | Futures | 8702.51 | 8829.27 | 8613.48 | 8825.81 | 582820.0 |
| 2019-10-03 | YM | Futures | 27297.7 | 27489.8 | 26982.8 | 27483.5 | 271794.0 |
| 2019-10-03 | CL | Futures | 53.87 | 54.32 | 52.35 | 53.85 | 642466.0 |
| 2019-10-03 | GC | Futures | 1857.2 | 1882.2 | 1852.4 | 1867.3 | 408743.0 |
| 2019-10-03 | ZN | Futures | 129.883248 | 130.781344 | 129.867764 | 130.564562 | 1916073.0 |
| 2019-10-03 | A6 | Futures | 0.68963 | 0.69445 | 0.68932 | 0.69352 | 105299.0 |
| 2019-10-03 | AD | Futures | 0.75653 | 0.75743 | 0.75532 | 0.75637 | 91250.0 |
| 2019-10-03 | ALI | Futures | 2076.21 | 2082.25 | 2076.21 | 2082.25 | 30.0 |
| 2019-10-03 | B | Futures | 45.58 | 45.94 | 44.48 | 45.72 | 336903.0 |
| 2019-10-03 | B6 | Futures | 1.2537 | 1.2654 | 1.2504 | 1.2591 | 159274.0 |
| 2019-10-03 | BR | Futures | 0.19513 | 0.19736 | 0.19509 | 0.19728 | 161.0 |
| 2019-10-03 | BTC | Futures | 11916.0 | 12131.8 | 11614.0 | 11736.3 | 2581.0 |
| 2019-10-03 | BZ | Futures | 44.91 | 45.3 | 43.86 | 45.08 | 49093.0 |
| 2019-10-03 | C | Futures | 1700.0 | 1735.0 | 1698.0 | 1733.0 | 9314.0 |
| 2019-10-03 | CB | Futures | 257.106 | 257.106 | 256.191 | 256.545 | 7.0 |
| 2019-10-03 | CC | Futures | 1631.0 | 1660.0 | 1624.0 | 1654.0 | 16934.0 |
| 2019-10-03 | CNH | Futures | 7.1446 | 7.1461 | 7.1229 | 7.1253 | 486.0 |
| 2019-10-03 | CSC | Futures | 3.132 | 3.143 | 3.132 | 3.139 | 22.0 |
| 2019-10-03 | CT | Futures | 59.54 | 61.24 | 59.52 | 59.96 | 27767.0 |
| 2019-10-03 | DC | Futures | 26.43 | 26.51 | 26.4 | 26.46 | 62.0 |
| 2019-10-03 | DX | Futures | 95.387 | 95.565 | 95.01 | 95.242 | 17375.0 |
| 2019-10-03 | E1 | Futures | 1.16059 | 1.16243 | 1.15369 | 1.15852 | 42829.0 |
| 2019-10-03 | E6 | Futures | 1.19388 | 1.19822 | 1.19177 | 1.1954 | 202051.0 |
| 2019-10-03 | E7 | Futures | 1.1878 | 1.1919 | 1.1856 | 1.1892 | 3973.0 |
| 2019-10-03 | EBM | Futures | 191.26 | 193.18 | 190.99 | 192.9 | 17060.0 |
| 2019-10-03 | ED | Futures | 95.3618 | 95.4249 | 95.3472 | 95.4201 | 486168.0 |
| 2019-10-03 | ER | Futures | 98.475 | 98.48 | 98.47 | 98.475 | 66840.0 |
| 2019-10-03 | EW | Futures | 1965.4 | 1982.8 | 1943.6 | 1980.7 | 15782.0 |
| 2019-10-03 | FBON | Futures | 146.2 | 146.35 | 145.95 | 146.2 | 380.0 |
| 2019-10-03 | FBTP | Futures | 131.81 | 132.77 | 131.8 | 132.52 | 75178.0 |
| 2019-10-03 | FBTS | Futures | 108.491 | 108.635 | 108.471 | 108.597 | 30911.0 |
| 2019-10-03 | FCE | Futures | 4904.2 | 4953.5 | 4879.8 | 4921.9 | 131813.0 |
| 2019-10-03 | FDAX | Futures | 12578.0 | 12629.7 | 12458.8 | 12583.8 | 107591.0 |
| 2019-10-03 | FDIV | Futures | 144.33 | 144.51 | 142.98 | 144.51 | 90.0 |
| 2019-10-03 | FDXM | Futures | 12407.0 | 12465.3 | 12296.6 | 12419.5 | 48499.0 |
| 2019-10-03 | FESX | Futures | 2985.2 | 3001.0 | 2957.1 | 2986.9 | 1490074.0 |
| 2019-10-03 | FGBL | Futures | 167.97 | 168.84 | 167.97 | 168.53 | 618774.0 |
| 2019-10-03 | FGBM | Futures | 135.12 | 135.39 | 135.12 | 135.29 | 298537.0 |
| 2019-10-03 | FGBS | Futures | 113.006 | 113.061 | 113.006 | 113.046 | 177003.0 |
| 2019-10-03 | FGBX | Futures | 224.54 | 227.46 | 224.54 | 226.3 | 47731.0 |
| 2019-10-03 | FMWO | Futures | 7076.5 | 7093.5 | 6992.3 | 7070.8 | 2630.0 |
| 2019-10-03 | FOAT | Futures | 154.71 | 155.47 | 154.71 | 155.22 | 181909.0 |
| 2019-10-03 | FTDX | Futures | 2711.1 | 2711.1 | 2629.2 | 2682.5 | 10.0 |
| 2019-10-03 | FTI | Futures | 528.3 | 532.48 | 524.98 | 529.54 | 40733.0 |
| 2019-10-03 | FTUK | Futures | 6556.3 | 6569.7 | 6460.3 | 6529.9 | 198838.0 |
| 2019-10-03 | FVSA | Futures | 219.5 | 223.43 | 208.83 | 213.32 | 36222.0 |
| 2019-10-03 | FXXP | Futures | 339.2 | 341.2 | 337.0 | 340.0 | 69974.0 |
| 2019-10-03 | G | Futures | 123.19 | 123.65 | 123.08 | 123.18 | 203514.0 |
| 2019-10-03 | GF | Futures | 298.285 | 298.494 | 296.558 | 297.971 | 1332.0 |
> showing 50 of 120 rows — these rows as CSV