PREVIEW / stock_daily / 2024-07-30
file: by_date/stock_daily/2024/2024-07-30.parquet size: 245 KB rows: 7,189 symbols: 879
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-30 | AAPL | Stock | 219.19 | 220.325 | 216.12 | 218.8 | 40835470.0 |
| 2024-07-30 | MSFT | Stock | 427.72 | 429.05 | 417.36 | 422.92 | 29990021.0 |
| 2024-07-30 | NVDA | Stock | 111.52 | 111.99 | 102.54 | 103.73 | 475035417.0 |
| 2024-07-30 | AMZN | Stock | 184.72 | 185.86 | 179.38 | 181.71 | 37017786.0 |
| 2024-07-30 | GOOGL | Stock | 170.24 | 171.2299 | 168.44 | 170.29 | 18959686.0 |
| 2024-07-30 | META | Stock | 467.0 | 472.73 | 456.7 | 463.19 | 10830302.0 |
| 2024-07-30 | TSLA | Stock | 232.25 | 232.41 | 220.0 | 222.62 | 99977631.0 |
| 2024-07-30 | TLT | Stock | 93.75 | 94.05 | 93.3 | 93.85 | 28169820.0 |
| 2024-07-30 | ES | Stock | 64.81 | 66.07 | 64.63 | 65.96 | 1985575.0 |
| 2024-07-30 | CL | Stock | 98.95 | 100.745 | 98.44 | 100.49 | 5110495.0 |
| 2024-07-30 | A | Stock | 138.04 | 139.73 | 137.11 | 139.49 | 1388116.0 |
| 2024-07-30 | AA | Stock | 32.55 | 32.67 | 31.16 | 31.77 | 8661090.0 |
| 2024-07-30 | AACG | Stock | 0.6899 | 0.6899 | 0.65 | 0.6524 | 10577.0 |
| 2024-07-30 | AACIU | Stock | 11.0 | 11.0 | 10.99 | 10.99 | 394.0 |
| 2024-07-30 | AACIW-DELISTED | Stock | 0.1109 | 0.1109 | 0.1109 | 0.1109 | 2100.0 |
| 2024-07-30 | AACT | Stock | 10.75 | 10.75 | 10.73 | 10.73 | 49707.0 |
| 2024-07-30 | AAGR-DELISTED | Stock | 0.1644 | 0.1644 | 0.15579 | 0.159 | 424341.0 |
| 2024-07-30 | AAL | Stock | 10.46 | 10.93 | 10.46 | 10.76 | 52679076.0 |
| 2024-07-30 | AAMC-DELISTED | Stock | 2.84 | 2.85 | 2.55 | 2.55 | 1634.0 |
| 2024-07-30 | AAME | Stock | 1.5301 | 1.62 | 1.52 | 1.52 | 1668.0 |
| 2024-07-30 | AAMI | Stock | 25.97 | 26.385 | 25.63 | 25.79 | 250113.0 |
| 2024-07-30 | AAN-DELISTED | Stock | 9.98 | 10.02 | 9.97 | 10.02 | 933996.0 |
| 2024-07-30 | AAOI | Stock | 8.37 | 8.53 | 7.985 | 8.12 | 2280200.0 |
| 2024-07-30 | AAON | Stock | 88.09 | 89.34 | 85.91 | 86.57 | 567530.0 |
| 2024-07-30 | AAP | Stock | 61.06 | 63.3 | 60.7775 | 63.09 | 1324703.0 |
| 2024-07-30 | AAT | Stock | 25.03 | 25.87 | 24.72 | 25.82 | 239196.0 |
| 2024-07-30 | AATC | Stock | 6.83 | 7.0 | 6.75 | 7.0 | 12406.0 |
| 2024-07-30 | AAUAF-DELISTED | Stock | 0.0501 | 0.056 | 0.05 | 0.052 | 22188.0 |
| 2024-07-30 | AAXJ | Stock | 71.01 | 71.04 | 70.4 | 70.62 | 429406.0 |
| 2024-07-30 | AB | Stock | 34.82 | 35.46 | 34.3 | 34.74 | 437101.0 |
| 2024-07-30 | ABAT | Stock | 1.0 | 1.02 | 0.98 | 1.01 | 270013.0 |
| 2024-07-30 | ABBV | Stock | 183.59 | 187.7 | 182.6 | 186.78 | 5763511.0 |
| 2024-07-30 | ABCB | Stock | 61.4 | 61.755 | 60.69 | 60.98 | 256345.0 |
| 2024-07-30 | ABCL | Stock | 3.21 | 3.28 | 3.175 | 3.23 | 550108.0 |
| 2024-07-30 | ABEO | Stock | 4.98 | 5.005 | 4.71 | 4.72 | 318486.0 |
| 2024-07-30 | ABEV | Stock | 2.09 | 2.1 | 2.08 | 2.09 | 13078129.0 |
| 2024-07-30 | ABG | Stock | 256.38 | 258.68 | 254.68 | 257.19 | 127181.0 |
| 2024-07-30 | ABLLW | Stock | 0.99 | 1.0 | 0.94 | 0.99 | 2913.0 |
| 2024-07-30 | ABLV | Stock | 1.22 | 1.22 | 1.17 | 1.1701 | 24850.0 |
| 2024-07-30 | ABLVW | Stock | 0.0434 | 0.0494 | 0.04 | 0.0406 | 10468.0 |
| 2024-07-30 | ABM | Stock | 55.45 | 55.94 | 54.97 | 55.67 | 410661.0 |
| 2024-07-30 | ABNB | Stock | 140.65 | 140.99 | 137.9 | 138.99 | 2936292.0 |
| 2024-07-30 | ABOS | Stock | 3.29 | 3.44 | 3.22 | 3.42 | 401912.0 |
| 2024-07-30 | ABR | Stock | 13.64 | 13.6599 | 13.525 | 13.59 | 1694826.0 |
| 2024-07-30 | ABR.D | Stock | 17.27 | 17.44 | 17.07 | 17.21 | 45720.0 |
| 2024-07-30 | ABR.E | Stock | 17.48 | 17.83 | 17.18 | 17.38 | 13005.0 |
| 2024-07-30 | ABR.F | Stock | 18.9 | 18.9 | 18.75 | 18.85 | 7428.0 |
| 2024-07-30 | ABSI | Stock | 4.46 | 4.59 | 4.175 | 4.23 | 634785.0 |
| 2024-07-30 | ABT | Stock | 104.76 | 105.675 | 102.78 | 105.32 | 8626356.0 |
| 2024-07-30 | ABTC | Stock | 69.75 | 72.0 | 68.925 | 69.54 | 562.2 |
> showing 50 of 7,189 rows — these rows as CSV