PREVIEW / futures_daily / 2010-08-25
file: by_date/futures_daily/2010/2010-08-25.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-25 | ES | Futures | 1024.12 | 1031.68 | 1011.44 | 1028.51 | 2478780.0 |
| 2010-08-25 | NQ | Futures | 2007.57 | 2035.59 | 1988.33 | 2025.68 | 354186.0 |
| 2010-08-25 | YM | Futures | 9267.2 | 9318.0 | 9166.4 | 9289.3 | 146529.0 |
| 2010-08-25 | CL | Futures | 150.76 | 153.92 | 149.26 | 152.98 | 343405.0 |
| 2010-08-25 | GC | Futures | 1674.7 | 1690.1 | 1673.1 | 1687.2 | 107824.0 |
| 2010-08-25 | ZN | Futures | 103.653932 | 103.986895 | 103.116069 | 103.205713 | 1901405.0 |
| 2010-08-25 | A6 | Futures | 0.72947 | 0.73568 | 0.72466 | 0.72963 | 110601.0 |
| 2010-08-25 | AD | Futures | 0.93048 | 0.93374 | 0.92545 | 0.93108 | 89938.0 |
| 2010-08-25 | B | Futures | 62.88 | 64.12 | 62.28 | 63.75 | 78429.0 |
| 2010-08-25 | B6 | Futures | 1.5985 | 1.6056 | 1.5967 | 1.6032 | 95710.0 |
| 2010-08-25 | BFX | Futures | 2776.5 | 2794.0 | 2749.2 | 2767.9 | 90.0 |
| 2010-08-25 | BR | Futures | 0.23649 | 0.23728 | 0.23649 | 0.23728 | 133.0 |
| 2010-08-25 | BZ | Futures | 67.66 | 67.66 | 67.66 | 67.66 | 143.0 |
| 2010-08-25 | C | Futures | 2273.0 | 2278.0 | 2223.0 | 2238.0 | 996.0 |
| 2010-08-25 | CB | Futures | 96.923 | 96.923 | 96.09 | 96.645 | 8.0 |
| 2010-08-25 | CC | Futures | 2320.0 | 2326.0 | 2270.0 | 2278.0 | 8831.0 |
| 2010-08-25 | CT | Futures | 74.61 | 74.66 | 74.15 | 74.15 | 16.0 |
| 2010-08-25 | DC | Futures | 24.11 | 24.19 | 23.99 | 24.14 | 85.0 |
| 2010-08-25 | DX | Futures | 84.025 | 84.232 | 83.657 | 83.991 | 25464.0 |
| 2010-08-25 | E1 | Futures | 1.27261 | 1.28207 | 1.27169 | 1.27642 | 35952.0 |
| 2010-08-25 | E6 | Futures | 1.49396 | 1.50496 | 1.49077 | 1.49633 | 333730.0 |
| 2010-08-25 | E7 | Futures | 1.4832 | 1.494 | 1.48 | 1.4856 | 5040.0 |
| 2010-08-25 | ED | Futures | 94.5962 | 94.6033 | 94.5701 | 94.5867 | 257908.0 |
| 2010-08-25 | ER | Futures | 97.321 | 97.326 | 97.306 | 97.316 | 99511.0 |
| 2010-08-25 | EW | Futures | 701.5 | 710.2 | 692.5 | 707.7 | 35849.0 |
| 2010-08-25 | FBTP | Futures | 67.28 | 67.47 | 67.27 | 67.41 | 3968.0 |
| 2010-08-25 | FCE | Futures | 2283.2 | 2305.9 | 2244.3 | 2273.0 | 160043.0 |
| 2010-08-25 | FDAX | Futures | 6428.3 | 6481.1 | 6349.4 | 6430.5 | 163553.0 |
| 2010-08-25 | FESX | Futures | 1606.2 | 1623.5 | 1579.5 | 1603.1 | 1536792.0 |
| 2010-08-25 | FGBL | Futures | 104.46 | 105.23 | 104.27 | 104.8 | 1227277.0 |
| 2010-08-25 | FGBM | Futures | 106.84 | 107.06 | 106.65 | 106.89 | 504237.0 |
| 2010-08-25 | FGBS | Futures | 107.917 | 107.927 | 107.834 | 107.883 | 484602.0 |
| 2010-08-25 | FGBX | Futures | 109.34 | 111.91 | 109.03 | 110.92 | 8883.0 |
| 2010-08-25 | FTDX | Futures | 642.1 | 642.6 | 629.8 | 632.0 | 257.0 |
| 2010-08-25 | FTI | Futures | 249.43 | 251.39 | 245.99 | 249.19 | 38847.0 |
| 2010-08-25 | FTUK | Futures | 3540.6 | 3554.4 | 3483.5 | 3519.6 | 104667.0 |
| 2010-08-25 | G | Futures | 84.64 | 85.32 | 84.62 | 84.98 | 158893.0 |
| 2010-08-25 | GF | Futures | 293.482 | 295.188 | 292.345 | 294.241 | 1209.0 |
| 2010-08-25 | GSCI | Futures | 838.33 | 843.76 | 830.95 | 843.76 | 492.0 |
| 2010-08-25 | HE | Futures | 102.093 | 103.345 | 100.973 | 101.566 | 15010.0 |
| 2010-08-25 | HG | Futures | 4.3311 | 4.3778 | 4.271 | 4.313 | 12306.0 |
| 2010-08-25 | HO | Futures | 1.6959 | 1.7222 | 1.6791 | 1.7145 | 15598.0 |
| 2010-08-25 | HRC | Futures | 2776.6 | 2776.6 | 2776.6 | 2776.6 | 50.0 |
| 2010-08-25 | J1 | Futures | 0.0149601 | 0.014974 | 0.0148318 | 0.0148507 | 143155.0 |
| 2010-08-25 | J7 | Futures | 0.014833 | 0.014859 | 0.014721 | 0.014739 | 333.0 |
| 2010-08-25 | JB | Futures | 121.81 | 121.92 | 121.75 | 121.8 | 2200.0 |
| 2010-08-25 | KC | Futures | 417.74 | 421.33 | 410.05 | 413.15 | 12600.0 |
| 2010-08-25 | KE | Futures | 2986.16 | 3020.57 | 2882.9 | 2882.9 | 19650.0 |
| 2010-08-25 | KRW | Futures | 0.0008171 | 0.0008171 | 0.0008171 | 0.0008171 | 7.0 |
| 2010-08-25 | L | Futures | 98.145 | 98.155 | 98.086 | 98.096 | 88718.0 |
> showing 50 of 90 rows — these rows as CSV