PREVIEW / futures_daily / 2010-03-22
file: by_date/futures_daily/2010/2010-03-22.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-03-22 | ES | Futures | 1123.02 | 1132.76 | 1116.69 | 1131.54 | 1915804.0 |
| 2010-03-22 | NQ | Futures | 2186.34 | 2216.97 | 2176.98 | 2210.44 | 282045.0 |
| 2010-03-22 | YM | Futures | 9801.2 | 9881.2 | 9759.9 | 9861.0 | 117736.0 |
| 2010-03-22 | CL | Futures | 189.19 | 191.46 | 184.51 | 190.92 | 351220.0 |
| 2010-03-22 | GC | Futures | 1520.2 | 1521.0 | 1498.4 | 1508.6 | 159063.0 |
| 2010-03-22 | ZN | Futures | 95.448204 | 95.792552 | 95.397189 | 95.728784 | 598549.0 |
| 2010-03-22 | A6 | Futures | 0.74414 | 0.74676 | 0.73856 | 0.74578 | 86517.0 |
| 2010-03-22 | AD | Futures | 0.97126 | 0.97284 | 0.96356 | 0.96781 | 67768.0 |
| 2010-03-22 | B | Futures | 71.25 | 72.31 | 69.81 | 72.08 | 153978.0 |
| 2010-03-22 | B6 | Futures | 1.5571 | 1.5677 | 1.5493 | 1.5659 | 90963.0 |
| 2010-03-22 | BFX | Futures | 2961.3 | 2970.4 | 2930.1 | 2968.6 | 265.0 |
| 2010-03-22 | BR | Futures | 0.22312 | 0.22333 | 0.22103 | 0.22333 | 118.0 |
| 2010-03-22 | BZ | Futures | 74.18 | 75.88 | 73.42 | 75.8 | 70.0 |
| 2010-03-22 | C | Futures | 2203.0 | 2223.0 | 2166.0 | 2222.0 | 3348.0 |
| 2010-03-22 | CB | Futures | 73.531 | 74.024 | 73.531 | 73.531 | 6.0 |
| 2010-03-22 | CC | Futures | 2407.0 | 2453.0 | 2355.0 | 2432.0 | 6924.0 |
| 2010-03-22 | CT | Futures | 66.91 | 67.33 | 66.43 | 67.08 | 6155.0 |
| 2010-03-22 | DC | Futures | 22.46 | 22.57 | 21.89 | 22.12 | 400.0 |
| 2010-03-22 | DX | Futures | 82.057 | 82.432 | 81.859 | 81.964 | 19510.0 |
| 2010-03-22 | E1 | Futures | 1.24222 | 1.24722 | 1.23564 | 1.2438 | 52519.0 |
| 2010-03-22 | E6 | Futures | 1.6007 | 1.60519 | 1.59266 | 1.60224 | 303153.0 |
| 2010-03-22 | E7 | Futures | 1.5872 | 1.592 | 1.5797 | 1.5891 | 4011.0 |
| 2010-03-22 | EBM | Futures | 208.09 | 208.91 | 207.27 | 208.09 | 5420.0 |
| 2010-03-22 | ED | Futures | 94.3471 | 94.3755 | 94.3423 | 94.3708 | 163618.0 |
| 2010-03-22 | ER | Futures | 97.34 | 97.38 | 97.335 | 97.37 | 129546.0 |
| 2010-03-22 | EW | Futures | 759.8 | 772.0 | 755.8 | 770.7 | 25278.0 |
| 2010-03-22 | FBTP | Futures | 64.33 | 64.48 | 64.24 | 64.43 | 4503.0 |
| 2010-03-22 | FCE | Futures | 2505.4 | 2520.5 | 2475.4 | 2514.7 | 125915.0 |
| 2010-03-22 | FDAX | Futures | 6491.5 | 6540.9 | 6436.5 | 6515.4 | 144437.0 |
| 2010-03-22 | FESX | Futures | 1723.3 | 1732.5 | 1700.0 | 1723.9 | 1176671.0 |
| 2010-03-22 | FEU3 | Futures | 97.904 | 97.929 | 97.904 | 97.929 | 511.0 |
| 2010-03-22 | FGBL | Futures | 96.12 | 96.53 | 96.09 | 96.44 | 640475.0 |
| 2010-03-22 | FGBM | Futures | 101.66 | 101.94 | 101.65 | 101.88 | 397742.0 |
| 2010-03-22 | FGBS | Futures | 106.233 | 106.351 | 106.233 | 106.336 | 365382.0 |
| 2010-03-22 | FGBX | Futures | 90.29 | 91.1 | 90.29 | 90.95 | 3394.0 |
| 2010-03-22 | FTDX | Futures | 724.8 | 724.8 | 711.9 | 718.1 | 552.0 |
| 2010-03-22 | FTI | Futures | 272.09 | 273.23 | 268.85 | 272.54 | 37288.0 |
| 2010-03-22 | FTUK | Futures | 3780.5 | 3798.5 | 3745.3 | 3785.9 | 110014.0 |
| 2010-03-22 | G | Futures | 76.79 | 76.97 | 76.7 | 76.9 | 53513.0 |
| 2010-03-22 | GF | Futures | 283.643 | 284.948 | 279.207 | 280.381 | 1169.0 |
| 2010-03-22 | GSCI | Futures | 948.55 | 964.56 | 942.2 | 963.36 | 934.0 |
| 2010-03-22 | HE | Futures | 97.426 | 97.914 | 96.877 | 97.457 | 194.0 |
| 2010-03-22 | HG | Futures | 4.6138 | 4.6316 | 4.523 | 4.6186 | 30277.0 |
| 2010-03-22 | HO | Futures | 1.9092 | 1.9299 | 1.8717 | 1.9257 | 9671.0 |
| 2010-03-22 | HRC | Futures | 3037.7 | 3037.7 | 3037.7 | 3037.7 | 0.0 |
| 2010-03-22 | J1 | Futures | 0.013902 | 0.0140051 | 0.013858 | 0.0139573 | 90370.0 |
| 2010-03-22 | J7 | Futures | 0.013794 | 0.013891 | 0.01375 | 0.013846 | 58.0 |
| 2010-03-22 | KC | Futures | 339.27 | 343.25 | 336.06 | 341.58 | 8396.0 |
| 2010-03-22 | KE | Futures | 2181.29 | 2215.64 | 2171.32 | 2189.05 | 4761.0 |
| 2010-03-22 | L | Futures | 97.848 | 97.868 | 97.838 | 97.858 | 29349.0 |
> showing 50 of 90 rows — these rows as CSV