PREVIEW / stock_daily / 2024-11-19
file: by_date/stock_daily/2024/2024-11-19.parquet size: 245 KB rows: 7,133 symbols: 644
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-11-19 | AAPL | Stock | 226.98 | 230.16 | 226.66 | 228.28 | 34179595.0 |
| 2024-11-19 | MSFT | Stock | 413.11 | 417.94 | 411.55 | 417.79 | 16881200.0 |
| 2024-11-19 | NVDA | Stock | 141.32 | 147.13 | 140.99 | 147.01 | 222499933.0 |
| 2024-11-19 | AMZN | Stock | 199.33 | 205.3 | 198.78 | 204.61 | 30179304.0 |
| 2024-11-19 | GOOGL | Stock | 173.72 | 178.87 | 173.56 | 178.12 | 23434925.0 |
| 2024-11-19 | META | Stock | 551.86 | 561.43 | 550.6 | 561.09 | 8904674.0 |
| 2024-11-19 | TSLA | Stock | 335.76 | 347.3799 | 332.75 | 346.0 | 88234573.0 |
| 2024-11-19 | TLT | Stock | 90.82 | 91.07 | 90.62 | 90.7 | 29585102.0 |
| 2024-11-19 | ES | Stock | 61.89 | 61.89 | 61.13 | 61.67 | 2099088.0 |
| 2024-11-19 | CL | Stock | 94.4 | 94.43 | 92.975 | 93.61 | 4018819.0 |
| 2024-11-19 | A | Stock | 125.78 | 127.12 | 125.12 | 125.69 | 1487506.0 |
| 2024-11-19 | AA | Stock | 43.79 | 45.64 | 43.79 | 45.6 | 4010406.0 |
| 2024-11-19 | AACG | Stock | 1.02 | 1.02 | 0.9998 | 1.02 | 27545.0 |
| 2024-11-19 | AACT | Stock | 10.91 | 10.95 | 10.899 | 10.9268 | 569611.0 |
| 2024-11-19 | AAL | Stock | 13.93 | 14.4 | 13.84 | 14.33 | 25233382.0 |
| 2024-11-19 | AAM | Stock | 10.06 | 10.06 | 10.05 | 10.05 | 93584.0 |
| 2024-11-19 | AAME | Stock | 1.62 | 1.66 | 1.55 | 1.6 | 6316.0 |
| 2024-11-19 | AAMI | Stock | 29.6 | 30.19 | 29.55 | 29.91 | 241033.0 |
| 2024-11-19 | AAOI | Stock | 26.96 | 28.63 | 26.96 | 28.55 | 2060770.0 |
| 2024-11-19 | AAON | Stock | 130.09 | 131.67 | 129.3275 | 131.16 | 592045.0 |
| 2024-11-19 | AAP | Stock | 39.34 | 39.62 | 38.11 | 38.5 | 2492788.0 |
| 2024-11-19 | AAT | Stock | 26.93 | 27.84 | 26.81 | 27.84 | 188583.0 |
| 2024-11-19 | AATC | Stock | 7.9 | 8.19 | 7.9 | 8.0 | 4220.0 |
| 2024-11-19 | AAUAF-DELISTED | Stock | 0.037 | 0.048 | 0.034 | 0.0417 | 22815.0 |
| 2024-11-19 | AAXJ | Stock | 74.1 | 74.5299 | 74.055 | 74.38 | 787404.0 |
| 2024-11-19 | AB | Stock | 36.6 | 36.79 | 36.22 | 36.5 | 249278.0 |
| 2024-11-19 | ABAT | Stock | 0.82 | 0.85 | 0.77 | 0.7999 | 858936.0 |
| 2024-11-19 | ABBV | Stock | 165.27 | 167.1 | 163.81 | 166.57 | 5079704.0 |
| 2024-11-19 | ABCB | Stock | 68.07 | 68.78 | 67.74 | 68.71 | 232180.0 |
| 2024-11-19 | ABCL | Stock | 2.63 | 2.72 | 2.61 | 2.71 | 1795247.0 |
| 2024-11-19 | ABEO | Stock | 5.83 | 5.93 | 5.77 | 5.89 | 251593.0 |
| 2024-11-19 | ABEV | Stock | 2.18 | 2.21 | 2.17 | 2.18 | 19479528.0 |
| 2024-11-19 | ABG | Stock | 251.88 | 254.09 | 249.74 | 250.47 | 116514.0 |
| 2024-11-19 | ABLLW | Stock | 1.22 | 1.43 | 1.2 | 1.41 | 18097.0 |
| 2024-11-19 | ABLV | Stock | 0.88 | 0.9 | 0.8601 | 0.8601 | 16830.0 |
| 2024-11-19 | ABLVW | Stock | 0.019 | 0.019 | 0.019 | 0.019 | 1131.0 |
| 2024-11-19 | ABM | Stock | 54.52 | 55.59 | 54.42 | 55.36 | 232020.0 |
| 2024-11-19 | ABNB | Stock | 131.15 | 131.96 | 129.87 | 131.44 | 4792964.0 |
| 2024-11-19 | ABOS | Stock | 2.23 | 2.39 | 2.23 | 2.39 | 146066.0 |
| 2024-11-19 | ABPWW | Stock | 0.05 | 0.08 | 0.0499 | 0.08 | 1624.0 |
| 2024-11-19 | ABR | Stock | 14.65 | 14.895 | 14.62 | 14.75 | 1833814.0 |
| 2024-11-19 | ABR.D | Stock | 18.51 | 18.51 | 18.2 | 18.3 | 34275.0 |
| 2024-11-19 | ABR.E | Stock | 18.88 | 18.9 | 18.5 | 18.84 | 8454.0 |
| 2024-11-19 | ABR.F | Stock | 20.4 | 20.53 | 20.31 | 20.35 | 31027.0 |
| 2024-11-19 | ABSI | Stock | 2.77 | 2.77 | 2.45 | 2.72 | 1594240.0 |
| 2024-11-19 | ABT | Stock | 116.54 | 117.55 | 115.45 | 117.13 | 4179316.0 |
| 2024-11-19 | ABTC | Stock | 49.425 | 56.0475 | 45.435 | 54.9975 | 16497.066666666666 |
| 2024-11-19 | ABTS | Stock | 8.4 | 8.7 | 7.875 | 8.4315 | 3512.0 |
| 2024-11-19 | ABUS | Stock | 3.51 | 3.5199 | 3.42 | 3.49 | 901990.0 |
| 2024-11-19 | ABVC | Stock | 0.52 | 0.56 | 0.5 | 0.5252 | 60190.0 |
> showing 50 of 7,133 rows — these rows as CSV