PREVIEW / futures_daily / 2017-03-24
file: by_date/futures_daily/2017/2017-03-24.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 |
|---|---|---|---|---|---|---|---|
| 2017-03-24 | ES | Futures | 2542.43 | 2555.19 | 2532.38 | 2546.5 | 1600274.0 |
| 2017-03-24 | NQ | Futures | 6309.42 | 6354.17 | 6298.23 | 6335.04 | 294980.0 |
| 2017-03-24 | YM | Futures | 21735.4 | 21814.5 | 21605.6 | 21710.1 | 180188.0 |
| 2017-03-24 | CL | Futures | 49.96 | 50.52 | 49.83 | 50.28 | 421027.0 |
| 2017-03-24 | GC | Futures | 1590.5 | 1599.3 | 1585.0 | 1594.9 | 207568.0 |
| 2017-03-24 | ZN | Futures | 122.245855 | 122.507031 | 122.138311 | 122.445578 | 1004433.0 |
| 2017-03-24 | A6 | Futures | 0.78184 | 0.78317 | 0.77948 | 0.78194 | 67511.0 |
| 2017-03-24 | AD | Futures | 0.76452 | 0.76503 | 0.76273 | 0.76314 | 44760.0 |
| 2017-03-24 | ALI | Futures | 2584.71 | 2584.71 | 2584.71 | 2584.71 | 0.0 |
| 2017-03-24 | B | Futures | 36.98 | 37.29 | 36.8 | 37.1 | 215340.0 |
| 2017-03-24 | B6 | Futures | 1.3154 | 1.3156 | 1.31 | 1.3132 | 68626.0 |
| 2017-03-24 | BFX | Futures | 4543.2 | 4543.2 | 4538.3 | 4538.3 | 5.0 |
| 2017-03-24 | BR | Futures | 0.22698 | 0.22951 | 0.22698 | 0.22951 | 17.0 |
| 2017-03-24 | BZ | Futures | 36.78 | 37.11 | 36.64 | 36.93 | 27105.0 |
| 2017-03-24 | C | Futures | 1816.0 | 1816.0 | 1773.0 | 1778.0 | 8166.0 |
| 2017-03-24 | CB | Futures | 263.645 | 263.645 | 262.424 | 262.729 | 37.0 |
| 2017-03-24 | CC | Futures | 1651.0 | 1659.0 | 1623.0 | 1627.0 | 13902.0 |
| 2017-03-24 | CNH | Futures | 7.2167 | 7.2226 | 7.2041 | 7.2041 | 6.0 |
| 2017-03-24 | CSC | Futures | 3.618 | 3.618 | 3.571 | 3.571 | 25.0 |
| 2017-03-24 | CT | Futures | 86.13 | 87.11 | 86.02 | 86.35 | 14787.0 |
| 2017-03-24 | DC | Futures | 29.4 | 29.44 | 29.23 | 29.31 | 47.0 |
| 2017-03-24 | DX | Futures | 92.766 | 92.994 | 92.565 | 92.647 | 22920.0 |
| 2017-03-24 | E1 | Futures | 1.25009 | 1.2559 | 1.24725 | 1.25392 | 14671.0 |
| 2017-03-24 | E6 | Futures | 1.2473 | 1.25122 | 1.24465 | 1.24983 | 151210.0 |
| 2017-03-24 | E7 | Futures | 1.2408 | 1.2449 | 1.2384 | 1.2435 | 2657.0 |
| 2017-03-24 | EBM | Futures | 187.34 | 187.9 | 186.5 | 187.06 | 21024.0 |
| 2017-03-24 | ED | Futures | 95.5494 | 95.5639 | 95.5446 | 95.5591 | 193127.0 |
| 2017-03-24 | ER | Futures | 98.313 | 98.323 | 98.313 | 98.318 | 90693.0 |
| 2017-03-24 | EW | Futures | 1801.0 | 1812.5 | 1793.1 | 1799.6 | 20151.0 |
| 2017-03-24 | FBON | Futures | 120.73 | 121.38 | 120.66 | 121.18 | 743.0 |
| 2017-03-24 | FBTP | Futures | 103.59 | 104.02 | 103.3 | 103.9 | 73626.0 |
| 2017-03-24 | FBTS | Futures | 101.664 | 101.773 | 101.61 | 101.737 | 37544.0 |
| 2017-03-24 | FCE | Futures | 4429.3 | 4432.8 | 4408.1 | 4422.7 | 72830.0 |
| 2017-03-24 | FDAX | Futures | 12737.6 | 12806.3 | 12707.0 | 12767.7 | 74358.0 |
| 2017-03-24 | FDXM | Futures | 12629.4 | 12690.1 | 12595.9 | 12655.6 | 20553.0 |
| 2017-03-24 | FESX | Futures | 2753.2 | 2756.5 | 2741.0 | 2750.8 | 763405.0 |
| 2017-03-24 | FEU3 | Futures | 98.986 | 98.991 | 98.986 | 98.991 | 23.0 |
| 2017-03-24 | FGBL | Futures | 146.99 | 147.37 | 146.8 | 147.25 | 534752.0 |
| 2017-03-24 | FGBM | Futures | 128.73 | 128.88 | 128.66 | 128.82 | 345294.0 |
| 2017-03-24 | FGBS | Futures | 112.222 | 112.247 | 112.202 | 112.222 | 195627.0 |
| 2017-03-24 | FGBX | Futures | 166.21 | 167.25 | 165.67 | 166.83 | 33819.0 |
| 2017-03-24 | FMWO | Futures | 6188.0 | 6200.1 | 6188.0 | 6200.1 | 17.0 |
| 2017-03-24 | FOAT | Futures | 130.82 | 131.45 | 130.61 | 131.34 | 97028.0 |
| 2017-03-24 | FTDX | Futures | 1939.1 | 1964.1 | 1938.1 | 1961.7 | 212.0 |
| 2017-03-24 | FTI | Futures | 464.11 | 464.61 | 461.61 | 463.52 | 21722.0 |
| 2017-03-24 | FTUK | Futures | 6230.0 | 6231.3 | 6192.3 | 6212.4 | 75563.0 |
| 2017-03-24 | FVSA | Futures | 654.42 | 664.12 | 640.55 | 651.65 | 17211.0 |
| 2017-03-24 | FXXP | Futures | 312.8 | 312.8 | 311.3 | 312.3 | 27819.0 |
| 2017-03-24 | G | Futures | 113.91 | 114.38 | 113.73 | 114.29 | 152942.0 |
| 2017-03-24 | GF | Futures | 313.188 | 315.552 | 311.343 | 312.669 | 4118.0 |
> showing 50 of 110 rows — these rows as CSV