PREVIEW / futures_daily / 2021-03-18
file: by_date/futures_daily/2021/2021-03-18.parquet size: 10 KB rows: 122
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-18 | ES | Futures | 4445.98 | 4464.49 | 4376.96 | 4383.13 | 2124392.0 |
| 2021-03-18 | NQ | Futures | 15210.14 | 15302.41 | 14719.93 | 14740.41 | 708016.0 |
| 2021-03-18 | YM | Futures | 35625.1 | 35842.6 | 35416.2 | 35462.7 | 234148.0 |
| 2021-03-18 | CL | Futures | 45.87 | 46.19 | 41.49 | 42.76 | 728880.0 |
| 2021-03-18 | GC | Futures | 2047.4 | 2059.4 | 2015.2 | 2033.9 | 251758.0 |
| 2021-03-18 | ZN | Futures | 132.625738 | 132.76708 | 131.667754 | 131.934733 | 2858288.0 |
| 2021-03-18 | A6 | Futures | 0.79977 | 0.80515 | 0.79479 | 0.79608 | 125102.0 |
| 2021-03-18 | AD | Futures | 0.81668 | 0.81946 | 0.80888 | 0.81009 | 99344.0 |
| 2021-03-18 | ALI | Futures | 2590.3 | 2600.98 | 2583.08 | 2591.17 | 289.0 |
| 2021-03-18 | B | Futures | 43.38 | 43.62 | 39.33 | 40.51 | 516083.0 |
| 2021-03-18 | B6 | Futures | 1.4179 | 1.4222 | 1.4115 | 1.4148 | 101179.0 |
| 2021-03-18 | BFX | Futures | 3936.8 | 3949.9 | 3936.8 | 3949.9 | 37.0 |
| 2021-03-18 | BR | Futures | 0.14352 | 0.14368 | 0.14146 | 0.14186 | 38.0 |
| 2021-03-18 | BTC | Futures | 75969.9 | 78281.5 | 74138.8 | 74495.9 | 9656.0 |
| 2021-03-18 | BZ | Futures | 42.57 | 42.71 | 38.49 | 39.65 | 61688.0 |
| 2021-03-18 | C | Futures | 1589.0 | 1614.0 | 1588.0 | 1607.0 | 6198.0 |
| 2021-03-18 | CB | Futures | 145.732 | 145.732 | 144.081 | 144.514 | 35.0 |
| 2021-03-18 | CC | Futures | 1704.0 | 1725.0 | 1702.0 | 1713.0 | 13600.0 |
| 2021-03-18 | CNH | Futures | 6.3307 | 6.3544 | 6.3301 | 6.3516 | 251.0 |
| 2021-03-18 | CSC | Futures | 2.846 | 2.853 | 2.846 | 2.848 | 48.0 |
| 2021-03-18 | CT | Futures | 81.96 | 82.68 | 80.76 | 80.85 | 10122.0 |
| 2021-03-18 | DC | Futures | 25.4 | 25.4 | 25.26 | 25.4 | 63.0 |
| 2021-03-18 | DX | Futures | 88.306 | 88.838 | 88.219 | 88.78 | 37404.0 |
| 2021-03-18 | E1 | Futures | 1.22273 | 1.22363 | 1.21215 | 1.21496 | 27876.0 |
| 2021-03-18 | E6 | Futures | 1.27883 | 1.27985 | 1.271 | 1.27185 | 198520.0 |
| 2021-03-18 | E7 | Futures | 1.2724 | 1.2733 | 1.2646 | 1.2654 | 5176.0 |
| 2021-03-18 | EBM | Futures | 282.26 | 282.58 | 280.98 | 281.62 | 18100.0 |
| 2021-03-18 | ED | Futures | 96.5125 | 96.5173 | 96.5028 | 96.5125 | 207905.0 |
| 2021-03-18 | ER | Futures | 98.46 | 98.46 | 98.455 | 98.46 | 33298.0 |
| 2021-03-18 | ESG | Futures | 364.07 | 365.47 | 360.57 | 360.76 | 454.0 |
| 2021-03-18 | EW | Futures | 2847.7 | 2863.1 | 2783.9 | 2789.8 | 8267.0 |
| 2021-03-18 | FBON | Futures | 147.87 | 148.18 | 147.68 | 147.95 | 1014.0 |
| 2021-03-18 | FBTP | Futures | 138.66 | 138.75 | 138.16 | 138.6 | 175642.0 |
| 2021-03-18 | FBTS | Futures | 110.03 | 110.078 | 109.981 | 110.049 | 103218.0 |
| 2021-03-18 | FCE | Futures | 5930.7 | 5939.4 | 5848.2 | 5905.3 | 49550.0 |
| 2021-03-18 | FDAX | Futures | 15678.5 | 15794.7 | 15640.1 | 15779.7 | 46615.0 |
| 2021-03-18 | FDIV | Futures | 178.68 | 180.88 | 178.68 | 180.88 | 181.0 |
| 2021-03-18 | FDXM | Futures | 15647.7 | 15776.5 | 15620.0 | 15760.5 | 6135.0 |
| 2021-03-18 | FESX | Futures | 3604.2 | 3611.7 | 3564.5 | 3601.3 | 930630.0 |
| 2021-03-18 | FGBL | Futures | 167.62 | 167.65 | 166.72 | 166.92 | 967444.0 |
| 2021-03-18 | FGBM | Futures | 134.85 | 134.85 | 134.61 | 134.68 | 571265.0 |
| 2021-03-18 | FGBS | Futures | 112.649 | 112.649 | 112.614 | 112.629 | 353442.0 |
| 2021-03-18 | FGBX | Futures | 219.44 | 219.48 | 216.13 | 216.53 | 95584.0 |
| 2021-03-18 | FMWO | Futures | 9944.6 | 9944.6 | 9790.7 | 9923.4 | 15191.0 |
| 2021-03-18 | FOAT | Futures | 155.93 | 156.02 | 155.17 | 155.37 | 246337.0 |
| 2021-03-18 | FTDX | Futures | 3496.7 | 3519.8 | 3467.9 | 3495.1 | 577.0 |
| 2021-03-18 | FTI | Futures | 642.49 | 643.99 | 631.93 | 639.36 | 14112.0 |
| 2021-03-18 | FTUK | Futures | 6565.0 | 6577.2 | 6489.0 | 6553.3 | 93989.0 |
| 2021-03-18 | FVSA | Futures | 114.3 | 121.43 | 113.45 | 114.87 | 22685.0 |
| 2021-03-18 | FXXP | Futures | 399.3 | 399.8 | 395.4 | 399.5 | 86589.0 |
> showing 50 of 122 rows — these rows as CSV