PREVIEW / futures_daily / 2010-08-05
file: by_date/futures_daily/2010/2010-08-05.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-08-05 | ES | Futures | 1097.03 | 1099.95 | 1088.01 | 1095.81 | 1340145.0 |
| 2010-08-05 | NQ | Futures | 2157.54 | 2164.9 | 2140.28 | 2151.6 | 224033.0 |
| 2010-08-05 | YM | Futures | 9836.7 | 9859.8 | 9772.0 | 9833.0 | 83313.0 |
| 2010-08-05 | CL | Futures | 175.03 | 175.12 | 173.16 | 174.12 | 234811.0 |
| 2010-08-05 | GC | Futures | 1627.0 | 1634.9 | 1620.2 | 1630.2 | 76534.0 |
| 2010-08-05 | ZN | Futures | 101.323192 | 101.668961 | 101.220741 | 101.540898 | 962022.0 |
| 2010-08-05 | A6 | Futures | 0.75616 | 0.75715 | 0.75234 | 0.75483 | 67537.0 |
| 2010-08-05 | AD | Futures | 0.96969 | 0.97671 | 0.9689 | 0.97068 | 72796.0 |
| 2010-08-05 | B | Futures | 71.53 | 71.72 | 70.69 | 71.2 | 74633.0 |
| 2010-08-05 | B6 | Futures | 1.6484 | 1.6524 | 1.6414 | 1.6477 | 84481.0 |
| 2010-08-05 | BFX | Futures | 2960.1 | 2979.5 | 2947.7 | 2953.3 | 81.0 |
| 2010-08-05 | BR | Futures | 0.23685 | 0.23685 | 0.23685 | 0.23685 | 4.0 |
| 2010-08-05 | BZ | Futures | 76.48 | 76.61 | 76.24 | 76.61 | 56.0 |
| 2010-08-05 | C | Futures | 2499.0 | 2533.0 | 2497.0 | 2499.0 | 3346.0 |
| 2010-08-05 | CB | Futures | 88.847 | 88.847 | 88.606 | 88.835 | 14.0 |
| 2010-08-05 | CC | Futures | 2601.0 | 2633.0 | 2580.0 | 2598.0 | 4436.0 |
| 2010-08-05 | CT | Futures | 70.79 | 72.35 | 70.61 | 70.83 | 246.0 |
| 2010-08-05 | DC | Futures | 23.23 | 23.49 | 23.23 | 23.43 | 177.0 |
| 2010-08-05 | DX | Futures | 81.732 | 81.868 | 81.263 | 81.571 | 14145.0 |
| 2010-08-05 | E1 | Futures | 1.247 | 1.26171 | 1.24608 | 1.25383 | 34699.0 |
| 2010-08-05 | E6 | Futures | 1.55569 | 1.56503 | 1.55119 | 1.55794 | 242098.0 |
| 2010-08-05 | E7 | Futures | 1.5444 | 1.5536 | 1.5401 | 1.5467 | 3003.0 |
| 2010-08-05 | ED | Futures | 94.5274 | 94.5369 | 94.5131 | 94.5274 | 158000.0 |
| 2010-08-05 | ER | Futures | 97.252 | 97.252 | 97.222 | 97.237 | 114562.0 |
| 2010-08-05 | EW | Futures | 760.5 | 762.7 | 752.3 | 757.3 | 18591.0 |
| 2010-08-05 | FBTP | Futures | 66.67 | 66.82 | 66.58 | 66.8 | 1259.0 |
| 2010-08-05 | FCE | Futures | 2473.9 | 2494.6 | 2465.1 | 2470.3 | 85464.0 |
| 2010-08-05 | FDAX | Futures | 6905.9 | 6948.9 | 6879.8 | 6899.4 | 101154.0 |
| 2010-08-05 | FESX | Futures | 1751.6 | 1763.4 | 1739.9 | 1744.8 | 842975.0 |
| 2010-08-05 | FEU3 | Futures | 97.795 | 97.8 | 97.79 | 97.795 | 59.0 |
| 2010-08-05 | FGBL | Futures | 100.93 | 101.34 | 100.79 | 101.24 | 709362.0 |
| 2010-08-05 | FGBM | Futures | 105.17 | 105.36 | 105.04 | 105.29 | 363915.0 |
| 2010-08-05 | FGBS | Futures | 107.431 | 107.441 | 107.308 | 107.397 | 377925.0 |
| 2010-08-05 | FGBX | Futures | 100.68 | 101.68 | 100.52 | 101.5 | 3714.0 |
| 2010-08-05 | FTDX | Futures | 693.3 | 693.3 | 682.7 | 682.7 | 613.0 |
| 2010-08-05 | FTI | Futures | 269.87 | 270.78 | 266.45 | 267.2 | 21030.0 |
| 2010-08-05 | FTUK | Futures | 3695.1 | 3717.1 | 3674.4 | 3685.8 | 65075.0 |
| 2010-08-05 | G | Futures | 81.86 | 82.27 | 81.77 | 82.22 | 77100.0 |
| 2010-08-05 | GF | Futures | 287.287 | 287.792 | 283.687 | 284.697 | 1094.0 |
| 2010-08-05 | GSCI | Futures | 925.4 | 928.29 | 919.8 | 919.97 | 613.0 |
| 2010-08-05 | HE | Futures | 103.839 | 103.839 | 100.051 | 100.15 | 21954.0 |
| 2010-08-05 | HG | Futures | 4.5535 | 4.5649 | 4.4497 | 4.4912 | 33067.0 |
| 2010-08-05 | HO | Futures | 1.9288 | 1.9332 | 1.9119 | 1.9164 | 52888.0 |
| 2010-08-05 | HRC | Futures | 2729.3 | 2729.3 | 2729.3 | 2729.3 | 0.0 |
| 2010-08-05 | J1 | Futures | 0.0145802 | 0.0146834 | 0.0145563 | 0.0146569 | 87377.0 |
| 2010-08-05 | J7 | Futures | 0.014455 | 0.014574 | 0.014448 | 0.014547 | 101.0 |
| 2010-08-05 | JB | Futures | 121.11 | 121.12 | 120.89 | 120.91 | 1471.0 |
| 2010-08-05 | KC | Futures | 425.68 | 433.59 | 424.67 | 426.56 | 10687.0 |
| 2010-08-05 | KE | Futures | 3091.62 | 3351.57 | 3079.91 | 3323.87 | 17439.0 |
| 2010-08-05 | L | Futures | 98.096 | 98.106 | 98.096 | 98.106 | 10883.0 |
> showing 50 of 90 rows — these rows as CSV