PREVIEW / futures_daily / 2014-09-25
file: by_date/futures_daily/2014/2014-09-25.parquet size: 9 KB rows: 104
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-09-25 | ES | Futures | 2079.51 | 2080.29 | 2045.04 | 2048.96 | 2318873.0 |
| 2014-09-25 | NQ | Futures | 4734.71 | 4738.47 | 4633.88 | 4644.6 | 442898.0 |
| 2014-09-25 | YM | Futures | 17378.8 | 17398.1 | 17107.9 | 17145.5 | 212814.0 |
| 2014-09-25 | CL | Futures | 174.98 | 176.2 | 173.4 | 174.3 | 248852.0 |
| 2014-09-25 | GC | Futures | 1596.7 | 1607.2 | 1582.6 | 1602.7 | 186354.0 |
| 2014-09-25 | ZN | Futures | 116.474647 | 117.001815 | 116.460004 | 116.913953 | 1424907.0 |
| 2014-09-25 | A6 | Futures | 0.8579 | 0.8581 | 0.84779 | 0.84886 | 151830.0 |
| 2014-09-25 | AD | Futures | 0.91651 | 0.91662 | 0.91103 | 0.91347 | 75747.0 |
| 2014-09-25 | ALI | Futures | 2958.96 | 2958.96 | 2947.92 | 2947.92 | 5.0 |
| 2014-09-25 | B | Futures | 101.28 | 101.93 | 100.59 | 101.34 | 140440.0 |
| 2014-09-25 | B6 | Futures | 1.7162 | 1.7166 | 1.7097 | 1.7134 | 133077.0 |
| 2014-09-25 | BR | Futures | 0.22354 | 0.22354 | 0.21814 | 0.21906 | 839.0 |
| 2014-09-25 | BZ | Futures | 101.99 | 102.67 | 101.33 | 102.09 | 16942.0 |
| 2014-09-25 | C | Futures | 2305.0 | 2329.0 | 2277.0 | 2279.0 | 5530.0 |
| 2014-09-25 | CB | Futures | 161.862 | 162.633 | 161.014 | 162.247 | 18.0 |
| 2014-09-25 | CC | Futures | 2481.0 | 2509.0 | 2453.0 | 2460.0 | 14350.0 |
| 2014-09-25 | CNH | Futures | 7.0809 | 7.0903 | 7.0809 | 7.0869 | 25.0 |
| 2014-09-25 | CSC | Futures | 5.523 | 5.523 | 5.41 | 5.41 | 47.0 |
| 2014-09-25 | CT | Futures | 78.14 | 78.31 | 77.08 | 77.8 | 14524.0 |
| 2014-09-25 | DC | Futures | 43.76 | 44.76 | 43.34 | 43.47 | 161.0 |
| 2014-09-25 | DX | Futures | 80.878 | 81.272 | 80.845 | 80.976 | 39060.0 |
| 2014-09-25 | E1 | Futures | 1.35307 | 1.35358 | 1.34463 | 1.35141 | 40770.0 |
| 2014-09-25 | E6 | Futures | 1.50517 | 1.50552 | 1.49528 | 1.5014 | 279428.0 |
| 2014-09-25 | E7 | Futures | 1.4956 | 1.4961 | 1.486 | 1.492 | 3500.0 |
| 2014-09-25 | ED | Futures | 95.4278 | 95.4374 | 95.4278 | 95.4278 | 138884.0 |
| 2014-09-25 | ER | Futures | 98.009 | 98.009 | 97.999 | 98.009 | 42045.0 |
| 2014-09-25 | EW | Futures | 1447.4 | 1448.0 | 1423.7 | 1430.9 | 30154.0 |
| 2014-09-25 | FBTP | Futures | 95.14 | 95.51 | 95.14 | 95.34 | 74148.0 |
| 2014-09-25 | FBTS | Futures | 98.686 | 98.721 | 98.668 | 98.703 | 17965.0 |
| 2014-09-25 | FCE | Futures | 3516.1 | 3528.0 | 3456.3 | 3466.7 | 116806.0 |
| 2014-09-25 | FDAX | Futures | 10601.8 | 10653.2 | 10374.4 | 10419.4 | 142794.0 |
| 2014-09-25 | FESX | Futures | 2343.3 | 2353.5 | 2303.5 | 2310.7 | 1155636.0 |
| 2014-09-25 | FGBL | Futures | 131.18 | 131.69 | 131.18 | 131.59 | 632857.0 |
| 2014-09-25 | FGBM | Futures | 122.63 | 122.86 | 122.63 | 122.84 | 364089.0 |
| 2014-09-25 | FGBS | Futures | 110.903 | 110.943 | 110.903 | 110.943 | 155936.0 |
| 2014-09-25 | FGBX | Futures | 140.29 | 141.27 | 140.29 | 141.01 | 21666.0 |
| 2014-09-25 | FMWO | Futures | 5715.0 | 5715.0 | 5656.1 | 5656.1 | 2.0 |
| 2014-09-25 | FOAT | Futures | 121.06 | 121.44 | 121.06 | 121.39 | 48792.0 |
| 2014-09-25 | FTDX | Futures | 1174.8 | 1195.1 | 1167.2 | 1173.8 | 252.0 |
| 2014-09-25 | FTI | Futures | 364.32 | 365.36 | 359.7 | 360.57 | 39647.0 |
| 2014-09-25 | FTUK | Futures | 5173.4 | 5182.3 | 5098.4 | 5115.1 | 108915.0 |
| 2014-09-25 | FVSA | Futures | 1376.19 | 1445.2 | 1364.01 | 1428.96 | 12631.0 |
| 2014-09-25 | FXXP | Futures | 261.2 | 262.0 | 257.7 | 258.6 | 8086.0 |
| 2014-09-25 | G | Futures | 96.5 | 96.78 | 96.39 | 96.66 | 170369.0 |
| 2014-09-25 | GF | Futures | 358.484 | 359.884 | 356.734 | 357.978 | 2971.0 |
| 2014-09-25 | GSCI | Futures | 979.15 | 982.69 | 973.43 | 976.37 | 203.0 |
| 2014-09-25 | HE | Futures | 127.726 | 127.726 | 124.16 | 125.977 | 14216.0 |
| 2014-09-25 | HG | Futures | 3.875 | 3.8858 | 3.83 | 3.8433 | 51591.0 |
| 2014-09-25 | HH | Futures | 47.451 | 48.527 | 47.028 | 48.527 | 212.0 |
| 2014-09-25 | HO | Futures | 2.151 | 2.1642 | 2.1408 | 2.154 | 17130.0 |
> showing 50 of 104 rows — these rows as CSV