PREVIEW / futures_daily / 2010-08-10
file: by_date/futures_daily/2010/2010-08-10.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-10 | ES | Futures | 1097.52 | 1098.0 | 1080.94 | 1092.15 | 2029717.0 |
| 2010-08-10 | NQ | Futures | 2166.31 | 2166.31 | 2128.68 | 2146.51 | 344656.0 |
| 2010-08-10 | YM | Futures | 9857.0 | 9860.7 | 9718.4 | 9817.3 | 127782.0 |
| 2010-08-10 | CL | Futures | 172.91 | 173.29 | 168.15 | 170.38 | 385854.0 |
| 2010-08-10 | GC | Futures | 1635.6 | 1644.6 | 1620.9 | 1628.4 | 101154.0 |
| 2010-08-10 | ZN | Futures | 102.040343 | 102.629431 | 101.873861 | 102.437337 | 1225018.0 |
| 2010-08-10 | A6 | Futures | 0.75624 | 0.7569 | 0.74787 | 0.75466 | 103584.0 |
| 2010-08-10 | AD | Futures | 0.9609 | 0.9611 | 0.95014 | 0.95685 | 96699.0 |
| 2010-08-10 | B | Futures | 70.76 | 70.84 | 68.6 | 69.57 | 131431.0 |
| 2010-08-10 | B6 | Futures | 1.6505 | 1.6508 | 1.6301 | 1.6475 | 133350.0 |
| 2010-08-10 | BR | Futures | 0.2366 | 0.2366 | 0.2366 | 0.2366 | 31.0 |
| 2010-08-10 | BZ | Futures | 74.59 | 74.86 | 74.05 | 74.86 | 68.0 |
| 2010-08-10 | C | Futures | 2366.0 | 2366.0 | 2306.0 | 2315.0 | 4366.0 |
| 2010-08-10 | CB | Futures | 91.02 | 91.901 | 90.779 | 90.779 | 20.0 |
| 2010-08-10 | CC | Futures | 2495.0 | 2495.0 | 2407.0 | 2426.0 | 14293.0 |
| 2010-08-10 | CSC | Futures | 3.857 | 3.857 | 3.857 | 3.857 | 1.0 |
| 2010-08-10 | CT | Futures | 70.75 | 70.98 | 69.65 | 70.98 | 48.0 |
| 2010-08-10 | DC | Futures | 23.77 | 24.06 | 23.72 | 23.85 | 522.0 |
| 2010-08-10 | DX | Futures | 81.485 | 82.296 | 81.414 | 81.565 | 32538.0 |
| 2010-08-10 | E1 | Futures | 1.25278 | 1.25593 | 1.23728 | 1.25304 | 44686.0 |
| 2010-08-10 | E6 | Futures | 1.56385 | 1.56444 | 1.54587 | 1.56054 | 303762.0 |
| 2010-08-10 | E7 | Futures | 1.5527 | 1.5532 | 1.5349 | 1.5493 | 4026.0 |
| 2010-08-10 | ED | Futures | 94.5369 | 94.5606 | 94.5321 | 94.5558 | 178379.0 |
| 2010-08-10 | ER | Futures | 97.237 | 97.262 | 97.232 | 97.252 | 101095.0 |
| 2010-08-10 | EW | Futures | 761.6 | 761.9 | 747.2 | 753.0 | 24486.0 |
| 2010-08-10 | FBTP | Futures | 66.99 | 67.04 | 66.67 | 66.69 | 4582.0 |
| 2010-08-10 | FCE | Futures | 2471.3 | 2473.9 | 2432.6 | 2447.4 | 100261.0 |
| 2010-08-10 | FDAX | Futures | 6897.2 | 6899.4 | 6799.8 | 6835.2 | 118928.0 |
| 2010-08-10 | FESX | Futures | 1743.6 | 1746.7 | 1721.3 | 1730.6 | 991273.0 |
| 2010-08-10 | FEU3 | Futures | 97.795 | 97.81 | 97.795 | 97.81 | 56.0 |
| 2010-08-10 | FGBL | Futures | 101.53 | 101.99 | 101.38 | 101.49 | 523610.0 |
| 2010-08-10 | FGBM | Futures | 105.48 | 105.82 | 105.41 | 105.55 | 329237.0 |
| 2010-08-10 | FGBS | Futures | 107.46 | 107.632 | 107.441 | 107.485 | 357390.0 |
| 2010-08-10 | FGBX | Futures | 101.75 | 101.81 | 100.93 | 101.2 | 3962.0 |
| 2010-08-10 | FTDX | Futures | 681.4 | 681.4 | 673.4 | 677.4 | 159.0 |
| 2010-08-10 | FTI | Futures | 266.85 | 266.93 | 265.13 | 265.69 | 749.0 |
| 2010-08-10 | FTUK | Futures | 3700.6 | 3716.4 | 3668.3 | 3687.5 | 82912.0 |
| 2010-08-10 | G | Futures | 82.2 | 82.31 | 82.07 | 82.14 | 68138.0 |
| 2010-08-10 | GF | Futures | 283.624 | 285.14 | 282.612 | 283.244 | 2543.0 |
| 2010-08-10 | GSCI | Futures | 909.79 | 909.79 | 895.19 | 904.19 | 3183.0 |
| 2010-08-10 | HE | Futures | 97.219 | 97.911 | 97.021 | 97.581 | 11927.0 |
| 2010-08-10 | HG | Futures | 4.4999 | 4.508 | 4.3814 | 4.4363 | 36320.0 |
| 2010-08-10 | HO | Futures | 1.8897 | 1.8943 | 1.8376 | 1.8626 | 60804.0 |
| 2010-08-10 | HRC | Futures | 2729.3 | 2729.3 | 2729.3 | 2729.3 | 0.0 |
| 2010-08-10 | J1 | Futures | 0.0146469 | 0.0147765 | 0.014594 | 0.0147551 | 104497.0 |
| 2010-08-10 | J7 | Futures | 0.014524 | 0.014664 | 0.014484 | 0.014644 | 454.0 |
| 2010-08-10 | JB | Futures | 121.08 | 121.08 | 120.86 | 120.96 | 1656.0 |
| 2010-08-10 | KC | Futures | 424.55 | 431.96 | 420.15 | 426.05 | 12824.0 |
| 2010-08-10 | KE | Futures | 3071.38 | 3114.0 | 3007.46 | 3036.23 | 13681.0 |
| 2010-08-10 | L | Futures | 98.096 | 98.106 | 98.096 | 98.096 | 7372.0 |
> showing 50 of 90 rows — these rows as CSV