PREVIEW / futures_daily / 2012-11-13
file: by_date/futures_daily/2012/2012-11-13.parquet size: 9 KB rows: 100
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-11-13 | ES | Futures | 1402.76 | 1410.9 | 1390.04 | 1395.38 | 1950603.0 |
| 2012-11-13 | NQ | Futures | 2970.59 | 2975.19 | 2937.51 | 2946.14 | 315321.0 |
| 2012-11-13 | YM | Futures | 12476.6 | 12552.8 | 12385.8 | 12418.0 | 138310.0 |
| 2012-11-13 | CL | Futures | 154.22 | 154.78 | 152.38 | 153.7 | 211605.0 |
| 2012-11-13 | GC | Futures | 2308.5 | 2314.2 | 2293.2 | 2302.8 | 142502.0 |
| 2012-11-13 | ZN | Futures | 117.700265 | 117.933743 | 117.617861 | 117.823871 | 821265.0 |
| 2012-11-13 | A6 | Futures | 0.94489 | 0.9468 | 0.94216 | 0.94607 | 111913.0 |
| 2012-11-13 | AD | Futures | 1.00318 | 1.00389 | 0.99937 | 1.00158 | 64906.0 |
| 2012-11-13 | B | Futures | 99.62 | 99.73 | 98.4 | 99.12 | 172382.0 |
| 2012-11-13 | B6 | Futures | 1.658 | 1.662 | 1.656 | 1.6578 | 95938.0 |
| 2012-11-13 | BFX | Futures | 2827.7 | 2852.6 | 2823.8 | 2851.8 | 739.0 |
| 2012-11-13 | BR | Futures | 0.23469 | 0.23471 | 0.23357 | 0.23376 | 160.0 |
| 2012-11-13 | BZ | Futures | 102.6 | 102.71 | 101.58 | 102.21 | 457.0 |
| 2012-11-13 | C | Futures | 1559.0 | 1582.0 | 1557.0 | 1574.0 | 2425.0 |
| 2012-11-13 | CC | Futures | 1787.0 | 1809.0 | 1777.0 | 1801.0 | 14057.0 |
| 2012-11-13 | CSC | Futures | 3.971 | 3.981 | 3.971 | 3.977 | 8.0 |
| 2012-11-13 | CT | Futures | 91.14 | 91.98 | 90.86 | 91.37 | 16231.0 |
| 2012-11-13 | DC | Futures | 29.31 | 29.75 | 29.14 | 29.58 | 570.0 |
| 2012-11-13 | DX | Futures | 78.642 | 78.767 | 78.491 | 78.593 | 20689.0 |
| 2012-11-13 | E1 | Futures | 1.35793 | 1.36051 | 1.35369 | 1.35935 | 23864.0 |
| 2012-11-13 | E6 | Futures | 1.49694 | 1.49941 | 1.49141 | 1.49659 | 309295.0 |
| 2012-11-13 | E7 | Futures | 1.488 | 1.4904 | 1.4825 | 1.4876 | 4003.0 |
| 2012-11-13 | ED | Futures | 95.2396 | 95.2396 | 95.2301 | 95.2396 | 92497.0 |
| 2012-11-13 | ER | Futures | 97.886 | 97.891 | 97.881 | 97.891 | 51059.0 |
| 2012-11-13 | EW | Futures | 986.7 | 991.3 | 977.9 | 982.0 | 19167.0 |
| 2012-11-13 | FBTP | Futures | 72.03 | 72.47 | 71.74 | 72.36 | 21884.0 |
| 2012-11-13 | FBTS | Futures | 89.667 | 89.868 | 89.608 | 89.851 | 2087.0 |
| 2012-11-13 | FCE | Futures | 2556.4 | 2585.1 | 2538.3 | 2582.1 | 107114.0 |
| 2012-11-13 | FDAX | Futures | 7829.4 | 7874.3 | 7751.6 | 7861.1 | 158941.0 |
| 2012-11-13 | FESX | Futures | 1677.0 | 1698.1 | 1664.1 | 1696.7 | 1081389.0 |
| 2012-11-13 | FEU3 | Futures | 98.512 | 98.512 | 98.512 | 98.512 | 150.0 |
| 2012-11-13 | FGBL | Futures | 119.79 | 119.91 | 119.5 | 119.63 | 678428.0 |
| 2012-11-13 | FGBM | Futures | 117.13 | 117.17 | 116.98 | 117.04 | 340996.0 |
| 2012-11-13 | FGBS | Futures | 110.537 | 110.547 | 110.507 | 110.517 | 237015.0 |
| 2012-11-13 | FGBX | Futures | 127.73 | 128.03 | 127.14 | 127.31 | 10230.0 |
| 2012-11-13 | FOAT | Futures | 104.68 | 105.3 | 104.58 | 105.06 | 28604.0 |
| 2012-11-13 | FTDX | Futures | 754.7 | 758.0 | 753.3 | 757.5 | 83.0 |
| 2012-11-13 | FTI | Futures | 283.68 | 286.12 | 282.4 | 285.78 | 25418.0 |
| 2012-11-13 | FTUK | Futures | 4206.2 | 4224.8 | 4165.2 | 4220.5 | 104316.0 |
| 2012-11-13 | FVSA | Futures | 5036.3 | 5105.29 | 4875.32 | 4875.32 | 19246.0 |
| 2012-11-13 | FXXP | Futures | 193.3 | 195.1 | 192.7 | 195.1 | 5641.0 |
| 2012-11-13 | G | Futures | 99.65 | 99.84 | 99.41 | 99.63 | 172726.0 |
| 2012-11-13 | GF | Futures | 276.661 | 277.373 | 275.001 | 277.326 | 2038.0 |
| 2012-11-13 | GSCI | Futures | 1018.43 | 1025.04 | 1015.77 | 1020.2 | 2350.0 |
| 2012-11-13 | HE | Futures | 100.185 | 101.117 | 99.687 | 100.06 | 30824.0 |
| 2012-11-13 | HG | Futures | 4.4586 | 4.4959 | 4.3969 | 4.4605 | 55253.0 |
| 2012-11-13 | HH | Futures | 43.503 | 43.503 | 43.503 | 43.503 | 958.0 |
| 2012-11-13 | HO | Futures | 2.4288 | 2.4305 | 2.387 | 2.3998 | 55235.0 |
| 2012-11-13 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-11-13 | J1 | Futures | 0.0157416 | 0.0158117 | 0.0157253 | 0.0157729 | 84336.0 |
> showing 50 of 100 rows — these rows as CSV