PREVIEW / futures_daily / 2022-08-19
file: by_date/futures_daily/2022/2022-08-19.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-08-19 | ES | Futures | 4809.19 | 4810.31 | 4734.87 | 4746.93 | 1701251.0 |
| 2022-08-19 | NQ | Futures | 15454.28 | 15454.57 | 15105.44 | 15150.83 | 618758.0 |
| 2022-08-19 | YM | Futures | 37177.6 | 37184.2 | 36754.5 | 36852.9 | 139450.0 |
| 2022-08-19 | CL | Futures | 76.97 | 78.41 | 75.21 | 77.34 | 255422.0 |
| 2022-08-19 | GC | Futures | 2029.1 | 2029.4 | 2013.1 | 2017.5 | 138699.0 |
| 2022-08-19 | ZN | Futures | 122.246215 | 122.278347 | 121.362585 | 121.442915 | 1173347.0 |
| 2022-08-19 | A6 | Futures | 0.70865 | 0.70916 | 0.70291 | 0.70373 | 78340.0 |
| 2022-08-19 | AD | Futures | 0.78334 | 0.78334 | 0.77953 | 0.78039 | 70977.0 |
| 2022-08-19 | ALI | Futures | 2727.39 | 2729.94 | 2694.88 | 2703.36 | 943.0 |
| 2022-08-19 | B | Futures | 81.97 | 82.99 | 79.91 | 82.0 | 178601.0 |
| 2022-08-19 | B6 | Futures | 1.211 | 1.2116 | 1.197 | 1.199 | 119618.0 |
| 2022-08-19 | BR | Futures | 0.16722 | 0.16796 | 0.16609 | 0.167 | 6069.0 |
| 2022-08-19 | BTC | Futures | 32234.2 | 32289.5 | 29063.3 | 29332.7 | 11296.0 |
| 2022-08-19 | BZ | Futures | 80.16 | 81.19 | 78.18 | 80.23 | 22212.0 |
| 2022-08-19 | C | Futures | 1323.0 | 1331.0 | 1317.0 | 1318.0 | 2183.0 |
| 2022-08-19 | CB | Futures | 237.103 | 238.111 | 237.103 | 237.708 | 15.0 |
| 2022-08-19 | CC | Futures | 1405.0 | 1413.0 | 1385.0 | 1390.0 | 26912.0 |
| 2022-08-19 | CNH | Futures | 6.4159 | 6.4563 | 6.4159 | 6.4501 | 1778.0 |
| 2022-08-19 | CSC | Futures | 2.728 | 2.728 | 2.65 | 2.664 | 257.0 |
| 2022-08-19 | CT | Futures | 146.82 | 151.82 | 146.29 | 151.82 | 11.0 |
| 2022-08-19 | DC | Futures | 25.84 | 26.1 | 25.3 | 25.42 | 504.0 |
| 2022-08-19 | DX | Futures | 103.619 | 104.318 | 103.619 | 104.278 | 35342.0 |
| 2022-08-19 | E1 | Futures | 1.15821 | 1.15992 | 1.15445 | 1.15516 | 16720.0 |
| 2022-08-19 | E6 | Futures | 1.06299 | 1.06383 | 1.05715 | 1.05721 | 181920.0 |
| 2022-08-19 | E7 | Futures | 1.0574 | 1.0574 | 1.0508 | 1.0508 | 5459.0 |
| 2022-08-19 | EBM | Futures | 441.32 | 443.77 | 436.06 | 441.67 | 7361.0 |
| 2022-08-19 | ED | Futures | 95.0053 | 95.0103 | 94.9709 | 94.9931 | 116354.0 |
| 2022-08-19 | ER | Futures | 98.198 | 98.213 | 98.169 | 98.193 | 121166.0 |
| 2022-08-19 | ESG | Futures | 411.7 | 411.7 | 409.4 | 409.77 | 188.0 |
| 2022-08-19 | EW | Futures | 2853.2 | 2854.8 | 2799.8 | 2807.8 | 9099.0 |
| 2022-08-19 | FBON | Futures | 130.55 | 130.55 | 129.15 | 129.64 | 246.0 |
| 2022-08-19 | FBTP | Futures | 115.89 | 115.89 | 114.4 | 114.83 | 93852.0 |
| 2022-08-19 | FBTS | Futures | 107.187 | 107.187 | 106.922 | 107.04 | 50320.0 |
| 2022-08-19 | FCE | Futures | 7188.4 | 7195.5 | 7124.7 | 7136.2 | 60447.0 |
| 2022-08-19 | FDAX | Futures | 14701.2 | 14729.2 | 14533.3 | 14559.2 | 66166.0 |
| 2022-08-19 | FDIV | Futures | 161.71 | 161.71 | 160.62 | 160.62 | 5.0 |
| 2022-08-19 | FDXM | Futures | 14811.6 | 14815.9 | 14621.1 | 14648.1 | 33632.0 |
| 2022-08-19 | FDXS | Futures | 14681.3 | 14688.8 | 14503.0 | 14528.8 | 24171.0 |
| 2022-08-19 | FESX | Futures | 3741.3 | 3742.3 | 3688.7 | 3694.6 | 914791.0 |
| 2022-08-19 | FGBL | Futures | 151.65 | 151.65 | 150.04 | 150.18 | 562752.0 |
| 2022-08-19 | FGBM | Futures | 127.54 | 127.55 | 126.9 | 126.96 | 419674.0 |
| 2022-08-19 | FGBS | Futures | 111.247 | 111.247 | 111.07 | 111.095 | 440383.0 |
| 2022-08-19 | FGBX | Futures | 180.01 | 180.09 | 175.7 | 176.11 | 45862.0 |
| 2022-08-19 | FMWO | Futures | 10069.5 | 10069.5 | 9965.3 | 9968.8 | 4428.0 |
| 2022-08-19 | FOAT | Futures | 139.03 | 139.06 | 137.66 | 137.83 | 112816.0 |
| 2022-08-19 | FSMX | Futures | 29220.2 | 29289.7 | 28794.6 | 28822.4 | 445.0 |
| 2022-08-19 | FTDX | Futures | 3346.5 | 3349.1 | 3319.2 | 3322.9 | 46.0 |
| 2022-08-19 | FTI | Futures | 738.34 | 740.02 | 730.05 | 731.09 | 18893.0 |
| 2022-08-19 | FTUK | Futures | 7668.2 | 7679.4 | 7612.5 | 7640.9 | 100922.0 |
| 2022-08-19 | FVSA | Futures | 62.57 | 66.17 | 62.2 | 65.92 | 14219.0 |
> showing 50 of 127 rows — these rows as CSV