PREVIEW / futures_daily / 2020-05-12
file: by_date/futures_daily/2020/2020-05-12.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-12 | ES | Futures | 3230.11 | 3252.24 | 3140.21 | 3156.25 | 1824303.0 |
| 2020-05-12 | NQ | Futures | 10641.25 | 10714.05 | 10364.39 | 10407.67 | 500539.0 |
| 2020-05-12 | YM | Futures | 25721.3 | 25921.9 | 25041.6 | 25154.7 | 209788.0 |
| 2020-05-12 | CL | Futures | 18.23 | 19.53 | 18.03 | 19.19 | 212335.0 |
| 2020-05-12 | GC | Futures | 2061.6 | 2081.9 | 2053.7 | 2069.9 | 198067.0 |
| 2020-05-12 | ZN | Futures | 137.037463 | 137.407918 | 136.898543 | 137.268998 | 1228975.0 |
| 2020-05-12 | A6 | Futures | 0.66696 | 0.67158 | 0.66079 | 0.66696 | 82675.0 |
| 2020-05-12 | AD | Futures | 0.72283 | 0.72526 | 0.71979 | 0.72181 | 41522.0 |
| 2020-05-12 | ALI | Futures | 1789.26 | 1789.26 | 1784.78 | 1785.07 | 19.0 |
| 2020-05-12 | B | Futures | 19.86 | 20.27 | 19.38 | 19.8 | 202469.0 |
| 2020-05-12 | B6 | Futures | 1.2523 | 1.2566 | 1.2441 | 1.2467 | 76059.0 |
| 2020-05-12 | BR | Futures | 0.13972 | 0.14247 | 0.13886 | 0.13907 | 5405.0 |
| 2020-05-12 | BTC | Futures | 12072.4 | 12587.0 | 11905.5 | 12336.7 | 6912.0 |
| 2020-05-12 | BZ | Futures | 19.22 | 19.61 | 18.83 | 19.17 | 25820.0 |
| 2020-05-12 | C | Futures | 1897.0 | 1905.0 | 1810.0 | 1839.0 | 13973.0 |
| 2020-05-12 | CB | Futures | 165.096 | 165.096 | 162.726 | 164.232 | 37.0 |
| 2020-05-12 | CC | Futures | 1621.0 | 1625.0 | 1530.0 | 1570.0 | 21567.0 |
| 2020-05-12 | CNH | Futures | 7.0501 | 7.0548 | 7.0316 | 7.0439 | 259.0 |
| 2020-05-12 | CSC | Futures | 2.842 | 2.89 | 2.783 | 2.844 | 103.0 |
| 2020-05-12 | CT | Futures | 55.13 | 57.11 | 54.59 | 56.87 | 19223.0 |
| 2020-05-12 | DC | Futures | 23.24 | 23.7 | 22.76 | 23.22 | 787.0 |
| 2020-05-12 | DX | Futures | 96.959 | 97.191 | 96.393 | 96.655 | 12075.0 |
| 2020-05-12 | E1 | Futures | 1.17132 | 1.17952 | 1.16905 | 1.17645 | 16486.0 |
| 2020-05-12 | E6 | Futures | 1.16231 | 1.17074 | 1.15978 | 1.16725 | 149471.0 |
| 2020-05-12 | E7 | Futures | 1.1564 | 1.1646 | 1.1537 | 1.1612 | 6480.0 |
| 2020-05-12 | EBM | Futures | 224.24 | 224.54 | 222.45 | 223.35 | 12220.0 |
| 2020-05-12 | ED | Futures | 96.3484 | 96.3581 | 96.3291 | 96.3339 | 244026.0 |
| 2020-05-12 | ER | Futures | 98.264 | 98.269 | 98.24 | 98.249 | 58831.0 |
| 2020-05-12 | ESG | Futures | 264.97 | 265.17 | 259.69 | 259.69 | 129.0 |
| 2020-05-12 | EW | Futures | 1759.7 | 1773.1 | 1674.7 | 1698.0 | 12237.0 |
| 2020-05-12 | FBON | Futures | 139.67 | 139.96 | 139.5 | 139.82 | 100.0 |
| 2020-05-12 | FBTP | Futures | 122.73 | 123.0 | 122.48 | 122.72 | 54905.0 |
| 2020-05-12 | FBTS | Futures | 106.96 | 107.018 | 106.912 | 106.97 | 48951.0 |
| 2020-05-12 | FCE | Futures | 4345.6 | 4369.9 | 4277.6 | 4334.9 | 69182.0 |
| 2020-05-12 | FDAX | Futures | 11474.4 | 11511.9 | 11272.9 | 11458.0 | 64740.0 |
| 2020-05-12 | FDIV | Futures | 121.41 | 121.87 | 121.18 | 121.87 | 142.0 |
| 2020-05-12 | FDXM | Futures | 11531.3 | 11566.4 | 11333.7 | 11512.7 | 57578.0 |
| 2020-05-12 | FESX | Futures | 2634.2 | 2644.3 | 2592.9 | 2636.0 | 856064.0 |
| 2020-05-12 | FGBL | Futures | 168.34 | 168.64 | 167.97 | 168.52 | 619804.0 |
| 2020-05-12 | FGBM | Futures | 135.01 | 135.06 | 134.8 | 134.99 | 349826.0 |
| 2020-05-12 | FGBS | Futures | 112.941 | 112.956 | 112.875 | 112.91 | 284116.0 |
| 2020-05-12 | FGBX | Futures | 226.33 | 227.65 | 225.51 | 227.2 | 45040.0 |
| 2020-05-12 | FMWO | Futures | 7124.5 | 7192.7 | 7036.2 | 7165.6 | 2177.0 |
| 2020-05-12 | FOAT | Futures | 152.58 | 152.99 | 152.27 | 152.9 | 87832.0 |
| 2020-05-12 | FTDX | Futures | 3010.3 | 3060.9 | 3000.7 | 3036.6 | 75.0 |
| 2020-05-12 | FTI | Futures | 482.51 | 486.56 | 477.53 | 483.48 | 12100.0 |
| 2020-05-12 | FTUK | Futures | 5592.3 | 5658.8 | 5557.4 | 5647.4 | 106239.0 |
| 2020-05-12 | FVSA | Futures | 265.11 | 275.06 | 250.18 | 251.08 | 9048.0 |
| 2020-05-12 | FXXP | Futures | 312.3 | 315.1 | 309.4 | 314.0 | 52872.0 |
| 2020-05-12 | G | Futures | 125.54 | 126.12 | 125.53 | 126.01 | 307307.0 |
> showing 50 of 119 rows — these rows as CSV