PREVIEW / stock_daily / 2024-12-31
file: by_date/stock_daily/2024/2024-12-31.parquet size: 246 KB rows: 7,169 symbols: 548
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-12-31 | AAPL | Stock | 252.44 | 253.28 | 249.43 | 250.42 | 34271788.0 |
| 2024-12-31 | MSFT | Stock | 426.1 | 426.73 | 420.66 | 421.5 | 12778195.0 |
| 2024-12-31 | NVDA | Stock | 138.03 | 138.07 | 133.83 | 134.29 | 153390381.0 |
| 2024-12-31 | AMZN | Stock | 222.965 | 223.2299 | 218.94 | 219.39 | 23424388.0 |
| 2024-12-31 | GOOGL | Stock | 191.075 | 191.96 | 188.51 | 189.3 | 17466919.0 |
| 2024-12-31 | META | Stock | 592.265 | 593.97 | 583.85 | 585.51 | 5801404.0 |
| 2024-12-31 | TSLA | Stock | 423.79 | 427.93 | 402.54 | 403.84 | 74950198.0 |
| 2024-12-31 | TLT | Stock | 88.13 | 88.28 | 87.26 | 87.33 | 31917307.0 |
| 2024-12-31 | ES | Stock | 57.4 | 57.75 | 56.92 | 57.43 | 1525426.0 |
| 2024-12-31 | CL | Stock | 91.03 | 91.52 | 90.26 | 90.91 | 2383873.0 |
| 2024-12-31 | A | Stock | 134.81 | 135.91 | 134.03 | 134.34 | 684175.0 |
| 2024-12-31 | AA | Stock | 37.24 | 38.18 | 37.24 | 37.78 | 2350728.0 |
| 2024-12-31 | AACG | Stock | 0.85 | 0.86 | 0.8127 | 0.846 | 18083.0 |
| 2024-12-31 | AACT | Stock | 10.97 | 10.98 | 10.96 | 10.98 | 12848.0 |
| 2024-12-31 | AAGR-DELISTED | Stock | 0.008 | 0.008 | 0.0 | 0.0 | 77838.0 |
| 2024-12-31 | AAL | Stock | 17.63 | 17.7488 | 17.35 | 17.43 | 12647592.0 |
| 2024-12-31 | AAM | Stock | 10.1 | 10.11 | 10.1 | 10.1 | 11543.0 |
| 2024-12-31 | AAME | Stock | 1.4506 | 1.55 | 1.4506 | 1.54 | 4641.0 |
| 2024-12-31 | AAMI | Stock | 26.54 | 26.72 | 26.07 | 26.34 | 221467.0 |
| 2024-12-31 | AAOI | Stock | 36.4 | 37.7 | 35.96 | 36.86 | 2299959.0 |
| 2024-12-31 | AAON | Stock | 120.0 | 120.84 | 117.235 | 117.68 | 406789.0 |
| 2024-12-31 | AAP | Stock | 46.1 | 47.69 | 46.06 | 47.29 | 2575572.0 |
| 2024-12-31 | AAT | Stock | 26.2 | 26.32 | 26.03 | 26.26 | 167322.0 |
| 2024-12-31 | AATC | Stock | 8.01 | 8.027 | 8.0 | 8.0 | 811.0 |
| 2024-12-31 | AAUAF-DELISTED | Stock | 0.0385 | 0.04 | 0.033 | 0.03665 | 93424.0 |
| 2024-12-31 | AAXJ | Stock | 72.4 | 72.5 | 72.07 | 72.18 | 109515.0 |
| 2024-12-31 | AB | Stock | 36.64 | 37.1 | 36.46 | 37.09 | 382065.0 |
| 2024-12-31 | ABAT | Stock | 2.7 | 2.73 | 2.17 | 2.46 | 9524402.0 |
| 2024-12-31 | ABBV | Stock | 176.35 | 177.84 | 175.92 | 177.7 | 2834033.0 |
| 2024-12-31 | ABCB | Stock | 62.83 | 63.11 | 62.19 | 62.57 | 287466.0 |
| 2024-12-31 | ABCL | Stock | 2.81 | 2.945 | 2.81 | 2.93 | 1858201.0 |
| 2024-12-31 | ABEO | Stock | 5.64 | 5.665 | 5.51 | 5.57 | 203401.0 |
| 2024-12-31 | ABEV | Stock | 1.85 | 1.86 | 1.82 | 1.85 | 30981410.0 |
| 2024-12-31 | ABG | Stock | 243.67 | 247.0099 | 242.775 | 243.03 | 115009.0 |
| 2024-12-31 | ABLLW | Stock | 1.06 | 1.09 | 1.04 | 1.05 | 35121.0 |
| 2024-12-31 | ABLV | Stock | 0.72 | 0.7689 | 0.6418 | 0.74798 | 3665.0 |
| 2024-12-31 | ABLVW | Stock | 0.0115 | 0.019 | 0.0115 | 0.0189 | 777.0 |
| 2024-12-31 | ABM | Stock | 51.68 | 51.88 | 50.945 | 51.18 | 389849.0 |
| 2024-12-31 | ABNB | Stock | 132.46 | 133.19 | 131.27 | 131.41 | 2197060.0 |
| 2024-12-31 | ABOS | Stock | 1.74 | 1.78 | 1.7 | 1.72 | 268930.0 |
| 2024-12-31 | ABPWW | Stock | 0.08 | 0.08 | 0.042 | 0.0625 | 66606.0 |
| 2024-12-31 | ABR | Stock | 13.79 | 13.945 | 13.7201 | 13.85 | 1836836.0 |
| 2024-12-31 | ABR.D | Stock | 19.0668 | 19.0753 | 18.15 | 18.54 | 99620.0 |
| 2024-12-31 | ABR.E | Stock | 18.5737 | 18.69 | 18.11 | 18.65 | 8136.0 |
| 2024-12-31 | ABR.F | Stock | 22.91 | 23.1399 | 22.5 | 22.84 | 133157.0 |
| 2024-12-31 | ABSI | Stock | 2.68 | 2.69 | 2.545 | 2.62 | 2369053.0 |
| 2024-12-31 | ABT | Stock | 113.06 | 113.775 | 112.545 | 113.11 | 3287000.0 |
| 2024-12-31 | ABTC | Stock | 30.255 | 30.869999999999997 | 26.302500000000002 | 30.0525 | 25666.466666666667 |
| 2024-12-31 | ABTS | Stock | 7.167 | 14.0955 | 7.167 | 10.3335 | 467978.0 |
| 2024-12-31 | ABUS | Stock | 3.24 | 3.285 | 3.21 | 3.27 | 723313.0 |
> showing 50 of 7,169 rows — these rows as CSV