PREVIEW / futures_daily / 2015-12-21
file: by_date/futures_daily/2015/2015-12-21.parquet size: 9 KB rows: 108
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-12-21 | ES | Futures | 2133.34 | 2157.1 | 2131.2 | 2152.29 | 1275266.0 |
| 2015-12-21 | NQ | Futures | 5291.5 | 5359.5 | 5289.16 | 5349.24 | 176610.0 |
| 2015-12-21 | YM | Futures | 17636.1 | 17816.2 | 17615.4 | 17775.8 | 127075.0 |
| 2015-12-21 | CL | Futures | 53.39 | 53.69 | 52.58 | 53.26 | 298080.0 |
| 2015-12-21 | GC | Futures | 1373.8 | 1394.7 | 1371.1 | 1393.6 | 122217.0 |
| 2015-12-21 | ZN | Futures | 121.701379 | 122.017252 | 121.550964 | 121.836754 | 569737.0 |
| 2015-12-21 | A6 | Futures | 0.71542 | 0.71803 | 0.71392 | 0.71753 | 42466.0 |
| 2015-12-21 | AD | Futures | 0.73382 | 0.73494 | 0.73065 | 0.73259 | 40195.0 |
| 2015-12-21 | ALI | Futures | 2158.78 | 2158.78 | 2158.78 | 2158.78 | 0.0 |
| 2015-12-21 | B | Futures | 31.85 | 32.03 | 31.41 | 31.68 | 175115.0 |
| 2015-12-21 | B6 | Futures | 1.5683 | 1.5712 | 1.5656 | 1.5666 | 53187.0 |
| 2015-12-21 | BFX | Futures | 4459.2 | 4459.2 | 4391.2 | 4391.2 | 11.0 |
| 2015-12-21 | BR | Futures | 0.1546 | 0.1546 | 0.15161 | 0.15309 | 1694.0 |
| 2015-12-21 | BZ | Futures | 31.63 | 31.79 | 31.13 | 31.4 | 22041.0 |
| 2015-12-21 | C | Futures | 2373.0 | 2378.0 | 2339.0 | 2366.0 | 10052.0 |
| 2015-12-21 | CB | Futures | 252.309 | 252.309 | 249.68 | 249.68 | 32.0 |
| 2015-12-21 | CC | Futures | 2393.0 | 2401.0 | 2363.0 | 2388.0 | 14497.0 |
| 2015-12-21 | CNH | Futures | 7.2739 | 7.2793 | 7.2678 | 7.2717 | 15.0 |
| 2015-12-21 | CSC | Futures | 3.841 | 3.841 | 3.79 | 3.79 | 154.0 |
| 2015-12-21 | CT | Futures | 74.76 | 75.16 | 74.0 | 74.17 | 10614.0 |
| 2015-12-21 | DC | Futures | 30.23 | 30.28 | 29.85 | 29.87 | 219.0 |
| 2015-12-21 | DX | Futures | 92.275 | 92.345 | 91.822 | 91.891 | 20929.0 |
| 2015-12-21 | E1 | Futures | 1.27763 | 1.28092 | 1.2717 | 1.27864 | 14111.0 |
| 2015-12-21 | E6 | Futures | 1.27303 | 1.28215 | 1.27151 | 1.28063 | 135047.0 |
| 2015-12-21 | E7 | Futures | 1.2647 | 1.275 | 1.2645 | 1.2734 | 3648.0 |
| 2015-12-21 | EBM | Futures | 248.25 | 249.66 | 246.48 | 246.84 | 12054.0 |
| 2015-12-21 | ED | Futures | 95.5736 | 95.5736 | 95.5591 | 95.5639 | 159213.0 |
| 2015-12-21 | ER | Futures | 98.22 | 98.22 | 98.205 | 98.205 | 31602.0 |
| 2015-12-21 | EW | Futures | 1444.2 | 1459.3 | 1443.3 | 1455.7 | 21200.0 |
| 2015-12-21 | FBON | Futures | 115.34 | 115.34 | 114.31 | 115.05 | 589.0 |
| 2015-12-21 | FBTP | Futures | 104.81 | 104.81 | 104.06 | 104.64 | 53714.0 |
| 2015-12-21 | FBTS | Futures | 100.579 | 100.588 | 100.517 | 100.579 | 10490.0 |
| 2015-12-21 | FCE | Futures | 3838.8 | 3903.6 | 3812.9 | 3818.3 | 76903.0 |
| 2015-12-21 | FDAX | Futures | 11441.2 | 11715.0 | 11359.3 | 11428.7 | 92499.0 |
| 2015-12-21 | FDXM | Futures | 10942.6 | 11201.8 | 10859.6 | 10927.0 | 18159.0 |
| 2015-12-21 | FESX | Futures | 2455.9 | 2499.3 | 2434.6 | 2449.8 | 831797.0 |
| 2015-12-21 | FGBL | Futures | 140.15 | 140.39 | 139.76 | 140.16 | 277409.0 |
| 2015-12-21 | FGBM | Futures | 125.74 | 125.84 | 125.62 | 125.75 | 171075.0 |
| 2015-12-21 | FGBS | Futures | 111.453 | 111.473 | 111.433 | 111.468 | 81744.0 |
| 2015-12-21 | FGBX | Futures | 159.65 | 160.04 | 158.69 | 159.47 | 13010.0 |
| 2015-12-21 | FMWO | Futures | 5545.7 | 5548.2 | 5497.1 | 5512.1 | 2023.0 |
| 2015-12-21 | FOAT | Futures | 128.33 | 128.61 | 127.79 | 128.33 | 42095.0 |
| 2015-12-21 | FTDX | Futures | 1745.9 | 1754.0 | 1724.8 | 1729.1 | 116.0 |
| 2015-12-21 | FTI | Futures | 377.59 | 383.22 | 373.52 | 374.31 | 30832.0 |
| 2015-12-21 | FTUK | Futures | 4863.4 | 4947.4 | 4849.9 | 4893.2 | 82802.0 |
| 2015-12-21 | FVSA | Futures | 2343.3 | 2376.23 | 2272.71 | 2329.18 | 9105.0 |
| 2015-12-21 | FXXP | Futures | 282.8 | 285.8 | 279.0 | 280.6 | 17253.0 |
| 2015-12-21 | G | Futures | 104.79 | 105.17 | 104.7 | 105.0 | 83066.0 |
| 2015-12-21 | GF | Futures | 294.849 | 300.158 | 294.849 | 300.158 | 4278.0 |
| 2015-12-21 | GSCI | Futures | 479.79 | 480.5 | 477.99 | 479.32 | 77.0 |
> showing 50 of 108 rows — these rows as CSV