PREVIEW / futures_daily / 2014-03-20
file: by_date/futures_daily/2014/2014-03-20.parquet size: 9 KB rows: 105
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-03-20 | ES | Futures | 1915.37 | 1931.15 | 1908.65 | 1930.63 | 1671773.0 |
| 2014-03-20 | NQ | Futures | 4228.87 | 4256.79 | 4209.88 | 4249.3 | 263321.0 |
| 2014-03-20 | YM | Futures | 16202.2 | 16346.7 | 16142.9 | 16331.7 | 168700.0 |
| 2014-03-20 | CL | Futures | 176.9 | 177.47 | 175.05 | 176.49 | 244866.0 |
| 2014-03-20 | GC | Futures | 1755.4 | 1760.2 | 1741.1 | 1753.9 | 167021.0 |
| 2014-03-20 | ZN | Futures | 114.432178 | 114.591534 | 114.258335 | 114.403204 | 1588779.0 |
| 2014-03-20 | A6 | Futures | 0.86282 | 0.86455 | 0.85917 | 0.8633 | 74397.0 |
| 2014-03-20 | AD | Futures | 0.89991 | 0.90072 | 0.89686 | 0.90011 | 53582.0 |
| 2014-03-20 | B | Futures | 108.95 | 109.82 | 108.44 | 109.51 | 205209.0 |
| 2014-03-20 | B6 | Futures | 1.7365 | 1.7402 | 1.7309 | 1.7334 | 78804.0 |
| 2014-03-20 | BFX | Futures | 3706.7 | 3721.3 | 3706.7 | 3721.3 | 6.0 |
| 2014-03-20 | BR | Futures | 0.22211 | 0.22225 | 0.22211 | 0.22225 | 72.0 |
| 2014-03-20 | BZ | Futures | 111.03 | 112.01 | 110.64 | 111.71 | 7396.0 |
| 2014-03-20 | C | Futures | 1988.0 | 1990.0 | 1961.0 | 1974.0 | 7288.0 |
| 2014-03-20 | CB | Futures | 93.923 | 94.025 | 93.923 | 93.923 | 6.0 |
| 2014-03-20 | CC | Futures | 2227.0 | 2229.0 | 2198.0 | 2208.0 | 12151.0 |
| 2014-03-20 | CNH | Futures | 7.1328 | 7.1386 | 7.128 | 7.1309 | 49.0 |
| 2014-03-20 | CSC | Futures | 4.471 | 4.484 | 4.462 | 4.466 | 28.0 |
| 2014-03-20 | CT | Futures | 103.92 | 104.48 | 103.2 | 103.61 | 8093.0 |
| 2014-03-20 | DC | Futures | 35.55 | 35.84 | 35.46 | 35.6 | 135.0 |
| 2014-03-20 | DX | Futures | 76.173 | 76.482 | 76.054 | 76.338 | 28085.0 |
| 2014-03-20 | E1 | Futures | 1.45612 | 1.45933 | 1.4479 | 1.45329 | 41964.0 |
| 2014-03-20 | E6 | Futures | 1.63127 | 1.63434 | 1.62289 | 1.62667 | 209266.0 |
| 2014-03-20 | E7 | Futures | 1.6204 | 1.6234 | 1.6122 | 1.6158 | 4057.0 |
| 2014-03-20 | EBM | Futures | 299.45 | 302.97 | 297.34 | 297.69 | 18055.0 |
| 2014-03-20 | ED | Futures | 95.3804 | 95.3851 | 95.3804 | 95.3851 | 106099.0 |
| 2014-03-20 | ER | Futures | 97.813 | 97.817 | 97.803 | 97.808 | 79198.0 |
| 2014-03-20 | EW | Futures | 1416.8 | 1423.6 | 1409.7 | 1422.7 | 16463.0 |
| 2014-03-20 | FBTP | Futures | 86.44 | 86.49 | 86.12 | 86.31 | 54938.0 |
| 2014-03-20 | FBTS | Futures | 96.976 | 97.003 | 96.932 | 96.985 | 12276.0 |
| 2014-03-20 | FCE | Futures | 3315.1 | 3361.4 | 3305.8 | 3359.5 | 79361.0 |
| 2014-03-20 | FDAX | Futures | 10174.6 | 10294.4 | 10129.8 | 10284.5 | 35422.0 |
| 2014-03-20 | FESX | Futures | 2142.9 | 2172.3 | 2133.5 | 2169.4 | 716844.0 |
| 2014-03-20 | FEU3 | Futures | 98.423 | 98.428 | 98.423 | 98.428 | 6.0 |
| 2014-03-20 | FGBL | Futures | 123.06 | 123.1 | 122.62 | 122.88 | 891766.0 |
| 2014-03-20 | FGBM | Futures | 119.31 | 119.4 | 119.12 | 119.25 | 775449.0 |
| 2014-03-20 | FGBS | Futures | 110.463 | 110.473 | 110.403 | 110.423 | 455500.0 |
| 2014-03-20 | FGBX | Futures | 125.67 | 125.75 | 124.75 | 125.26 | 29667.0 |
| 2014-03-20 | FMWO | Futures | 5448.4 | 5467.4 | 5444.6 | 5467.4 | 27.0 |
| 2014-03-20 | FOAT | Futures | 111.59 | 111.73 | 111.35 | 111.63 | 79417.0 |
| 2014-03-20 | FTDX | Futures | 1167.7 | 1173.3 | 1159.2 | 1169.1 | 165.0 |
| 2014-03-20 | FTI | Futures | 329.26 | 333.83 | 329.01 | 333.4 | 13924.0 |
| 2014-03-20 | FTUK | Futures | 4941.4 | 4953.6 | 4904.1 | 4951.7 | 83911.0 |
| 2014-03-20 | FVSA | Futures | 1940.97 | 1940.97 | 1840.67 | 1845.68 | 12531.0 |
| 2014-03-20 | FXXP | Futures | 240.1 | 242.0 | 239.5 | 241.9 | 10747.0 |
| 2014-03-20 | G | Futures | 93.19 | 93.2 | 92.82 | 93.04 | 204230.0 |
| 2014-03-20 | GF | Futures | 283.038 | 284.078 | 279.356 | 279.596 | 2050.0 |
| 2014-03-20 | GSCI | Futures | 1060.25 | 1062.07 | 1053.23 | 1057.86 | 72.0 |
| 2014-03-20 | HE | Futures | 147.679 | 148.671 | 146.367 | 147.562 | 465.0 |
| 2014-03-20 | HG | Futures | 3.7759 | 3.7968 | 3.6923 | 3.7113 | 64664.0 |
> showing 50 of 105 rows — these rows as CSV