PREVIEW / futures_daily / 2010-07-27
file: by_date/futures_daily/2010/2010-07-27.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-07-27 | ES | Futures | 1081.91 | 1091.18 | 1078.74 | 1083.62 | 1822245.0 |
| 2010-07-27 | NQ | Futures | 2136.32 | 2151.32 | 2125.85 | 2135.19 | 270426.0 |
| 2010-07-27 | YM | Futures | 9671.2 | 9736.8 | 9648.1 | 9702.6 | 127446.0 |
| 2010-07-27 | CL | Futures | 167.56 | 169.19 | 163.04 | 164.54 | 377844.0 |
| 2010-07-27 | GC | Futures | 1611.1 | 1617.8 | 1577.8 | 1579.2 | 116906.0 |
| 2010-07-27 | ZN | Futures | 100.593234 | 100.670072 | 100.157821 | 100.260271 | 998211.0 |
| 2010-07-27 | A6 | Futures | 0.74339 | 0.74754 | 0.74165 | 0.74306 | 82451.0 |
| 2010-07-27 | AD | Futures | 0.95597 | 0.96248 | 0.94885 | 0.95241 | 76513.0 |
| 2010-07-27 | B | Futures | 67.74 | 68.36 | 65.99 | 66.54 | 52845.0 |
| 2010-07-27 | B6 | Futures | 1.6066 | 1.6188 | 1.6021 | 1.6174 | 96115.0 |
| 2010-07-27 | BFX | Futures | 2891.7 | 2921.2 | 2891.7 | 2915.5 | 96.0 |
| 2010-07-27 | BR | Futures | 0.23484 | 0.23484 | 0.23432 | 0.23432 | 36.0 |
| 2010-07-27 | BZ | Futures | 73.34 | 73.49 | 71.06 | 71.6 | 132.0 |
| 2010-07-27 | C | Futures | 2491.0 | 2506.0 | 2442.0 | 2486.0 | 5318.0 |
| 2010-07-27 | CC | Futures | 2473.0 | 2524.0 | 2464.0 | 2485.0 | 5535.0 |
| 2010-07-27 | CT | Futures | 67.55 | 68.54 | 67.55 | 68.52 | 50.0 |
| 2010-07-27 | DC | Futures | 23.68 | 23.86 | 23.66 | 23.71 | 325.0 |
| 2010-07-27 | DX | Futures | 82.881 | 83.183 | 82.619 | 82.98 | 15674.0 |
| 2010-07-27 | E1 | Futures | 1.25278 | 1.25344 | 1.23479 | 1.23978 | 44924.0 |
| 2010-07-27 | E6 | Futures | 1.53559 | 1.54268 | 1.53133 | 1.53582 | 277661.0 |
| 2010-07-27 | E7 | Futures | 1.5245 | 1.5316 | 1.5203 | 1.5248 | 3403.0 |
| 2010-07-27 | ED | Futures | 94.4657 | 94.4847 | 94.4609 | 94.4752 | 106231.0 |
| 2010-07-27 | ER | Futures | 97.213 | 97.222 | 97.198 | 97.218 | 86244.0 |
| 2010-07-27 | EW | Futures | 758.8 | 766.3 | 752.4 | 755.9 | 28969.0 |
| 2010-07-27 | FBTP | Futures | 65.67 | 66.02 | 65.64 | 65.9 | 6271.0 |
| 2010-07-27 | FCE | Futures | 2385.7 | 2426.7 | 2381.1 | 2405.1 | 122190.0 |
| 2010-07-27 | FDAX | Futures | 6746.5 | 6809.1 | 6731.3 | 6756.3 | 120449.0 |
| 2010-07-27 | FESX | Futures | 1697.1 | 1726.2 | 1694.1 | 1712.0 | 1169249.0 |
| 2010-07-27 | FEU3 | Futures | 97.761 | 97.776 | 97.761 | 97.776 | 75.0 |
| 2010-07-27 | FGBL | Futures | 99.83 | 99.84 | 99.48 | 99.73 | 782762.0 |
| 2010-07-27 | FGBM | Futures | 104.33 | 104.33 | 104.07 | 104.25 | 471007.0 |
| 2010-07-27 | FGBS | Futures | 107.22 | 107.225 | 107.087 | 107.146 | 475421.0 |
| 2010-07-27 | FGBX | Futures | 98.61 | 98.68 | 98.18 | 98.54 | 2518.0 |
| 2010-07-27 | FTDX | Futures | 705.6 | 705.6 | 692.8 | 694.6 | 430.0 |
| 2010-07-27 | FTI | Futures | 266.77 | 269.39 | 266.53 | 267.28 | 32866.0 |
| 2010-07-27 | FTUK | Futures | 3670.0 | 3703.0 | 3661.0 | 3665.8 | 92840.0 |
| 2010-07-27 | G | Futures | 80.72 | 80.79 | 80.26 | 80.4 | 159361.0 |
| 2010-07-27 | GF | Futures | 290.507 | 290.697 | 288.992 | 290.255 | 1460.0 |
| 2010-07-27 | GSCI | Futures | 879.07 | 880.93 | 858.78 | 863.96 | 68.0 |
| 2010-07-27 | HE | Futures | 100.164 | 100.498 | 99.678 | 99.83 | 6692.0 |
| 2010-07-27 | HG | Futures | 4.3225 | 4.3345 | 4.2535 | 4.2944 | 33800.0 |
| 2010-07-27 | HO | Futures | 1.8145 | 1.8323 | 1.7662 | 1.7785 | 48397.0 |
| 2010-07-27 | HRC | Futures | 2802.4 | 2802.4 | 2802.4 | 2802.4 | 10.0 |
| 2010-07-27 | J1 | Futures | 0.0144745 | 0.0144959 | 0.0143047 | 0.0143261 | 127285.0 |
| 2010-07-27 | J7 | Futures | 0.014362 | 0.014386 | 0.014199 | 0.014218 | 206.0 |
| 2010-07-27 | JB | Futures | 120.75 | 120.83 | 120.66 | 120.77 | 909.0 |
| 2010-07-27 | KC | Futures | 413.37 | 418.27 | 409.86 | 411.24 | 6993.0 |
| 2010-07-27 | KE | Futures | 2602.63 | 2661.23 | 2586.65 | 2620.74 | 10253.0 |
| 2010-07-27 | L | Futures | 98.096 | 98.106 | 98.076 | 98.086 | 25899.0 |
| 2010-07-27 | LBS | Futures | 614.3 | 617.9 | 591.6 | 591.6 | 453.0 |
> showing 50 of 89 rows — these rows as CSV