PREVIEW / futures_daily / 2019-03-29
file: by_date/futures_daily/2019/2019-03-29.parquet size: 10 KB rows: 116
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-03-29 | ES | Futures | 3046.63 | 3068.51 | 3046.36 | 3065.27 | 1491974.0 |
| 2019-03-29 | NQ | Futures | 8468.99 | 8543.02 | 8468.99 | 8526.89 | 395579.0 |
| 2019-03-29 | YM | Futures | 27159.5 | 27406.5 | 27152.1 | 27373.8 | 191218.0 |
| 2019-03-29 | CL | Futures | 61.13 | 62.36 | 61.0 | 61.75 | 705559.0 |
| 2019-03-29 | GC | Futures | 1611.8 | 1623.7 | 1607.2 | 1616.1 | 270179.0 |
| 2019-03-29 | ZN | Futures | 123.725341 | 123.77196 | 123.399012 | 123.538867 | 1962022.0 |
| 2019-03-29 | A6 | Futures | 0.73054 | 0.73343 | 0.73034 | 0.73281 | 85978.0 |
| 2019-03-29 | AD | Futures | 0.75418 | 0.75923 | 0.75347 | 0.75853 | 88893.0 |
| 2019-03-29 | B | Futures | 49.01 | 49.75 | 48.91 | 49.22 | 333687.0 |
| 2019-03-29 | B6 | Futures | 1.342 | 1.3508 | 1.3344 | 1.3374 | 187612.0 |
| 2019-03-29 | BFX | Futures | 4295.9 | 4295.9 | 4272.5 | 4290.0 | 38.0 |
| 2019-03-29 | BR | Futures | 0.20529 | 0.20605 | 0.20384 | 0.20384 | 83.0 |
| 2019-03-29 | BTC | Futures | 6188.1 | 6342.7 | 6180.4 | 6296.3 | 4797.0 |
| 2019-03-29 | BZ | Futures | 48.91 | 49.61 | 48.78 | 49.09 | 43566.0 |
| 2019-03-29 | C | Futures | 1520.0 | 1540.0 | 1515.0 | 1537.0 | 13918.0 |
| 2019-03-29 | CB | Futures | 279.56 | 279.62 | 279.53 | 279.62 | 48.0 |
| 2019-03-29 | CC | Futures | 1521.0 | 1543.0 | 1516.0 | 1539.0 | 18662.0 |
| 2019-03-29 | CNH | Futures | 6.7481 | 6.7508 | 6.7214 | 6.7326 | 422.0 |
| 2019-03-29 | CSC | Futures | 2.84 | 2.849 | 2.84 | 2.849 | 62.0 |
| 2019-03-29 | CT | Futures | 80.58 | 82.6 | 80.39 | 82.4 | 20337.0 |
| 2019-03-29 | DC | Futures | 24.05 | 24.05 | 23.94 | 24.0 | 103.0 |
| 2019-03-29 | DX | Futures | 92.751 | 92.89 | 92.559 | 92.828 | 15901.0 |
| 2019-03-29 | E1 | Futures | 1.18173 | 1.18208 | 1.17834 | 1.18021 | 25660.0 |
| 2019-03-29 | E6 | Futures | 1.24019 | 1.24244 | 1.23832 | 1.23892 | 189647.0 |
| 2019-03-29 | E7 | Futures | 1.234 | 1.2363 | 1.2321 | 1.2328 | 4839.0 |
| 2019-03-29 | EBM | Futures | 196.6 | 197.13 | 196.07 | 196.6 | 14471.0 |
| 2019-03-29 | ED | Futures | 95.1795 | 95.1795 | 95.1404 | 95.1648 | 470370.0 |
| 2019-03-29 | ER | Futures | 98.411 | 98.416 | 98.411 | 98.411 | 43428.0 |
| 2019-03-29 | EW | Futures | 2013.2 | 2027.4 | 2011.2 | 2017.3 | 17591.0 |
| 2019-03-29 | FBON | Futures | 135.07 | 135.2 | 134.94 | 135.01 | 245.0 |
| 2019-03-29 | FBTP | Futures | 114.81 | 115.08 | 114.54 | 114.8 | 64754.0 |
| 2019-03-29 | FBTS | Futures | 105.712 | 105.789 | 105.608 | 105.684 | 38176.0 |
| 2019-03-29 | FCE | Futures | 4739.6 | 4773.5 | 4731.1 | 4762.3 | 78223.0 |
| 2019-03-29 | FDAX | Futures | 12102.2 | 12179.0 | 12059.5 | 12141.7 | 109949.0 |
| 2019-03-29 | FDIV | Futures | 140.52 | 140.85 | 140.52 | 140.85 | 242.0 |
| 2019-03-29 | FDXM | Futures | 11992.1 | 12082.9 | 11954.5 | 12036.4 | 47142.0 |
| 2019-03-29 | FESX | Futures | 2847.4 | 2869.3 | 2840.4 | 2859.6 | 935456.0 |
| 2019-03-29 | FGBL | Futures | 160.46 | 160.62 | 160.23 | 160.54 | 695143.0 |
| 2019-03-29 | FGBM | Futures | 133.09 | 133.2 | 133.03 | 133.17 | 504140.0 |
| 2019-03-29 | FGBS | Futures | 112.794 | 112.819 | 112.779 | 112.809 | 468460.0 |
| 2019-03-29 | FGBX | Futures | 196.29 | 196.82 | 195.37 | 195.94 | 66673.0 |
| 2019-03-29 | FMWO | Futures | 7058.8 | 7143.2 | 7047.2 | 7068.0 | 4770.0 |
| 2019-03-29 | FOAT | Futures | 147.21 | 147.39 | 147.02 | 147.27 | 125177.0 |
| 2019-03-29 | FTDX | Futures | 2644.0 | 2644.0 | 2616.3 | 2633.1 | 146.0 |
| 2019-03-29 | FTI | Futures | 511.5 | 515.02 | 511.03 | 513.84 | 24450.0 |
| 2019-03-29 | FTUK | Futures | 6595.4 | 6621.5 | 6567.0 | 6613.7 | 103831.0 |
| 2019-03-29 | FVSA | Futures | 256.6 | 259.86 | 246.83 | 249.27 | 34715.0 |
| 2019-03-29 | FXXP | Futures | 332.7 | 333.9 | 331.7 | 333.3 | 36163.0 |
| 2019-03-29 | G | Futures | 119.41 | 119.53 | 118.91 | 119.31 | 232907.0 |
| 2019-03-29 | GF | Futures | 312.391 | 312.391 | 310.253 | 310.627 | 1522.0 |
> showing 50 of 116 rows — these rows as CSV