PREVIEW / stock_daily / 2009-11-05
file: by_date/stock_daily/2009/2009-11-05.parquet size: 185 KB rows: 5,850 symbols: 3,472
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-11-05 | AAPL | Stock | 6.8714 | 6.9643 | 6.8507 | 6.9296 | 384801200.0 |
| 2009-11-05 | MSFT | Stock | 28.52 | 28.74 | 28.28 | 28.47 | 52681700.0 |
| 2009-11-05 | NVDA | Stock | 0.303 | 0.3098 | 0.302 | 0.3068 | 955156000.0 |
| 2009-11-05 | AMZN | Stock | 5.873 | 6.0475 | 5.8125 | 6.0305 | 181736000.0 |
| 2009-11-05 | TLT | Stock | 92.87 | 93.24 | 92.8 | 93.24 | 2852043.0 |
| 2009-11-05 | ES | Stock | 22.89 | 23.18 | 22.85 | 23.17 | 1087400.0 |
| 2009-11-05 | CL | Stock | 39.295 | 39.825 | 39.1 | 39.8 | 4308200.0 |
| 2009-11-05 | A | Stock | 18.1116 | 18.7339 | 18.0973 | 18.691 | 3690720.0 |
| 2009-11-05 | AABA-DELISTED | Stock | 15.82 | 16.0 | 15.74 | 15.91 | 27387506.0 |
| 2009-11-05 | AACC-DELISTED | Stock | 5.37 | 5.46 | 5.13 | 5.21 | 69178.0 |
| 2009-11-05 | AACG | Stock | 5.1 | 5.1 | 5.0 | 5.02 | 2400.0 |
| 2009-11-05 | AAI-DELISTED | Stock | 4.15 | 4.24 | 4.08 | 4.15 | 4070303.0 |
| 2009-11-05 | AAIC-DELISTED | Stock | 12.45 | 12.62 | 12.36 | 12.45 | 30091.0 |
| 2009-11-05 | AAON | Stock | 3.7393 | 3.8044 | 3.6879 | 3.7926 | 338175.0 |
| 2009-11-05 | AAP | Stock | 37.81 | 37.98 | 37.3 | 37.72 | 1486400.0 |
| 2009-11-05 | AATI-DELISTED | Stock | 3.03 | 3.17 | 3.02 | 3.13 | 300149.0 |
| 2009-11-05 | AAU-DELISTED | Stock | 0.72 | 0.7706 | 0.71 | 0.717 | 246773.0 |
| 2009-11-05 | AAUAF-DELISTED | Stock | 0.72 | 0.77 | 0.71 | 0.715 | 250030.0 |
| 2009-11-05 | AAV-DELISTED | Stock | 6.27 | 6.44 | 6.24 | 6.42 | 445825.0 |
| 2009-11-05 | AAWW-DELISTED | Stock | 26.36 | 27.34 | 26.36 | 26.74 | 464986.0 |
| 2009-11-05 | AAXJ | Stock | 52.89 | 53.29 | 52.62 | 53.28 | 68098.0 |
| 2009-11-05 | AAXN-DELISTED | Stock | 4.05 | 4.09 | 4.0301 | 4.07 | 327646.0 |
| 2009-11-05 | AB | Stock | 26.93 | 27.04 | 26.02 | 26.3 | 675400.0 |
| 2009-11-05 | ABAX-DELISTED | Stock | 23.14 | 23.65 | 22.99 | 23.43 | 83378.0 |
| 2009-11-05 | ABB-DELISTED | Stock | 19.18 | 19.42 | 19.1 | 19.36 | 2079820.0 |
| 2009-11-05 | ABBC-DELISTED | Stock | 6.55 | 6.72 | 6.52 | 6.71 | 42593.0 |
| 2009-11-05 | ABBNY-DELISTED | Stock | 19.18 | 19.42 | 19.1 | 19.33 | 2116233.0 |
| 2009-11-05 | ABC-DELISTED | Stock | 23.16 | 23.59 | 23.14 | 23.43 | 3112627.0 |
| 2009-11-05 | ABCB | Stock | 5.2731 | 5.4592 | 4.9692 | 5.028 | 53667.0 |
| 2009-11-05 | ABCO-DELISTED | Stock | 12.677 | 13.138 | 12.547 | 12.973 | 127450.0 |
| 2009-11-05 | ABCW-DELISTED | Stock | 0.69 | 0.7103 | 0.645 | 0.67 | 90430.0 |
| 2009-11-05 | ABD-DELISTED | Stock | 6.0 | 6.2801 | 5.89 | 6.24 | 315700.0 |
| 2009-11-05 | ABE-DELISTED | Stock | 16.28 | 16.37 | 16.23 | 16.3 | 12023.0 |
| 2009-11-05 | ABEO | Stock | 3875.0 | 4125.0 | 3875.0 | 4037.5 | 13.0 |
| 2009-11-05 | ABFS-DELISTED | Stock | 23.54 | 24.2 | 23.31 | 23.89 | 297149.0 |
| 2009-11-05 | ABG | Stock | 10.24 | 10.55 | 10.11 | 10.41 | 387500.0 |
| 2009-11-05 | ABII-DELISTED | Stock | 33.96 | 34.4 | 32.91 | 33.03 | 34250.0 |
| 2009-11-05 | ABK-DELISTED | Stock | 1.44 | 1.44 | 1.16 | 1.198 | 61607349.0 |
| 2009-11-05 | ABM | Stock | 18.53 | 18.9 | 18.49 | 18.86 | 110400.0 |
| 2009-11-05 | ABMD-DELISTED | Stock | 8.91 | 9.84 | 8.9 | 9.66 | 556457.0 |
| 2009-11-05 | ABR | Stock | 1.97 | 2.11 | 1.95 | 2.11 | 136000.0 |
| 2009-11-05 | ABT | Stock | 24.489 | 24.8392 | 24.4602 | 24.7673 | 10392872.0 |
| 2009-11-05 | ABTL-DELISTED | Stock | 3.9002 | 4.0503 | 3.9002 | 3.9998 | 12010.0 |
| 2009-11-05 | ABV-DELISTED | Stock | 93.13 | 96.13 | 92.56 | 96.06 | 546186.0 |
| 2009-11-05 | ABVA-DELISTED | Stock | 2.28 | 2.28 | 2.23 | 2.23 | 4341.0 |
| 2009-11-05 | ABVT-DELISTED | Stock | 48.7 | 51.0 | 48.7 | 50.98 | 108726.0 |
| 2009-11-05 | ABX-DELISTED | Stock | 40.14 | 40.77 | 39.76 | 40.77 | 12082255.0 |
| 2009-11-05 | ACAD | Stock | 1.34 | 1.4 | 1.28 | 1.4 | 777600.0 |
| 2009-11-05 | ACAP-DELISTED | Stock | 28.53 | 28.58 | 28.33 | 28.44 | 48262.0 |
| 2009-11-05 | ACAS-DELISTED | Stock | 2.85 | 3.05 | 2.8098 | 3.02 | 6578859.0 |
> showing 50 of 5,850 rows — these rows as CSV