PREVIEW / stock_daily / 2006-04-24
file: by_date/stock_daily/2006/2006-04-24.parquet size: 148 KB rows: 4,414 symbols: 2,791
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-24 | AAPL | Stock | 2.3875 | 2.39 | 2.3393 | 2.3482 | 707028000.0 |
| 2006-04-24 | MSFT | Stock | 27.07 | 27.25 | 26.98 | 27.11 | 42318400.0 |
| 2006-04-24 | NVDA | Stock | 0.4708 | 0.4868 | 0.4625 | 0.4822 | 676848000.0 |
| 2006-04-24 | AMZN | Stock | 1.806 | 1.806 | 1.766 | 1.7895 | 61752000.0 |
| 2006-04-24 | CL | Stock | 28.545 | 28.965 | 28.515 | 28.67 | 3609600.0 |
| 2006-04-24 | A | Stock | 27.6609 | 27.6967 | 27.3391 | 27.4821 | 2539187.0 |
| 2006-04-24 | AABA-DELISTED | Stock | 33.0099983215332 | 33.4500007629395 | 32.9000015258789 | 33.0099983215332 | 15441600.0 |
| 2006-04-24 | AACC-DELISTED | Stock | 20.54 | 20.67 | 20.31 | 20.4 | 96009.0 |
| 2006-04-24 | AACQ-DELISTED | Stock | 5.37 | 5.37 | 5.37 | 5.37 | 3000.0 |
| 2006-04-24 | AACQU-DELISTED | Stock | 6.8 | 6.8 | 6.75 | 6.75 | 10600.0 |
| 2006-04-24 | AACQW-DELISTED | Stock | 0.75 | 0.75 | 0.71 | 0.71 | 32000.0 |
| 2006-04-24 | AAI-DELISTED | Stock | 14.72 | 15.59 | 14.6601 | 15.58 | 2297300.0 |
| 2006-04-24 | AAIC-DELISTED | Stock | 187.2 | 188.8 | 184.2 | 187.0 | 470900.0 |
| 2006-04-24 | AAME | Stock | 2.85 | 3.34 | 2.85 | 3.22 | 7200.0 |
| 2006-04-24 | AAON | Stock | 3.1802 | 3.2263 | 3.1236 | 3.2 | 116184.0 |
| 2006-04-24 | AAP | Stock | 38.85 | 38.85 | 37.81 | 38.25 | 1553500.0 |
| 2006-04-24 | AATI-DELISTED | Stock | 11.77 | 11.83 | 11.6 | 11.67 | 188035.0 |
| 2006-04-24 | AAU-DELISTED | Stock | 2.77 | 2.77 | 2.666 | 2.74 | 182100.0 |
| 2006-04-24 | AAUAF-DELISTED | Stock | 2.77 | 2.77 | 2.666 | 2.74 | 182100.0 |
| 2006-04-24 | AAV-DELISTED | Stock | 20.16 | 20.21 | 19.91 | 20.2 | 283800.0 |
| 2006-04-24 | AAWW-DELISTED | Stock | 46.0 | 46.0 | 45.0 | 46.0 | 34300.0 |
| 2006-04-24 | AAXN-DELISTED | Stock | 10.3000001907349 | 10.3400001525879 | 10.1499996185303 | 10.1999998092651 | 894100.0 |
| 2006-04-24 | AB | Stock | 69.1 | 70.5 | 68.6 | 70.5 | 185900.0 |
| 2006-04-24 | ABAX-DELISTED | Stock | 25.59 | 26.39 | 25.52 | 25.89 | 508565.0 |
| 2006-04-24 | ABB-DELISTED | Stock | 13.98 | 14.0 | 13.84 | 13.97 | 1578800.0 |
| 2006-04-24 | ABBC-DELISTED | Stock | 13.31 | 13.4484 | 13.31 | 13.42 | 2809.0 |
| 2006-04-24 | ABC-DELISTED | Stock | 23.41 | 23.76 | 23.28 | 23.73 | 2995200.0 |
| 2006-04-24 | ABCB | Stock | 22.1276 | 22.6042 | 21.972 | 22.5459 | 12749.0 |
| 2006-04-24 | ABCO-DELISTED | Stock | 27.36 | 27.63 | 27.24 | 27.46 | 231034.0 |
| 2006-04-24 | ABCW-DELISTED | Stock | 28.62 | 29.15 | 28.48 | 28.56 | 49330.0 |
| 2006-04-24 | ABD-DELISTED | Stock | 21.69 | 21.98 | 21.5 | 21.7 | 192450.0 |
| 2006-04-24 | ABE-DELISTED | Stock | 13.54 | 13.7 | 13.49 | 13.59 | 21700.0 |
| 2006-04-24 | ABFS-DELISTED | Stock | 39.43 | 41.5 | 39.32 | 40.51 | 988173.0 |
| 2006-04-24 | ABG | Stock | 18.8 | 18.9 | 18.52 | 18.8 | 84200.0 |
| 2006-04-24 | ABK-DELISTED | Stock | 78.48 | 78.54 | 77.82 | 78.31 | 695900.0 |
| 2006-04-24 | ABM | Stock | 17.41 | 17.41 | 17.03 | 17.12 | 160300.0 |
| 2006-04-24 | ABMD-DELISTED | Stock | 13.84 | 13.84 | 13.35 | 13.57 | 72745.0 |
| 2006-04-24 | ABP-DELISTED | Stock | 6.48 | 6.5 | 6.0 | 6.12 | 545000.0 |
| 2006-04-24 | ABR | Stock | 26.45 | 26.45 | 25.95 | 26.02 | 90800.0 |
| 2006-04-24 | ABT | Stock | 20.0652 | 20.0892 | 19.7054 | 19.739 | 9300333.0 |
| 2006-04-24 | ABTL-DELISTED | Stock | 22.42 | 22.88 | 22.17 | 22.53 | 65727.0 |
| 2006-04-24 | ABV-DELISTED | Stock | 48.1 | 48.1 | 47.3 | 47.9 | 242600.0 |
| 2006-04-24 | ABVA-DELISTED | Stock | 18.67 | 18.76 | 18.65 | 18.76 | 6092.0 |
| 2006-04-24 | ABX-DELISTED | Stock | 29.86 | 30.34 | 29.36 | 29.9 | 3679157.0 |
| 2006-04-24 | ACAD | Stock | 14.81 | 15.0 | 13.88 | 14.14 | 405300.0 |
| 2006-04-24 | ACAP-DELISTED | Stock | 49.44 | 50.13 | 49.14 | 49.19 | 35442.0 |
| 2006-04-24 | ACAS-DELISTED | Stock | 34.25 | 34.33 | 33.93 | 33.97 | 855264.0 |
| 2006-04-24 | ACAT-DELISTED | Stock | 21.05 | 21.25 | 20.92 | 21.14 | 33863.0 |
| 2006-04-24 | ACC-DELISTED | Stock | 24.92 | 24.99 | 24.27 | 24.27 | 107494.0 |
| 2006-04-24 | ACCL-DELISTED | Stock | 7.26 | 7.29 | 7.18 | 7.27 | 65629.0 |
> showing 50 of 4,414 rows — these rows as CSV