PREVIEW / futures_daily / 2014-11-24
file: by_date/futures_daily/2014/2014-11-24.parquet size: 9 KB rows: 106
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-11-24 | ES | Futures | 2154.2 | 2161.25 | 2152.63 | 2159.68 | 793915.0 |
| 2014-11-24 | NQ | Futures | 4925.36 | 4968.24 | 4923.33 | 4962.73 | 158380.0 |
| 2014-11-24 | YM | Futures | 18038.2 | 18091.0 | 18023.0 | 18050.4 | 71611.0 |
| 2014-11-24 | CL | Futures | 147.7 | 148.47 | 145.45 | 146.08 | 194751.0 |
| 2014-11-24 | GC | Futures | 1573.9 | 1579.0 | 1563.8 | 1568.3 | 158694.0 |
| 2014-11-24 | ZN | Futures | 118.729751 | 118.905474 | 118.568672 | 118.817612 | 1777839.0 |
| 2014-11-24 | A6 | Futures | 0.84128 | 0.8442 | 0.83477 | 0.83545 | 58552.0 |
| 2014-11-24 | AD | Futures | 0.90341 | 0.90453 | 0.89752 | 0.89863 | 47712.0 |
| 2014-11-24 | ALI | Futures | 3068.6 | 3068.6 | 3068.6 | 3068.6 | 0.0 |
| 2014-11-24 | B | Futures | 83.23 | 83.59 | 82.09 | 82.38 | 151150.0 |
| 2014-11-24 | B6 | Futures | 1.6444 | 1.6515 | 1.6425 | 1.6497 | 55469.0 |
| 2014-11-24 | BFX | Futures | 3920.7 | 3934.3 | 3915.7 | 3915.7 | 11.0 |
| 2014-11-24 | BR | Futures | 0.21388 | 0.21415 | 0.21002 | 0.21087 | 1048.0 |
| 2014-11-24 | BZ | Futures | 83.99 | 84.41 | 82.94 | 83.22 | 11108.0 |
| 2014-11-24 | C | Futures | 2018.0 | 2042.0 | 2010.0 | 2040.0 | 3740.0 |
| 2014-11-24 | CB | Futures | 138.629 | 138.629 | 138.013 | 138.013 | 30.0 |
| 2014-11-24 | CC | Futures | 2077.0 | 2124.0 | 2068.0 | 2115.0 | 12864.0 |
| 2014-11-24 | CNH | Futures | 7.0483 | 7.0681 | 7.0483 | 7.0681 | 11.0 |
| 2014-11-24 | CSC | Futures | 4.83 | 4.844 | 4.83 | 4.844 | 38.0 |
| 2014-11-24 | CT | Futures | 75.72 | 75.94 | 74.75 | 75.11 | 13498.0 |
| 2014-11-24 | DC | Futures | 39.39 | 39.39 | 38.8 | 39.2 | 97.0 |
| 2014-11-24 | DX | Futures | 83.958 | 84.025 | 83.674 | 83.732 | 26081.0 |
| 2014-11-24 | E1 | Futures | 1.31561 | 1.32341 | 1.31522 | 1.32251 | 34041.0 |
| 2014-11-24 | E6 | Futures | 1.45679 | 1.46503 | 1.45561 | 1.46385 | 201664.0 |
| 2014-11-24 | E7 | Futures | 1.4472 | 1.4558 | 1.4466 | 1.4546 | 3045.0 |
| 2014-11-24 | ED | Futures | 95.4398 | 95.4422 | 95.4374 | 95.4398 | 45295.0 |
| 2014-11-24 | ER | Futures | 98.004 | 98.004 | 97.994 | 97.999 | 26646.0 |
| 2014-11-24 | EW | Futures | 1504.4 | 1514.5 | 1503.5 | 1514.3 | 8712.0 |
| 2014-11-24 | FBTP | Futures | 96.78 | 97.12 | 96.67 | 96.92 | 63020.0 |
| 2014-11-24 | FBTS | Futures | 98.712 | 98.881 | 98.712 | 98.774 | 16652.0 |
| 2014-11-24 | FCE | Futures | 3509.0 | 3560.1 | 3507.8 | 3535.0 | 93508.0 |
| 2014-11-24 | FDAX | Futures | 10636.8 | 10772.1 | 10633.0 | 10719.0 | 105911.0 |
| 2014-11-24 | FDIV | Futures | 140.02 | 140.02 | 139.79 | 139.79 | 30.0 |
| 2014-11-24 | FESX | Futures | 2307.1 | 2343.3 | 2305.7 | 2325.2 | 1102812.0 |
| 2014-11-24 | FGBL | Futures | 133.89 | 133.96 | 133.73 | 133.8 | 440460.0 |
| 2014-11-24 | FGBM | Futures | 123.18 | 123.23 | 123.17 | 123.19 | 216742.0 |
| 2014-11-24 | FGBS | Futures | 110.853 | 110.878 | 110.853 | 110.863 | 157442.0 |
| 2014-11-24 | FGBX | Futures | 147.16 | 147.2 | 146.52 | 146.74 | 19559.0 |
| 2014-11-24 | FMWO | Futures | 5795.2 | 5804.0 | 5792.7 | 5792.7 | 3561.0 |
| 2014-11-24 | FOAT | Futures | 123.46 | 123.53 | 123.33 | 123.43 | 40492.0 |
| 2014-11-24 | FTDX | Futures | 1259.9 | 1272.6 | 1259.4 | 1269.3 | 255.0 |
| 2014-11-24 | FTI | Futures | 367.94 | 370.37 | 367.29 | 367.77 | 28539.0 |
| 2014-11-24 | FTUK | Futures | 5225.2 | 5231.0 | 5195.5 | 5203.6 | 63627.0 |
| 2014-11-24 | FVSA | Futures | 1525.22 | 1569.17 | 1525.22 | 1564.78 | 3900.0 |
| 2014-11-24 | FXXP | Futures | 263.0 | 263.3 | 261.8 | 262.5 | 9802.0 |
| 2014-11-24 | G | Futures | 100.38 | 100.41 | 100.17 | 100.29 | 207595.0 |
| 2014-11-24 | GF | Futures | 379.221 | 380.584 | 374.407 | 374.407 | 3879.0 |
| 2014-11-24 | GSCI | Futures | 884.16 | 888.14 | 878.67 | 880.19 | 136.0 |
| 2014-11-24 | HE | Futures | 121.881 | 123.222 | 121.344 | 121.411 | 13322.0 |
| 2014-11-24 | HG | Futures | 3.861 | 3.8687 | 3.8102 | 3.8185 | 39530.0 |
> showing 50 of 106 rows — these rows as CSV