PREVIEW / futures_daily / 2012-11-26
file: by_date/futures_daily/2012/2012-11-26.parquet size: 9 KB rows: 99
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-26 | ES | Futures | 1428.21 | 1429.99 | 1419.81 | 1428.21 | 1220715.0 |
| 2012-11-26 | NQ | Futures | 3029.56 | 3049.98 | 3018.05 | 3044.23 | 203339.0 |
| 2012-11-26 | YM | Futures | 12644.6 | 12646.5 | 12567.4 | 12631.9 | 90154.0 |
| 2012-11-26 | CL | Futures | 157.94 | 158.09 | 156.26 | 157.1 | 156593.0 |
| 2012-11-26 | GC | Futures | 2338.4 | 2338.4 | 2329.8 | 2334.8 | 69219.0 |
| 2012-11-26 | ZN | Futures | 117.178374 | 117.549191 | 117.150906 | 117.384383 | 990568.0 |
| 2012-11-26 | A6 | Futures | 0.94871 | 0.94961 | 0.94698 | 0.9488 | 87718.0 |
| 2012-11-26 | AD | Futures | 1.01091 | 1.01161 | 1.0072 | 1.00961 | 67774.0 |
| 2012-11-26 | B | Futures | 102.85 | 103.1 | 102.08 | 102.66 | 61785.0 |
| 2012-11-26 | B6 | Futures | 1.6737 | 1.6751 | 1.6705 | 1.6729 | 76491.0 |
| 2012-11-26 | BFX | Futures | 2903.5 | 2903.5 | 2893.2 | 2897.3 | 22.0 |
| 2012-11-26 | BR | Futures | 0.23274 | 0.23294 | 0.23257 | 0.23257 | 161.0 |
| 2012-11-26 | BZ | Futures | 106.06 | 106.17 | 105.23 | 105.76 | 404.0 |
| 2012-11-26 | C | Futures | 1623.0 | 1627.0 | 1587.0 | 1608.0 | 1889.0 |
| 2012-11-26 | CB | Futures | 89.789 | 89.919 | 89.658 | 89.919 | 12.0 |
| 2012-11-26 | CC | Futures | 1900.0 | 1900.0 | 1845.0 | 1870.0 | 13670.0 |
| 2012-11-26 | CSC | Futures | 3.931 | 3.931 | 3.92 | 3.929 | 14.0 |
| 2012-11-26 | CT | Futures | 90.11 | 91.85 | 89.95 | 91.39 | 15723.0 |
| 2012-11-26 | DC | Futures | 29.32 | 29.4 | 29.04 | 29.2 | 76.0 |
| 2012-11-26 | DX | Futures | 77.712 | 77.818 | 77.663 | 77.747 | 13152.0 |
| 2012-11-26 | E1 | Futures | 1.38702 | 1.38818 | 1.38445 | 1.38638 | 33476.0 |
| 2012-11-26 | E6 | Futures | 1.52779 | 1.52932 | 1.5245 | 1.52673 | 180265.0 |
| 2012-11-26 | E7 | Futures | 1.5192 | 1.5202 | 1.5155 | 1.5176 | 2071.0 |
| 2012-11-26 | ED | Futures | 95.2229 | 95.2277 | 95.2205 | 95.2229 | 75786.0 |
| 2012-11-26 | ER | Futures | 97.881 | 97.886 | 97.876 | 97.881 | 48172.0 |
| 2012-11-26 | EW | Futures | 1005.8 | 1008.5 | 1000.5 | 1006.6 | 18723.0 |
| 2012-11-26 | FBTP | Futures | 73.65 | 73.68 | 73.44 | 73.66 | 9682.0 |
| 2012-11-26 | FBTS | Futures | 90.337 | 90.53 | 90.32 | 90.463 | 1672.0 |
| 2012-11-26 | FCE | Futures | 2649.6 | 2654.2 | 2630.4 | 2634.9 | 75358.0 |
| 2012-11-26 | FDAX | Futures | 7988.8 | 8014.5 | 7969.0 | 7989.9 | 87595.0 |
| 2012-11-26 | FESX | Futures | 1734.8 | 1738.2 | 1726.0 | 1729.4 | 566393.0 |
| 2012-11-26 | FGBL | Futures | 118.87 | 119.1 | 118.8 | 119.04 | 446478.0 |
| 2012-11-26 | FGBM | Futures | 116.78 | 116.87 | 116.75 | 116.83 | 250052.0 |
| 2012-11-26 | FGBS | Futures | 110.487 | 110.507 | 110.472 | 110.482 | 145222.0 |
| 2012-11-26 | FGBX | Futures | 124.54 | 125.42 | 124.41 | 125.3 | 9732.0 |
| 2012-11-26 | FOAT | Futures | 104.53 | 104.69 | 104.44 | 104.67 | 28954.0 |
| 2012-11-26 | FTDX | Futures | 781.5 | 781.5 | 775.4 | 781.1 | 73.0 |
| 2012-11-26 | FTI | Futures | 283.85 | 284.97 | 283.12 | 283.68 | 20906.0 |
| 2012-11-26 | FTUK | Futures | 4257.0 | 4257.4 | 4223.4 | 4228.9 | 63281.0 |
| 2012-11-26 | FVSA | Futures | 4357.89 | 4495.87 | 4334.9 | 4403.89 | 4456.0 |
| 2012-11-26 | FXXP | Futures | 197.1 | 197.1 | 195.8 | 196.0 | 2865.0 |
| 2012-11-26 | G | Futures | 98.62 | 98.8 | 98.55 | 98.6 | 164535.0 |
| 2012-11-26 | GF | Futures | 280.457 | 280.789 | 278.891 | 279.603 | 1988.0 |
| 2012-11-26 | GSCI | Futures | 1046.02 | 1048.36 | 1041.9 | 1043.92 | 333.0 |
| 2012-11-26 | HE | Futures | 100.331 | 101.105 | 99.613 | 99.814 | 16252.0 |
| 2012-11-26 | HG | Futures | 4.5491 | 4.5633 | 4.5177 | 4.5568 | 28880.0 |
| 2012-11-26 | HH | Futures | 45.411 | 45.411 | 45.411 | 45.411 | 299.0 |
| 2012-11-26 | HO | Futures | 2.4813 | 2.4825 | 2.4574 | 2.4632 | 13587.0 |
| 2012-11-26 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 10.0 |
| 2012-11-26 | J1 | Futures | 0.0151995 | 0.0152846 | 0.0151544 | 0.0152395 | 98561.0 |
> showing 50 of 99 rows — these rows as CSV