PREVIEW / futures_daily / 2020-09-21
file: by_date/futures_daily/2020/2020-09-21.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-09-21 | ES | Futures | 3723.78 | 3736.98 | 3615.08 | 3679.4 | 2507980.0 |
| 2020-09-21 | NQ | Futures | 12642.18 | 12746.09 | 12337.13 | 12722.06 | 727984.0 |
| 2020-09-21 | YM | Futures | 29679.1 | 29781.4 | 28619.8 | 29126.9 | 264286.0 |
| 2020-09-21 | CL | Futures | 29.57 | 29.79 | 27.91 | 28.39 | 405205.0 |
| 2020-09-21 | GC | Futures | 2311.6 | 2318.2 | 2226.7 | 2256.4 | 386667.0 |
| 2020-09-21 | ZN | Futures | 138.249209 | 138.590144 | 138.233712 | 138.419677 | 997320.0 |
| 2020-09-21 | A6 | Futures | 0.74919 | 0.75206 | 0.73913 | 0.74005 | 104213.0 |
| 2020-09-21 | AD | Futures | 0.7681 | 0.76956 | 0.7609 | 0.76105 | 104341.0 |
| 2020-09-21 | ALI | Futures | 2154.02 | 2154.02 | 2127.88 | 2129.06 | 164.0 |
| 2020-09-21 | B | Futures | 27.42 | 27.6 | 26.11 | 26.42 | 217355.0 |
| 2020-09-21 | B6 | Futures | 1.3111 | 1.3154 | 1.296 | 1.2979 | 107877.0 |
| 2020-09-21 | BR | Futures | 0.14274 | 0.14533 | 0.14226 | 0.14517 | 520.0 |
| 2020-09-21 | BTC | Futures | 14696.7 | 14858.7 | 13859.5 | 14156.6 | 12875.0 |
| 2020-09-21 | BZ | Futures | 26.83 | 26.99 | 25.55 | 25.84 | 24298.0 |
| 2020-09-21 | C | Futures | 1676.0 | 1720.0 | 1667.0 | 1678.0 | 8536.0 |
| 2020-09-21 | CB | Futures | 175.836 | 176.928 | 175.353 | 175.887 | 19.0 |
| 2020-09-21 | CC | Futures | 1743.0 | 1778.0 | 1713.0 | 1726.0 | 18315.0 |
| 2020-09-21 | CNH | Futures | 6.6665 | 6.6989 | 6.6499 | 6.691 | 937.0 |
| 2020-09-21 | CSC | Futures | 3.428 | 3.445 | 3.408 | 3.445 | 69.0 |
| 2020-09-21 | CT | Futures | 65.79 | 66.54 | 64.46 | 64.46 | 11.0 |
| 2020-09-21 | DC | Futures | 27.94 | 28.4 | 27.87 | 28.14 | 280.0 |
| 2020-09-21 | DX | Futures | 89.839 | 90.622 | 89.598 | 90.495 | 32237.0 |
| 2020-09-21 | E1 | Futures | 1.2459 | 1.24907 | 1.23752 | 1.24024 | 29907.0 |
| 2020-09-21 | E6 | Futures | 1.27125 | 1.27404 | 1.25882 | 1.2614 | 234778.0 |
| 2020-09-21 | E7 | Futures | 1.2646 | 1.2675 | 1.2524 | 1.255 | 8246.0 |
| 2020-09-21 | EBM | Futures | 233.27 | 235.08 | 232.67 | 232.97 | 37739.0 |
| 2020-09-21 | ED | Futures | 96.4697 | 96.4745 | 96.46 | 96.4648 | 187435.0 |
| 2020-09-21 | ER | Futures | 98.435 | 98.45 | 98.435 | 98.45 | 86301.0 |
| 2020-09-21 | ESG | Futures | 301.62 | 303.38 | 298.22 | 303.38 | 50.0 |
| 2020-09-21 | EW | Futures | 1989.2 | 1997.7 | 1915.6 | 1939.1 | 15801.0 |
| 2020-09-21 | FBON | Futures | 147.37 | 148.16 | 147.37 | 147.93 | 343.0 |
| 2020-09-21 | FBTP | Futures | 134.28 | 134.95 | 133.9 | 134.54 | 119904.0 |
| 2020-09-21 | FBTS | Futures | 109.189 | 109.315 | 109.122 | 109.247 | 80828.0 |
| 2020-09-21 | FCE | Futures | 4793.3 | 4797.7 | 4624.1 | 4637.6 | 103493.0 |
| 2020-09-21 | FDAX | Futures | 14003.6 | 14005.8 | 13304.2 | 13317.0 | 127827.0 |
| 2020-09-21 | FDIV | Futures | 146.73 | 147.01 | 144.46 | 144.46 | 240.0 |
| 2020-09-21 | FDXM | Futures | 13930.4 | 13935.7 | 13236.6 | 13249.9 | 99935.0 |
| 2020-09-21 | FESX | Futures | 3027.7 | 3029.6 | 2900.2 | 2903.9 | 1524331.0 |
| 2020-09-21 | FGBL | Futures | 169.29 | 170.04 | 169.17 | 169.85 | 608361.0 |
| 2020-09-21 | FGBM | Futures | 135.01 | 135.3 | 134.96 | 135.23 | 369917.0 |
| 2020-09-21 | FGBS | Futures | 112.744 | 112.83 | 112.744 | 112.82 | 398895.0 |
| 2020-09-21 | FGBX | Futures | 229.84 | 232.95 | 229.4 | 232.2 | 67896.0 |
| 2020-09-21 | FMWO | Futures | 8299.3 | 8299.3 | 8052.9 | 8077.8 | 2908.0 |
| 2020-09-21 | FOAT | Futures | 157.49 | 158.04 | 157.28 | 157.85 | 167559.0 |
| 2020-09-21 | FTDX | Futures | 3166.6 | 3166.6 | 3057.6 | 3068.4 | 119.0 |
| 2020-09-21 | FTI | Futures | 509.7 | 510.03 | 496.51 | 499.15 | 36249.0 |
| 2020-09-21 | FTUK | Futures | 5705.4 | 5715.9 | 5491.8 | 5511.4 | 137636.0 |
| 2020-09-21 | FVSA | Futures | 196.13 | 215.44 | 195.76 | 214.33 | 54223.0 |
| 2020-09-21 | FXXP | Futures | 338.3 | 338.3 | 328.2 | 328.8 | 87857.0 |
| 2020-09-21 | G | Futures | 127.16 | 127.71 | 127.12 | 127.55 | 156543.0 |
> showing 50 of 120 rows — these rows as CSV