PREVIEW / futures_daily / 2015-02-09
file: by_date/futures_daily/2015/2015-02-09.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-02-09 | ES | Futures | 2148.66 | 2150.5 | 2134.51 | 2140.8 | 1289419.0 |
| 2015-02-09 | NQ | Futures | 4903.97 | 4910.35 | 4874.96 | 4889.76 | 198223.0 |
| 2015-02-09 | YM | Futures | 18098.3 | 18098.3 | 17949.6 | 18007.7 | 120433.0 |
| 2015-02-09 | CL | Futures | 99.95 | 103.75 | 99.26 | 101.58 | 536364.0 |
| 2015-02-09 | GC | Futures | 1615.9 | 1626.0 | 1614.0 | 1623.3 | 92651.0 |
| 2015-02-09 | ZN | Futures | 121.174416 | 121.64551 | 120.924146 | 121.174416 | 1127292.0 |
| 2015-02-09 | A6 | Futures | 0.75928 | 0.76584 | 0.75732 | 0.76349 | 56979.0 |
| 2015-02-09 | AD | Futures | 0.81249 | 0.81911 | 0.81249 | 0.81759 | 34850.0 |
| 2015-02-09 | ALI | Futures | 2874.99 | 2874.99 | 2874.99 | 2874.99 | 0.0 |
| 2015-02-09 | B | Futures | 57.91 | 59.98 | 57.67 | 58.74 | 204354.0 |
| 2015-02-09 | B6 | Futures | 1.6012 | 1.6051 | 1.5977 | 1.6014 | 53203.0 |
| 2015-02-09 | BFX | Futures | 4235.1 | 4242.4 | 4223.7 | 4242.4 | 3.0 |
| 2015-02-09 | BR | Futures | 0.19729 | 0.19809 | 0.19633 | 0.19746 | 3677.0 |
| 2015-02-09 | BZ | Futures | 58.38 | 59.71 | 57.6 | 58.59 | 27361.0 |
| 2015-02-09 | C | Futures | 2141.0 | 2195.0 | 2137.0 | 2192.0 | 11551.0 |
| 2015-02-09 | CB | Futures | 145.407 | 146.228 | 143.764 | 143.764 | 21.0 |
| 2015-02-09 | CC | Futures | 2057.0 | 2119.0 | 2057.0 | 2116.0 | 25411.0 |
| 2015-02-09 | CNH | Futures | 7.1427 | 7.1427 | 7.1286 | 7.129 | 45.0 |
| 2015-02-09 | CSC | Futures | 4.58 | 4.594 | 4.447 | 4.484 | 89.0 |
| 2015-02-09 | CT | Futures | 78.71 | 80.22 | 78.23 | 79.57 | 21471.0 |
| 2015-02-09 | DC | Futures | 37.45 | 37.49 | 36.14 | 36.25 | 344.0 |
| 2015-02-09 | DX | Futures | 89.83 | 89.957 | 89.423 | 89.529 | 27715.0 |
| 2015-02-09 | E1 | Futures | 1.38086 | 1.39159 | 1.37754 | 1.38852 | 10726.0 |
| 2015-02-09 | E6 | Futures | 1.3314 | 1.33658 | 1.32623 | 1.33399 | 216874.0 |
| 2015-02-09 | E7 | Futures | 1.3235 | 1.3286 | 1.3183 | 1.326 | 3024.0 |
| 2015-02-09 | EBM | Futures | 306.57 | 306.57 | 303.33 | 303.73 | 19066.0 |
| 2015-02-09 | ED | Futures | 95.4402 | 95.4498 | 95.4402 | 95.445 | 103000.0 |
| 2015-02-09 | ER | Futures | 98.033 | 98.038 | 98.023 | 98.023 | 38964.0 |
| 2015-02-09 | EW | Futures | 1541.2 | 1543.7 | 1531.2 | 1535.3 | 18758.0 |
| 2015-02-09 | FBTP | Futures | 101.0 | 101.08 | 100.49 | 100.63 | 108671.0 |
| 2015-02-09 | FBTS | Futures | 99.164 | 99.2 | 99.102 | 99.156 | 15766.0 |
| 2015-02-09 | FCE | Futures | 3794.7 | 3803.2 | 3760.8 | 3795.5 | 123365.0 |
| 2015-02-09 | FDAX | Futures | 11934.5 | 11967.3 | 11768.6 | 11856.8 | 117833.0 |
| 2015-02-09 | FESX | Futures | 2422.4 | 2428.1 | 2393.5 | 2416.6 | 1089052.0 |
| 2015-02-09 | FEU3 | Futures | 98.65 | 98.65 | 98.645 | 98.645 | 1.0 |
| 2015-02-09 | FGBL | Futures | 138.85 | 139.31 | 138.73 | 139.07 | 520435.0 |
| 2015-02-09 | FGBM | Futures | 124.5 | 124.55 | 124.42 | 124.5 | 286469.0 |
| 2015-02-09 | FGBS | Futures | 111.198 | 111.198 | 111.178 | 111.188 | 114518.0 |
| 2015-02-09 | FGBX | Futures | 168.4 | 169.59 | 168.12 | 168.52 | 18603.0 |
| 2015-02-09 | FMWO | Futures | 5643.4 | 5661.9 | 5634.7 | 5659.5 | 890.0 |
| 2015-02-09 | FOAT | Futures | 127.35 | 127.61 | 127.19 | 127.4 | 62742.0 |
| 2015-02-09 | FTDX | Futures | 1403.1 | 1403.1 | 1386.2 | 1390.9 | 158.0 |
| 2015-02-09 | FTI | Futures | 389.82 | 390.42 | 386.18 | 389.51 | 34652.0 |
| 2015-02-09 | FTUK | Futures | 5274.6 | 5294.4 | 5238.3 | 5291.3 | 97418.0 |
| 2015-02-09 | FVSA | Futures | 2048.85 | 2152.16 | 2031.64 | 2096.2 | 13646.0 |
| 2015-02-09 | FXXP | Futures | 279.3 | 280.0 | 277.5 | 279.8 | 8400.0 |
| 2015-02-09 | G | Futures | 104.21 | 104.74 | 104.15 | 104.49 | 150520.0 |
| 2015-02-09 | GF | Futures | 338.659 | 344.057 | 338.49 | 343.509 | 5691.0 |
| 2015-02-09 | GSCI | Futures | 709.77 | 721.92 | 709.77 | 715.2 | 2684.0 |
| 2015-02-09 | HE | Futures | 91.629 | 91.897 | 88.912 | 89.549 | 17905.0 |
> showing 50 of 107 rows — these rows as CSV