PREVIEW / futures_daily / 2010-07-23
file: by_date/futures_daily/2010/2010-07-23.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-23 | ES | Futures | 1060.45 | 1074.35 | 1057.28 | 1073.38 | 2091081.0 |
| 2010-07-23 | NQ | Futures | 2094.44 | 2123.59 | 2087.37 | 2120.76 | 326684.0 |
| 2010-07-23 | YM | Futures | 9485.4 | 9609.3 | 9463.2 | 9602.8 | 150705.0 |
| 2010-07-23 | CL | Futures | 168.3 | 169.0 | 166.45 | 167.68 | 259741.0 |
| 2010-07-23 | GC | Futures | 1630.2 | 1642.2 | 1614.2 | 1620.2 | 137637.0 |
| 2010-07-23 | ZN | Futures | 100.926197 | 101.041454 | 100.516397 | 100.542009 | 1134525.0 |
| 2010-07-23 | A6 | Futures | 0.73602 | 0.73917 | 0.73287 | 0.73825 | 101890.0 |
| 2010-07-23 | AD | Futures | 0.95083 | 0.95419 | 0.94569 | 0.95211 | 71474.0 |
| 2010-07-23 | B | Futures | 67.9 | 68.28 | 67.25 | 67.71 | 114518.0 |
| 2010-07-23 | B6 | Futures | 1.5835 | 1.6031 | 1.5829 | 1.6002 | 124323.0 |
| 2010-07-23 | BFX | Futures | 2847.7 | 2871.6 | 2841.6 | 2860.2 | 380.0 |
| 2010-07-23 | BR | Futures | 0.23488 | 0.23551 | 0.23488 | 0.23551 | 41.0 |
| 2010-07-23 | BZ | Futures | 72.38 | 72.73 | 71.9 | 72.37 | 120.0 |
| 2010-07-23 | C | Futures | 2475.0 | 2513.0 | 2458.0 | 2504.0 | 4577.0 |
| 2010-07-23 | CB | Futures | 86.191 | 86.191 | 86.191 | 86.191 | 4.0 |
| 2010-07-23 | CC | Futures | 2445.0 | 2480.0 | 2432.0 | 2474.0 | 6679.0 |
| 2010-07-23 | CSC | Futures | 3.809 | 3.809 | 3.795 | 3.795 | 1.0 |
| 2010-07-23 | CT | Futures | 67.13 | 67.69 | 66.98 | 67.57 | 38.0 |
| 2010-07-23 | DC | Futures | 23.22 | 23.4 | 23.22 | 23.29 | 188.0 |
| 2010-07-23 | DX | Futures | 83.345 | 83.879 | 83.042 | 83.283 | 25576.0 |
| 2010-07-23 | E1 | Futures | 1.25922 | 1.26276 | 1.24385 | 1.2495 | 49382.0 |
| 2010-07-23 | E6 | Futures | 1.52388 | 1.53322 | 1.51265 | 1.52778 | 347918.0 |
| 2010-07-23 | E7 | Futures | 1.513 | 1.5221 | 1.5019 | 1.5168 | 4733.0 |
| 2010-07-23 | ED | Futures | 94.4752 | 94.4799 | 94.442 | 94.4609 | 174169.0 |
| 2010-07-23 | ER | Futures | 97.227 | 97.242 | 97.208 | 97.222 | 122313.0 |
| 2010-07-23 | EW | Futures | 733.1 | 747.1 | 730.3 | 746.4 | 30851.0 |
| 2010-07-23 | FBTP | Futures | 65.57 | 65.62 | 65.37 | 65.54 | 2801.0 |
| 2010-07-23 | FCE | Futures | 2357.2 | 2384.1 | 2345.4 | 2365.7 | 121658.0 |
| 2010-07-23 | FDAX | Futures | 6679.6 | 6744.4 | 6653.5 | 6715.5 | 131114.0 |
| 2010-07-23 | FESX | Futures | 1672.4 | 1695.3 | 1666.2 | 1682.9 | 1130953.0 |
| 2010-07-23 | FEU3 | Futures | 97.79 | 97.795 | 97.776 | 97.78 | 400.0 |
| 2010-07-23 | FGBL | Futures | 100.59 | 100.68 | 99.85 | 100.23 | 802156.0 |
| 2010-07-23 | FGBM | Futures | 105.07 | 105.07 | 104.43 | 104.7 | 470667.0 |
| 2010-07-23 | FGBS | Futures | 107.505 | 107.519 | 107.328 | 107.392 | 440566.0 |
| 2010-07-23 | FGBX | Futures | 100.01 | 100.16 | 98.68 | 99.47 | 2445.0 |
| 2010-07-23 | FTDX | Futures | 688.9 | 700.8 | 688.0 | 694.6 | 71.0 |
| 2010-07-23 | FTI | Futures | 264.62 | 268.67 | 264.02 | 266.89 | 31754.0 |
| 2010-07-23 | FTUK | Futures | 3630.1 | 3663.4 | 3606.3 | 3634.9 | 94948.0 |
| 2010-07-23 | G | Futures | 81.37 | 81.55 | 80.65 | 80.86 | 107129.0 |
| 2010-07-23 | GF | Futures | 289.75 | 291.392 | 289.686 | 290.949 | 1274.0 |
| 2010-07-23 | GSCI | Futures | 874.14 | 876.26 | 872.62 | 875.84 | 96.0 |
| 2010-07-23 | HE | Futures | 100.589 | 101.166 | 100.164 | 101.044 | 6877.0 |
| 2010-07-23 | HG | Futures | 4.2348 | 4.3205 | 4.2107 | 4.2656 | 28498.0 |
| 2010-07-23 | HO | Futures | 1.8275 | 1.8419 | 1.8097 | 1.8216 | 33645.0 |
| 2010-07-23 | HRC | Futures | 2851.1 | 2851.1 | 2851.1 | 2851.1 | 0.0 |
| 2010-07-23 | J1 | Futures | 0.0144644 | 0.0145135 | 0.0143839 | 0.0144015 | 131600.0 |
| 2010-07-23 | J7 | Futures | 0.014354 | 0.014403 | 0.014278 | 0.014293 | 137.0 |
| 2010-07-23 | JB | Futures | 120.71 | 120.8 | 120.58 | 120.58 | 1827.0 |
| 2010-07-23 | KC | Futures | 406.09 | 420.91 | 402.95 | 416.89 | 14342.0 |
| 2010-07-23 | KE | Futures | 2599.44 | 2643.11 | 2595.17 | 2620.74 | 9860.0 |
> showing 50 of 90 rows — these rows as CSV