PREVIEW / futures_daily / 2011-05-31
file: by_date/futures_daily/2011/2011-05-31.parquet size: 9 KB rows: 95
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-05-31 | ES | Futures | 1316.47 | 1332.31 | 1314.98 | 1330.57 | 1927228.0 |
| 2011-05-31 | NQ | Futures | 2655.03 | 2707.99 | 2654.46 | 2701.15 | 251027.0 |
| 2011-05-31 | YM | Futures | 11678.9 | 11822.7 | 11677.0 | 11806.7 | 106814.0 |
| 2011-05-31 | CL | Futures | 193.44 | 198.62 | 191.34 | 197.3 | 319037.0 |
| 2011-05-31 | GC | Futures | 2081.7 | 2086.8 | 2074.9 | 2079.9 | 114703.0 |
| 2011-05-31 | ZN | Futures | 104.410819 | 104.608343 | 104.134287 | 104.529333 | 507364.0 |
| 2011-05-31 | A6 | Futures | 0.91711 | 0.92106 | 0.91119 | 0.91299 | 109380.0 |
| 2011-05-31 | AD | Futures | 1.01833 | 1.03107 | 1.01693 | 1.02739 | 106171.0 |
| 2011-05-31 | B | Futures | 97.71 | 100.23 | 97.71 | 99.57 | 68025.0 |
| 2011-05-31 | B6 | Futures | 1.712 | 1.7189 | 1.7059 | 1.7089 | 114378.0 |
| 2011-05-31 | BFX | Futures | 3137.0 | 3181.2 | 3137.0 | 3176.0 | 159.0 |
| 2011-05-31 | BR | Futures | 0.27439 | 0.27764 | 0.27394 | 0.27671 | 84.0 |
| 2011-05-31 | BZ | Futures | 103.83 | 103.83 | 103.83 | 103.83 | 328.0 |
| 2011-05-31 | C | Futures | 1975.0 | 2007.0 | 1968.0 | 2001.0 | 7582.0 |
| 2011-05-31 | CB | Futures | 119.176 | 119.176 | 119.176 | 119.176 | 2.0 |
| 2011-05-31 | CC | Futures | 2368.0 | 2404.0 | 2361.0 | 2387.0 | 9353.0 |
| 2011-05-31 | CT | Futures | 151.88 | 157.05 | 151.83 | 157.05 | 6429.0 |
| 2011-05-31 | DC | Futures | 31.38 | 31.71 | 31.23 | 31.63 | 94.0 |
| 2011-05-31 | DX | Futures | 74.457 | 74.466 | 74.123 | 74.323 | 25833.0 |
| 2011-05-31 | E1 | Futures | 1.53841 | 1.54652 | 1.53225 | 1.53461 | 50540.0 |
| 2011-05-31 | E6 | Futures | 1.69477 | 1.70828 | 1.68838 | 1.70318 | 339937.0 |
| 2011-05-31 | E7 | Futures | 1.6826 | 1.6957 | 1.6758 | 1.6905 | 5879.0 |
| 2011-05-31 | ED | Futures | 94.9549 | 94.9644 | 94.9549 | 94.9621 | 163010.0 |
| 2011-05-31 | ER | Futures | 97.331 | 97.331 | 97.311 | 97.326 | 101457.0 |
| 2011-05-31 | EW | Futures | 983.8 | 997.0 | 982.1 | 993.6 | 23972.0 |
| 2011-05-31 | FBTP | Futures | 64.89 | 65.18 | 64.79 | 64.99 | 7223.0 |
| 2011-05-31 | FCE | Futures | 2742.9 | 2780.8 | 2742.6 | 2770.0 | 137858.0 |
| 2011-05-31 | FDAX | Futures | 7722.0 | 7835.2 | 7711.9 | 7790.9 | 138958.0 |
| 2011-05-31 | FESX | Futures | 1815.8 | 1840.8 | 1814.5 | 1830.5 | 1512533.0 |
| 2011-05-31 | FEU3 | Futures | 97.865 | 97.87 | 97.86 | 97.87 | 56.0 |
| 2011-05-31 | FGBL | Futures | 100.35 | 100.42 | 100.04 | 100.3 | 1120837.0 |
| 2011-05-31 | FGBM | Futures | 104.68 | 104.72 | 104.42 | 104.68 | 853382.0 |
| 2011-05-31 | FGBS | Futures | 106.9 | 106.9 | 106.776 | 106.875 | 843577.0 |
| 2011-05-31 | FGBX | Futures | 98.02 | 98.02 | 97.2 | 97.64 | 8640.0 |
| 2011-05-31 | FTDX | Futures | 816.7 | 826.6 | 815.0 | 817.2 | 798.0 |
| 2011-05-31 | FTI | Futures | 285.99 | 288.04 | 285.91 | 286.73 | 37855.0 |
| 2011-05-31 | FTUK | Futures | 4153.6 | 4197.3 | 4153.6 | 4175.6 | 111502.0 |
| 2011-05-31 | FXXP | Futures | 187.7 | 188.3 | 187.2 | 187.7 | 5250.0 |
| 2011-05-31 | G | Futures | 83.78 | 83.97 | 83.71 | 83.87 | 85960.0 |
| 2011-05-31 | GF | Futures | 286.32 | 290.677 | 286.32 | 289.051 | 2828.0 |
| 2011-05-31 | GSCI | Futures | 1105.84 | 1111.32 | 1104.11 | 1105.21 | 197.0 |
| 2011-05-31 | HE | Futures | 94.749 | 96.47 | 94.537 | 95.49 | 7850.0 |
| 2011-05-31 | HG | Futures | 5.5514 | 5.5965 | 5.4936 | 5.55 | 34253.0 |
| 2011-05-31 | HO | Futures | 2.445 | 2.5129 | 2.445 | 2.4962 | 8235.0 |
| 2011-05-31 | HRC | Futures | 3118.0 | 3118.0 | 3118.0 | 3118.0 | 0.0 |
| 2011-05-31 | J1 | Futures | 0.0155405 | 0.0155669 | 0.0153634 | 0.0154187 | 141748.0 |
| 2011-05-31 | J7 | Futures | 0.015445 | 0.015469 | 0.015271 | 0.015324 | 708.0 |
| 2011-05-31 | JB | Futures | 122.74 | 122.74 | 122.35 | 122.39 | 3344.0 |
| 2011-05-31 | KC | Futures | 634.75 | 643.62 | 631.87 | 634.51 | 9534.0 |
| 2011-05-31 | KE | Futures | 3649.49 | 3675.17 | 3567.54 | 3586.3 | 16994.0 |
> showing 50 of 95 rows — these rows as CSV