PREVIEW / stock_daily / 2024-07-03
file: by_date/stock_daily/2024/2024-07-03.parquet size: 227 KB rows: 7,054 symbols: 866
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-03 | AAPL | Stock | 219.96 | 220.7299 | 219.61 | 220.28 | 3643781.0 |
| 2024-07-03 | MSFT | Stock | 458.19 | 461.02 | 457.88 | 460.77 | 9932800.0 |
| 2024-07-03 | NVDA | Stock | 121.66 | 128.28 | 121.36 | 128.28 | 215749000.0 |
| 2024-07-03 | AMZN | Stock | 199.91 | 200.029 | 196.7601 | 197.59 | 31028411.0 |
| 2024-07-03 | GOOGL | Stock | 184.85 | 186.09 | 184.0 | 185.82 | 10242126.0 |
| 2024-07-03 | META | Stock | 506.37 | 511.28 | 506.02 | 509.96 | 6005600.0 |
| 2024-07-03 | TSLA | Stock | 234.56 | 248.35 | 234.25 | 246.39 | 166561500.0 |
| 2024-07-03 | TLT | Stock | 91.17 | 91.89 | 91.085 | 91.8 | 35563313.0 |
| 2024-07-03 | ES | Stock | 56.78 | 57.84 | 56.68 | 57.31 | 1105600.0 |
| 2024-07-03 | CL | Stock | 95.73 | 96.22 | 95.52 | 95.89 | 2114700.0 |
| 2024-07-03 | A | Stock | 126.12 | 127.61 | 125.83 | 126.13 | 1288206.0 |
| 2024-07-03 | AA | Stock | 39.89 | 42.22 | 41.58 | 42.06 | 438854.0 |
| 2024-07-03 | AAGR-DELISTED | Stock | 0.2 | 0.2008 | 0.1727 | 0.1887 | 1050992.0 |
| 2024-07-03 | AAGRW-DELISTED | Stock | 0.0171 | 0.0171 | 0.0171 | 0.0171 | 263.0 |
| 2024-07-03 | AAL | Stock | 11.18 | 11.18 | 11.105 | 11.115 | 703298.0 |
| 2024-07-03 | AAMI | Stock | 22.78 | 23.03 | 22.72 | 22.76 | 91374.0 |
| 2024-07-03 | AAN-DELISTED | Stock | 9.96 | 9.97 | 9.95 | 9.95 | 28519.0 |
| 2024-07-03 | AAOI | Stock | 7.9 | 7.96 | 7.8 | 7.83 | 25451.0 |
| 2024-07-03 | AAON | Stock | 85.74 | 85.84 | 85.52 | 85.805 | 6820.0 |
| 2024-07-03 | AAP | Stock | 59.26 | 60.38 | 60.19 | 60.38 | 9996.0 |
| 2024-07-03 | AAT | Stock | 22.47 | 22.365 | 22.3 | 22.3 | 2320.0 |
| 2024-07-03 | AATC | Stock | 6.354 | 6.354 | 6.35 | 6.35 | 1823.0 |
| 2024-07-03 | AAUAF-DELISTED | Stock | 0.0583 | 0.06006 | 0.053 | 0.056 | 156364.0 |
| 2024-07-03 | AAXJ | Stock | 72.99 | 73.615 | 72.99 | 73.56 | 159832.0 |
| 2024-07-03 | AB | Stock | 33.4 | 33.79 | 33.51 | 33.705 | 19648.0 |
| 2024-07-03 | ABAT | Stock | 1.07 | 1.09 | 1.02 | 1.035 | 772742.0 |
| 2024-07-03 | ABBV | Stock | 168.63 | 166.77 | 165.87 | 166.715 | 150540.0 |
| 2024-07-03 | ABCB | Stock | 50.65 | 50.65 | 50.26 | 50.345 | 7967.0 |
| 2024-07-03 | ABCL | Stock | 2.79 | 2.79 | 2.74 | 2.759 | 57606.0 |
| 2024-07-03 | ABEO | Stock | 4.25 | 4.34 | 4.22 | 4.22 | 47352.0 |
| 2024-07-03 | ABEV | Stock | 2.04 | 2.075 | 2.06 | 2.065 | 1176661.0 |
| 2024-07-03 | ABG | Stock | 229.09 | 229.17 | 226.68 | 226.68 | 4236.0 |
| 2024-07-03 | ABLLW | Stock | 0.66 | 0.67 | 0.64 | 0.64 | 10422.0 |
| 2024-07-03 | ABLVW | Stock | 0.0257 | 0.0257 | 0.0257 | 0.0257 | 100.0 |
| 2024-07-03 | ABM | Stock | 50.33 | 50.21 | 50.11 | 50.21 | 8456.0 |
| 2024-07-03 | ABNB | Stock | 153.81 | 154.33 | 153.43 | 153.99 | 156457.0 |
| 2024-07-03 | ABOS | Stock | 2.29 | 2.29 | 2.26 | 2.26 | 8246.0 |
| 2024-07-03 | ABR | Stock | 14.61 | 14.65 | 14.565 | 14.615 | 123120.0 |
| 2024-07-03 | ABR.D | Stock | 18.9399 | 18.94 | 18.83 | 18.9 | 8197.0 |
| 2024-07-03 | ABR.E | Stock | 18.38 | 18.4899 | 18.38 | 18.48 | 3385.0 |
| 2024-07-03 | ABR.F | Stock | 20.05 | 20.11 | 19.9931 | 20.1 | 5572.0 |
| 2024-07-03 | ABSI | Stock | 3.31 | 3.515 | 3.234 | 3.25 | 440226.0 |
| 2024-07-03 | ABT | Stock | 103.36 | 103.64 | 103.03 | 103.345 | 178480.0 |
| 2024-07-03 | ABTC | Stock | 92.25 | 97.5 | 90.0 | 93.0 | 1636.0 |
| 2024-07-03 | ABTS | Stock | 8.4 | 8.4 | 8.4 | 8.4 | 21.1 |
| 2024-07-03 | ABUS | Stock | 3.15 | 3.17 | 3.135 | 3.165 | 55563.0 |
| 2024-07-03 | ABVC | Stock | 0.71 | 0.74 | 0.71 | 0.71 | 4433.0 |
| 2024-07-03 | ABVE | Stock | 3.57 | 3.705 | 2.9 | 2.99 | 182495.0 |
| 2024-07-03 | ABVEW | Stock | 0.1 | 0.1 | 0.0601 | 0.0717 | 60766.0 |
| 2024-07-03 | ABVX | Stock | 13.535 | 13.535 | 13.03 | 13.07 | 8262.0 |
> showing 50 of 7,054 rows — these rows as CSV