PREVIEW / futures_daily / 2012-10-24
file: by_date/futures_daily/2012/2012-10-24.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-10-24 | ES | Futures | 1431.51 | 1440.16 | 1426.68 | 1430.24 | 1756752.0 |
| 2012-10-24 | NQ | Futures | 3060.63 | 3084.21 | 3044.81 | 3049.7 | 261593.0 |
| 2012-10-24 | YM | Futures | 12731.5 | 12788.1 | 12693.4 | 12714.9 | 124742.0 |
| 2012-10-24 | CL | Futures | 156.08 | 157.64 | 153.08 | 154.51 | 298160.0 |
| 2012-10-24 | GC | Futures | 2281.7 | 2290.0 | 2268.0 | 2271.9 | 140583.0 |
| 2012-10-24 | ZN | Futures | 116.381802 | 116.464206 | 116.162059 | 116.354334 | 942403.0 |
| 2012-10-24 | A6 | Futures | 0.92908 | 0.93826 | 0.92817 | 0.93607 | 137935.0 |
| 2012-10-24 | AD | Futures | 1.01011 | 1.01372 | 1.0066 | 1.0085 | 74604.0 |
| 2012-10-24 | B | Futures | 99.26 | 100.2 | 97.87 | 98.84 | 233367.0 |
| 2012-10-24 | B6 | Futures | 1.666 | 1.6757 | 1.6639 | 1.6747 | 110595.0 |
| 2012-10-24 | BFX | Futures | 2818.5 | 2831.1 | 2818.5 | 2831.1 | 14.0 |
| 2012-10-24 | BR | Futures | 0.23828 | 0.23847 | 0.23828 | 0.2383 | 44.0 |
| 2012-10-24 | BZ | Futures | 103.32 | 103.44 | 101.62 | 102.56 | 503.0 |
| 2012-10-24 | C | Futures | 1639.0 | 1652.0 | 1578.0 | 1584.0 | 6073.0 |
| 2012-10-24 | CB | Futures | 91.525 | 92.06 | 91.123 | 92.06 | 3.0 |
| 2012-10-24 | CC | Futures | 1880.0 | 1882.0 | 1802.0 | 1809.0 | 20119.0 |
| 2012-10-24 | CSC | Futures | 4.141 | 4.183 | 4.141 | 4.183 | 34.0 |
| 2012-10-24 | CT | Futures | 95.88 | 95.93 | 92.99 | 93.77 | 19458.0 |
| 2012-10-24 | DC | Futures | 30.91 | 31.12 | 30.7 | 30.99 | 290.0 |
| 2012-10-24 | DX | Futures | 77.523 | 77.726 | 77.402 | 77.503 | 18543.0 |
| 2012-10-24 | E1 | Futures | 1.38084 | 1.3829 | 1.37583 | 1.38136 | 27024.0 |
| 2012-10-24 | E6 | Futures | 1.53027 | 1.53121 | 1.52214 | 1.5285 | 228980.0 |
| 2012-10-24 | E7 | Futures | 1.5209 | 1.522 | 1.5132 | 1.5194 | 3387.0 |
| 2012-10-24 | ED | Futures | 95.2396 | 95.2492 | 95.2396 | 95.2444 | 136766.0 |
| 2012-10-24 | ER | Futures | 97.862 | 97.871 | 97.857 | 97.866 | 48323.0 |
| 2012-10-24 | EW | Futures | 995.3 | 1001.5 | 990.5 | 993.1 | 14114.0 |
| 2012-10-24 | FBTP | Futures | 72.82 | 72.93 | 72.49 | 72.9 | 18475.0 |
| 2012-10-24 | FBTS | Futures | 89.734 | 89.742 | 89.55 | 89.717 | 2503.0 |
| 2012-10-24 | FCE | Futures | 2576.8 | 2580.9 | 2544.1 | 2574.6 | 94040.0 |
| 2012-10-24 | FDAX | Futures | 7904.9 | 7907.7 | 7800.3 | 7883.0 | 137625.0 |
| 2012-10-24 | FESX | Futures | 1693.3 | 1698.8 | 1672.2 | 1694.0 | 1066208.0 |
| 2012-10-24 | FEU3 | Futures | 98.487 | 98.487 | 98.487 | 98.487 | 3.0 |
| 2012-10-24 | FGBL | Futures | 117.16 | 117.55 | 117.11 | 117.4 | 838395.0 |
| 2012-10-24 | FGBM | Futures | 115.71 | 115.97 | 115.69 | 115.9 | 459784.0 |
| 2012-10-24 | FGBS | Futures | 110.208 | 110.278 | 110.193 | 110.253 | 379077.0 |
| 2012-10-24 | FGBX | Futures | 122.74 | 123.35 | 122.55 | 122.97 | 7028.0 |
| 2012-10-24 | FOAT | Futures | 103.64 | 103.75 | 103.41 | 103.56 | 24082.0 |
| 2012-10-24 | FTDX | Futures | 746.7 | 752.3 | 740.6 | 750.9 | 170.0 |
| 2012-10-24 | FTI | Futures | 280.68 | 281.62 | 278.23 | 280.98 | 30360.0 |
| 2012-10-24 | FTUK | Futures | 4226.7 | 4245.7 | 4210.2 | 4241.7 | 76430.0 |
| 2012-10-24 | FVSA | Futures | 5319.47 | 5398.52 | 5217.82 | 5330.76 | 7240.0 |
| 2012-10-24 | FXXP | Futures | 193.6 | 194.5 | 192.6 | 194.3 | 2387.0 |
| 2012-10-24 | G | Futures | 98.46 | 98.66 | 98.17 | 98.33 | 153879.0 |
| 2012-10-24 | GF | Futures | 282.755 | 283.668 | 282.227 | 282.611 | 1090.0 |
| 2012-10-24 | GSCI | Futures | 1036.04 | 1036.85 | 1023.99 | 1028.84 | 400.0 |
| 2012-10-24 | HE | Futures | 96.891 | 97.947 | 96.487 | 97.264 | 17876.0 |
| 2012-10-24 | HG | Futures | 4.5903 | 4.6231 | 4.5588 | 4.5852 | 43934.0 |
| 2012-10-24 | HH | Futures | 43.992 | 43.992 | 43.992 | 43.992 | 2401.0 |
| 2012-10-24 | HO | Futures | 2.4583 | 2.479 | 2.4345 | 2.453 | 59538.0 |
| 2012-10-24 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 30.0 |
> showing 50 of 100 rows — these rows as CSV