PREVIEW / futures_daily / 2012-04-05
file: by_date/futures_daily/2012/2012-04-05.parquet size: 9 KB rows: 99
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-04-05 | ES | Futures | 1404.0 | 1408.54 | 1394.68 | 1400.98 | 1539342.0 |
| 2012-04-05 | NQ | Futures | 3137.55 | 3163.05 | 3119.22 | 3155.03 | 225937.0 |
| 2012-04-05 | YM | Futures | 12643.3 | 12679.3 | 12573.3 | 12621.0 | 93919.0 |
| 2012-04-05 | CL | Futures | 187.96 | 190.61 | 186.87 | 190.44 | 242903.0 |
| 2012-04-05 | GC | Futures | 2168.3 | 2185.4 | 2166.5 | 2179.1 | 128046.0 |
| 2012-04-05 | ZN | Futures | 112.21632 | 112.879681 | 112.108016 | 112.608922 | 1133784.0 |
| 2012-04-05 | A6 | Futures | 0.91619 | 0.92159 | 0.9152 | 0.91862 | 109448.0 |
| 2012-04-05 | AD | Futures | 1.00853 | 1.01406 | 1.00471 | 1.01084 | 101925.0 |
| 2012-04-05 | B | Futures | 110.38 | 111.24 | 109.66 | 111.09 | 146903.0 |
| 2012-04-05 | B6 | Futures | 1.6673 | 1.669 | 1.658 | 1.6608 | 88674.0 |
| 2012-04-05 | BFX | Futures | 2762.4 | 2773.4 | 2726.2 | 2751.8 | 61.0 |
| 2012-04-05 | BR | Futures | 0.25793 | 0.25793 | 0.25793 | 0.25793 | 25.0 |
| 2012-04-05 | BZ | Futures | 116.21 | 117.55 | 116.0 | 117.5 | 1004.0 |
| 2012-04-05 | C | Futures | 1395.0 | 1439.0 | 1390.0 | 1422.0 | 10495.0 |
| 2012-04-05 | CB | Futures | 78.312 | 78.582 | 78.312 | 78.582 | 17.0 |
| 2012-04-05 | CC | Futures | 1591.0 | 1621.0 | 1579.0 | 1589.0 | 15427.0 |
| 2012-04-05 | CSC | Futures | 3.65 | 3.65 | 3.62 | 3.623 | 50.0 |
| 2012-04-05 | CT | Futures | 111.92 | 113.18 | 110.38 | 110.81 | 13718.0 |
| 2012-04-05 | DC | Futures | 25.53 | 25.53 | 25.15 | 25.19 | 246.0 |
| 2012-04-05 | DX | Futures | 77.429 | 77.865 | 77.308 | 77.795 | 24833.0 |
| 2012-04-05 | E1 | Futures | 1.43089 | 1.43311 | 1.42107 | 1.4246 | 47650.0 |
| 2012-04-05 | E6 | Futures | 1.56943 | 1.57205 | 1.55665 | 1.56 | 233636.0 |
| 2012-04-05 | E7 | Futures | 1.5544 | 1.557 | 1.5418 | 1.545 | 3601.0 |
| 2012-04-05 | EBM | Futures | 280.98 | 286.03 | 279.97 | 284.69 | 8779.0 |
| 2012-04-05 | ED | Futures | 95.0502 | 95.0549 | 95.0263 | 95.0406 | 166780.0 |
| 2012-04-05 | ER | Futures | 97.494 | 97.518 | 97.484 | 97.499 | 113429.0 |
| 2012-04-05 | EW | Futures | 996.3 | 999.3 | 988.8 | 990.9 | 18357.0 |
| 2012-04-05 | FBTP | Futures | 66.79 | 67.13 | 65.97 | 66.62 | 19418.0 |
| 2012-04-05 | FBTS | Futures | 85.062 | 85.201 | 84.631 | 84.916 | 3807.0 |
| 2012-04-05 | FCE | Futures | 2356.8 | 2367.1 | 2323.5 | 2352.6 | 128718.0 |
| 2012-04-05 | FDAX | Futures | 7532.5 | 7564.0 | 7401.0 | 7506.0 | 168974.0 |
| 2012-04-05 | FESX | Futures | 1612.3 | 1618.5 | 1584.7 | 1605.4 | 1353279.0 |
| 2012-04-05 | FEU3 | Futures | 98.073 | 98.073 | 98.073 | 98.073 | 30.0 |
| 2012-04-05 | FGBL | Futures | 113.61 | 114.29 | 113.46 | 114.1 | 748991.0 |
| 2012-04-05 | FGBM | Futures | 113.93 | 114.35 | 113.85 | 114.25 | 458298.0 |
| 2012-04-05 | FGBS | Futures | 109.984 | 110.108 | 109.959 | 110.089 | 557602.0 |
| 2012-04-05 | FGBX | Futures | 117.93 | 118.79 | 117.34 | 118.47 | 7473.0 |
| 2012-04-05 | FTDX | Futures | 726.5 | 738.7 | 722.3 | 730.2 | 272.0 |
| 2012-04-05 | FTI | Futures | 265.45 | 265.88 | 261.61 | 265.16 | 39881.0 |
| 2012-04-05 | FTUK | Futures | 4133.4 | 4147.3 | 4095.5 | 4141.8 | 112405.0 |
| 2012-04-05 | FVSA | Futures | 8368.63 | 8937.7 | 8218.0 | 8552.74 | 951.0 |
| 2012-04-05 | FXXP | Futures | 185.0 | 185.3 | 182.7 | 184.7 | 2129.0 |
| 2012-04-05 | G | Futures | 93.68 | 94.47 | 93.67 | 94.06 | 110021.0 |
| 2012-04-05 | GF | Futures | 311.412 | 312.093 | 310.418 | 311.308 | 1497.0 |
| 2012-04-05 | GSCI | Futures | 1080.3 | 1090.91 | 1078.64 | 1090.2 | 138.0 |
| 2012-04-05 | HE | Futures | 102.733 | 103.696 | 102.513 | 103.696 | 311.0 |
| 2012-04-05 | HG | Futures | 4.9708 | 5.0174 | 4.9485 | 4.9761 | 46385.0 |
| 2012-04-05 | HO | Futures | 2.6158 | 2.6262 | 2.5898 | 2.6129 | 21133.0 |
| 2012-04-05 | HRC | Futures | 2680.3 | 2680.3 | 2680.3 | 2680.3 | 0.0 |
| 2012-04-05 | J1 | Futures | 0.0152197 | 0.0153338 | 0.0152134 | 0.0152335 | 96100.0 |
> showing 50 of 99 rows — these rows as CSV