PREVIEW / futures_daily / 2019-01-15
file: by_date/futures_daily/2019/2019-01-15.parquet size: 10 KB rows: 114
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-15 | ES | Futures | 2794.91 | 2829.83 | 2793.29 | 2820.9 | 1532494.0 |
| 2019-01-15 | NQ | Futures | 7575.18 | 7744.21 | 7574.31 | 7730.03 | 492324.0 |
| 2019-01-15 | YM | Futures | 25174.2 | 25391.5 | 25129.9 | 25297.6 | 224202.0 |
| 2019-01-15 | CL | Futures | 53.12 | 54.68 | 52.97 | 54.48 | 220625.0 |
| 2019-01-15 | GC | Futures | 1628.4 | 1631.5 | 1621.0 | 1623.4 | 242065.0 |
| 2019-01-15 | ZN | Futures | 121.440361 | 121.689342 | 121.284748 | 121.409239 | 1555787.0 |
| 2019-01-15 | A6 | Futures | 0.74177 | 0.74507 | 0.74033 | 0.74177 | 105943.0 |
| 2019-01-15 | AD | Futures | 0.76339 | 0.76658 | 0.76268 | 0.76339 | 57152.0 |
| 2019-01-15 | B | Futures | 42.85 | 43.94 | 42.67 | 43.78 | 234362.0 |
| 2019-01-15 | B6 | Futures | 1.325 | 1.3303 | 1.3047 | 1.3217 | 171723.0 |
| 2019-01-15 | BR | Futures | 0.21532 | 0.21532 | 0.21357 | 0.21361 | 188.0 |
| 2019-01-15 | BTC | Futures | 5336.1 | 5358.0 | 5102.2 | 5168.0 | 3786.0 |
| 2019-01-15 | BZ | Futures | 42.42 | 43.56 | 42.32 | 43.41 | 29948.0 |
| 2019-01-15 | C | Futures | 1472.0 | 1489.0 | 1442.0 | 1459.0 | 11978.0 |
| 2019-01-15 | CB | Futures | 273.959 | 273.959 | 273.959 | 273.959 | 2.0 |
| 2019-01-15 | CC | Futures | 1615.0 | 1627.0 | 1556.0 | 1567.0 | 29905.0 |
| 2019-01-15 | CNH | Futures | 6.7749 | 6.8024 | 6.7605 | 6.7914 | 674.0 |
| 2019-01-15 | CSC | Futures | 2.775 | 2.791 | 2.767 | 2.777 | 102.0 |
| 2019-01-15 | CT | Futures | 79.54 | 80.02 | 78.7 | 78.82 | 12598.0 |
| 2019-01-15 | DC | Futures | 23.96 | 24.04 | 23.89 | 23.94 | 168.0 |
| 2019-01-15 | DX | Futures | 90.749 | 91.455 | 90.668 | 91.245 | 28672.0 |
| 2019-01-15 | E1 | Futures | 1.20546 | 1.20652 | 1.19512 | 1.19676 | 25382.0 |
| 2019-01-15 | E6 | Futures | 1.27365 | 1.27619 | 1.26414 | 1.2663 | 226599.0 |
| 2019-01-15 | E7 | Futures | 1.2675 | 1.2698 | 1.2581 | 1.2602 | 5178.0 |
| 2019-01-15 | EBM | Futures | 209.74 | 210.0 | 208.46 | 208.71 | 19460.0 |
| 2019-01-15 | ED | Futures | 95.0183 | 95.033 | 95.0086 | 95.0281 | 241684.0 |
| 2019-01-15 | ER | Futures | 98.401 | 98.406 | 98.396 | 98.401 | 71135.0 |
| 2019-01-15 | EW | Futures | 1868.6 | 1881.8 | 1865.7 | 1879.7 | 12955.0 |
| 2019-01-15 | FBON | Futures | 129.71 | 130.16 | 129.71 | 130.1 | 162.0 |
| 2019-01-15 | FBTP | Futures | 110.87 | 111.2 | 110.6 | 110.79 | 125441.0 |
| 2019-01-15 | FBTS | Futures | 104.887 | 105.067 | 104.887 | 104.973 | 46845.0 |
| 2019-01-15 | FCE | Futures | 4288.3 | 4312.5 | 4255.2 | 4284.3 | 170184.0 |
| 2019-01-15 | FDAX | Futures | 11423.3 | 11549.4 | 11356.6 | 11438.5 | 110781.0 |
| 2019-01-15 | FDXM | Futures | 11396.0 | 11520.8 | 11328.9 | 11410.7 | 49234.0 |
| 2019-01-15 | FESX | Futures | 2604.7 | 2630.4 | 2591.9 | 2611.6 | 1029771.0 |
| 2019-01-15 | FGBL | Futures | 156.52 | 156.86 | 156.29 | 156.78 | 706567.0 |
| 2019-01-15 | FGBM | Futures | 132.28 | 132.47 | 132.2 | 132.44 | 377153.0 |
| 2019-01-15 | FGBS | Futures | 112.729 | 112.789 | 112.723 | 112.784 | 266332.0 |
| 2019-01-15 | FGBX | Futures | 185.1 | 186.19 | 184.79 | 185.83 | 37998.0 |
| 2019-01-15 | FMWO | Futures | 6555.2 | 6598.3 | 6543.6 | 6573.9 | 2185.0 |
| 2019-01-15 | FOAT | Futures | 142.1 | 142.52 | 142.1 | 142.46 | 139913.0 |
| 2019-01-15 | FTDX | Futures | 2491.6 | 2497.1 | 2463.8 | 2484.2 | 200.0 |
| 2019-01-15 | FTI | Futures | 468.15 | 471.12 | 466.3 | 469.33 | 45710.0 |
| 2019-01-15 | FTUK | Futures | 6209.8 | 6266.7 | 6181.1 | 6228.4 | 85578.0 |
| 2019-01-15 | FVSA | Futures | 349.83 | 355.46 | 336.7 | 344.2 | 45004.0 |
| 2019-01-15 | FXXP | Futures | 305.2 | 306.3 | 303.3 | 304.7 | 33493.0 |
| 2019-01-15 | G | Futures | 116.44 | 116.9 | 116.32 | 116.8 | 170790.0 |
| 2019-01-15 | GF | Futures | 315.236 | 317.696 | 314.58 | 316.548 | 5892.0 |
| 2019-01-15 | GSCI | Futures | 459.53 | 461.93 | 458.45 | 461.59 | 80.0 |
| 2019-01-15 | HE | Futures | 74.86 | 76.483 | 73.928 | 74.739 | 22045.0 |
> showing 50 of 114 rows — these rows as CSV