PREVIEW / futures_daily / 2021-07-01
file: by_date/futures_daily/2021/2021-07-01.parquet size: 10 KB rows: 122
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 |
|---|---|---|---|---|---|---|---|
| 2021-07-01 | ES | Futures | 4827.05 | 4847.01 | 4817.78 | 4845.6 | 985190.0 |
| 2021-07-01 | NQ | Futures | 16795.95 | 16851.04 | 16695.0 | 16784.42 | 436419.0 |
| 2021-07-01 | YM | Futures | 37352.6 | 37464.3 | 37275.6 | 37424.2 | 110332.0 |
| 2021-07-01 | CL | Futures | 52.72 | 54.68 | 52.65 | 53.97 | 615678.0 |
| 2021-07-01 | GC | Futures | 2071.2 | 2085.9 | 2065.5 | 2078.2 | 171443.0 |
| 2021-07-01 | ZN | Futures | 133.914943 | 134.073086 | 133.78843 | 133.867501 | 1124574.0 |
| 2021-07-01 | A6 | Futures | 0.76946 | 0.77023 | 0.76526 | 0.76536 | 74007.0 |
| 2021-07-01 | AD | Futures | 0.81758 | 0.81991 | 0.81449 | 0.81469 | 49948.0 |
| 2021-07-01 | ALI | Futures | 2906.75 | 2912.77 | 2891.83 | 2910.76 | 839.0 |
| 2021-07-01 | B | Futures | 49.31 | 50.67 | 49.22 | 50.07 | 405155.0 |
| 2021-07-01 | B6 | Futures | 1.4039 | 1.4049 | 1.3965 | 1.3967 | 98231.0 |
| 2021-07-01 | BFX | Futures | 4250.6 | 4256.7 | 4250.6 | 4256.7 | 1.0 |
| 2021-07-01 | BR | Futures | 0.15927 | 0.16051 | 0.15727 | 0.15783 | 316.0 |
| 2021-07-01 | BTC | Futures | 49526.6 | 50124.9 | 46577.6 | 47054.9 | 4607.0 |
| 2021-07-01 | BZ | Futures | 48.21 | 49.53 | 48.11 | 48.95 | 52210.0 |
| 2021-07-01 | C | Futures | 1453.0 | 1463.0 | 1443.0 | 1444.0 | 2946.0 |
| 2021-07-01 | CB | Futures | 143.012 | 143.012 | 142.009 | 142.41 | 8.0 |
| 2021-07-01 | CC | Futures | 1567.0 | 1582.0 | 1542.0 | 1544.0 | 19168.0 |
| 2021-07-01 | CNH | Futures | 6.2686 | 6.2771 | 6.2616 | 6.2746 | 577.0 |
| 2021-07-01 | CSC | Futures | 2.493 | 2.498 | 2.486 | 2.49 | 101.0 |
| 2021-07-01 | CT | Futures | 79.47 | 80.76 | 79.21 | 79.99 | 36.0 |
| 2021-07-01 | DC | Futures | 22.71 | 22.71 | 22.5 | 22.54 | 254.0 |
| 2021-07-01 | DX | Futures | 89.269 | 89.506 | 89.172 | 89.5 | 20837.0 |
| 2021-07-01 | E1 | Futures | 1.21606 | 1.21808 | 1.21348 | 1.21438 | 25422.0 |
| 2021-07-01 | E6 | Futures | 1.26302 | 1.26594 | 1.26089 | 1.26132 | 154435.0 |
| 2021-07-01 | E7 | Futures | 1.2567 | 1.2595 | 1.2546 | 1.255 | 4442.0 |
| 2021-07-01 | EBM | Futures | 310.03 | 314.81 | 306.36 | 307.46 | 17866.0 |
| 2021-07-01 | ED | Futures | 96.5297 | 96.5297 | 96.52 | 96.5248 | 82110.0 |
| 2021-07-01 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.465 | 25391.0 |
| 2021-07-01 | ESG | Futures | 399.04 | 399.82 | 398.54 | 399.71 | 441.0 |
| 2021-07-01 | EW | Futures | 2896.2 | 2923.3 | 2893.7 | 2916.3 | 12133.0 |
| 2021-07-01 | FBON | Futures | 148.06 | 148.34 | 147.86 | 148.26 | 500.0 |
| 2021-07-01 | FBTP | Futures | 138.42 | 138.78 | 138.2 | 138.68 | 107947.0 |
| 2021-07-01 | FBTS | Futures | 110.195 | 110.224 | 110.175 | 110.214 | 53308.0 |
| 2021-07-01 | FCE | Futures | 6515.0 | 6563.8 | 6474.1 | 6525.9 | 66404.0 |
| 2021-07-01 | FDAX | Futures | 16668.4 | 16810.9 | 16575.2 | 16687.7 | 80832.0 |
| 2021-07-01 | FDIV | Futures | 188.48 | 188.48 | 187.5 | 187.84 | 50.0 |
| 2021-07-01 | FDXM | Futures | 16590.0 | 16728.5 | 16493.0 | 16604.9 | 52524.0 |
| 2021-07-01 | FDXS | Futures | 16485.6 | 16622.3 | 16388.2 | 16499.4 | 6524.0 |
| 2021-07-01 | FESX | Futures | 3851.3 | 3888.2 | 3827.1 | 3852.7 | 792717.0 |
| 2021-07-01 | FGBL | Futures | 167.1 | 167.28 | 166.83 | 167.14 | 666568.0 |
| 2021-07-01 | FGBM | Futures | 134.61 | 134.68 | 134.51 | 134.63 | 328203.0 |
| 2021-07-01 | FGBS | Futures | 112.569 | 112.589 | 112.559 | 112.584 | 163124.0 |
| 2021-07-01 | FGBX | Futures | 216.91 | 217.17 | 215.78 | 216.72 | 67488.0 |
| 2021-07-01 | FMWO | Futures | 10660.0 | 10689.3 | 10625.9 | 10656.4 | 3132.0 |
| 2021-07-01 | FOAT | Futures | 154.99 | 155.24 | 154.78 | 155.11 | 242994.0 |
| 2021-07-01 | FTDX | Futures | 3659.9 | 3659.9 | 3612.7 | 3636.3 | 114.0 |
| 2021-07-01 | FTI | Futures | 697.86 | 702.57 | 691.14 | 696.12 | 27170.0 |
| 2021-07-01 | FTUK | Futures | 6885.8 | 6972.5 | 6876.5 | 6943.0 | 105407.0 |
| 2021-07-01 | FVSA | Futures | 82.75 | 84.12 | 80.46 | 82.29 | 30737.0 |
> showing 50 of 122 rows — these rows as CSV