PREVIEW / futures_daily / 2008-01-07
file: by_date/futures_daily/2008/2008-01-07.parquet size: 7 KB rows: 45
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-07 | ES | Futures | 1318.46 | 1327.5 | 1306.88 | 1317.54 | 2436934.0 |
| 2008-01-07 | NQ | Futures | 2227.82 | 2239.89 | 2181.8 | 2217.16 | 581477.0 |
| 2008-01-07 | YM | Futures | 11448.0 | 11508.4 | 11353.8 | 11439.1 | 205987.0 |
| 2008-01-07 | CL | Futures | 417.42 | 420.03 | 403.25 | 405.9 | 258890.0 |
| 2008-01-07 | ZN | Futures | 82.496796 | 82.788622 | 82.373332 | 82.721277 | 1076770.0 |
| 2008-01-07 | A6 | Futures | 0.65358 | 0.65652 | 0.65147 | 0.652 | 36541.0 |
| 2008-01-07 | AD | Futures | 0.97965 | 0.98574 | 0.97464 | 0.9767 | 34566.0 |
| 2008-01-07 | B6 | Futures | 2.0029 | 2.0055 | 1.9947 | 1.9992 | 44803.0 |
| 2008-01-07 | CB | Futures | 87.305 | 87.305 | 86.111 | 87.305 | 8.0 |
| 2008-01-07 | DC | Futures | 44.86 | 45.11 | 43.24 | 43.31 | 242.0 |
| 2008-01-07 | DX | Futures | 82.042 | 82.425 | 81.956 | 82.263 | 2049.0 |
| 2008-01-07 | E1 | Futures | 1.2085 | 1.2085 | 1.19491 | 1.19811 | 46443.0 |
| 2008-01-07 | E6 | Futures | 1.71247 | 1.7127 | 1.70098 | 1.70516 | 106089.0 |
| 2008-01-07 | E7 | Futures | 1.6988 | 1.6993 | 1.6884 | 1.6923 | 1206.0 |
| 2008-01-07 | ED | Futures | 90.7696 | 90.8121 | 90.7412 | 90.7979 | 198829.0 |
| 2008-01-07 | ER | Futures | 94.13 | 94.13 | 94.091 | 94.111 | 80341.0 |
| 2008-01-07 | EW | Futures | 819.7 | 824.6 | 805.7 | 812.8 | 36529.0 |
| 2008-01-07 | FDAX | Futures | 8875.4 | 8980.7 | 8869.7 | 8930.9 | 160695.0 |
| 2008-01-07 | FESX | Futures | 2429.5 | 2468.8 | 2426.1 | 2459.1 | 1162309.0 |
| 2008-01-07 | FEU3 | Futures | 94.576 | 94.59 | 94.571 | 94.586 | 1026.0 |
| 2008-01-07 | FTDX | Futures | 850.5 | 869.7 | 827.7 | 831.3 | 1511.0 |
| 2008-01-07 | FTUK | Futures | 4108.5 | 4132.2 | 4062.9 | 4109.2 | 127211.0 |
| 2008-01-07 | G | Futures | 70.15 | 70.21 | 70.04 | 70.17 | 65187.0 |
| 2008-01-07 | HG | Futures | 4.4011 | 4.4827 | 4.366 | 4.4152 | 8784.0 |
| 2008-01-07 | J1 | Futures | 0.0119095 | 0.0119121 | 0.011766 | 0.0118416 | 116006.0 |
| 2008-01-07 | J7 | Futures | 0.011679 | 0.011681 | 0.01156 | 0.011633 | 46.0 |
| 2008-01-07 | JB | Futures | 114.57 | 114.59 | 114.34 | 114.44 | 2677.0 |
| 2008-01-07 | KC | Futures | 422.94 | 423.74 | 415.63 | 417.85 | 9124.0 |
| 2008-01-07 | KE | Futures | 5118.05 | 5141.07 | 4960.94 | 4960.94 | 6279.0 |
| 2008-01-07 | L | Futures | 94.083 | 94.113 | 94.063 | 94.093 | 58876.0 |
| 2008-01-07 | MP | Futures | 0.04297 | 0.04314 | 0.04293 | 0.04307 | 21218.0 |
| 2008-01-07 | N6 | Futures | 0.5698 | 0.57235 | 0.56575 | 0.56913 | 817.0 |
| 2008-01-07 | PA | Futures | 440.23 | 452.23 | 436.64 | 452.05 | 764.0 |
| 2008-01-07 | PJY | Futures | 168.53 | 168.53 | 168.53 | 168.53 | 0.0 |
| 2008-01-07 | PL | Futures | 1823.4 | 1824.5 | 1797.7 | 1808.1 | 1429.0 |
| 2008-01-07 | PSI | Futures | 10022.8 | 10022.8 | 9901.0 | 9963.8 | 230.0 |
| 2008-01-07 | RP | Futures | 0.8528 | 0.85337 | 0.84893 | 0.85098 | 263.0 |
| 2008-01-07 | RTY | Futures | 737.2 | 744.2 | 726.0 | 736.2 | 296295.0 |
| 2008-01-07 | RY | Futures | 145.15 | 145.8 | 144.88 | 145.14 | 953.0 |
| 2008-01-07 | SI | Futures | 26.533 | 26.671 | 26.189 | 26.344 | 19486.0 |
| 2008-01-07 | US | Futures | 89.768213 | 90.220266 | 89.506498 | 90.148889 | 292333.0 |
| 2008-01-07 | ZF | Futures | 91.2957876 | 91.4877737 | 91.180596 | 91.3725821 | 519472.0 |
| 2008-01-07 | ZL | Futures | 50.86 | 51.2 | 50.53 | 50.61 | 27558.0 |
| 2008-01-07 | ZT | Futures | 98.09068116 | 98.14140773 | 97.97473473 | 98.06169455 | 254032.0 |
| 2008-01-07 | ZW | Futures | 7076.62 | 7131.98 | 6883.81 | 6895.27 | 42067.0 |
> showing 45 of 45 rows — these rows as CSV