PREVIEW / futures_daily / 2012-04-26
file: by_date/futures_daily/2012/2012-04-26.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-26 | ES | Futures | 1397.95 | 1409.04 | 1391.66 | 1407.53 | 1666603.0 |
| 2012-04-26 | NQ | Futures | 3098.6 | 3124.38 | 3087.72 | 3116.64 | 206885.0 |
| 2012-04-26 | YM | Futures | 12682.2 | 12809.6 | 12640.4 | 12798.0 | 117170.0 |
| 2012-04-26 | CL | Futures | 190.7 | 192.46 | 190.48 | 191.79 | 192832.0 |
| 2012-04-26 | GC | Futures | 2198.4 | 2221.8 | 2195.7 | 2219.8 | 130313.0 |
| 2012-04-26 | ZN | Futures | 114.125175 | 114.477163 | 114.016872 | 114.301169 | 1118473.0 |
| 2012-04-26 | A6 | Futures | 0.92708 | 0.93059 | 0.92618 | 0.9305 | 117466.0 |
| 2012-04-26 | AD | Futures | 1.02181 | 1.02483 | 1.0205 | 1.02191 | 87840.0 |
| 2012-04-26 | B | Futures | 107.36 | 108.28 | 107.06 | 108.09 | 149291.0 |
| 2012-04-26 | B6 | Futures | 1.6967 | 1.7005 | 1.6955 | 1.6995 | 96562.0 |
| 2012-04-26 | BFX | Futures | 2685.5 | 2694.2 | 2659.9 | 2661.1 | 19.0 |
| 2012-04-26 | BR | Futures | 0.25123 | 0.25132 | 0.25123 | 0.25132 | 76.0 |
| 2012-04-26 | BZ | Futures | 114.67 | 115.18 | 114.67 | 115.18 | 560.0 |
| 2012-04-26 | C | Futures | 1485.0 | 1505.0 | 1479.0 | 1500.0 | 2422.0 |
| 2012-04-26 | CB | Futures | 75.083 | 75.083 | 73.065 | 73.065 | 31.0 |
| 2012-04-26 | CC | Futures | 1697.0 | 1726.0 | 1690.0 | 1713.0 | 7137.0 |
| 2012-04-26 | CSC | Futures | 3.405 | 3.405 | 3.359 | 3.359 | 52.0 |
| 2012-04-26 | CT | Futures | 110.96 | 112.96 | 110.96 | 112.68 | 9579.0 |
| 2012-04-26 | DC | Futures | 23.56 | 23.71 | 23.2 | 23.27 | 270.0 |
| 2012-04-26 | DX | Futures | 76.639 | 76.707 | 76.445 | 76.543 | 17256.0 |
| 2012-04-26 | E1 | Futures | 1.4411 | 1.4462 | 1.43913 | 1.44293 | 41675.0 |
| 2012-04-26 | E6 | Futures | 1.5785 | 1.58363 | 1.57587 | 1.58065 | 225954.0 |
| 2012-04-26 | E7 | Futures | 1.5634 | 1.5684 | 1.5609 | 1.5655 | 2810.0 |
| 2012-04-26 | EBM | Futures | 286.37 | 288.05 | 282.66 | 284.35 | 9567.0 |
| 2012-04-26 | ED | Futures | 95.0645 | 95.074 | 95.0597 | 95.0693 | 92759.0 |
| 2012-04-26 | ER | Futures | 97.533 | 97.567 | 97.528 | 97.557 | 159028.0 |
| 2012-04-26 | EW | Futures | 994.0 | 1006.3 | 990.1 | 1003.9 | 23378.0 |
| 2012-04-26 | FBTP | Futures | 65.74 | 66.05 | 65.33 | 65.8 | 16525.0 |
| 2012-04-26 | FBTS | Futures | 85.013 | 85.144 | 84.859 | 85.013 | 2271.0 |
| 2012-04-26 | FCE | Futures | 2295.5 | 2314.3 | 2264.4 | 2293.3 | 111721.0 |
| 2012-04-26 | FDAX | Futures | 7412.6 | 7505.4 | 7347.9 | 7455.7 | 139694.0 |
| 2012-04-26 | FESX | Futures | 1563.3 | 1576.4 | 1541.9 | 1561.9 | 1166430.0 |
| 2012-04-26 | FGBL | Futures | 115.12 | 115.67 | 114.96 | 115.55 | 800936.0 |
| 2012-04-26 | FGBM | Futures | 114.51 | 114.81 | 114.44 | 114.76 | 429412.0 |
| 2012-04-26 | FGBS | Futures | 110.143 | 110.203 | 110.123 | 110.198 | 384524.0 |
| 2012-04-26 | FGBX | Futures | 119.11 | 119.74 | 118.4 | 119.61 | 8899.0 |
| 2012-04-26 | FOAT | Futures | 94.78 | 94.97 | 94.53 | 94.89 | 10911.0 |
| 2012-04-26 | FTDX | Futures | 734.9 | 739.1 | 732.6 | 735.4 | 176.0 |
| 2012-04-26 | FTI | Futures | 263.81 | 267.76 | 263.42 | 265.9 | 37613.0 |
| 2012-04-26 | FTUK | Futures | 4153.5 | 4185.6 | 4125.7 | 4165.1 | 92420.0 |
| 2012-04-26 | FVSA | Futures | 9094.01 | 9242.82 | 8895.6 | 9044.41 | 1601.0 |
| 2012-04-26 | FXXP | Futures | 184.0 | 185.0 | 182.7 | 183.9 | 1993.0 |
| 2012-04-26 | G | Futures | 94.57 | 95.11 | 94.33 | 94.9 | 109177.0 |
| 2012-04-26 | GF | Futures | 310.469 | 312.083 | 308.907 | 309.479 | 2780.0 |
| 2012-04-26 | GSCI | Futures | 1078.47 | 1084.74 | 1077.67 | 1082.83 | 99.0 |
| 2012-04-26 | HE | Futures | 95.635 | 96.103 | 94.7 | 95.525 | 481.0 |
| 2012-04-26 | HG | Futures | 4.8685 | 4.966 | 4.8403 | 4.9418 | 47409.0 |
| 2012-04-26 | HO | Futures | 2.6031 | 2.6389 | 2.597 | 2.6293 | 69291.0 |
| 2012-04-26 | HRC | Futures | 2629.4 | 2629.4 | 2629.4 | 2629.4 | 0.0 |
| 2012-04-26 | J1 | Futures | 0.0154278 | 0.0155507 | 0.0154053 | 0.0154968 | 94005.0 |
> showing 50 of 99 rows — these rows as CSV