PREVIEW / futures_daily / 2010-05-04
file: by_date/futures_daily/2010/2010-05-04.parquet size: 9 KB rows: 89
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-05-04 | ES | Futures | 1166.84 | 1168.3 | 1133.73 | 1141.76 | 3553338.0 |
| 2010-05-04 | NQ | Futures | 2298.36 | 2301.2 | 2214.7 | 2234.27 | 515322.0 |
| 2010-05-04 | YM | Futures | 10204.8 | 10217.7 | 9944.6 | 10012.7 | 209462.0 |
| 2010-05-04 | CL | Futures | 199.07 | 199.41 | 189.72 | 191.32 | 497427.0 |
| 2010-05-04 | GC | Futures | 1623.0 | 1636.6 | 1601.0 | 1604.2 | 190145.0 |
| 2010-05-04 | ZN | Futures | 95.99661 | 96.570523 | 95.932842 | 96.430233 | 1323655.0 |
| 2010-05-04 | A6 | Futures | 0.7562 | 0.75727 | 0.74159 | 0.74184 | 171023.0 |
| 2010-05-04 | AD | Futures | 0.97728 | 0.97728 | 0.96218 | 0.96287 | 102546.0 |
| 2010-05-04 | B | Futures | 79.56 | 79.72 | 76.26 | 76.71 | 126252.0 |
| 2010-05-04 | B6 | Futures | 1.5819 | 1.5846 | 1.5665 | 1.5738 | 159968.0 |
| 2010-05-04 | BFX | Futures | 2920.2 | 2920.2 | 2827.0 | 2835.0 | 652.0 |
| 2010-05-04 | BR | Futures | 0.23106 | 0.23106 | 0.23106 | 0.23106 | 205.0 |
| 2010-05-04 | BZ | Futures | 80.73 | 80.73 | 80.73 | 80.73 | 4.0 |
| 2010-05-04 | C | Futures | 2397.0 | 2409.0 | 2354.0 | 2371.0 | 2531.0 |
| 2010-05-04 | CB | Futures | 83.277 | 83.4 | 83.03 | 83.03 | 15.0 |
| 2010-05-04 | CC | Futures | 2716.0 | 2724.0 | 2634.0 | 2665.0 | 9557.0 |
| 2010-05-04 | CT | Futures | 66.15 | 66.38 | 64.53 | 64.61 | 16515.0 |
| 2010-05-04 | DC | Futures | 22.72 | 22.72 | 22.44 | 22.51 | 209.0 |
| 2010-05-04 | DX | Futures | 83.592 | 84.768 | 83.506 | 84.536 | 30757.0 |
| 2010-05-04 | E1 | Futures | 1.21274 | 1.21484 | 1.19339 | 1.1955 | 67108.0 |
| 2010-05-04 | E6 | Futures | 1.56036 | 1.56344 | 1.53575 | 1.53847 | 468697.0 |
| 2010-05-04 | E7 | Futures | 1.5477 | 1.5505 | 1.5233 | 1.5259 | 6450.0 |
| 2010-05-04 | EBM | Futures | 215.07 | 215.48 | 213.42 | 214.25 | 2353.0 |
| 2010-05-04 | ED | Futures | 94.295 | 94.3186 | 94.2523 | 94.2665 | 378880.0 |
| 2010-05-04 | ER | Futures | 97.291 | 97.311 | 97.223 | 97.232 | 336140.0 |
| 2010-05-04 | EW | Futures | 811.6 | 812.5 | 786.0 | 792.3 | 37859.0 |
| 2010-05-04 | FBTP | Futures | 64.45 | 64.46 | 64.21 | 64.34 | 8905.0 |
| 2010-05-04 | FCE | Futures | 2441.5 | 2448.0 | 2343.7 | 2354.3 | 217527.0 |
| 2010-05-04 | FDAX | Futures | 6724.2 | 6750.3 | 6523.5 | 6543.7 | 279947.0 |
| 2010-05-04 | FESX | Futures | 1692.1 | 1695.1 | 1617.3 | 1626.5 | 2450809.0 |
| 2010-05-04 | FEU3 | Futures | 97.85 | 97.864 | 97.786 | 97.786 | 168.0 |
| 2010-05-04 | FGBL | Futures | 97.14 | 98.19 | 97.11 | 97.95 | 1284156.0 |
| 2010-05-04 | FGBM | Futures | 102.63 | 103.29 | 102.6 | 103.14 | 757132.0 |
| 2010-05-04 | FGBS | Futures | 106.777 | 107.021 | 106.757 | 106.953 | 886648.0 |
| 2010-05-04 | FGBX | Futures | 93.64 | 95.36 | 93.48 | 95.21 | 5837.0 |
| 2010-05-04 | FTDX | Futures | 717.7 | 726.5 | 695.1 | 697.4 | 1329.0 |
| 2010-05-04 | FTI | Futures | 281.6 | 282.17 | 270.45 | 271.47 | 62243.0 |
| 2010-05-04 | FTUK | Futures | 3726.7 | 3730.1 | 3625.9 | 3638.1 | 194568.0 |
| 2010-05-04 | G | Futures | 77.36 | 77.79 | 77.29 | 77.71 | 120721.0 |
| 2010-05-04 | GF | Futures | 293.731 | 294.184 | 291.207 | 293.601 | 1462.0 |
| 2010-05-04 | GSCI | Futures | 990.89 | 992.16 | 969.84 | 971.83 | 684.0 |
| 2010-05-04 | HE | Futures | 109.485 | 109.485 | 108.04 | 109.045 | 13960.0 |
| 2010-05-04 | HG | Futures | 4.4744 | 4.5192 | 4.2992 | 4.3162 | 44390.0 |
| 2010-05-04 | HO | Futures | 2.1336 | 2.141 | 2.0502 | 2.0593 | 65168.0 |
| 2010-05-04 | J1 | Futures | 0.013301 | 0.013335 | 0.0132419 | 0.0133236 | 125580.0 |
| 2010-05-04 | J7 | Futures | 0.013174 | 0.013227 | 0.013139 | 0.013217 | 203.0 |
| 2010-05-04 | KC | Futures | 351.75 | 352.13 | 346.29 | 349.08 | 12610.0 |
| 2010-05-04 | KE | Futures | 2226.99 | 2273.72 | 2204.16 | 2271.55 | 10668.0 |
| 2010-05-04 | L | Futures | 97.789 | 97.809 | 97.75 | 97.76 | 84929.0 |
| 2010-05-04 | LBS | Futures | 903.9 | 917.1 | 887.5 | 887.5 | 357.0 |
> showing 50 of 89 rows — these rows as CSV