PREVIEW / futures_daily / 2012-05-24
file: by_date/futures_daily/2012/2012-05-24.parquet size: 9 KB rows: 100
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-24 | ES | Futures | 1325.9 | 1333.71 | 1316.08 | 1332.7 | 2171218.0 |
| 2012-05-24 | NQ | Futures | 2910.99 | 2928.75 | 2876.04 | 2905.83 | 287392.0 |
| 2012-05-24 | YM | Futures | 12121.1 | 12197.9 | 12048.2 | 12191.1 | 174744.0 |
| 2012-05-24 | CL | Futures | 165.91 | 167.73 | 164.59 | 166.15 | 231521.0 |
| 2012-05-24 | GC | Futures | 2086.5 | 2109.1 | 2073.4 | 2082.1 | 197533.0 |
| 2012-05-24 | ZN | Futures | 115.790347 | 116.006955 | 115.533125 | 115.709119 | 1908575.0 |
| 2012-05-24 | A6 | Futures | 0.87562 | 0.88102 | 0.87193 | 0.87301 | 168430.0 |
| 2012-05-24 | AD | Futures | 0.98116 | 0.98317 | 0.97653 | 0.97784 | 118229.0 |
| 2012-05-24 | B | Futures | 95.94 | 96.98 | 94.97 | 96.35 | 191101.0 |
| 2012-05-24 | B6 | Futures | 1.6469 | 1.6505 | 1.6412 | 1.6425 | 112978.0 |
| 2012-05-24 | BFX | Futures | 2556.1 | 2569.7 | 2550.3 | 2569.7 | 14.0 |
| 2012-05-24 | BR | Futures | 0.23439 | 0.23517 | 0.23234 | 0.23329 | 1627.0 |
| 2012-05-24 | BZ | Futures | 101.98 | 103.32 | 101.25 | 102.68 | 1067.0 |
| 2012-05-24 | C | Futures | 1467.0 | 1483.0 | 1464.0 | 1472.0 | 6251.0 |
| 2012-05-24 | CB | Futures | 79.12 | 79.523 | 79.12 | 79.254 | 7.0 |
| 2012-05-24 | CC | Futures | 1589.0 | 1604.0 | 1579.0 | 1587.0 | 11470.0 |
| 2012-05-24 | CSC | Futures | 3.623 | 3.623 | 3.575 | 3.591 | 7.0 |
| 2012-05-24 | CT | Futures | 88.08 | 91.14 | 87.92 | 90.45 | 14942.0 |
| 2012-05-24 | DC | Futures | 25.46 | 25.97 | 25.4 | 25.55 | 347.0 |
| 2012-05-24 | DX | Futures | 79.72 | 79.967 | 79.444 | 79.921 | 35863.0 |
| 2012-05-24 | E1 | Futures | 1.37276 | 1.37367 | 1.3649 | 1.36529 | 69048.0 |
| 2012-05-24 | E6 | Futures | 1.5027 | 1.50675 | 1.4941 | 1.49529 | 347365.0 |
| 2012-05-24 | E7 | Futures | 1.4884 | 1.4924 | 1.4799 | 1.481 | 3677.0 |
| 2012-05-24 | ED | Futures | 95.0597 | 95.0645 | 95.0549 | 95.0573 | 132022.0 |
| 2012-05-24 | ER | Futures | 97.518 | 97.577 | 97.513 | 97.548 | 103157.0 |
| 2012-05-24 | EW | Futures | 941.8 | 949.3 | 932.8 | 948.6 | 27667.0 |
| 2012-05-24 | FBTP | Futures | 66.12 | 66.86 | 65.63 | 66.47 | 20689.0 |
| 2012-05-24 | FBTS | Futures | 84.631 | 84.753 | 84.362 | 84.696 | 4686.0 |
| 2012-05-24 | FCE | Futures | 2220.7 | 2234.3 | 2184.6 | 2222.5 | 137294.0 |
| 2012-05-24 | FDAX | Futures | 7019.6 | 7026.2 | 6901.3 | 6990.3 | 187797.0 |
| 2012-05-24 | FESX | Futures | 1478.4 | 1490.1 | 1454.2 | 1483.2 | 1413226.0 |
| 2012-05-24 | FEU3 | Futures | 98.093 | 98.122 | 98.093 | 98.122 | 52.0 |
| 2012-05-24 | FGBL | Futures | 117.94 | 118.53 | 117.94 | 118.05 | 932851.0 |
| 2012-05-24 | FGBM | Futures | 115.71 | 115.98 | 115.69 | 115.74 | 423868.0 |
| 2012-05-24 | FGBS | Futures | 110.298 | 110.348 | 110.293 | 110.308 | 324060.0 |
| 2012-05-24 | FGBX | Futures | 127.55 | 130.13 | 127.42 | 128.23 | 15262.0 |
| 2012-05-24 | FOAT | Futures | 96.9 | 98.7 | 96.87 | 98.37 | 27544.0 |
| 2012-05-24 | FTDX | Futures | 702.2 | 705.9 | 702.2 | 705.4 | 77.0 |
| 2012-05-24 | FTI | Futures | 253.36 | 254.19 | 250.24 | 253.19 | 36861.0 |
| 2012-05-24 | FTUK | Futures | 3854.3 | 3908.0 | 3830.6 | 3900.7 | 125863.0 |
| 2012-05-24 | FVSA | Futures | 10664.52 | 10758.35 | 10289.23 | 10304.87 | 3292.0 |
| 2012-05-24 | FXXP | Futures | 174.9 | 175.6 | 172.9 | 175.3 | 3373.0 |
| 2012-05-24 | G | Futures | 97.79 | 98.25 | 97.7 | 97.85 | 205981.0 |
| 2012-05-24 | GF | Futures | 312.864 | 314.69 | 312.519 | 313.505 | 1600.0 |
| 2012-05-24 | GSCI | Futures | 977.98 | 988.22 | 977.98 | 979.25 | 509.0 |
| 2012-05-24 | HE | Futures | 89.846 | 90.246 | 89.499 | 89.819 | 13677.0 |
| 2012-05-24 | HG | Futures | 4.5162 | 4.5201 | 4.4585 | 4.49 | 62545.0 |
| 2012-05-24 | HO | Futures | 2.3269 | 2.3354 | 2.3065 | 2.3227 | 8140.0 |
| 2012-05-24 | HRC | Futures | 2550.0 | 2550.0 | 2550.0 | 2550.0 | 0.0 |
| 2012-05-24 | J1 | Futures | 0.0157814 | 0.0158065 | 0.0157488 | 0.0157626 | 66294.0 |
> showing 50 of 100 rows — these rows as CSV