PREVIEW / futures_daily / 2022-08-17
file: by_date/futures_daily/2022/2022-08-17.parquet size: 10 KB rows: 126
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-17 | ES | Futures | 4834.15 | 4840.6 | 4773.29 | 4797.69 | 1638797.0 |
| 2022-08-17 | NQ | Futures | 15595.59 | 15611.57 | 15308.12 | 15407.47 | 610667.0 |
| 2022-08-17 | YM | Futures | 37313.2 | 37367.9 | 36960.1 | 37133.9 | 163823.0 |
| 2022-08-17 | CL | Futures | 74.15 | 75.82 | 73.1 | 74.99 | 187601.0 |
| 2022-08-17 | GC | Futures | 2049.4 | 2056.0 | 2030.1 | 2033.3 | 137832.0 |
| 2022-08-17 | ZN | Futures | 122.776393 | 122.824591 | 121.892763 | 122.117687 | 1254160.0 |
| 2022-08-17 | A6 | Futures | 0.71982 | 0.72018 | 0.70834 | 0.71167 | 110390.0 |
| 2022-08-17 | AD | Futures | 0.78932 | 0.79054 | 0.78384 | 0.78618 | 73162.0 |
| 2022-08-17 | ALI | Futures | 2736.72 | 2765.0 | 2727.68 | 2733.05 | 485.0 |
| 2022-08-17 | B | Futures | 78.57 | 80.11 | 77.59 | 79.4 | 199193.0 |
| 2022-08-17 | B6 | Futures | 1.2279 | 1.2329 | 1.2211 | 1.2247 | 95784.0 |
| 2022-08-17 | BR | Futures | 0.16861 | 0.16904 | 0.16617 | 0.16748 | 7336.0 |
| 2022-08-17 | BTC | Futures | 33104.7 | 33802.4 | 31978.6 | 32096.1 | 8565.0 |
| 2022-08-17 | BZ | Futures | 76.96 | 78.36 | 75.92 | 77.69 | 21011.0 |
| 2022-08-17 | C | Futures | 1296.0 | 1323.0 | 1284.0 | 1320.0 | 3422.0 |
| 2022-08-17 | CB | Futures | 233.679 | 238.332 | 233.054 | 237.909 | 63.0 |
| 2022-08-17 | CC | Futures | 1384.0 | 1424.0 | 1377.0 | 1418.0 | 29950.0 |
| 2022-08-17 | CNH | Futures | 6.4065 | 6.412 | 6.3894 | 6.4032 | 500.0 |
| 2022-08-17 | CSC | Futures | 2.819 | 2.82 | 2.767 | 2.771 | 138.0 |
| 2022-08-17 | CT | Futures | 154.86 | 154.86 | 148.66 | 150.01 | 27.0 |
| 2022-08-17 | DC | Futures | 26.89 | 27.05 | 26.28 | 26.63 | 602.0 |
| 2022-08-17 | DX | Futures | 102.611 | 103.021 | 102.427 | 102.722 | 23270.0 |
| 2022-08-17 | E1 | Futures | 1.16722 | 1.16882 | 1.16141 | 1.16506 | 20443.0 |
| 2022-08-17 | E6 | Futures | 1.07193 | 1.07551 | 1.06941 | 1.07356 | 170845.0 |
| 2022-08-17 | E7 | Futures | 1.0655 | 1.0689 | 1.0631 | 1.0672 | 6198.0 |
| 2022-08-17 | EBM | Futures | 466.56 | 467.61 | 452.19 | 458.85 | 10821.0 |
| 2022-08-17 | ED | Futures | 94.9931 | 95.0103 | 94.9243 | 94.998 | 178777.0 |
| 2022-08-17 | ER | Futures | 98.282 | 98.282 | 98.218 | 98.233 | 133364.0 |
| 2022-08-17 | ESG | Futures | 414.95 | 416.66 | 412.83 | 414.07 | 472.0 |
| 2022-08-17 | EW | Futures | 2874.0 | 2877.7 | 2813.9 | 2832.5 | 10016.0 |
| 2022-08-17 | FBON | Futures | 132.06 | 132.06 | 130.87 | 131.54 | 144.0 |
| 2022-08-17 | FBTP | Futures | 118.26 | 118.32 | 115.91 | 116.38 | 116510.0 |
| 2022-08-17 | FBTS | Futures | 107.857 | 107.857 | 107.237 | 107.296 | 57985.0 |
| 2022-08-17 | FCE | Futures | 7275.4 | 7281.2 | 7152.4 | 7171.3 | 72388.0 |
| 2022-08-17 | FDAX | Futures | 15004.7 | 15024.1 | 14635.6 | 14651.7 | 66145.0 |
| 2022-08-17 | FDIV | Futures | 162.95 | 162.95 | 161.61 | 161.61 | 71.0 |
| 2022-08-17 | FDXM | Futures | 15094.2 | 15118.0 | 14725.0 | 14741.2 | 31586.0 |
| 2022-08-17 | FDXS | Futures | 14976.6 | 14996.0 | 14604.0 | 14621.2 | 20664.0 |
| 2022-08-17 | FESX | Futures | 3785.9 | 3791.9 | 3716.5 | 3724.4 | 739433.0 |
| 2022-08-17 | FGBL | Futures | 153.77 | 153.92 | 151.82 | 152.1 | 619754.0 |
| 2022-08-17 | FGBM | Futures | 128.75 | 128.8 | 127.62 | 127.79 | 566198.0 |
| 2022-08-17 | FGBS | Futures | 111.624 | 111.634 | 111.258 | 111.288 | 532403.0 |
| 2022-08-17 | FGBX | Futures | 183.43 | 183.78 | 179.09 | 180.45 | 49909.0 |
| 2022-08-17 | FMWO | Futures | 10198.3 | 10198.3 | 10056.7 | 10087.1 | 7180.0 |
| 2022-08-17 | FOAT | Futures | 140.86 | 141.02 | 139.12 | 139.45 | 164356.0 |
| 2022-08-17 | FSMX | Futures | 30094.7 | 30120.4 | 29445.8 | 29460.7 | 2151.0 |
| 2022-08-17 | FTDX | Futures | 3398.4 | 3416.0 | 3350.2 | 3365.7 | 8.0 |
| 2022-08-17 | FTI | Futures | 742.1 | 743.83 | 733.21 | 734.72 | 16067.0 |
| 2022-08-17 | FTUK | Futures | 7643.9 | 7654.6 | 7584.6 | 7599.3 | 75476.0 |
| 2022-08-17 | FVSA | Futures | 61.83 | 64.68 | 61.33 | 63.32 | 21326.0 |
> showing 50 of 126 rows — these rows as CSV