PREVIEW / futures_daily / 2019-04-25
file: by_date/futures_daily/2019/2019-04-25.parquet size: 10 KB rows: 114
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-04-25 | ES | Futures | 3164.91 | 3171.12 | 3147.9 | 3160.86 | 1376185.0 |
| 2019-04-25 | NQ | Futures | 9050.86 | 9078.8 | 8977.98 | 8985.47 | 488329.0 |
| 2019-04-25 | YM | Futures | 28010.3 | 28053.5 | 27752.7 | 27908.9 | 189570.0 |
| 2019-04-25 | CL | Futures | 67.57 | 68.05 | 66.63 | 66.95 | 603001.0 |
| 2019-04-25 | GC | Futures | 1590.5 | 1599.1 | 1587.1 | 1592.7 | 237154.0 |
| 2019-04-25 | ZN | Futures | 122.839591 | 122.886209 | 122.653117 | 122.715275 | 1141463.0 |
| 2019-04-25 | A6 | Futures | 0.72353 | 0.72477 | 0.72127 | 0.72353 | 95491.0 |
| 2019-04-25 | AD | Futures | 0.74998 | 0.75079 | 0.74887 | 0.75054 | 64060.0 |
| 2019-04-25 | B | Futures | 54.31 | 55.08 | 54.0 | 54.26 | 330749.0 |
| 2019-04-25 | B6 | Futures | 1.3249 | 1.3265 | 1.3213 | 1.324 | 92169.0 |
| 2019-04-25 | BR | Futures | 0.19976 | 0.20208 | 0.1984 | 0.2018 | 15500.0 |
| 2019-04-25 | BTC | Futures | 8412.9 | 8536.6 | 8320.1 | 8490.2 | 1238.0 |
| 2019-04-25 | BZ | Futures | 54.17 | 54.92 | 53.87 | 54.11 | 40938.0 |
| 2019-04-25 | C | Futures | 1630.0 | 1652.0 | 1630.0 | 1635.0 | 3644.0 |
| 2019-04-25 | CB | Futures | 276.929 | 278.304 | 276.929 | 277.586 | 8.0 |
| 2019-04-25 | CC | Futures | 1516.0 | 1542.0 | 1510.0 | 1538.0 | 18660.0 |
| 2019-04-25 | CNH | Futures | 6.7465 | 6.7671 | 6.7414 | 6.7608 | 798.0 |
| 2019-04-25 | CSC | Futures | 2.915 | 2.989 | 2.915 | 2.978 | 408.0 |
| 2019-04-25 | CT | Futures | 80.73 | 82.15 | 80.73 | 81.98 | 15598.0 |
| 2019-04-25 | DC | Futures | 24.66 | 25.1 | 24.61 | 25.07 | 871.0 |
| 2019-04-25 | DX | Futures | 93.743 | 93.987 | 93.662 | 93.857 | 16649.0 |
| 2019-04-25 | E1 | Futures | 1.14894 | 1.15022 | 1.14649 | 1.14835 | 22528.0 |
| 2019-04-25 | E6 | Futures | 1.22976 | 1.23036 | 1.22548 | 1.22663 | 226181.0 |
| 2019-04-25 | E7 | Futures | 1.2236 | 1.2242 | 1.2191 | 1.2206 | 5745.0 |
| 2019-04-25 | EBM | Futures | 192.1 | 193.16 | 191.84 | 192.63 | 8840.0 |
| 2019-04-25 | ED | Futures | 95.1599 | 95.1648 | 95.1453 | 95.1453 | 172309.0 |
| 2019-04-25 | ER | Futures | 98.416 | 98.421 | 98.411 | 98.416 | 61683.0 |
| 2019-04-25 | EW | Futures | 2096.0 | 2099.3 | 2065.5 | 2077.2 | 9675.0 |
| 2019-04-25 | FBON | Futures | 135.3 | 135.47 | 135.09 | 135.21 | 440.0 |
| 2019-04-25 | FBTP | Futures | 115.14 | 115.15 | 114.39 | 114.56 | 82794.0 |
| 2019-04-25 | FBTS | Futures | 105.76 | 105.76 | 105.551 | 105.608 | 41721.0 |
| 2019-04-25 | FCE | Futures | 4977.6 | 4979.0 | 4939.8 | 4957.8 | 58834.0 |
| 2019-04-25 | FDAX | Futures | 12978.5 | 13008.5 | 12906.4 | 12958.0 | 95952.0 |
| 2019-04-25 | FDXM | Futures | 12866.5 | 12895.8 | 12794.5 | 12845.7 | 35069.0 |
| 2019-04-25 | FESX | Futures | 2998.6 | 3003.9 | 2978.5 | 2993.4 | 931539.0 |
| 2019-04-25 | FGBL | Futures | 159.92 | 160.02 | 159.79 | 159.91 | 534846.0 |
| 2019-04-25 | FGBM | Futures | 133.03 | 133.09 | 133.02 | 133.07 | 348574.0 |
| 2019-04-25 | FGBS | Futures | 112.774 | 112.784 | 112.764 | 112.779 | 223812.0 |
| 2019-04-25 | FGBX | Futures | 194.0 | 194.28 | 193.3 | 193.65 | 31555.0 |
| 2019-04-25 | FMWO | Futures | 7285.5 | 7285.5 | 7240.4 | 7268.2 | 3042.0 |
| 2019-04-25 | FOAT | Futures | 146.89 | 146.89 | 146.59 | 146.64 | 117521.0 |
| 2019-04-25 | FTDX | Futures | 2861.6 | 2867.1 | 2822.6 | 2835.5 | 107.0 |
| 2019-04-25 | FTI | Futures | 533.38 | 534.71 | 531.11 | 533.67 | 22061.0 |
| 2019-04-25 | FTUK | Futures | 6805.0 | 6819.2 | 6748.1 | 6771.5 | 92056.0 |
| 2019-04-25 | FVSA | Futures | 198.3 | 205.28 | 198.3 | 201.09 | 29768.0 |
| 2019-04-25 | FXXP | Futures | 345.9 | 345.9 | 343.7 | 344.9 | 62496.0 |
| 2019-04-25 | G | Futures | 117.55 | 117.76 | 117.4 | 117.69 | 140765.0 |
| 2019-04-25 | GF | Futures | 304.64 | 304.64 | 297.978 | 298.863 | 3040.0 |
| 2019-04-25 | GSCI | Futures | 512.74 | 513.65 | 509.92 | 509.92 | 5.0 |
| 2019-04-25 | HE | Futures | 87.145 | 87.466 | 86.306 | 86.75 | 632.0 |
> showing 50 of 114 rows — these rows as CSV