PREVIEW / futures_daily / 2023-04-20
file: by_date/futures_daily/2023/2023-04-20.parquet size: 10 KB rows: 130
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-20 | ES | Futures | 4565.37 | 4566.73 | 4526.8 | 4543.76 | 1768379.0 |
| 2023-04-20 | NQ | Futures | 14590.75 | 14632.88 | 14435.28 | 14493.48 | 680299.0 |
| 2023-04-20 | YM | Futures | 36448.2 | 36468.6 | 36221.1 | 36335.7 | 147308.0 |
| 2023-04-20 | CL | Futures | 68.9 | 68.94 | 67.11 | 67.46 | 361413.0 |
| 2023-04-20 | GC | Futures | 2227.7 | 2246.0 | 2221.6 | 2240.3 | 162840.0 |
| 2023-04-20 | ZN | Futures | 116.898297 | 117.473835 | 116.866322 | 117.313963 | 1148900.0 |
| 2023-04-20 | A6 | Futures | 0.68408 | 0.68982 | 0.6822 | 0.68682 | 73820.0 |
| 2023-04-20 | AD | Futures | 0.75338 | 0.75399 | 0.75166 | 0.75247 | 52595.0 |
| 2023-04-20 | ALI | Futures | 2665.28 | 2702.99 | 2654.36 | 2659.55 | 3606.0 |
| 2023-04-20 | B | Futures | 72.79 | 72.94 | 71.05 | 71.34 | 302902.0 |
| 2023-04-20 | B6 | Futures | 1.2508 | 1.2537 | 1.2473 | 1.2509 | 67614.0 |
| 2023-04-20 | BFX | Futures | 4139.4 | 4139.4 | 4139.4 | 4139.4 | 0.0 |
| 2023-04-20 | BR | Futures | 0.1765 | 0.17799 | 0.17623 | 0.17763 | 713.0 |
| 2023-04-20 | BTC | Futures | 39757.8 | 39839.5 | 38110.0 | 38259.8 | 7611.0 |
| 2023-04-20 | BZ | Futures | 72.64 | 72.67 | 70.68 | 70.97 | 26114.0 |
| 2023-04-20 | C | Futures | 1758.0 | 1762.0 | 1747.0 | 1750.0 | 3687.0 |
| 2023-04-20 | CB | Futures | 238.29 | 239.464 | 235.354 | 235.378 | 31.0 |
| 2023-04-20 | CC | Futures | 1722.0 | 1729.0 | 1710.0 | 1716.0 | 27634.0 |
| 2023-04-20 | CNH | Futures | 6.5551 | 6.565 | 6.5409 | 6.5496 | 459.0 |
| 2023-04-20 | CSC | Futures | 2.223 | 2.244 | 2.211 | 2.232 | 107.0 |
| 2023-04-20 | CT | Futures | 107.96 | 108.12 | 102.92 | 102.92 | 5553.0 |
| 2023-04-20 | DC | Futures | 21.19 | 21.21 | 20.87 | 21.08 | 366.0 |
| 2023-04-20 | DX | Futures | 99.399 | 99.545 | 99.062 | 99.273 | 10868.0 |
| 2023-04-20 | E1 | Futures | 1.20138 | 1.20845 | 1.20015 | 1.20663 | 18178.0 |
| 2023-04-20 | E6 | Futures | 1.13047 | 1.13371 | 1.12785 | 1.13114 | 149926.0 |
| 2023-04-20 | E7 | Futures | 1.1297 | 1.1331 | 1.1274 | 1.1307 | 4665.0 |
| 2023-04-20 | EBM | Futures | 369.97 | 372.56 | 368.12 | 369.6 | 25274.0 |
| 2023-04-20 | ER | Futures | 97.838 | 97.868 | 97.828 | 97.858 | 142415.0 |
| 2023-04-20 | ESG | Futures | 393.19 | 394.2 | 391.13 | 392.4 | 493.0 |
| 2023-04-20 | EW | Futures | 2688.8 | 2693.9 | 2666.6 | 2681.8 | 9262.0 |
| 2023-04-20 | FBON | Futures | 120.36 | 120.83 | 120.34 | 120.79 | 32.0 |
| 2023-04-20 | FBTP | Futures | 110.57 | 110.97 | 110.31 | 110.86 | 159822.0 |
| 2023-04-20 | FBTS | Futures | 106.047 | 106.148 | 105.946 | 106.118 | 101061.0 |
| 2023-04-20 | FCE | Futures | 8165.3 | 8169.7 | 8109.4 | 8144.6 | 58726.0 |
| 2023-04-20 | FDAX | Futures | 17085.4 | 17111.0 | 16926.5 | 16990.5 | 64175.0 |
| 2023-04-20 | FDIV | Futures | 188.82 | 188.82 | 187.99 | 187.99 | 35.0 |
| 2023-04-20 | FDXM | Futures | 17242.8 | 17256.8 | 17070.7 | 17135.3 | 35088.0 |
| 2023-04-20 | FDXS | Futures | 17126.0 | 17139.9 | 16956.1 | 17020.2 | 16141.0 |
| 2023-04-20 | FESX | Futures | 4432.4 | 4442.6 | 4402.7 | 4421.1 | 759465.0 |
| 2023-04-20 | FEU3 | Futures | 97.868 | 97.868 | 97.868 | 97.868 | 0.0 |
| 2023-04-20 | FGBL | Futures | 134.27 | 134.91 | 134.14 | 134.73 | 707810.0 |
| 2023-04-20 | FGBM | Futures | 118.6 | 118.95 | 118.53 | 118.87 | 565213.0 |
| 2023-04-20 | FGBS | Futures | 107.836 | 107.964 | 107.806 | 107.929 | 413255.0 |
| 2023-04-20 | FGBX | Futures | 138.66 | 139.94 | 138.17 | 139.39 | 57881.0 |
| 2023-04-20 | FMWO | Futures | 9935.7 | 9945.9 | 9878.1 | 9917.7 | 4451.0 |
| 2023-04-20 | FOAT | Futures | 125.37 | 125.9 | 125.17 | 125.74 | 205254.0 |
| 2023-04-20 | FSMX | Futures | 29509.1 | 29509.1 | 29344.4 | 29506.9 | 712.0 |
| 2023-04-20 | FTDX | Futures | 3527.3 | 3527.3 | 3473.7 | 3486.6 | 179.0 |
| 2023-04-20 | FTI | Futures | 799.85 | 803.92 | 795.82 | 800.74 | 11605.0 |
| 2023-04-20 | FTUK | Futures | 8036.1 | 8069.3 | 8027.0 | 8051.4 | 71620.0 |
> showing 50 of 130 rows — these rows as CSV