PREVIEW / futures_daily / 2010-04-23
file: by_date/futures_daily/2010/2010-04-23.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-04-23 | ES | Futures | 1169.76 | 1181.93 | 1166.11 | 1180.47 | 1856101.0 |
| 2010-04-23 | NQ | Futures | 2306.3 | 2329.56 | 2302.05 | 2328.99 | 289715.0 |
| 2010-04-23 | YM | Futures | 10169.9 | 10252.6 | 10146.0 | 10242.5 | 119246.0 |
| 2010-04-23 | CL | Futures | 193.66 | 196.99 | 191.74 | 196.82 | 322550.0 |
| 2010-04-23 | GC | Futures | 1566.6 | 1589.5 | 1557.5 | 1582.9 | 144453.0 |
| 2010-04-23 | ZN | Futures | 95.371682 | 95.473711 | 94.938058 | 95.052841 | 1081544.0 |
| 2010-04-23 | A6 | Futures | 0.75628 | 0.75735 | 0.74832 | 0.7553 | 116603.0 |
| 2010-04-23 | AD | Futures | 0.98666 | 0.99021 | 0.98064 | 0.98706 | 97395.0 |
| 2010-04-23 | B | Futures | 76.34 | 77.97 | 76.08 | 77.9 | 146004.0 |
| 2010-04-23 | B6 | Futures | 1.597 | 1.5989 | 1.5875 | 1.5956 | 131350.0 |
| 2010-04-23 | BFX | Futures | 2960.1 | 2982.0 | 2955.5 | 2979.1 | 50.0 |
| 2010-04-23 | BR | Futures | 0.23037 | 0.23037 | 0.23037 | 0.23037 | 190.0 |
| 2010-04-23 | BZ | Futures | 80.3 | 81.69 | 79.89 | 81.62 | 55.0 |
| 2010-04-23 | C | Futures | 2275.0 | 2332.0 | 2274.0 | 2317.0 | 5369.0 |
| 2010-04-23 | CB | Futures | 79.452 | 79.465 | 79.452 | 79.465 | 1.0 |
| 2010-04-23 | CC | Futures | 2637.0 | 2697.0 | 2621.0 | 2686.0 | 8521.0 |
| 2010-04-23 | CT | Futures | 67.19 | 68.57 | 67.18 | 68.52 | 2762.0 |
| 2010-04-23 | DC | Futures | 22.0 | 22.57 | 21.98 | 22.49 | 125.0 |
| 2010-04-23 | DX | Futures | 83.212 | 83.298 | 82.538 | 82.587 | 24640.0 |
| 2010-04-23 | E1 | Futures | 1.22182 | 1.22893 | 1.2134 | 1.22787 | 62922.0 |
| 2010-04-23 | E6 | Futures | 1.57231 | 1.58544 | 1.56178 | 1.58378 | 422184.0 |
| 2010-04-23 | E7 | Futures | 1.5593 | 1.5723 | 1.5489 | 1.5708 | 6400.0 |
| 2010-04-23 | EBM | Futures | 217.53 | 219.17 | 214.66 | 215.07 | 6642.0 |
| 2010-04-23 | ED | Futures | 94.3565 | 94.3708 | 94.3518 | 94.3613 | 232755.0 |
| 2010-04-23 | ER | Futures | 97.35 | 97.365 | 97.345 | 97.36 | 160079.0 |
| 2010-04-23 | EW | Futures | 815.4 | 826.8 | 813.1 | 824.5 | 25410.0 |
| 2010-04-23 | FBTP | Futures | 64.57 | 64.69 | 64.51 | 64.57 | 7042.0 |
| 2010-04-23 | FCE | Futures | 2498.8 | 2528.0 | 2482.6 | 2513.1 | 135877.0 |
| 2010-04-23 | FDAX | Futures | 6753.6 | 6846.0 | 6716.1 | 6811.2 | 181879.0 |
| 2010-04-23 | FESX | Futures | 1736.1 | 1755.7 | 1721.4 | 1744.1 | 1285715.0 |
| 2010-04-23 | FEU3 | Futures | 97.919 | 97.919 | 97.914 | 97.919 | 660.0 |
| 2010-04-23 | FGBL | Futures | 96.73 | 96.86 | 96.44 | 96.75 | 989744.0 |
| 2010-04-23 | FGBM | Futures | 102.26 | 102.35 | 102.03 | 102.24 | 670425.0 |
| 2010-04-23 | FGBS | Futures | 106.61 | 106.64 | 106.503 | 106.561 | 664928.0 |
| 2010-04-23 | FGBX | Futures | 92.4 | 92.56 | 91.95 | 92.38 | 3926.0 |
| 2010-04-23 | FTDX | Futures | 746.0 | 749.5 | 741.6 | 742.9 | 449.0 |
| 2010-04-23 | FTI | Futures | 285.38 | 286.93 | 283.39 | 285.38 | 36826.0 |
| 2010-04-23 | FTUK | Futures | 3822.8 | 3870.9 | 3803.9 | 3840.1 | 108292.0 |
| 2010-04-23 | G | Futures | 76.22 | 76.34 | 75.81 | 75.93 | 110230.0 |
| 2010-04-23 | GF | Futures | 292.307 | 293.989 | 290.818 | 291.401 | 2056.0 |
| 2010-04-23 | GSCI | Futures | 980.0 | 998.15 | 980.0 | 998.15 | 287.0 |
| 2010-04-23 | HE | Futures | 108.991 | 108.991 | 104.963 | 106.672 | 1403.0 |
| 2010-04-23 | HG | Futures | 4.7799 | 4.8139 | 4.7229 | 4.7942 | 16755.0 |
| 2010-04-23 | HO | Futures | 2.0381 | 2.0764 | 2.0288 | 2.0732 | 36568.0 |
| 2010-04-23 | J1 | Futures | 0.0134607 | 0.0134783 | 0.0133274 | 0.0133765 | 126095.0 |
| 2010-04-23 | J7 | Futures | 0.013352 | 0.013369 | 0.013226 | 0.01327 | 212.0 |
| 2010-04-23 | JB | Futures | 118.46 | 118.5 | 118.29 | 118.41 | 1828.0 |
| 2010-04-23 | KC | Futures | 334.23 | 338.04 | 332.71 | 334.99 | 9752.0 |
| 2010-04-23 | KE | Futures | 2254.41 | 2265.49 | 2221.17 | 2241.11 | 4359.0 |
| 2010-04-23 | L | Futures | 97.858 | 97.868 | 97.838 | 97.848 | 49680.0 |
> showing 50 of 90 rows — these rows as CSV