PREVIEW / futures_daily / 2009-06-22
file: by_date/futures_daily/2009/2009-06-22.parquet size: 8 KB rows: 85
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-22 | ES | Futures | 877.41 | 881.97 | 851.74 | 852.46 | 2043793.0 |
| 2009-06-22 | NQ | Futures | 1648.42 | 1656.02 | 1600.56 | 1608.16 | 312002.0 |
| 2009-06-22 | YM | Futures | 7633.9 | 7677.2 | 7466.1 | 7473.3 | 138109.0 |
| 2009-06-22 | CL | Futures | 184.71 | 184.97 | 175.42 | 177.6 | 278468.0 |
| 2009-06-22 | GC | Futures | 1294.6 | 1295.3 | 1271.4 | 1275.1 | 96762.0 |
| 2009-06-22 | ZN | Futures | 90.177822 | 90.81808 | 90.03007 | 90.731891 | 538689.0 |
| 2009-06-22 | A6 | Futures | 0.6429 | 0.6433 | 0.62281 | 0.62972 | 71413.0 |
| 2009-06-22 | AD | Futures | 0.87116 | 0.87195 | 0.85506 | 0.85773 | 61525.0 |
| 2009-06-22 | B | Futures | 66.45 | 66.6 | 63.25 | 64.07 | 135156.0 |
| 2009-06-22 | B6 | Futures | 1.7184 | 1.7199 | 1.6995 | 1.7021 | 99004.0 |
| 2009-06-22 | BFX | Futures | 2273.9 | 2278.4 | 2214.1 | 2222.5 | 162.0 |
| 2009-06-22 | BR | Futures | 0.19036 | 0.19071 | 0.18916 | 0.19036 | 29.0 |
| 2009-06-22 | C | Futures | 1689.0 | 1699.0 | 1675.0 | 1681.0 | 2341.0 |
| 2009-06-22 | CB | Futures | 72.331 | 72.331 | 72.331 | 72.331 | 2.0 |
| 2009-06-22 | CC | Futures | 2232.0 | 2232.0 | 2201.0 | 2206.0 | 4875.0 |
| 2009-06-22 | CT | Futures | 47.72 | 47.93 | 46.4 | 46.73 | 4740.0 |
| 2009-06-22 | DC | Futures | 20.49 | 20.63 | 20.28 | 20.4 | 158.0 |
| 2009-06-22 | DX | Futures | 83.147 | 83.214 | 82.518 | 83.05 | 4584.0 |
| 2009-06-22 | E1 | Futures | 1.22689 | 1.22808 | 1.21617 | 1.22027 | 41617.0 |
| 2009-06-22 | E6 | Futures | 1.65506 | 1.65541 | 1.64033 | 1.64556 | 194318.0 |
| 2009-06-22 | E7 | Futures | 1.6378 | 1.6378 | 1.6236 | 1.6287 | 2784.0 |
| 2009-06-22 | ED | Futures | 93.6875 | 93.7347 | 93.6875 | 93.7205 | 157547.0 |
| 2009-06-22 | ER | Futures | 96.826 | 96.846 | 96.821 | 96.836 | 82234.0 |
| 2009-06-22 | EW | Futures | 555.9 | 559.0 | 536.1 | 538.7 | 29686.0 |
| 2009-06-22 | FCE | Futures | 2099.6 | 2105.1 | 2025.5 | 2036.3 | 124171.0 |
| 2009-06-22 | FDAX | Futures | 5321.3 | 5339.9 | 5138.6 | 5169.9 | 137030.0 |
| 2009-06-22 | FESX | Futures | 1448.1 | 1451.7 | 1396.8 | 1408.1 | 1013921.0 |
| 2009-06-22 | FEU3 | Futures | 97.406 | 97.411 | 97.406 | 97.411 | 231.0 |
| 2009-06-22 | FGBL | Futures | 91.07 | 91.44 | 90.93 | 91.35 | 551917.0 |
| 2009-06-22 | FGBM | Futures | 97.32 | 97.45 | 97.2 | 97.39 | 308872.0 |
| 2009-06-22 | FGBS | Futures | 103.791 | 103.801 | 103.714 | 103.772 | 381025.0 |
| 2009-06-22 | FGBX | Futures | 81.19 | 82.17 | 81.19 | 82.03 | 978.0 |
| 2009-06-22 | FTDX | Futures | 548.7 | 548.7 | 522.9 | 526.4 | 578.0 |
| 2009-06-22 | FTI | Futures | 208.34 | 209.56 | 201.47 | 202.08 | 31973.0 |
| 2009-06-22 | FTUK | Futures | 2863.4 | 2867.7 | 2774.4 | 2793.4 | 98951.0 |
| 2009-06-22 | G | Futures | 74.98 | 75.5 | 74.96 | 75.43 | 79952.0 |
| 2009-06-22 | GF | Futures | 270.807 | 273.012 | 270.531 | 272.667 | 1945.0 |
| 2009-06-22 | GSCI | Futures | 937.96 | 937.96 | 916.37 | 920.02 | 784.0 |
| 2009-06-22 | HE | Futures | 89.812 | 90.068 | 87.655 | 88.386 | 4182.0 |
| 2009-06-22 | HG | Futures | 3.1705 | 3.1705 | 2.9971 | 3.0104 | 14587.0 |
| 2009-06-22 | HO | Futures | 1.8852 | 1.8944 | 1.8164 | 1.8317 | 6554.0 |
| 2009-06-22 | HRC | Futures | 2328.7 | 2328.7 | 2328.7 | 2328.7 | 0.0 |
| 2009-06-22 | J1 | Futures | 0.0130915 | 0.0131657 | 0.0130839 | 0.0131393 | 57223.0 |
| 2009-06-22 | J7 | Futures | 0.012936 | 0.012979 | 0.012915 | 0.012958 | 49.0 |
| 2009-06-22 | JB | Futures | 115.39 | 115.51 | 115.31 | 115.51 | 1906.0 |
| 2009-06-22 | KC | Futures | 324.79 | 328.05 | 323.44 | 326.83 | 5980.0 |
| 2009-06-22 | KE | Futures | 2994.94 | 2994.94 | 2935.21 | 2944.96 | 8358.0 |
| 2009-06-22 | L | Futures | 96.984 | 97.023 | 96.974 | 97.013 | 32609.0 |
| 2009-06-22 | LBS | Futures | 982.5 | 985.7 | 954.7 | 962.4 | 403.0 |
| 2009-06-22 | LE | Futures | 145.038 | 146.096 | 144.774 | 146.008 | 15852.0 |
> showing 50 of 85 rows — these rows as CSV