PREVIEW / futures_daily / 2020-08-28
file: by_date/futures_daily/2020/2020-08-28.parquet size: 10 KB rows: 120
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-08-28 | ES | Futures | 3926.05 | 3950.25 | 3917.89 | 3944.62 | 1248430.0 |
| 2020-08-28 | NQ | Futures | 13873.41 | 13948.86 | 13835.4 | 13918.1 | 489066.0 |
| 2020-08-28 | YM | Futures | 30559.3 | 30776.8 | 30481.0 | 30662.2 | 147833.0 |
| 2020-08-28 | CL | Futures | 31.08 | 31.4 | 30.87 | 31.07 | 272800.0 |
| 2020-08-28 | GC | Futures | 2288.2 | 2341.9 | 2277.2 | 2332.4 | 334102.0 |
| 2020-08-28 | ZN | Futures | 137.660553 | 138.109614 | 137.474734 | 138.00122 | 899499.0 |
| 2020-08-28 | A6 | Futures | 0.74693 | 0.75793 | 0.74631 | 0.7568 | 99011.0 |
| 2020-08-28 | AD | Futures | 0.77332 | 0.77799 | 0.77296 | 0.77525 | 88965.0 |
| 2020-08-28 | ALI | Futures | 2129.3 | 2153.42 | 2125.43 | 2145.98 | 158.0 |
| 2020-08-28 | B | Futures | 29.09 | 29.28 | 28.9 | 29.2 | 223895.0 |
| 2020-08-28 | B6 | Futures | 1.3407 | 1.3563 | 1.339 | 1.3549 | 113205.0 |
| 2020-08-28 | BR | Futures | 0.14266 | 0.14502 | 0.1423 | 0.14502 | 55.0 |
| 2020-08-28 | BTC | Futures | 15419.0 | 15797.0 | 15351.5 | 15702.5 | 7783.0 |
| 2020-08-28 | BZ | Futures | 28.41 | 28.63 | 28.27 | 28.57 | 21040.0 |
| 2020-08-28 | C | Futures | 1536.0 | 1580.0 | 1525.0 | 1570.0 | 10299.0 |
| 2020-08-28 | CB | Futures | 172.278 | 172.278 | 170.246 | 170.246 | 24.0 |
| 2020-08-28 | CC | Futures | 1684.0 | 1730.0 | 1667.0 | 1722.0 | 22891.0 |
| 2020-08-28 | CNH | Futures | 6.7896 | 6.7896 | 6.7617 | 6.7656 | 1029.0 |
| 2020-08-28 | CSC | Futures | 3.315 | 3.318 | 3.304 | 3.304 | 57.0 |
| 2020-08-28 | CT | Futures | 65.05 | 65.1 | 64.98 | 65.1 | 3.0 |
| 2020-08-28 | DC | Futures | 26.77 | 26.77 | 26.65 | 26.71 | 74.0 |
| 2020-08-28 | DX | Futures | 89.861 | 89.928 | 89.04 | 89.232 | 35365.0 |
| 2020-08-28 | E1 | Futures | 1.25011 | 1.25908 | 1.24852 | 1.25556 | 26706.0 |
| 2020-08-28 | E6 | Futures | 1.26879 | 1.27941 | 1.26772 | 1.2763 | 236265.0 |
| 2020-08-28 | E7 | Futures | 1.2624 | 1.2731 | 1.2613 | 1.27 | 10607.0 |
| 2020-08-28 | EBM | Futures | 225.14 | 226.04 | 224.24 | 225.14 | 3644.0 |
| 2020-08-28 | ED | Futures | 96.433 | 96.4427 | 96.4306 | 96.4427 | 156497.0 |
| 2020-08-28 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.401 | 65890.0 |
| 2020-08-28 | ESG | Futures | 319.1 | 320.5 | 319.1 | 320.45 | 19.0 |
| 2020-08-28 | EW | Futures | 2064.1 | 2079.4 | 2053.0 | 2069.5 | 10986.0 |
| 2020-08-28 | FBON | Futures | 145.8 | 146.25 | 145.74 | 146.19 | 618.0 |
| 2020-08-28 | FBTP | Futures | 132.63 | 132.94 | 132.49 | 132.77 | 115985.0 |
| 2020-08-28 | FBTS | Futures | 108.919 | 108.987 | 108.9 | 108.967 | 58689.0 |
| 2020-08-28 | FCE | Futures | 4899.5 | 4902.9 | 4832.8 | 4865.9 | 57665.0 |
| 2020-08-28 | FDAX | Futures | 13916.2 | 14012.9 | 13749.9 | 13836.5 | 74261.0 |
| 2020-08-28 | FDIV | Futures | 150.43 | 150.43 | 150.33 | 150.33 | 40.0 |
| 2020-08-28 | FDXM | Futures | 13863.9 | 13961.3 | 13700.8 | 13786.6 | 41707.0 |
| 2020-08-28 | FESX | Futures | 3073.0 | 3093.4 | 3040.7 | 3059.2 | 760475.0 |
| 2020-08-28 | FGBL | Futures | 167.48 | 167.99 | 167.26 | 167.85 | 916048.0 |
| 2020-08-28 | FGBM | Futures | 134.57 | 134.72 | 134.49 | 134.65 | 495048.0 |
| 2020-08-28 | FGBS | Futures | 112.684 | 112.704 | 112.659 | 112.694 | 373741.0 |
| 2020-08-28 | FGBX | Futures | 222.17 | 223.76 | 220.79 | 223.36 | 65838.0 |
| 2020-08-28 | FMWO | Futures | 8637.0 | 8666.6 | 8584.8 | 8606.2 | 1913.0 |
| 2020-08-28 | FOAT | Futures | 155.24 | 155.68 | 155.16 | 155.56 | 229993.0 |
| 2020-08-28 | FTDX | Futures | 3159.9 | 3182.4 | 3159.9 | 3176.3 | 14.0 |
| 2020-08-28 | FTI | Futures | 526.0 | 526.09 | 516.91 | 518.35 | 27197.0 |
| 2020-08-28 | FTUK | Futures | 5676.5 | 5708.6 | 5622.1 | 5634.4 | 97173.0 |
| 2020-08-28 | FVSA | Futures | 206.24 | 219.94 | 202.51 | 215.79 | 27465.0 |
| 2020-08-28 | FXXP | Futures | 343.3 | 343.4 | 338.5 | 340.5 | 43205.0 |
| 2020-08-28 | G | Futures | 125.35 | 125.9 | 125.18 | 125.82 | 229933.0 |
> showing 50 of 120 rows — these rows as CSV