PREVIEW / futures_daily / 2012-03-21
file: by_date/futures_daily/2012/2012-03-21.parquet size: 9 KB rows: 96
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-21 | ES | Futures | 1410.8 | 1416.6 | 1405.01 | 1408.28 | 1533579.0 |
| 2012-03-21 | NQ | Futures | 3134.98 | 3149.01 | 3127.82 | 3133.83 | 210535.0 |
| 2012-03-21 | YM | Futures | 12748.4 | 12798.0 | 12683.2 | 12706.6 | 100580.0 |
| 2012-03-21 | CL | Futures | 196.01 | 198.43 | 195.51 | 197.74 | 252603.0 |
| 2012-03-21 | GC | Futures | 2210.6 | 2225.5 | 2204.6 | 2210.0 | 139650.0 |
| 2012-03-21 | ZN | Futures | 110.930212 | 111.458193 | 110.754218 | 111.390503 | 1183847.0 |
| 2012-03-21 | A6 | Futures | 0.93293 | 0.93769 | 0.92816 | 0.93014 | 146062.0 |
| 2012-03-21 | AD | Futures | 1.01286 | 1.01688 | 1.01064 | 1.01165 | 65070.0 |
| 2012-03-21 | B | Futures | 111.59 | 112.12 | 111.19 | 111.58 | 147361.0 |
| 2012-03-21 | B6 | Futures | 1.6638 | 1.6703 | 1.6591 | 1.6635 | 91058.0 |
| 2012-03-21 | BFX | Futures | 2874.7 | 2874.7 | 2856.4 | 2863.8 | 24.0 |
| 2012-03-21 | BR | Futures | 0.25757 | 0.25812 | 0.25642 | 0.25812 | 28.0 |
| 2012-03-21 | BZ | Futures | 118.73 | 119.24 | 118.29 | 118.69 | 741.0 |
| 2012-03-21 | C | Futures | 1525.0 | 1553.0 | 1508.0 | 1516.0 | 8885.0 |
| 2012-03-21 | CB | Futures | 83.156 | 83.156 | 82.618 | 83.156 | 2.0 |
| 2012-03-21 | CC | Futures | 1804.0 | 1838.0 | 1771.0 | 1795.0 | 13264.0 |
| 2012-03-21 | CSC | Futures | 3.714 | 3.714 | 3.692 | 3.692 | 12.0 |
| 2012-03-21 | CT | Futures | 109.96 | 112.0 | 109.96 | 110.52 | 8891.0 |
| 2012-03-21 | DC | Futures | 25.73 | 26.24 | 25.66 | 26.02 | 203.0 |
| 2012-03-21 | DX | Futures | 77.322 | 77.579 | 77.056 | 77.41 | 15810.0 |
| 2012-03-21 | E1 | Futures | 1.43743 | 1.44411 | 1.43246 | 1.43547 | 40112.0 |
| 2012-03-21 | E6 | Futures | 1.57922 | 1.58674 | 1.57396 | 1.57695 | 245811.0 |
| 2012-03-21 | E7 | Futures | 1.5642 | 1.5715 | 1.5589 | 1.5618 | 3670.0 |
| 2012-03-21 | EBM | Futures | 281.32 | 283.0 | 280.31 | 281.32 | 7200.0 |
| 2012-03-21 | ED | Futures | 95.0549 | 95.0645 | 95.0502 | 95.0549 | 149393.0 |
| 2012-03-21 | ER | Futures | 97.553 | 97.567 | 97.543 | 97.553 | 135123.0 |
| 2012-03-21 | EW | Futures | 1004.5 | 1009.7 | 1000.0 | 1003.1 | 24071.0 |
| 2012-03-21 | FBTP | Futures | 69.06 | 69.27 | 68.57 | 68.61 | 11489.0 |
| 2012-03-21 | FBTS | Futures | 86.405 | 86.413 | 86.242 | 86.242 | 1551.0 |
| 2012-03-21 | FCE | Futures | 2511.1 | 2528.9 | 2484.5 | 2502.3 | 97737.0 |
| 2012-03-21 | FDAX | Futures | 7849.2 | 7880.7 | 7766.3 | 7835.9 | 128920.0 |
| 2012-03-21 | FESX | Futures | 1738.6 | 1746.2 | 1712.4 | 1727.6 | 1028187.0 |
| 2012-03-21 | FGBL | Futures | 111.15 | 111.93 | 110.94 | 111.79 | 879764.0 |
| 2012-03-21 | FGBM | Futures | 112.44 | 112.93 | 112.35 | 112.84 | 443911.0 |
| 2012-03-21 | FGBS | Futures | 109.65 | 109.775 | 109.635 | 109.745 | 466179.0 |
| 2012-03-21 | FGBX | Futures | 113.52 | 115.16 | 113.02 | 114.99 | 6520.0 |
| 2012-03-21 | FTDX | Futures | 732.6 | 735.9 | 728.4 | 733.1 | 134.0 |
| 2012-03-21 | FTI | Futures | 280.13 | 281.32 | 277.13 | 278.57 | 30539.0 |
| 2012-03-21 | FTUK | Futures | 4262.2 | 4285.5 | 4254.9 | 4271.7 | 96290.0 |
| 2012-03-21 | FVSA | Futures | 7966.94 | 8067.36 | 7749.35 | 7866.52 | 15944.0 |
| 2012-03-21 | FXXP | Futures | 192.3 | 192.3 | 190.7 | 191.5 | 994.0 |
| 2012-03-21 | G | Futures | 91.62 | 92.27 | 91.4 | 92.24 | 139883.0 |
| 2012-03-21 | GF | Futures | 319.262 | 321.983 | 318.268 | 320.465 | 2335.0 |
| 2012-03-21 | GSCI | Futures | 1110.3 | 1117.18 | 1109.67 | 1111.64 | 396.0 |
| 2012-03-21 | HE | Futures | 102.926 | 103.476 | 102.431 | 103.091 | 286.0 |
| 2012-03-21 | HG | Futures | 5.0331 | 5.0737 | 5.018 | 5.0416 | 37837.0 |
| 2012-03-21 | HO | Futures | 2.6817 | 2.6885 | 2.6607 | 2.6661 | 23935.0 |
| 2012-03-21 | HRC | Futures | 2719.2 | 2719.2 | 2719.2 | 2719.2 | 0.0 |
| 2012-03-21 | J1 | Futures | 0.0149902 | 0.0150655 | 0.0149213 | 0.0150341 | 111565.0 |
| 2012-03-21 | J7 | Futures | 0.014921 | 0.014993 | 0.014852 | 0.014963 | 551.0 |
> showing 50 of 96 rows — these rows as CSV