PREVIEW / futures_daily / 2012-10-23
file: by_date/futures_daily/2012/2012-10-23.parquet size: 9 KB rows: 100
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-10-23 | ES | Futures | 1456.19 | 1458.74 | 1426.93 | 1431.77 | 2303989.0 |
| 2012-10-23 | NQ | Futures | 3096.3 | 3101.19 | 3050.85 | 3061.2 | 356710.0 |
| 2012-10-23 | YM | Futures | 12980.5 | 13003.0 | 12714.9 | 12734.4 | 179734.0 |
| 2012-10-23 | CL | Futures | 160.65 | 160.92 | 154.44 | 156.2 | 309492.0 |
| 2012-10-23 | GC | Futures | 2309.5 | 2311.4 | 2275.9 | 2282.3 | 153971.0 |
| 2012-10-23 | ZN | Futures | 115.969783 | 116.423004 | 115.956049 | 116.354334 | 854351.0 |
| 2012-10-23 | A6 | Futures | 0.93435 | 0.93544 | 0.92608 | 0.92817 | 112562.0 |
| 2012-10-23 | AD | Futures | 1.01011 | 1.01252 | 1.00489 | 1.00961 | 96022.0 |
| 2012-10-23 | B | Futures | 100.37 | 100.62 | 98.34 | 99.2 | 254992.0 |
| 2012-10-23 | B6 | Futures | 1.6723 | 1.6732 | 1.6615 | 1.6647 | 105007.0 |
| 2012-10-23 | BFX | Futures | 2845.3 | 2845.3 | 2814.1 | 2814.1 | 1.0 |
| 2012-10-23 | BR | Futures | 0.23842 | 0.23842 | 0.23777 | 0.23828 | 82.0 |
| 2012-10-23 | BZ | Futures | 104.37 | 104.37 | 102.08 | 102.94 | 602.0 |
| 2012-10-23 | C | Futures | 1638.0 | 1653.0 | 1629.0 | 1652.0 | 5564.0 |
| 2012-10-23 | CB | Futures | 92.595 | 92.595 | 92.06 | 92.06 | 18.0 |
| 2012-10-23 | CC | Futures | 1885.0 | 1899.0 | 1866.0 | 1884.0 | 13035.0 |
| 2012-10-23 | CSC | Futures | 4.128 | 4.17 | 4.128 | 4.17 | 4.0 |
| 2012-10-23 | CT | Futures | 99.36 | 99.36 | 95.4 | 95.84 | 19274.0 |
| 2012-10-23 | DC | Futures | 31.21 | 31.24 | 30.73 | 30.83 | 289.0 |
| 2012-10-23 | DX | Futures | 77.121 | 77.639 | 77.121 | 77.566 | 21584.0 |
| 2012-10-23 | E1 | Futures | 1.38998 | 1.39101 | 1.37866 | 1.3802 | 30405.0 |
| 2012-10-23 | E6 | Futures | 1.53898 | 1.54051 | 1.52579 | 1.52838 | 245218.0 |
| 2012-10-23 | E7 | Futures | 1.5295 | 1.5312 | 1.5167 | 1.5192 | 3729.0 |
| 2012-10-23 | ED | Futures | 95.2492 | 95.254 | 95.2396 | 95.2444 | 66709.0 |
| 2012-10-23 | ER | Futures | 97.857 | 97.866 | 97.857 | 97.862 | 61560.0 |
| 2012-10-23 | EW | Futures | 1004.4 | 1006.0 | 983.0 | 995.6 | 26015.0 |
| 2012-10-23 | FBTP | Futures | 73.22 | 73.28 | 72.52 | 72.72 | 22218.0 |
| 2012-10-23 | FBTS | Futures | 89.86 | 89.902 | 89.617 | 89.692 | 3078.0 |
| 2012-10-23 | FCE | Futures | 2619.6 | 2623.8 | 2546.4 | 2560.3 | 152904.0 |
| 2012-10-23 | FDAX | Futures | 8039.7 | 8048.5 | 7837.6 | 7863.3 | 157958.0 |
| 2012-10-23 | FESX | Futures | 1723.3 | 1724.6 | 1676.3 | 1684.5 | 1263962.0 |
| 2012-10-23 | FEU3 | Futures | 98.483 | 98.483 | 98.483 | 98.483 | 4.0 |
| 2012-10-23 | FGBL | Futures | 116.9 | 117.42 | 116.9 | 117.3 | 761537.0 |
| 2012-10-23 | FGBM | Futures | 115.55 | 115.79 | 115.54 | 115.75 | 429727.0 |
| 2012-10-23 | FGBS | Futures | 110.178 | 110.218 | 110.173 | 110.208 | 229591.0 |
| 2012-10-23 | FGBX | Futures | 122.34 | 123.41 | 122.34 | 123.01 | 6171.0 |
| 2012-10-23 | FOAT | Futures | 103.71 | 103.71 | 103.53 | 103.62 | 22915.0 |
| 2012-10-23 | FTDX | Futures | 756.6 | 756.6 | 744.8 | 746.7 | 88.0 |
| 2012-10-23 | FTI | Futures | 286.26 | 286.64 | 278.96 | 279.52 | 36051.0 |
| 2012-10-23 | FTUK | Futures | 4299.1 | 4306.8 | 4215.0 | 4223.7 | 113786.0 |
| 2012-10-23 | FVSA | Futures | 5082.29 | 5432.4 | 5082.29 | 5319.47 | 7625.0 |
| 2012-10-23 | FXXP | Futures | 196.6 | 196.6 | 192.7 | 193.0 | 6845.0 |
| 2012-10-23 | G | Futures | 97.96 | 98.63 | 97.94 | 98.52 | 203216.0 |
| 2012-10-23 | GF | Futures | 283.523 | 284.676 | 281.891 | 282.371 | 1329.0 |
| 2012-10-23 | GSCI | Futures | 1034.91 | 1036.04 | 1025.53 | 1032.48 | 188.0 |
| 2012-10-23 | HE | Futures | 97.761 | 97.792 | 96.704 | 97.108 | 17649.0 |
| 2012-10-23 | HG | Futures | 4.6565 | 4.679 | 4.5595 | 4.5871 | 55450.0 |
| 2012-10-23 | HH | Futures | 45.076 | 45.076 | 45.076 | 45.076 | 351.0 |
| 2012-10-23 | HO | Futures | 2.4857 | 2.4927 | 2.4406 | 2.4566 | 84331.0 |
| 2012-10-23 | HRC | Futures | 2446.4 | 2446.4 | 2446.4 | 2446.4 | 25.0 |
> showing 50 of 100 rows — these rows as CSV