PREVIEW / futures_daily / 2020-04-02
file: by_date/futures_daily/2020/2020-04-02.parquet size: 10 KB rows: 118
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-04-02 | ES | Futures | 2720.85 | 2793.88 | 2682.95 | 2784.47 | 2145458.0 |
| 2020-04-02 | NQ | Futures | 8567.92 | 8777.43 | 8456.14 | 8744.18 | 436829.0 |
| 2020-04-02 | YM | Futures | 22215.0 | 22807.2 | 21874.6 | 22699.4 | 247194.0 |
| 2020-04-02 | CL | Futures | 21.03 | 27.15 | 20.57 | 25.09 | 1095972.0 |
| 2020-04-02 | GC | Futures | 1943.3 | 1995.7 | 1934.5 | 1986.1 | 167707.0 |
| 2020-04-02 | ZN | Futures | 137.608582 | 137.762938 | 137.099206 | 137.207255 | 1185789.0 |
| 2020-04-02 | A6 | Futures | 0.6235 | 0.62884 | 0.61723 | 0.62145 | 84524.0 |
| 2020-04-02 | AD | Futures | 0.71436 | 0.72019 | 0.70914 | 0.71477 | 82402.0 |
| 2020-04-02 | ALI | Futures | 1820.44 | 1835.01 | 1808.0 | 1827.42 | 37.0 |
| 2020-04-02 | B | Futures | 19.62 | 27.8 | 19.49 | 22.93 | 612268.0 |
| 2020-04-02 | B6 | Futures | 1.2583 | 1.2673 | 1.2542 | 1.2591 | 65035.0 |
| 2020-04-02 | BR | Futures | 0.15571 | 0.15571 | 0.15464 | 0.15489 | 84.0 |
| 2020-04-02 | BTC | Futures | 9078.4 | 10418.9 | 9050.0 | 9738.0 | 9591.0 |
| 2020-04-02 | BZ | Futures | 19.05 | 24.22 | 18.9 | 22.25 | 65518.0 |
| 2020-04-02 | C | Futures | 1612.0 | 1635.0 | 1605.0 | 1631.0 | 6109.0 |
| 2020-04-02 | CB | Futures | 165.375 | 165.375 | 161.722 | 161.722 | 26.0 |
| 2020-04-02 | CC | Futures | 1475.0 | 1499.0 | 1460.0 | 1496.0 | 16297.0 |
| 2020-04-02 | CNH | Futures | 7.0562 | 7.068 | 7.0204 | 7.0333 | 582.0 |
| 2020-04-02 | CSC | Futures | 2.712 | 2.736 | 2.677 | 2.717 | 117.0 |
| 2020-04-02 | CT | Futures | 47.13 | 49.56 | 46.77 | 48.13 | 20779.0 |
| 2020-04-02 | DC | Futures | 21.74 | 21.82 | 21.2 | 21.63 | 694.0 |
| 2020-04-02 | DX | Futures | 96.335 | 97.181 | 96.161 | 96.96 | 12720.0 |
| 2020-04-02 | E1 | Futures | 1.18249 | 1.18317 | 1.17132 | 1.17326 | 24232.0 |
| 2020-04-02 | E6 | Futures | 1.17999 | 1.18122 | 1.16548 | 1.16859 | 172086.0 |
| 2020-04-02 | E7 | Futures | 1.1739 | 1.1751 | 1.1595 | 1.1625 | 6767.0 |
| 2020-04-02 | EBM | Futures | 215.29 | 216.69 | 213.05 | 213.61 | 18837.0 |
| 2020-04-02 | ED | Futures | 96.1793 | 96.2179 | 96.1551 | 96.2083 | 325614.0 |
| 2020-04-02 | ER | Futures | 98.303 | 98.308 | 98.289 | 98.298 | 70015.0 |
| 2020-04-02 | EW | Futures | 1436.6 | 1486.1 | 1413.2 | 1451.3 | 8202.0 |
| 2020-04-02 | FBON | Futures | 140.98 | 140.98 | 140.16 | 140.7 | 300.0 |
| 2020-04-02 | FBTP | Futures | 126.66 | 127.18 | 126.38 | 126.94 | 55180.0 |
| 2020-04-02 | FBTS | Futures | 107.355 | 107.451 | 107.287 | 107.374 | 38205.0 |
| 2020-04-02 | FCE | Futures | 4074.4 | 4130.6 | 4005.2 | 4085.5 | 50574.0 |
| 2020-04-02 | FDAX | Futures | 9941.3 | 10188.3 | 9846.1 | 10068.2 | 107233.0 |
| 2020-04-02 | FDIV | Futures | 107.82 | 108.05 | 106.8 | 108.05 | 150.0 |
| 2020-04-02 | FDXM | Futures | 9981.9 | 10233.8 | 9893.7 | 10116.3 | 94591.0 |
| 2020-04-02 | FESX | Futures | 2392.8 | 2458.9 | 2374.4 | 2427.7 | 1349876.0 |
| 2020-04-02 | FGBL | Futures | 167.74 | 167.77 | 166.8 | 167.11 | 540189.0 |
| 2020-04-02 | FGBM | Futures | 134.38 | 134.43 | 134.07 | 134.24 | 280749.0 |
| 2020-04-02 | FGBS | Futures | 112.744 | 112.82 | 112.744 | 112.785 | 192426.0 |
| 2020-04-02 | FGBX | Futures | 225.17 | 227.16 | 222.69 | 224.95 | 38562.0 |
| 2020-04-02 | FMWO | Futures | 6223.3 | 6276.3 | 6075.1 | 6203.3 | 2389.0 |
| 2020-04-02 | FOAT | Futures | 152.16 | 152.16 | 151.25 | 151.64 | 147365.0 |
| 2020-04-02 | FTDX | Futures | 2569.0 | 2577.1 | 2562.9 | 2577.1 | 11.0 |
| 2020-04-02 | FTI | Futures | 438.81 | 451.71 | 437.17 | 447.33 | 28234.0 |
| 2020-04-02 | FTUK | Futures | 5062.3 | 5231.1 | 5058.5 | 5147.6 | 143309.0 |
| 2020-04-02 | FVSA | Futures | 400.59 | 432.54 | 400.59 | 422.64 | 12923.0 |
| 2020-04-02 | FXXP | Futures | 285.5 | 288.6 | 281.1 | 285.6 | 52493.0 |
| 2020-04-02 | G | Futures | 125.03 | 125.46 | 124.91 | 125.09 | 175588.0 |
| 2020-04-02 | GF | Futures | 241.433 | 241.433 | 229.805 | 229.805 | 1503.0 |
> showing 50 of 118 rows — these rows as CSV