PREVIEW / futures_daily / 2019-04-08
file: by_date/futures_daily/2019/2019-04-08.parquet size: 10 KB rows: 116
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-08 | ES | Futures | 3128.46 | 3132.24 | 3115.49 | 3130.62 | 978909.0 |
| 2019-04-08 | NQ | Futures | 8765.69 | 8790.46 | 8712.11 | 8783.83 | 333328.0 |
| 2019-04-08 | YM | Futures | 27855.1 | 27879.4 | 27706.3 | 27797.0 | 133521.0 |
| 2019-04-08 | CL | Futures | 65.03 | 66.21 | 64.82 | 66.13 | 895767.0 |
| 2019-04-08 | GC | Futures | 1612.8 | 1627.8 | 1612.4 | 1620.4 | 207572.0 |
| 2019-04-08 | ZN | Futures | 122.948367 | 123.026065 | 122.746354 | 122.777433 | 860631.0 |
| 2019-04-08 | A6 | Futures | 0.73364 | 0.73611 | 0.73168 | 0.73559 | 76155.0 |
| 2019-04-08 | AD | Futures | 0.75645 | 0.7611 | 0.7564 | 0.76075 | 61463.0 |
| 2019-04-08 | B | Futures | 51.39 | 51.85 | 51.3 | 51.79 | 288128.0 |
| 2019-04-08 | B6 | Futures | 1.3391 | 1.344 | 1.3391 | 1.3431 | 67323.0 |
| 2019-04-08 | BR | Futures | 0.20701 | 0.20729 | 0.20697 | 0.20729 | 19.0 |
| 2019-04-08 | BTC | Futures | 7980.5 | 8297.2 | 7926.4 | 8050.0 | 16170.0 |
| 2019-04-08 | BZ | Futures | 51.21 | 51.71 | 51.17 | 51.65 | 40966.0 |
| 2019-04-08 | C | Futures | 1609.0 | 1610.0 | 1593.0 | 1597.0 | 10205.0 |
| 2019-04-08 | CB | Futures | 277.497 | 277.497 | 277.228 | 277.497 | 13.0 |
| 2019-04-08 | CC | Futures | 1625.0 | 1632.0 | 1612.0 | 1624.0 | 39171.0 |
| 2019-04-08 | CNH | Futures | 6.7188 | 6.7355 | 6.7188 | 6.7259 | 458.0 |
| 2019-04-08 | CSC | Futures | 2.885 | 2.885 | 2.863 | 2.866 | 62.0 |
| 2019-04-08 | CT | Futures | 83.22 | 83.96 | 82.65 | 83.79 | 28062.0 |
| 2019-04-08 | DC | Futures | 24.38 | 24.4 | 24.2 | 24.22 | 81.0 |
| 2019-04-08 | DX | Futures | 92.976 | 92.995 | 92.569 | 92.641 | 12357.0 |
| 2019-04-08 | E1 | Futures | 1.17473 | 1.17718 | 1.17426 | 1.17566 | 16794.0 |
| 2019-04-08 | E6 | Futures | 1.23827 | 1.24474 | 1.23805 | 1.24331 | 146347.0 |
| 2019-04-08 | E7 | Futures | 1.2321 | 1.2386 | 1.2319 | 1.2372 | 3176.0 |
| 2019-04-08 | EBM | Futures | 199.78 | 201.1 | 199.51 | 200.57 | 12510.0 |
| 2019-04-08 | ED | Futures | 95.1453 | 95.155 | 95.1404 | 95.1502 | 140589.0 |
| 2019-04-08 | ER | Futures | 98.416 | 98.421 | 98.416 | 98.416 | 18648.0 |
| 2019-04-08 | EW | Futures | 2074.1 | 2074.4 | 2060.8 | 2072.9 | 11322.0 |
| 2019-04-08 | FBON | Futures | 134.99 | 135.11 | 134.88 | 135.06 | 155.0 |
| 2019-04-08 | FBTP | Futures | 114.93 | 115.09 | 114.69 | 114.89 | 42905.0 |
| 2019-04-08 | FBTS | Futures | 105.693 | 105.76 | 105.627 | 105.722 | 28821.0 |
| 2019-04-08 | FCE | Futures | 4871.5 | 4885.3 | 4861.7 | 4871.5 | 50089.0 |
| 2019-04-08 | FDAX | Futures | 12661.7 | 12661.7 | 12591.7 | 12604.8 | 79569.0 |
| 2019-04-08 | FDIV | Futures | 147.2 | 147.2 | 147.07 | 147.07 | 5.0 |
| 2019-04-08 | FDXM | Futures | 12550.4 | 12550.4 | 12482.5 | 12495.6 | 30367.0 |
| 2019-04-08 | FESX | Futures | 2948.8 | 2949.7 | 2934.8 | 2935.7 | 651170.0 |
| 2019-04-08 | FGBL | Futures | 159.62 | 159.78 | 159.38 | 159.6 | 358592.0 |
| 2019-04-08 | FGBM | Futures | 132.92 | 132.98 | 132.86 | 132.92 | 250058.0 |
| 2019-04-08 | FGBS | Futures | 112.749 | 112.764 | 112.739 | 112.754 | 206272.0 |
| 2019-04-08 | FGBX | Futures | 193.59 | 194.16 | 193.0 | 193.49 | 28262.0 |
| 2019-04-08 | FMWO | Futures | 7213.8 | 7232.3 | 7203.4 | 7211.5 | 1047.0 |
| 2019-04-08 | FOAT | Futures | 146.78 | 146.93 | 146.63 | 146.7 | 72314.0 |
| 2019-04-08 | FTDX | Futures | 2734.3 | 2734.3 | 2724.4 | 2724.4 | 52.0 |
| 2019-04-08 | FTI | Futures | 525.47 | 527.73 | 524.91 | 526.4 | 16019.0 |
| 2019-04-08 | FTUK | Futures | 6790.7 | 6790.7 | 6745.8 | 6763.7 | 90247.0 |
| 2019-04-08 | FVSA | Futures | 240.31 | 244.38 | 237.05 | 242.75 | 15100.0 |
| 2019-04-08 | FXXP | Futures | 341.4 | 342.1 | 340.6 | 340.7 | 45597.0 |
| 2019-04-08 | G | Futures | 118.08 | 118.25 | 118.01 | 118.15 | 125428.0 |
| 2019-04-08 | GF | Futures | 312.177 | 314.209 | 311.803 | 313.781 | 924.0 |
| 2019-04-08 | GSCI | Futures | 507.32 | 511.28 | 507.32 | 510.72 | 2789.0 |
> showing 50 of 116 rows — these rows as CSV