PREVIEW / futures_daily / 2013-08-12
file: by_date/futures_daily/2013/2013-08-12.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-12 | ES | Futures | 1735.49 | 1739.09 | 1725.45 | 1737.55 | 1251215.0 |
| 2013-08-12 | NQ | Futures | 3601.54 | 3620.05 | 3579.27 | 3613.68 | 171281.0 |
| 2013-08-12 | YM | Futures | 15237.1 | 15267.8 | 15154.8 | 15250.9 | 108258.0 |
| 2013-08-12 | CL | Futures | 184.85 | 185.93 | 183.43 | 185.32 | 257139.0 |
| 2013-08-12 | GC | Futures | 1737.2 | 1777.1 | 1737.2 | 1764.5 | 141631.0 |
| 2013-08-12 | ZN | Futures | 113.910483 | 114.078928 | 113.629743 | 113.756076 | 732539.0 |
| 2013-08-12 | A6 | Futures | 0.85954 | 0.86319 | 0.85513 | 0.8571 | 79027.0 |
| 2013-08-12 | AD | Futures | 0.97792 | 0.97923 | 0.9757 | 0.97782 | 41459.0 |
| 2013-08-12 | B | Futures | 104.92 | 105.81 | 104.22 | 105.65 | 181028.0 |
| 2013-08-12 | B6 | Futures | 1.6257 | 1.627 | 1.6204 | 1.6217 | 59553.0 |
| 2013-08-12 | BFX | Futures | 3375.9 | 3383.5 | 3373.7 | 3383.5 | 3.0 |
| 2013-08-12 | BR | Futures | 0.2165 | 0.21769 | 0.21534 | 0.21591 | 186.0 |
| 2013-08-12 | BZ | Futures | 105.21 | 106.57 | 104.99 | 106.42 | 7805.0 |
| 2013-08-12 | C | Futures | 1746.0 | 1771.0 | 1737.0 | 1756.0 | 3331.0 |
| 2013-08-12 | CB | Futures | 71.399 | 71.399 | 69.844 | 69.964 | 19.0 |
| 2013-08-12 | CC | Futures | 1841.0 | 1866.0 | 1832.0 | 1862.0 | 21782.0 |
| 2013-08-12 | CSC | Futures | 3.404 | 3.414 | 3.337 | 3.353 | 17.0 |
| 2013-08-12 | CT | Futures | 106.02 | 107.25 | 106.02 | 107.25 | 23.0 |
| 2013-08-12 | DC | Futures | 26.07 | 26.24 | 25.41 | 25.74 | 407.0 |
| 2013-08-12 | DX | Futures | 77.598 | 77.937 | 77.517 | 77.769 | 21124.0 |
| 2013-08-12 | E1 | Futures | 1.39419 | 1.3947 | 1.38468 | 1.39008 | 20944.0 |
| 2013-08-12 | E6 | Futures | 1.57439 | 1.57498 | 1.56707 | 1.57097 | 143053.0 |
| 2013-08-12 | E7 | Futures | 1.5639 | 1.5646 | 1.557 | 1.5607 | 2714.0 |
| 2013-08-12 | ED | Futures | 95.3012 | 95.3012 | 95.2964 | 95.2964 | 44630.0 |
| 2013-08-12 | ER | Futures | 97.827 | 97.827 | 97.822 | 97.827 | 19291.0 |
| 2013-08-12 | EW | Futures | 1258.0 | 1264.2 | 1247.3 | 1262.6 | 17270.0 |
| 2013-08-12 | FBTP | Futures | 78.95 | 79.16 | 78.89 | 79.11 | 15072.0 |
| 2013-08-12 | FBTS | Futures | 93.367 | 93.461 | 93.332 | 93.436 | 4633.0 |
| 2013-08-12 | FCE | Futures | 3151.7 | 3154.4 | 3121.7 | 3138.6 | 46030.0 |
| 2013-08-12 | FDAX | Futures | 9274.6 | 9294.0 | 9142.5 | 9283.5 | 91321.0 |
| 2013-08-12 | FESX | Futures | 1987.8 | 1990.6 | 1966.0 | 1984.3 | 642321.0 |
| 2013-08-12 | FGBL | Futures | 119.27 | 119.27 | 118.82 | 119.09 | 444660.0 |
| 2013-08-12 | FGBM | Futures | 117.13 | 117.13 | 116.9 | 117.06 | 308603.0 |
| 2013-08-12 | FGBS | Futures | 110.288 | 110.293 | 110.258 | 110.273 | 152698.0 |
| 2013-08-12 | FGBX | Futures | 123.75 | 123.92 | 122.75 | 123.23 | 9892.0 |
| 2013-08-12 | FMWO | Futures | 5006.7 | 5006.7 | 5006.7 | 5006.7 | 0.0 |
| 2013-08-12 | FOAT | Futures | 106.9 | 106.92 | 106.6 | 106.87 | 20170.0 |
| 2013-08-12 | FTDX | Futures | 966.3 | 966.3 | 959.3 | 965.4 | 89.0 |
| 2013-08-12 | FTI | Futures | 327.59 | 327.94 | 325.5 | 326.76 | 5612.0 |
| 2013-08-12 | FTUK | Futures | 4916.7 | 4933.2 | 4883.7 | 4905.4 | 60738.0 |
| 2013-08-12 | FVSA | Futures | 2588.61 | 2675.12 | 2581.95 | 2601.92 | 1753.0 |
| 2013-08-12 | FXXP | Futures | 225.5 | 225.6 | 223.8 | 225.3 | 4013.0 |
| 2013-08-12 | G | Futures | 94.02 | 94.2 | 93.76 | 93.99 | 93073.0 |
| 2013-08-12 | GF | Futures | 259.22 | 260.083 | 257.658 | 258.151 | 2594.0 |
| 2013-08-12 | GSCI | Futures | 1042.02 | 1052.3 | 1040.05 | 1051.81 | 1625.0 |
| 2013-08-12 | HE | Futures | 102.917 | 104.732 | 102.706 | 104.278 | 16262.0 |
| 2013-08-12 | HG | Futures | 4.1935 | 4.224 | 4.1669 | 4.191 | 63709.0 |
| 2013-08-12 | HH | Futures | 36.708 | 36.972 | 36.466 | 36.466 | 487.0 |
| 2013-08-12 | HO | Futures | 2.4027 | 2.4337 | 2.3922 | 2.4261 | 47063.0 |
| 2013-08-12 | HRC | Futures | 2259.4 | 2259.4 | 2259.4 | 2259.4 | 0.0 |
> showing 50 of 103 rows — these rows as CSV