PREVIEW / futures_daily / 2019-03-28
file: by_date/futures_daily/2019/2019-03-28.parquet size: 10 KB rows: 115
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-03-28 | ES | Futures | 3032.05 | 3050.68 | 3019.09 | 3047.17 | 1185882.0 |
| 2019-03-28 | NQ | Futures | 8438.17 | 8494.63 | 8399.0 | 8471.01 | 446378.0 |
| 2019-03-28 | YM | Futures | 27045.5 | 27193.3 | 26944.1 | 27166.9 | 181851.0 |
| 2019-03-28 | CL | Futures | 60.99 | 61.16 | 59.76 | 60.89 | 712209.0 |
| 2019-03-28 | GC | Futures | 1636.7 | 1639.9 | 1609.7 | 1612.2 | 426819.0 |
| 2019-03-28 | ZN | Futures | 124.020591 | 124.269223 | 123.647644 | 123.818578 | 1775988.0 |
| 2019-03-28 | A6 | Futures | 0.73147 | 0.73364 | 0.729 | 0.73065 | 90794.0 |
| 2019-03-28 | AD | Futures | 0.75519 | 0.7562 | 0.75312 | 0.75372 | 76908.0 |
| 2019-03-28 | B | Futures | 48.88 | 49.03 | 48.02 | 48.87 | 434893.0 |
| 2019-03-28 | B6 | Futures | 1.3527 | 1.3571 | 1.3403 | 1.3428 | 135940.0 |
| 2019-03-28 | BR | Futures | 0.1992 | 0.20384 | 0.1992 | 0.20384 | 822.0 |
| 2019-03-28 | BTC | Futures | 6188.1 | 6226.8 | 6165.0 | 6188.1 | 832.0 |
| 2019-03-28 | BZ | Futures | 48.87 | 48.9 | 47.9 | 48.74 | 48206.0 |
| 2019-03-28 | C | Futures | 1504.0 | 1523.0 | 1502.0 | 1521.0 | 7333.0 |
| 2019-03-28 | CB | Futures | 279.949 | 279.949 | 279.919 | 279.919 | 3.0 |
| 2019-03-28 | CC | Futures | 1511.0 | 1538.0 | 1506.0 | 1523.0 | 15737.0 |
| 2019-03-28 | CNH | Futures | 6.7501 | 6.7599 | 6.7391 | 6.7481 | 670.0 |
| 2019-03-28 | CSC | Futures | 2.849 | 2.849 | 2.824 | 2.838 | 55.0 |
| 2019-03-28 | CT | Futures | 81.7 | 81.91 | 80.18 | 80.55 | 16636.0 |
| 2019-03-28 | DC | Futures | 24.0 | 24.11 | 23.86 | 23.99 | 186.0 |
| 2019-03-28 | DX | Futures | 92.483 | 92.837 | 92.363 | 92.75 | 20791.0 |
| 2019-03-28 | E1 | Futures | 1.18208 | 1.1822 | 1.17869 | 1.18103 | 25219.0 |
| 2019-03-28 | E6 | Futures | 1.24298 | 1.24403 | 1.23881 | 1.24024 | 193757.0 |
| 2019-03-28 | E7 | Futures | 1.2368 | 1.2378 | 1.2326 | 1.2341 | 6591.0 |
| 2019-03-28 | EBM | Futures | 196.34 | 197.4 | 195.81 | 196.87 | 15337.0 |
| 2019-03-28 | ED | Futures | 95.1892 | 95.199 | 95.1648 | 95.1795 | 391010.0 |
| 2019-03-28 | ER | Futures | 98.411 | 98.421 | 98.411 | 98.411 | 82260.0 |
| 2019-03-28 | EW | Futures | 1992.5 | 2013.8 | 1984.5 | 2011.0 | 12876.0 |
| 2019-03-28 | FBON | Futures | 135.48 | 135.51 | 134.94 | 135.12 | 411.0 |
| 2019-03-28 | FBTP | Futures | 115.16 | 115.22 | 114.38 | 114.91 | 100701.0 |
| 2019-03-28 | FBTS | Futures | 105.884 | 105.884 | 105.541 | 105.741 | 51643.0 |
| 2019-03-28 | FCE | Futures | 4731.1 | 4742.7 | 4710.2 | 4714.6 | 56917.0 |
| 2019-03-28 | FDAX | Futures | 12035.3 | 12119.0 | 12003.8 | 12050.1 | 102374.0 |
| 2019-03-28 | FDXM | Futures | 11938.9 | 12013.0 | 11901.3 | 11945.6 | 42833.0 |
| 2019-03-28 | FESX | Futures | 2836.0 | 2847.4 | 2827.3 | 2832.6 | 782170.0 |
| 2019-03-28 | FGBL | Futures | 160.73 | 160.94 | 160.42 | 160.59 | 755958.0 |
| 2019-03-28 | FGBM | Futures | 133.22 | 133.28 | 133.07 | 133.13 | 690545.0 |
| 2019-03-28 | FGBS | Futures | 112.799 | 112.809 | 112.759 | 112.794 | 549833.0 |
| 2019-03-28 | FGBX | Futures | 197.39 | 198.35 | 196.23 | 196.78 | 75882.0 |
| 2019-03-28 | FMWO | Futures | 7021.7 | 7050.7 | 7010.2 | 7015.9 | 3774.0 |
| 2019-03-28 | FOAT | Futures | 147.57 | 147.62 | 147.18 | 147.35 | 133209.0 |
| 2019-03-28 | FTDX | Futures | 2627.2 | 2648.4 | 2627.2 | 2632.1 | 32.0 |
| 2019-03-28 | FTI | Futures | 510.1 | 511.97 | 508.5 | 508.89 | 18952.0 |
| 2019-03-28 | FTUK | Futures | 6527.1 | 6596.8 | 6523.0 | 6568.8 | 77214.0 |
| 2019-03-28 | FVSA | Futures | 262.3 | 264.75 | 257.42 | 262.3 | 19995.0 |
| 2019-03-28 | FXXP | Futures | 331.9 | 332.8 | 330.9 | 331.0 | 37432.0 |
| 2019-03-28 | G | Futures | 119.33 | 119.64 | 119.13 | 119.22 | 199731.0 |
| 2019-03-28 | GF | Futures | 311.75 | 312.445 | 311.161 | 312.124 | 1773.0 |
| 2019-03-28 | GSCI | Futures | 486.94 | 489.99 | 486.94 | 489.88 | 20.0 |
| 2019-03-28 | HE | Futures | 84.602 | 84.997 | 82.627 | 82.627 | 478.0 |
> showing 50 of 115 rows — these rows as CSV