PREVIEW / futures_daily / 2010-05-14
file: by_date/futures_daily/2010/2010-05-14.parquet size: 9 KB rows: 89
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-14 | ES | Futures | 1125.21 | 1129.1 | 1094.29 | 1105.49 | 2979512.0 |
| 2010-05-14 | NQ | Futures | 2206.47 | 2212.71 | 2136.14 | 2166.48 | 449745.0 |
| 2010-05-14 | YM | Futures | 9897.8 | 9923.5 | 9660.6 | 9752.5 | 208712.0 |
| 2010-05-14 | CL | Futures | 172.04 | 172.39 | 164.25 | 165.05 | 249080.0 |
| 2010-05-14 | GC | Futures | 1692.1 | 1714.6 | 1670.6 | 1684.6 | 242404.0 |
| 2010-05-14 | ZN | Futures | 97.233712 | 97.973423 | 97.131683 | 97.756611 | 1331469.0 |
| 2010-05-14 | A6 | Futures | 0.73208 | 0.7338 | 0.72371 | 0.72412 | 114490.0 |
| 2010-05-14 | AD | Futures | 0.96573 | 0.96682 | 0.95102 | 0.95655 | 104871.0 |
| 2010-05-14 | B | Futures | 71.84 | 72.04 | 68.67 | 68.99 | 220960.0 |
| 2010-05-14 | B6 | Futures | 1.515 | 1.5196 | 1.5049 | 1.5114 | 155463.0 |
| 2010-05-14 | BFX | Futures | 2808.3 | 2808.3 | 2768.4 | 2772.7 | 2.0 |
| 2010-05-14 | BR | Futures | 0.22623 | 0.22623 | 0.22623 | 0.22623 | 4.0 |
| 2010-05-14 | BZ | Futures | 74.31 | 74.47 | 72.3 | 72.6 | 230.0 |
| 2010-05-14 | C | Futures | 2235.0 | 2238.0 | 2198.0 | 2204.0 | 7471.0 |
| 2010-05-14 | CC | Futures | 2443.0 | 2446.0 | 2357.0 | 2362.0 | 11829.0 |
| 2010-05-14 | CT | Futures | 64.37 | 64.8 | 63.9 | 64.16 | 6271.0 |
| 2010-05-14 | DC | Futures | 22.8 | 23.05 | 22.56 | 22.79 | 608.0 |
| 2010-05-14 | DX | Futures | 86.627 | 87.59 | 86.475 | 87.383 | 32266.0 |
| 2010-05-14 | E1 | Futures | 1.17733 | 1.18075 | 1.1618 | 1.1643 | 67419.0 |
| 2010-05-14 | E6 | Futures | 1.48181 | 1.48796 | 1.46158 | 1.46537 | 460512.0 |
| 2010-05-14 | E7 | Futures | 1.4697 | 1.4757 | 1.4495 | 1.4534 | 9204.0 |
| 2010-05-14 | ED | Futures | 94.2192 | 94.2239 | 94.1576 | 94.1718 | 426736.0 |
| 2010-05-14 | ER | Futures | 97.335 | 97.34 | 97.301 | 97.311 | 202279.0 |
| 2010-05-14 | EW | Futures | 788.0 | 790.6 | 762.3 | 769.6 | 33932.0 |
| 2010-05-14 | FBTP | Futures | 64.99 | 65.04 | 64.68 | 64.75 | 4981.0 |
| 2010-05-14 | FCE | Futures | 2419.0 | 2419.0 | 2310.9 | 2321.2 | 3999.0 |
| 2010-05-14 | FDAX | Futures | 6785.1 | 6786.8 | 6544.2 | 6564.3 | 249499.0 |
| 2010-05-14 | FESX | Futures | 1668.8 | 1669.4 | 1584.3 | 1591.6 | 2397706.0 |
| 2010-05-14 | FEU3 | Futures | 97.889 | 97.894 | 97.869 | 97.869 | 683.0 |
| 2010-05-14 | FGBL | Futures | 98.43 | 98.99 | 98.32 | 98.75 | 900058.0 |
| 2010-05-14 | FGBM | Futures | 104.03 | 104.3 | 103.94 | 104.2 | 428350.0 |
| 2010-05-14 | FGBS | Futures | 107.378 | 107.461 | 107.344 | 107.417 | 500278.0 |
| 2010-05-14 | FGBX | Futures | 94.58 | 95.97 | 94.35 | 95.46 | 3098.0 |
| 2010-05-14 | FTDX | Futures | 695.1 | 697.4 | 677.9 | 681.9 | 695.0 |
| 2010-05-14 | FTI | Futures | 264.04 | 264.12 | 256.96 | 257.23 | 660.0 |
| 2010-05-14 | FTUK | Futures | 3645.9 | 3648.2 | 3529.8 | 3548.1 | 161540.0 |
| 2010-05-14 | G | Futures | 78.08 | 78.63 | 77.96 | 78.46 | 101061.0 |
| 2010-05-14 | GF | Futures | 290.507 | 291.455 | 284.95 | 285.392 | 3759.0 |
| 2010-05-14 | GSCI | Futures | 890.12 | 891.86 | 868.04 | 870.47 | 2592.0 |
| 2010-05-14 | HE | Futures | 106.531 | 106.594 | 104.677 | 105.023 | 14749.0 |
| 2010-05-14 | HG | Futures | 4.3726 | 4.3834 | 4.2327 | 4.2558 | 34653.0 |
| 2010-05-14 | HO | Futures | 1.944 | 1.9478 | 1.8709 | 1.878 | 50547.0 |
| 2010-05-14 | HRC | Futures | 3107.7 | 3107.7 | 3107.7 | 3107.7 | 0.0 |
| 2010-05-14 | J1 | Futures | 0.0135625 | 0.0136996 | 0.0135072 | 0.0136392 | 137104.0 |
| 2010-05-14 | J7 | Futures | 0.013457 | 0.013588 | 0.013401 | 0.01353 | 182.0 |
| 2010-05-14 | JB | Futures | 118.72 | 118.94 | 118.72 | 118.94 | 1288.0 |
| 2010-05-14 | KC | Futures | 347.69 | 350.1 | 337.91 | 340.96 | 17535.0 |
| 2010-05-14 | KE | Futures | 2162.86 | 2171.56 | 2131.34 | 2134.6 | 8528.0 |
| 2010-05-14 | L | Futures | 97.809 | 97.809 | 97.769 | 97.789 | 45884.0 |
| 2010-05-14 | LBS | Futures | 799.1 | 814.9 | 791.4 | 808.7 | 567.0 |
> showing 50 of 89 rows — these rows as CSV