PREVIEW / futures_daily / 2010-07-20
file: by_date/futures_daily/2010/2010-07-20.parquet size: 9 KB rows: 90
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-20 | ES | Futures | 1037.04 | 1054.11 | 1024.85 | 1053.38 | 2275816.0 |
| 2010-07-20 | NQ | Futures | 2043.23 | 2083.97 | 2016.63 | 2082.27 | 350306.0 |
| 2010-07-20 | YM | Futures | 9294.9 | 9417.9 | 9196.0 | 9410.5 | 161057.0 |
| 2010-07-20 | CL | Futures | 163.01 | 165.39 | 161.36 | 164.71 | 285817.0 |
| 2010-07-20 | GC | Futures | 1614.0 | 1628.3 | 1602.9 | 1625.6 | 144273.0 |
| 2010-07-20 | ZN | Futures | 100.887779 | 101.25916 | 100.74691 | 101.003035 | 1067189.0 |
| 2010-07-20 | A6 | Futures | 0.71538 | 0.72839 | 0.71364 | 0.72648 | 108284.0 |
| 2010-07-20 | AD | Futures | 0.93611 | 0.94639 | 0.93226 | 0.94263 | 88588.0 |
| 2010-07-20 | B | Futures | 66.27 | 66.88 | 65.35 | 66.64 | 145497.0 |
| 2010-07-20 | B6 | Futures | 1.5803 | 1.5885 | 1.5722 | 1.5839 | 101915.0 |
| 2010-07-20 | BFX | Futures | 2776.5 | 2789.0 | 2714.9 | 2714.9 | 686.0 |
| 2010-07-20 | BR | Futures | 0.23384 | 0.23384 | 0.23363 | 0.23363 | 2.0 |
| 2010-07-20 | BZ | Futures | 70.16 | 71.46 | 69.86 | 71.22 | 408.0 |
| 2010-07-20 | C | Futures | 2562.0 | 2602.0 | 2523.0 | 2528.0 | 7916.0 |
| 2010-07-20 | CB | Futures | 85.467 | 85.467 | 85.467 | 85.467 | 1.0 |
| 2010-07-20 | CC | Futures | 2500.0 | 2523.0 | 2445.0 | 2483.0 | 9371.0 |
| 2010-07-20 | CT | Futures | 65.98 | 66.7 | 65.43 | 65.43 | 56.0 |
| 2010-07-20 | DC | Futures | 22.99 | 23.11 | 22.92 | 23.06 | 187.0 |
| 2010-07-20 | DX | Futures | 83.476 | 83.929 | 83.007 | 83.586 | 17417.0 |
| 2010-07-20 | E1 | Futures | 1.24608 | 1.25725 | 1.2449 | 1.25121 | 36296.0 |
| 2010-07-20 | E6 | Futures | 1.53097 | 1.54067 | 1.51809 | 1.52459 | 285869.0 |
| 2010-07-20 | E7 | Futures | 1.5189 | 1.5295 | 1.5072 | 1.5136 | 3224.0 |
| 2010-07-20 | ED | Futures | 94.423 | 94.4562 | 94.4182 | 94.4514 | 250660.0 |
| 2010-07-20 | ER | Futures | 97.154 | 97.188 | 97.154 | 97.183 | 103352.0 |
| 2010-07-20 | EW | Futures | 712.0 | 726.1 | 702.7 | 724.9 | 25791.0 |
| 2010-07-20 | FBTP | Futures | 65.24 | 65.52 | 65.24 | 65.47 | 3939.0 |
| 2010-07-20 | FCE | Futures | 2295.5 | 2306.7 | 2241.8 | 2274.9 | 134136.0 |
| 2010-07-20 | FDAX | Futures | 6564.8 | 6587.2 | 6431.0 | 6496.3 | 152744.0 |
| 2010-07-20 | FESX | Futures | 1634.0 | 1645.2 | 1598.1 | 1623.5 | 1260968.0 |
| 2010-07-20 | FEU3 | Futures | 97.731 | 97.741 | 97.731 | 97.741 | 85.0 |
| 2010-07-20 | FGBL | Futures | 100.48 | 100.86 | 100.45 | 100.67 | 667157.0 |
| 2010-07-20 | FGBM | Futures | 104.61 | 104.9 | 104.58 | 104.8 | 363429.0 |
| 2010-07-20 | FGBS | Futures | 107.23 | 107.343 | 107.22 | 107.323 | 360475.0 |
| 2010-07-20 | FGBX | Futures | 99.76 | 100.46 | 99.71 | 100.14 | 2586.0 |
| 2010-07-20 | FTDX | Futures | 680.0 | 683.6 | 662.0 | 668.6 | 884.0 |
| 2010-07-20 | FTI | Futures | 256.0 | 256.47 | 250.63 | 253.29 | 35043.0 |
| 2010-07-20 | FTUK | Futures | 3539.9 | 3559.5 | 3479.7 | 3515.1 | 95034.0 |
| 2010-07-20 | G | Futures | 81.38 | 81.6 | 81.21 | 81.39 | 85692.0 |
| 2010-07-20 | GF | Futures | 288.992 | 289.75 | 288.108 | 289.181 | 1314.0 |
| 2010-07-20 | GSCI | Futures | 852.25 | 860.9 | 849.87 | 859.72 | 58.0 |
| 2010-07-20 | HE | Futures | 99.223 | 99.769 | 96.491 | 97.159 | 18952.0 |
| 2010-07-20 | HG | Futures | 3.9261 | 4.058 | 3.9261 | 4.0198 | 34904.0 |
| 2010-07-20 | HO | Futures | 1.7856 | 1.8079 | 1.7708 | 1.797 | 36448.0 |
| 2010-07-20 | HRC | Futures | 2875.5 | 2875.5 | 2875.5 | 2875.5 | 0.0 |
| 2010-07-20 | J1 | Futures | 0.0145047 | 0.0145223 | 0.0143726 | 0.0144343 | 117850.0 |
| 2010-07-20 | J7 | Futures | 0.014402 | 0.014412 | 0.014268 | 0.014326 | 209.0 |
| 2010-07-20 | JB | Futures | 120.74 | 120.84 | 120.58 | 120.65 | 1286.0 |
| 2010-07-20 | KC | Futures | 411.99 | 412.37 | 397.42 | 398.18 | 12362.0 |
| 2010-07-20 | KE | Futures | 2531.25 | 2533.38 | 2504.62 | 2512.08 | 11491.0 |
| 2010-07-20 | L | Futures | 98.076 | 98.086 | 98.056 | 98.066 | 46174.0 |
> showing 50 of 90 rows — these rows as CSV