PREVIEW / futures_daily / 2014-04-24
file: by_date/futures_daily/2014/2014-04-24.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 |
|---|---|---|---|---|---|---|---|
| 2014-04-24 | ES | Futures | 1944.08 | 1947.71 | 1928.31 | 1937.88 | 1577086.0 |
| 2014-04-24 | NQ | Futures | 4139.09 | 4164.99 | 4079.52 | 4126.42 | 393068.0 |
| 2014-04-24 | YM | Futures | 16562.6 | 16580.7 | 16451.2 | 16498.4 | 157844.0 |
| 2014-04-24 | CL | Futures | 183.92 | 185.38 | 183.66 | 184.64 | 202278.0 |
| 2014-04-24 | GC | Futures | 1691.7 | 1711.6 | 1671.2 | 1700.5 | 189289.0 |
| 2014-04-24 | ZN | Futures | 114.808838 | 115.026141 | 114.591534 | 114.895759 | 1400257.0 |
| 2014-04-24 | A6 | Futures | 0.88934 | 0.89049 | 0.88588 | 0.88655 | 59161.0 |
| 2014-04-24 | AD | Futures | 0.91785 | 0.91937 | 0.91745 | 0.91846 | 30068.0 |
| 2014-04-24 | B | Futures | 112.8 | 114.27 | 112.64 | 113.94 | 215429.0 |
| 2014-04-24 | B6 | Futures | 1.7629 | 1.7658 | 1.7614 | 1.7649 | 52915.0 |
| 2014-04-24 | BR | Futures | 0.23547 | 0.23555 | 0.23413 | 0.23492 | 1036.0 |
| 2014-04-24 | BZ | Futures | 114.96 | 116.44 | 114.82 | 116.13 | 6422.0 |
| 2014-04-24 | C | Futures | 1955.0 | 1960.0 | 1937.0 | 1939.0 | 7487.0 |
| 2014-04-24 | CB | Futures | 94.431 | 94.431 | 94.177 | 94.431 | 8.0 |
| 2014-04-24 | CC | Futures | 2217.0 | 2224.0 | 2183.0 | 2197.0 | 16220.0 |
| 2014-04-24 | CNH | Futures | 7.1674 | 7.1817 | 7.1653 | 7.1773 | 33.0 |
| 2014-04-24 | CSC | Futures | 4.417 | 4.491 | 4.417 | 4.486 | 9.0 |
| 2014-04-24 | CT | Futures | 104.42 | 105.31 | 104.04 | 104.94 | 11837.0 |
| 2014-04-24 | DC | Futures | 35.39 | 36.17 | 35.39 | 36.05 | 260.0 |
| 2014-04-24 | DX | Futures | 75.931 | 76.054 | 75.822 | 75.885 | 12194.0 |
| 2014-04-24 | E1 | Futures | 1.45342 | 1.45676 | 1.44957 | 1.45547 | 24573.0 |
| 2014-04-24 | E6 | Futures | 1.6308 | 1.63411 | 1.62785 | 1.63186 | 157395.0 |
| 2014-04-24 | E7 | Futures | 1.62 | 1.6231 | 1.6171 | 1.621 | 2936.0 |
| 2014-04-24 | EBM | Futures | 301.56 | 305.09 | 300.86 | 304.38 | 12569.0 |
| 2014-04-24 | ED | Futures | 95.4091 | 95.4091 | 95.4043 | 95.4091 | 42844.0 |
| 2014-04-24 | ER | Futures | 97.822 | 97.822 | 97.813 | 97.817 | 55236.0 |
| 2014-04-24 | EW | Futures | 1410.5 | 1412.6 | 1392.2 | 1403.8 | 17158.0 |
| 2014-04-24 | FBTP | Futures | 88.77 | 88.82 | 88.44 | 88.58 | 58496.0 |
| 2014-04-24 | FBTS | Futures | 97.522 | 97.522 | 97.434 | 97.469 | 11276.0 |
| 2014-04-24 | FCE | Futures | 3498.8 | 3524.2 | 3476.2 | 3507.9 | 120166.0 |
| 2014-04-24 | FDAX | Futures | 10615.7 | 10673.2 | 10405.9 | 10546.2 | 123463.0 |
| 2014-04-24 | FESX | Futures | 2251.3 | 2262.8 | 2220.5 | 2246.3 | 1009323.0 |
| 2014-04-24 | FGBL | Futures | 124.13 | 124.41 | 123.88 | 124.2 | 706734.0 |
| 2014-04-24 | FGBM | Futures | 119.66 | 119.83 | 119.54 | 119.68 | 448096.0 |
| 2014-04-24 | FGBS | Futures | 110.473 | 110.518 | 110.443 | 110.483 | 367738.0 |
| 2014-04-24 | FGBX | Futures | 127.82 | 128.41 | 127.41 | 128.05 | 19356.0 |
| 2014-04-24 | FMWO | Futures | 5583.4 | 5583.4 | 5554.4 | 5569.6 | 111.0 |
| 2014-04-24 | FOAT | Futures | 113.51 | 113.71 | 113.22 | 113.52 | 49316.0 |
| 2014-04-24 | FTDX | Futures | 1158.7 | 1162.0 | 1139.5 | 1146.6 | 152.0 |
| 2014-04-24 | FTI | Futures | 340.22 | 341.3 | 335.64 | 338.92 | 37177.0 |
| 2014-04-24 | FTUK | Futures | 5067.3 | 5095.1 | 5050.1 | 5072.6 | 99838.0 |
| 2014-04-24 | FVSA | Futures | 1751.75 | 1818.4 | 1727.95 | 1766.03 | 11714.0 |
| 2014-04-24 | FXXP | Futures | 249.7 | 250.7 | 247.3 | 249.1 | 14056.0 |
| 2014-04-24 | G | Futures | 93.87 | 94.04 | 93.56 | 93.84 | 152203.0 |
| 2014-04-24 | GF | Futures | 284.609 | 286.24 | 284.569 | 285.842 | 1785.0 |
| 2014-04-24 | GSCI | Futures | 1091.77 | 1097.81 | 1091.77 | 1096.57 | 58.0 |
| 2014-04-24 | HE | Futures | 144.034 | 144.617 | 142.313 | 143.363 | 505.0 |
| 2014-04-24 | HG | Futures | 3.8838 | 3.9547 | 3.8781 | 3.9458 | 32656.0 |
| 2014-04-24 | HH | Futures | 59.87 | 59.87 | 59.87 | 59.87 | 682.0 |
| 2014-04-24 | HO | Futures | 2.3732 | 2.4034 | 2.3689 | 2.3984 | 49896.0 |
> showing 50 of 103 rows — these rows as CSV