PREVIEW / stock_daily / 2005-11-04
file: by_date/stock_daily/2005/2005-11-04.parquet size: 141 KB rows: 4,211 symbols: 2,647
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-04 | AAPL | Stock | 2.1554 | 2.1871 | 2.1293 | 2.1839 | 878035200.0 |
| 2005-11-04 | MSFT | Stock | 26.53 | 26.71 | 26.45 | 26.66 | 57464000.0 |
| 2005-11-04 | NVDA | Stock | 0.2889 | 0.2896 | 0.2808 | 0.2838 | 570276000.0 |
| 2005-11-04 | AMZN | Stock | 2.0745 | 2.09 | 2.0455 | 2.0545 | 88908000.0 |
| 2005-11-04 | CL | Stock | 25.85 | 26.08 | 25.85 | 25.925 | 3724000.0 |
| 2005-11-04 | A | Stock | 23.3619 | 23.6052 | 23.3548 | 23.4621 | 2857652.0 |
| 2005-11-04 | AABA-DELISTED | Stock | 37.5900001525879 | 37.9900016784668 | 37.3699989318848 | 37.8699989318848 | 11656100.0 |
| 2005-11-04 | AACC-DELISTED | Stock | 18.35 | 18.67 | 18.13 | 18.5 | 259042.0 |
| 2005-11-04 | AAI-DELISTED | Stock | 15.18 | 15.29 | 14.91 | 15.28 | 870800.0 |
| 2005-11-04 | AAIC-DELISTED | Stock | 182.4 | 182.4 | 180.0 | 180.6 | 1130400.0 |
| 2005-11-04 | AAME | Stock | 2.7 | 2.7 | 2.7 | 2.7 | 2400.0 |
| 2005-11-04 | AAON | Stock | 2.2966 | 2.3216 | 2.2953 | 2.3216 | 167822.0 |
| 2005-11-04 | AAP | Stock | 39.8 | 39.97 | 39.13 | 39.49 | 1201900.0 |
| 2005-11-04 | AATI-DELISTED | Stock | 10.29 | 10.5 | 10.15 | 10.45 | 47443.0 |
| 2005-11-04 | AAV-DELISTED | Stock | 16.5 | 16.69 | 16.4 | 16.5 | 15400.0 |
| 2005-11-04 | AAXN-DELISTED | Stock | 7.40000009536743 | 7.98999977111816 | 7.15000009536743 | 7.98000001907349 | 8093100.0 |
| 2005-11-04 | ABAX-DELISTED | Stock | 17.0 | 17.05 | 16.57 | 16.72 | 199317.0 |
| 2005-11-04 | ABB-DELISTED | Stock | 8.04 | 8.07 | 7.86 | 7.95 | 7118900.0 |
| 2005-11-04 | ABBC-DELISTED | Stock | 12.05 | 12.13 | 12.05 | 12.08 | 7610.0 |
| 2005-11-04 | ABC-DELISTED | Stock | 19.28 | 19.28 | 19.02 | 19.12 | 3480000.0 |
| 2005-11-04 | ABCB | Stock | 18.9665 | 18.9957 | 18.6553 | 18.9957 | 6888.0 |
| 2005-11-04 | ABCO-DELISTED | Stock | 24.42 | 24.48 | 23.75 | 24.14 | 158950.0 |
| 2005-11-04 | ABCW-DELISTED | Stock | 31.87 | 32.05 | 31.5 | 32.05 | 25230.0 |
| 2005-11-04 | ABD-DELISTED | Stock | 24.1 | 24.12 | 23.64 | 23.82 | 99900.0 |
| 2005-11-04 | ABE-DELISTED | Stock | 11.24 | 11.3 | 11.18 | 11.26 | 8100.0 |
| 2005-11-04 | ABFS-DELISTED | Stock | 40.25 | 40.62 | 39.41 | 40.25 | 368700.0 |
| 2005-11-04 | ABG | Stock | 17.24 | 17.24 | 16.82 | 17.18 | 29300.0 |
| 2005-11-04 | ABK-DELISTED | Stock | 74.2 | 75.17 | 74.01 | 74.83 | 754300.0 |
| 2005-11-04 | ABM | Stock | 20.3 | 20.47 | 19.85 | 20.08 | 129900.0 |
| 2005-11-04 | ABMD-DELISTED | Stock | 9.25 | 9.33 | 8.75 | 9.09 | 134106.0 |
| 2005-11-04 | ABP-DELISTED | Stock | 7.43 | 7.43 | 6.75 | 7.1 | 1292100.0 |
| 2005-11-04 | ABR | Stock | 27.49 | 27.7 | 27.0 | 27.4 | 59300.0 |
| 2005-11-04 | ABT | Stock | 20.6074 | 20.6218 | 20.2572 | 20.4251 | 7898499.0 |
| 2005-11-04 | ABTL-DELISTED | Stock | 22.4 | 22.5 | 22.05 | 22.4 | 22926.0 |
| 2005-11-04 | ABV-DELISTED | Stock | 36.5 | 36.5 | 35.85 | 35.9701 | 498000.0 |
| 2005-11-04 | ABVA-DELISTED | Stock | 16.6 | 16.69 | 16.55 | 16.69 | 8700.0 |
| 2005-11-04 | ABX-DELISTED | Stock | 25.2 | 25.32 | 24.58 | 24.94 | 3559900.0 |
| 2005-11-04 | ACAD | Stock | 10.3 | 10.3 | 9.98 | 10.1 | 23200.0 |
| 2005-11-04 | ACAP-DELISTED | Stock | 45.5 | 45.74 | 44.25 | 45.08 | 67933.0 |
| 2005-11-04 | ACAS-DELISTED | Stock | 37.96 | 38.31 | 37.6 | 38.2 | 498339.0 |
| 2005-11-04 | ACAT-DELISTED | Stock | 19.5 | 19.75 | 19.37 | 19.41 | 55674.0 |
| 2005-11-04 | ACC-DELISTED | Stock | 24.98 | 25.03 | 24.65 | 24.97 | 110076.0 |
| 2005-11-04 | ACCL-DELISTED | Stock | 6.92 | 6.99 | 6.65 | 6.797 | 83276.0 |
| 2005-11-04 | ACCO | Stock | 24.1 | 24.12 | 23.64 | 23.82 | 100700.0 |
| 2005-11-04 | ACE-DELISTED | Stock | 53.0 | 53.67 | 52.24 | 53.47 | 1515500.0 |
| 2005-11-04 | ACF-DELISTED | Stock | 22.62 | 22.91 | 22.53 | 22.81 | 893900.0 |
| 2005-11-04 | ACFC-DELISTED | Stock | 72.55 | 73.72 | 72.55 | 73.42 | 4187.0 |
| 2005-11-04 | ACG-DELISTED | Stock | 8.19 | 8.22 | 8.16 | 8.19 | 322700.0 |
| 2005-11-04 | ACGL | Stock | 5.7456 | 5.7778 | 5.6856 | 5.7689 | 707400.0 |
| 2005-11-04 | ACGN-DELISTED | Stock | 884.0 | 906.6712 | 850.0 | 850.0 | 144700.0 |
> showing 50 of 4,211 rows — these rows as CSV