PREVIEW / futures_daily / 2012-08-06
file: by_date/futures_daily/2012/2012-08-06.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-06 | ES | Futures | 1407.93 | 1413.5 | 1404.9 | 1407.68 | 1171977.0 |
| 2012-08-06 | NQ | Futures | 3070.27 | 3100.97 | 3066.54 | 3083.47 | 160449.0 |
| 2012-08-06 | YM | Futures | 12674.4 | 12741.3 | 12645.3 | 12677.3 | 72418.0 |
| 2012-08-06 | CL | Futures | 165.78 | 167.57 | 164.49 | 167.34 | 194374.0 |
| 2012-08-06 | GC | Futures | 2146.5 | 2160.8 | 2143.3 | 2157.8 | 79352.0 |
| 2012-08-06 | ZN | Futures | 116.781125 | 117.067119 | 116.672174 | 116.890075 | 577265.0 |
| 2012-08-06 | A6 | Futures | 0.94756 | 0.94882 | 0.94378 | 0.94774 | 87810.0 |
| 2012-08-06 | AD | Futures | 1.0003 | 1.00331 | 0.9996 | 1.0024 | 58257.0 |
| 2012-08-06 | B | Futures | 97.62 | 98.35 | 96.76 | 98.22 | 105882.0 |
| 2012-08-06 | B6 | Futures | 1.6344 | 1.6372 | 1.6246 | 1.6312 | 83225.0 |
| 2012-08-06 | BFX | Futures | 2762.5 | 2811.5 | 2762.5 | 2803.4 | 59.0 |
| 2012-08-06 | BR | Futures | 0.2342 | 0.2346 | 0.23389 | 0.23444 | 146.0 |
| 2012-08-06 | BZ | Futures | 102.59 | 103.61 | 102.14 | 103.51 | 748.0 |
| 2012-08-06 | C | Futures | 1671.0 | 1678.0 | 1660.0 | 1671.0 | 4060.0 |
| 2012-08-06 | CC | Futures | 1807.0 | 1820.0 | 1783.0 | 1817.0 | 11376.0 |
| 2012-08-06 | CSC | Futures | 4.029 | 4.086 | 4.012 | 4.075 | 23.0 |
| 2012-08-06 | CT | Futures | 96.24 | 98.96 | 96.18 | 98.96 | 65.0 |
| 2012-08-06 | DC | Futures | 29.93 | 30.5 | 29.9 | 30.38 | 426.0 |
| 2012-08-06 | DX | Futures | 79.984 | 80.197 | 79.712 | 79.886 | 15132.0 |
| 2012-08-06 | E1 | Futures | 1.33299 | 1.33841 | 1.32486 | 1.33338 | 40899.0 |
| 2012-08-06 | E6 | Futures | 1.46247 | 1.46861 | 1.45646 | 1.46271 | 209578.0 |
| 2012-08-06 | E7 | Futures | 1.4533 | 1.4592 | 1.4474 | 1.4536 | 3676.0 |
| 2012-08-06 | ED | Futures | 95.1895 | 95.1991 | 95.1847 | 95.1895 | 66379.0 |
| 2012-08-06 | ER | Futures | 97.778 | 97.817 | 97.773 | 97.798 | 87051.0 |
| 2012-08-06 | EW | Futures | 956.8 | 964.3 | 955.3 | 960.8 | 16000.0 |
| 2012-08-06 | FBTP | Futures | 65.33 | 65.58 | 65.11 | 65.44 | 13039.0 |
| 2012-08-06 | FBTS | Futures | 86.708 | 86.907 | 86.642 | 86.766 | 3170.0 |
| 2012-08-06 | FCE | Futures | 2510.3 | 2543.4 | 2499.1 | 2530.7 | 112678.0 |
| 2012-08-06 | FDAX | Futures | 7499.4 | 7582.4 | 7475.4 | 7556.2 | 112743.0 |
| 2012-08-06 | FESX | Futures | 1600.1 | 1628.5 | 1596.1 | 1621.1 | 1035731.0 |
| 2012-08-06 | FEU3 | Futures | 98.369 | 98.379 | 98.369 | 98.379 | 100.0 |
| 2012-08-06 | FGBL | Futures | 118.07 | 118.64 | 117.96 | 118.28 | 453048.0 |
| 2012-08-06 | FGBM | Futures | 116.06 | 116.37 | 115.98 | 116.25 | 298868.0 |
| 2012-08-06 | FGBS | Futures | 110.482 | 110.542 | 110.462 | 110.527 | 190903.0 |
| 2012-08-06 | FGBX | Futures | 126.19 | 127.67 | 126.15 | 126.64 | 3475.0 |
| 2012-08-06 | FOAT | Futures | 102.5 | 102.8 | 102.37 | 102.54 | 11625.0 |
| 2012-08-06 | FTDX | Futures | 730.5 | 743.5 | 730.0 | 742.1 | 93.0 |
| 2012-08-06 | FTI | Futures | 279.4 | 281.92 | 278.3 | 280.26 | 29823.0 |
| 2012-08-06 | FTUK | Futures | 4182.9 | 4219.7 | 4167.3 | 4199.7 | 73398.0 |
| 2012-08-06 | FVSA | Futures | 6651.2 | 7011.48 | 6471.07 | 6581.92 | 4988.0 |
| 2012-08-06 | FXXP | Futures | 189.5 | 191.4 | 189.2 | 191.0 | 7401.0 |
| 2012-08-06 | G | Futures | 100.23 | 100.81 | 100.2 | 100.5 | 87726.0 |
| 2012-08-06 | GF | Futures | 276.057 | 277.931 | 273.145 | 273.195 | 1696.0 |
| 2012-08-06 | GSCI | Futures | 1026.72 | 1037.62 | 1024.09 | 1037.62 | 298.0 |
| 2012-08-06 | HE | Futures | 93.925 | 94.234 | 92.843 | 92.905 | 14724.0 |
| 2012-08-06 | HG | Futures | 4.3351 | 4.3705 | 4.308 | 4.366 | 37127.0 |
| 2012-08-06 | HO | Futures | 2.3924 | 2.4098 | 2.3774 | 2.4045 | 45559.0 |
| 2012-08-06 | HRC | Futures | 2529.1 | 2529.1 | 2529.1 | 2529.1 | 0.0 |
| 2012-08-06 | J1 | Futures | 0.0159506 | 0.0160446 | 0.0159406 | 0.0160271 | 66398.0 |
| 2012-08-06 | J7 | Futures | 0.015901 | 0.015982 | 0.015881 | 0.015964 | 153.0 |
> showing 50 of 97 rows — these rows as CSV