PREVIEW / futures_daily / 2015-08-03
file: by_date/futures_daily/2015/2015-08-03.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-03 | ES | Futures | 2224.29 | 2228.27 | 2204.42 | 2216.08 | 1512106.0 |
| 2015-08-03 | NQ | Futures | 5351.03 | 5369.71 | 5301.12 | 5339.06 | 251564.0 |
| 2015-08-03 | YM | Futures | 18096.1 | 18135.1 | 17885.6 | 17984.2 | 142066.0 |
| 2015-08-03 | CL | Futures | 77.8 | 77.94 | 74.85 | 75.0 | 371085.0 |
| 2015-08-03 | GC | Futures | 1413.7 | 1417.4 | 1400.7 | 1406.3 | 105923.0 |
| 2015-08-03 | ZN | Futures | 121.688828 | 122.01671 | 121.480176 | 121.927288 | 974279.0 |
| 2015-08-03 | A6 | Futures | 0.72207 | 0.72296 | 0.71751 | 0.71841 | 60484.0 |
| 2015-08-03 | AD | Futures | 0.7813 | 0.7815 | 0.77577 | 0.77741 | 49700.0 |
| 2015-08-03 | ALI | Futures | 2195.64 | 2195.64 | 2195.64 | 2195.64 | 0.0 |
| 2015-08-03 | B | Futures | 48.64 | 48.7 | 46.33 | 46.46 | 180655.0 |
| 2015-08-03 | B6 | Futures | 1.6443 | 1.6462 | 1.6377 | 1.6396 | 73899.0 |
| 2015-08-03 | BFX | Futures | 4561.2 | 4602.9 | 4561.2 | 4593.3 | 4.0 |
| 2015-08-03 | BR | Futures | 0.17305 | 0.17305 | 0.17158 | 0.17182 | 2534.0 |
| 2015-08-03 | BZ | Futures | 48.25 | 48.46 | 46.31 | 46.41 | 21119.0 |
| 2015-08-03 | C | Futures | 2282.0 | 2286.0 | 2259.0 | 2262.0 | 7631.0 |
| 2015-08-03 | CB | Futures | 161.081 | 162.033 | 161.081 | 161.324 | 36.0 |
| 2015-08-03 | CC | Futures | 2355.0 | 2358.0 | 2324.0 | 2328.0 | 18165.0 |
| 2015-08-03 | CNH | Futures | 7.009 | 7.0092 | 7.0063 | 7.0063 | 18.0 |
| 2015-08-03 | CSC | Futures | 4.412 | 4.483 | 4.412 | 4.47 | 22.0 |
| 2015-08-03 | CT | Futures | 78.39 | 80.15 | 77.47 | 79.98 | 311.0 |
| 2015-08-03 | DC | Futures | 35.84 | 36.12 | 35.36 | 35.97 | 183.0 |
| 2015-08-03 | DX | Futures | 91.086 | 91.451 | 91.03 | 91.377 | 30071.0 |
| 2015-08-03 | E1 | Futures | 1.3145 | 1.31843 | 1.31031 | 1.31094 | 11685.0 |
| 2015-08-03 | E6 | Futures | 1.29073 | 1.2925 | 1.28604 | 1.28686 | 151855.0 |
| 2015-08-03 | E7 | Futures | 1.2828 | 1.2854 | 1.2789 | 1.2798 | 3028.0 |
| 2015-08-03 | EBM | Futures | 295.12 | 295.12 | 291.84 | 292.25 | 6635.0 |
| 2015-08-03 | ED | Futures | 95.6366 | 95.6414 | 95.6318 | 95.6366 | 111313.0 |
| 2015-08-03 | ER | Futures | 98.122 | 98.122 | 98.112 | 98.122 | 16342.0 |
| 2015-08-03 | EW | Futures | 1571.4 | 1575.4 | 1558.6 | 1566.6 | 15606.0 |
| 2015-08-03 | FBTP | Futures | 101.57 | 101.57 | 101.2 | 101.31 | 46046.0 |
| 2015-08-03 | FBTS | Futures | 100.088 | 100.115 | 100.07 | 100.106 | 8414.0 |
| 2015-08-03 | FCE | Futures | 4234.6 | 4275.4 | 4224.6 | 4270.0 | 69920.0 |
| 2015-08-03 | FDAX | Futures | 12481.2 | 12674.1 | 12433.1 | 12645.9 | 104964.0 |
| 2015-08-03 | FESX | Futures | 2657.6 | 2695.3 | 2654.6 | 2689.4 | 864227.0 |
| 2015-08-03 | FGBL | Futures | 137.75 | 138.24 | 137.48 | 137.91 | 344874.0 |
| 2015-08-03 | FGBM | Futures | 124.7 | 124.86 | 124.64 | 124.78 | 229653.0 |
| 2015-08-03 | FGBS | Futures | 111.218 | 111.253 | 111.213 | 111.243 | 130183.0 |
| 2015-08-03 | FGBX | Futures | 158.5 | 159.46 | 157.39 | 158.26 | 18477.0 |
| 2015-08-03 | FMWO | Futures | 5826.1 | 5837.2 | 5826.1 | 5834.7 | 184.0 |
| 2015-08-03 | FOAT | Futures | 125.98 | 126.46 | 125.89 | 126.14 | 48308.0 |
| 2015-08-03 | FTDX | Futures | 1676.7 | 1700.3 | 1669.2 | 1696.0 | 316.0 |
| 2015-08-03 | FTI | Futures | 424.91 | 430.66 | 424.74 | 429.62 | 23282.0 |
| 2015-08-03 | FTUK | Futures | 5266.2 | 5293.3 | 5231.7 | 5271.0 | 73611.0 |
| 2015-08-03 | FVSA | Futures | 1772.08 | 1776.47 | 1693.13 | 1697.52 | 8005.0 |
| 2015-08-03 | FXXP | Futures | 303.9 | 306.7 | 303.7 | 306.3 | 7219.0 |
| 2015-08-03 | G | Futures | 102.57 | 102.94 | 102.36 | 102.73 | 109151.0 |
| 2015-08-03 | GF | Futures | 360.441 | 364.691 | 360.441 | 363.586 | 3470.0 |
| 2015-08-03 | GSCI | Futures | 620.84 | 621.84 | 613.68 | 614.26 | 108.0 |
| 2015-08-03 | HE | Futures | 87.687 | 90.388 | 87.516 | 89.328 | 16244.0 |
| 2015-08-03 | HG | Futures | 2.9403 | 2.949 | 2.8972 | 2.9278 | 57518.0 |
> showing 50 of 105 rows — these rows as CSV