PREVIEW / futures_daily / 2010-04-22
file: by_date/futures_daily/2010/2010-04-22.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-04-22 | ES | Futures | 1167.08 | 1175.36 | 1155.15 | 1170.25 | 2668931.0 |
| 2010-04-22 | NQ | Futures | 2292.69 | 2319.92 | 2269.43 | 2309.99 | 374013.0 |
| 2010-04-22 | YM | Futures | 10157.0 | 10203.9 | 10078.8 | 10174.5 | 151218.0 |
| 2010-04-22 | CL | Futures | 193.01 | 194.4 | 188.98 | 193.54 | 433947.0 |
| 2010-04-22 | GC | Futures | 1573.7 | 1577.6 | 1553.1 | 1568.1 | 138485.0 |
| 2010-04-22 | ZN | Futures | 95.639508 | 95.843566 | 95.282406 | 95.358928 | 1160061.0 |
| 2010-04-22 | A6 | Futures | 0.75595 | 0.75907 | 0.75283 | 0.75718 | 114881.0 |
| 2010-04-22 | AD | Futures | 0.98785 | 0.99091 | 0.98311 | 0.98794 | 100237.0 |
| 2010-04-22 | B | Futures | 76.5 | 77.05 | 75.13 | 76.49 | 212791.0 |
| 2010-04-22 | B6 | Futures | 1.5997 | 1.6063 | 1.5923 | 1.5972 | 137354.0 |
| 2010-04-22 | BFX | Futures | 3001.2 | 3001.2 | 2957.5 | 2965.7 | 244.0 |
| 2010-04-22 | BR | Futures | 0.23012 | 0.23012 | 0.23012 | 0.23012 | 111.0 |
| 2010-04-22 | BZ | Futures | 79.37 | 80.3 | 78.73 | 80.15 | 56.0 |
| 2010-04-22 | C | Futures | 2251.0 | 2279.0 | 2234.0 | 2275.0 | 5069.0 |
| 2010-04-22 | CB | Futures | 78.465 | 78.959 | 78.465 | 78.959 | 17.0 |
| 2010-04-22 | CC | Futures | 2593.0 | 2643.0 | 2570.0 | 2637.0 | 11250.0 |
| 2010-04-22 | CT | Futures | 67.54 | 68.13 | 66.72 | 67.02 | 4097.0 |
| 2010-04-22 | DC | Futures | 22.41 | 22.57 | 21.98 | 22.18 | 104.0 |
| 2010-04-22 | DX | Futures | 82.407 | 83.02 | 82.224 | 82.773 | 21185.0 |
| 2010-04-22 | E1 | Futures | 1.23064 | 1.2338 | 1.21879 | 1.223 | 74468.0 |
| 2010-04-22 | E6 | Futures | 1.58414 | 1.58804 | 1.56852 | 1.57515 | 448260.0 |
| 2010-04-22 | E7 | Futures | 1.5712 | 1.5749 | 1.5557 | 1.5622 | 5288.0 |
| 2010-04-22 | EBM | Futures | 215.07 | 217.94 | 214.25 | 217.12 | 4883.0 |
| 2010-04-22 | ED | Futures | 94.385 | 94.3944 | 94.3565 | 94.366 | 310705.0 |
| 2010-04-22 | ER | Futures | 97.389 | 97.394 | 97.35 | 97.37 | 185172.0 |
| 2010-04-22 | EW | Futures | 805.9 | 819.1 | 798.8 | 815.7 | 30573.0 |
| 2010-04-22 | FBTP | Futures | 64.77 | 64.82 | 64.54 | 64.64 | 8883.0 |
| 2010-04-22 | FCE | Futures | 2527.0 | 2548.7 | 2482.6 | 2495.9 | 179476.0 |
| 2010-04-22 | FDAX | Futures | 6780.8 | 6845.0 | 6684.5 | 6727.5 | 229397.0 |
| 2010-04-22 | FESX | Futures | 1759.4 | 1772.9 | 1721.4 | 1733.7 | 1832241.0 |
| 2010-04-22 | FEU3 | Futures | 97.943 | 97.943 | 97.929 | 97.929 | 1014.0 |
| 2010-04-22 | FGBL | Futures | 96.59 | 97.01 | 96.49 | 96.78 | 1261161.0 |
| 2010-04-22 | FGBM | Futures | 102.24 | 102.45 | 102.11 | 102.32 | 707233.0 |
| 2010-04-22 | FGBS | Futures | 106.61 | 106.674 | 106.551 | 106.63 | 651505.0 |
| 2010-04-22 | FGBX | Futures | 91.77 | 92.58 | 91.51 | 92.42 | 5110.0 |
| 2010-04-22 | FTDX | Futures | 746.4 | 757.1 | 741.1 | 743.8 | 675.0 |
| 2010-04-22 | FTI | Futures | 285.38 | 287.91 | 282.17 | 283.55 | 49194.0 |
| 2010-04-22 | FTUK | Futures | 3835.7 | 3870.5 | 3795.4 | 3811.3 | 139789.0 |
| 2010-04-22 | G | Futures | 76.05 | 76.43 | 75.97 | 76.27 | 149381.0 |
| 2010-04-22 | GF | Futures | 292.889 | 293.278 | 290.624 | 291.919 | 1879.0 |
| 2010-04-22 | GSCI | Futures | 975.28 | 986.89 | 968.66 | 985.44 | 118.0 |
| 2010-04-22 | HE | Futures | 107.373 | 108.716 | 106.489 | 107.862 | 1378.0 |
| 2010-04-22 | HG | Futures | 4.7983 | 4.8248 | 4.7297 | 4.7616 | 14157.0 |
| 2010-04-22 | HO | Futures | 2.0329 | 2.0514 | 2.0043 | 2.0413 | 49293.0 |
| 2010-04-22 | HRC | Futures | 3130.4 | 3130.4 | 3130.4 | 3130.4 | 0.0 |
| 2010-04-22 | J1 | Futures | 0.0135009 | 0.0135638 | 0.0134343 | 0.0134733 | 151444.0 |
| 2010-04-22 | J7 | Futures | 0.013407 | 0.013453 | 0.01333 | 0.013366 | 239.0 |
| 2010-04-22 | JB | Futures | 118.3 | 118.46 | 118.27 | 118.34 | 1898.0 |
| 2010-04-22 | KC | Futures | 333.47 | 335.37 | 330.68 | 333.72 | 12200.0 |
| 2010-04-22 | KE | Futures | 2208.99 | 2263.27 | 2186.83 | 2261.06 | 6544.0 |
> showing 50 of 91 rows — these rows as CSV