PREVIEW / stock_daily / 2024-08-08
file: by_date/stock_daily/2024/2024-08-08.parquet size: 245 KB rows: 7,177 symbols: 858
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-08 | AAPL | Stock | 213.11 | 214.2 | 208.83 | 213.31 | 45768054.0 |
| 2024-08-08 | MSFT | Stock | 402.44 | 405.86 | 399.9407 | 402.69 | 18588222.0 |
| 2024-08-08 | NVDA | Stock | 102.0 | 105.5 | 97.52 | 104.97 | 385184329.0 |
| 2024-08-08 | AMZN | Stock | 165.165 | 166.6899 | 162.55 | 165.8 | 43619094.0 |
| 2024-08-08 | GOOGL | Stock | 160.51 | 163.69 | 160.21 | 162.03 | 25578839.0 |
| 2024-08-08 | META | Stock | 497.5 | 509.96 | 494.72 | 509.63 | 15869487.0 |
| 2024-08-08 | TSLA | Stock | 195.7 | 200.7 | 192.04 | 198.84 | 64056131.0 |
| 2024-08-08 | TLT | Stock | 95.115 | 95.4 | 94.84 | 95.32 | 37815770.0 |
| 2024-08-08 | ES | Stock | 64.68 | 65.565 | 64.5 | 64.85 | 2738644.0 |
| 2024-08-08 | CL | Stock | 101.61 | 103.11 | 101.26 | 102.71 | 3147593.0 |
| 2024-08-08 | A | Stock | 134.15 | 137.22 | 133.78 | 136.76 | 948395.0 |
| 2024-08-08 | AA | Stock | 29.61 | 30.66 | 29.55 | 30.63 | 5861287.0 |
| 2024-08-08 | AACG | Stock | 0.6 | 0.6391 | 0.6 | 0.6365 | 28066.0 |
| 2024-08-08 | AACIU | Stock | 11.79 | 15.0 | 11.08 | 11.98 | 15269.0 |
| 2024-08-08 | AACT | Stock | 10.75 | 10.76 | 10.73 | 10.73 | 30426.0 |
| 2024-08-08 | AAGR-DELISTED | Stock | 0.1381 | 0.15 | 0.1372 | 0.139 | 289720.0 |
| 2024-08-08 | AAGRW-DELISTED | Stock | 0.011 | 0.0112 | 0.011 | 0.0112 | 2102.0 |
| 2024-08-08 | AAL | Stock | 9.35 | 9.91 | 9.35 | 9.89 | 34546421.0 |
| 2024-08-08 | AAMC-DELISTED | Stock | 2.83 | 3.15 | 2.762 | 3.08 | 8812.0 |
| 2024-08-08 | AAME | Stock | 1.5301 | 1.6 | 1.5101 | 1.52 | 2592.0 |
| 2024-08-08 | AAMI | Stock | 21.8 | 22.45 | 21.8 | 21.97 | 118351.0 |
| 2024-08-08 | AAN-DELISTED | Stock | 10.04 | 10.04 | 10.0 | 10.02 | 210607.0 |
| 2024-08-08 | AAOI | Stock | 7.05 | 8.57 | 7.04 | 8.57 | 2645674.0 |
| 2024-08-08 | AAON | Stock | 87.14 | 87.92 | 85.46 | 86.07 | 467319.0 |
| 2024-08-08 | AAP | Stock | 59.1 | 61.1 | 59.0 | 60.92 | 1217412.0 |
| 2024-08-08 | AAT | Stock | 25.4 | 25.67 | 25.12 | 25.22 | 237363.0 |
| 2024-08-08 | AATC | Stock | 7.113 | 7.29 | 6.61 | 6.7 | 16622.0 |
| 2024-08-08 | AAUAF-DELISTED | Stock | 0.052 | 0.0553 | 0.05 | 0.0553 | 56080.0 |
| 2024-08-08 | AAXJ | Stock | 69.715 | 70.395 | 69.47 | 70.35 | 289334.0 |
| 2024-08-08 | AB | Stock | 33.2 | 33.32 | 32.595 | 33.08 | 244795.0 |
| 2024-08-08 | ABAT | Stock | 1.0 | 1.02 | 0.98 | 1.0 | 136975.0 |
| 2024-08-08 | ABBV | Stock | 186.92 | 190.71 | 186.92 | 190.4 | 5643626.0 |
| 2024-08-08 | ABCB | Stock | 56.17 | 56.85 | 55.65 | 56.72 | 191862.0 |
| 2024-08-08 | ABCL | Stock | 2.68 | 2.9 | 2.66 | 2.77 | 1416976.0 |
| 2024-08-08 | ABEO | Stock | 4.41 | 4.58 | 4.41 | 4.47 | 204781.0 |
| 2024-08-08 | ABEV | Stock | 2.23 | 2.27 | 2.21 | 2.25 | 28042115.0 |
| 2024-08-08 | ABG | Stock | 230.03 | 234.79 | 230.03 | 234.3 | 80768.0 |
| 2024-08-08 | ABLLW | Stock | 1.1 | 1.29 | 1.1 | 1.2 | 72097.0 |
| 2024-08-08 | ABLV | Stock | 1.21 | 1.25 | 1.12 | 1.12 | 70836.0 |
| 2024-08-08 | ABM | Stock | 52.2 | 52.815 | 52.08 | 52.41 | 210128.0 |
| 2024-08-08 | ABNB | Stock | 113.98 | 116.43 | 112.42 | 114.64 | 7990356.0 |
| 2024-08-08 | ABOS | Stock | 2.7 | 2.7699 | 2.65 | 2.74 | 130877.0 |
| 2024-08-08 | ABR | Stock | 13.49 | 13.605 | 13.275 | 13.51 | 1971763.0 |
| 2024-08-08 | ABR.D | Stock | 17.605 | 17.83 | 17.48 | 17.52 | 43133.0 |
| 2024-08-08 | ABR.E | Stock | 17.66 | 17.95 | 17.64 | 17.92 | 6205.0 |
| 2024-08-08 | ABR.F | Stock | 18.83 | 18.93 | 18.58 | 18.9 | 21794.0 |
| 2024-08-08 | ABSI | Stock | 3.71 | 3.83 | 3.66 | 3.77 | 682492.0 |
| 2024-08-08 | ABT | Stock | 109.95 | 111.22 | 109.22 | 109.76 | 4796208.0 |
| 2024-08-08 | ABTC | Stock | 47.5725 | 56.25 | 47.5725 | 52.32 | 3070.733333333333 |
| 2024-08-08 | ABTS | Stock | 7.8 | 8.55 | 7.8 | 8.1 | 272.0 |
> showing 50 of 7,177 rows — these rows as CSV