PREVIEW / stock_daily / 2024-12-23
file: by_date/stock_daily/2024/2024-12-23.parquet size: 245 KB rows: 7,149 symbols: 551
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-23 | AAPL | Stock | 254.77 | 255.65 | 253.45 | 255.27 | 38425676.0 |
| 2024-12-23 | MSFT | Stock | 436.74 | 437.65 | 432.83 | 435.25 | 16491069.0 |
| 2024-12-23 | NVDA | Stock | 136.28 | 139.79 | 135.1201 | 139.67 | 173696271.0 |
| 2024-12-23 | AMZN | Stock | 225.01 | 226.88 | 223.9 | 225.06 | 25343320.0 |
| 2024-12-23 | GOOGL | Stock | 192.62 | 195.1 | 190.15 | 194.63 | 25675014.0 |
| 2024-12-23 | META | Stock | 589.6 | 601.09 | 586.25 | 599.85 | 9937486.0 |
| 2024-12-23 | TSLA | Stock | 431.0 | 434.51 | 415.4112 | 430.6 | 71374846.0 |
| 2024-12-23 | TLT | Stock | 88.16 | 88.23 | 87.44 | 87.5 | 32764561.0 |
| 2024-12-23 | ES | Stock | 56.71 | 57.23 | 56.28 | 57.18 | 1860140.0 |
| 2024-12-23 | CL | Stock | 91.97 | 92.2 | 91.08 | 91.91 | 2862271.0 |
| 2024-12-23 | A | Stock | 134.16 | 134.69 | 133.17 | 134.6 | 1094670.0 |
| 2024-12-23 | AA | Stock | 37.84 | 38.75 | 37.59 | 38.58 | 2772320.0 |
| 2024-12-23 | AACG | Stock | 0.849 | 0.849 | 0.7887 | 0.8101 | 8382.0 |
| 2024-12-23 | AACT | Stock | 10.92 | 10.99 | 10.92 | 10.97 | 248395.0 |
| 2024-12-23 | AAGR-DELISTED | Stock | 0.0005 | 0.0005 | 0.0 | 0.0 | 538.0 |
| 2024-12-23 | AAL | Stock | 16.87 | 17.27 | 16.87 | 17.25 | 15663016.0 |
| 2024-12-23 | AAM | Stock | 10.07 | 10.1 | 10.07 | 10.0906 | 5404.0 |
| 2024-12-23 | AAME | Stock | 1.471 | 1.51 | 1.471 | 1.51 | 2107.0 |
| 2024-12-23 | AAMI | Stock | 26.93 | 27.3 | 26.58 | 26.73 | 160794.0 |
| 2024-12-23 | AAOI | Stock | 37.52 | 39.03 | 35.7 | 36.72 | 2285789.0 |
| 2024-12-23 | AAON | Stock | 123.67 | 124.72 | 122.74 | 123.21 | 330516.0 |
| 2024-12-23 | AAP | Stock | 43.04 | 43.855 | 42.6 | 43.75 | 1291682.0 |
| 2024-12-23 | AAT | Stock | 25.87 | 26.11 | 25.86 | 26.07 | 182143.0 |
| 2024-12-23 | AATC | Stock | 7.985 | 7.985 | 7.985 | 7.985 | 188.0 |
| 2024-12-23 | AAUAF-DELISTED | Stock | 0.03 | 0.03875 | 0.03 | 0.0369 | 196617.0 |
| 2024-12-23 | AAXJ | Stock | 72.84 | 73.31 | 72.65 | 73.25 | 225383.0 |
| 2024-12-23 | AB | Stock | 37.27 | 37.37 | 36.27 | 36.49 | 372715.0 |
| 2024-12-23 | ABAT | Stock | 1.57 | 1.83 | 1.31 | 1.78 | 38701549.0 |
| 2024-12-23 | ABBV | Stock | 175.29 | 178.65 | 174.63 | 178.39 | 6054422.0 |
| 2024-12-23 | ABCB | Stock | 62.37 | 63.0 | 61.99 | 63.0 | 350163.0 |
| 2024-12-23 | ABCL | Stock | 2.82 | 2.95 | 2.815 | 2.92 | 2079191.0 |
| 2024-12-23 | ABEO | Stock | 5.68 | 5.7199 | 5.57 | 5.69 | 163104.0 |
| 2024-12-23 | ABEV | Stock | 1.97 | 1.98 | 1.88 | 1.9 | 69319100.0 |
| 2024-12-23 | ABG | Stock | 245.23 | 245.23 | 240.98 | 243.78 | 102881.0 |
| 2024-12-23 | ABLLW | Stock | 1.14 | 1.15 | 1.11 | 1.15 | 25873.0 |
| 2024-12-23 | ABLV | Stock | 0.7 | 0.7001 | 0.65 | 0.67 | 7629.0 |
| 2024-12-23 | ABM | Stock | 50.28 | 51.0 | 50.011 | 50.35 | 376854.0 |
| 2024-12-23 | ABNB | Stock | 134.81 | 135.58 | 132.21 | 134.52 | 4593341.0 |
| 2024-12-23 | ABOS | Stock | 1.85 | 1.85 | 1.758 | 1.77 | 667802.0 |
| 2024-12-23 | ABPWW | Stock | 0.09 | 0.11 | 0.0695 | 0.11 | 13864.0 |
| 2024-12-23 | ABR | Stock | 13.78 | 13.84 | 13.6131 | 13.83 | 2038790.0 |
| 2024-12-23 | ABR.D | Stock | 18.75 | 19.11 | 18.68 | 19.11 | 44464.0 |
| 2024-12-23 | ABR.E | Stock | 18.5 | 18.74 | 18.2396 | 18.7 | 38658.0 |
| 2024-12-23 | ABR.F | Stock | 22.97 | 23.0999 | 22.851 | 23.0 | 20103.0 |
| 2024-12-23 | ABSI | Stock | 3.0 | 3.0 | 2.865 | 2.93 | 1432219.0 |
| 2024-12-23 | ABT | Stock | 114.0 | 114.51 | 112.96 | 114.31 | 3785780.0 |
| 2024-12-23 | ABTC | Stock | 33.375 | 34.4625 | 31.560000000000002 | 32.025 | 7019.333333333333 |
| 2024-12-23 | ABTS | Stock | 6.8115 | 7.365 | 6.6465 | 6.6705 | 4245.0 |
| 2024-12-23 | ABUS | Stock | 3.19 | 3.245 | 3.1501 | 3.19 | 568284.0 |
| 2024-12-23 | ABVC | Stock | 0.51 | 0.54 | 0.49 | 0.53 | 109356.0 |
> showing 50 of 7,149 rows — these rows as CSV