PREVIEW / futures_daily / 2019-01-10
file: by_date/futures_daily/2019/2019-01-10.parquet size: 10 KB rows: 112
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-01-10 | ES | Futures | 2793.29 | 2814.4 | 2772.18 | 2808.45 | 1534119.0 |
| 2019-01-10 | NQ | Futures | 7637.99 | 7689.51 | 7557.24 | 7670.41 | 496364.0 |
| 2019-01-10 | YM | Futures | 25131.0 | 25313.4 | 24934.8 | 25264.9 | 228649.0 |
| 2019-01-10 | CL | Futures | 54.73 | 55.36 | 53.88 | 55.16 | 821782.0 |
| 2019-01-10 | GC | Futures | 1631.3 | 1635.5 | 1621.2 | 1622.1 | 239920.0 |
| 2019-01-10 | ZN | Futures | 121.30031 | 121.611536 | 121.082451 | 121.222503 | 1426743.0 |
| 2019-01-10 | A6 | Futures | 0.74002 | 0.74218 | 0.73703 | 0.74074 | 96681.0 |
| 2019-01-10 | AD | Futures | 0.7679 | 0.7679 | 0.76471 | 0.76653 | 67657.0 |
| 2019-01-10 | B | Futures | 44.15 | 44.7 | 43.63 | 44.53 | 300922.0 |
| 2019-01-10 | B6 | Futures | 1.3186 | 1.3187 | 1.3111 | 1.3128 | 84791.0 |
| 2019-01-10 | BR | Futures | 0.2154 | 0.21544 | 0.21377 | 0.21409 | 556.0 |
| 2019-01-10 | BTC | Futures | 5840.5 | 5877.0 | 5153.4 | 5270.3 | 5744.0 |
| 2019-01-10 | BZ | Futures | 43.91 | 44.31 | 43.28 | 44.16 | 31333.0 |
| 2019-01-10 | C | Futures | 1495.0 | 1519.0 | 1480.0 | 1497.0 | 10819.0 |
| 2019-01-10 | CB | Futures | 271.833 | 271.833 | 271.833 | 271.833 | 4.0 |
| 2019-01-10 | CC | Futures | 1606.0 | 1647.0 | 1603.0 | 1632.0 | 22114.0 |
| 2019-01-10 | CNH | Futures | 6.8243 | 6.8424 | 6.7963 | 6.8077 | 1706.0 |
| 2019-01-10 | CSC | Futures | 2.786 | 2.799 | 2.777 | 2.793 | 46.0 |
| 2019-01-10 | CT | Futures | 79.74 | 80.41 | 78.91 | 79.36 | 14447.0 |
| 2019-01-10 | DC | Futures | 23.94 | 24.04 | 23.8 | 23.99 | 186.0 |
| 2019-01-10 | DX | Futures | 90.344 | 90.806 | 90.253 | 90.716 | 22317.0 |
| 2019-01-10 | E1 | Futures | 1.21463 | 1.21734 | 1.201 | 1.20194 | 32397.0 |
| 2019-01-10 | E6 | Futures | 1.28309 | 1.2853 | 1.27586 | 1.27751 | 207876.0 |
| 2019-01-10 | E7 | Futures | 1.2771 | 1.279 | 1.2697 | 1.2713 | 4020.0 |
| 2019-01-10 | EBM | Futures | 210.51 | 210.77 | 209.23 | 209.23 | 15374.0 |
| 2019-01-10 | ED | Futures | 95.0086 | 95.0135 | 94.9988 | 94.9988 | 264867.0 |
| 2019-01-10 | ER | Futures | 98.401 | 98.401 | 98.391 | 98.396 | 37683.0 |
| 2019-01-10 | EW | Futures | 1858.2 | 1879.8 | 1846.1 | 1877.9 | 14823.0 |
| 2019-01-10 | FBON | Futures | 129.07 | 129.47 | 129.05 | 129.38 | 423.0 |
| 2019-01-10 | FBTP | Futures | 110.75 | 110.75 | 110.23 | 110.49 | 57026.0 |
| 2019-01-10 | FBTS | Futures | 104.783 | 104.802 | 104.641 | 104.717 | 45765.0 |
| 2019-01-10 | FCE | Futures | 4249.3 | 4280.4 | 4223.5 | 4265.3 | 69582.0 |
| 2019-01-10 | FDAX | Futures | 11432.8 | 11524.7 | 11326.6 | 11449.1 | 90646.0 |
| 2019-01-10 | FDXM | Futures | 11393.9 | 11496.6 | 11299.6 | 11421.2 | 40681.0 |
| 2019-01-10 | FESX | Futures | 2614.1 | 2627.8 | 2590.2 | 2613.3 | 804247.0 |
| 2019-01-10 | FGBL | Futures | 155.87 | 156.29 | 155.87 | 156.13 | 647210.0 |
| 2019-01-10 | FGBM | Futures | 132.03 | 132.19 | 132.03 | 132.13 | 316987.0 |
| 2019-01-10 | FGBS | Futures | 112.703 | 112.734 | 112.703 | 112.723 | 233907.0 |
| 2019-01-10 | FGBX | Futures | 184.24 | 185.06 | 184.18 | 184.55 | 36898.0 |
| 2019-01-10 | FMWO | Futures | 6536.6 | 6575.0 | 6508.6 | 6556.4 | 7579.0 |
| 2019-01-10 | FOAT | Futures | 141.54 | 141.88 | 141.46 | 141.79 | 213507.0 |
| 2019-01-10 | FTDX | Futures | 2523.4 | 2526.4 | 2498.6 | 2508.0 | 162.0 |
| 2019-01-10 | FTI | Futures | 464.22 | 469.85 | 463.94 | 468.86 | 21.0 |
| 2019-01-10 | FTUK | Futures | 6221.2 | 6293.1 | 6192.5 | 6253.9 | 93813.0 |
| 2019-01-10 | FVSA | Futures | 396.09 | 406.24 | 378.82 | 387.96 | 20569.0 |
| 2019-01-10 | FXXP | Futures | 302.2 | 305.9 | 301.1 | 304.3 | 44153.0 |
| 2019-01-10 | G | Futures | 117.23 | 117.28 | 116.66 | 116.75 | 217764.0 |
| 2019-01-10 | GF | Futures | 316.056 | 317.914 | 315.892 | 317.258 | 3525.0 |
| 2019-01-10 | GSCI | Futures | 460.68 | 464.85 | 460.68 | 464.85 | 2983.0 |
| 2019-01-10 | HE | Futures | 76.453 | 77.235 | 75.882 | 77.054 | 36157.0 |
> showing 50 of 112 rows — these rows as CSV