PREVIEW / futures_daily / 2016-05-25
file: by_date/futures_daily/2016/2016-05-25.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-25 | ES | Futures | 2227.96 | 2246.75 | 2226.35 | 2241.12 | 1442270.0 |
| 2016-05-25 | NQ | Futures | 5223.49 | 5275.19 | 5220.56 | 5257.86 | 253726.0 |
| 2016-05-25 | YM | Futures | 18399.5 | 18579.3 | 18382.8 | 18525.3 | 124625.0 |
| 2016-05-25 | CL | Futures | 57.55 | 58.32 | 57.03 | 58.1 | 550501.0 |
| 2016-05-25 | GC | Futures | 1581.9 | 1585.6 | 1569.5 | 1577.4 | 246046.0 |
| 2016-05-25 | ZN | Futures | 125.072378 | 125.147814 | 124.876245 | 125.012029 | 1980645.0 |
| 2016-05-25 | A6 | Futures | 0.72668 | 0.73013 | 0.72547 | 0.7279 | 91448.0 |
| 2016-05-25 | AD | Futures | 0.7786 | 0.78556 | 0.7785 | 0.78453 | 80745.0 |
| 2016-05-25 | ALI | Futures | 2070.82 | 2070.82 | 2070.82 | 2070.82 | 0.0 |
| 2016-05-25 | B | Futures | 40.35 | 40.89 | 40.06 | 40.71 | 195051.0 |
| 2016-05-25 | B6 | Futures | 1.5402 | 1.5511 | 1.5376 | 1.5502 | 101773.0 |
| 2016-05-25 | BFX | Futures | 4093.6 | 4095.9 | 4093.6 | 4095.9 | 2.0 |
| 2016-05-25 | BR | Futures | 0.18103 | 0.18113 | 0.17907 | 0.1796 | 1482.0 |
| 2016-05-25 | BZ | Futures | 40.22 | 40.78 | 39.99 | 40.61 | 20403.0 |
| 2016-05-25 | C | Futures | 2296.0 | 2309.0 | 2262.0 | 2270.0 | 8985.0 |
| 2016-05-25 | CB | Futures | 254.955 | 254.984 | 254.369 | 254.369 | 7.0 |
| 2016-05-25 | CC | Futures | 2164.0 | 2171.0 | 2134.0 | 2139.0 | 13266.0 |
| 2016-05-25 | CNH | Futures | 7.1407 | 7.1418 | 7.1378 | 7.1384 | 83.0 |
| 2016-05-25 | CSC | Futures | 3.31 | 3.323 | 3.31 | 3.31 | 90.0 |
| 2016-05-25 | CT | Futures | 71.72 | 72.14 | 70.95 | 71.55 | 13343.0 |
| 2016-05-25 | DC | Futures | 26.03 | 26.06 | 25.97 | 26.03 | 57.0 |
| 2016-05-25 | DX | Futures | 89.176 | 89.19 | 88.868 | 88.887 | 11327.0 |
| 2016-05-25 | E1 | Futures | 1.26589 | 1.27054 | 1.26564 | 1.26903 | 15822.0 |
| 2016-05-25 | E6 | Futures | 1.29966 | 1.30304 | 1.29855 | 1.30246 | 123130.0 |
| 2016-05-25 | E7 | Futures | 1.2927 | 1.2959 | 1.2916 | 1.2954 | 1738.0 |
| 2016-05-25 | EBM | Futures | 196.97 | 197.87 | 196.67 | 197.57 | 5042.0 |
| 2016-05-25 | ED | Futures | 95.663 | 95.6846 | 95.6581 | 95.6798 | 275787.0 |
| 2016-05-25 | ER | Futures | 98.264 | 98.264 | 98.259 | 98.264 | 27509.0 |
| 2016-05-25 | EW | Futures | 1554.2 | 1566.1 | 1554.2 | 1563.7 | 20006.0 |
| 2016-05-25 | FBON | Futures | 118.84 | 119.42 | 118.76 | 119.38 | 241.0 |
| 2016-05-25 | FBTP | Futures | 106.84 | 107.32 | 106.73 | 107.27 | 116140.0 |
| 2016-05-25 | FBTS | Futures | 101.141 | 101.194 | 101.123 | 101.185 | 20636.0 |
| 2016-05-25 | FCE | Futures | 3802.6 | 3837.0 | 3797.9 | 3828.9 | 82459.0 |
| 2016-05-25 | FDAX | Futures | 10892.4 | 10993.4 | 10880.1 | 10964.4 | 91936.0 |
| 2016-05-25 | FDXM | Futures | 10486.5 | 10584.7 | 10476.1 | 10557.8 | 17063.0 |
| 2016-05-25 | FESX | Futures | 2352.5 | 2384.4 | 2349.3 | 2378.2 | 1494829.0 |
| 2016-05-25 | FEU3 | Futures | 98.917 | 98.917 | 98.917 | 98.917 | 47.0 |
| 2016-05-25 | FGBL | Futures | 146.26 | 146.64 | 145.91 | 146.59 | 730563.0 |
| 2016-05-25 | FGBM | Futures | 127.63 | 127.71 | 127.53 | 127.69 | 508450.0 |
| 2016-05-25 | FGBS | Futures | 111.658 | 111.668 | 111.648 | 111.663 | 164845.0 |
| 2016-05-25 | FGBX | Futures | 172.22 | 173.56 | 171.21 | 173.41 | 47708.0 |
| 2016-05-25 | FMWO | Futures | 5665.1 | 5696.2 | 5663.9 | 5691.2 | 360.0 |
| 2016-05-25 | FOAT | Futures | 133.99 | 134.35 | 133.67 | 134.31 | 84539.0 |
| 2016-05-25 | FTDX | Futures | 1606.1 | 1607.5 | 1597.6 | 1602.8 | 266.0 |
| 2016-05-25 | FTI | Futures | 398.59 | 402.55 | 398.5 | 401.29 | 30408.0 |
| 2016-05-25 | FTUK | Futures | 5141.8 | 5169.5 | 5141.4 | 5159.2 | 107291.0 |
| 2016-05-25 | FVSA | Futures | 2364.41 | 2369.06 | 2266.67 | 2285.28 | 16793.0 |
| 2016-05-25 | FXXP | Futures | 276.9 | 279.8 | 276.9 | 279.0 | 42297.0 |
| 2016-05-25 | G | Futures | 108.26 | 108.57 | 108.15 | 108.53 | 425554.0 |
| 2016-05-25 | GF | Futures | 283.85 | 285.796 | 283.251 | 284.898 | 2498.0 |
> showing 50 of 110 rows — these rows as CSV