PREVIEW / futures_daily / 2014-06-24
file: by_date/futures_daily/2014/2014-06-24.parquet size: 9 KB rows: 104
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-06-24 | ES | Futures | 2026.95 | 2036.04 | 2015.01 | 2018.64 | 1530560.0 |
| 2014-06-24 | NQ | Futures | 4375.13 | 4416.66 | 4362.73 | 4378.01 | 281591.0 |
| 2014-06-24 | YM | Futures | 16980.2 | 17036.7 | 16867.2 | 16902.5 | 142745.0 |
| 2014-06-24 | CL | Futures | 193.66 | 194.47 | 192.26 | 193.68 | 175206.0 |
| 2014-06-24 | GC | Futures | 1736.7 | 1747.9 | 1732.0 | 1740.9 | 123877.0 |
| 2014-06-24 | ZN | Futures | 116.010538 | 116.37526 | 115.981361 | 116.302315 | 1130867.0 |
| 2014-06-24 | A6 | Futures | 0.90533 | 0.9062 | 0.89982 | 0.90108 | 62599.0 |
| 2014-06-24 | AD | Futures | 0.94475 | 0.94587 | 0.94323 | 0.94363 | 43560.0 |
| 2014-06-24 | ALI | Futures | 2788.11 | 2805.92 | 2788.11 | 2805.92 | 30.0 |
| 2014-06-24 | B | Futures | 119.21 | 120.19 | 118.85 | 119.8 | 230490.0 |
| 2014-06-24 | B6 | Futures | 1.7887 | 1.7895 | 1.7824 | 1.7842 | 101875.0 |
| 2014-06-24 | BFX | Futures | 3810.4 | 3812.6 | 3810.4 | 3812.6 | 2.0 |
| 2014-06-24 | BR | Futures | 0.23371 | 0.23371 | 0.23221 | 0.23257 | 345.0 |
| 2014-06-24 | BZ | Futures | 120.1 | 121.23 | 119.9 | 120.85 | 11656.0 |
| 2014-06-24 | C | Futures | 2022.0 | 2024.0 | 2004.0 | 2013.0 | 4290.0 |
| 2014-06-24 | CB | Futures | 121.572 | 122.41 | 121.572 | 121.851 | 11.0 |
| 2014-06-24 | CC | Futures | 2262.0 | 2265.0 | 2234.0 | 2236.0 | 13427.0 |
| 2014-06-24 | CSC | Futures | 4.721 | 4.734 | 4.707 | 4.71 | 18.0 |
| 2014-06-24 | CT | Futures | 98.55 | 98.55 | 96.44 | 96.57 | 67.0 |
| 2014-06-24 | DC | Futures | 37.68 | 37.94 | 37.49 | 37.71 | 437.0 |
| 2014-06-24 | DX | Futures | 76.275 | 76.418 | 76.18 | 76.311 | 15467.0 |
| 2014-06-24 | E1 | Futures | 1.43455 | 1.43724 | 1.43186 | 1.43455 | 30055.0 |
| 2014-06-24 | E6 | Futures | 1.60554 | 1.60849 | 1.60318 | 1.60542 | 157381.0 |
| 2014-06-24 | E7 | Futures | 1.5953 | 1.5979 | 1.5927 | 1.595 | 1924.0 |
| 2014-06-24 | ED | Futures | 95.4115 | 95.4115 | 95.4067 | 95.4115 | 50468.0 |
| 2014-06-24 | ER | Futures | 97.906 | 97.916 | 97.901 | 97.911 | 36581.0 |
| 2014-06-24 | EW | Futures | 1473.1 | 1483.8 | 1463.2 | 1465.1 | 21313.0 |
| 2014-06-24 | FBTP | Futures | 91.02 | 91.42 | 90.99 | 91.27 | 43922.0 |
| 2014-06-24 | FBTS | Futures | 97.992 | 98.108 | 97.992 | 98.072 | 9815.0 |
| 2014-06-24 | FCE | Futures | 3604.4 | 3616.4 | 3583.2 | 3602.8 | 74502.0 |
| 2014-06-24 | FDAX | Futures | 10941.5 | 10967.9 | 10904.1 | 10962.4 | 68720.0 |
| 2014-06-24 | FESX | Futures | 2359.8 | 2365.6 | 2345.4 | 2360.5 | 656702.0 |
| 2014-06-24 | FEU3 | Futures | 98.527 | 98.532 | 98.527 | 98.532 | 40.0 |
| 2014-06-24 | FGBL | Futures | 126.97 | 127.22 | 126.95 | 127.05 | 481535.0 |
| 2014-06-24 | FGBM | Futures | 121.2 | 121.28 | 121.17 | 121.21 | 314329.0 |
| 2014-06-24 | FGBS | Futures | 110.728 | 110.748 | 110.728 | 110.738 | 111755.0 |
| 2014-06-24 | FGBX | Futures | 130.85 | 131.07 | 130.62 | 130.77 | 13042.0 |
| 2014-06-24 | FMWO | Futures | 5795.3 | 5802.8 | 5795.3 | 5802.8 | 40.0 |
| 2014-06-24 | FOAT | Futures | 116.69 | 116.97 | 116.68 | 116.9 | 43977.0 |
| 2014-06-24 | FTDX | Futures | 1238.0 | 1241.7 | 1235.6 | 1240.8 | 77.0 |
| 2014-06-24 | FTI | Futures | 359.65 | 360.43 | 357.66 | 359.52 | 18476.0 |
| 2014-06-24 | FTUK | Futures | 5201.2 | 5212.7 | 5161.2 | 5191.2 | 66039.0 |
| 2014-06-24 | FVSA | Futures | 1272.17 | 1293.66 | 1267.87 | 1272.17 | 3744.0 |
| 2014-06-24 | FXXP | Futures | 260.6 | 260.8 | 258.9 | 259.7 | 5962.0 |
| 2014-06-24 | G | Futures | 93.21 | 93.36 | 93.11 | 93.23 | 189429.0 |
| 2014-06-24 | GF | Futures | 319.623 | 323.224 | 319.623 | 322.803 | 3341.0 |
| 2014-06-24 | GSCI | Futures | 1110.5 | 1113.67 | 1110.5 | 1111.67 | 87.0 |
| 2014-06-24 | HE | Futures | 135.048 | 137.941 | 135.048 | 137.231 | 10484.0 |
| 2014-06-24 | HG | Futures | 4.0199 | 4.0276 | 3.995 | 4.0199 | 27897.0 |
| 2014-06-24 | HH | Futures | 56.359 | 57.611 | 56.359 | 57.611 | 1254.0 |
> showing 50 of 104 rows — these rows as CSV