PREVIEW / futures_daily / 2022-07-06
file: by_date/futures_daily/2022/2022-07-06.parquet size: 10 KB rows: 127
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-06 | ES | Futures | 4305.5 | 4347.0 | 4272.68 | 4317.0 | 1684324.0 |
| 2022-07-06 | NQ | Futures | 13497.13 | 13672.97 | 13391.5 | 13565.64 | 649912.0 |
| 2022-07-06 | YM | Futures | 33848.3 | 34119.5 | 33608.9 | 33908.5 | 169287.0 |
| 2022-07-06 | CL | Futures | 83.18 | 84.66 | 78.82 | 81.66 | 444106.0 |
| 2022-07-06 | GC | Futures | 2038.7 | 2047.1 | 2000.0 | 2006.7 | 258824.0 |
| 2022-07-06 | ZN | Futures | 123.274439 | 123.917079 | 122.198017 | 122.406875 | 1618742.0 |
| 2022-07-06 | A6 | Futures | 0.69702 | 0.69979 | 0.69318 | 0.6961 | 88078.0 |
| 2022-07-06 | AD | Futures | 0.77842 | 0.77958 | 0.77563 | 0.77781 | 90379.0 |
| 2022-07-06 | ALI | Futures | 2652.37 | 2713.19 | 2652.37 | 2701.02 | 2613.0 |
| 2022-07-06 | B | Futures | 84.36 | 85.14 | 79.22 | 80.99 | 350296.0 |
| 2022-07-06 | B6 | Futures | 1.2143 | 1.2182 | 1.2066 | 1.2116 | 122836.0 |
| 2022-07-06 | BR | Futures | 0.15852 | 0.15861 | 0.15569 | 0.15774 | 310.0 |
| 2022-07-06 | BTC | Futures | 28309.8 | 28504.9 | 27501.3 | 28261.0 | 5808.0 |
| 2022-07-06 | BZ | Futures | 81.68 | 83.09 | 77.37 | 79.08 | 28820.0 |
| 2022-07-06 | C | Futures | 1284.0 | 1316.0 | 1283.0 | 1313.0 | 3573.0 |
| 2022-07-06 | CB | Futures | 221.673 | 221.673 | 213.836 | 219.86 | 46.0 |
| 2022-07-06 | CC | Futures | 1394.0 | 1418.0 | 1391.0 | 1408.0 | 27230.0 |
| 2022-07-06 | CNH | Futures | 6.3379 | 6.3379 | 6.322 | 6.3301 | 385.0 |
| 2022-07-06 | CSC | Futures | 2.971 | 2.971 | 2.922 | 2.95 | 38.0 |
| 2022-07-06 | CT | Futures | 128.36 | 128.36 | 122.19 | 122.2 | 73.0 |
| 2022-07-06 | DC | Futures | 28.09 | 28.16 | 27.49 | 27.75 | 279.0 |
| 2022-07-06 | DX | Futures | 102.572 | 103.286 | 102.384 | 103.12 | 38049.0 |
| 2022-07-06 | E1 | Futures | 1.14737 | 1.14936 | 1.14068 | 1.14433 | 22331.0 |
| 2022-07-06 | E6 | Futures | 1.08555 | 1.08666 | 1.07446 | 1.07656 | 225402.0 |
| 2022-07-06 | E7 | Futures | 1.079 | 1.0801 | 1.0681 | 1.0701 | 7345.0 |
| 2022-07-06 | EBM | Futures | 466.91 | 475.67 | 451.49 | 456.39 | 26425.0 |
| 2022-07-06 | ED | Futures | 95.1528 | 95.197 | 95.0545 | 95.0938 | 122994.0 |
| 2022-07-06 | ER | Futures | 98.446 | 98.48 | 98.426 | 98.45 | 142086.0 |
| 2022-07-06 | ESG | Futures | 372.76 | 375.64 | 370.17 | 373.58 | 556.0 |
| 2022-07-06 | EW | Futures | 2496.4 | 2510.2 | 2453.2 | 2482.3 | 12917.0 |
| 2022-07-06 | FBON | Futures | 129.24 | 130.29 | 128.91 | 129.86 | 451.0 |
| 2022-07-06 | FBTP | Futures | 115.95 | 117.36 | 115.62 | 116.48 | 134477.0 |
| 2022-07-06 | FBTS | Futures | 107.768 | 108.261 | 107.729 | 108.005 | 89367.0 |
| 2022-07-06 | FCE | Futures | 6366.0 | 6480.7 | 6350.7 | 6429.6 | 63013.0 |
| 2022-07-06 | FDAX | Futures | 13504.6 | 13635.8 | 13381.9 | 13536.8 | 70118.0 |
| 2022-07-06 | FDIV | Futures | 150.98 | 150.98 | 148.84 | 149.54 | 118.0 |
| 2022-07-06 | FDXM | Futures | 13586.0 | 13718.1 | 13465.8 | 13619.5 | 46721.0 |
| 2022-07-06 | FDXS | Futures | 13477.5 | 13606.3 | 13356.1 | 13508.6 | 24621.0 |
| 2022-07-06 | FESX | Futures | 3372.2 | 3410.9 | 3346.4 | 3382.1 | 984272.0 |
| 2022-07-06 | FGBL | Futures | 148.87 | 150.92 | 148.59 | 149.94 | 882491.0 |
| 2022-07-06 | FGBM | Futures | 127.25 | 128.43 | 127.11 | 127.9 | 677381.0 |
| 2022-07-06 | FGBS | Futures | 111.415 | 111.812 | 111.369 | 111.618 | 600875.0 |
| 2022-07-06 | FGBX | Futures | 170.68 | 174.07 | 169.76 | 171.29 | 79980.0 |
| 2022-07-06 | FMWO | Futures | 9166.8 | 9212.5 | 9105.9 | 9125.8 | 11912.0 |
| 2022-07-06 | FOAT | Futures | 136.31 | 138.07 | 136.12 | 137.26 | 175427.0 |
| 2022-07-06 | FSMX | Futures | 26591.1 | 26841.3 | 26560.1 | 26684.1 | 618.0 |
| 2022-07-06 | FTDX | Futures | 3099.2 | 3136.1 | 3096.5 | 3127.6 | 72.0 |
| 2022-07-06 | FTI | Futures | 648.01 | 660.01 | 646.26 | 653.77 | 22953.0 |
| 2022-07-06 | FTUK | Futures | 7125.4 | 7242.5 | 7108.6 | 7145.1 | 134443.0 |
| 2022-07-06 | FVSA | Futures | 86.57 | 87.43 | 83.54 | 86.71 | 23202.0 |
> showing 50 of 127 rows — these rows as CSV