PREVIEW / stock_daily / 2024-12-16
file: by_date/stock_daily/2024/2024-12-16.parquet size: 247 KB rows: 7,199 symbols: 613
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-16 | AAPL | Stock | 247.99 | 251.38 | 247.65 | 251.04 | 47967301.0 |
| 2024-12-16 | MSFT | Stock | 447.27 | 452.18 | 445.28 | 451.59 | 21695003.0 |
| 2024-12-16 | NVDA | Stock | 134.18 | 134.4 | 130.42 | 132.0 | 227962345.0 |
| 2024-12-16 | AMZN | Stock | 230.23 | 233.0 | 228.01 | 232.93 | 34748183.0 |
| 2024-12-16 | GOOGL | Stock | 192.87 | 199.0 | 192.62 | 196.66 | 44934901.0 |
| 2024-12-16 | META | Stock | 629.975 | 631.15 | 618.58 | 624.24 | 10694869.0 |
| 2024-12-16 | TSLA | Stock | 441.09 | 463.19 | 436.15 | 463.02 | 111605157.0 |
| 2024-12-16 | TLT | Stock | 90.55 | 90.6152 | 90.05 | 90.42 | 23482268.0 |
| 2024-12-16 | ES | Stock | 59.43 | 59.64 | 58.01 | 58.13 | 2240847.0 |
| 2024-12-16 | CL | Stock | 93.62 | 94.27 | 92.8 | 92.92 | 6347236.0 |
| 2024-12-16 | A | Stock | 138.63 | 139.938 | 137.0 | 137.67 | 1458262.0 |
| 2024-12-16 | AA | Stock | 38.86 | 39.19 | 38.26 | 38.46 | 3627093.0 |
| 2024-12-16 | AACG | Stock | 0.89 | 0.9099 | 0.88 | 0.8991 | 9989.0 |
| 2024-12-16 | AACT | Stock | 10.93 | 10.95 | 10.93 | 10.93 | 11849.0 |
| 2024-12-16 | AAGR-DELISTED | Stock | 0.0075 | 0.0075 | 0.0075 | 0.0075 | 112.0 |
| 2024-12-16 | AAL | Stock | 16.91 | 16.955 | 16.46 | 16.52 | 15671593.0 |
| 2024-12-16 | AAM | Stock | 10.09 | 10.09 | 10.07 | 10.07 | 8839.0 |
| 2024-12-16 | AAME | Stock | 1.55 | 1.55 | 1.5 | 1.5 | 616.0 |
| 2024-12-16 | AAMI | Stock | 30.16 | 30.66 | 30.04 | 30.27 | 171616.0 |
| 2024-12-16 | AAOI | Stock | 36.37 | 36.5 | 34.68 | 35.09 | 2351106.0 |
| 2024-12-16 | AAON | Stock | 131.5 | 135.38 | 131.5 | 134.66 | 339781.0 |
| 2024-12-16 | AAP | Stock | 43.56 | 45.77 | 43.4 | 43.98 | 1611970.0 |
| 2024-12-16 | AAT | Stock | 27.66 | 28.02 | 27.61 | 27.72 | 537828.0 |
| 2024-12-16 | AATC | Stock | 7.99 | 8.0 | 7.97 | 7.9708 | 2842.0 |
| 2024-12-16 | AAUAF-DELISTED | Stock | 0.0413 | 0.048 | 0.0397 | 0.04238 | 58213.0 |
| 2024-12-16 | AAXJ | Stock | 74.95 | 75.17 | 74.84 | 74.99 | 174232.0 |
| 2024-12-16 | AB | Stock | 35.84 | 36.49 | 35.66 | 35.67 | 294633.0 |
| 2024-12-16 | ABAT | Stock | 0.93 | 1.08 | 0.8573 | 0.8573 | 1436642.0 |
| 2024-12-16 | ABBV | Stock | 171.674 | 173.34 | 170.53 | 171.63 | 7516759.0 |
| 2024-12-16 | ABCB | Stock | 66.77 | 67.02 | 66.17 | 67.0 | 414330.0 |
| 2024-12-16 | ABCL | Stock | 2.83 | 3.0 | 2.79 | 2.86 | 2925544.0 |
| 2024-12-16 | ABEO | Stock | 5.86 | 6.0 | 5.84 | 5.89 | 218109.0 |
| 2024-12-16 | ABEV | Stock | 2.15 | 2.16 | 2.07 | 2.08 | 23815527.0 |
| 2024-12-16 | ABG | Stock | 252.56 | 257.39 | 252.56 | 256.67 | 158140.0 |
| 2024-12-16 | ABLLW | Stock | 1.13 | 1.1501 | 1.07 | 1.14 | 101500.0 |
| 2024-12-16 | ABLV | Stock | 0.5601 | 0.769 | 0.5601 | 0.665 | 20691.0 |
| 2024-12-16 | ABLVW | Stock | 0.0133 | 0.0133 | 0.0112 | 0.012 | 5020.0 |
| 2024-12-16 | ABM | Stock | 56.04 | 56.825 | 55.68 | 56.76 | 264085.0 |
| 2024-12-16 | ABNB | Stock | 131.22 | 133.28 | 129.17 | 132.2 | 3953620.0 |
| 2024-12-16 | ABOS | Stock | 1.99 | 2.015 | 1.923 | 1.97 | 405741.0 |
| 2024-12-16 | ABR | Stock | 14.34 | 14.55 | 14.28 | 14.41 | 1593959.0 |
| 2024-12-16 | ABR.D | Stock | 19.24 | 19.5 | 19.09 | 19.5 | 10052.0 |
| 2024-12-16 | ABR.E | Stock | 18.74 | 18.74 | 18.52 | 18.6 | 191893.0 |
| 2024-12-16 | ABR.F | Stock | 22.34 | 22.79 | 22.3 | 22.79 | 19105.0 |
| 2024-12-16 | ABSI | Stock | 3.65 | 4.11 | 3.53 | 3.83 | 2420029.0 |
| 2024-12-16 | ABT | Stock | 112.7 | 113.64931 | 112.385 | 112.62 | 4902950.0 |
| 2024-12-16 | ABTC | Stock | 43.5 | 44.167500000000004 | 37.6575 | 38.167500000000004 | 18425.666666666668 |
| 2024-12-16 | ABTS | Stock | 7.95 | 7.95 | 6.9225 | 7.8 | 4771.0 |
| 2024-12-16 | ABUS | Stock | 3.45 | 3.605 | 3.44 | 3.55 | 538950.0 |
| 2024-12-16 | ABVC | Stock | 0.51 | 0.515 | 0.4815 | 0.51 | 109960.0 |
> showing 50 of 7,199 rows — these rows as CSV