PREVIEW / stock_daily / 2006-05-01
file: by_date/stock_daily/2006/2006-05-01.parquet size: 148 KB rows: 4,402 symbols: 2,779
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-01 | AAPL | Stock | 2.5275 | 2.555 | 2.47 | 2.4857 | 750380400.0 |
| 2006-05-01 | MSFT | Stock | 24.32 | 25.0 | 24.09 | 24.29 | 174800900.0 |
| 2006-05-01 | NVDA | Stock | 0.4903 | 0.5245 | 0.4903 | 0.515 | 902472000.0 |
| 2006-05-01 | AMZN | Stock | 1.7595 | 1.7785 | 1.722 | 1.7295 | 141454000.0 |
| 2006-05-01 | CL | Stock | 29.625 | 29.7 | 29.29 | 29.375 | 4354800.0 |
| 2006-05-01 | A | Stock | 27.5751 | 27.897 | 27.4678 | 27.7182 | 2977740.0 |
| 2006-05-01 | AABA-DELISTED | Stock | 32.9900016784668 | 33.0999984741211 | 31.8600006103516 | 32.0800018310547 | 19752200.0 |
| 2006-05-01 | AACC-DELISTED | Stock | 20.85 | 21.367 | 20.74 | 20.91 | 104192.0 |
| 2006-05-01 | AACQ-DELISTED | Stock | 5.41 | 5.41 | 5.41 | 5.41 | 1500.0 |
| 2006-05-01 | AAI-DELISTED | Stock | 13.82 | 13.94 | 13.34 | 13.37 | 3144000.0 |
| 2006-05-01 | AAIC-DELISTED | Stock | 219.4 | 219.4 | 209.2 | 214.0 | 1756200.0 |
| 2006-05-01 | AAME | Stock | 2.78 | 3.01 | 2.78 | 3.01 | 9900.0 |
| 2006-05-01 | AAON | Stock | 3.5885 | 3.6267 | 3.549 | 3.5806 | 179212.0 |
| 2006-05-01 | AAP | Stock | 40.11 | 40.26 | 39.29 | 39.44 | 1340700.0 |
| 2006-05-01 | AATI-DELISTED | Stock | 11.19 | 11.3 | 11.02 | 11.11 | 235231.0 |
| 2006-05-01 | AAU-DELISTED | Stock | 2.92 | 3.09 | 2.88 | 2.98 | 140400.0 |
| 2006-05-01 | AAUAF-DELISTED | Stock | 2.92 | 3.09 | 2.88 | 2.98 | 140400.0 |
| 2006-05-01 | AAV-DELISTED | Stock | 19.55 | 19.88 | 19.404 | 19.6 | 260500.0 |
| 2006-05-01 | AAWW-DELISTED | Stock | 46.0 | 47.5 | 46.0 | 47.5 | 18300.0 |
| 2006-05-01 | AAXN-DELISTED | Stock | 10.789999961853 | 10.789999961853 | 10.3199996948242 | 10.3900003433228 | 1532200.0 |
| 2006-05-01 | AB | Stock | 64.95 | 66.6 | 64.95 | 66.35 | 313400.0 |
| 2006-05-01 | ABAX-DELISTED | Stock | 26.35 | 26.36 | 23.6 | 24.15 | 1264315.0 |
| 2006-05-01 | ABB-DELISTED | Stock | 14.39 | 14.48 | 14.08 | 14.1 | 1977000.0 |
| 2006-05-01 | ABBC-DELISTED | Stock | 13.473 | 13.57 | 13.4601 | 13.57 | 67523.0 |
| 2006-05-01 | ABC-DELISTED | Stock | 21.58 | 21.84 | 21.5 | 21.72 | 4116000.0 |
| 2006-05-01 | ABCB | Stock | 21.5926 | 21.8844 | 20.8632 | 20.9507 | 11618.0 |
| 2006-05-01 | ABCO-DELISTED | Stock | 28.12 | 28.47 | 26.69 | 27.08 | 207264.0 |
| 2006-05-01 | ABCW-DELISTED | Stock | 29.21 | 29.4 | 28.77 | 28.92 | 40570.0 |
| 2006-05-01 | ABD-DELISTED | Stock | 21.58 | 21.58 | 21.25 | 21.41 | 365560.0 |
| 2006-05-01 | ABE-DELISTED | Stock | 13.8 | 14.08 | 13.77 | 14.08 | 27700.0 |
| 2006-05-01 | ABFS-DELISTED | Stock | 42.89 | 43.21 | 41.7 | 42.25 | 264352.0 |
| 2006-05-01 | ABG | Stock | 19.27 | 19.99 | 19.07 | 19.68 | 165800.0 |
| 2006-05-01 | ABK-DELISTED | Stock | 82.17 | 83.2 | 81.73 | 81.76 | 1011300.0 |
| 2006-05-01 | ABM | Stock | 17.32 | 17.46 | 17.2 | 17.34 | 178500.0 |
| 2006-05-01 | ABMD-DELISTED | Stock | 12.95 | 13.44 | 12.82 | 12.98 | 91665.0 |
| 2006-05-01 | ABP-DELISTED | Stock | 6.26 | 6.3 | 6.12 | 6.22 | 329500.0 |
| 2006-05-01 | ABR | Stock | 25.76 | 25.94 | 25.07 | 25.17 | 118600.0 |
| 2006-05-01 | ABT | Stock | 20.5114 | 20.6506 | 20.2236 | 20.3051 | 9777407.0 |
| 2006-05-01 | ABTL-DELISTED | Stock | 22.5 | 23.1 | 22.2 | 22.4 | 38475.0 |
| 2006-05-01 | ABV-DELISTED | Stock | 46.27 | 47.2013 | 46.27 | 46.78 | 279400.0 |
| 2006-05-01 | ABVA-DELISTED | Stock | 18.71 | 18.8 | 18.7 | 18.75 | 7146.0 |
| 2006-05-01 | ABVT-DELISTED | Stock | 45.0 | 45.0 | 45.0 | 45.0 | 100.0 |
| 2006-05-01 | ABX-DELISTED | Stock | 30.96 | 31.13 | 30.61 | 30.99 | 3803059.0 |
| 2006-05-01 | ACAD | Stock | 11.41 | 12.04 | 11.41 | 11.9 | 523200.0 |
| 2006-05-01 | ACAP-DELISTED | Stock | 48.0 | 48.6 | 46.49 | 46.87 | 58805.0 |
| 2006-05-01 | ACAS-DELISTED | Stock | 34.94 | 35.0 | 33.97 | 34.0 | 1144760.0 |
| 2006-05-01 | ACAT-DELISTED | Stock | 21.78 | 22.2 | 21.36 | 21.55 | 73896.0 |
| 2006-05-01 | ACC-DELISTED | Stock | 24.05 | 24.25 | 23.76 | 23.77 | 47000.0 |
| 2006-05-01 | ACCL-DELISTED | Stock | 7.0 | 7.01 | 6.702 | 6.85 | 87496.0 |
| 2006-05-01 | ACCO | Stock | 21.58 | 21.58 | 21.25 | 21.41 | 466500.0 |
> showing 50 of 4,402 rows — these rows as CSV