PREVIEW / futures_daily / 2021-09-23
file: by_date/futures_daily/2021/2021-09-23.parquet size: 10 KB rows: 124
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-09-23 | ES | Futures | 4933.78 | 5011.39 | 4933.49 | 4992.27 | 1447395.0 |
| 2021-09-23 | NQ | Futures | 17502.73 | 17697.32 | 17499.27 | 17647.16 | 514535.0 |
| 2021-09-23 | YM | Futures | 37159.6 | 37808.0 | 37154.1 | 37693.8 | 189406.0 |
| 2021-09-23 | CL | Futures | 53.0 | 54.12 | 52.73 | 53.97 | 403405.0 |
| 2021-09-23 | GC | Futures | 2064.0 | 2073.3 | 2027.1 | 2041.4 | 225456.0 |
| 2021-09-23 | ZN | Futures | 135.449915 | 135.449915 | 134.401147 | 134.623613 | 2148141.0 |
| 2021-09-23 | A6 | Futures | 0.74239 | 0.75013 | 0.7407 | 0.74952 | 107779.0 |
| 2021-09-23 | AD | Futures | 0.7946 | 0.80349 | 0.79328 | 0.80247 | 89713.0 |
| 2021-09-23 | ALI | Futures | 3351.7 | 3390.01 | 3349.45 | 3359.31 | 772.0 |
| 2021-09-23 | B | Futures | 51.1 | 52.08 | 50.9 | 52.01 | 226594.0 |
| 2021-09-23 | B6 | Futures | 1.3823 | 1.396 | 1.3819 | 1.3941 | 129957.0 |
| 2021-09-23 | BR | Futures | 0.15251 | 0.15251 | 0.15149 | 0.15149 | 427.0 |
| 2021-09-23 | BTC | Futures | 57596.7 | 59880.3 | 57383.6 | 59634.0 | 5357.0 |
| 2021-09-23 | BZ | Futures | 49.77 | 50.74 | 49.6 | 50.68 | 26832.0 |
| 2021-09-23 | C | Futures | 1594.0 | 1595.0 | 1566.0 | 1569.0 | 6231.0 |
| 2021-09-23 | CB | Futures | 140.657 | 141.602 | 140.657 | 141.602 | 7.0 |
| 2021-09-23 | CC | Futures | 1703.0 | 1707.0 | 1673.0 | 1677.0 | 16000.0 |
| 2021-09-23 | CNH | Futures | 6.2411 | 6.243 | 6.2221 | 6.2263 | 319.0 |
| 2021-09-23 | CSC | Futures | 2.417 | 2.422 | 2.417 | 2.421 | 8.0 |
| 2021-09-23 | CT | Futures | 85.21 | 86.3 | 85.21 | 86.3 | 3.0 |
| 2021-09-23 | DC | Futures | 22.05 | 22.17 | 21.99 | 22.15 | 124.0 |
| 2021-09-23 | DX | Futures | 90.342 | 90.371 | 89.825 | 89.888 | 24798.0 |
| 2021-09-23 | E1 | Futures | 1.21104 | 1.21743 | 1.21004 | 1.21508 | 22102.0 |
| 2021-09-23 | E6 | Futures | 1.24426 | 1.25037 | 1.2432 | 1.25 | 155047.0 |
| 2021-09-23 | E7 | Futures | 1.2374 | 1.2435 | 1.2364 | 1.2432 | 3200.0 |
| 2021-09-23 | EBM | Futures | 368.87 | 371.07 | 367.03 | 370.34 | 36707.0 |
| 2021-09-23 | ED | Futures | 96.5489 | 96.5489 | 96.5392 | 96.5392 | 111875.0 |
| 2021-09-23 | ER | Futures | 98.475 | 98.475 | 98.47 | 98.47 | 27094.0 |
| 2021-09-23 | ESG | Futures | 410.15 | 413.49 | 408.42 | 412.17 | 348.0 |
| 2021-09-23 | EW | Futures | 2862.7 | 2917.3 | 2862.7 | 2901.5 | 11553.0 |
| 2021-09-23 | FBON | Futures | 150.65 | 150.67 | 149.8 | 149.93 | 949.0 |
| 2021-09-23 | FBTP | Futures | 140.62 | 140.86 | 139.95 | 140.04 | 150752.0 |
| 2021-09-23 | FBTS | Futures | 110.516 | 110.555 | 110.448 | 110.468 | 78847.0 |
| 2021-09-23 | FCE | Futures | 6683.3 | 6724.4 | 6670.3 | 6707.3 | 61263.0 |
| 2021-09-23 | FDAX | Futures | 16597.0 | 16756.3 | 16589.5 | 16701.8 | 70665.0 |
| 2021-09-23 | FDIV | Futures | 184.76 | 184.76 | 183.97 | 184.36 | 34.0 |
| 2021-09-23 | FDXM | Futures | 16635.7 | 16804.0 | 16635.7 | 16749.3 | 56990.0 |
| 2021-09-23 | FDXS | Futures | 16465.3 | 16647.9 | 16465.3 | 16593.8 | 21517.0 |
| 2021-09-23 | FESX | Futures | 3965.1 | 4008.2 | 3962.2 | 3997.2 | 658815.0 |
| 2021-09-23 | FGBL | Futures | 169.13 | 169.18 | 168.08 | 168.18 | 905531.0 |
| 2021-09-23 | FGBM | Futures | 135.07 | 135.09 | 134.79 | 134.81 | 542325.0 |
| 2021-09-23 | FGBS | Futures | 112.679 | 112.679 | 112.624 | 112.639 | 380829.0 |
| 2021-09-23 | FGBX | Futures | 224.81 | 225.29 | 221.51 | 222.01 | 93093.0 |
| 2021-09-23 | FMWO | Futures | 10957.2 | 11062.1 | 10957.2 | 11036.2 | 5259.0 |
| 2021-09-23 | FOAT | Futures | 156.89 | 156.89 | 155.73 | 155.92 | 167363.0 |
| 2021-09-23 | FTDX | Futures | 4020.6 | 4059.6 | 4020.6 | 4048.8 | 94.0 |
| 2021-09-23 | FTI | Futures | 757.35 | 764.98 | 757.35 | 762.58 | 19824.0 |
| 2021-09-23 | FTUK | Futures | 6958.8 | 7014.2 | 6950.4 | 6961.3 | 100951.0 |
| 2021-09-23 | FVSA | Futures | 83.78 | 83.78 | 79.27 | 80.4 | 30408.0 |
| 2021-09-23 | FXXP | Futures | 442.8 | 445.2 | 442.5 | 443.9 | 40606.0 |
> showing 50 of 124 rows — these rows as CSV