PREVIEW / futures_daily / 2012-04-24
file: by_date/futures_daily/2012/2012-04-24.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-24 | ES | Futures | 1373.52 | 1381.83 | 1371.5 | 1380.57 | 1440903.0 |
| 2012-04-24 | NQ | Futures | 3037.59 | 3054.49 | 3007.23 | 3016.11 | 265558.0 |
| 2012-04-24 | YM | Futures | 12515.9 | 12637.5 | 12515.9 | 12602.5 | 110151.0 |
| 2012-04-24 | CL | Futures | 189.14 | 190.96 | 188.56 | 189.95 | 196136.0 |
| 2012-04-24 | GC | Futures | 2191.8 | 2205.8 | 2185.1 | 2197.4 | 107793.0 |
| 2012-04-24 | ZN | Futures | 114.328245 | 114.463625 | 114.071024 | 114.179327 | 867154.0 |
| 2012-04-24 | A6 | Futures | 0.92303 | 0.92348 | 0.91601 | 0.92006 | 124723.0 |
| 2012-04-24 | AD | Futures | 1.01426 | 1.01819 | 1.01205 | 1.01638 | 81132.0 |
| 2012-04-24 | B | Futures | 107.4 | 107.57 | 106.58 | 106.86 | 173505.0 |
| 2012-04-24 | B6 | Futures | 1.6921 | 1.6959 | 1.6902 | 1.6931 | 89152.0 |
| 2012-04-24 | BFX | Futures | 2631.1 | 2639.0 | 2631.1 | 2639.0 | 2.0 |
| 2012-04-24 | BR | Futures | 0.25194 | 0.25239 | 0.25161 | 0.25218 | 72.0 |
| 2012-04-24 | BZ | Futures | 113.42 | 113.74 | 112.78 | 113.04 | 583.0 |
| 2012-04-24 | C | Futures | 1454.0 | 1504.0 | 1452.0 | 1492.0 | 3629.0 |
| 2012-04-24 | CB | Futures | 77.263 | 77.263 | 76.953 | 76.967 | 29.0 |
| 2012-04-24 | CC | Futures | 1662.0 | 1743.0 | 1652.0 | 1722.0 | 17443.0 |
| 2012-04-24 | CSC | Futures | 3.407 | 3.474 | 3.382 | 3.474 | 45.0 |
| 2012-04-24 | CT | Futures | 113.13 | 113.6 | 110.16 | 111.89 | 15412.0 |
| 2012-04-24 | DC | Futures | 23.13 | 23.97 | 23.05 | 23.84 | 647.0 |
| 2012-04-24 | DX | Futures | 77.022 | 77.06 | 76.721 | 76.858 | 16024.0 |
| 2012-04-24 | E1 | Futures | 1.43468 | 1.44123 | 1.43298 | 1.43809 | 37128.0 |
| 2012-04-24 | E6 | Futures | 1.57134 | 1.57838 | 1.56955 | 1.57492 | 224930.0 |
| 2012-04-24 | E7 | Futures | 1.556 | 1.5631 | 1.5545 | 1.5598 | 3233.0 |
| 2012-04-24 | EBM | Futures | 290.08 | 290.75 | 289.06 | 289.06 | 5435.0 |
| 2012-04-24 | ED | Futures | 95.0549 | 95.0645 | 95.0502 | 95.0597 | 109319.0 |
| 2012-04-24 | ER | Futures | 97.508 | 97.523 | 97.503 | 97.518 | 67784.0 |
| 2012-04-24 | EW | Futures | 974.5 | 981.5 | 972.0 | 977.9 | 20528.0 |
| 2012-04-24 | FBTP | Futures | 65.06 | 65.62 | 65.02 | 65.39 | 17611.0 |
| 2012-04-24 | FBTS | Futures | 84.68 | 84.883 | 84.59 | 84.826 | 2112.0 |
| 2012-04-24 | FCE | Futures | 2202.3 | 2254.0 | 2201.2 | 2246.4 | 126708.0 |
| 2012-04-24 | FDAX | Futures | 7259.5 | 7308.6 | 7199.2 | 7300.9 | 146806.0 |
| 2012-04-24 | FESX | Futures | 1515.7 | 1538.5 | 1506.7 | 1537.1 | 1198121.0 |
| 2012-04-24 | FGBL | Futures | 115.73 | 115.77 | 115.2 | 115.3 | 832015.0 |
| 2012-04-24 | FGBM | Futures | 114.77 | 114.8 | 114.46 | 114.53 | 389246.0 |
| 2012-04-24 | FGBS | Futures | 110.163 | 110.173 | 110.089 | 110.113 | 323333.0 |
| 2012-04-24 | FGBX | Futures | 120.65 | 120.65 | 119.57 | 119.76 | 12956.0 |
| 2012-04-24 | FOAT | Futures | 94.1 | 94.57 | 93.91 | 94.32 | 16719.0 |
| 2012-04-24 | FTDX | Futures | 712.5 | 718.5 | 712.5 | 718.1 | 98.0 |
| 2012-04-24 | FTI | Futures | 258.91 | 260.56 | 257.09 | 260.08 | 29827.0 |
| 2012-04-24 | FTUK | Futures | 4111.2 | 4139.2 | 4096.2 | 4136.0 | 77679.0 |
| 2012-04-24 | FVSA | Futures | 9590.05 | 9722.32 | 9424.7 | 9540.44 | 2868.0 |
| 2012-04-24 | FXXP | Futures | 180.8 | 181.9 | 180.1 | 181.9 | 1835.0 |
| 2012-04-24 | G | Futures | 94.58 | 94.97 | 94.47 | 94.79 | 150780.0 |
| 2012-04-24 | GF | Futures | 314.114 | 315.26 | 307.969 | 307.969 | 2825.0 |
| 2012-04-24 | GSCI | Futures | 1072.59 | 1077.04 | 1068.86 | 1070.93 | 79.0 |
| 2012-04-24 | HE | Futures | 96.461 | 96.626 | 94.782 | 95.305 | 456.0 |
| 2012-04-24 | HG | Futures | 4.7617 | 4.8403 | 4.7591 | 4.8207 | 31627.0 |
| 2012-04-24 | HO | Futures | 2.5836 | 2.5883 | 2.5676 | 2.5768 | 52346.0 |
| 2012-04-24 | HRC | Futures | 2649.1 | 2649.1 | 2649.1 | 2649.1 | 0.0 |
| 2012-04-24 | J1 | Futures | 0.0154517 | 0.0155156 | 0.0154115 | 0.0154379 | 70241.0 |
> showing 50 of 99 rows — these rows as CSV