PREVIEW / stock_daily / 2024-08-29
file: by_date/stock_daily/2024/2024-08-29.parquet size: 245 KB rows: 7,090 symbols: 759
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-29 | AAPL | Stock | 230.1 | 232.92 | 228.88 | 229.79 | 50986919.0 |
| 2024-08-29 | MSFT | Stock | 414.94 | 422.05 | 410.6 | 413.12 | 15684329.0 |
| 2024-08-29 | NVDA | Stock | 121.355 | 124.43 | 116.71 | 117.59 | 448218541.0 |
| 2024-08-29 | AMZN | Stock | 173.22 | 174.29 | 170.81 | 172.12 | 25782421.0 |
| 2024-08-29 | GOOGL | Stock | 164.31 | 165.97 | 160.25 | 161.78 | 19699767.0 |
| 2024-08-29 | META | Stock | 519.05 | 527.2 | 515.6789 | 518.22 | 7940210.0 |
| 2024-08-29 | TSLA | Stock | 209.8 | 214.89 | 205.97 | 206.28 | 62125104.0 |
| 2024-08-29 | TLT | Stock | 97.37 | 97.64 | 97.125 | 97.53 | 24988243.0 |
| 2024-08-29 | ES | Stock | 67.03 | 67.29 | 66.08 | 66.66 | 1029738.0 |
| 2024-08-29 | CL | Stock | 105.8 | 106.1 | 105.28 | 105.81 | 2511391.0 |
| 2024-08-29 | A | Stock | 142.07 | 143.44 | 141.11 | 142.53 | 1546553.0 |
| 2024-08-29 | AA | Stock | 32.21 | 32.775 | 31.7 | 32.47 | 4658529.0 |
| 2024-08-29 | AACG | Stock | 0.6 | 0.6278 | 0.5977 | 0.5977 | 3381.0 |
| 2024-08-29 | AACT | Stock | 10.76 | 10.77 | 10.75 | 10.75 | 315398.0 |
| 2024-08-29 | AAGR-DELISTED | Stock | 0.131 | 0.136 | 0.128 | 0.1352 | 71196.0 |
| 2024-08-29 | AAL | Stock | 10.24 | 10.51 | 10.21 | 10.39 | 22055090.0 |
| 2024-08-29 | AAMC-DELISTED | Stock | 1.2213 | 1.34 | 1.2213 | 1.271 | 26122.0 |
| 2024-08-29 | AAME | Stock | 1.5891 | 1.5891 | 1.56 | 1.56 | 1053.0 |
| 2024-08-29 | AAMI | Stock | 23.65 | 24.25 | 23.5 | 24.17 | 206438.0 |
| 2024-08-29 | AAN-DELISTED | Stock | 10.1 | 10.105 | 10.09 | 10.09 | 236282.0 |
| 2024-08-29 | AAOI | Stock | 9.2 | 10.585 | 9.13 | 10.3 | 3743224.0 |
| 2024-08-29 | AAON | Stock | 93.11 | 95.12 | 92.28 | 93.7 | 312927.0 |
| 2024-08-29 | AAP | Stock | 46.75 | 46.85 | 45.795 | 46.15 | 2625133.0 |
| 2024-08-29 | AAT | Stock | 27.14 | 27.21 | 26.74 | 27.07 | 261432.0 |
| 2024-08-29 | AATC | Stock | 7.49 | 7.7 | 7.39 | 7.6 | 6897.0 |
| 2024-08-29 | AAUAF-DELISTED | Stock | 0.0422 | 0.05 | 0.037 | 0.04005 | 240498.0 |
| 2024-08-29 | AAXJ | Stock | 72.87 | 73.17 | 72.75 | 72.78 | 295294.0 |
| 2024-08-29 | AB | Stock | 34.52 | 34.7092 | 34.14 | 34.24 | 183122.0 |
| 2024-08-29 | ABAT | Stock | 1.09 | 1.13 | 1.08 | 1.09 | 168965.0 |
| 2024-08-29 | ABBV | Stock | 196.0 | 196.44 | 193.85 | 195.18 | 4421786.0 |
| 2024-08-29 | ABCB | Stock | 61.5 | 61.5 | 60.47 | 60.63 | 314641.0 |
| 2024-08-29 | ABCL | Stock | 2.55 | 2.66 | 2.53 | 2.53 | 2396903.0 |
| 2024-08-29 | ABEO | Stock | 5.6 | 5.84 | 5.54 | 5.56 | 239322.0 |
| 2024-08-29 | ABEV | Stock | 2.28 | 2.31 | 2.27 | 2.28 | 13035006.0 |
| 2024-08-29 | ABG | Stock | 243.85 | 243.85 | 239.47 | 242.2 | 151228.0 |
| 2024-08-29 | ABLLW | Stock | 1.4 | 1.4 | 1.3101 | 1.35 | 21940.0 |
| 2024-08-29 | ABLV | Stock | 1.62 | 1.68 | 1.62 | 1.68 | 454.0 |
| 2024-08-29 | ABLVW | Stock | 0.04 | 0.04 | 0.04 | 0.04 | 100.0 |
| 2024-08-29 | ABM | Stock | 56.27 | 56.78 | 55.765 | 56.22 | 299501.0 |
| 2024-08-29 | ABNB | Stock | 118.17 | 119.38 | 116.42 | 116.6 | 3300654.0 |
| 2024-08-29 | ABOS | Stock | 2.8 | 2.92 | 2.76 | 2.81 | 127437.0 |
| 2024-08-29 | ABR | Stock | 13.7 | 13.85 | 13.61 | 13.68 | 2821012.0 |
| 2024-08-29 | ABR.D | Stock | 17.75 | 17.7893 | 17.69 | 17.69 | 9231.0 |
| 2024-08-29 | ABR.E | Stock | 17.5013 | 17.85 | 17.45 | 17.52 | 11758.0 |
| 2024-08-29 | ABR.F | Stock | 18.5 | 18.6101 | 18.4 | 18.5 | 25636.0 |
| 2024-08-29 | ABSI | Stock | 4.47 | 4.575 | 4.285 | 4.3 | 889194.0 |
| 2024-08-29 | ABT | Stock | 113.295 | 113.5 | 112.52 | 112.76 | 3221310.0 |
| 2024-08-29 | ABTC | Stock | 53.512499999999996 | 55.5 | 50.3625 | 52.905 | 3114.866666666667 |
| 2024-08-29 | ABTS | Stock | 7.317 | 7.32 | 7.2 | 7.2225 | 239.0 |
| 2024-08-29 | ABUS | Stock | 3.85 | 3.885 | 3.82 | 3.83 | 451918.0 |
> showing 50 of 7,090 rows — these rows as CSV