PREVIEW / stock_daily / 2024-05-23
file: by_date/stock_daily/2024/2024-05-23.parquet size: 231 KB rows: 7,195 symbols: 962
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-05-23 | AAPL | Stock | 190.98 | 191.0 | 186.63 | 186.88 | 51005900.0 |
| 2024-05-23 | MSFT | Stock | 432.97 | 433.6 | 425.42 | 427.0 | 17211700.0 |
| 2024-05-23 | NVDA | Stock | 102.028 | 106.32 | 101.52 | 103.799 | 835065000.0 |
| 2024-05-23 | AMZN | Stock | 183.66 | 184.76 | 180.08 | 181.05 | 33670200.0 |
| 2024-05-23 | GOOGL | Stock | 177.07 | 178.25 | 172.95 | 173.55 | 21024935.0 |
| 2024-05-23 | META | Stock | 472.88 | 474.36 | 461.54 | 465.78 | 11747900.0 |
| 2024-05-23 | TSLA | Stock | 181.8 | 181.9 | 173.26 | 173.74 | 71975500.0 |
| 2024-05-23 | TLT | Stock | 91.8 | 91.8 | 90.82 | 91.11 | 51294662.0 |
| 2024-05-23 | ES | Stock | 59.28 | 59.3 | 57.45 | 57.53 | 1776800.0 |
| 2024-05-23 | CL | Stock | 94.52 | 95.01 | 93.65 | 93.73 | 3948900.0 |
| 2024-05-23 | A | Stock | 152.47 | 152.47 | 150.11 | 150.55 | 1005200.0 |
| 2024-05-23 | AA | Stock | 42.2 | 42.255 | 40.33 | 41.05 | 4764100.0 |
| 2024-05-23 | AACG | Stock | 0.94 | 0.94 | 0.88 | 0.88 | 7000.0 |
| 2024-05-23 | AACIW-DELISTED | Stock | 0.13 | 0.135 | 0.1289 | 0.135 | 138011.0 |
| 2024-05-23 | AACT | Stock | 10.645 | 10.645 | 10.63 | 10.64 | 102700.0 |
| 2024-05-23 | AAGR-DELISTED | Stock | 0.3501 | 0.3999 | 0.3435 | 0.3566 | 81948.0 |
| 2024-05-23 | AAGRW-DELISTED | Stock | 0.0111 | 0.015 | 0.0111 | 0.015 | 390.0 |
| 2024-05-23 | AAL | Stock | 14.13 | 14.14 | 13.72 | 13.82 | 29089800.0 |
| 2024-05-23 | AAMC-DELISTED | Stock | 2.69 | 2.69 | 2.38 | 2.49 | 4900.0 |
| 2024-05-23 | AAME | Stock | 1.71 | 1.71 | 1.68 | 1.68 | 800.0 |
| 2024-05-23 | AAMI | Stock | 22.26 | 22.45 | 22.01 | 22.14 | 256500.0 |
| 2024-05-23 | AAN-DELISTED | Stock | 7.39 | 7.39 | 7.07 | 7.15 | 152100.0 |
| 2024-05-23 | AAOI | Stock | 12.04 | 12.4 | 11.65 | 11.9 | 1937400.0 |
| 2024-05-23 | AAON | Stock | 76.39 | 76.39 | 74.96 | 76.26 | 469400.0 |
| 2024-05-23 | AAP | Stock | 70.12 | 70.12 | 68.72 | 69.42 | 1650300.0 |
| 2024-05-23 | AAT | Stock | 21.74 | 21.74 | 20.88 | 21.08 | 298900.0 |
| 2024-05-23 | AATC | Stock | 6.35 | 6.35 | 6.16 | 6.35 | 1915.0 |
| 2024-05-23 | AAUAF-DELISTED | Stock | 0.122 | 0.13 | 0.1219 | 0.12595 | 18609.0 |
| 2024-05-23 | AAXJ | Stock | 72.82 | 72.88 | 71.82 | 72.0 | 310279.0 |
| 2024-05-23 | AB | Stock | 34.22 | 34.54 | 33.33 | 33.37 | 354800.0 |
| 2024-05-23 | ABAT | Stock | 1.46 | 1.48 | 1.41 | 1.43 | 298877.0 |
| 2024-05-23 | ABBV | Stock | 159.03 | 160.04 | 157.76 | 158.26 | 5672900.0 |
| 2024-05-23 | ABCB | Stock | 49.66 | 49.66 | 47.65 | 47.81 | 197100.0 |
| 2024-05-23 | ABCL | Stock | 3.87 | 4.01 | 3.81 | 3.85 | 1332900.0 |
| 2024-05-23 | ABEO | Stock | 4.29 | 4.3 | 4.1 | 4.17 | 515300.0 |
| 2024-05-23 | ABEV | Stock | 2.32 | 2.32 | 2.28 | 2.28 | 17663400.0 |
| 2024-05-23 | ABG | Stock | 235.02 | 235.02 | 227.14 | 228.08 | 128500.0 |
| 2024-05-23 | ABLLW | Stock | 0.3325 | 0.3475 | 0.3311 | 0.34 | 2821.0 |
| 2024-05-23 | ABLV | Stock | 1.64 | 1.65 | 1.46 | 1.49 | 42100.0 |
| 2024-05-23 | ABM | Stock | 47.47 | 47.48 | 46.97 | 47.22 | 358100.0 |
| 2024-05-23 | ABNB | Stock | 142.58 | 143.44 | 140.82 | 141.04 | 3900900.0 |
| 2024-05-23 | ABOS | Stock | 3.61 | 3.61 | 3.33 | 3.4 | 181700.0 |
| 2024-05-23 | ABR | Stock | 13.5 | 13.51 | 13.12 | 13.23 | 3328000.0 |
| 2024-05-23 | ABR.D | Stock | 18.3 | 18.7423 | 18.0 | 18.04 | 22483.0 |
| 2024-05-23 | ABR.E | Stock | 18.14 | 18.14 | 17.46 | 17.4799 | 22877.0 |
| 2024-05-23 | ABR.F | Stock | 20.0 | 20.0 | 19.52 | 19.61 | 5921.0 |
| 2024-05-23 | ABSI | Stock | 4.65 | 4.7 | 4.23 | 4.35 | 1227400.0 |
| 2024-05-23 | ABT | Stock | 103.96 | 104.91 | 103.44 | 104.23 | 5862200.0 |
| 2024-05-23 | ABTC | Stock | 115.5 | 115.5 | 101.25 | 103.5 | 6806.666666666667 |
| 2024-05-23 | ABTS | Stock | 9.9 | 10.5 | 9.75 | 10.5 | 1307.0 |
> showing 50 of 7,195 rows — these rows as CSV