PREVIEW / futures_daily / 2011-04-25
file: by_date/futures_daily/2011/2011-04-25.parquet size: 8 KB rows: 72
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-25 | ES | Futures | 1317.21 | 1321.91 | 1313.99 | 1317.46 | 599322.0 |
| 2011-04-25 | NQ | Futures | 2702.58 | 2713.11 | 2701.15 | 2707.7 | 115169.0 |
| 2011-04-25 | YM | Futures | 11688.3 | 11723.1 | 11648.8 | 11683.6 | 41009.0 |
| 2011-04-25 | CL | Futures | 216.49 | 218.69 | 214.06 | 216.37 | 209683.0 |
| 2011-04-25 | GC | Futures | 2044.7 | 2056.3 | 2033.2 | 2042.6 | 123686.0 |
| 2011-04-25 | ZN | Futures | 101.145101 | 101.434801 | 101.07926 | 101.408465 | 375081.0 |
| 2011-04-25 | A6 | Futures | 0.91685 | 0.91874 | 0.91068 | 0.91394 | 40155.0 |
| 2011-04-25 | AD | Futures | 1.04332 | 1.04651 | 1.04014 | 1.04223 | 37822.0 |
| 2011-04-25 | B | Futures | 105.17 | 105.56 | 103.83 | 104.63 | 19361.0 |
| 2011-04-25 | B6 | Futures | 1.7147 | 1.7185 | 1.7098 | 1.7137 | 34404.0 |
| 2011-04-25 | BR | Futures | 0.28026 | 0.28026 | 0.27766 | 0.27885 | 1448.0 |
| 2011-04-25 | BZ | Futures | 110.89 | 111.24 | 110.25 | 110.25 | 231.0 |
| 2011-04-25 | CB | Futures | 118.509 | 118.509 | 117.922 | 118.509 | 2.0 |
| 2011-04-25 | CC | Futures | 2458.0 | 2481.0 | 2417.0 | 2436.0 | 4051.0 |
| 2011-04-25 | CSC | Futures | 4.405 | 4.405 | 4.386 | 4.397 | 5.0 |
| 2011-04-25 | CT | Futures | 166.92 | 170.67 | 163.53 | 164.69 | 5868.0 |
| 2011-04-25 | DC | Futures | 29.22 | 29.38 | 29.02 | 29.19 | 158.0 |
| 2011-04-25 | DX | Futures | 73.929 | 74.098 | 73.641 | 73.811 | 15273.0 |
| 2011-04-25 | E1 | Futures | 1.48001 | 1.4931 | 1.47608 | 1.48708 | 19504.0 |
| 2011-04-25 | E6 | Futures | 1.72308 | 1.73043 | 1.71846 | 1.72545 | 103252.0 |
| 2011-04-25 | E7 | Futures | 1.7105 | 1.7175 | 1.7057 | 1.7126 | 2493.0 |
| 2011-04-25 | ED | Futures | 94.9216 | 94.9264 | 94.9121 | 94.9216 | 67939.0 |
| 2011-04-25 | EW | Futures | 985.2 | 989.2 | 981.7 | 985.8 | 15760.0 |
| 2011-04-25 | GF | Futures | 319.361 | 319.361 | 312.803 | 312.803 | 1965.0 |
| 2011-04-25 | GSCI | Futures | 1183.29 | 1183.76 | 1165.01 | 1173.13 | 144.0 |
| 2011-04-25 | HE | Futures | 107.929 | 107.955 | 106.255 | 106.946 | 639.0 |
| 2011-04-25 | HG | Futures | 5.8609 | 5.8716 | 5.6862 | 5.744 | 18950.0 |
| 2011-04-25 | HO | Futures | 2.6724 | 2.6885 | 2.633 | 2.658 | 44822.0 |
| 2011-04-25 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-04-25 | J1 | Futures | 0.0153596 | 0.015386 | 0.015244 | 0.0153659 | 55398.0 |
| 2011-04-25 | J7 | Futures | 0.015242 | 0.015291 | 0.015153 | 0.015272 | 500.0 |
| 2011-04-25 | JB | Futures | 121.69 | 121.72 | 121.54 | 121.59 | 32.0 |
| 2011-04-25 | KC | Futures | 711.72 | 711.96 | 693.26 | 697.33 | 7208.0 |
| 2011-04-25 | KE | Futures | 3743.3 | 3847.96 | 3743.3 | 3835.13 | 15111.0 |
| 2011-04-25 | LBS | Futures | 555.9 | 566.4 | 550.8 | 560.7 | 615.0 |
| 2011-04-25 | LE | Futures | 174.644 | 175.288 | 170.63 | 170.857 | 32104.0 |
| 2011-04-25 | MFS | Futures | 1458.5 | 1459.7 | 1451.8 | 1458.9 | 628.0 |
| 2011-04-25 | MGC | Futures | 2029.8 | 2041.8 | 2019.6 | 2028.6 | 1070.0 |
| 2011-04-25 | MME | Futures | 1046.3 | 1047.0 | 1035.6 | 1038.6 | 451.0 |
| 2011-04-25 | MP | Futures | 0.04782 | 0.04801 | 0.04777 | 0.04792 | 10043.0 |
| 2011-04-25 | N6 | Futures | 0.65476 | 0.65632 | 0.65091 | 0.65312 | 2562.0 |
| 2011-04-25 | NG | Futures | 115.494 | 116.398 | 113.763 | 115.029 | 69167.0 |
| 2011-04-25 | NIY | Futures | 7879.3 | 7920.0 | 7826.5 | 7846.9 | 4011.0 |
| 2011-04-25 | NKD | Futures | 9035.9 | 9110.6 | 9003.2 | 9026.6 | 2372.0 |
| 2011-04-25 | NOK | Futures | 0.182721 | 0.182721 | 0.182721 | 0.182721 | 33.0 |
| 2011-04-25 | OJ | Futures | 105.47 | 106.79 | 104.06 | 104.87 | 1114.0 |
| 2011-04-25 | PA | Futures | 852.77 | 857.68 | 826.46 | 839.31 | 3211.0 |
| 2011-04-25 | PJY | Futures | 110.57 | 110.63 | 109.67 | 109.85 | 53.0 |
| 2011-04-25 | PL | Futures | 2088.8 | 2115.9 | 2077.1 | 2096.6 | 3384.0 |
| 2011-04-25 | QG | Futures | 118.733 | 120.067 | 117.399 | 118.733 | 747.0 |
> showing 50 of 72 rows — these rows as CSV