PREVIEW / stock_daily / 2024-07-22
file: by_date/stock_daily/2024/2024-07-22.parquet size: 246 KB rows: 7,210 symbols: 896
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-07-22 | AAPL | Stock | 227.01 | 227.78 | 223.09 | 223.96 | 44963114.0 |
| 2024-07-22 | MSFT | Stock | 441.79 | 444.6 | 438.9125 | 442.94 | 14913318.0 |
| 2024-07-22 | NVDA | Stock | 120.35 | 124.07 | 119.86 | 123.54 | 251157737.0 |
| 2024-07-22 | AMZN | Stock | 185.0 | 185.06 | 182.48 | 182.55 | 37606720.0 |
| 2024-07-22 | GOOGL | Stock | 180.59 | 182.7 | 180.23 | 181.67 | 24100345.0 |
| 2024-07-22 | META | Stock | 486.575 | 492.06 | 483.9 | 487.4 | 11838883.0 |
| 2024-07-22 | TSLA | Stock | 244.21 | 253.21 | 243.75 | 251.51 | 100423132.0 |
| 2024-07-22 | TLT | Stock | 93.4 | 93.52 | 92.3 | 92.65 | 36160366.0 |
| 2024-07-22 | ES | Stock | 61.25 | 62.12 | 61.045 | 61.76 | 1429606.0 |
| 2024-07-22 | CL | Stock | 98.13 | 98.14 | 97.31 | 97.95 | 3127323.0 |
| 2024-07-22 | A | Stock | 133.06 | 133.93 | 131.4 | 133.42 | 1963596.0 |
| 2024-07-22 | AA | Stock | 34.7 | 34.82 | 34.22 | 34.53 | 6072902.0 |
| 2024-07-22 | AACG | Stock | 0.653 | 0.6979 | 0.65 | 0.65 | 21195.0 |
| 2024-07-22 | AACIW-DELISTED | Stock | 0.12 | 0.14728 | 0.12 | 0.1448 | 52174.0 |
| 2024-07-22 | AACT | Stock | 10.71 | 10.72 | 10.7 | 10.7 | 499523.0 |
| 2024-07-22 | AAGR-DELISTED | Stock | 0.16 | 0.1669 | 0.1584 | 0.162 | 2158001.0 |
| 2024-07-22 | AAL | Stock | 10.49 | 10.74 | 10.35 | 10.69 | 38603284.0 |
| 2024-07-22 | AAMC-DELISTED | Stock | 2.76 | 2.78 | 2.5 | 2.78 | 5390.0 |
| 2024-07-22 | AAME | Stock | 1.63 | 1.64 | 1.58 | 1.63 | 15277.0 |
| 2024-07-22 | AAMI | Stock | 24.9 | 24.97 | 24.6 | 24.94 | 109133.0 |
| 2024-07-22 | AAN-DELISTED | Stock | 9.95 | 9.99 | 9.95 | 9.97 | 702610.0 |
| 2024-07-22 | AAOI | Stock | 9.84 | 9.9 | 9.12 | 9.65 | 2104626.0 |
| 2024-07-22 | AAON | Stock | 86.9 | 89.15 | 86.44 | 89.05 | 278662.0 |
| 2024-07-22 | AAP | Stock | 59.68 | 60.04 | 58.77 | 59.75 | 1190774.0 |
| 2024-07-22 | AAT | Stock | 24.03 | 24.56 | 23.785 | 24.55 | 169138.0 |
| 2024-07-22 | AATC | Stock | 6.51 | 6.74 | 6.51 | 6.7 | 1400.0 |
| 2024-07-22 | AAUAF-DELISTED | Stock | 0.0501 | 0.0544 | 0.0501 | 0.0501 | 11786.0 |
| 2024-07-22 | AAXJ | Stock | 72.28 | 72.55 | 72.15 | 72.45 | 542675.0 |
| 2024-07-22 | AB | Stock | 34.06 | 34.41 | 33.7811 | 34.33 | 251245.0 |
| 2024-07-22 | ABAT | Stock | 1.04 | 1.06 | 1.0 | 1.02 | 588146.0 |
| 2024-07-22 | ABBV | Stock | 173.32 | 174.7299 | 172.0 | 173.61 | 3250322.0 |
| 2024-07-22 | ABCB | Stock | 58.41 | 60.46 | 58.41 | 60.0 | 724043.0 |
| 2024-07-22 | ABCL | Stock | 3.0 | 3.02 | 2.93 | 3.01 | 882772.0 |
| 2024-07-22 | ABEO | Stock | 5.11 | 5.33 | 4.97 | 5.0 | 170107.0 |
| 2024-07-22 | ABEV | Stock | 2.13 | 2.15 | 2.11 | 2.13 | 15081867.0 |
| 2024-07-22 | ABG | Stock | 246.36 | 252.01 | 243.515 | 251.93 | 141724.0 |
| 2024-07-22 | ABLLW | Stock | 0.73 | 0.95 | 0.73 | 0.85 | 158548.0 |
| 2024-07-22 | ABLV | Stock | 1.1 | 1.27 | 1.0915 | 1.2 | 8636.0 |
| 2024-07-22 | ABM | Stock | 53.83 | 54.48 | 53.01 | 54.42 | 296797.0 |
| 2024-07-22 | ABNB | Stock | 148.14 | 150.37 | 146.55 | 150.18 | 3669430.0 |
| 2024-07-22 | ABOS | Stock | 2.9 | 3.26 | 2.83 | 3.23 | 383443.0 |
| 2024-07-22 | ABR | Stock | 13.18 | 13.4097 | 13.05 | 13.39 | 3375813.0 |
| 2024-07-22 | ABR.D | Stock | 17.74 | 18.0 | 17.74 | 17.84 | 11802.0 |
| 2024-07-22 | ABR.E | Stock | 17.51 | 17.51 | 17.36 | 17.42 | 14963.0 |
| 2024-07-22 | ABR.F | Stock | 18.73 | 18.73 | 18.51 | 18.6 | 20671.0 |
| 2024-07-22 | ABSI | Stock | 4.0 | 4.11 | 3.76 | 4.1 | 1069257.0 |
| 2024-07-22 | ABT | Stock | 102.5 | 103.83 | 102.31 | 103.72 | 7098906.0 |
| 2024-07-22 | ABTC | Stock | 82.5 | 83.25 | 78.0 | 79.665 | 2329.2 |
| 2024-07-22 | ABTS | Stock | 7.203 | 7.875 | 7.14 | 7.3245 | 2195.0 |
| 2024-07-22 | ABUS | Stock | 3.7 | 3.82 | 3.69 | 3.81 | 902551.0 |
> showing 50 of 7,210 rows — these rows as CSV