PREVIEW / futures_daily / 2013-04-16
file: by_date/futures_daily/2013/2013-04-16.parquet size: 9 KB rows: 102
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-04-16 | ES | Futures | 1583.62 | 1612.63 | 1583.37 | 1610.57 | 2252603.0 |
| 2013-04-16 | NQ | Futures | 3218.08 | 3273.81 | 3217.21 | 3266.59 | 236656.0 |
| 2013-04-16 | YM | Futures | 14283.2 | 14473.2 | 14282.2 | 14460.4 | 187105.0 |
| 2013-04-16 | CL | Futures | 152.9 | 155.71 | 150.67 | 155.27 | 169002.0 |
| 2013-04-16 | GC | Futures | 1798.8 | 1864.1 | 1754.3 | 1841.8 | 424780.0 |
| 2013-04-16 | ZN | Futures | 118.616848 | 118.672504 | 118.255084 | 118.394224 | 1008711.0 |
| 2013-04-16 | A6 | Futures | 0.94731 | 0.95525 | 0.94703 | 0.95377 | 152637.0 |
| 2013-04-16 | AD | Futures | 0.97924 | 0.98326 | 0.97803 | 0.98235 | 80878.0 |
| 2013-04-16 | B | Futures | 95.74 | 96.65 | 94.37 | 96.21 | 328741.0 |
| 2013-04-16 | B6 | Futures | 1.5995 | 1.6087 | 1.5974 | 1.6076 | 96945.0 |
| 2013-04-16 | BFX | Futures | 3010.6 | 3037.4 | 3010.6 | 3019.6 | 192.0 |
| 2013-04-16 | BR | Futures | 0.2478 | 0.24832 | 0.24629 | 0.24688 | 75.0 |
| 2013-04-16 | BZ | Futures | 96.47 | 97.82 | 95.55 | 97.4 | 4727.0 |
| 2013-04-16 | C | Futures | 1592.0 | 1630.0 | 1588.0 | 1624.0 | 11698.0 |
| 2013-04-16 | CB | Futures | 90.35 | 90.35 | 89.844 | 90.005 | 19.0 |
| 2013-04-16 | CC | Futures | 1698.0 | 1738.0 | 1692.0 | 1737.0 | 21594.0 |
| 2013-04-16 | CSC | Futures | 3.845 | 3.845 | 3.805 | 3.821 | 20.0 |
| 2013-04-16 | CT | Futures | 103.57 | 104.57 | 102.5 | 102.54 | 12904.0 |
| 2013-04-16 | DC | Futures | 29.54 | 29.7 | 29.26 | 29.57 | 326.0 |
| 2013-04-16 | DX | Futures | 79.188 | 79.404 | 78.597 | 78.638 | 42095.0 |
| 2013-04-16 | E1 | Futures | 1.3825 | 1.39794 | 1.38005 | 1.39716 | 35401.0 |
| 2013-04-16 | E6 | Futures | 1.53841 | 1.55716 | 1.53629 | 1.55575 | 317540.0 |
| 2013-04-16 | E7 | Futures | 1.5286 | 1.5469 | 1.5266 | 1.5456 | 4700.0 |
| 2013-04-16 | EBM | Futures | 287.01 | 287.59 | 284.39 | 287.01 | 17284.0 |
| 2013-04-16 | ED | Futures | 95.2444 | 95.2492 | 95.2444 | 95.2492 | 78993.0 |
| 2013-04-16 | ER | Futures | 97.827 | 97.832 | 97.817 | 97.822 | 56329.0 |
| 2013-04-16 | EW | Futures | 1130.7 | 1151.9 | 1130.7 | 1150.0 | 26472.0 |
| 2013-04-16 | FBTP | Futures | 76.85 | 77.35 | 76.85 | 77.2 | 16845.0 |
| 2013-04-16 | FBTS | Futures | 92.039 | 92.15 | 92.039 | 92.107 | 4949.0 |
| 2013-04-16 | FCE | Futures | 2791.6 | 2814.7 | 2779.6 | 2787.7 | 98898.0 |
| 2013-04-16 | FDAX | Futures | 8552.4 | 8617.4 | 8501.2 | 8561.2 | 133521.0 |
| 2013-04-16 | FESX | Futures | 1784.7 | 1802.2 | 1777.0 | 1786.8 | 913923.0 |
| 2013-04-16 | FGBL | Futures | 122.38 | 122.46 | 121.99 | 122.14 | 689466.0 |
| 2013-04-16 | FGBM | Futures | 118.32 | 118.36 | 118.1 | 118.17 | 386982.0 |
| 2013-04-16 | FGBS | Futures | 110.507 | 110.517 | 110.467 | 110.482 | 213764.0 |
| 2013-04-16 | FGBX | Futures | 129.51 | 129.99 | 129.11 | 129.34 | 8746.0 |
| 2013-04-16 | FMWO | Futures | 4679.7 | 4679.7 | 4679.7 | 4679.7 | 0.0 |
| 2013-04-16 | FOAT | Futures | 108.96 | 109.08 | 108.77 | 108.87 | 29660.0 |
| 2013-04-16 | FTDX | Futures | 870.6 | 870.6 | 862.0 | 862.0 | 122.0 |
| 2013-04-16 | FTI | Futures | 295.07 | 297.86 | 294.46 | 295.81 | 26710.0 |
| 2013-04-16 | FTUK | Futures | 4641.3 | 4671.4 | 4636.5 | 4644.7 | 83513.0 |
| 2013-04-16 | FVSA | Futures | 3311.31 | 3374.69 | 3240.02 | 3287.55 | 7718.0 |
| 2013-04-16 | FXXP | Futures | 210.2 | 210.5 | 208.5 | 209.3 | 2634.0 |
| 2013-04-16 | G | Futures | 100.31 | 100.31 | 100.02 | 100.13 | 100889.0 |
| 2013-04-16 | GF | Futures | 251.521 | 254.601 | 251.158 | 253.786 | 3738.0 |
| 2013-04-16 | GSCI | Futures | 977.51 | 981.6 | 971.24 | 979.59 | 310.0 |
| 2013-04-16 | HE | Futures | 86.26 | 87.519 | 86.26 | 87.393 | 169.0 |
| 2013-04-16 | HG | Futures | 4.1757 | 4.221 | 4.1119 | 4.2171 | 85614.0 |
| 2013-04-16 | HH | Futures | 46.926 | 47.492 | 46.268 | 47.129 | 669.0 |
| 2013-04-16 | HO | Futures | 2.2459 | 2.2658 | 2.229 | 2.2559 | 37835.0 |
> showing 50 of 102 rows — these rows as CSV