PREVIEW / stock_daily / 2024-08-22
file: by_date/stock_daily/2024/2024-08-22.parquet size: 244 KB rows: 7,108 symbols: 783
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-22 | AAPL | Stock | 227.79 | 228.34 | 223.9 | 224.53 | 38207152.0 |
| 2024-08-22 | MSFT | Stock | 424.36 | 426.7899 | 414.61 | 415.55 | 18313365.0 |
| 2024-08-22 | NVDA | Stock | 130.02 | 130.75 | 123.1 | 123.74 | 362217682.0 |
| 2024-08-22 | AMZN | Stock | 181.38 | 181.47 | 175.68 | 176.13 | 30655815.0 |
| 2024-08-22 | GOOGL | Stock | 167.26 | 167.59 | 163.31 | 163.8 | 22493275.0 |
| 2024-08-22 | META | Stock | 537.0 | 544.23 | 528.59 | 531.93 | 14653988.0 |
| 2024-08-22 | TSLA | Stock | 223.82 | 224.8 | 210.32 | 210.66 | 76372948.0 |
| 2024-08-22 | TLT | Stock | 98.23 | 98.3 | 97.43 | 97.75 | 33453848.0 |
| 2024-08-22 | ES | Stock | 66.65 | 67.25 | 66.62 | 67.14 | 2443417.0 |
| 2024-08-22 | CL | Stock | 103.85 | 104.05 | 103.48 | 103.95 | 2441281.0 |
| 2024-08-22 | A | Stock | 145.375 | 145.45 | 138.15 | 140.22 | 2599010.0 |
| 2024-08-22 | AA | Stock | 33.25 | 33.4499 | 32.365 | 32.52 | 2865162.0 |
| 2024-08-22 | AACG | Stock | 0.625 | 0.659 | 0.55 | 0.60395 | 77041.0 |
| 2024-08-22 | AACT | Stock | 10.75 | 10.78 | 10.75 | 10.77 | 3819.0 |
| 2024-08-22 | AAGR-DELISTED | Stock | 0.136 | 0.14 | 0.1325 | 0.1351 | 471052.0 |
| 2024-08-22 | AAGRW-DELISTED | Stock | 0.0095 | 0.0095 | 0.0095 | 0.0095 | 309.0 |
| 2024-08-22 | AAL | Stock | 10.41 | 10.54 | 10.13 | 10.14 | 25546027.0 |
| 2024-08-22 | AAMC-DELISTED | Stock | 2.44 | 2.65 | 2.35 | 2.37 | 9238.0 |
| 2024-08-22 | AAME | Stock | 1.56 | 1.56 | 1.5301 | 1.55 | 927.0 |
| 2024-08-22 | AAMI | Stock | 23.18 | 23.29 | 23.12 | 23.2 | 58171.0 |
| 2024-08-22 | AAN-DELISTED | Stock | 10.08 | 10.1 | 10.07 | 10.07 | 599108.0 |
| 2024-08-22 | AAOI | Stock | 8.93 | 9.52 | 8.8 | 9.03 | 3010495.0 |
| 2024-08-22 | AAON | Stock | 92.16 | 93.09 | 91.11 | 93.0 | 349123.0 |
| 2024-08-22 | AAP | Stock | 48.4 | 53.89 | 48.285 | 51.1 | 13733423.0 |
| 2024-08-22 | AAT | Stock | 26.12 | 26.175 | 25.88 | 26.05 | 160152.0 |
| 2024-08-22 | AATC | Stock | 7.21 | 7.21 | 7.17 | 7.2 | 2912.0 |
| 2024-08-22 | AAUAF-DELISTED | Stock | 0.053 | 0.05713 | 0.0473 | 0.05588 | 97421.0 |
| 2024-08-22 | AAXJ | Stock | 73.19 | 73.19 | 72.31 | 72.46 | 157554.0 |
| 2024-08-22 | AB | Stock | 34.94 | 35.1 | 34.67 | 34.75 | 197172.0 |
| 2024-08-22 | ABAT | Stock | 1.05 | 1.07 | 1.03 | 1.04 | 101133.0 |
| 2024-08-22 | ABBV | Stock | 197.005 | 197.54 | 195.35 | 196.37 | 3014856.0 |
| 2024-08-22 | ABCB | Stock | 58.56 | 58.93 | 57.96 | 58.5 | 209593.0 |
| 2024-08-22 | ABCL | Stock | 2.64 | 2.6599 | 2.48 | 2.51 | 2455812.0 |
| 2024-08-22 | ABEO | Stock | 5.26 | 5.26 | 5.08 | 5.12 | 175648.0 |
| 2024-08-22 | ABEV | Stock | 2.34 | 2.36 | 2.32 | 2.33 | 30854395.0 |
| 2024-08-22 | ABG | Stock | 235.04 | 235.04 | 229.79 | 230.89 | 99099.0 |
| 2024-08-22 | ABLLW | Stock | 1.49 | 1.49 | 1.4 | 1.4 | 19505.0 |
| 2024-08-22 | ABLV | Stock | 1.61 | 1.87 | 1.61 | 1.79 | 22027.0 |
| 2024-08-22 | ABM | Stock | 54.68 | 54.8 | 54.39 | 54.5 | 183140.0 |
| 2024-08-22 | ABNB | Stock | 117.68 | 118.395 | 115.3 | 115.45 | 4460865.0 |
| 2024-08-22 | ABOS | Stock | 2.87 | 2.8899 | 2.7686 | 2.81 | 109398.0 |
| 2024-08-22 | ABR | Stock | 13.15 | 13.24 | 13.1 | 13.16 | 1948646.0 |
| 2024-08-22 | ABR.D | Stock | 17.6 | 17.77 | 17.6 | 17.66 | 17269.0 |
| 2024-08-22 | ABR.E | Stock | 17.4 | 17.5 | 17.4 | 17.5 | 4328.0 |
| 2024-08-22 | ABR.F | Stock | 18.2 | 18.2 | 18.09 | 18.12 | 15418.0 |
| 2024-08-22 | ABSI | Stock | 4.4 | 4.49 | 4.21 | 4.23 | 768198.0 |
| 2024-08-22 | ABT | Stock | 111.79 | 112.15 | 111.05 | 112.1 | 2936174.0 |
| 2024-08-22 | ABTC | Stock | 58.8 | 60.0 | 55.5 | 55.575 | 1463.1333333333332 |
| 2024-08-22 | ABTS | Stock | 7.965 | 8.475 | 6.975 | 7.518 | 19235.0 |
| 2024-08-22 | ABUS | Stock | 3.92 | 3.92 | 3.78 | 3.81 | 660748.0 |
> showing 50 of 7,108 rows — these rows as CSV