PREVIEW / futures_daily / 2010-07-09
file: by_date/futures_daily/2010/2010-07-09.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-07-09 | ES | Futures | 1040.46 | 1048.5 | 1037.04 | 1046.07 | 1421814.0 |
| 2010-07-09 | NQ | Futures | 2033.61 | 2054.54 | 2025.12 | 2050.3 | 207835.0 |
| 2010-07-09 | YM | Futures | 9329.1 | 9383.7 | 9293.0 | 9367.9 | 108015.0 |
| 2010-07-09 | CL | Futures | 162.0 | 163.35 | 160.18 | 162.51 | 269887.0 |
| 2010-07-09 | GC | Futures | 1634.8 | 1656.1 | 1629.5 | 1650.2 | 110471.0 |
| 2010-07-09 | ZN | Futures | 100.016952 | 100.132209 | 99.863277 | 99.927308 | 674825.0 |
| 2010-07-09 | A6 | Futures | 0.72093 | 0.72275 | 0.71795 | 0.72052 | 77413.0 |
| 2010-07-09 | AD | Futures | 0.94569 | 0.95863 | 0.94411 | 0.95616 | 91914.0 |
| 2010-07-09 | B | Futures | 65.78 | 66.5 | 65.26 | 66.14 | 121945.0 |
| 2010-07-09 | B6 | Futures | 1.573 | 1.5778 | 1.5615 | 1.563 | 82275.0 |
| 2010-07-09 | BFX | Futures | 2818.6 | 2819.7 | 2802.6 | 2811.8 | 87.0 |
| 2010-07-09 | BZ | Futures | 70.68 | 70.68 | 70.68 | 70.68 | 34.0 |
| 2010-07-09 | C | Futures | 2595.0 | 2601.0 | 2553.0 | 2596.0 | 17181.0 |
| 2010-07-09 | CB | Futures | 83.294 | 83.536 | 83.294 | 83.487 | 8.0 |
| 2010-07-09 | CC | Futures | 2476.0 | 2523.0 | 2473.0 | 2499.0 | 5140.0 |
| 2010-07-09 | CT | Futures | 65.2 | 65.95 | 64.83 | 65.74 | 60.0 |
| 2010-07-09 | DC | Futures | 23.06 | 23.12 | 22.74 | 22.79 | 105.0 |
| 2010-07-09 | DX | Futures | 84.66 | 84.983 | 84.499 | 84.818 | 16225.0 |
| 2010-07-09 | E1 | Futures | 1.25265 | 1.25318 | 1.24096 | 1.24451 | 30676.0 |
| 2010-07-09 | E6 | Futures | 1.50106 | 1.50449 | 1.49101 | 1.49538 | 247622.0 |
| 2010-07-09 | E7 | Futures | 1.4905 | 1.4937 | 1.4804 | 1.4846 | 3083.0 |
| 2010-07-09 | ED | Futures | 94.3755 | 94.3945 | 94.3755 | 94.385 | 185170.0 |
| 2010-07-09 | ER | Futures | 97.193 | 97.222 | 97.159 | 97.198 | 216218.0 |
| 2010-07-09 | EW | Futures | 716.3 | 723.0 | 712.5 | 719.8 | 20901.0 |
| 2010-07-09 | FBTP | Futures | 65.03 | 65.24 | 64.97 | 65.21 | 3385.0 |
| 2010-07-09 | FCE | Futures | 2349.4 | 2360.9 | 2329.3 | 2337.8 | 124904.0 |
| 2010-07-09 | FDAX | Futures | 6614.3 | 6641.5 | 6575.2 | 6602.9 | 94633.0 |
| 2010-07-09 | FESX | Futures | 1664.3 | 1674.2 | 1649.5 | 1658.2 | 896449.0 |
| 2010-07-09 | FEU3 | Futures | 97.741 | 97.771 | 97.741 | 97.756 | 417.0 |
| 2010-07-09 | FGBL | Futures | 100.58 | 100.81 | 100.35 | 100.66 | 666916.0 |
| 2010-07-09 | FGBM | Futures | 105.07 | 105.12 | 104.78 | 105.0 | 438691.0 |
| 2010-07-09 | FGBS | Futures | 107.377 | 107.382 | 107.225 | 107.308 | 534324.0 |
| 2010-07-09 | FGBX | Futures | 100.3 | 100.8 | 100.03 | 100.69 | 4671.0 |
| 2010-07-09 | FTDX | Futures | 678.7 | 683.1 | 677.8 | 681.8 | 613.0 |
| 2010-07-09 | FTI | Futures | 257.7 | 259.17 | 255.84 | 257.11 | 62256.0 |
| 2010-07-09 | FTUK | Futures | 3506.9 | 3539.2 | 3486.9 | 3516.5 | 77187.0 |
| 2010-07-09 | G | Futures | 81.02 | 81.55 | 80.98 | 81.45 | 81974.0 |
| 2010-07-09 | GF | Futures | 287.602 | 287.981 | 285.708 | 285.96 | 3895.0 |
| 2010-07-09 | GSCI | Futures | 846.28 | 857.38 | 846.28 | 851.23 | 3188.0 |
| 2010-07-09 | HE | Futures | 98.828 | 98.95 | 96.977 | 97.159 | 21426.0 |
| 2010-07-09 | HG | Futures | 4.0573 | 4.1122 | 4.0392 | 4.0895 | 18424.0 |
| 2010-07-09 | HO | Futures | 1.7878 | 1.8103 | 1.7743 | 1.7956 | 17659.0 |
| 2010-07-09 | HRC | Futures | 2851.7 | 2851.7 | 2851.7 | 2851.7 | 0.0 |
| 2010-07-09 | J1 | Futures | 0.014238 | 0.0142481 | 0.014194 | 0.0142179 | 84687.0 |
| 2010-07-09 | J7 | Futures | 0.01412 | 0.014138 | 0.014088 | 0.014111 | 183.0 |
| 2010-07-09 | JB | Futures | 120.46 | 120.46 | 120.24 | 120.27 | 1225.0 |
| 2010-07-09 | KC | Futures | 407.47 | 419.9 | 406.97 | 411.49 | 11136.0 |
| 2010-07-09 | KE | Futures | 2384.24 | 2388.5 | 2337.36 | 2357.6 | 15968.0 |
| 2010-07-09 | L | Futures | 98.046 | 98.066 | 98.026 | 98.056 | 20759.0 |
| 2010-07-09 | LBS | Futures | 627.4 | 631.4 | 606.9 | 613.4 | 218.0 |
> showing 50 of 88 rows — these rows as CSV