PREVIEW / stock_daily / 2024-11-06
file: by_date/stock_daily/2024/2024-11-06.parquet size: 246 KB rows: 7,132 symbols: 656
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-11-06 | AAPL | Stock | 222.61 | 226.065 | 221.19 | 222.72 | 51716459.0 |
| 2024-11-06 | MSFT | Stock | 412.42 | 420.45 | 410.52 | 420.18 | 25271064.0 |
| 2024-11-06 | NVDA | Stock | 142.96 | 146.49 | 141.96 | 145.61 | 236372394.0 |
| 2024-11-06 | AMZN | Stock | 200.01 | 207.55 | 199.14 | 207.09 | 70637654.0 |
| 2024-11-06 | GOOGL | Stock | 173.8 | 176.94 | 173.5 | 176.51 | 33695538.0 |
| 2024-11-06 | META | Stock | 562.75 | 573.0 | 555.1679 | 572.05 | 17791377.0 |
| 2024-11-06 | TSLA | Stock | 284.67 | 289.59 | 275.62 | 288.53 | 163276277.0 |
| 2024-11-06 | TLT | Stock | 89.64 | 90.72 | 89.5545 | 90.2 | 98895693.0 |
| 2024-11-06 | ES | Stock | 61.77 | 61.77 | 59.88 | 60.7 | 4060035.0 |
| 2024-11-06 | CL | Stock | 94.66 | 94.66 | 90.04 | 90.22 | 8604348.0 |
| 2024-11-06 | A | Stock | 143.0 | 143.07 | 137.04 | 137.78 | 2474224.0 |
| 2024-11-06 | AA | Stock | 43.0 | 46.03 | 42.33 | 45.36 | 9393114.0 |
| 2024-11-06 | AACG | Stock | 1.02 | 1.03 | 1.0 | 1.025 | 38436.0 |
| 2024-11-06 | AACT | Stock | 10.87 | 10.88 | 10.855 | 10.87 | 628723.0 |
| 2024-11-06 | AAGR-DELISTED | Stock | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 10639.0 |
| 2024-11-06 | AAL | Stock | 14.01 | 14.17 | 13.795 | 14.0 | 38526669.0 |
| 2024-11-06 | AAM | Stock | 10.05 | 10.06 | 10.045 | 10.06 | 25104.0 |
| 2024-11-06 | AAME | Stock | 1.6186 | 1.71 | 1.6055 | 1.6731 | 9935.0 |
| 2024-11-06 | AAMI | Stock | 29.62 | 30.3511 | 29.3 | 29.9 | 387051.0 |
| 2024-11-06 | AAOI | Stock | 17.53 | 18.0 | 15.91 | 16.21 | 4265763.0 |
| 2024-11-06 | AAON | Stock | 118.87 | 120.41 | 116.0639 | 120.25 | 575641.0 |
| 2024-11-06 | AAP | Stock | 38.78 | 39.33 | 37.88 | 38.84 | 1940474.0 |
| 2024-11-06 | AAT | Stock | 28.96 | 28.96 | 27.48 | 28.02 | 363996.0 |
| 2024-11-06 | AATC | Stock | 7.56 | 7.88 | 7.52 | 7.88 | 14029.0 |
| 2024-11-06 | AAUAF-DELISTED | Stock | 0.05248 | 0.0542 | 0.0508 | 0.0508 | 66650.0 |
| 2024-11-06 | AAXJ | Stock | 76.16 | 76.775 | 75.905 | 76.52 | 1783055.0 |
| 2024-11-06 | AB | Stock | 37.21 | 38.33 | 37.18 | 38.21 | 637225.0 |
| 2024-11-06 | ABAT | Stock | 1.0 | 1.01 | 0.9801 | 0.9902 | 382461.0 |
| 2024-11-06 | ABBV | Stock | 205.79 | 206.15 | 200.85 | 201.2 | 6944292.0 |
| 2024-11-06 | ABCB | Stock | 68.62 | 71.96 | 68.62 | 71.14 | 1032897.0 |
| 2024-11-06 | ABCL | Stock | 2.74 | 2.805 | 2.64 | 2.76 | 1674493.0 |
| 2024-11-06 | ABEO | Stock | 6.25 | 6.38 | 6.13 | 6.28 | 183774.0 |
| 2024-11-06 | ABEV | Stock | 2.18 | 2.22 | 2.14 | 2.21 | 26736487.0 |
| 2024-11-06 | ABG | Stock | 254.61 | 263.36 | 254.61 | 259.2 | 345997.0 |
| 2024-11-06 | ABLLW | Stock | 1.38 | 1.3801 | 1.28 | 1.31 | 28515.0 |
| 2024-11-06 | ABLV | Stock | 0.9898 | 0.9898 | 0.95 | 0.9601 | 7529.0 |
| 2024-11-06 | ABM | Stock | 56.68 | 57.48 | 56.06 | 57.19 | 487513.0 |
| 2024-11-06 | ABNB | Stock | 141.98 | 142.95 | 139.41 | 140.91 | 4979837.0 |
| 2024-11-06 | ABOS | Stock | 3.02 | 3.295 | 2.85 | 3.23 | 382037.0 |
| 2024-11-06 | ABR | Stock | 15.47 | 15.6 | 14.705 | 15.03 | 3241331.0 |
| 2024-11-06 | ABR.D | Stock | 19.169 | 19.393 | 18.66 | 19.25 | 26580.0 |
| 2024-11-06 | ABR.E | Stock | 19.69 | 19.69 | 19.0001 | 19.51 | 2625.0 |
| 2024-11-06 | ABR.F | Stock | 20.67 | 20.8 | 20.2755 | 20.55 | 23956.0 |
| 2024-11-06 | ABSI | Stock | 4.1 | 4.23 | 3.97 | 4.14 | 1963638.0 |
| 2024-11-06 | ABT | Stock | 121.0 | 121.0 | 115.5 | 116.8 | 5020431.0 |
| 2024-11-06 | ABTC | Stock | 46.5 | 50.2275 | 44.145 | 49.7475 | 20482.266666666666 |
| 2024-11-06 | ABTS | Stock | 8.85 | 9.3 | 7.8705 | 8.4 | 9879.0 |
| 2024-11-06 | ABUS | Stock | 3.85 | 3.955 | 3.6 | 3.92 | 1469949.0 |
| 2024-11-06 | ABVC | Stock | 0.5701 | 0.5819 | 0.5221 | 0.553 | 104186.0 |
| 2024-11-06 | ABVE | Stock | 0.4139 | 0.4667 | 0.3818 | 0.42 | 54333.0 |
> showing 50 of 7,132 rows — these rows as CSV