PREVIEW / stock_daily / 2005-04-14
file: by_date/stock_daily/2005/2005-04-14.parquet size: 135 KB rows: 4,040 symbols: 2,540
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-14 | AAPL | Stock | 1.3861 | 1.4129 | 1.3157 | 1.3307 | 2753192400.0 |
| 2005-04-14 | MSFT | Stock | 25.01 | 25.14 | 24.83 | 24.84 | 66754400.0 |
| 2005-04-14 | NVDA | Stock | 0.1862 | 0.188 | 0.1837 | 0.1843 | 352080000.0 |
| 2005-04-14 | AMZN | Stock | 1.713 | 1.725 | 1.694 | 1.6985 | 83568000.0 |
| 2005-04-14 | CL | Stock | 26.965 | 27.04 | 26.63 | 26.65 | 4442000.0 |
| 2005-04-14 | A | Stock | 14.8856 | 15.0286 | 14.7496 | 14.7854 | 2925595.0 |
| 2005-04-14 | AABA-DELISTED | Stock | 33.6300010681152 | 34.2000007629395 | 33.4000015258789 | 33.4599990844727 | 19855300.0 |
| 2005-04-14 | AACC-DELISTED | Stock | 19.16 | 19.34 | 18.81 | 18.9 | 142188.0 |
| 2005-04-14 | AACQ-DELISTED | Stock | 5.15 | 5.15 | 5.15 | 5.15 | 10000.0 |
| 2005-04-14 | AACQW-DELISTED | Stock | 0.6 | 0.6 | 0.6 | 0.6 | 2500.0 |
| 2005-04-14 | AAI-DELISTED | Stock | 9.24 | 9.28 | 8.774 | 8.81 | 1026300.0 |
| 2005-04-14 | AAIC-DELISTED | Stock | 282.8 | 288.8 | 281.6 | 282.8 | 1500500.0 |
| 2005-04-14 | AAME | Stock | 3.01 | 3.1 | 3.01 | 3.1 | 5000.0 |
| 2005-04-14 | AAON | Stock | 2.2677 | 2.2677 | 2.2281 | 2.2281 | 54675.0 |
| 2005-04-14 | AAP | Stock | 33.82 | 34.0 | 33.1067 | 33.1733 | 715650.0 |
| 2005-04-14 | AAV-DELISTED | Stock | 14.65 | 14.74 | 14.3 | 14.65 | 72900.0 |
| 2005-04-14 | AAXN-DELISTED | Stock | 8.4399995803833 | 8.60000038146973 | 8.1899995803833 | 8.22999954223633 | 3852700.0 |
| 2005-04-14 | ABAX-DELISTED | Stock | 8.51 | 8.57 | 8.04 | 8.1 | 76905.0 |
| 2005-04-14 | ABB-DELISTED | Stock | 6.4 | 6.4 | 6.32 | 6.32 | 1374700.0 |
| 2005-04-14 | ABBC-DELISTED | Stock | 11.95 | 12.0 | 11.81 | 11.95 | 33781.0 |
| 2005-04-14 | ABC-DELISTED | Stock | 14.74 | 15.01 | 14.7 | 14.9 | 6548000.0 |
| 2005-04-14 | ABCB | Stock | 17.9258 | 18.2662 | 17.5075 | 17.5172 | 30638.0 |
| 2005-04-14 | ABCO-DELISTED | Stock | 21.23 | 21.35 | 21.13 | 21.22 | 186816.0 |
| 2005-04-14 | ABCW-DELISTED | Stock | 27.36 | 27.5 | 27.2 | 27.2 | 76150.0 |
| 2005-04-14 | ABE-DELISTED | Stock | 9.41 | 9.45 | 9.35 | 9.39 | 15800.0 |
| 2005-04-14 | ABFS-DELISTED | Stock | 34.14 | 34.4 | 32.91 | 33.44 | 588135.0 |
| 2005-04-14 | ABG | Stock | 14.2 | 14.43 | 14.1 | 14.15 | 35400.0 |
| 2005-04-14 | ABK-DELISTED | Stock | 76.77 | 76.99 | 75.68 | 75.8 | 708000.0 |
| 2005-04-14 | ABM | Stock | 18.81 | 19.06 | 18.48 | 18.52 | 144700.0 |
| 2005-04-14 | ABMD-DELISTED | Stock | 11.04 | 11.2 | 10.93 | 11.08 | 49838.0 |
| 2005-04-14 | ABP-DELISTED | Stock | 2.67 | 2.71 | 2.55 | 2.66 | 215200.0 |
| 2005-04-14 | ABR | Stock | 25.35 | 25.5 | 25.2 | 25.22 | 74900.0 |
| 2005-04-14 | ABT | Stock | 22.9872 | 23.2703 | 22.9584 | 23.1695 | 9097541.0 |
| 2005-04-14 | ABTL-DELISTED | Stock | 24.55 | 25.05 | 24.25 | 24.75 | 35100.0 |
| 2005-04-14 | ABV-DELISTED | Stock | 27.9 | 28.01 | 27.49 | 27.54 | 356900.0 |
| 2005-04-14 | ABVA-DELISTED | Stock | 15.2 | 15.2 | 15.17 | 15.17 | 1600.0 |
| 2005-04-14 | ABX-DELISTED | Stock | 23.13 | 23.22 | 22.51 | 22.62 | 3910700.0 |
| 2005-04-14 | ACAD | Stock | 6.25 | 7.22 | 6.25 | 6.9 | 18400.0 |
| 2005-04-14 | ACAP-DELISTED | Stock | 34.78 | 34.96 | 34.5 | 34.64 | 65903.0 |
| 2005-04-14 | ACAS-DELISTED | Stock | 31.65 | 31.84 | 31.1 | 31.32 | 602646.0 |
| 2005-04-14 | ACAT-DELISTED | Stock | 25.5 | 26.07 | 24.51 | 24.8 | 127082.0 |
| 2005-04-14 | ACC-DELISTED | Stock | 20.5 | 20.55 | 20.05 | 20.06 | 13500.0 |
| 2005-04-14 | ACCL-DELISTED | Stock | 5.89 | 5.9 | 5.71 | 5.75 | 123893.0 |
| 2005-04-14 | ACE-DELISTED | Stock | 40.06 | 40.13 | 39.22 | 39.32 | 2086300.0 |
| 2005-04-14 | ACF-DELISTED | Stock | 23.72 | 23.94 | 23.3 | 23.42 | 939300.0 |
| 2005-04-14 | ACFC-DELISTED | Stock | 56.79 | 57.4 | 56.48 | 56.63 | 1836.0 |
| 2005-04-14 | ACG-DELISTED | Stock | 8.08 | 8.09 | 8.02 | 8.03 | 359900.0 |
| 2005-04-14 | ACGL | Stock | 4.5833 | 4.5833 | 4.4933 | 4.5056 | 709200.0 |
| 2005-04-14 | ACGN-DELISTED | Stock | 736.6712 | 759.3288 | 714.0 | 736.6712 | 101400.0 |
| 2005-04-14 | ACH | Stock | 18.4 | 18.7133 | 18.4 | 18.5667 | 361500.0 |
> showing 50 of 4,040 rows — these rows as CSV