PREVIEW / stock_daily / 2005-05-19
file: by_date/stock_daily/2005/2005-05-19.parquet size: 135 KB rows: 4,066 symbols: 2,541
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-19 | AAPL | Stock | 1.2779 | 1.3457 | 1.2779 | 1.3411 | 793161600.0 |
| 2005-05-19 | MSFT | Stock | 25.75 | 26.05 | 25.7 | 25.92 | 52120800.0 |
| 2005-05-19 | NVDA | Stock | 0.2162 | 0.2172 | 0.2129 | 0.2153 | 452880000.0 |
| 2005-05-19 | AMZN | Stock | 1.7685 | 1.7955 | 1.7665 | 1.7795 | 106870000.0 |
| 2005-05-19 | CL | Stock | 25.195 | 25.375 | 25.195 | 25.345 | 2693800.0 |
| 2005-05-19 | A | Stock | 16.3948 | 16.5379 | 16.3448 | 16.5021 | 2144672.0 |
| 2005-05-19 | AABA-DELISTED | Stock | 36.1300010681152 | 36.9900016784668 | 36.1100006103516 | 36.75 | 21267100.0 |
| 2005-05-19 | AACC-DELISTED | Stock | 23.98 | 23.98 | 23.486 | 23.61 | 88123.0 |
| 2005-05-19 | AAI-DELISTED | Stock | 9.5 | 9.5 | 9.21 | 9.36 | 1262000.0 |
| 2005-05-19 | AAIC-DELISTED | Stock | 264.0 | 272.8 | 264.0 | 270.4 | 1538100.0 |
| 2005-05-19 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 1800.0 |
| 2005-05-19 | AAON | Stock | 2.3704 | 2.3849 | 2.348 | 2.3849 | 1038825.0 |
| 2005-05-19 | AAP | Stock | 39.2667 | 39.6867 | 38.6667 | 38.98 | 3828000.0 |
| 2005-05-19 | AAV-DELISTED | Stock | 13.5 | 14.3 | 13.33 | 13.5 | 49100.0 |
| 2005-05-19 | AAXN-DELISTED | Stock | 10.539999961853 | 11.75 | 10.539999961853 | 11.1999998092651 | 8816900.0 |
| 2005-05-19 | ABAX-DELISTED | Stock | 10.49 | 11.31 | 10.49 | 11.14 | 351784.0 |
| 2005-05-19 | ABB-DELISTED | Stock | 6.43 | 6.45 | 6.37 | 6.45 | 1086700.0 |
| 2005-05-19 | ABBC-DELISTED | Stock | 11.51 | 11.7 | 11.51 | 11.68 | 5464.0 |
| 2005-05-19 | ABC-DELISTED | Stock | 16.6 | 16.65 | 16.47 | 16.51 | 2862000.0 |
| 2005-05-19 | ABCB | Stock | 17.7507 | 17.9744 | 17.5367 | 17.5367 | 6273.0 |
| 2005-05-19 | ABCO-DELISTED | Stock | 23.16 | 23.24 | 22.67 | 22.71 | 179264.0 |
| 2005-05-19 | ABCW-DELISTED | Stock | 27.49 | 27.59 | 27.33 | 27.59 | 72730.0 |
| 2005-05-19 | ABE-DELISTED | Stock | 9.58 | 9.7 | 9.58 | 9.58 | 12600.0 |
| 2005-05-19 | ABFS-DELISTED | Stock | 32.99 | 33.2 | 32.174 | 32.38 | 293071.0 |
| 2005-05-19 | ABG | Stock | 14.37 | 14.4 | 14.29 | 14.36 | 37800.0 |
| 2005-05-19 | ABK-DELISTED | Stock | 72.32 | 72.54 | 71.77 | 72.2 | 793800.0 |
| 2005-05-19 | ABM | Stock | 19.05 | 19.47 | 19.05 | 19.45 | 101400.0 |
| 2005-05-19 | ABMD-DELISTED | Stock | 10.0 | 10.38 | 10.0 | 10.23 | 90157.0 |
| 2005-05-19 | ABP-DELISTED | Stock | 2.33 | 2.42 | 2.3 | 2.4 | 165300.0 |
| 2005-05-19 | ABR | Stock | 26.4 | 26.48 | 26.31 | 26.33 | 118300.0 |
| 2005-05-19 | ABT | Stock | 23.7021 | 23.7165 | 23.3471 | 23.5294 | 6859108.0 |
| 2005-05-19 | ABTL-DELISTED | Stock | 20.15 | 20.85 | 20.15 | 20.55 | 44400.0 |
| 2005-05-19 | ABV-DELISTED | Stock | 29.37 | 29.68 | 29.12 | 29.66 | 394100.0 |
| 2005-05-19 | ABVA-DELISTED | Stock | 14.75 | 14.894 | 14.75 | 14.894 | 2450.0 |
| 2005-05-19 | ABX-DELISTED | Stock | 21.92 | 22.09 | 21.67 | 22.02 | 1050300.0 |
| 2005-05-19 | ACAD | Stock | 7.38 | 7.88 | 7.38 | 7.74 | 11900.0 |
| 2005-05-19 | ACAP-DELISTED | Stock | 34.2 | 34.39 | 33.47 | 33.76 | 36936.0 |
| 2005-05-19 | ACAS-DELISTED | Stock | 34.02 | 34.5 | 34.01 | 34.48 | 867116.0 |
| 2005-05-19 | ACAT-DELISTED | Stock | 21.13 | 21.77 | 20.85 | 21.46 | 71956.0 |
| 2005-05-19 | ACC-DELISTED | Stock | 20.6 | 20.61 | 20.524 | 20.6 | 42318.0 |
| 2005-05-19 | ACCL-DELISTED | Stock | 5.24 | 5.3 | 5.15 | 5.2 | 165592.0 |
| 2005-05-19 | ACE-DELISTED | Stock | 43.45 | 43.66 | 43.22 | 43.53 | 722720.0 |
| 2005-05-19 | ACF-DELISTED | Stock | 23.94 | 24.35 | 23.85 | 24.25 | 1868200.0 |
| 2005-05-19 | ACFC-DELISTED | Stock | 62.27 | 62.98 | 61.96 | 62.68 | 837.0 |
| 2005-05-19 | ACG-DELISTED | Stock | 8.15 | 8.17 | 8.13 | 8.17 | 387200.0 |
| 2005-05-19 | ACGL | Stock | 4.76 | 4.8333 | 4.7533 | 4.8289 | 950400.0 |
| 2005-05-19 | ACGN-DELISTED | Stock | 691.3288 | 725.3288 | 680.0 | 725.3288 | 317100.0 |
| 2005-05-19 | ACH | Stock | 20.6 | 20.6 | 20.2667 | 20.46 | 249750.0 |
| 2005-05-19 | ACH-DELISTED | Stock | 12.801 | 12.861 | 12.548 | 12.743 | 220798.0 |
| 2005-05-19 | ACLS | Stock | 23.84 | 24.28 | 23.32 | 23.4 | 145200.0 |
> showing 50 of 4,066 rows — these rows as CSV