PREVIEW / stock_daily / 2005-11-01
file: by_date/stock_daily/2005/2005-11-01.parquet size: 141 KB rows: 4,220 symbols: 2,659
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-01 | AAPL | Stock | 2.0443 | 2.0764 | 2.0311 | 2.0536 | 749686000.0 |
| 2005-11-01 | MSFT | Stock | 25.61 | 26.1 | 25.61 | 25.96 | 71370400.0 |
| 2005-11-01 | NVDA | Stock | 0.2796 | 0.2817 | 0.274 | 0.2762 | 400488000.0 |
| 2005-11-01 | AMZN | Stock | 1.9985 | 2.037 | 1.9825 | 2.0185 | 107660000.0 |
| 2005-11-01 | CL | Stock | 26.625 | 26.795 | 26.055 | 26.18 | 5574200.0 |
| 2005-11-01 | A | Stock | 22.897 | 23.2403 | 22.8183 | 22.9828 | 2686537.0 |
| 2005-11-01 | AABA-DELISTED | Stock | 36.6199989318848 | 38.7099990844727 | 36.5900001525879 | 37.7200012207031 | 41932100.0 |
| 2005-11-01 | AACC-DELISTED | Stock | 22.8 | 22.9 | 18.96 | 19.06 | 1939335.0 |
| 2005-11-01 | AACQ-DELISTED | Stock | 5.17 | 5.17 | 5.17 | 5.17 | 500.0 |
| 2005-11-01 | AACQU-DELISTED | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 1000.0 |
| 2005-11-01 | AACQW-DELISTED | Stock | 0.45 | 0.45 | 0.43 | 0.43 | 50000.0 |
| 2005-11-01 | AAI-DELISTED | Stock | 14.75 | 14.99 | 14.54 | 14.62 | 1756300.0 |
| 2005-11-01 | AAIC-DELISTED | Stock | 181.0 | 183.2 | 174.4 | 175.0 | 1195700.0 |
| 2005-11-01 | AAME | Stock | 2.9 | 2.9 | 2.6 | 2.7 | 4200.0 |
| 2005-11-01 | AAON | Stock | 2.2387 | 2.2558 | 2.2347 | 2.2519 | 72141.0 |
| 2005-11-01 | AAP | Stock | 37.5 | 37.65 | 37.1 | 37.5 | 1401800.0 |
| 2005-11-01 | AATI-DELISTED | Stock | 10.82 | 10.99 | 10.23 | 10.26 | 139115.0 |
| 2005-11-01 | AAV-DELISTED | Stock | 16.3 | 16.61 | 16.3 | 16.3 | 42900.0 |
| 2005-11-01 | AAXN-DELISTED | Stock | 6.13000011444092 | 6.34999990463257 | 6.13000011444092 | 6.30000019073486 | 1801600.0 |
| 2005-11-01 | ABAX-DELISTED | Stock | 17.2 | 17.3 | 17.11 | 17.2 | 189056.0 |
| 2005-11-01 | ABB-DELISTED | Stock | 7.71 | 7.71 | 7.64 | 7.67 | 909000.0 |
| 2005-11-01 | ABBC-DELISTED | Stock | 12.05 | 12.05 | 12.0295 | 12.03 | 600.0 |
| 2005-11-01 | ABC-DELISTED | Stock | 18.94 | 19.0 | 18.8 | 18.95 | 2914400.0 |
| 2005-11-01 | ABCB | Stock | 18.5969 | 18.6747 | 18.4024 | 18.4802 | 8739.0 |
| 2005-11-01 | ABCO-DELISTED | Stock | 24.24 | 24.59 | 24.0 | 24.34 | 243107.0 |
| 2005-11-01 | ABCW-DELISTED | Stock | 31.36 | 31.75 | 31.26 | 31.44 | 44450.0 |
| 2005-11-01 | ABD-DELISTED | Stock | 24.25 | 24.58 | 23.8 | 23.9 | 255500.0 |
| 2005-11-01 | ABE-DELISTED | Stock | 10.94 | 10.99 | 10.93 | 10.98 | 14700.0 |
| 2005-11-01 | ABFS-DELISTED | Stock | 38.5 | 39.17 | 38.5 | 38.8 | 217657.0 |
| 2005-11-01 | ABG | Stock | 16.8 | 17.16 | 15.63 | 16.9 | 106300.0 |
| 2005-11-01 | ABK-DELISTED | Stock | 70.55 | 72.02 | 70.43 | 71.84 | 580200.0 |
| 2005-11-01 | ABM | Stock | 19.71 | 19.74 | 19.34 | 19.5 | 98100.0 |
| 2005-11-01 | ABMD-DELISTED | Stock | 8.47 | 8.6 | 8.37 | 8.5 | 153453.0 |
| 2005-11-01 | ABP-DELISTED | Stock | 5.8 | 6.18 | 5.76 | 6.14 | 552000.0 |
| 2005-11-01 | ABR | Stock | 26.38 | 26.86 | 26.02 | 26.55 | 86200.0 |
| 2005-11-01 | ABT | Stock | 20.6074 | 20.7705 | 20.4923 | 20.5258 | 6517924.0 |
| 2005-11-01 | ABTL-DELISTED | Stock | 21.83 | 22.17 | 21.58 | 22.17 | 16484.0 |
| 2005-11-01 | ABV-DELISTED | Stock | 35.52 | 36.37 | 35.52 | 36.05 | 388700.0 |
| 2005-11-01 | ABVA-DELISTED | Stock | 16.65 | 16.75 | 16.55 | 16.56 | 600.0 |
| 2005-11-01 | ABX-DELISTED | Stock | 25.12 | 25.28 | 24.77 | 25.02 | 6415855.0 |
| 2005-11-01 | ACAD | Stock | 10.38 | 10.41 | 10.24 | 10.29 | 26900.0 |
| 2005-11-01 | ACAP-DELISTED | Stock | 42.11 | 44.83 | 42.01 | 44.36 | 69572.0 |
| 2005-11-01 | ACAS-DELISTED | Stock | 37.58 | 37.63 | 36.8 | 37.43 | 448944.0 |
| 2005-11-01 | ACAT-DELISTED | Stock | 18.63 | 19.16 | 18.63 | 19.01 | 76330.0 |
| 2005-11-01 | ACC-DELISTED | Stock | 24.55 | 24.56 | 23.81 | 24.26 | 66800.0 |
| 2005-11-01 | ACCL-DELISTED | Stock | 6.62 | 6.67 | 6.5605 | 6.58 | 24869.0 |
| 2005-11-01 | ACCO | Stock | 24.25 | 24.58 | 23.8 | 23.9 | 255500.0 |
| 2005-11-01 | ACE-DELISTED | Stock | 51.72 | 52.18 | 51.45 | 51.85 | 2605159.0 |
| 2005-11-01 | ACF-DELISTED | Stock | 22.35 | 22.45 | 22.12 | 22.37 | 1302000.0 |
| 2005-11-01 | ACFC-DELISTED | Stock | 70.92 | 71.84 | 70.92 | 71.84 | 2314.0 |
> showing 50 of 4,220 rows — these rows as CSV