PREVIEW / stock_daily / 2024-10-21
file: by_date/stock_daily/2024/2024-10-21.parquet size: 245 KB rows: 7,111 symbols: 675
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-21 | AAPL | Stock | 234.45 | 236.85 | 234.45 | 236.48 | 34085740.0 |
| 2024-10-21 | MSFT | Stock | 416.12 | 418.96 | 413.7501 | 418.78 | 12604451.0 |
| 2024-10-21 | NVDA | Stock | 138.13 | 143.71 | 138.0 | 143.71 | 259255902.0 |
| 2024-10-21 | AMZN | Stock | 188.05 | 189.46 | 186.4 | 189.07 | 23720731.0 |
| 2024-10-21 | GOOGL | Stock | 162.95 | 164.5 | 162.62 | 164.07 | 20946455.0 |
| 2024-10-21 | META | Stock | 576.03 | 577.2399 | 569.11 | 575.16 | 8097718.0 |
| 2024-10-21 | TSLA | Stock | 218.9 | 220.48 | 215.726 | 218.85 | 47017290.0 |
| 2024-10-21 | TLT | Stock | 93.02 | 93.09 | 92.23 | 92.23 | 49504698.0 |
| 2024-10-21 | ES | Stock | 66.23 | 66.49 | 65.84 | 66.13 | 1154986.0 |
| 2024-10-21 | CL | Stock | 100.0 | 100.485 | 99.19 | 99.36 | 2417955.0 |
| 2024-10-21 | A | Stock | 138.35 | 138.81 | 136.22 | 136.76 | 960179.0 |
| 2024-10-21 | AA | Stock | 41.82 | 41.9499 | 41.18 | 41.52 | 3135400.0 |
| 2024-10-21 | AACG | Stock | 1.0 | 1.0 | 0.9501 | 0.9862 | 23263.0 |
| 2024-10-21 | AACT | Stock | 10.87 | 10.87 | 10.84 | 10.86 | 43055.0 |
| 2024-10-21 | AAL | Stock | 12.98 | 13.1 | 12.775 | 12.97 | 27871408.0 |
| 2024-10-21 | AAM | Stock | 10.02 | 10.0262 | 10.02 | 10.02 | 103833.0 |
| 2024-10-21 | AAME | Stock | 1.6847 | 1.7 | 1.62 | 1.6999 | 1368.0 |
| 2024-10-21 | AAMI | Stock | 27.1 | 27.11 | 26.13 | 26.18 | 113085.0 |
| 2024-10-21 | AAOI | Stock | 18.57 | 18.75 | 17.8 | 18.51 | 1877022.0 |
| 2024-10-21 | AAON | Stock | 109.6 | 110.08 | 108.75 | 109.81 | 279075.0 |
| 2024-10-21 | AAP | Stock | 39.83 | 41.155 | 39.7 | 40.98 | 2566021.0 |
| 2024-10-21 | AAT | Stock | 28.14 | 28.14 | 27.44 | 27.52 | 110177.0 |
| 2024-10-21 | AATC | Stock | 7.3 | 7.49 | 7.3 | 7.49 | 2903.0 |
| 2024-10-21 | AAUAF-DELISTED | Stock | 0.0462 | 0.0575 | 0.046 | 0.049 | 65305.0 |
| 2024-10-21 | AAXJ | Stock | 77.81 | 78.09 | 77.465 | 77.93 | 345501.0 |
| 2024-10-21 | AB | Stock | 38.59 | 38.7 | 37.76 | 37.83 | 394049.0 |
| 2024-10-21 | ABAT | Stock | 1.0 | 1.03 | 0.99 | 1.01 | 387338.0 |
| 2024-10-21 | ABBV | Stock | 188.71 | 189.38 | 185.89 | 186.54 | 4045665.0 |
| 2024-10-21 | ABCB | Stock | 64.71 | 64.71 | 62.35 | 62.41 | 287990.0 |
| 2024-10-21 | ABCL | Stock | 2.9 | 2.92 | 2.7101 | 2.77 | 2065459.0 |
| 2024-10-21 | ABEO | Stock | 6.67 | 6.74 | 6.54 | 6.55 | 81264.0 |
| 2024-10-21 | ABEV | Stock | 2.27 | 2.29 | 2.26 | 2.29 | 22738851.0 |
| 2024-10-21 | ABG | Stock | 235.32 | 236.05 | 229.77 | 229.97 | 191602.0 |
| 2024-10-21 | ABLLW | Stock | 1.65 | 1.65 | 1.45 | 1.64 | 39890.0 |
| 2024-10-21 | ABLV | Stock | 0.93 | 0.95 | 0.92 | 0.93 | 6068.0 |
| 2024-10-21 | ABLVW | Stock | 0.015 | 0.024 | 0.01335 | 0.0217 | 49725.0 |
| 2024-10-21 | ABM | Stock | 54.99 | 55.035 | 54.05 | 54.29 | 506855.0 |
| 2024-10-21 | ABNB | Stock | 135.66 | 137.99 | 135.13 | 137.19 | 2835380.0 |
| 2024-10-21 | ABOS | Stock | 2.85 | 2.95 | 2.64 | 2.7 | 180210.0 |
| 2024-10-21 | ABR | Stock | 15.4 | 15.42 | 15.01 | 15.04 | 2025377.0 |
| 2024-10-21 | ABR.D | Stock | 19.85 | 19.85 | 19.54 | 19.6535 | 13988.0 |
| 2024-10-21 | ABR.E | Stock | 19.96 | 19.96 | 19.92 | 19.9501 | 1389.0 |
| 2024-10-21 | ABR.F | Stock | 20.13 | 20.18 | 19.889 | 20.04 | 21658.0 |
| 2024-10-21 | ABSI | Stock | 4.19 | 4.2 | 3.97 | 4.04 | 720311.0 |
| 2024-10-21 | ABT | Stock | 118.89 | 118.92 | 116.6 | 116.99 | 8247367.0 |
| 2024-10-21 | ABTC | Stock | 51.690000000000005 | 52.4775 | 47.362500000000004 | 49.8975 | 2102.8 |
| 2024-10-21 | ABTS | Stock | 7.08 | 7.5 | 7.08 | 7.29 | 1291.0 |
| 2024-10-21 | ABUS | Stock | 4.15 | 4.15 | 3.98 | 4.07 | 779829.0 |
| 2024-10-21 | ABVC | Stock | 0.55 | 0.558 | 0.5281 | 0.54 | 35092.0 |
| 2024-10-21 | ABVE | Stock | 0.49 | 0.5357 | 0.4811 | 0.5281 | 12908.0 |
> showing 50 of 7,111 rows — these rows as CSV