PREVIEW / futures_daily / 2010-06-14
file: by_date/futures_daily/2010/2010-06-14.parquet size: 9 KB rows: 88
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-06-14 | ES | Futures | 1060.7 | 1074.6 | 1057.53 | 1059.48 | 2411842.0 |
| 2010-06-14 | NQ | Futures | 2091.9 | 2123.3 | 2085.39 | 2089.91 | 329991.0 |
| 2010-06-14 | YM | Futures | 9385.5 | 9495.5 | 9361.5 | 9376.3 | 136726.0 |
| 2010-06-14 | CL | Futures | 161.44 | 165.16 | 161.04 | 162.92 | 145483.0 |
| 2010-06-14 | GC | Futures | 1676.8 | 1685.8 | 1660.7 | 1670.3 | 97231.0 |
| 2010-06-14 | ZN | Futures | 98.6851 | 98.710713 | 98.134431 | 98.505813 | 858143.0 |
| 2010-06-14 | A6 | Futures | 0.69847 | 0.71074 | 0.69789 | 0.70634 | 86332.0 |
| 2010-06-14 | AD | Futures | 0.95439 | 0.96545 | 0.95409 | 0.95814 | 76360.0 |
| 2010-06-14 | B | Futures | 66.05 | 67.45 | 65.63 | 66.39 | 214082.0 |
| 2010-06-14 | B6 | Futures | 1.5105 | 1.5371 | 1.5102 | 1.5331 | 115142.0 |
| 2010-06-14 | BFX | Futures | 2843.2 | 2859.8 | 2831.6 | 2850.2 | 89.0 |
| 2010-06-14 | BR | Futures | 0.22778 | 0.22778 | 0.22774 | 0.22774 | 1.0 |
| 2010-06-14 | BZ | Futures | 72.34 | 72.37 | 70.83 | 71.6 | 109.0 |
| 2010-06-14 | C | Futures | 2452.0 | 2494.0 | 2448.0 | 2469.0 | 2853.0 |
| 2010-06-14 | CB | Futures | 81.604 | 81.604 | 81.604 | 81.604 | 7.0 |
| 2010-06-14 | CC | Futures | 2464.0 | 2504.0 | 2462.0 | 2480.0 | 6367.0 |
| 2010-06-14 | CT | Futures | 64.94 | 66.0 | 64.68 | 65.62 | 8010.0 |
| 2010-06-14 | DC | Futures | 22.57 | 22.59 | 22.26 | 22.29 | 23.0 |
| 2010-06-14 | DX | Futures | 88.314 | 88.389 | 87.15 | 87.483 | 23278.0 |
| 2010-06-14 | E1 | Futures | 1.14614 | 1.1594 | 1.14509 | 1.1531 | 42809.0 |
| 2010-06-14 | E6 | Futures | 1.43413 | 1.45553 | 1.43366 | 1.44867 | 305666.0 |
| 2010-06-14 | E7 | Futures | 1.4237 | 1.4451 | 1.4232 | 1.4382 | 4635.0 |
| 2010-06-14 | ED | Futures | 94.2379 | 94.2521 | 94.2189 | 94.2474 | 175681.0 |
| 2010-06-14 | ER | Futures | 97.375 | 97.375 | 97.34 | 97.355 | 200835.0 |
| 2010-06-14 | EW | Futures | 742.6 | 755.6 | 742.3 | 744.3 | 39967.0 |
| 2010-06-14 | FBTP | Futures | 64.4 | 64.71 | 64.26 | 64.33 | 4793.0 |
| 2010-06-14 | FCE | Futures | 2351.3 | 2386.2 | 2351.0 | 2381.3 | 45319.0 |
| 2010-06-14 | FDAX | Futures | 6640.5 | 6676.9 | 6603.5 | 6655.2 | 152977.0 |
| 2010-06-14 | FESX | Futures | 1643.9 | 1660.6 | 1639.0 | 1655.1 | 433651.0 |
| 2010-06-14 | FEU3 | Futures | 97.929 | 97.929 | 97.909 | 97.914 | 678.0 |
| 2010-06-14 | FGBL | Futures | 100.73 | 100.77 | 100.29 | 100.38 | 655806.0 |
| 2010-06-14 | FGBM | Futures | 105.31 | 105.36 | 105.1 | 105.19 | 343884.0 |
| 2010-06-14 | FGBS | Futures | 107.731 | 107.775 | 107.691 | 107.716 | 271719.0 |
| 2010-06-14 | FGBX | Futures | 100.05 | 100.05 | 99.1 | 99.15 | 2962.0 |
| 2010-06-14 | FTDX | Futures | 681.4 | 683.6 | 680.0 | 682.7 | 293.0 |
| 2010-06-14 | FTI | Futures | 260.71 | 262.65 | 260.24 | 262.38 | 13885.0 |
| 2010-06-14 | FTUK | Futures | 3558.5 | 3566.1 | 3514.8 | 3553.0 | 170969.0 |
| 2010-06-14 | G | Futures | 80.09 | 80.21 | 79.75 | 79.79 | 64274.0 |
| 2010-06-14 | GF | Futures | 278.256 | 279.771 | 278.256 | 278.95 | 1412.0 |
| 2010-06-14 | GSCI | Futures | 856.1 | 860.96 | 847.47 | 852.08 | 2123.0 |
| 2010-06-14 | HE | Futures | 98.788 | 100.978 | 98.725 | 100.164 | 15563.0 |
| 2010-06-14 | HG | Futures | 3.9754 | 4.105 | 3.9686 | 4.063 | 27162.0 |
| 2010-06-14 | HO | Futures | 1.8005 | 1.8418 | 1.7962 | 1.8133 | 7725.0 |
| 2010-06-14 | HRC | Futures | 3017.0 | 3017.0 | 3017.0 | 3017.0 | 0.0 |
| 2010-06-14 | J1 | Futures | 0.0137322 | 0.0137838 | 0.0136781 | 0.0137649 | 102393.0 |
| 2010-06-14 | J7 | Futures | 0.013639 | 0.013678 | 0.013578 | 0.013661 | 79.0 |
| 2010-06-14 | JB | Futures | 119.53 | 119.57 | 119.42 | 119.53 | 1250.0 |
| 2010-06-14 | KC | Futures | 367.24 | 387.04 | 367.24 | 383.23 | 14127.0 |
| 2010-06-14 | KE | Futures | 2034.61 | 2088.95 | 2033.52 | 2084.61 | 11040.0 |
| 2010-06-14 | L | Futures | 97.977 | 97.997 | 97.957 | 97.967 | 74734.0 |
> showing 50 of 88 rows — these rows as CSV