PREVIEW / futures_daily / 2011-04-21
file: by_date/futures_daily/2011/2011-04-21.parquet size: 9 KB rows: 92
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-21 | ES | Futures | 1315.23 | 1324.39 | 1314.73 | 1317.7 | 1276072.0 |
| 2011-04-21 | NQ | Futures | 2683.22 | 2713.68 | 2683.22 | 2705.42 | 242215.0 |
| 2011-04-21 | YM | Futures | 11658.2 | 11722.1 | 11647.8 | 11690.1 | 67200.0 |
| 2011-04-21 | CL | Futures | 214.62 | 216.76 | 213.91 | 216.39 | 240462.0 |
| 2011-04-21 | GC | Futures | 2033.0 | 2043.3 | 2030.8 | 2035.4 | 127269.0 |
| 2011-04-21 | ZN | Futures | 100.987082 | 101.329456 | 100.921241 | 101.118764 | 680740.0 |
| 2011-04-21 | A6 | Futures | 0.91214 | 0.91848 | 0.91016 | 0.916 | 73781.0 |
| 2011-04-21 | AD | Futures | 1.04412 | 1.05179 | 1.04272 | 1.04462 | 61958.0 |
| 2011-04-21 | B | Futures | 105.06 | 105.87 | 104.5 | 105.17 | 125848.0 |
| 2011-04-21 | B6 | Futures | 1.7024 | 1.7235 | 1.7013 | 1.7181 | 138520.0 |
| 2011-04-21 | BFX | Futures | 3177.4 | 3182.9 | 3158.9 | 3158.9 | 44.0 |
| 2011-04-21 | BR | Futures | 0.27722 | 0.27722 | 0.27722 | 0.27722 | 1027.0 |
| 2011-04-21 | BZ | Futures | 111.19 | 111.25 | 110.18 | 110.89 | 966.0 |
| 2011-04-21 | C | Futures | 2104.0 | 2116.0 | 2066.0 | 2070.0 | 2853.0 |
| 2011-04-21 | CC | Futures | 2444.0 | 2484.0 | 2436.0 | 2458.0 | 5150.0 |
| 2011-04-21 | CSC | Futures | 4.451 | 4.451 | 4.412 | 4.412 | 8.0 |
| 2011-04-21 | CT | Futures | 163.91 | 168.85 | 161.45 | 166.92 | 9736.0 |
| 2011-04-21 | DC | Futures | 29.52 | 29.55 | 29.0 | 29.14 | 192.0 |
| 2011-04-21 | DX | Futures | 73.825 | 74.163 | 73.566 | 73.81 | 23833.0 |
| 2011-04-21 | E1 | Futures | 1.47385 | 1.49166 | 1.47294 | 1.48276 | 48388.0 |
| 2011-04-21 | E6 | Futures | 1.71811 | 1.73303 | 1.71598 | 1.72403 | 276678.0 |
| 2011-04-21 | E7 | Futures | 1.7053 | 1.7203 | 1.7033 | 1.7112 | 5779.0 |
| 2011-04-21 | EBM | Futures | 238.13 | 238.13 | 233.91 | 236.96 | 4695.0 |
| 2011-04-21 | ED | Futures | 94.9216 | 94.9264 | 94.9216 | 94.9264 | 58633.0 |
| 2011-04-21 | ER | Futures | 97.227 | 97.272 | 97.217 | 97.262 | 165827.0 |
| 2011-04-21 | EW | Futures | 981.4 | 988.8 | 981.1 | 985.1 | 15546.0 |
| 2011-04-21 | FBTP | Futures | 64.51 | 64.56 | 64.22 | 64.33 | 5384.0 |
| 2011-04-21 | FCE | Futures | 2690.9 | 2700.1 | 2683.4 | 2692.2 | 87725.0 |
| 2011-04-21 | FDAX | Futures | 7800.5 | 7832.0 | 7787.7 | 7809.1 | 92588.0 |
| 2011-04-21 | FESX | Futures | 1838.2 | 1845.9 | 1830.5 | 1838.2 | 830257.0 |
| 2011-04-21 | FEU3 | Futures | 97.765 | 97.81 | 97.765 | 97.805 | 765.0 |
| 2011-04-21 | FGBL | Futures | 97.41 | 97.94 | 97.36 | 97.87 | 782295.0 |
| 2011-04-21 | FGBM | Futures | 102.67 | 103.03 | 102.6 | 102.99 | 538197.0 |
| 2011-04-21 | FGBS | Futures | 106.206 | 106.394 | 106.196 | 106.38 | 528877.0 |
| 2011-04-21 | FGBX | Futures | 93.11 | 93.75 | 92.91 | 93.63 | 3619.0 |
| 2011-04-21 | FTDX | Futures | 823.4 | 829.2 | 817.2 | 818.5 | 1583.0 |
| 2011-04-21 | FTI | Futures | 294.65 | 296.38 | 291.89 | 292.55 | 23004.0 |
| 2011-04-21 | FTUK | Futures | 4211.0 | 4217.3 | 4176.7 | 4186.1 | 66784.0 |
| 2011-04-21 | FXXP | Futures | 184.6 | 185.2 | 184.6 | 185.2 | 365.0 |
| 2011-04-21 | G | Futures | 81.96 | 82.37 | 81.86 | 82.32 | 89816.0 |
| 2011-04-21 | GF | Futures | 322.489 | 323.392 | 317.135 | 320.023 | 1243.0 |
| 2011-04-21 | GSCI | Futures | 1174.7 | 1177.04 | 1167.59 | 1177.04 | 39.0 |
| 2011-04-21 | HE | Futures | 109.31 | 109.576 | 107.849 | 108.434 | 514.0 |
| 2011-04-21 | HG | Futures | 5.7952 | 5.8749 | 5.7666 | 5.8709 | 16209.0 |
| 2011-04-21 | HO | Futures | 2.6866 | 2.7037 | 2.6591 | 2.6724 | 41446.0 |
| 2011-04-21 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-04-21 | J1 | Futures | 0.0152151 | 0.0153973 | 0.0152151 | 0.0153672 | 114869.0 |
| 2011-04-21 | J7 | Futures | 0.015143 | 0.015301 | 0.015143 | 0.015273 | 691.0 |
| 2011-04-21 | JB | Futures | 121.33 | 121.89 | 121.33 | 121.63 | 45.0 |
| 2011-04-21 | KC | Futures | 717.36 | 720.71 | 704.41 | 706.33 | 7965.0 |
> showing 50 of 92 rows — these rows as CSV