PREVIEW / futures_daily / 2011-08-24
file: by_date/futures_daily/2011/2011-08-24.parquet size: 9 KB rows: 96
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-08-24 | ES | Futures | 1151.04 | 1168.67 | 1134.66 | 1163.95 | 2616278.0 |
| 2011-08-24 | NQ | Futures | 2418.72 | 2445.48 | 2387.12 | 2435.8 | 270378.0 |
| 2011-08-24 | YM | Futures | 10533.7 | 10690.6 | 10397.6 | 10652.8 | 133456.0 |
| 2011-08-24 | CL | Futures | 163.19 | 164.94 | 161.05 | 162.22 | 294928.0 |
| 2011-08-24 | GC | Futures | 2472.8 | 2507.0 | 2364.9 | 2372.6 | 440826.0 |
| 2011-08-24 | ZN | Futures | 110.93686 | 111.163044 | 110.098647 | 110.338136 | 1448252.0 |
| 2011-08-24 | A6 | Futures | 0.91256 | 0.91274 | 0.90569 | 0.90717 | 87974.0 |
| 2011-08-24 | AD | Futures | 1.00984 | 1.01373 | 1.00684 | 1.00914 | 73344.0 |
| 2011-08-24 | B | Futures | 93.8 | 94.95 | 92.99 | 94.22 | 196746.0 |
| 2011-08-24 | B6 | Futures | 1.7149 | 1.7198 | 1.7016 | 1.7026 | 87013.0 |
| 2011-08-24 | BFX | Futures | 2598.0 | 2656.5 | 2598.0 | 2649.6 | 41.0 |
| 2011-08-24 | BR | Futures | 0.27662 | 0.27662 | 0.27584 | 0.27633 | 829.0 |
| 2011-08-24 | BZ | Futures | 96.74 | 98.03 | 96.48 | 97.32 | 2404.0 |
| 2011-08-24 | C | Futures | 2105.0 | 2119.0 | 2071.0 | 2074.0 | 2515.0 |
| 2011-08-24 | CC | Futures | 2458.0 | 2470.0 | 2402.0 | 2421.0 | 10944.0 |
| 2011-08-24 | CSC | Futures | 4.319 | 4.319 | 4.288 | 4.312 | 2.0 |
| 2011-08-24 | CT | Futures | 138.53 | 140.8 | 135.77 | 135.77 | 32.0 |
| 2011-08-24 | DC | Futures | 29.94 | 29.94 | 29.36 | 29.54 | 613.0 |
| 2011-08-24 | DX | Futures | 73.187 | 73.459 | 73.004 | 73.372 | 20294.0 |
| 2011-08-24 | E1 | Futures | 1.6526 | 1.66319 | 1.64475 | 1.64776 | 19368.0 |
| 2011-08-24 | E6 | Futures | 1.71371 | 1.71953 | 1.70718 | 1.71217 | 256054.0 |
| 2011-08-24 | E7 | Futures | 1.7014 | 1.7067 | 1.6949 | 1.6997 | 3650.0 |
| 2011-08-24 | ED | Futures | 94.8977 | 94.9358 | 94.8929 | 94.9287 | 269835.0 |
| 2011-08-24 | ER | Futures | 97.504 | 97.509 | 97.489 | 97.499 | 95690.0 |
| 2011-08-24 | EW | Futures | 811.2 | 826.1 | 799.6 | 821.9 | 28845.0 |
| 2011-08-24 | FBTP | Futures | 64.5 | 64.5 | 64.05 | 64.26 | 9294.0 |
| 2011-08-24 | FCE | Futures | 2175.2 | 2220.1 | 2154.1 | 2196.6 | 84064.0 |
| 2011-08-24 | FDAX | Futures | 5958.0 | 6140.7 | 5893.4 | 6061.1 | 170409.0 |
| 2011-08-24 | FESX | Futures | 1420.7 | 1448.9 | 1403.4 | 1432.9 | 1229982.0 |
| 2011-08-24 | FEU3 | Futures | 98.044 | 98.044 | 98.039 | 98.039 | 25.0 |
| 2011-08-24 | FGBL | Futures | 108.43 | 108.56 | 107.7 | 107.93 | 883812.0 |
| 2011-08-24 | FGBM | Futures | 109.93 | 110.03 | 109.44 | 109.61 | 417923.0 |
| 2011-08-24 | FGBS | Futures | 108.934 | 108.959 | 108.736 | 108.82 | 485876.0 |
| 2011-08-24 | FGBX | Futures | 107.56 | 107.62 | 105.87 | 106.29 | 4580.0 |
| 2011-08-24 | FTDX | Futures | 625.2 | 647.5 | 625.2 | 639.9 | 324.0 |
| 2011-08-24 | FTI | Futures | 228.54 | 231.6 | 224.87 | 229.81 | 40123.0 |
| 2011-08-24 | FTUK | Futures | 3664.8 | 3702.6 | 3592.9 | 3666.2 | 111909.0 |
| 2011-08-24 | FVSA | Futures | 15349.04 | 15368.44 | 14728.09 | 14863.92 | 1334.0 |
| 2011-08-24 | FXXP | Futures | 152.8 | 156.7 | 152.8 | 155.3 | 694.0 |
| 2011-08-24 | G | Futures | 90.26 | 90.47 | 89.72 | 89.83 | 245644.0 |
| 2011-08-24 | GF | Futures | 306.47 | 306.699 | 300.46 | 301.204 | 1834.0 |
| 2011-08-24 | GSCI | Futures | 1021.25 | 1027.98 | 1015.76 | 1018.11 | 90.0 |
| 2011-08-24 | HE | Futures | 107.787 | 108.153 | 106.321 | 106.321 | 15322.0 |
| 2011-08-24 | HG | Futures | 5.3262 | 5.358 | 5.272 | 5.315 | 11350.0 |
| 2011-08-24 | HO | Futures | 2.3876 | 2.4128 | 2.3734 | 2.3957 | 17553.0 |
| 2011-08-24 | HRC | Futures | 2826.6 | 2843.3 | 2826.6 | 2843.3 | 1.0 |
| 2011-08-24 | J1 | Futures | 0.0163977 | 0.0164404 | 0.0163085 | 0.0163286 | 104289.0 |
| 2011-08-24 | J7 | Futures | 0.016281 | 0.016329 | 0.016202 | 0.016219 | 437.0 |
| 2011-08-24 | JB | Futures | 124.06 | 124.27 | 123.93 | 124.09 | 1598.0 |
| 2011-08-24 | KC | Futures | 640.96 | 654.27 | 640.84 | 645.08 | 12220.0 |
> showing 50 of 96 rows — these rows as CSV