PREVIEW / futures_daily / 2010-08-09
file: by_date/futures_daily/2010/2010-08-09.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-08-09 | ES | Futures | 1092.4 | 1098.98 | 1088.98 | 1097.76 | 998906.0 |
| 2010-08-09 | NQ | Futures | 2153.86 | 2170.84 | 2148.77 | 2166.03 | 184344.0 |
| 2010-08-09 | YM | Futures | 9815.4 | 9876.5 | 9791.4 | 9861.7 | 70004.0 |
| 2010-08-09 | CL | Futures | 171.78 | 173.59 | 171.36 | 172.99 | 267083.0 |
| 2010-08-09 | GC | Futures | 1639.7 | 1647.6 | 1632.6 | 1634.6 | 69569.0 |
| 2010-08-09 | ZN | Futures | 102.104374 | 102.245243 | 102.001924 | 102.053149 | 606807.0 |
| 2010-08-09 | A6 | Futures | 0.75839 | 0.75997 | 0.75558 | 0.75674 | 49025.0 |
| 2010-08-09 | AD | Futures | 0.9614 | 0.96248 | 0.95853 | 0.9616 | 50462.0 |
| 2010-08-09 | B | Futures | 70.21 | 71.01 | 70.08 | 70.74 | 69550.0 |
| 2010-08-09 | B6 | Futures | 1.6593 | 1.6597 | 1.649 | 1.6495 | 60045.0 |
| 2010-08-09 | BFX | Futures | 2941.9 | 2946.4 | 2924.7 | 2938.4 | 39.0 |
| 2010-08-09 | BR | Futures | 0.23722 | 0.23722 | 0.23722 | 0.23722 | 53.0 |
| 2010-08-09 | BZ | Futures | 75.91 | 76.11 | 75.91 | 76.11 | 45.0 |
| 2010-08-09 | C | Futures | 2371.0 | 2391.0 | 2342.0 | 2382.0 | 5331.0 |
| 2010-08-09 | CB | Futures | 88.847 | 90.537 | 88.847 | 90.537 | 26.0 |
| 2010-08-09 | CC | Futures | 2524.0 | 2528.0 | 2474.0 | 2516.0 | 6148.0 |
| 2010-08-09 | CT | Futures | 70.83 | 70.92 | 70.47 | 70.81 | 30.0 |
| 2010-08-09 | DC | Futures | 23.49 | 23.8 | 23.49 | 23.74 | 298.0 |
| 2010-08-09 | DX | Futures | 81.122 | 81.48 | 80.981 | 81.429 | 11857.0 |
| 2010-08-09 | E1 | Futures | 1.26591 | 1.26631 | 1.25121 | 1.25252 | 29959.0 |
| 2010-08-09 | E6 | Futures | 1.57082 | 1.57354 | 1.56267 | 1.56385 | 165319.0 |
| 2010-08-09 | E7 | Futures | 1.5601 | 1.5621 | 1.5514 | 1.5526 | 1417.0 |
| 2010-08-09 | ED | Futures | 94.5321 | 94.5369 | 94.5274 | 94.5321 | 118605.0 |
| 2010-08-09 | ER | Futures | 97.227 | 97.237 | 97.213 | 97.232 | 76071.0 |
| 2010-08-09 | EW | Futures | 756.3 | 762.9 | 754.0 | 761.9 | 16061.0 |
| 2010-08-09 | FBTP | Futures | 66.92 | 67.13 | 66.92 | 67.03 | 1471.0 |
| 2010-08-09 | FCE | Futures | 2469.0 | 2487.7 | 2466.7 | 2478.2 | 63923.0 |
| 2010-08-09 | FDAX | Futures | 6885.8 | 6934.2 | 6876.0 | 6913.0 | 70317.0 |
| 2010-08-09 | FESX | Futures | 1741.7 | 1757.8 | 1738.0 | 1749.1 | 617549.0 |
| 2010-08-09 | FEU3 | Futures | 97.785 | 97.79 | 97.785 | 97.79 | 1.0 |
| 2010-08-09 | FGBL | Futures | 101.58 | 101.64 | 101.51 | 101.56 | 338449.0 |
| 2010-08-09 | FGBM | Futures | 105.44 | 105.48 | 105.39 | 105.47 | 195424.0 |
| 2010-08-09 | FGBS | Futures | 107.397 | 107.46 | 107.382 | 107.451 | 207217.0 |
| 2010-08-09 | FGBX | Futures | 102.1 | 102.17 | 101.54 | 101.7 | 3419.0 |
| 2010-08-09 | FTDX | Futures | 680.5 | 686.7 | 680.5 | 682.7 | 264.0 |
| 2010-08-09 | FTI | Futures | 265.02 | 267.6 | 264.98 | 266.85 | 17013.0 |
| 2010-08-09 | FTUK | Futures | 3702.3 | 3726.1 | 3696.1 | 3706.1 | 66648.0 |
| 2010-08-09 | G | Futures | 82.29 | 82.38 | 82.18 | 82.23 | 38353.0 |
| 2010-08-09 | GF | Futures | 284.318 | 284.318 | 282.929 | 283.624 | 639.0 |
| 2010-08-09 | GSCI | Futures | 910.64 | 913.35 | 905.63 | 909.79 | 3584.0 |
| 2010-08-09 | HE | Futures | 97.252 | 98.108 | 96.495 | 96.56 | 17191.0 |
| 2010-08-09 | HG | Futures | 4.4999 | 4.5455 | 4.4678 | 4.4919 | 26577.0 |
| 2010-08-09 | HO | Futures | 1.8832 | 1.9054 | 1.8798 | 1.8875 | 44765.0 |
| 2010-08-09 | HRC | Futures | 2729.3 | 2729.3 | 2729.3 | 2729.3 | 0.0 |
| 2010-08-09 | J1 | Futures | 0.0147349 | 0.0147538 | 0.0146418 | 0.0146544 | 65507.0 |
| 2010-08-09 | J7 | Futures | 0.014635 | 0.014635 | 0.01454 | 0.014544 | 89.0 |
| 2010-08-09 | JB | Futures | 120.84 | 121.1 | 120.82 | 121.06 | 1903.0 |
| 2010-08-09 | KC | Futures | 420.65 | 428.94 | 417.51 | 425.93 | 15058.0 |
| 2010-08-09 | KE | Futures | 2989.35 | 3174.72 | 2943.54 | 3068.19 | 19394.0 |
| 2010-08-09 | L | Futures | 98.096 | 98.106 | 98.086 | 98.096 | 7054.0 |
> showing 50 of 90 rows — these rows as CSV