PREVIEW / futures_daily / 2014-02-18
file: by_date/futures_daily/2014/2014-02-18.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-18 | ES | Futures | 1890.07 | 1897.03 | 1888.01 | 1894.2 | 1210508.0 |
| 2014-02-18 | NQ | Futures | 4207.56 | 4236.02 | 4200.67 | 4224.81 | 220169.0 |
| 2014-02-18 | YM | Futures | 16094.6 | 16163.5 | 16051.6 | 16081.6 | 130079.0 |
| 2014-02-18 | CL | Futures | 178.16 | 182.68 | 178.04 | 181.68 | 190438.0 |
| 2014-02-18 | GC | Futures | 1738.2 | 1756.4 | 1729.9 | 1745.8 | 184496.0 |
| 2014-02-18 | ZN | Futures | 115.063693 | 115.435697 | 114.934922 | 115.335542 | 956454.0 |
| 2014-02-18 | A6 | Futures | 0.86083 | 0.86388 | 0.85625 | 0.8593 | 102203.0 |
| 2014-02-18 | AD | Futures | 0.9218 | 0.92504 | 0.92139 | 0.92473 | 51389.0 |
| 2014-02-18 | B | Futures | 111.99 | 113.67 | 111.76 | 113.42 | 150349.0 |
| 2014-02-18 | B6 | Futures | 1.7598 | 1.7671 | 1.7493 | 1.7523 | 193305.0 |
| 2014-02-18 | BFX | Futures | 3613.1 | 3625.1 | 3607.9 | 3612.6 | 1047.0 |
| 2014-02-18 | BR | Futures | 0.21614 | 0.21679 | 0.21513 | 0.21601 | 464.0 |
| 2014-02-18 | BZ | Futures | 114.41 | 115.86 | 113.83 | 115.72 | 5560.0 |
| 2014-02-18 | C | Futures | 1966.0 | 1973.0 | 1958.0 | 1961.0 | 2255.0 |
| 2014-02-18 | CB | Futures | 88.076 | 88.321 | 86.359 | 87.831 | 19.0 |
| 2014-02-18 | CC | Futures | 2198.0 | 2216.0 | 2184.0 | 2197.0 | 8385.0 |
| 2014-02-18 | CNH | Futures | 6.9494 | 6.9541 | 6.9494 | 6.9527 | 32.0 |
| 2014-02-18 | CSC | Futures | 4.278 | 4.28 | 4.278 | 4.28 | 3.0 |
| 2014-02-18 | CT | Futures | 100.34 | 100.61 | 99.54 | 100.24 | 9584.0 |
| 2014-02-18 | DC | Futures | 32.86 | 33.5 | 32.86 | 33.28 | 459.0 |
| 2014-02-18 | DX | Futures | 76.267 | 76.329 | 76.077 | 76.12 | 17195.0 |
| 2014-02-18 | E1 | Futures | 1.43981 | 1.44777 | 1.43789 | 1.44533 | 37824.0 |
| 2014-02-18 | E6 | Futures | 1.61746 | 1.62561 | 1.61616 | 1.62395 | 238140.0 |
| 2014-02-18 | E7 | Futures | 1.6071 | 1.615 | 1.6057 | 1.6134 | 4523.0 |
| 2014-02-18 | EBM | Futures | 276.35 | 277.39 | 276.0 | 277.04 | 15480.0 |
| 2014-02-18 | ED | Futures | 95.3853 | 95.3853 | 95.3829 | 95.3853 | 70988.0 |
| 2014-02-18 | ER | Futures | 97.881 | 97.886 | 97.871 | 97.876 | 68468.0 |
| 2014-02-18 | EW | Futures | 1374.0 | 1383.6 | 1371.1 | 1382.4 | 13494.0 |
| 2014-02-18 | FBTP | Futures | 85.25 | 85.73 | 85.08 | 85.48 | 48988.0 |
| 2014-02-18 | FBTS | Futures | 96.59 | 96.739 | 96.538 | 96.652 | 9335.0 |
| 2014-02-18 | FCE | Futures | 3363.4 | 3368.4 | 3335.9 | 3357.2 | 86554.0 |
| 2014-02-18 | FDAX | Futures | 10731.3 | 10755.7 | 10663.7 | 10725.8 | 92996.0 |
| 2014-02-18 | FESX | Futures | 2199.2 | 2201.3 | 2178.1 | 2195.7 | 753314.0 |
| 2014-02-18 | FEU3 | Futures | 98.497 | 98.497 | 98.492 | 98.492 | 5.0 |
| 2014-02-18 | FGBL | Futures | 122.11 | 122.5 | 122.05 | 122.3 | 772162.0 |
| 2014-02-18 | FGBM | Futures | 119.2 | 119.4 | 119.17 | 119.32 | 423207.0 |
| 2014-02-18 | FGBS | Futures | 110.628 | 110.653 | 110.618 | 110.633 | 234005.0 |
| 2014-02-18 | FGBX | Futures | 123.59 | 124.27 | 123.32 | 123.67 | 31792.0 |
| 2014-02-18 | FMWO | Futures | 5442.2 | 5461.0 | 5432.1 | 5461.0 | 51.0 |
| 2014-02-18 | FOAT | Futures | 110.49 | 110.88 | 110.44 | 110.73 | 51045.0 |
| 2014-02-18 | FTDX | Futures | 1197.2 | 1197.2 | 1191.1 | 1192.0 | 122.0 |
| 2014-02-18 | FTI | Futures | 343.52 | 343.86 | 341.51 | 343.09 | 22270.0 |
| 2014-02-18 | FTUK | Futures | 5066.5 | 5123.7 | 5052.1 | 5119.5 | 111221.0 |
| 2014-02-18 | FVSA | Futures | 1781.82 | 1851.5 | 1776.84 | 1776.84 | 11394.0 |
| 2014-02-18 | FXXP | Futures | 246.0 | 246.0 | 243.5 | 245.3 | 6047.0 |
| 2014-02-18 | G | Futures | 92.84 | 93.35 | 92.8 | 93.18 | 158446.0 |
| 2014-02-18 | GF | Futures | 275.214 | 277.23 | 275.053 | 276.826 | 2900.0 |
| 2014-02-18 | GSCI | Futures | 1060.09 | 1068.54 | 1059.35 | 1068.13 | 1058.0 |
| 2014-02-18 | HE | Futures | 116.545 | 117.843 | 116.545 | 117.601 | 14297.0 |
| 2014-02-18 | HG | Futures | 4.1168 | 4.1985 | 4.1162 | 4.1529 | 18899.0 |
> showing 50 of 106 rows — these rows as CSV