PREVIEW / futures_daily / 2015-03-23
file: by_date/futures_daily/2015/2015-03-23.parquet size: 9 KB rows: 108
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-03-23 | ES | Futures | 2205.71 | 2215.43 | 2200.97 | 2202.55 | 957576.0 |
| 2015-03-23 | NQ | Futures | 5164.85 | 5179.66 | 5150.34 | 5151.21 | 149739.0 |
| 2015-03-23 | YM | Futures | 18444.2 | 18540.3 | 18392.0 | 18427.8 | 73526.0 |
| 2015-03-23 | CL | Futures | 81.74 | 83.85 | 79.83 | 83.57 | 292417.0 |
| 2015-03-23 | GC | Futures | 1547.0 | 1557.2 | 1541.0 | 1552.9 | 162532.0 |
| 2015-03-23 | ZN | Futures | 121.894159 | 122.130962 | 121.820159 | 122.042161 | 745365.0 |
| 2015-03-23 | A6 | Futures | 0.76512 | 0.77538 | 0.76187 | 0.77341 | 128149.0 |
| 2015-03-23 | AD | Futures | 0.81322 | 0.81628 | 0.80852 | 0.81557 | 54685.0 |
| 2015-03-23 | ALI | Futures | 2679.79 | 2679.79 | 2679.79 | 2679.79 | 0.0 |
| 2015-03-23 | B | Futures | 54.36 | 55.3 | 53.26 | 55.03 | 191637.0 |
| 2015-03-23 | B6 | Futures | 1.575 | 1.5753 | 1.5611 | 1.5717 | 121095.0 |
| 2015-03-23 | BFX | Futures | 4532.1 | 4532.1 | 4516.4 | 4527.8 | 22.0 |
| 2015-03-23 | BR | Futures | 0.17399 | 0.1777 | 0.17399 | 0.17667 | 221.0 |
| 2015-03-23 | BZ | Futures | 53.99 | 54.81 | 52.83 | 54.55 | 20185.0 |
| 2015-03-23 | C | Futures | 2118.0 | 2121.0 | 2096.0 | 2098.0 | 6105.0 |
| 2015-03-23 | CB | Futures | 141.398 | 141.398 | 141.398 | 141.398 | 1.0 |
| 2015-03-23 | CC | Futures | 2040.0 | 2051.0 | 2029.0 | 2035.0 | 13248.0 |
| 2015-03-23 | CNH | Futures | 7.0488 | 7.0488 | 7.0338 | 7.0338 | 43.0 |
| 2015-03-23 | CSC | Futures | 4.268 | 4.274 | 4.207 | 4.223 | 108.0 |
| 2015-03-23 | CT | Futures | 80.22 | 82.74 | 79.93 | 82.1 | 17273.0 |
| 2015-03-23 | DC | Futures | 34.46 | 34.5 | 34.01 | 34.12 | 168.0 |
| 2015-03-23 | DX | Futures | 91.831 | 92.536 | 91.136 | 91.36 | 74919.0 |
| 2015-03-23 | E1 | Futures | 1.31124 | 1.3259 | 1.30283 | 1.32233 | 20046.0 |
| 2015-03-23 | E6 | Futures | 1.27906 | 1.29164 | 1.26765 | 1.28811 | 349418.0 |
| 2015-03-23 | E7 | Futures | 1.2718 | 1.2842 | 1.2602 | 1.2807 | 9984.0 |
| 2015-03-23 | EBM | Futures | 317.32 | 319.73 | 313.31 | 313.71 | 24775.0 |
| 2015-03-23 | ED | Futures | 95.4998 | 95.5141 | 95.4902 | 95.4998 | 128807.0 |
| 2015-03-23 | ER | Futures | 98.058 | 98.058 | 98.048 | 98.053 | 25704.0 |
| 2015-03-23 | EW | Futures | 1608.2 | 1612.7 | 1604.0 | 1607.1 | 9079.0 |
| 2015-03-23 | FBTP | Futures | 104.25 | 104.25 | 103.22 | 103.36 | 70792.0 |
| 2015-03-23 | FBTS | Futures | 99.599 | 99.599 | 99.475 | 99.484 | 15834.0 |
| 2015-03-23 | FCE | Futures | 4135.5 | 4136.3 | 4094.0 | 4111.1 | 89024.0 |
| 2015-03-23 | FDAX | Futures | 13389.5 | 13390.1 | 13147.7 | 13214.2 | 109422.0 |
| 2015-03-23 | FDIV | Futures | 165.19 | 165.19 | 164.77 | 164.77 | 7.0 |
| 2015-03-23 | FESX | Futures | 2692.5 | 2693.2 | 2658.6 | 2668.2 | 881087.0 |
| 2015-03-23 | FEU3 | Futures | 98.695 | 98.695 | 98.69 | 98.69 | 425.0 |
| 2015-03-23 | FGBL | Futures | 141.15 | 141.21 | 140.58 | 140.7 | 430619.0 |
| 2015-03-23 | FGBM | Futures | 124.84 | 124.86 | 124.57 | 124.62 | 325460.0 |
| 2015-03-23 | FGBS | Futures | 111.243 | 111.248 | 111.198 | 111.203 | 137352.0 |
| 2015-03-23 | FGBX | Futures | 177.57 | 177.74 | 176.4 | 176.58 | 27761.0 |
| 2015-03-23 | FMWO | Futures | 5863.1 | 5863.1 | 5853.2 | 5854.5 | 152.0 |
| 2015-03-23 | FOAT | Futures | 130.18 | 130.18 | 129.38 | 129.49 | 79333.0 |
| 2015-03-23 | FTDX | Futures | 1567.3 | 1567.3 | 1527.0 | 1535.4 | 210.0 |
| 2015-03-23 | FTI | Futures | 431.59 | 432.02 | 427.74 | 429.77 | 23592.0 |
| 2015-03-23 | FTUK | Futures | 5499.2 | 5509.0 | 5466.1 | 5494.9 | 79542.0 |
| 2015-03-23 | FVSA | Futures | 1753.3 | 1804.12 | 1753.3 | 1774.47 | 7825.0 |
| 2015-03-23 | FXXP | Futures | 305.4 | 305.6 | 302.6 | 303.3 | 9262.0 |
| 2015-03-23 | G | Futures | 105.54 | 105.81 | 105.32 | 105.52 | 124982.0 |
| 2015-03-23 | GF | Futures | 368.05 | 373.352 | 367.668 | 371.825 | 2786.0 |
| 2015-03-23 | GSCI | Futures | 684.3 | 694.21 | 682.32 | 692.92 | 296.0 |
> showing 50 of 108 rows — these rows as CSV