PREVIEW / stock_daily / 2010-11-03
file: by_date/stock_daily/2010/2010-11-03.parquet size: 192 KB rows: 5,978 symbols: 3,499
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-11-03 | AAPL | Stock | 11.1204 | 11.1743 | 11.0189 | 11.1714 | 508348400.0 |
| 2010-11-03 | MSFT | Stock | 27.46 | 27.49 | 26.96 | 27.03 | 110255300.0 |
| 2010-11-03 | NVDA | Stock | 0.3093 | 0.3115 | 0.3012 | 0.3095 | 671748000.0 |
| 2010-11-03 | AMZN | Stock | 8.27 | 8.4305 | 8.1145 | 8.4235 | 122242000.0 |
| 2010-11-03 | TSLA | Stock | 1.4187 | 1.5 | 1.4107 | 1.4513 | 5589000.0 |
| 2010-11-03 | TLT | Stock | 101.73 | 102.27 | 98.43 | 98.92 | 25543437.0 |
| 2010-11-03 | ES | Stock | 31.95 | 31.95 | 31.33 | 31.59 | 1494000.0 |
| 2010-11-03 | CL | Stock | 39.13 | 39.23 | 38.715 | 39.23 | 6120800.0 |
| 2010-11-03 | A | Stock | 25.1645 | 25.2361 | 24.721 | 25.1144 | 3352823.0 |
| 2010-11-03 | AABA-DELISTED | Stock | 16.21 | 16.23 | 16.01 | 16.17 | 16910243.0 |
| 2010-11-03 | AACC-DELISTED | Stock | 5.77 | 6.35 | 5.69 | 6.04 | 25862.0 |
| 2010-11-03 | AACG | Stock | 3.52 | 3.56 | 3.21 | 3.56 | 5400.0 |
| 2010-11-03 | AAI-DELISTED | Stock | 7.42 | 7.47 | 7.4 | 7.46 | 8617166.0 |
| 2010-11-03 | AAIC-DELISTED | Stock | 23.94 | 24.17 | 23.5996 | 24.08 | 47917.0 |
| 2010-11-03 | AAON | Stock | 4.8988 | 4.9422 | 4.8849 | 4.9422 | 109856.0 |
| 2010-11-03 | AAP | Stock | 64.57 | 65.09 | 64.19 | 64.94 | 555300.0 |
| 2010-11-03 | AATI-DELISTED | Stock | 3.72 | 3.73 | 3.67 | 3.72 | 83823.0 |
| 2010-11-03 | AAU-DELISTED | Stock | 2.9 | 2.9 | 2.78 | 2.87 | 164607.0 |
| 2010-11-03 | AAUAF-DELISTED | Stock | 2.9 | 2.9 | 2.78 | 2.85 | 165707.0 |
| 2010-11-03 | AAV-DELISTED | Stock | 6.4 | 6.43 | 6.3 | 6.37 | 220525.0 |
| 2010-11-03 | AAWW-DELISTED | Stock | 58.73 | 59.88 | 57.95 | 59.6 | 270329.0 |
| 2010-11-03 | AAXJ | Stock | 63.96 | 64.15 | 63.31 | 64.15 | 560875.0 |
| 2010-11-03 | AAXN-DELISTED | Stock | 3.94 | 4.0 | 3.9 | 3.96 | 348893.0 |
| 2010-11-03 | AB | Stock | 24.28 | 24.5 | 24.1 | 24.26 | 508400.0 |
| 2010-11-03 | ABAC-DELISTED | Stock | 6.99 | 7.25 | 6.8 | 6.9 | 310000.0 |
| 2010-11-03 | ABAX-DELISTED | Stock | 24.89 | 24.92 | 24.17 | 24.7 | 65498.0 |
| 2010-11-03 | ABB-DELISTED | Stock | 20.97 | 21.17 | 20.8 | 21.16 | 2087877.0 |
| 2010-11-03 | ABBC-DELISTED | Stock | 11.01 | 11.27 | 10.97 | 11.25 | 36776.0 |
| 2010-11-03 | ABBNY-DELISTED | Stock | 20.96 | 21.17 | 20.8 | 21.17 | 2097719.0 |
| 2010-11-03 | ABC-DELISTED | Stock | 32.07 | 32.165 | 31.5 | 31.66 | 4113471.0 |
| 2010-11-03 | ABCB | Stock | 9.07 | 9.14 | 8.93 | 9.06 | 29600.0 |
| 2010-11-03 | ABCD-DELISTED | Stock | 3.2 | 3.22 | 3.16 | 3.18 | 30008.0 |
| 2010-11-03 | ABCO-DELISTED | Stock | 24.12 | 24.27 | 23.72 | 24.07 | 43288.0 |
| 2010-11-03 | ABCW-DELISTED | Stock | 0.5308 | 0.5561 | 0.5217 | 0.54 | 48720.0 |
| 2010-11-03 | ABD-DELISTED | Stock | 6.115 | 6.1751 | 5.9148 | 6.095 | 237780.0 |
| 2010-11-03 | ABE-DELISTED | Stock | 18.99 | 19.11 | 18.98 | 19.05 | 8753.0 |
| 2010-11-03 | ABEO | Stock | 3775.0 | 3775.0 | 3625.0 | 3675.0 | 34.0 |
| 2010-11-03 | ABFS-DELISTED | Stock | 26.0 | 26.99 | 25.6 | 25.98 | 586073.0 |
| 2010-11-03 | ABG | Stock | 14.88 | 15.02 | 14.66 | 15.0 | 105600.0 |
| 2010-11-03 | ABK-DELISTED | Stock | 0.509 | 0.55 | 0.4971 | 0.5301 | 29777959.0 |
| 2010-11-03 | ABM | Stock | 23.14 | 23.54 | 23.0 | 23.38 | 190300.0 |
| 2010-11-03 | ABMD-DELISTED | Stock | 10.71 | 10.9 | 10.55 | 10.89 | 140264.0 |
| 2010-11-03 | ABR | Stock | 5.25 | 5.29 | 5.23 | 5.29 | 57600.0 |
| 2010-11-03 | ABT | Stock | 24.4026 | 24.561 | 24.2779 | 24.489 | 12040850.0 |
| 2010-11-03 | ABTL-DELISTED | Stock | 4.15 | 4.2505 | 4.1 | 4.25 | 24365.0 |
| 2010-11-03 | ABV-DELISTED | Stock | 140.63 | 140.63 | 137.55 | 139.91 | 497137.0 |
| 2010-11-03 | ABVT-DELISTED | Stock | 58.25 | 58.455 | 58.0 | 58.43 | 189833.0 |
| 2010-11-03 | ABX-DELISTED | Stock | 48.51 | 48.89 | 47.63 | 48.43 | 10019492.0 |
| 2010-11-03 | ACAD | Stock | 0.72 | 0.75 | 0.72 | 0.74 | 305500.0 |
| 2010-11-03 | ACAS-DELISTED | Stock | 7.25 | 7.5 | 7.15 | 7.3 | 6538104.0 |
> showing 50 of 5,978 rows — these rows as CSV