PREVIEW / futures_daily / 2018-02-13
file: by_date/futures_daily/2018/2018-02-13.parquet size: 9 KB rows: 111
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-13 | ES | Futures | 2883.76 | 2899.25 | 2863.11 | 2893.0 | 1461104.0 |
| 2018-02-13 | NQ | Futures | 7647.51 | 7695.82 | 7578.41 | 7683.52 | 382334.0 |
| 2018-02-13 | YM | Futures | 25914.9 | 26021.4 | 25701.8 | 25970.7 | 257768.0 |
| 2018-02-13 | CL | Futures | 59.66 | 59.95 | 58.64 | 59.45 | 320334.0 |
| 2018-02-13 | GC | Futures | 1692.5 | 1703.3 | 1690.8 | 1699.4 | 201432.0 |
| 2018-02-13 | ZN | Futures | 119.306452 | 119.59955 | 119.306452 | 119.460714 | 1277076.0 |
| 2018-02-13 | A6 | Futures | 0.80841 | 0.81016 | 0.80501 | 0.8081 | 91545.0 |
| 2018-02-13 | AD | Futures | 0.80726 | 0.80818 | 0.80442 | 0.8066 | 63136.0 |
| 2018-02-13 | B | Futures | 45.1 | 45.28 | 44.32 | 45.01 | 367263.0 |
| 2018-02-13 | B6 | Futures | 1.4413 | 1.45 | 1.4405 | 1.4449 | 98840.0 |
| 2018-02-13 | BR | Futures | 0.23055 | 0.23055 | 0.22899 | 0.22956 | 271.0 |
| 2018-02-13 | BTC | Futures | 11613.5 | 11711.1 | 10845.8 | 11320.7 | 550.0 |
| 2018-02-13 | BZ | Futures | 44.43 | 44.68 | 43.74 | 44.42 | 38693.0 |
| 2018-02-13 | C | Futures | 1304.0 | 1332.0 | 1303.0 | 1323.0 | 6288.0 |
| 2018-02-13 | CB | Futures | 261.912 | 261.974 | 260.739 | 261.974 | 9.0 |
| 2018-02-13 | CC | Futures | 1478.0 | 1506.0 | 1471.0 | 1494.0 | 29295.0 |
| 2018-02-13 | CNH | Futures | 6.4707 | 6.4794 | 6.4601 | 6.4667 | 173.0 |
| 2018-02-13 | CSC | Futures | 3.197 | 3.229 | 3.197 | 3.229 | 92.0 |
| 2018-02-13 | CT | Futures | 89.24 | 89.35 | 88.37 | 89.21 | 18895.0 |
| 2018-02-13 | DC | Futures | 25.09 | 25.44 | 25.09 | 25.44 | 222.0 |
| 2018-02-13 | DX | Futures | 84.575 | 84.585 | 84.04 | 84.136 | 20985.0 |
| 2018-02-13 | E1 | Futures | 1.29574 | 1.30545 | 1.29501 | 1.30229 | 20493.0 |
| 2018-02-13 | E6 | Futures | 1.39651 | 1.40547 | 1.39566 | 1.40354 | 205834.0 |
| 2018-02-13 | E7 | Futures | 1.3894 | 1.3985 | 1.3886 | 1.3965 | 4112.0 |
| 2018-02-13 | EBM | Futures | 173.16 | 173.7 | 172.89 | 173.43 | 15503.0 |
| 2018-02-13 | ED | Futures | 95.1999 | 95.2145 | 95.1951 | 95.2096 | 282008.0 |
| 2018-02-13 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.332 | 20664.0 |
| 2018-02-13 | EW | Futures | 1948.9 | 1957.4 | 1929.7 | 1954.3 | 15712.0 |
| 2018-02-13 | FBON | Futures | 126.46 | 126.46 | 125.92 | 125.96 | 295.0 |
| 2018-02-13 | FBTP | Futures | 111.0 | 111.16 | 110.49 | 110.63 | 149468.0 |
| 2018-02-13 | FBTS | Futures | 103.714 | 103.723 | 103.65 | 103.668 | 51535.0 |
| 2018-02-13 | FCE | Futures | 4540.5 | 4551.1 | 4508.7 | 4510.5 | 204131.0 |
| 2018-02-13 | FDAX | Futures | 12738.1 | 12757.8 | 12631.2 | 12654.1 | 91845.0 |
| 2018-02-13 | FDXM | Futures | 12772.2 | 12777.4 | 12653.7 | 12675.5 | 36703.0 |
| 2018-02-13 | FESX | Futures | 2750.6 | 2754.7 | 2724.4 | 2729.3 | 1306842.0 |
| 2018-02-13 | FGBL | Futures | 146.46 | 146.84 | 146.39 | 146.53 | 664396.0 |
| 2018-02-13 | FGBM | Futures | 128.32 | 128.47 | 128.3 | 128.38 | 435771.0 |
| 2018-02-13 | FGBS | Futures | 112.306 | 112.326 | 112.296 | 112.301 | 219560.0 |
| 2018-02-13 | FGBX | Futures | 164.07 | 164.79 | 163.46 | 163.78 | 63777.0 |
| 2018-02-13 | FMWO | Futures | 6822.0 | 6865.1 | 6816.1 | 6829.0 | 3184.0 |
| 2018-02-13 | FOAT | Futures | 135.86 | 136.13 | 135.71 | 135.82 | 80842.0 |
| 2018-02-13 | FTDX | Futures | 2473.5 | 2480.5 | 2453.6 | 2455.1 | 67.0 |
| 2018-02-13 | FTI | Futures | 479.86 | 480.97 | 475.96 | 476.47 | 32688.0 |
| 2018-02-13 | FTUK | Futures | 6230.4 | 6251.4 | 6204.6 | 6214.7 | 111290.0 |
| 2018-02-13 | FVSA | Futures | 502.3 | 522.0 | 497.37 | 513.38 | 43493.0 |
| 2018-02-13 | FXXP | Futures | 317.3 | 317.8 | 314.5 | 315.0 | 42981.0 |
| 2018-02-13 | G | Futures | 111.72 | 111.89 | 111.41 | 111.53 | 171206.0 |
| 2018-02-13 | GF | Futures | 324.838 | 325.717 | 322.258 | 323.411 | 5507.0 |
| 2018-02-13 | GSCI | Futures | 489.38 | 491.02 | 488.52 | 491.02 | 2253.0 |
| 2018-02-13 | HE | Futures | 90.302 | 90.431 | 88.986 | 89.147 | 20071.0 |
> showing 50 of 111 rows — these rows as CSV