PREVIEW / futures_daily / 2020-05-22
file: by_date/futures_daily/2020/2020-05-22.parquet size: 10 KB rows: 120
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-22 | ES | Futures | 3249.47 | 3272.43 | 3212.96 | 3267.45 | 1377263.0 |
| 2020-05-22 | NQ | Futures | 10731.25 | 10802.33 | 10594.82 | 10783.7 | 365377.0 |
| 2020-05-22 | YM | Futures | 26011.6 | 26149.2 | 25717.0 | 26061.7 | 194134.0 |
| 2020-05-22 | CL | Futures | 24.61 | 24.65 | 22.27 | 24.1 | 429036.0 |
| 2020-05-22 | GC | Futures | 2093.2 | 2112.6 | 2088.9 | 2104.7 | 196816.0 |
| 2020-05-22 | ZN | Futures | 137.377047 | 137.732067 | 137.361612 | 137.469661 | 1390072.0 |
| 2020-05-22 | A6 | Futures | 0.67415 | 0.67528 | 0.6685 | 0.67076 | 79548.0 |
| 2020-05-22 | AD | Futures | 0.72607 | 0.72688 | 0.72125 | 0.72308 | 43645.0 |
| 2020-05-22 | ALI | Futures | 1805.26 | 1806.74 | 1803.48 | 1806.74 | 3.0 |
| 2020-05-22 | B | Futures | 23.89 | 23.92 | 22.15 | 23.2 | 174586.0 |
| 2020-05-22 | B6 | Futures | 1.2407 | 1.2419 | 1.2344 | 1.2354 | 66931.0 |
| 2020-05-22 | BR | Futures | 0.14722 | 0.14821 | 0.1455 | 0.14714 | 8649.0 |
| 2020-05-22 | BTC | Futures | 12823.4 | 13032.1 | 12580.0 | 12872.1 | 595.0 |
| 2020-05-22 | BZ | Futures | 22.98 | 23.16 | 21.45 | 22.46 | 31482.0 |
| 2020-05-22 | C | Futures | 1862.0 | 1903.0 | 1854.0 | 1897.0 | 6124.0 |
| 2020-05-22 | CB | Futures | 187.765 | 187.765 | 185.09 | 185.384 | 30.0 |
| 2020-05-22 | CC | Futures | 1522.0 | 1572.0 | 1515.0 | 1564.0 | 19506.0 |
| 2020-05-22 | CNH | Futures | 7.0673 | 7.1026 | 7.0673 | 7.0876 | 413.0 |
| 2020-05-22 | CSC | Futures | 3.387 | 3.389 | 3.284 | 3.293 | 369.0 |
| 2020-05-22 | CT | Futures | 56.61 | 56.74 | 55.62 | 56.16 | 9723.0 |
| 2020-05-22 | DC | Futures | 27.99 | 27.99 | 26.93 | 27.08 | 817.0 |
| 2020-05-22 | DX | Futures | 96.161 | 96.601 | 96.117 | 96.589 | 13882.0 |
| 2020-05-22 | E1 | Futures | 1.17394 | 1.17497 | 1.17064 | 1.17167 | 17962.0 |
| 2020-05-22 | E6 | Futures | 1.17714 | 1.17778 | 1.17042 | 1.17064 | 120721.0 |
| 2020-05-22 | E7 | Futures | 1.1711 | 1.1716 | 1.1642 | 1.1645 | 4190.0 |
| 2020-05-22 | EBM | Futures | 225.74 | 226.34 | 224.24 | 225.44 | 15957.0 |
| 2020-05-22 | ED | Futures | 96.3968 | 96.3968 | 96.3702 | 96.375 | 200360.0 |
| 2020-05-22 | ER | Futures | 98.284 | 98.289 | 98.274 | 98.284 | 27396.0 |
| 2020-05-22 | ESG | Futures | 265.76 | 267.33 | 265.72 | 267.33 | 45.0 |
| 2020-05-22 | EW | Futures | 1787.8 | 1801.6 | 1758.9 | 1794.2 | 8495.0 |
| 2020-05-22 | FBON | Futures | 141.69 | 141.9 | 141.53 | 141.8 | 183.0 |
| 2020-05-22 | FBTP | Futures | 125.52 | 125.91 | 125.39 | 125.83 | 60382.0 |
| 2020-05-22 | FBTS | Futures | 107.383 | 107.46 | 107.326 | 107.403 | 32717.0 |
| 2020-05-22 | FCE | Futures | 4254.8 | 4337.8 | 4232.4 | 4307.2 | 56844.0 |
| 2020-05-22 | FDAX | Futures | 11724.5 | 11777.9 | 11482.3 | 11710.2 | 66333.0 |
| 2020-05-22 | FDIV | Futures | 123.87 | 124.24 | 123.87 | 124.24 | 85.0 |
| 2020-05-22 | FDXM | Futures | 11777.9 | 11834.2 | 11537.7 | 11766.2 | 61251.0 |
| 2020-05-22 | FESX | Futures | 2664.5 | 2675.5 | 2610.3 | 2658.9 | 824455.0 |
| 2020-05-22 | FGBL | Futures | 168.27 | 168.67 | 168.09 | 168.28 | 460081.0 |
| 2020-05-22 | FGBM | Futures | 134.73 | 134.85 | 134.68 | 134.72 | 274667.0 |
| 2020-05-22 | FGBS | Futures | 112.815 | 112.835 | 112.795 | 112.8 | 258582.0 |
| 2020-05-22 | FGBX | Futures | 227.41 | 228.92 | 226.5 | 227.27 | 36766.0 |
| 2020-05-22 | FMWO | Futures | 7117.4 | 7210.4 | 7100.9 | 7169.2 | 3193.0 |
| 2020-05-22 | FOAT | Futures | 153.38 | 153.53 | 152.95 | 153.14 | 88857.0 |
| 2020-05-22 | FTDX | Futures | 3123.0 | 3123.0 | 3076.0 | 3119.0 | 40.0 |
| 2020-05-22 | FTI | Futures | 481.72 | 489.91 | 478.41 | 487.89 | 24512.0 |
| 2020-05-22 | FTUK | Futures | 5675.3 | 5695.5 | 5549.8 | 5655.0 | 94073.0 |
| 2020-05-22 | FVSA | Futures | 276.42 | 284.11 | 266.92 | 271.89 | 9084.0 |
| 2020-05-22 | FXXP | Futures | 310.9 | 315.6 | 309.2 | 314.4 | 62831.0 |
| 2020-05-22 | G | Futures | 126.99 | 127.32 | 126.66 | 126.88 | 357345.0 |
> showing 50 of 120 rows — these rows as CSV