PREVIEW / futures_daily / 2012-12-04
file: by_date/futures_daily/2012/2012-12-04.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-12-04 | ES | Futures | 1431.0 | 1436.86 | 1426.42 | 1430.5 | 1619569.0 |
| 2012-12-04 | NQ | Futures | 3069.54 | 3078.75 | 3049.41 | 3065.8 | 259040.0 |
| 2012-12-04 | YM | Futures | 12635.8 | 12702.2 | 12610.4 | 12629.0 | 116192.0 |
| 2012-12-04 | CL | Futures | 159.23 | 159.68 | 156.8 | 158.46 | 206265.0 |
| 2012-12-04 | GC | Futures | 2289.1 | 2291.0 | 2255.6 | 2259.9 | 197018.0 |
| 2012-12-04 | ZN | Futures | 117.810137 | 117.920009 | 117.672797 | 117.851339 | 79454.0 |
| 2012-12-04 | A6 | Futures | 0.94634 | 0.95189 | 0.94489 | 0.9508 | 118530.0 |
| 2012-12-04 | AD | Futures | 1.0084 | 1.01202 | 1.008 | 1.01061 | 79156.0 |
| 2012-12-04 | B | Futures | 102.61 | 102.61 | 101.04 | 101.58 | 129734.0 |
| 2012-12-04 | B6 | Futures | 1.681 | 1.6846 | 1.6799 | 1.682 | 96638.0 |
| 2012-12-04 | BFX | Futures | 2945.8 | 2954.3 | 2939.7 | 2950.9 | 124.0 |
| 2012-12-04 | BR | Futures | 0.22985 | 0.22985 | 0.22865 | 0.22933 | 89.0 |
| 2012-12-04 | BZ | Futures | 105.38 | 105.61 | 104.15 | 104.64 | 501.0 |
| 2012-12-04 | C | Futures | 1620.0 | 1640.0 | 1606.0 | 1614.0 | 5656.0 |
| 2012-12-04 | CC | Futures | 1894.0 | 1900.0 | 1834.0 | 1844.0 | 18808.0 |
| 2012-12-04 | CSC | Futures | 3.948 | 3.959 | 3.933 | 3.935 | 11.0 |
| 2012-12-04 | CT | Futures | 93.05 | 93.05 | 91.27 | 91.76 | 13058.0 |
| 2012-12-04 | DC | Futures | 29.42 | 29.48 | 29.15 | 29.16 | 83.0 |
| 2012-12-04 | DX | Futures | 77.378 | 77.411 | 77.092 | 77.134 | 21326.0 |
| 2012-12-04 | E1 | Futures | 1.3914 | 1.39256 | 1.38522 | 1.39024 | 30449.0 |
| 2012-12-04 | E6 | Futures | 1.5378 | 1.54381 | 1.53639 | 1.54275 | 253280.0 |
| 2012-12-04 | E7 | Futures | 1.5285 | 1.5346 | 1.5273 | 1.5335 | 2733.0 |
| 2012-12-04 | ED | Futures | 95.2325 | 95.2349 | 95.2301 | 95.2325 | 117095.0 |
| 2012-12-04 | ER | Futures | 97.876 | 97.886 | 97.876 | 97.881 | 43705.0 |
| 2012-12-04 | EW | Futures | 1014.4 | 1019.2 | 1011.0 | 1016.2 | 22216.0 |
| 2012-12-04 | FBTP | Futures | 75.54 | 75.8 | 75.39 | 75.59 | 48217.0 |
| 2012-12-04 | FBTS | Futures | 90.706 | 90.798 | 90.697 | 90.739 | 9811.0 |
| 2012-12-04 | FCE | Futures | 2684.4 | 2709.6 | 2681.7 | 2696.1 | 83017.0 |
| 2012-12-04 | FDAX | Futures | 8127.3 | 8181.6 | 8121.9 | 8138.3 | 111999.0 |
| 2012-12-04 | FESX | Futures | 1753.2 | 1770.9 | 1752.5 | 1760.0 | 702837.0 |
| 2012-12-04 | FGBL | Futures | 119.08 | 119.34 | 118.95 | 119.3 | 1249618.0 |
| 2012-12-04 | FGBM | Futures | 116.72 | 116.88 | 116.69 | 116.84 | 975835.0 |
| 2012-12-04 | FGBS | Futures | 110.407 | 110.442 | 110.407 | 110.432 | 738023.0 |
| 2012-12-04 | FGBX | Futures | 125.51 | 126.23 | 124.96 | 126.16 | 51424.0 |
| 2012-12-04 | FOAT | Futures | 105.49 | 105.75 | 105.43 | 105.72 | 61396.0 |
| 2012-12-04 | FTDX | Futures | 791.0 | 791.0 | 783.4 | 784.8 | 69.0 |
| 2012-12-04 | FTI | Futures | 288.65 | 291.14 | 288.65 | 289.51 | 28566.0 |
| 2012-12-04 | FTUK | Futures | 4284.9 | 4317.4 | 4283.4 | 4292.5 | 104484.0 |
| 2012-12-04 | FVSA | Futures | 4081.93 | 4127.92 | 4024.44 | 4081.93 | 4200.0 |
| 2012-12-04 | FXXP | Futures | 199.5 | 200.2 | 199.0 | 199.1 | 3382.0 |
| 2012-12-04 | G | Futures | 98.77 | 98.91 | 98.51 | 98.89 | 124250.0 |
| 2012-12-04 | GF | Futures | 276.424 | 276.804 | 275.476 | 276.235 | 1878.0 |
| 2012-12-04 | GSCI | Futures | 1041.82 | 1041.82 | 1038.11 | 1039.08 | 205.0 |
| 2012-12-04 | HE | Futures | 98.322 | 98.81 | 97.748 | 98.15 | 22082.0 |
| 2012-12-04 | HG | Futures | 4.6917 | 4.7238 | 4.666 | 4.6942 | 44986.0 |
| 2012-12-04 | HH | Futures | 41.549 | 41.549 | 41.549 | 41.549 | 3255.0 |
| 2012-12-04 | HO | Futures | 2.4639 | 2.4667 | 2.4255 | 2.4286 | 18388.0 |
| 2012-12-04 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-12-04 | J1 | Futures | 0.0152358 | 0.0153222 | 0.0152295 | 0.0152996 | 94475.0 |
| 2012-12-04 | J7 | Futures | 0.015171 | 0.015261 | 0.01517 | 0.015235 | 825.0 |
> showing 50 of 99 rows — these rows as CSV