PREVIEW / futures_daily / 2014-08-25
file: by_date/futures_daily/2014/2014-08-25.parquet size: 9 KB rows: 99
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-25 | ES | Futures | 2067.21 | 2077.33 | 2065.91 | 2072.4 | 853066.0 |
| 2014-08-25 | NQ | Futures | 4681.46 | 4705.69 | 4680.59 | 4688.38 | 168702.0 |
| 2014-08-25 | YM | Futures | 17156.8 | 17256.7 | 17152.7 | 17209.2 | 76350.0 |
| 2014-08-25 | CL | Futures | 174.22 | 175.0 | 173.32 | 173.88 | 137420.0 |
| 2014-08-25 | GC | Futures | 1680.0 | 1681.0 | 1672.4 | 1677.5 | 53712.0 |
| 2014-08-25 | ZN | Futures | 117.498601 | 117.717434 | 117.469423 | 117.600723 | 1310860.0 |
| 2014-08-25 | A6 | Futures | 0.89818 | 0.89982 | 0.89653 | 0.8974 | 43826.0 |
| 2014-08-25 | AD | Futures | 0.92616 | 0.92769 | 0.92393 | 0.92434 | 30551.0 |
| 2014-08-25 | ALI | Futures | 2991.53 | 2991.53 | 2991.53 | 2991.53 | 0.0 |
| 2014-08-25 | B | Futures | 107.43 | 108.13 | 107.05 | 107.97 | 31552.0 |
| 2014-08-25 | B6 | Futures | 1.7397 | 1.7446 | 1.7397 | 1.7426 | 42355.0 |
| 2014-08-25 | BFX | Futures | 3861.6 | 3865.0 | 3859.5 | 3859.5 | 8.0 |
| 2014-08-25 | BR | Futures | 0.23086 | 0.23086 | 0.23005 | 0.23019 | 461.0 |
| 2014-08-25 | BZ | Futures | 108.27 | 108.88 | 108.04 | 108.74 | 5078.0 |
| 2014-08-25 | CB | Futures | 149.915 | 150.127 | 146.061 | 146.061 | 41.0 |
| 2014-08-25 | CC | Futures | 2358.0 | 2382.0 | 2356.0 | 2376.0 | 4982.0 |
| 2014-08-25 | CSC | Futures | 5.024 | 5.079 | 5.024 | 5.064 | 12.0 |
| 2014-08-25 | CT | Futures | 85.1 | 85.69 | 84.43 | 85.35 | 28.0 |
| 2014-08-25 | DC | Futures | 40.76 | 41.11 | 40.72 | 40.95 | 66.0 |
| 2014-08-25 | DX | Futures | 78.425 | 78.492 | 78.302 | 78.4 | 11956.0 |
| 2014-08-25 | E1 | Futures | 1.39943 | 1.40238 | 1.39776 | 1.40071 | 25742.0 |
| 2014-08-25 | E6 | Futures | 1.55846 | 1.55893 | 1.55574 | 1.5568 | 115049.0 |
| 2014-08-25 | E7 | Futures | 1.5481 | 1.5486 | 1.5456 | 1.5467 | 1470.0 |
| 2014-08-25 | ED | Futures | 95.4115 | 95.4139 | 95.4115 | 95.4139 | 34965.0 |
| 2014-08-25 | ER | Futures | 97.916 | 97.955 | 97.916 | 97.95 | 134446.0 |
| 2014-08-25 | EW | Futures | 1479.4 | 1489.6 | 1479.4 | 1484.4 | 8037.0 |
| 2014-08-25 | FBTP | Futures | 93.73 | 94.65 | 93.7 | 94.44 | 45902.0 |
| 2014-08-25 | FBTS | Futures | 98.836 | 98.961 | 98.836 | 98.917 | 8588.0 |
| 2014-08-25 | FCE | Futures | 3424.5 | 3459.2 | 3413.0 | 3457.2 | 64521.0 |
| 2014-08-25 | FDAX | Futures | 10355.6 | 10479.5 | 10355.1 | 10460.8 | 68793.0 |
| 2014-08-25 | FESX | Futures | 2240.4 | 2277.8 | 2240.4 | 2274.2 | 659397.0 |
| 2014-08-25 | FEU3 | Futures | 98.562 | 98.567 | 98.562 | 98.567 | 2134.0 |
| 2014-08-25 | FGBL | Futures | 130.79 | 131.38 | 130.78 | 131.07 | 381717.0 |
| 2014-08-25 | FGBM | Futures | 122.27 | 122.57 | 122.27 | 122.44 | 305094.0 |
| 2014-08-25 | FGBS | Futures | 110.843 | 110.948 | 110.843 | 110.908 | 279188.0 |
| 2014-08-25 | FGBX | Futures | 142.08 | 143.15 | 141.87 | 142.05 | 14541.0 |
| 2014-08-25 | FMWO | Futures | 5797.8 | 5819.2 | 5796.5 | 5819.2 | 121.0 |
| 2014-08-25 | FOAT | Futures | 120.71 | 121.49 | 120.71 | 121.19 | 36910.0 |
| 2014-08-25 | FTDX | Futures | 1155.6 | 1180.9 | 1155.2 | 1165.0 | 129.0 |
| 2014-08-25 | FTI | Futures | 351.26 | 352.77 | 350.1 | 352.6 | 15937.0 |
| 2014-08-25 | FVSA | Futures | 1408.0 | 1446.52 | 1403.72 | 1403.72 | 3099.0 |
| 2014-08-25 | FXXP | Futures | 256.0 | 257.7 | 255.4 | 257.3 | 4032.0 |
| 2014-08-25 | GF | Futures | 327.485 | 330.859 | 326.942 | 330.859 | 2393.0 |
| 2014-08-25 | GSCI | Futures | 1009.15 | 1011.33 | 1007.97 | 1009.99 | 27.0 |
| 2014-08-25 | HE | Futures | 112.191 | 113.611 | 112.13 | 112.977 | 16190.0 |
| 2014-08-25 | HG | Futures | 4.0881 | 4.1173 | 4.0786 | 4.1058 | 14273.0 |
| 2014-08-25 | HH | Futures | 48.747 | 48.747 | 48.747 | 48.747 | 807.0 |
| 2014-08-25 | HO | Futures | 2.2677 | 2.2793 | 2.2603 | 2.2725 | 10984.0 |
| 2014-08-25 | HRC | Futures | 2509.6 | 2509.6 | 2509.6 | 2509.6 | 0.0 |
| 2014-08-25 | J1 | Futures | 0.0120585 | 0.0120874 | 0.0120422 | 0.0120736 | 69615.0 |
> showing 50 of 99 rows — these rows as CSV