PREVIEW / futures_daily / 2010-07-30
file: by_date/futures_daily/2010/2010-07-30.parquet size: 9 KB rows: 91
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-30 | ES | Futures | 1069.23 | 1076.3 | 1056.8 | 1071.18 | 2133582.0 |
| 2010-07-30 | NQ | Futures | 2101.8 | 2120.47 | 2072.94 | 2107.74 | 355325.0 |
| 2010-07-30 | YM | Futures | 9620.3 | 9671.2 | 9510.3 | 9631.4 | 151104.0 |
| 2010-07-30 | CL | Futures | 166.14 | 167.83 | 163.12 | 167.62 | 294425.0 |
| 2010-07-30 | GC | Futures | 1591.4 | 1611.8 | 1587.6 | 1609.2 | 119041.0 |
| 2010-07-30 | ZN | Futures | 101.003035 | 101.540898 | 100.977422 | 101.476867 | 1185206.0 |
| 2010-07-30 | A6 | Futures | 0.74298 | 0.74787 | 0.73941 | 0.74505 | 104847.0 |
| 2010-07-30 | AD | Futures | 0.953 | 0.96179 | 0.95132 | 0.95913 | 97995.0 |
| 2010-07-30 | B | Futures | 67.55 | 68.29 | 66.41 | 68.18 | 81370.0 |
| 2010-07-30 | B6 | Futures | 1.62 | 1.6313 | 1.6136 | 1.6286 | 111514.0 |
| 2010-07-30 | BFX | Futures | 2908.8 | 2908.8 | 2874.2 | 2875.5 | 77.0 |
| 2010-07-30 | BR | Futures | 0.23593 | 0.23593 | 0.23593 | 0.23593 | 27.0 |
| 2010-07-30 | BZ | Futures | 73.37 | 73.37 | 73.37 | 73.37 | 575.0 |
| 2010-07-30 | C | Futures | 2491.0 | 2518.0 | 2478.0 | 2478.0 | 23158.0 |
| 2010-07-30 | CB | Futures | 86.891 | 86.916 | 86.891 | 86.916 | 2.0 |
| 2010-07-30 | CC | Futures | 2532.0 | 2581.0 | 2525.0 | 2578.0 | 5483.0 |
| 2010-07-30 | CSC | Futures | 3.831 | 3.84 | 3.831 | 3.84 | 2.0 |
| 2010-07-30 | CT | Futures | 67.7 | 69.66 | 67.7 | 69.28 | 111.0 |
| 2010-07-30 | DC | Futures | 23.63 | 23.75 | 23.63 | 23.68 | 269.0 |
| 2010-07-30 | DX | Futures | 82.407 | 82.73 | 82.211 | 82.301 | 17161.0 |
| 2010-07-30 | E1 | Futures | 1.26171 | 1.26802 | 1.25528 | 1.26342 | 40380.0 |
| 2010-07-30 | E6 | Futures | 1.54635 | 1.54836 | 1.53488 | 1.54363 | 285059.0 |
| 2010-07-30 | E7 | Futures | 1.5347 | 1.5372 | 1.5239 | 1.5325 | 3092.0 |
| 2010-07-30 | ED | Futures | 94.5179 | 94.5369 | 94.5084 | 94.5179 | 205877.0 |
| 2010-07-30 | ER | Futures | 97.242 | 97.276 | 97.237 | 97.267 | 170788.0 |
| 2010-07-30 | EW | Futures | 739.1 | 745.9 | 728.9 | 743.1 | 32913.0 |
| 2010-07-30 | FBTP | Futures | 65.96 | 66.16 | 65.87 | 66.09 | 2855.0 |
| 2010-07-30 | FCE | Futures | 2386.4 | 2414.3 | 2361.5 | 2388.3 | 143155.0 |
| 2010-07-30 | FDAX | Futures | 6658.4 | 6734.0 | 6595.9 | 6709.0 | 145877.0 |
| 2010-07-30 | FESX | Futures | 1694.1 | 1711.4 | 1675.5 | 1699.0 | 1302134.0 |
| 2010-07-30 | FEU3 | Futures | 97.805 | 97.825 | 97.805 | 97.825 | 13.0 |
| 2010-07-30 | FGBL | Futures | 100.2 | 100.49 | 100.13 | 100.4 | 806247.0 |
| 2010-07-30 | FGBM | Futures | 104.64 | 104.84 | 104.54 | 104.76 | 434663.0 |
| 2010-07-30 | FGBS | Futures | 107.244 | 107.338 | 107.215 | 107.303 | 400355.0 |
| 2010-07-30 | FGBX | Futures | 98.72 | 99.62 | 98.57 | 99.28 | 5122.0 |
| 2010-07-30 | FTDX | Futures | 683.6 | 683.6 | 668.1 | 676.5 | 707.0 |
| 2010-07-30 | FTI | Futures | 262.71 | 264.82 | 259.1 | 261.64 | 38778.0 |
| 2010-07-30 | FTUK | Futures | 3623.2 | 3644.2 | 3585.7 | 3609.4 | 132845.0 |
| 2010-07-30 | G | Futures | 81.08 | 81.67 | 81.06 | 81.59 | 118886.0 |
| 2010-07-30 | GF | Futures | 286.718 | 287.413 | 285.708 | 287.287 | 1399.0 |
| 2010-07-30 | GSCI | Futures | 872.36 | 892.14 | 870.24 | 888.57 | 272.0 |
| 2010-07-30 | HE | Futures | 102.653 | 104.201 | 102.258 | 104.201 | 6244.0 |
| 2010-07-30 | HG | Futures | 4.3908 | 4.4417 | 4.3486 | 4.435 | 31540.0 |
| 2010-07-30 | HO | Futures | 1.813 | 1.8324 | 1.7802 | 1.8299 | 53245.0 |
| 2010-07-30 | HRC | Futures | 2826.8 | 2826.8 | 2826.8 | 2826.8 | 0.0 |
| 2010-07-30 | J1 | Futures | 0.0144858 | 0.0146444 | 0.014477 | 0.0145752 | 150407.0 |
| 2010-07-30 | J7 | Futures | 0.014402 | 0.014532 | 0.014389 | 0.014465 | 333.0 |
| 2010-07-30 | JB | Futures | 120.7 | 120.87 | 120.68 | 120.83 | 1735.0 |
| 2010-07-30 | KC | Futures | 434.59 | 448.91 | 433.59 | 442.75 | 14204.0 |
| 2010-07-30 | KE | Futures | 2748.58 | 2897.73 | 2747.52 | 2874.29 | 24581.0 |
> showing 50 of 91 rows — these rows as CSV