PREVIEW / stock_daily / 2024-08-23
file: by_date/stock_daily/2024/2024-08-23.parquet size: 246 KB rows: 7,144 symbols: 773
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-08-23 | AAPL | Stock | 225.6589 | 228.22 | 224.33 | 226.84 | 38043084.0 |
| 2024-08-23 | MSFT | Stock | 416.98 | 419.26 | 412.09 | 416.79 | 17505030.0 |
| 2024-08-23 | NVDA | Stock | 125.86 | 129.6 | 125.22 | 129.37 | 319900356.0 |
| 2024-08-23 | AMZN | Stock | 177.34 | 178.9699 | 175.24 | 177.04 | 28738276.0 |
| 2024-08-23 | GOOGL | Stock | 164.72 | 166.18 | 163.83 | 165.62 | 13955741.0 |
| 2024-08-23 | META | Stock | 536.92 | 539.87 | 525.06 | 528.0 | 11032950.0 |
| 2024-08-23 | TSLA | Stock | 214.455 | 221.48 | 214.21 | 220.32 | 81280745.0 |
| 2024-08-23 | TLT | Stock | 98.19 | 98.67 | 97.96 | 98.39 | 32005083.0 |
| 2024-08-23 | ES | Stock | 67.36 | 67.445 | 66.56 | 66.78 | 1538096.0 |
| 2024-08-23 | CL | Stock | 104.3 | 104.34 | 103.11 | 104.21 | 3128024.0 |
| 2024-08-23 | A | Stock | 141.21 | 142.27 | 140.16 | 140.87 | 1717741.0 |
| 2024-08-23 | AA | Stock | 32.75 | 34.1 | 32.51 | 33.92 | 4068125.0 |
| 2024-08-23 | AACG | Stock | 0.5838 | 0.66 | 0.5671 | 0.6399 | 30412.0 |
| 2024-08-23 | AACT | Stock | 10.76 | 10.76 | 10.745 | 10.75 | 56036.0 |
| 2024-08-23 | AAGR-DELISTED | Stock | 0.132 | 0.138 | 0.129 | 0.1379 | 97345.0 |
| 2024-08-23 | AAGRW-DELISTED | Stock | 0.0119 | 0.0119 | 0.0117 | 0.0118 | 838.0 |
| 2024-08-23 | AAL | Stock | 10.23 | 10.5 | 10.17 | 10.39 | 24470480.0 |
| 2024-08-23 | AAMC-DELISTED | Stock | 2.3688 | 2.37 | 2.32 | 2.37 | 1440.0 |
| 2024-08-23 | AAME | Stock | 1.5301 | 1.55 | 1.53 | 1.54 | 4076.0 |
| 2024-08-23 | AAMI | Stock | 23.37 | 23.77 | 23.2 | 23.64 | 131649.0 |
| 2024-08-23 | AAN-DELISTED | Stock | 10.09 | 10.11 | 10.07 | 10.07 | 876789.0 |
| 2024-08-23 | AAOI | Stock | 9.19 | 9.72 | 8.87 | 9.71 | 2368171.0 |
| 2024-08-23 | AAON | Stock | 93.25 | 95.88 | 92.755 | 94.55 | 356234.0 |
| 2024-08-23 | AAP | Stock | 51.3 | 51.49 | 47.97 | 49.15 | 6619253.0 |
| 2024-08-23 | AAT | Stock | 26.19 | 27.01 | 26.1 | 26.64 | 222147.0 |
| 2024-08-23 | AATC | Stock | 7.25 | 7.3 | 7.19 | 7.22 | 5095.0 |
| 2024-08-23 | AAUAF-DELISTED | Stock | 0.0482 | 0.05466 | 0.0482 | 0.0482 | 25861.0 |
| 2024-08-23 | AAXJ | Stock | 73.17 | 73.805 | 72.985 | 73.65 | 222953.0 |
| 2024-08-23 | AB | Stock | 34.99 | 35.5 | 34.8513 | 34.96 | 359238.0 |
| 2024-08-23 | ABAT | Stock | 1.05 | 1.07 | 1.04 | 1.07 | 167340.0 |
| 2024-08-23 | ABBV | Stock | 197.25 | 197.98 | 196.2271 | 197.55 | 4650917.0 |
| 2024-08-23 | ABCB | Stock | 59.1 | 62.77 | 58.7 | 61.89 | 317235.0 |
| 2024-08-23 | ABCL | Stock | 2.53 | 2.645 | 2.525 | 2.61 | 1801485.0 |
| 2024-08-23 | ABEO | Stock | 5.13 | 5.5482 | 5.13 | 5.515 | 397220.0 |
| 2024-08-23 | ABEV | Stock | 2.38 | 2.41 | 2.35 | 2.4 | 36622261.0 |
| 2024-08-23 | ABG | Stock | 232.91 | 242.06 | 232.84 | 241.78 | 142802.0 |
| 2024-08-23 | ABLLW | Stock | 1.44 | 1.45 | 1.4 | 1.45 | 7265.0 |
| 2024-08-23 | ABLV | Stock | 1.71 | 1.71 | 1.69 | 1.69 | 1128.0 |
| 2024-08-23 | ABM | Stock | 54.87 | 55.855 | 54.51 | 55.43 | 246614.0 |
| 2024-08-23 | ABNB | Stock | 116.64 | 118.7 | 116.37 | 116.85 | 4966612.0 |
| 2024-08-23 | ABOS | Stock | 2.85 | 2.95 | 2.81 | 2.91 | 170553.0 |
| 2024-08-23 | ABR | Stock | 13.23 | 13.485 | 13.17 | 13.33 | 2601850.0 |
| 2024-08-23 | ABR.D | Stock | 17.75 | 17.89 | 17.7 | 17.74 | 13493.0 |
| 2024-08-23 | ABR.E | Stock | 17.46 | 17.57 | 17.45 | 17.45 | 5594.0 |
| 2024-08-23 | ABR.F | Stock | 18.12 | 18.18 | 18.1 | 18.1 | 38333.0 |
| 2024-08-23 | ABSI | Stock | 4.3 | 4.5 | 4.23 | 4.49 | 736436.0 |
| 2024-08-23 | ABT | Stock | 112.4 | 112.78 | 111.89 | 112.69 | 4023212.0 |
| 2024-08-23 | ABTC | Stock | 56.3325 | 58.4175 | 55.5075 | 58.0875 | 4084.733333333333 |
| 2024-08-23 | ABTS | Stock | 7.293 | 7.818 | 7.0065 | 7.275 | 581.0 |
| 2024-08-23 | ABUS | Stock | 3.85 | 3.93 | 3.835 | 3.89 | 945373.0 |
> showing 50 of 7,144 rows — these rows as CSV