PREVIEW / futures_daily / 2010-07-14
file: by_date/futures_daily/2010/2010-07-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-07-14 | ES | Futures | 1068.01 | 1071.91 | 1056.8 | 1064.11 | 1940692.0 |
| 2010-07-14 | NQ | Futures | 2105.19 | 2112.27 | 2080.29 | 2095.29 | 336833.0 |
| 2010-07-14 | YM | Futures | 9552.9 | 9580.6 | 9475.2 | 9528.8 | 133968.0 |
| 2010-07-14 | CL | Futures | 164.78 | 166.77 | 163.12 | 164.44 | 187505.0 |
| 2010-07-14 | GC | Futures | 1653.2 | 1661.7 | 1640.3 | 1646.4 | 107456.0 |
| 2010-07-14 | ZN | Futures | 99.632764 | 100.247465 | 99.54312 | 100.183434 | 1309413.0 |
| 2010-07-14 | A6 | Futures | 0.72698 | 0.73005 | 0.72292 | 0.72549 | 92874.0 |
| 2010-07-14 | AD | Futures | 0.95705 | 0.95962 | 0.95162 | 0.9535 | 70417.0 |
| 2010-07-14 | B | Futures | 67.35 | 67.93 | 66.51 | 67.02 | 156291.0 |
| 2010-07-14 | B6 | Futures | 1.5745 | 1.5873 | 1.5742 | 1.5824 | 112216.0 |
| 2010-07-14 | BFX | Futures | 2880.3 | 2884.6 | 2862.7 | 2877.3 | 1096.0 |
| 2010-07-14 | BZ | Futures | 71.27 | 72.58 | 71.09 | 71.63 | 333.0 |
| 2010-07-14 | C | Futures | 2629.0 | 2688.0 | 2629.0 | 2656.0 | 7841.0 |
| 2010-07-14 | CB | Futures | 84.248 | 84.381 | 84.248 | 84.381 | 25.0 |
| 2010-07-14 | CC | Futures | 2548.0 | 2639.0 | 2548.0 | 2630.0 | 13785.0 |
| 2010-07-14 | CT | Futures | 65.66 | 65.99 | 64.84 | 64.99 | 36.0 |
| 2010-07-14 | DC | Futures | 23.09 | 23.29 | 23.06 | 23.26 | 210.0 |
| 2010-07-14 | DX | Futures | 84.373 | 84.539 | 84.025 | 84.26 | 16766.0 |
| 2010-07-14 | E1 | Futures | 1.24608 | 1.24897 | 1.23807 | 1.24608 | 26797.0 |
| 2010-07-14 | E6 | Futures | 1.50508 | 1.51111 | 1.49964 | 1.50531 | 255092.0 |
| 2010-07-14 | E7 | Futures | 1.4938 | 1.5002 | 1.4888 | 1.4945 | 3108.0 |
| 2010-07-14 | ED | Futures | 94.3708 | 94.385 | 94.366 | 94.3803 | 174886.0 |
| 2010-07-14 | ER | Futures | 97.203 | 97.232 | 97.198 | 97.208 | 118797.0 |
| 2010-07-14 | EW | Futures | 739.1 | 742.5 | 728.9 | 735.8 | 24095.0 |
| 2010-07-14 | FBTP | Futures | 64.96 | 65.0 | 64.72 | 64.8 | 4636.0 |
| 2010-07-14 | FCE | Futures | 2401.1 | 2401.1 | 2359.2 | 2383.1 | 173805.0 |
| 2010-07-14 | FDAX | Futures | 6788.4 | 6794.9 | 6707.9 | 6755.8 | 114627.0 |
| 2010-07-14 | FESX | Futures | 1704.6 | 1707.1 | 1676.7 | 1691.6 | 1064200.0 |
| 2010-07-14 | FEU3 | Futures | 97.761 | 97.766 | 97.761 | 97.766 | 32.0 |
| 2010-07-14 | FGBL | Futures | 100.48 | 100.82 | 100.41 | 100.53 | 695219.0 |
| 2010-07-14 | FGBM | Futures | 104.98 | 105.12 | 104.86 | 104.9 | 476903.0 |
| 2010-07-14 | FGBS | Futures | 107.372 | 107.416 | 107.308 | 107.323 | 396928.0 |
| 2010-07-14 | FGBX | Futures | 100.21 | 100.73 | 99.94 | 100.16 | 3822.0 |
| 2010-07-14 | FTDX | Futures | 698.6 | 702.1 | 695.0 | 697.7 | 408.0 |
| 2010-07-14 | FTI | Futures | 265.93 | 266.29 | 263.11 | 265.06 | 50815.0 |
| 2010-07-14 | FTUK | Futures | 3619.0 | 3621.5 | 3559.2 | 3591.5 | 94608.0 |
| 2010-07-14 | G | Futures | 81.12 | 81.24 | 81.01 | 81.06 | 81349.0 |
| 2010-07-14 | GF | Futures | 287.35 | 288.297 | 286.213 | 287.034 | 3187.0 |
| 2010-07-14 | GSCI | Futures | 856.83 | 866.59 | 852.59 | 856.41 | 3334.0 |
| 2010-07-14 | HE | Futures | 96.097 | 99.132 | 95.945 | 98.859 | 28696.0 |
| 2010-07-14 | HG | Futures | 4.07 | 4.0928 | 3.9984 | 4.0292 | 29763.0 |
| 2010-07-14 | HO | Futures | 1.8165 | 1.829 | 1.795 | 1.8046 | 21277.0 |
| 2010-07-14 | HRC | Futures | 2899.3 | 2899.3 | 2899.3 | 2899.3 | 0.0 |
| 2010-07-14 | J1 | Futures | 0.0141927 | 0.0142971 | 0.0141298 | 0.0142682 | 127216.0 |
| 2010-07-14 | J7 | Futures | 0.014047 | 0.014191 | 0.013992 | 0.014161 | 288.0 |
| 2010-07-14 | JB | Futures | 120.38 | 120.38 | 120.18 | 120.29 | 1522.0 |
| 2010-07-14 | KC | Futures | 415.0 | 418.27 | 411.86 | 414.12 | 6225.0 |
| 2010-07-14 | KE | Futures | 2405.54 | 2477.99 | 2403.41 | 2439.63 | 16226.0 |
| 2010-07-14 | L | Futures | 98.076 | 98.076 | 98.066 | 98.066 | 8819.0 |
| 2010-07-14 | LBS | Futures | 635.6 | 643.9 | 628.8 | 631.5 | 251.0 |
> showing 50 of 89 rows — these rows as CSV