PREVIEW / futures_daily / 2011-01-13
file: by_date/futures_daily/2011/2011-01-13.parquet size: 9 KB rows: 93
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-13 | ES | Futures | 1263.13 | 1264.36 | 1256.24 | 1261.17 | 1671242.0 |
| 2011-01-13 | NQ | Futures | 2616.59 | 2621.98 | 2607.51 | 2614.32 | 185940.0 |
| 2011-01-13 | YM | Futures | 10955.0 | 10965.3 | 10899.8 | 10934.5 | 88159.0 |
| 2011-01-13 | CL | Futures | 188.53 | 189.29 | 185.97 | 187.3 | 358898.0 |
| 2011-01-13 | GC | Futures | 1885.4 | 1893.3 | 1861.0 | 1885.3 | 201998.0 |
| 2011-01-13 | ZN | Futures | 100.244571 | 100.829504 | 100.127584 | 100.751513 | 1322061.0 |
| 2011-01-13 | A6 | Futures | 0.83842 | 0.84351 | 0.83477 | 0.83986 | 101456.0 |
| 2011-01-13 | AD | Futures | 1.00446 | 1.00575 | 1.00019 | 1.00197 | 61744.0 |
| 2011-01-13 | B | Futures | 83.21 | 83.35 | 82.17 | 82.85 | 229164.0 |
| 2011-01-13 | B6 | Futures | 1.6331 | 1.6471 | 1.63 | 1.6427 | 129403.0 |
| 2011-01-13 | BR | Futures | 0.25545 | 0.25547 | 0.25502 | 0.25502 | 69.0 |
| 2011-01-13 | BZ | Futures | 88.46 | 88.67 | 87.77 | 88.25 | 751.0 |
| 2011-01-13 | C | Futures | 2152.0 | 2156.0 | 2123.0 | 2146.0 | 5359.0 |
| 2011-01-13 | CB | Futures | 114.402 | 115.575 | 114.402 | 115.575 | 37.0 |
| 2011-01-13 | CC | Futures | 2391.0 | 2422.0 | 2373.0 | 2396.0 | 6834.0 |
| 2011-01-13 | CSC | Futures | 3.505 | 3.537 | 3.505 | 3.528 | 5.0 |
| 2011-01-13 | CT | Futures | 129.38 | 130.02 | 123.45 | 123.53 | 14635.0 |
| 2011-01-13 | DC | Futures | 24.52 | 24.7 | 24.34 | 24.47 | 262.0 |
| 2011-01-13 | DX | Futures | 80.145 | 80.3 | 79.067 | 79.263 | 32838.0 |
| 2011-01-13 | E1 | Futures | 1.35753 | 1.36421 | 1.34298 | 1.3612 | 49777.0 |
| 2011-01-13 | E6 | Futures | 1.55239 | 1.5828 | 1.5479 | 1.57854 | 518037.0 |
| 2011-01-13 | E7 | Futures | 1.5411 | 1.5709 | 1.5365 | 1.5668 | 10064.0 |
| 2011-01-13 | EBM | Futures | 233.76 | 234.44 | 229.91 | 231.72 | 6733.0 |
| 2011-01-13 | ED | Futures | 94.8147 | 94.8289 | 94.8099 | 94.8242 | 199225.0 |
| 2011-01-13 | ER | Futures | 97.34 | 97.35 | 97.271 | 97.296 | 312614.0 |
| 2011-01-13 | EW | Futures | 910.3 | 911.7 | 906.1 | 909.4 | 14663.0 |
| 2011-01-13 | FBTP | Futures | 63.66 | 64.24 | 63.6 | 64.05 | 10840.0 |
| 2011-01-13 | FCE | Futures | 2644.1 | 2655.7 | 2633.7 | 2655.7 | 3175.0 |
| 2011-01-13 | FDAX | Futures | 7597.2 | 7600.9 | 7544.7 | 7577.4 | 122246.0 |
| 2011-01-13 | FESX | Futures | 1789.9 | 1810.4 | 1786.8 | 1808.5 | 1501019.0 |
| 2011-01-13 | FEU3 | Futures | 97.904 | 97.904 | 97.855 | 97.855 | 39.0 |
| 2011-01-13 | FGBL | Futures | 98.78 | 98.98 | 98.42 | 98.71 | 1104501.0 |
| 2011-01-13 | FGBM | Futures | 104.67 | 104.78 | 104.23 | 104.38 | 667037.0 |
| 2011-01-13 | FGBS | Futures | 107.341 | 107.366 | 107.075 | 107.144 | 1053544.0 |
| 2011-01-13 | FGBX | Futures | 96.47 | 97.39 | 96.27 | 97.01 | 5511.0 |
| 2011-01-13 | FTDX | Futures | 777.1 | 782.4 | 771.9 | 774.9 | 603.0 |
| 2011-01-13 | FTI | Futures | 290.96 | 291.08 | 288.83 | 290.2 | 2100.0 |
| 2011-01-13 | FTUK | Futures | 4171.1 | 4180.1 | 4137.4 | 4152.7 | 103199.0 |
| 2011-01-13 | FXXP | Futures | 184.2 | 184.7 | 183.0 | 183.5 | 1186.0 |
| 2011-01-13 | G | Futures | 80.66 | 80.99 | 80.59 | 80.82 | 103264.0 |
| 2011-01-13 | GF | Futures | 311.609 | 313.891 | 309.266 | 313.028 | 2878.0 |
| 2011-01-13 | GSCI | Futures | 1023.91 | 1027.65 | 1018.34 | 1020.73 | 3130.0 |
| 2011-01-13 | HE | Futures | 101.897 | 101.96 | 99.859 | 100.706 | 27124.0 |
| 2011-01-13 | HG | Futures | 5.8866 | 5.898 | 5.7873 | 5.8333 | 32091.0 |
| 2011-01-13 | HO | Futures | 2.1911 | 2.2 | 2.1681 | 2.1853 | 35807.0 |
| 2011-01-13 | HRC | Futures | 2744.7 | 2744.7 | 2744.7 | 2744.7 | 0.0 |
| 2011-01-13 | J1 | Futures | 0.0151335 | 0.0152214 | 0.0151096 | 0.01519 | 124039.0 |
| 2011-01-13 | J7 | Futures | 0.01501 | 0.015112 | 0.015005 | 0.015082 | 301.0 |
| 2011-01-13 | JB | Futures | 120.91 | 121.07 | 120.91 | 121.05 | 1703.0 |
| 2011-01-13 | KC | Futures | 589.4 | 591.49 | 580.21 | 582.42 | 12845.0 |
> showing 50 of 93 rows — these rows as CSV