PREVIEW / stock_daily / 2005-05-23
file: by_date/stock_daily/2005/2005-05-23.parquet size: 135 KB rows: 4,070 symbols: 2,544
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-05-23 | AAPL | Stock | 1.3518 | 1.425 | 1.3518 | 1.42 | 1042574400.0 |
| 2005-05-23 | MSFT | Stock | 25.74 | 26.07 | 25.74 | 25.85 | 75421100.0 |
| 2005-05-23 | NVDA | Stock | 0.2207 | 0.2265 | 0.22 | 0.2242 | 703668000.0 |
| 2005-05-23 | AMZN | Stock | 1.7785 | 1.801 | 1.7695 | 1.784 | 114028000.0 |
| 2005-05-23 | CL | Stock | 25.56 | 25.575 | 25.28 | 25.36 | 4506400.0 |
| 2005-05-23 | A | Stock | 16.681 | 16.9456 | 16.6667 | 16.9027 | 3203517.0 |
| 2005-05-23 | AABA-DELISTED | Stock | 36.0999984741211 | 37.0999984741211 | 36.0400009155273 | 36.7999992370605 | 21616200.0 |
| 2005-05-23 | AACC-DELISTED | Stock | 22.4 | 22.65 | 22.36 | 22.44 | 90511.0 |
| 2005-05-23 | AAI-DELISTED | Stock | 9.69 | 9.98 | 9.61 | 9.88 | 1994200.0 |
| 2005-05-23 | AAIC-DELISTED | Stock | 270.4 | 276.8 | 269.8 | 273.0 | 1326000.0 |
| 2005-05-23 | AAME | Stock | 3.0 | 3.07 | 3.0 | 3.07 | 13500.0 |
| 2005-05-23 | AAON | Stock | 2.3664 | 2.4797 | 2.3664 | 2.4678 | 116944.0 |
| 2005-05-23 | AAP | Stock | 39.4667 | 39.9 | 39.4333 | 39.6467 | 1224150.0 |
| 2005-05-23 | AAV-DELISTED | Stock | 13.46 | 13.46 | 13.46 | 13.46 | 600.0 |
| 2005-05-23 | AAXN-DELISTED | Stock | 11.1199998855591 | 11.3900003433228 | 10.8000001907349 | 10.8400001525879 | 4148400.0 |
| 2005-05-23 | ABAX-DELISTED | Stock | 11.05 | 11.11 | 10.96 | 11.01 | 109329.0 |
| 2005-05-23 | ABB-DELISTED | Stock | 6.4 | 6.43 | 6.39 | 6.41 | 1131400.0 |
| 2005-05-23 | ABBC-DELISTED | Stock | 11.7 | 12.14 | 11.18 | 11.49 | 22937.0 |
| 2005-05-23 | ABC-DELISTED | Stock | 16.42 | 16.54 | 16.42 | 16.5 | 4127600.0 |
| 2005-05-23 | ABCB | Stock | 17.5562 | 17.7604 | 17.2839 | 17.4492 | 6169.0 |
| 2005-05-23 | ABCO-DELISTED | Stock | 22.68 | 22.93 | 22.45 | 22.58 | 169784.0 |
| 2005-05-23 | ABCW-DELISTED | Stock | 27.3 | 27.95 | 26.63 | 27.63 | 43770.0 |
| 2005-05-23 | ABE-DELISTED | Stock | 9.65 | 9.65 | 9.58 | 9.6 | 8100.0 |
| 2005-05-23 | ABFS-DELISTED | Stock | 32.47 | 33.46 | 32.44 | 32.86 | 188618.0 |
| 2005-05-23 | ABG | Stock | 14.35 | 14.65 | 14.23 | 14.33 | 93600.0 |
| 2005-05-23 | ABK-DELISTED | Stock | 71.75 | 72.41 | 71.42 | 72.0 | 491000.0 |
| 2005-05-23 | ABM | Stock | 19.21 | 19.5 | 19.21 | 19.42 | 50100.0 |
| 2005-05-23 | ABMD-DELISTED | Stock | 10.28 | 10.29 | 9.99 | 9.99 | 101709.0 |
| 2005-05-23 | ABP-DELISTED | Stock | 2.45 | 2.48 | 2.41 | 2.46 | 67900.0 |
| 2005-05-23 | ABR | Stock | 26.5 | 26.75 | 26.38 | 26.59 | 181600.0 |
| 2005-05-23 | ABT | Stock | 23.6062 | 23.6062 | 23.2703 | 23.3663 | 6307628.0 |
| 2005-05-23 | ABTL-DELISTED | Stock | 20.25 | 20.8 | 20.15 | 20.45 | 81200.0 |
| 2005-05-23 | ABV-DELISTED | Stock | 29.65 | 29.8 | 29.6 | 29.77 | 148100.0 |
| 2005-05-23 | ABVA-DELISTED | Stock | 14.6 | 14.61 | 14.5 | 14.5 | 525.0 |
| 2005-05-23 | ABX-DELISTED | Stock | 21.55 | 22.02 | 21.55 | 21.93 | 940100.0 |
| 2005-05-23 | ACAD | Stock | 7.91 | 8.1 | 7.88 | 7.91 | 36500.0 |
| 2005-05-23 | ACAP-DELISTED | Stock | 35.0 | 35.05 | 34.51 | 34.54 | 65584.0 |
| 2005-05-23 | ACAS-DELISTED | Stock | 34.74 | 34.79 | 34.0 | 34.63 | 895106.0 |
| 2005-05-23 | ACAT-DELISTED | Stock | 22.0 | 23.58 | 21.97 | 22.63 | 218957.0 |
| 2005-05-23 | ACC-DELISTED | Stock | 20.75 | 21.49 | 20.75 | 21.24 | 19200.0 |
| 2005-05-23 | ACCL-DELISTED | Stock | 5.13 | 5.45 | 5.13 | 5.24 | 136497.0 |
| 2005-05-23 | ACE-DELISTED | Stock | 43.48 | 43.59 | 43.23 | 43.31 | 686700.0 |
| 2005-05-23 | ACF-DELISTED | Stock | 24.32 | 24.54 | 24.11 | 24.4 | 1375700.0 |
| 2005-05-23 | ACFC-DELISTED | Stock | 62.19 | 62.65 | 62.19 | 62.55 | 725.0 |
| 2005-05-23 | ACG-DELISTED | Stock | 8.19 | 8.22 | 8.18 | 8.22 | 650900.0 |
| 2005-05-23 | ACGL | Stock | 4.8178 | 4.8711 | 4.8178 | 4.8533 | 2749500.0 |
| 2005-05-23 | ACGN-DELISTED | Stock | 736.6712 | 782.0 | 736.6712 | 782.0 | 415100.0 |
| 2005-05-23 | ACH | Stock | 20.4667 | 20.7533 | 20.3333 | 20.5133 | 166350.0 |
| 2005-05-23 | ACH-DELISTED | Stock | 12.662 | 12.832 | 12.662 | 12.757 | 114800.0 |
| 2005-05-23 | ACLS | Stock | 23.4 | 24.88 | 22.6 | 24.36 | 319225.0 |
> showing 50 of 4,070 rows — these rows as CSV