PREVIEW / futures_daily / 2013-07-25
file: by_date/futures_daily/2013/2013-07-25.parquet size: 9 KB rows: 101
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-25 | ES | Futures | 1734.46 | 1737.03 | 1721.84 | 1734.46 | 1425052.0 |
| 2013-07-25 | NQ | Futures | 3530.98 | 3537.63 | 3502.06 | 3528.09 | 214945.0 |
| 2013-07-25 | YM | Futures | 15361.0 | 15366.9 | 15261.8 | 15347.1 | 121975.0 |
| 2013-07-25 | CL | Futures | 184.03 | 184.9 | 181.77 | 184.24 | 270580.0 |
| 2013-07-25 | GC | Futures | 1753.9 | 1775.6 | 1736.9 | 1764.0 | 176485.0 |
| 2013-07-25 | ZN | Futures | 113.587632 | 113.798187 | 113.278817 | 113.461298 | 1201656.0 |
| 2013-07-25 | A6 | Futures | 0.85719 | 0.86789 | 0.85344 | 0.86151 | 97015.0 |
| 2013-07-25 | AD | Futures | 0.9756 | 0.98124 | 0.9751 | 0.97832 | 59141.0 |
| 2013-07-25 | B | Futures | 104.17 | 104.91 | 103.62 | 104.7 | 176110.0 |
| 2013-07-25 | B6 | Futures | 1.6056 | 1.618 | 1.5998 | 1.6099 | 123420.0 |
| 2013-07-25 | BFX | Futures | 3170.4 | 3173.2 | 3170.4 | 3173.2 | 5.0 |
| 2013-07-25 | BR | Futures | 0.21851 | 0.21962 | 0.21705 | 0.21811 | 214.0 |
| 2013-07-25 | BZ | Futures | 104.66 | 105.61 | 104.35 | 105.4 | 4913.0 |
| 2013-07-25 | C | Futures | 1683.0 | 1710.0 | 1681.0 | 1688.0 | 5283.0 |
| 2013-07-25 | CB | Futures | 75.106 | 75.525 | 75.106 | 75.465 | 3.0 |
| 2013-07-25 | CC | Futures | 1757.0 | 1779.0 | 1750.0 | 1754.0 | 9664.0 |
| 2013-07-25 | CT | Futures | 102.86 | 102.86 | 102.65 | 102.65 | 8.0 |
| 2013-07-25 | DC | Futures | 27.08 | 27.1 | 26.84 | 27.02 | 163.0 |
| 2013-07-25 | DX | Futures | 78.797 | 78.845 | 78.09 | 78.418 | 26389.0 |
| 2013-07-25 | E1 | Futures | 1.37195 | 1.38519 | 1.36848 | 1.38005 | 31765.0 |
| 2013-07-25 | E6 | Futures | 1.55798 | 1.56943 | 1.55397 | 1.56318 | 232162.0 |
| 2013-07-25 | E7 | Futures | 1.5479 | 1.5591 | 1.5438 | 1.553 | 3863.0 |
| 2013-07-25 | ED | Futures | 95.2869 | 95.2964 | 95.2869 | 95.2869 | 98433.0 |
| 2013-07-25 | ER | Futures | 97.808 | 97.817 | 97.803 | 97.817 | 50111.0 |
| 2013-07-25 | EW | Futures | 1253.0 | 1257.0 | 1243.0 | 1254.0 | 13924.0 |
| 2013-07-25 | FBTP | Futures | 77.7 | 77.93 | 77.65 | 77.72 | 20593.0 |
| 2013-07-25 | FBTS | Futures | 93.1 | 93.126 | 93.023 | 93.04 | 5042.0 |
| 2013-07-25 | FCE | Futures | 3067.5 | 3079.1 | 3031.5 | 3059.7 | 88510.0 |
| 2013-07-25 | FDAX | Futures | 9293.5 | 9295.1 | 9175.3 | 9210.2 | 98903.0 |
| 2013-07-25 | FESX | Futures | 1932.3 | 1935.8 | 1908.5 | 1922.5 | 774713.0 |
| 2013-07-25 | FGBL | Futures | 119.29 | 119.57 | 119.03 | 119.13 | 797579.0 |
| 2013-07-25 | FGBM | Futures | 117.08 | 117.29 | 117.02 | 117.08 | 474207.0 |
| 2013-07-25 | FGBS | Futures | 110.268 | 110.328 | 110.258 | 110.288 | 356456.0 |
| 2013-07-25 | FGBX | Futures | 123.77 | 124.23 | 123.08 | 123.11 | 10084.0 |
| 2013-07-25 | FMWO | Futures | 4947.1 | 4952.2 | 4947.1 | 4952.2 | 48.0 |
| 2013-07-25 | FOAT | Futures | 106.33 | 106.64 | 106.24 | 106.28 | 44193.0 |
| 2013-07-25 | FTDX | Futures | 937.1 | 937.1 | 928.7 | 930.1 | 48.0 |
| 2013-07-25 | FTI | Futures | 324.0 | 324.27 | 320.85 | 322.91 | 22909.0 |
| 2013-07-25 | FTUK | Futures | 4930.9 | 4936.2 | 4868.7 | 4904.7 | 86373.0 |
| 2013-07-25 | FVSA | Futures | 2666.83 | 2773.51 | 2666.83 | 2745.06 | 3969.0 |
| 2013-07-25 | FXXP | Futures | 221.1 | 221.3 | 218.8 | 220.2 | 3391.0 |
| 2013-07-25 | G | Futures | 94.6 | 94.8 | 94.24 | 94.62 | 139528.0 |
| 2013-07-25 | GF | Futures | 257.83 | 258.63 | 255.766 | 256.693 | 3025.0 |
| 2013-07-25 | GSCI | Futures | 1050.2 | 1050.69 | 1042.02 | 1048.56 | 284.0 |
| 2013-07-25 | HE | Futures | 102.066 | 102.918 | 101.601 | 101.834 | 16848.0 |
| 2013-07-25 | HG | Futures | 4.0387 | 4.0546 | 3.9968 | 4.0419 | 46680.0 |
| 2013-07-25 | HH | Futures | 41.192 | 41.192 | 40.134 | 40.178 | 2664.0 |
| 2013-07-25 | HO | Futures | 2.4473 | 2.4503 | 2.4133 | 2.4413 | 51981.0 |
| 2013-07-25 | HRC | Futures | 2249.0 | 2249.0 | 2249.0 | 2249.0 | 100.0 |
| 2013-07-25 | J1 | Futures | 0.0125502 | 0.0127288 | 0.0125288 | 0.0126408 | 128998.0 |
> showing 50 of 101 rows — these rows as CSV