PREVIEW / futures_daily / 2010-12-28
file: by_date/futures_daily/2010/2010-12-28.parquet size: 9 KB rows: 87
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-28 | ES | Futures | 1233.85 | 1236.8 | 1231.88 | 1234.34 | 553798.0 |
| 2010-12-28 | NQ | Futures | 2530.88 | 2539.68 | 2521.79 | 2526.62 | 80279.0 |
| 2010-12-28 | YM | Futures | 10765.0 | 10797.8 | 10735.1 | 10771.6 | 32529.0 |
| 2010-12-28 | CL | Futures | 186.05 | 187.86 | 185.97 | 187.49 | 104415.0 |
| 2010-12-28 | GC | Futures | 1881.5 | 1913.2 | 1880.0 | 1910.6 | 105803.0 |
| 2010-12-28 | ZN | Futures | 99.828618 | 100.140582 | 98.905723 | 99.02271 | 447244.0 |
| 2010-12-28 | A6 | Futures | 0.8441 | 0.85275 | 0.84342 | 0.848 | 44678.0 |
| 2010-12-28 | AD | Futures | 0.98401 | 0.99344 | 0.98391 | 0.99106 | 61107.0 |
| 2010-12-28 | B | Futures | 79.75 | 80.25 | 79.63 | 80.21 | 16055.0 |
| 2010-12-28 | B6 | Futures | 1.5986 | 1.6084 | 1.5908 | 1.5934 | 59725.0 |
| 2010-12-28 | BFX | Futures | 2991.7 | 2999.8 | 2973.8 | 2986.6 | 77.0 |
| 2010-12-28 | BR | Futures | 0.25244 | 0.25244 | 0.25127 | 0.25127 | 72.0 |
| 2010-12-28 | BZ | Futures | 85.44 | 85.44 | 85.44 | 85.44 | 75.0 |
| 2010-12-28 | CB | Futures | 100.322 | 101.788 | 100.322 | 101.202 | 8.0 |
| 2010-12-28 | CC | Futures | 2467.0 | 2508.0 | 2465.0 | 2487.0 | 4365.0 |
| 2010-12-28 | CT | Futures | 125.46 | 128.19 | 123.48 | 123.78 | 4413.0 |
| 2010-12-28 | DC | Futures | 22.59 | 22.72 | 22.49 | 22.65 | 80.0 |
| 2010-12-28 | DX | Futures | 80.13 | 80.615 | 79.746 | 80.525 | 10777.0 |
| 2010-12-28 | E1 | Futures | 1.36696 | 1.39095 | 1.36696 | 1.37863 | 29389.0 |
| 2010-12-28 | E6 | Futures | 1.55641 | 1.57014 | 1.54872 | 1.55145 | 205415.0 |
| 2010-12-28 | E7 | Futures | 1.5455 | 1.5585 | 1.5373 | 1.5399 | 4600.0 |
| 2010-12-28 | EBM | Futures | 224.23 | 227.18 | 224.23 | 225.59 | 2582.0 |
| 2010-12-28 | ED | Futures | 94.7718 | 94.7814 | 94.7671 | 94.7766 | 59295.0 |
| 2010-12-28 | ER | Futures | 97.365 | 97.38 | 97.36 | 97.37 | 42037.0 |
| 2010-12-28 | EW | Futures | 896.8 | 898.4 | 892.3 | 894.3 | 6998.0 |
| 2010-12-28 | FBTP | Futures | 63.98 | 63.98 | 63.45 | 63.63 | 592.0 |
| 2010-12-28 | FCE | Futures | 2588.3 | 2592.3 | 2571.3 | 2578.0 | 29846.0 |
| 2010-12-28 | FDAX | Futures | 7501.9 | 7506.7 | 7464.9 | 7481.5 | 33115.0 |
| 2010-12-28 | FESX | Futures | 1761.9 | 1763.8 | 1750.1 | 1753.2 | 200913.0 |
| 2010-12-28 | FEU3 | Futures | 97.929 | 97.929 | 97.929 | 97.929 | 14.0 |
| 2010-12-28 | FGBL | Futures | 99.04 | 99.36 | 98.54 | 99.15 | 150726.0 |
| 2010-12-28 | FGBM | Futures | 104.72 | 105.06 | 104.63 | 104.94 | 101971.0 |
| 2010-12-28 | FGBS | Futures | 107.361 | 107.553 | 107.361 | 107.543 | 134628.0 |
| 2010-12-28 | FGBX | Futures | 97.59 | 98.5 | 96.59 | 98.05 | 483.0 |
| 2010-12-28 | FTDX | Futures | 742.0 | 746.0 | 742.0 | 744.6 | 144.0 |
| 2010-12-28 | FTI | Futures | 285.68 | 286.24 | 284.92 | 285.52 | 9037.0 |
| 2010-12-28 | GF | Futures | 300.485 | 303.039 | 300.423 | 300.672 | 984.0 |
| 2010-12-28 | GSCI | Futures | 1021.43 | 1025.24 | 1018.84 | 1024.11 | 102.0 |
| 2010-12-28 | HE | Futures | 98.417 | 99.076 | 97.79 | 98.605 | 8769.0 |
| 2010-12-28 | HG | Futures | 5.7114 | 5.7774 | 5.7054 | 5.768 | 13434.0 |
| 2010-12-28 | HO | Futures | 2.1188 | 2.128 | 2.1145 | 2.1242 | 5735.0 |
| 2010-12-28 | HRC | Futures | 2615.9 | 2615.9 | 2615.9 | 2615.9 | 0.0 |
| 2010-12-28 | J1 | Futures | 0.01518 | 0.0153646 | 0.0151787 | 0.0152541 | 99981.0 |
| 2010-12-28 | J7 | Futures | 0.015077 | 0.015254 | 0.015077 | 0.015146 | 494.0 |
| 2010-12-28 | JB | Futures | 120.79 | 121.33 | 120.69 | 121.31 | 1393.0 |
| 2010-12-28 | KC | Futures | 583.76 | 588.3 | 578.98 | 586.83 | 2785.0 |
| 2010-12-28 | KE | Futures | 3436.0 | 3518.51 | 3432.94 | 3506.29 | 9387.0 |
| 2010-12-28 | LBS | Futures | 846.6 | 852.9 | 833.7 | 849.7 | 644.0 |
| 2010-12-28 | LE | Futures | 163.689 | 165.167 | 163.197 | 163.424 | 13313.0 |
| 2010-12-28 | MFS | Futures | 1330.4 | 1330.4 | 1321.9 | 1324.2 | 297.0 |
> showing 50 of 87 rows — these rows as CSV