PREVIEW / stock_daily / 2005-04-19
file: by_date/stock_daily/2005/2005-04-19.parquet size: 135 KB rows: 4,046 symbols: 2,538
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-04-19 | AAPL | Stock | 1.3071 | 1.3371 | 1.2811 | 1.3246 | 1081642800.0 |
| 2005-04-19 | MSFT | Stock | 24.71 | 24.8 | 24.45 | 24.63 | 65956200.0 |
| 2005-04-19 | NVDA | Stock | 0.1796 | 0.1842 | 0.1787 | 0.1828 | 365460000.0 |
| 2005-04-19 | AMZN | Stock | 1.659 | 1.6685 | 1.6005 | 1.639 | 132388000.0 |
| 2005-04-19 | CL | Stock | 26.165 | 26.235 | 25.94 | 26.06 | 3824200.0 |
| 2005-04-19 | A | Stock | 14.7926 | 14.9642 | 14.7783 | 14.8569 | 3607819.0 |
| 2005-04-19 | AABA-DELISTED | Stock | 32.9599990844727 | 33.3300018310547 | 32.4199981689453 | 33.2200012207031 | 34158500.0 |
| 2005-04-19 | AACC-DELISTED | Stock | 20.2 | 20.5 | 19.75 | 20.25 | 354539.0 |
| 2005-04-19 | AACQW-DELISTED | Stock | 0.57 | 0.57 | 0.57 | 0.57 | 5000.0 |
| 2005-04-19 | AAI-DELISTED | Stock | 8.89 | 8.92 | 8.75 | 8.89 | 678700.0 |
| 2005-04-19 | AAIC-DELISTED | Stock | 279.2 | 285.0 | 279.0 | 279.4 | 1460900.0 |
| 2005-04-19 | AAME | Stock | 3.03 | 3.04 | 3.03 | 3.03 | 6900.0 |
| 2005-04-19 | AAON | Stock | 2.2756 | 2.3045 | 2.2387 | 2.2663 | 217941.0 |
| 2005-04-19 | AAP | Stock | 33.3333 | 34.0733 | 33.1667 | 34.0133 | 1817850.0 |
| 2005-04-19 | AAV-DELISTED | Stock | 15.31 | 15.37 | 15.27 | 15.31 | 49100.0 |
| 2005-04-19 | AAXN-DELISTED | Stock | 7.46999979019165 | 8.30000019073486 | 7.32999992370605 | 7.90000009536743 | 8152400.0 |
| 2005-04-19 | ABAX-DELISTED | Stock | 7.57 | 7.97 | 7.57 | 7.84 | 107211.0 |
| 2005-04-19 | ABB-DELISTED | Stock | 6.22 | 6.32 | 6.22 | 6.3 | 1336600.0 |
| 2005-04-19 | ABBC-DELISTED | Stock | 12.18 | 12.27 | 11.78 | 11.79 | 13340.0 |
| 2005-04-19 | ABC-DELISTED | Stock | 14.79 | 15.0 | 14.78 | 14.95 | 8374400.0 |
| 2005-04-19 | ABCB | Stock | 17.9355 | 17.9744 | 17.6437 | 17.8675 | 18198.0 |
| 2005-04-19 | ABCO-DELISTED | Stock | 21.04 | 21.29 | 20.82 | 20.9 | 738685.0 |
| 2005-04-19 | ABCW-DELISTED | Stock | 27.35 | 27.37 | 27.05 | 27.24 | 78250.0 |
| 2005-04-19 | ABE-DELISTED | Stock | 9.25 | 9.3 | 9.22 | 9.3 | 16900.0 |
| 2005-04-19 | ABFS-DELISTED | Stock | 32.8 | 34.24 | 32.8 | 34.19 | 437346.0 |
| 2005-04-19 | ABG | Stock | 13.74 | 14.22 | 13.71 | 14.05 | 46900.0 |
| 2005-04-19 | ABK-DELISTED | Stock | 74.55 | 74.91 | 74.1 | 74.57 | 443200.0 |
| 2005-04-19 | ABM | Stock | 18.55 | 18.75 | 18.42 | 18.63 | 129500.0 |
| 2005-04-19 | ABMD-DELISTED | Stock | 11.07 | 11.14 | 10.96 | 11.1 | 38275.0 |
| 2005-04-19 | ABP-DELISTED | Stock | 2.57 | 2.74 | 2.57 | 2.61 | 135300.0 |
| 2005-04-19 | ABR | Stock | 26.0 | 26.15 | 25.94 | 26.02 | 61600.0 |
| 2005-04-19 | ABT | Stock | 23.3423 | 23.3855 | 22.9344 | 23.112 | 8509170.0 |
| 2005-04-19 | ABTL-DELISTED | Stock | 23.8 | 23.95 | 22.6 | 23.1 | 41300.0 |
| 2005-04-19 | ABV-DELISTED | Stock | 27.01 | 27.3 | 26.97 | 27.28 | 649700.0 |
| 2005-04-19 | ABVA-DELISTED | Stock | 14.9 | 15.0 | 14.9 | 15.0 | 441.0 |
| 2005-04-19 | ABX-DELISTED | Stock | 22.68 | 23.03 | 22.57 | 22.99 | 2681450.0 |
| 2005-04-19 | ACAD | Stock | 6.46 | 6.95 | 6.39 | 6.86 | 24600.0 |
| 2005-04-19 | ACAP-DELISTED | Stock | 33.39 | 34.23 | 33.13 | 33.68 | 55452.0 |
| 2005-04-19 | ACAS-DELISTED | Stock | 31.75 | 31.96 | 31.6 | 31.9 | 572420.0 |
| 2005-04-19 | ACAT-DELISTED | Stock | 24.02 | 25.13 | 23.93 | 25.05 | 92598.0 |
| 2005-04-19 | ACC-DELISTED | Stock | 19.77 | 20.27 | 19.77 | 20.23 | 7296.0 |
| 2005-04-19 | ACCL-DELISTED | Stock | 5.62 | 5.75 | 5.51 | 5.67 | 146024.0 |
| 2005-04-19 | ACE-DELISTED | Stock | 39.32 | 39.72 | 39.12 | 39.48 | 867418.0 |
| 2005-04-19 | ACF-DELISTED | Stock | 23.0 | 23.43 | 22.9 | 23.18 | 2047800.0 |
| 2005-04-19 | ACFC-DELISTED | Stock | 57.24 | 58.32 | 57.24 | 58.32 | 923.0 |
| 2005-04-19 | ACG-DELISTED | Stock | 8.11 | 8.17 | 8.11 | 8.15 | 418700.0 |
| 2005-04-19 | ACGL | Stock | 4.45 | 4.4778 | 4.4411 | 4.4411 | 443700.0 |
| 2005-04-19 | ACGN-DELISTED | Stock | 702.6712 | 714.0 | 680.0 | 691.3288 | 116700.0 |
| 2005-04-19 | ACH | Stock | 17.84 | 18.04 | 17.7 | 17.9667 | 309600.0 |
| 2005-04-19 | ACH-DELISTED | Stock | 13.993 | 14.176 | 13.971 | 14.173 | 104753.0 |
> showing 50 of 4,046 rows — these rows as CSV