PREVIEW / futures_daily / 2015-07-24
file: by_date/futures_daily/2015/2015-07-24.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-24 | ES | Futures | 2226.68 | 2229.86 | 2193.56 | 2201.77 | 1669725.0 |
| 2015-07-24 | NQ | Futures | 5409.7 | 5415.83 | 5305.79 | 5325.93 | 236180.0 |
| 2015-07-24 | YM | Futures | 18169.0 | 18189.6 | 17945.1 | 17996.5 | 123764.0 |
| 2015-07-24 | CL | Futures | 81.01 | 81.41 | 79.23 | 79.93 | 278233.0 |
| 2015-07-24 | GC | Futures | 1422.9 | 1437.8 | 1400.4 | 1417.7 | 249020.0 |
| 2015-07-24 | ZN | Futures | 120.749894 | 121.018161 | 120.705183 | 120.869124 | 873572.0 |
| 2015-07-24 | A6 | Futures | 0.72623 | 0.72712 | 0.71712 | 0.7194 | 93702.0 |
| 2015-07-24 | AD | Futures | 0.78375 | 0.78508 | 0.78007 | 0.78222 | 55689.0 |
| 2015-07-24 | ALI | Futures | 2199.49 | 2199.49 | 2199.49 | 2199.49 | 0.0 |
| 2015-07-24 | B | Futures | 51.54 | 51.74 | 50.53 | 50.83 | 195038.0 |
| 2015-07-24 | B6 | Futures | 1.6321 | 1.6336 | 1.6273 | 1.6319 | 49445.0 |
| 2015-07-24 | BFX | Futures | 4572.1 | 4572.1 | 4560.6 | 4560.6 | 1.0 |
| 2015-07-24 | BR | Futures | 0.17826 | 0.17826 | 0.17623 | 0.1765 | 726.0 |
| 2015-07-24 | BZ | Futures | 51.59 | 51.7 | 50.5 | 50.79 | 23004.0 |
| 2015-07-24 | C | Futures | 2323.0 | 2338.0 | 2283.0 | 2284.0 | 15838.0 |
| 2015-07-24 | CB | Futures | 160.514 | 162.905 | 158.852 | 159.237 | 34.0 |
| 2015-07-24 | CC | Futures | 2388.0 | 2398.0 | 2335.0 | 2339.0 | 22624.0 |
| 2015-07-24 | CNH | Futures | 7.0154 | 7.0197 | 7.0154 | 7.0194 | 10.0 |
| 2015-07-24 | CSC | Futures | 4.409 | 4.465 | 4.346 | 4.358 | 30.0 |
| 2015-07-24 | CT | Futures | 80.86 | 80.86 | 80.31 | 80.57 | 6.0 |
| 2015-07-24 | DC | Futures | 35.67 | 36.03 | 34.87 | 35.08 | 418.0 |
| 2015-07-24 | DX | Futures | 91.081 | 91.498 | 91.002 | 91.124 | 27597.0 |
| 2015-07-24 | E1 | Futures | 1.32529 | 1.32846 | 1.3197 | 1.32135 | 15980.0 |
| 2015-07-24 | E6 | Futures | 1.2912 | 1.29261 | 1.28427 | 1.29097 | 164283.0 |
| 2015-07-24 | E7 | Futures | 1.2841 | 1.2856 | 1.2773 | 1.2838 | 3329.0 |
| 2015-07-24 | EBM | Futures | 306.6 | 306.6 | 304.14 | 304.55 | 11613.0 |
| 2015-07-24 | ED | Futures | 95.6318 | 95.6414 | 95.627 | 95.6318 | 141308.0 |
| 2015-07-24 | ER | Futures | 98.107 | 98.112 | 98.107 | 98.107 | 15052.0 |
| 2015-07-24 | EW | Futures | 1559.9 | 1562.6 | 1540.6 | 1545.3 | 16725.0 |
| 2015-07-24 | FBTP | Futures | 100.56 | 100.69 | 100.39 | 100.61 | 38741.0 |
| 2015-07-24 | FBTS | Futures | 99.99 | 100.017 | 99.981 | 99.999 | 11668.0 |
| 2015-07-24 | FCE | Futures | 4231.2 | 4271.7 | 4192.1 | 4220.0 | 77561.0 |
| 2015-07-24 | FDAX | Futures | 12693.5 | 12768.1 | 12472.4 | 12546.4 | 94992.0 |
| 2015-07-24 | FDIV | Futures | 153.76 | 153.9 | 153.76 | 153.9 | 1.0 |
| 2015-07-24 | FESX | Futures | 2679.1 | 2702.7 | 2645.8 | 2663.5 | 902555.0 |
| 2015-07-24 | FGBL | Futures | 136.91 | 137.34 | 136.82 | 137.26 | 431994.0 |
| 2015-07-24 | FGBM | Futures | 124.45 | 124.57 | 124.42 | 124.57 | 278978.0 |
| 2015-07-24 | FGBS | Futures | 111.203 | 111.218 | 111.188 | 111.218 | 137049.0 |
| 2015-07-24 | FGBX | Futures | 155.26 | 156.8 | 154.95 | 156.33 | 21053.0 |
| 2015-07-24 | FMWO | Futures | 5836.0 | 5838.4 | 5796.6 | 5796.6 | 279.0 |
| 2015-07-24 | FOAT | Futures | 125.41 | 125.86 | 125.31 | 125.8 | 48828.0 |
| 2015-07-24 | FTDX | Futures | 1713.0 | 1715.3 | 1696.0 | 1699.8 | 236.0 |
| 2015-07-24 | FTI | Futures | 424.44 | 428.15 | 417.87 | 420.68 | 27781.0 |
| 2015-07-24 | FTUK | Futures | 5236.0 | 5273.0 | 5156.5 | 5184.4 | 77998.0 |
| 2015-07-24 | FVSA | Futures | 1706.29 | 1780.86 | 1671.2 | 1750.15 | 10932.0 |
| 2015-07-24 | FXXP | Futures | 304.3 | 306.9 | 300.9 | 302.4 | 18608.0 |
| 2015-07-24 | G | Futures | 101.88 | 102.31 | 101.86 | 102.22 | 190077.0 |
| 2015-07-24 | GF | Futures | 356.02 | 357.891 | 353.768 | 356.488 | 3670.0 |
| 2015-07-24 | GSCI | Futures | 650.41 | 650.41 | 642.17 | 644.75 | 398.0 |
| 2015-07-24 | HE | Futures | 87.492 | 87.994 | 86.598 | 86.765 | 7896.0 |
> showing 50 of 107 rows — these rows as CSV