PREVIEW / futures_daily / 2010-07-12
file: by_date/futures_daily/2010/2010-07-12.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-12 | ES | Futures | 1045.09 | 1050.7 | 1039.24 | 1049.97 | 1382638.0 |
| 2010-07-12 | NQ | Futures | 2048.6 | 2070.96 | 2038.7 | 2060.2 | 238450.0 |
| 2010-07-12 | YM | Futures | 9354.1 | 9417.9 | 9317.1 | 9413.2 | 103397.0 |
| 2010-07-12 | CL | Futures | 162.96 | 163.24 | 159.16 | 160.08 | 309169.0 |
| 2010-07-12 | GC | Futures | 1653.7 | 1655.3 | 1631.6 | 1635.1 | 96041.0 |
| 2010-07-12 | ZN | Futures | 99.940115 | 100.273078 | 99.901696 | 100.080984 | 797657.0 |
| 2010-07-12 | A6 | Futures | 0.72143 | 0.72217 | 0.71587 | 0.71952 | 62755.0 |
| 2010-07-12 | AD | Futures | 0.95577 | 0.95824 | 0.95014 | 0.95182 | 62643.0 |
| 2010-07-12 | B | Futures | 66.19 | 66.37 | 64.73 | 65.12 | 112803.0 |
| 2010-07-12 | B6 | Futures | 1.5632 | 1.5655 | 1.5511 | 1.5598 | 118902.0 |
| 2010-07-12 | BFX | Futures | 2811.8 | 2825.4 | 2805.0 | 2816.0 | 344.0 |
| 2010-07-12 | BR | Futures | 0.23419 | 0.23419 | 0.23419 | 0.23419 | 62.0 |
| 2010-07-12 | BZ | Futures | 69.59 | 69.59 | 69.59 | 69.59 | 14.0 |
| 2010-07-12 | C | Futures | 2596.0 | 2619.0 | 2582.0 | 2602.0 | 18788.0 |
| 2010-07-12 | CB | Futures | 83.053 | 83.536 | 83.053 | 83.536 | 15.0 |
| 2010-07-12 | CC | Futures | 2489.0 | 2513.0 | 2469.0 | 2493.0 | 4090.0 |
| 2010-07-12 | CSC | Futures | 3.779 | 3.779 | 3.779 | 3.779 | 1.0 |
| 2010-07-12 | CT | Futures | 65.2 | 65.23 | 64.64 | 64.91 | 157.0 |
| 2010-07-12 | DC | Futures | 22.85 | 23.22 | 22.8 | 23.06 | 288.0 |
| 2010-07-12 | DX | Futures | 84.746 | 85.305 | 84.746 | 85.075 | 12706.0 |
| 2010-07-12 | E1 | Futures | 1.24595 | 1.24661 | 1.23137 | 1.24044 | 38370.0 |
| 2010-07-12 | E6 | Futures | 1.49467 | 1.49574 | 1.48427 | 1.48959 | 184312.0 |
| 2010-07-12 | E7 | Futures | 1.4845 | 1.4848 | 1.4736 | 1.4789 | 2238.0 |
| 2010-07-12 | ED | Futures | 94.3945 | 94.3945 | 94.3613 | 94.3708 | 162549.0 |
| 2010-07-12 | ER | Futures | 97.198 | 97.257 | 97.193 | 97.247 | 153437.0 |
| 2010-07-12 | EW | Futures | 719.3 | 725.9 | 713.1 | 720.7 | 27400.0 |
| 2010-07-12 | FBTP | Futures | 65.19 | 65.28 | 65.14 | 65.17 | 1256.0 |
| 2010-07-12 | FCE | Futures | 2337.8 | 2357.5 | 2325.7 | 2340.8 | 35601.0 |
| 2010-07-12 | FDAX | Futures | 6613.3 | 6664.9 | 6599.1 | 6607.3 | 97770.0 |
| 2010-07-12 | FESX | Futures | 1660.6 | 1672.4 | 1651.3 | 1659.4 | 836596.0 |
| 2010-07-12 | FEU3 | Futures | 97.771 | 97.805 | 97.771 | 97.805 | 506.0 |
| 2010-07-12 | FGBL | Futures | 100.63 | 101.16 | 100.56 | 101.02 | 487381.0 |
| 2010-07-12 | FGBM | Futures | 104.99 | 105.37 | 104.97 | 105.28 | 343489.0 |
| 2010-07-12 | FGBS | Futures | 107.289 | 107.49 | 107.289 | 107.456 | 320978.0 |
| 2010-07-12 | FGBX | Futures | 100.69 | 101.61 | 100.43 | 101.05 | 3052.0 |
| 2010-07-12 | FTDX | Futures | 680.9 | 687.5 | 680.0 | 682.2 | 272.0 |
| 2010-07-12 | FTI | Futures | 257.11 | 259.49 | 256.11 | 258.06 | 8704.0 |
| 2010-07-12 | FTUK | Futures | 3516.5 | 3553.7 | 3506.5 | 3526.1 | 70887.0 |
| 2010-07-12 | G | Futures | 81.33 | 81.55 | 81.21 | 81.43 | 56716.0 |
| 2010-07-12 | GF | Futures | 286.466 | 286.529 | 284.066 | 284.634 | 3699.0 |
| 2010-07-12 | GSCI | Futures | 851.23 | 851.23 | 838.5 | 840.71 | 3330.0 |
| 2010-07-12 | HE | Futures | 97.129 | 97.372 | 96.279 | 96.461 | 20507.0 |
| 2010-07-12 | HG | Futures | 4.0935 | 4.1049 | 3.9977 | 4.0299 | 21321.0 |
| 2010-07-12 | HO | Futures | 1.7968 | 1.804 | 1.7608 | 1.7664 | 14578.0 |
| 2010-07-12 | HRC | Futures | 2875.5 | 2875.5 | 2875.5 | 2875.5 | 0.0 |
| 2010-07-12 | J1 | Futures | 0.0141965 | 0.0142455 | 0.0141222 | 0.0142229 | 90750.0 |
| 2010-07-12 | J7 | Futures | 0.014098 | 0.014137 | 0.014017 | 0.014116 | 128.0 |
| 2010-07-12 | KC | Futures | 408.73 | 412.87 | 399.31 | 410.73 | 7824.0 |
| 2010-07-12 | KE | Futures | 2341.62 | 2377.84 | 2341.62 | 2362.93 | 11760.0 |
| 2010-07-12 | L | Futures | 98.056 | 98.086 | 98.056 | 98.076 | 21700.0 |
> showing 50 of 89 rows — these rows as CSV