PREVIEW / futures_daily / 2010-06-22
file: by_date/futures_daily/2010/2010-06-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-06-22 | ES | Futures | 1083.13 | 1089.47 | 1062.65 | 1063.62 | 2286571.0 |
| 2010-06-22 | NQ | Futures | 2149.34 | 2169.43 | 2123.87 | 2125.85 | 335379.0 |
| 2010-06-22 | YM | Futures | 9608.3 | 9661.0 | 9452.1 | 9461.3 | 159221.0 |
| 2010-06-22 | CL | Futures | 166.76 | 168.51 | 165.16 | 166.27 | 285495.0 |
| 2010-06-22 | GC | Futures | 1682.3 | 1696.9 | 1681.9 | 1692.5 | 122705.0 |
| 2010-06-22 | ZN | Futures | 98.595457 | 99.171739 | 98.416169 | 99.094901 | 966898.0 |
| 2010-06-22 | A6 | Futures | 0.71878 | 0.72524 | 0.71505 | 0.71704 | 101162.0 |
| 2010-06-22 | AD | Futures | 0.96387 | 0.9695 | 0.95853 | 0.95952 | 73852.0 |
| 2010-06-22 | B | Futures | 69.11 | 69.43 | 68.06 | 68.48 | 118822.0 |
| 2010-06-22 | B6 | Futures | 1.532 | 1.5423 | 1.5243 | 1.5372 | 143731.0 |
| 2010-06-22 | BFX | Futures | 2895.2 | 2913.5 | 2881.3 | 2895.5 | 73.0 |
| 2010-06-22 | BR | Futures | 0.23031 | 0.23031 | 0.23031 | 0.23031 | 217.0 |
| 2010-06-22 | BZ | Futures | 73.66 | 74.84 | 73.64 | 73.85 | 166.0 |
| 2010-06-22 | C | Futures | 2449.0 | 2504.0 | 2444.0 | 2500.0 | 2000.0 |
| 2010-06-22 | CB | Futures | 83.053 | 83.053 | 83.053 | 83.053 | 15.0 |
| 2010-06-22 | CC | Futures | 2483.0 | 2574.0 | 2434.0 | 2548.0 | 12146.0 |
| 2010-06-22 | CSC | Futures | 3.628 | 3.628 | 3.59 | 3.616 | 8.0 |
| 2010-06-22 | CT | Futures | 65.17 | 65.61 | 64.82 | 65.54 | 3014.0 |
| 2010-06-22 | DC | Futures | 21.99 | 22.06 | 21.83 | 21.91 | 162.0 |
| 2010-06-22 | DX | Futures | 86.893 | 87.23 | 86.726 | 87.092 | 15331.0 |
| 2010-06-22 | E1 | Futures | 1.18291 | 1.19197 | 1.18278 | 1.18777 | 36873.0 |
| 2010-06-22 | E6 | Futures | 1.45801 | 1.4618 | 1.4495 | 1.45127 | 282277.0 |
| 2010-06-22 | E7 | Futures | 1.4472 | 1.451 | 1.4392 | 1.4408 | 3318.0 |
| 2010-06-22 | ED | Futures | 94.2759 | 94.2854 | 94.2474 | 94.2616 | 179470.0 |
| 2010-06-22 | ER | Futures | 97.262 | 97.301 | 97.257 | 97.296 | 163779.0 |
| 2010-06-22 | EW | Futures | 751.6 | 757.4 | 733.3 | 733.5 | 30626.0 |
| 2010-06-22 | FBTP | Futures | 65.24 | 65.24 | 64.88 | 65.05 | 4542.0 |
| 2010-06-22 | FCE | Futures | 2441.8 | 2449.7 | 2392.8 | 2435.9 | 147222.0 |
| 2010-06-22 | FDAX | Futures | 6833.0 | 6856.4 | 6744.9 | 6824.3 | 142246.0 |
| 2010-06-22 | FESX | Futures | 1701.5 | 1707.7 | 1663.7 | 1697.1 | 1174537.0 |
| 2010-06-22 | FEU3 | Futures | 97.825 | 97.859 | 97.825 | 97.85 | 371.0 |
| 2010-06-22 | FGBL | Futures | 99.69 | 100.33 | 99.56 | 100.05 | 895737.0 |
| 2010-06-22 | FGBM | Futures | 104.63 | 105.01 | 104.58 | 104.86 | 483835.0 |
| 2010-06-22 | FGBS | Futures | 107.524 | 107.662 | 107.505 | 107.628 | 532307.0 |
| 2010-06-22 | FGBX | Futures | 97.62 | 99.2 | 97.41 | 98.66 | 4175.0 |
| 2010-06-22 | FTDX | Futures | 695.0 | 696.4 | 680.9 | 687.1 | 979.0 |
| 2010-06-22 | FTI | Futures | 268.48 | 269.78 | 264.83 | 269.27 | 30953.0 |
| 2010-06-22 | FTUK | Futures | 3586.0 | 3610.1 | 3530.3 | 3592.2 | 107286.0 |
| 2010-06-22 | G | Futures | 80.45 | 80.9 | 80.18 | 80.54 | 107031.0 |
| 2010-06-22 | GF | Futures | 282.55 | 285.392 | 281.476 | 282.487 | 2763.0 |
| 2010-06-22 | GSCI | Futures | 866.26 | 876.5 | 865.57 | 869.59 | 139.0 |
| 2010-06-22 | HE | Futures | 102.761 | 103.511 | 101.666 | 102.542 | 7778.0 |
| 2010-06-22 | HG | Futures | 3.9488 | 4.0379 | 3.9241 | 4.0319 | 13488.0 |
| 2010-06-22 | HO | Futures | 1.9074 | 1.9125 | 1.8833 | 1.8877 | 15465.0 |
| 2010-06-22 | HRC | Futures | 2994.3 | 2994.3 | 2994.3 | 2994.3 | 0.0 |
| 2010-06-22 | J1 | Futures | 0.0138379 | 0.0139461 | 0.0138266 | 0.0139197 | 111354.0 |
| 2010-06-22 | J7 | Futures | 0.013735 | 0.013839 | 0.013725 | 0.013815 | 124.0 |
| 2010-06-22 | JB | Futures | 119.54 | 119.95 | 119.54 | 119.93 | 2108.0 |
| 2010-06-22 | KC | Futures | 401.19 | 407.97 | 395.41 | 403.7 | 12457.0 |
| 2010-06-22 | KE | Futures | 2169.38 | 2172.64 | 2146.56 | 2147.64 | 9669.0 |
> showing 50 of 91 rows — these rows as CSV