PREVIEW / futures_daily / 2010-06-04
file: by_date/futures_daily/2010/2010-06-04.parquet size: 9 KB rows: 88
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-06-04 | ES | Futures | 1075.06 | 1078.71 | 1031.48 | 1038.06 | 3211493.0 |
| 2010-06-04 | NQ | Futures | 2152.59 | 2160.53 | 2069.49 | 2080.83 | 426018.0 |
| 2010-06-04 | YM | Futures | 9429.8 | 9456.5 | 9082.4 | 9143.0 | 192536.0 |
| 2010-06-04 | CL | Futures | 163.26 | 165.03 | 154.77 | 156.48 | 448494.0 |
| 2010-06-04 | GC | Futures | 1648.5 | 1666.9 | 1634.3 | 1661.0 | 139929.0 |
| 2010-06-04 | ZN | Futures | 98.151974 | 99.248787 | 98.062699 | 99.210526 | 83088.0 |
| 2010-06-04 | A6 | Futures | 0.69064 | 0.69491 | 0.67308 | 0.67324 | 131028.0 |
| 2010-06-04 | AD | Futures | 0.94846 | 0.9533 | 0.92852 | 0.93138 | 128610.0 |
| 2010-06-04 | B | Futures | 66.71 | 67.81 | 63.39 | 63.92 | 94799.0 |
| 2010-06-04 | B6 | Futures | 1.5175 | 1.5243 | 1.5002 | 1.5012 | 132596.0 |
| 2010-06-04 | BFX | Futures | 2851.2 | 2856.6 | 2764.0 | 2770.8 | 51.0 |
| 2010-06-04 | BR | Futures | 0.22131 | 0.22131 | 0.2201 | 0.2201 | 51.0 |
| 2010-06-04 | BZ | Futures | 70.67 | 70.67 | 68.45 | 68.93 | 41.0 |
| 2010-06-04 | C | Futures | 2548.0 | 2588.0 | 2536.0 | 2542.0 | 7114.0 |
| 2010-06-04 | CC | Futures | 2560.0 | 2575.0 | 2431.0 | 2452.0 | 12222.0 |
| 2010-06-04 | CT | Futures | 62.23 | 62.39 | 60.85 | 61.25 | 16993.0 |
| 2010-06-04 | DC | Futures | 22.29 | 22.46 | 22.22 | 22.34 | 94.0 |
| 2010-06-04 | DX | Futures | 88.355 | 89.586 | 88.137 | 89.495 | 36966.0 |
| 2010-06-04 | E1 | Futures | 1.13811 | 1.1539 | 1.13048 | 1.13324 | 74414.0 |
| 2010-06-04 | E6 | Futures | 1.4391 | 1.44525 | 1.41426 | 1.41556 | 516180.0 |
| 2010-06-04 | E7 | Futures | 1.4268 | 1.4335 | 1.4027 | 1.404 | 7160.0 |
| 2010-06-04 | ED | Futures | 94.2192 | 94.2239 | 94.1978 | 94.2002 | 159644.0 |
| 2010-06-04 | ER | Futures | 97.365 | 97.37 | 97.36 | 97.365 | 65873.0 |
| 2010-06-04 | EW | Futures | 748.7 | 751.0 | 714.7 | 719.6 | 41612.0 |
| 2010-06-04 | FBTP | Futures | 63.37 | 63.55 | 63.06 | 63.49 | 11690.0 |
| 2010-06-04 | FCE | Futures | 2352.3 | 2375.5 | 2240.9 | 2283.0 | 191827.0 |
| 2010-06-04 | FDAX | Futures | 6586.6 | 6651.9 | 6379.4 | 6450.7 | 183352.0 |
| 2010-06-04 | FESX | Futures | 1608.2 | 1623.5 | 1532.2 | 1556.7 | 1934542.0 |
| 2010-06-04 | FEU3 | Futures | 97.919 | 97.929 | 97.919 | 97.924 | 1104.0 |
| 2010-06-04 | FGBL | Futures | 100.51 | 101.16 | 100.31 | 100.98 | 1362022.0 |
| 2010-06-04 | FGBM | Futures | 105.03 | 105.6 | 104.94 | 105.42 | 960595.0 |
| 2010-06-04 | FGBS | Futures | 107.638 | 107.784 | 107.623 | 107.711 | 967392.0 |
| 2010-06-04 | FGBX | Futures | 99.58 | 100.28 | 98.88 | 99.89 | 18700.0 |
| 2010-06-04 | FTDX | Futures | 669.5 | 679.7 | 653.1 | 660.7 | 665.0 |
| 2010-06-04 | FTI | Futures | 257.39 | 260.69 | 248.97 | 253.02 | 48860.0 |
| 2010-06-04 | FTUK | Futures | 3530.1 | 3562.3 | 3412.7 | 3468.5 | 135859.0 |
| 2010-06-04 | G | Futures | 79.65 | 80.18 | 79.36 | 80.03 | 95584.0 |
| 2010-06-04 | GF | Futures | 277.624 | 278.256 | 274.087 | 275.035 | 2368.0 |
| 2010-06-04 | GSCI | Futures | 836.47 | 843.17 | 821.43 | 822.21 | 240.0 |
| 2010-06-04 | HE | Futures | 102.354 | 102.354 | 99.695 | 99.758 | 18880.0 |
| 2010-06-04 | HG | Futures | 4.0066 | 4.063 | 3.7886 | 3.8287 | 41912.0 |
| 2010-06-04 | HO | Futures | 1.8246 | 1.8319 | 1.7445 | 1.7536 | 9419.0 |
| 2010-06-04 | J1 | Futures | 0.0135789 | 0.0137574 | 0.0135374 | 0.0137524 | 178406.0 |
| 2010-06-04 | J7 | Futures | 0.013469 | 0.013645 | 0.013431 | 0.013643 | 320.0 |
| 2010-06-04 | JB | Futures | 119.31 | 119.63 | 119.08 | 119.63 | 10218.0 |
| 2010-06-04 | KC | Futures | 345.53 | 345.66 | 338.67 | 339.56 | 13923.0 |
| 2010-06-04 | KE | Futures | 2054.17 | 2059.61 | 2021.57 | 2021.57 | 10179.0 |
| 2010-06-04 | L | Futures | 97.918 | 97.928 | 97.878 | 97.898 | 54553.0 |
| 2010-06-04 | LBS | Futures | 714.3 | 728.3 | 700.1 | 705.7 | 544.0 |
| 2010-06-04 | LE | Futures | 147.228 | 147.228 | 143.77 | 144.217 | 23978.0 |
> showing 50 of 88 rows — these rows as CSV