PREVIEW / futures_daily / 2019-04-16
file: by_date/futures_daily/2019/2019-04-16.parquet size: 10 KB rows: 115
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 |
|---|---|---|---|---|---|---|---|
| 2019-04-16 | ES | Futures | 3143.58 | 3155.46 | 3137.37 | 3144.93 | 1124491.0 |
| 2019-04-16 | NQ | Futures | 8815.23 | 8866.22 | 8812.93 | 8848.36 | 373199.0 |
| 2019-04-16 | YM | Futures | 27856.1 | 28029.3 | 27842.4 | 27916.3 | 189117.0 |
| 2019-04-16 | CL | Futures | 65.42 | 66.22 | 64.83 | 65.9 | 255946.0 |
| 2019-04-16 | GC | Futures | 1606.6 | 1607.7 | 1587.5 | 1589.6 | 326514.0 |
| 2019-04-16 | ZN | Futures | 122.482183 | 122.528801 | 122.124775 | 122.155854 | 1356140.0 |
| 2019-04-16 | A6 | Futures | 0.74013 | 0.74106 | 0.73704 | 0.74044 | 96796.0 |
| 2019-04-16 | AD | Futures | 0.75701 | 0.75858 | 0.75534 | 0.75817 | 74025.0 |
| 2019-04-16 | B | Futures | 51.87 | 52.41 | 51.53 | 52.24 | 273904.0 |
| 2019-04-16 | B6 | Futures | 1.3459 | 1.3463 | 1.3401 | 1.3412 | 83123.0 |
| 2019-04-16 | BFX | Futures | 4451.9 | 4451.9 | 4450.7 | 4450.7 | 47.0 |
| 2019-04-16 | BR | Futures | 0.20565 | 0.20565 | 0.2048 | 0.2048 | 15.0 |
| 2019-04-16 | BTC | Futures | 7771.9 | 8088.6 | 7764.2 | 8034.5 | 6800.0 |
| 2019-04-16 | BZ | Futures | 51.77 | 52.26 | 51.39 | 52.1 | 43907.0 |
| 2019-04-16 | C | Futures | 1624.0 | 1624.0 | 1577.0 | 1610.0 | 7085.0 |
| 2019-04-16 | CB | Futures | 275.732 | 278.304 | 275.732 | 277.467 | 27.0 |
| 2019-04-16 | CC | Futures | 1620.0 | 1621.0 | 1558.0 | 1579.0 | 28732.0 |
| 2019-04-16 | CNH | Futures | 6.7169 | 6.7244 | 6.7161 | 6.7202 | 295.0 |
| 2019-04-16 | CSC | Futures | 2.849 | 2.866 | 2.843 | 2.863 | 145.0 |
| 2019-04-16 | CT | Futures | 81.21 | 83.04 | 81.21 | 82.75 | 8922.0 |
| 2019-04-16 | DC | Futures | 24.05 | 24.22 | 23.99 | 24.2 | 263.0 |
| 2019-04-16 | DX | Futures | 92.54 | 92.717 | 92.497 | 92.643 | 14628.0 |
| 2019-04-16 | E1 | Futures | 1.16913 | 1.16983 | 1.16411 | 1.16504 | 27635.0 |
| 2019-04-16 | E6 | Futures | 1.24672 | 1.24825 | 1.24408 | 1.24534 | 199751.0 |
| 2019-04-16 | E7 | Futures | 1.2408 | 1.2421 | 1.238 | 1.2392 | 4524.0 |
| 2019-04-16 | EBM | Futures | 200.04 | 200.31 | 196.87 | 197.13 | 33327.0 |
| 2019-04-16 | ED | Futures | 95.1306 | 95.1306 | 95.1209 | 95.1257 | 195283.0 |
| 2019-04-16 | ER | Futures | 98.416 | 98.421 | 98.411 | 98.416 | 55955.0 |
| 2019-04-16 | EW | Futures | 2086.2 | 2095.5 | 2082.4 | 2088.0 | 9331.0 |
| 2019-04-16 | FBON | Futures | 135.26 | 135.34 | 135.03 | 135.23 | 385.0 |
| 2019-04-16 | FBTP | Futures | 115.35 | 115.67 | 114.91 | 115.23 | 81143.0 |
| 2019-04-16 | FBTS | Futures | 105.836 | 105.931 | 105.703 | 105.836 | 39696.0 |
| 2019-04-16 | FCE | Futures | 4911.9 | 4928.1 | 4900.2 | 4923.1 | 148125.0 |
| 2019-04-16 | FDAX | Futures | 12684.3 | 12782.2 | 12679.6 | 12776.4 | 93389.0 |
| 2019-04-16 | FDXM | Futures | 12571.2 | 12671.4 | 12569.1 | 12665.7 | 33632.0 |
| 2019-04-16 | FESX | Futures | 2956.7 | 2967.1 | 2953.2 | 2966.3 | 787626.0 |
| 2019-04-16 | FGBL | Futures | 158.91 | 159.19 | 158.66 | 158.86 | 661544.0 |
| 2019-04-16 | FGBM | Futures | 132.72 | 132.84 | 132.67 | 132.72 | 415590.0 |
| 2019-04-16 | FGBS | Futures | 112.713 | 112.744 | 112.708 | 112.724 | 246016.0 |
| 2019-04-16 | FGBX | Futures | 190.3 | 191.2 | 189.5 | 190.24 | 40620.0 |
| 2019-04-16 | FMWO | Futures | 7265.9 | 7285.5 | 7256.6 | 7272.8 | 880.0 |
| 2019-04-16 | FOAT | Futures | 145.87 | 146.07 | 145.72 | 145.99 | 117880.0 |
| 2019-04-16 | FTDX | Futures | 2766.9 | 2779.7 | 2764.9 | 2773.3 | 106.0 |
| 2019-04-16 | FTI | Futures | 527.6 | 530.35 | 527.08 | 529.75 | 45991.0 |
| 2019-04-16 | FTUK | Futures | 6775.2 | 6813.7 | 6768.3 | 6799.9 | 93358.0 |
| 2019-04-16 | FVSA | Futures | 200.39 | 201.09 | 197.6 | 198.3 | 29346.0 |
| 2019-04-16 | FXXP | Futures | 342.9 | 344.0 | 342.5 | 343.8 | 58291.0 |
| 2019-04-16 | G | Futures | 117.07 | 117.17 | 116.84 | 117.01 | 233409.0 |
| 2019-04-16 | GF | Futures | 314.373 | 316.924 | 313.592 | 314.79 | 5513.0 |
| 2019-04-16 | GSCI | Futures | 507.95 | 509.02 | 507.21 | 509.02 | 13.0 |
> showing 50 of 115 rows — these rows as CSV