PREVIEW / futures_daily / 2010-07-22
file: by_date/futures_daily/2010/2010-07-22.parquet size: 9 KB rows: 90
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-07-22 | ES | Futures | 1037.04 | 1067.52 | 1035.09 | 1060.94 | 2178892.0 |
| 2010-07-22 | NQ | Futures | 2054.83 | 2115.66 | 2051.43 | 2096.99 | 349001.0 |
| 2010-07-22 | YM | Futures | 9299.5 | 9536.2 | 9278.3 | 9492.8 | 154260.0 |
| 2010-07-22 | CL | Futures | 162.27 | 168.62 | 161.7 | 168.36 | 358815.0 |
| 2010-07-22 | GC | Futures | 1615.2 | 1638.5 | 1610.5 | 1630.9 | 134689.0 |
| 2010-07-22 | ZN | Futures | 101.25916 | 101.374417 | 100.810941 | 100.95181 | 952860.0 |
| 2010-07-22 | A6 | Futures | 0.72217 | 0.73759 | 0.71977 | 0.7361 | 115489.0 |
| 2010-07-22 | AD | Futures | 0.94095 | 0.9532 | 0.93967 | 0.95211 | 79925.0 |
| 2010-07-22 | B | Futures | 65.96 | 68.12 | 65.49 | 68.04 | 162155.0 |
| 2010-07-22 | B6 | Futures | 1.5738 | 1.5872 | 1.5719 | 1.584 | 79833.0 |
| 2010-07-22 | BFX | Futures | 2792.4 | 2858.8 | 2792.4 | 2854.6 | 85.0 |
| 2010-07-22 | BR | Futures | 0.23476 | 0.23538 | 0.23476 | 0.23538 | 5.0 |
| 2010-07-22 | BZ | Futures | 70.66 | 72.8 | 70.56 | 72.71 | 521.0 |
| 2010-07-22 | C | Futures | 2489.0 | 2508.0 | 2454.0 | 2478.0 | 5552.0 |
| 2010-07-22 | CB | Futures | 85.708 | 86.191 | 85.708 | 85.708 | 16.0 |
| 2010-07-22 | CC | Futures | 2455.0 | 2477.0 | 2420.0 | 2432.0 | 7786.0 |
| 2010-07-22 | CSC | Futures | 3.765 | 3.765 | 3.765 | 3.765 | 1.0 |
| 2010-07-22 | CT | Futures | 66.58 | 66.94 | 66.11 | 66.94 | 112.0 |
| 2010-07-22 | DC | Futures | 23.2 | 23.4 | 23.06 | 23.14 | 411.0 |
| 2010-07-22 | DX | Futures | 84.131 | 84.206 | 83.294 | 83.437 | 20993.0 |
| 2010-07-22 | E1 | Futures | 1.25042 | 1.2646 | 1.25029 | 1.26 | 43307.0 |
| 2010-07-22 | E6 | Futures | 1.50815 | 1.52932 | 1.50614 | 1.52459 | 284053.0 |
| 2010-07-22 | E7 | Futures | 1.4968 | 1.5181 | 1.4953 | 1.5136 | 4032.0 |
| 2010-07-22 | ED | Futures | 94.4562 | 94.4799 | 94.4562 | 94.4752 | 178628.0 |
| 2010-07-22 | ER | Futures | 97.208 | 97.232 | 97.203 | 97.227 | 117738.0 |
| 2010-07-22 | EW | Futures | 713.2 | 737.0 | 711.4 | 733.7 | 34735.0 |
| 2010-07-22 | FBTP | Futures | 65.49 | 65.62 | 65.4 | 65.54 | 2986.0 |
| 2010-07-22 | FCE | Futures | 2272.6 | 2367.0 | 2268.7 | 2362.8 | 146904.0 |
| 2010-07-22 | FDAX | Futures | 6494.7 | 6695.4 | 6477.8 | 6682.9 | 157177.0 |
| 2010-07-22 | FESX | Futures | 1621.0 | 1682.3 | 1615.4 | 1678.6 | 1390452.0 |
| 2010-07-22 | FEU3 | Futures | 97.776 | 97.785 | 97.776 | 97.785 | 64.0 |
| 2010-07-22 | FGBL | Futures | 100.91 | 101.09 | 100.38 | 100.51 | 702815.0 |
| 2010-07-22 | FGBM | Futures | 105.07 | 105.26 | 104.86 | 104.93 | 403289.0 |
| 2010-07-22 | FGBS | Futures | 107.48 | 107.519 | 107.446 | 107.48 | 355993.0 |
| 2010-07-22 | FGBX | Futures | 100.77 | 100.95 | 99.56 | 99.8 | 1351.0 |
| 2010-07-22 | FTDX | Futures | 675.2 | 695.5 | 675.2 | 690.6 | 439.0 |
| 2010-07-22 | FTI | Futures | 256.79 | 265.65 | 256.43 | 265.1 | 38288.0 |
| 2010-07-22 | FTUK | Futures | 3547.8 | 3643.5 | 3541.3 | 3631.8 | 102684.0 |
| 2010-07-22 | G | Futures | 81.69 | 81.69 | 81.28 | 81.36 | 65471.0 |
| 2010-07-22 | GF | Futures | 289.244 | 290.507 | 288.613 | 290.255 | 1308.0 |
| 2010-07-22 | GSCI | Futures | 860.56 | 878.39 | 860.56 | 877.54 | 182.0 |
| 2010-07-22 | HE | Futures | 98.95 | 100.801 | 98.768 | 100.316 | 13801.0 |
| 2010-07-22 | HG | Futures | 4.1102 | 4.2756 | 4.0814 | 4.2381 | 42158.0 |
| 2010-07-22 | HO | Futures | 1.7672 | 1.8343 | 1.7614 | 1.8311 | 42438.0 |
| 2010-07-22 | HRC | Futures | 2851.1 | 2851.1 | 2851.1 | 2851.1 | 0.0 |
| 2010-07-22 | J1 | Futures | 0.0144707 | 0.0145789 | 0.014433 | 0.0144657 | 130064.0 |
| 2010-07-22 | J7 | Futures | 0.014368 | 0.014467 | 0.014327 | 0.014357 | 201.0 |
| 2010-07-22 | JB | Futures | 120.67 | 120.99 | 120.67 | 120.71 | 1381.0 |
| 2010-07-22 | KC | Futures | 395.79 | 406.72 | 395.79 | 406.09 | 10170.0 |
| 2010-07-22 | KE | Futures | 2557.89 | 2651.64 | 2547.23 | 2606.89 | 14024.0 |
> showing 50 of 90 rows — these rows as CSV