PREVIEW / futures_daily / 2012-03-23
file: by_date/futures_daily/2012/2012-03-23.parquet size: 9 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-23 | ES | Futures | 1399.72 | 1406.02 | 1391.15 | 1404.76 | 1559341.0 |
| 2012-03-23 | NQ | Futures | 3130.68 | 3146.72 | 3105.76 | 3126.38 | 198235.0 |
| 2012-03-23 | YM | Futures | 12644.3 | 12682.2 | 12576.2 | 12673.5 | 85775.0 |
| 2012-03-23 | CL | Futures | 194.52 | 199.55 | 193.85 | 197.01 | 260269.0 |
| 2012-03-23 | GC | Futures | 2201.7 | 2231.4 | 2198.2 | 2226.2 | 144592.0 |
| 2012-03-23 | ZN | Futures | 111.485269 | 112.026789 | 111.390503 | 111.810181 | 1017129.0 |
| 2012-03-23 | A6 | Futures | 0.92573 | 0.93419 | 0.9242 | 0.93212 | 123035.0 |
| 2012-03-23 | AD | Futures | 1.0046 | 1.00712 | 1.00068 | 1.00581 | 93095.0 |
| 2012-03-23 | B | Futures | 110.77 | 114.15 | 110.59 | 112.42 | 202711.0 |
| 2012-03-23 | B6 | Futures | 1.659 | 1.6688 | 1.6581 | 1.6646 | 80368.0 |
| 2012-03-23 | BFX | Futures | 2836.4 | 2852.7 | 2836.3 | 2850.2 | 68.0 |
| 2012-03-23 | BR | Futures | 0.25788 | 0.25919 | 0.25788 | 0.25876 | 31.0 |
| 2012-03-23 | BZ | Futures | 118.29 | 121.39 | 118.19 | 119.58 | 747.0 |
| 2012-03-23 | C | Futures | 1491.0 | 1496.0 | 1468.0 | 1494.0 | 3941.0 |
| 2012-03-23 | CB | Futures | 82.349 | 82.349 | 81.273 | 81.273 | 13.0 |
| 2012-03-23 | CC | Futures | 1757.0 | 1765.0 | 1728.0 | 1755.0 | 13003.0 |
| 2012-03-23 | CSC | Futures | 3.646 | 3.648 | 3.611 | 3.616 | 58.0 |
| 2012-03-23 | CT | Futures | 112.11 | 113.26 | 111.78 | 112.17 | 8952.0 |
| 2012-03-23 | DC | Futures | 25.61 | 25.69 | 25.0 | 25.33 | 316.0 |
| 2012-03-23 | DX | Futures | 77.409 | 77.521 | 76.857 | 77.1 | 24619.0 |
| 2012-03-23 | E1 | Futures | 1.43495 | 1.44568 | 1.43403 | 1.44254 | 34071.0 |
| 2012-03-23 | E6 | Futures | 1.57647 | 1.58769 | 1.57528 | 1.58411 | 241136.0 |
| 2012-03-23 | E7 | Futures | 1.561 | 1.5723 | 1.5602 | 1.5689 | 4035.0 |
| 2012-03-23 | EBM | Futures | 285.7 | 288.73 | 284.69 | 288.39 | 8546.0 |
| 2012-03-23 | ED | Futures | 95.0549 | 95.074 | 95.0549 | 95.0693 | 95765.0 |
| 2012-03-23 | ER | Futures | 97.538 | 97.557 | 97.538 | 97.548 | 72184.0 |
| 2012-03-23 | EW | Futures | 993.6 | 1002.2 | 985.2 | 1002.0 | 18235.0 |
| 2012-03-23 | FBTP | Futures | 68.25 | 68.57 | 67.65 | 68.3 | 19631.0 |
| 2012-03-23 | FBTS | Futures | 86.096 | 86.136 | 85.884 | 86.071 | 1316.0 |
| 2012-03-23 | FCE | Futures | 2465.4 | 2475.7 | 2433.4 | 2466.8 | 101814.0 |
| 2012-03-23 | FDAX | Futures | 7740.3 | 7784.5 | 7650.8 | 7756.9 | 142980.0 |
| 2012-03-23 | FESX | Futures | 1701.3 | 1708.2 | 1673.7 | 1697.2 | 1134186.0 |
| 2012-03-23 | FGBL | Futures | 112.34 | 112.91 | 112.23 | 112.66 | 794882.0 |
| 2012-03-23 | FGBM | Futures | 113.15 | 113.49 | 113.11 | 113.31 | 435032.0 |
| 2012-03-23 | FGBS | Futures | 109.815 | 109.914 | 109.805 | 109.874 | 450131.0 |
| 2012-03-23 | FGBX | Futures | 116.15 | 117.0 | 115.98 | 116.58 | 5985.0 |
| 2012-03-23 | FTDX | Futures | 734.9 | 741.0 | 731.7 | 736.3 | 65.0 |
| 2012-03-23 | FTI | Futures | 275.61 | 276.54 | 272.64 | 274.67 | 28581.0 |
| 2012-03-23 | FTUK | Futures | 4240.3 | 4252.7 | 4196.9 | 4244.7 | 104043.0 |
| 2012-03-23 | FVSA | Futures | 8033.89 | 8184.52 | 7699.14 | 7715.88 | 5729.0 |
| 2012-03-23 | FXXP | Futures | 189.3 | 190.0 | 187.3 | 189.3 | 2033.0 |
| 2012-03-23 | G | Futures | 92.51 | 93.44 | 92.48 | 93.01 | 126689.0 |
| 2012-03-23 | GF | Futures | 322.402 | 322.925 | 317.012 | 319.053 | 2422.0 |
| 2012-03-23 | GSCI | Futures | 1104.92 | 1121.46 | 1103.97 | 1113.23 | 231.0 |
| 2012-03-23 | HE | Futures | 103.229 | 103.366 | 102.348 | 103.174 | 353.0 |
| 2012-03-23 | HG | Futures | 4.9466 | 5.0147 | 4.9328 | 4.9931 | 51126.0 |
| 2012-03-23 | HO | Futures | 2.6381 | 2.7064 | 2.6381 | 2.6593 | 21455.0 |
| 2012-03-23 | HRC | Futures | 2699.8 | 2699.8 | 2699.8 | 2699.8 | 50.0 |
| 2012-03-23 | J1 | Futures | 0.0151984 | 0.01531 | 0.0151282 | 0.0152122 | 99863.0 |
| 2012-03-23 | J7 | Futures | 0.015116 | 0.015237 | 0.015059 | 0.01514 | 729.0 |
> showing 50 of 98 rows — these rows as CSV