PREVIEW / stock_daily / 2024-08-05
file: by_date/stock_daily/2024/2024-08-05.parquet size: 245 KB rows: 7,283 symbols: 895
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-05 | AAPL | Stock | 199.09 | 213.5 | 196.0 | 209.27 | 119223277.0 |
| 2024-08-05 | MSFT | Stock | 389.17 | 401.04 | 385.58 | 395.15 | 38760913.0 |
| 2024-08-05 | NVDA | Stock | 92.06 | 103.41 | 90.69 | 100.45 | 549531095.0 |
| 2024-08-05 | AMZN | Stock | 154.21 | 162.96 | 151.61 | 161.02 | 82948655.0 |
| 2024-08-05 | GOOGL | Stock | 155.5 | 164.43 | 154.93 | 159.25 | 53630673.0 |
| 2024-08-05 | META | Stock | 451.345 | 483.48 | 450.8 | 475.73 | 21184122.0 |
| 2024-08-05 | TSLA | Stock | 185.22 | 203.8799 | 182.0 | 198.88 | 99633750.0 |
| 2024-08-05 | TLT | Stock | 99.69 | 99.935 | 97.9 | 98.8 | 90686310.0 |
| 2024-08-05 | ES | Stock | 67.18 | 67.505 | 64.95 | 65.02 | 2460511.0 |
| 2024-08-05 | CL | Stock | 102.99 | 104.15 | 99.95 | 100.97 | 5863009.0 |
| 2024-08-05 | A | Stock | 136.55 | 136.82 | 133.06 | 134.7 | 1859815.0 |
| 2024-08-05 | AA | Stock | 27.98 | 28.54 | 27.12 | 28.44 | 13095304.0 |
| 2024-08-05 | AACG | Stock | 0.61 | 0.6636 | 0.61 | 0.65 | 4572.0 |
| 2024-08-05 | AACIU | Stock | 10.31 | 13.97 | 10.01 | 12.7 | 16922.0 |
| 2024-08-05 | AACT | Stock | 10.73 | 10.74 | 10.73 | 10.74 | 81276.0 |
| 2024-08-05 | AAGR-DELISTED | Stock | 0.1328 | 0.1345 | 0.121 | 0.1242 | 384460.0 |
| 2024-08-05 | AAGRW-DELISTED | Stock | 0.0097 | 0.0097 | 0.0097 | 0.0097 | 56123.0 |
| 2024-08-05 | AAL | Stock | 9.1 | 9.59 | 9.07 | 9.28 | 44377725.0 |
| 2024-08-05 | AAMC-DELISTED | Stock | 3.39 | 3.39 | 3.0001 | 3.27 | 11524.0 |
| 2024-08-05 | AAME | Stock | 1.561 | 1.561 | 1.561 | 1.561 | 361.0 |
| 2024-08-05 | AAMI | Stock | 22.5 | 22.685 | 22.05 | 22.36 | 223644.0 |
| 2024-08-05 | AAN-DELISTED | Stock | 9.96 | 10.02 | 9.95 | 9.97 | 1220731.0 |
| 2024-08-05 | AAOI | Stock | 6.89 | 7.32 | 6.7 | 6.97 | 1952728.0 |
| 2024-08-05 | AAON | Stock | 82.3 | 86.28 | 79.65 | 85.47 | 725270.0 |
| 2024-08-05 | AAP | Stock | 58.35 | 59.575 | 57.02 | 58.86 | 1440780.0 |
| 2024-08-05 | AAT | Stock | 24.77 | 25.19 | 24.31 | 24.51 | 251241.0 |
| 2024-08-05 | AATC | Stock | 6.49 | 7.05 | 6.483 | 7.0 | 14969.0 |
| 2024-08-05 | AAUAF-DELISTED | Stock | 0.05 | 0.051 | 0.05 | 0.05 | 67320.0 |
| 2024-08-05 | AAXJ | Stock | 66.23 | 68.48 | 66.23 | 68.09 | 698329.0 |
| 2024-08-05 | AB | Stock | 32.42 | 32.74 | 30.57 | 31.87 | 877993.0 |
| 2024-08-05 | ABAT | Stock | 0.9308 | 1.02 | 0.75 | 1.02 | 458971.0 |
| 2024-08-05 | ABBV | Stock | 187.45 | 189.29 | 183.04 | 184.36 | 6227121.0 |
| 2024-08-05 | ABCB | Stock | 53.65 | 55.44 | 52.81 | 55.13 | 431839.0 |
| 2024-08-05 | ABCL | Stock | 2.69 | 2.81 | 2.65 | 2.76 | 2184396.0 |
| 2024-08-05 | ABEO | Stock | 4.4 | 4.7 | 4.3 | 4.6 | 481790.0 |
| 2024-08-05 | ABEV | Stock | 2.02 | 2.1 | 2.02 | 2.09 | 25180581.0 |
| 2024-08-05 | ABG | Stock | 220.82 | 235.25 | 220.0 | 230.17 | 285043.0 |
| 2024-08-05 | ABLLW | Stock | 0.95 | 1.0 | 0.89 | 0.93 | 79526.0 |
| 2024-08-05 | ABLV | Stock | 1.06 | 1.155 | 1.06 | 1.09 | 4496.0 |
| 2024-08-05 | ABLVW | Stock | 0.0222 | 0.0222 | 0.0222 | 0.0222 | 707.0 |
| 2024-08-05 | ABM | Stock | 53.01 | 53.31 | 52.25 | 52.76 | 316972.0 |
| 2024-08-05 | ABNB | Stock | 123.77 | 125.95 | 122.06 | 125.31 | 7266440.0 |
| 2024-08-05 | ABOS | Stock | 2.63 | 2.835 | 2.6115 | 2.83 | 340460.0 |
| 2024-08-05 | ABR | Stock | 12.9 | 13.36 | 12.65 | 13.28 | 5493227.0 |
| 2024-08-05 | ABR.D | Stock | 17.25 | 17.5 | 16.99 | 17.03 | 54438.0 |
| 2024-08-05 | ABR.E | Stock | 17.17 | 17.44 | 17.095 | 17.41 | 4162.0 |
| 2024-08-05 | ABR.F | Stock | 17.86 | 18.68 | 17.86 | 18.46 | 23803.0 |
| 2024-08-05 | ABSI | Stock | 3.46 | 3.625 | 3.34 | 3.58 | 1343106.0 |
| 2024-08-05 | ABT | Stock | 111.34 | 112.0 | 108.37 | 108.63 | 6830176.0 |
| 2024-08-05 | ABTC | Stock | 44.550000000000004 | 50.702999999999996 | 36.862500000000004 | 42.825 | 5592.6 |
> showing 50 of 7,283 rows — these rows as CSV