PREVIEW / futures_daily / 2020-07-22
file: by_date/futures_daily/2020/2020-07-22.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-07-22 | ES | Futures | 3657.31 | 3682.64 | 3632.55 | 3675.6 | 1354244.0 |
| 2020-07-22 | NQ | Futures | 12593.81 | 12669.83 | 12489.93 | 12539.84 | 483851.0 |
| 2020-07-22 | YM | Futures | 28643.1 | 28858.5 | 28427.7 | 28811.3 | 162999.0 |
| 2020-07-22 | CL | Futures | 30.31 | 30.67 | 30.02 | 30.57 | 333647.0 |
| 2020-07-22 | GC | Futures | 2212.5 | 2247.3 | 2211.7 | 2239.3 | 382234.0 |
| 2020-07-22 | ZN | Futures | 138.295432 | 138.419311 | 138.233493 | 138.310917 | 647895.0 |
| 2020-07-22 | A6 | Futures | 0.73397 | 0.73911 | 0.73181 | 0.73469 | 116064.0 |
| 2020-07-22 | AD | Futures | 0.75449 | 0.75764 | 0.75292 | 0.75667 | 64589.0 |
| 2020-07-22 | ALI | Futures | 2070.69 | 2074.33 | 2043.68 | 2062.8 | 394.0 |
| 2020-07-22 | B | Futures | 28.69 | 28.93 | 28.42 | 28.85 | 202158.0 |
| 2020-07-22 | B6 | Futures | 1.2928 | 1.2943 | 1.2842 | 1.2937 | 101418.0 |
| 2020-07-22 | BR | Futures | 0.15316 | 0.15534 | 0.15316 | 0.15514 | 785.0 |
| 2020-07-22 | BTC | Futures | 12967.1 | 12994.7 | 12801.9 | 12980.9 | 3117.0 |
| 2020-07-22 | BZ | Futures | 27.96 | 28.28 | 27.78 | 28.21 | 19676.0 |
| 2020-07-22 | C | Futures | 1399.0 | 1408.0 | 1388.0 | 1399.0 | 3317.0 |
| 2020-07-22 | CB | Futures | 190.44 | 191.376 | 189.985 | 191.376 | 6.0 |
| 2020-07-22 | CC | Futures | 1434.0 | 1455.0 | 1419.0 | 1446.0 | 9329.0 |
| 2020-07-22 | CNH | Futures | 6.8854 | 6.9313 | 6.8797 | 6.9264 | 933.0 |
| 2020-07-22 | CSC | Futures | 4.468 | 4.499 | 4.306 | 4.345 | 127.0 |
| 2020-07-22 | CT | Futures | 63.33 | 63.67 | 63.33 | 63.45 | 13.0 |
| 2020-07-22 | DC | Futures | 36.35 | 37.03 | 35.34 | 35.7 | 669.0 |
| 2020-07-22 | DX | Futures | 91.851 | 92.126 | 91.546 | 91.696 | 17679.0 |
| 2020-07-22 | E1 | Futures | 1.21978 | 1.22478 | 1.21638 | 1.22342 | 22111.0 |
| 2020-07-22 | E6 | Futures | 1.23896 | 1.24642 | 1.23617 | 1.24288 | 261651.0 |
| 2020-07-22 | E7 | Futures | 1.2325 | 1.2401 | 1.23 | 1.2366 | 8681.0 |
| 2020-07-22 | EBM | Futures | 218.85 | 220.35 | 217.36 | 220.05 | 11346.0 |
| 2020-07-22 | ED | Futures | 96.4233 | 96.4233 | 96.4185 | 96.4185 | 63899.0 |
| 2020-07-22 | ER | Futures | 98.372 | 98.377 | 98.367 | 98.372 | 56719.0 |
| 2020-07-22 | ESG | Futures | 295.63 | 296.87 | 295.63 | 296.87 | 45.0 |
| 2020-07-22 | EW | Futures | 1961.3 | 1988.3 | 1942.8 | 1976.8 | 10056.0 |
| 2020-07-22 | FBON | Futures | 146.17 | 146.77 | 146.15 | 146.57 | 52.0 |
| 2020-07-22 | FBTP | Futures | 132.13 | 132.63 | 131.89 | 132.54 | 92278.0 |
| 2020-07-22 | FBTS | Futures | 108.754 | 108.861 | 108.745 | 108.841 | 51919.0 |
| 2020-07-22 | FCE | Futures | 4908.4 | 4925.8 | 4854.2 | 4864.4 | 50404.0 |
| 2020-07-22 | FDAX | Futures | 13924.7 | 14014.5 | 13867.3 | 13905.0 | 71645.0 |
| 2020-07-22 | FDXM | Futures | 13888.2 | 13963.4 | 13817.3 | 13854.9 | 45425.0 |
| 2020-07-22 | FESX | Futures | 3126.6 | 3141.4 | 3096.1 | 3104.4 | 728570.0 |
| 2020-07-22 | FGBL | Futures | 168.51 | 169.07 | 168.35 | 169.05 | 482282.0 |
| 2020-07-22 | FGBM | Futures | 134.78 | 134.99 | 134.72 | 134.98 | 334271.0 |
| 2020-07-22 | FGBS | Futures | 112.729 | 112.785 | 112.724 | 112.78 | 259158.0 |
| 2020-07-22 | FGBX | Futures | 227.14 | 229.51 | 226.83 | 229.43 | 53218.0 |
| 2020-07-22 | FMWO | Futures | 8146.3 | 8170.0 | 8089.5 | 8141.6 | 1984.0 |
| 2020-07-22 | FOAT | Futures | 156.01 | 156.52 | 155.95 | 156.41 | 136293.0 |
| 2020-07-22 | FTDX | Futures | 3224.8 | 3237.6 | 3206.4 | 3233.0 | 84.0 |
| 2020-07-22 | FTI | Futures | 537.82 | 539.09 | 531.56 | 533.19 | 22080.0 |
| 2020-07-22 | FTUK | Futures | 5875.9 | 5899.1 | 5823.5 | 5836.2 | 69162.0 |
| 2020-07-22 | FVSA | Futures | 231.2 | 237.99 | 228.49 | 233.92 | 14032.0 |
| 2020-07-22 | FXXP | Futures | 345.3 | 345.9 | 342.3 | 343.7 | 54428.0 |
| 2020-07-22 | G | Futures | 127.54 | 127.85 | 127.52 | 127.83 | 158140.0 |
| 2020-07-22 | GF | Futures | 274.004 | 275.312 | 272.889 | 274.343 | 4214.0 |
> showing 50 of 118 rows — these rows as CSV