PREVIEW / futures_daily / 2012-12-14
file: by_date/futures_daily/2012/2012-12-14.parquet size: 9 KB rows: 101
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-14 | ES | Futures | 1443.22 | 1452.17 | 1438.36 | 1441.94 | 1689033.0 |
| 2012-12-14 | NQ | Futures | 3051.13 | 3066.13 | 3016.82 | 3025.76 | 252883.0 |
| 2012-12-14 | YM | Futures | 12837.0 | 12898.7 | 12800.7 | 12833.0 | 100301.0 |
| 2012-12-14 | CL | Futures | 153.79 | 155.26 | 153.72 | 154.86 | 147776.0 |
| 2012-12-14 | GC | Futures | 2264.9 | 2268.0 | 2257.5 | 2261.5 | 85242.0 |
| 2012-12-14 | ZN | Futures | 117.010674 | 117.217407 | 116.900417 | 117.134714 | 856378.0 |
| 2012-12-14 | A6 | Futures | 0.95646 | 0.9614 | 0.95518 | 0.95994 | 133637.0 |
| 2012-12-14 | AD | Futures | 1.01613 | 1.01773 | 1.01422 | 1.01442 | 76674.0 |
| 2012-12-14 | B | Futures | 99.42 | 101.08 | 99.36 | 100.88 | 169624.0 |
| 2012-12-14 | B6 | Futures | 1.6836 | 1.6903 | 1.6824 | 1.6891 | 100889.0 |
| 2012-12-14 | BFX | Futures | 2964.5 | 2967.4 | 2961.9 | 2967.4 | 101.0 |
| 2012-12-14 | BR | Futures | 0.23375 | 0.23375 | 0.23277 | 0.23311 | 26.0 |
| 2012-12-14 | BZ | Futures | 102.44 | 104.04 | 102.44 | 103.92 | 281.0 |
| 2012-12-14 | C | Futures | 1640.0 | 1661.0 | 1636.0 | 1656.0 | 6903.0 |
| 2012-12-14 | CB | Futures | 87.313 | 87.313 | 87.313 | 87.313 | 5.0 |
| 2012-12-14 | CC | Futures | 1827.0 | 1846.0 | 1820.0 | 1837.0 | 7469.0 |
| 2012-12-14 | CSC | Futures | 3.892 | 3.959 | 3.879 | 3.959 | 52.0 |
| 2012-12-14 | CT | Futures | 93.76 | 94.59 | 93.63 | 94.5 | 8734.0 |
| 2012-12-14 | DC | Futures | 28.77 | 29.56 | 28.74 | 29.5 | 199.0 |
| 2012-12-14 | DX | Futures | 77.198 | 77.208 | 76.74 | 76.822 | 30043.0 |
| 2012-12-14 | E1 | Futures | 1.39526 | 1.40633 | 1.3941 | 1.40453 | 37879.0 |
| 2012-12-14 | E6 | Futures | 1.54349 | 1.55516 | 1.54243 | 1.5534 | 254562.0 |
| 2012-12-14 | E7 | Futures | 1.5331 | 1.5445 | 1.532 | 1.5428 | 3599.0 |
| 2012-12-14 | EBM | Futures | 286.74 | 288.41 | 286.19 | 288.13 | 20923.0 |
| 2012-12-14 | ED | Futures | 95.239 | 95.2486 | 95.239 | 95.239 | 84911.0 |
| 2012-12-14 | ER | Futures | 97.866 | 97.876 | 97.857 | 97.866 | 59279.0 |
| 2012-12-14 | EW | Futures | 1021.8 | 1025.7 | 1017.8 | 1020.2 | 29437.0 |
| 2012-12-14 | FBTP | Futures | 74.42 | 74.87 | 74.35 | 74.65 | 14586.0 |
| 2012-12-14 | FBTS | Futures | 90.519 | 90.544 | 90.366 | 90.494 | 2180.0 |
| 2012-12-14 | FCE | Futures | 2739.1 | 2744.7 | 2731.2 | 2738.3 | 15248.0 |
| 2012-12-14 | FDAX | Futures | 8317.4 | 8350.3 | 8294.4 | 8320.7 | 105930.0 |
| 2012-12-14 | FESX | Futures | 1781.8 | 1790.0 | 1780.4 | 1785.2 | 254477.0 |
| 2012-12-14 | FEU3 | Futures | 98.473 | 98.473 | 98.468 | 98.473 | 134.0 |
| 2012-12-14 | FGBL | Futures | 119.83 | 120.05 | 119.63 | 119.79 | 404164.0 |
| 2012-12-14 | FGBM | Futures | 117.39 | 117.48 | 117.25 | 117.34 | 286856.0 |
| 2012-12-14 | FGBS | Futures | 110.597 | 110.622 | 110.552 | 110.572 | 194313.0 |
| 2012-12-14 | FGBX | Futures | 126.68 | 127.25 | 126.12 | 126.85 | 5051.0 |
| 2012-12-14 | FOAT | Futures | 106.18 | 106.4 | 105.98 | 106.24 | 25505.0 |
| 2012-12-14 | FTDX | Futures | 785.3 | 785.3 | 785.3 | 785.3 | 5.0 |
| 2012-12-14 | FTI | Futures | 295.39 | 296.81 | 295.35 | 295.99 | 833.0 |
| 2012-12-14 | FTUK | Futures | 4328.4 | 4343.8 | 4317.7 | 4328.8 | 43380.0 |
| 2012-12-14 | FVSA | Futures | 4040.71 | 4132.08 | 4040.71 | 4050.86 | 9179.0 |
| 2012-12-14 | FXXP | Futures | 201.0 | 201.0 | 200.6 | 200.6 | 549.0 |
| 2012-12-14 | G | Futures | 98.26 | 98.49 | 98.24 | 98.39 | 92368.0 |
| 2012-12-14 | GF | Futures | 289.517 | 291.225 | 288.948 | 290.466 | 2852.0 |
| 2012-12-14 | GSCI | Futures | 1021.82 | 1027.05 | 1020.12 | 1026.16 | 292.0 |
| 2012-12-14 | HE | Futures | 98.638 | 98.982 | 97.892 | 98.007 | 13310.0 |
| 2012-12-14 | HG | Futures | 4.7135 | 4.7443 | 4.7052 | 4.7296 | 32889.0 |
| 2012-12-14 | HH | Futures | 38.907 | 38.907 | 38.907 | 38.907 | 2811.0 |
| 2012-12-14 | HO | Futures | 2.3809 | 2.3992 | 2.3768 | 2.3914 | 17610.0 |
> showing 50 of 101 rows — these rows as CSV