PREVIEW / stock_daily / 2024-09-04
file: by_date/stock_daily/2024/2024-09-04.parquet size: 245 KB rows: 7,118 symbols: 776
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-09-04 | AAPL | Stock | 221.66 | 221.78 | 217.48 | 220.85 | 42633761.0 |
| 2024-09-04 | MSFT | Stock | 405.91 | 411.24 | 404.37 | 408.9 | 14779892.0 |
| 2024-09-04 | NVDA | Stock | 105.41 | 109.99 | 104.12 | 106.21 | 370714671.0 |
| 2024-09-04 | AMZN | Stock | 174.48 | 175.98 | 172.54 | 173.33 | 29611465.0 |
| 2024-09-04 | GOOGL | Stock | 156.655 | 159.0 | 155.9616 | 156.45 | 19353759.0 |
| 2024-09-04 | META | Stock | 506.07 | 516.59 | 504.07 | 512.74 | 8048112.0 |
| 2024-09-04 | TSLA | Stock | 210.59 | 222.22 | 210.57 | 219.41 | 80056392.0 |
| 2024-09-04 | TLT | Stock | 97.88 | 99.03 | 97.81 | 99.01 | 40885163.0 |
| 2024-09-04 | ES | Stock | 67.72 | 68.7 | 67.41 | 68.17 | 1454834.0 |
| 2024-09-04 | CL | Stock | 108.16 | 108.98 | 107.81 | 108.77 | 4294515.0 |
| 2024-09-04 | A | Stock | 138.39 | 139.66 | 136.49 | 138.16 | 1316756.0 |
| 2024-09-04 | AA | Stock | 30.84 | 31.22 | 30.46 | 30.48 | 3103489.0 |
| 2024-09-04 | AACG | Stock | 0.58 | 0.60895 | 0.57 | 0.596 | 4774.0 |
| 2024-09-04 | AACT | Stock | 10.771 | 10.78 | 10.76 | 10.775 | 462676.0 |
| 2024-09-04 | AAGR-DELISTED | Stock | 0.14 | 0.1441 | 0.132 | 0.1344 | 46958.0 |
| 2024-09-04 | AAGRW-DELISTED | Stock | 0.0086 | 0.0086 | 0.0086 | 0.0086 | 1950.0 |
| 2024-09-04 | AAL | Stock | 10.53 | 10.78 | 10.5035 | 10.63 | 21986270.0 |
| 2024-09-04 | AAMC-DELISTED | Stock | 1.22 | 1.29 | 1.05 | 1.12 | 17587.0 |
| 2024-09-04 | AAME | Stock | 1.65 | 1.65 | 1.58 | 1.62 | 7273.0 |
| 2024-09-04 | AAMI | Stock | 23.44 | 23.71 | 23.35 | 23.66 | 146068.0 |
| 2024-09-04 | AAN-DELISTED | Stock | 9.95 | 9.985 | 9.945 | 9.97 | 1520503.0 |
| 2024-09-04 | AAOI | Stock | 12.0 | 13.65 | 11.9 | 13.0 | 4298638.0 |
| 2024-09-04 | AAON | Stock | 88.95 | 90.12 | 87.61 | 88.92 | 278026.0 |
| 2024-09-04 | AAP | Stock | 43.56 | 43.73 | 41.94 | 42.42 | 3099858.0 |
| 2024-09-04 | AAT | Stock | 26.96 | 27.285 | 26.42 | 26.7 | 260414.0 |
| 2024-09-04 | AATC | Stock | 7.5 | 7.775 | 7.31 | 7.59 | 9580.0 |
| 2024-09-04 | AAUAF-DELISTED | Stock | 0.0402 | 0.0454 | 0.0402 | 0.0454 | 15631.0 |
| 2024-09-04 | AAXJ | Stock | 71.26 | 71.87 | 71.26 | 71.42 | 381828.0 |
| 2024-09-04 | AB | Stock | 33.49 | 33.96 | 33.41 | 33.68 | 139681.0 |
| 2024-09-04 | ABAT | Stock | 1.05 | 1.07 | 1.05 | 1.07 | 140150.0 |
| 2024-09-04 | ABBV | Stock | 198.68 | 199.88 | 196.44 | 197.01 | 3483066.0 |
| 2024-09-04 | ABCB | Stock | 61.05 | 61.7853 | 60.536 | 60.8 | 331906.0 |
| 2024-09-04 | ABCL | Stock | 2.47 | 2.55 | 2.46 | 2.52 | 1301593.0 |
| 2024-09-04 | ABEO | Stock | 5.36 | 5.61 | 5.33 | 5.57 | 147875.0 |
| 2024-09-04 | ABEV | Stock | 2.3 | 2.33 | 2.28 | 2.32 | 18944962.0 |
| 2024-09-04 | ABG | Stock | 236.23 | 237.535 | 233.7 | 233.72 | 207531.0 |
| 2024-09-04 | ABLLW | Stock | 1.33 | 1.42 | 1.33 | 1.37 | 42465.0 |
| 2024-09-04 | ABLV | Stock | 1.56 | 1.79 | 1.55 | 1.65 | 9571.0 |
| 2024-09-04 | ABM | Stock | 56.68 | 57.1 | 55.73 | 56.0 | 340710.0 |
| 2024-09-04 | ABNB | Stock | 114.27 | 115.99 | 114.19 | 115.21 | 3256612.0 |
| 2024-09-04 | ABOS | Stock | 2.45 | 2.53 | 2.38 | 2.4 | 241015.0 |
| 2024-09-04 | ABR | Stock | 13.16 | 13.315 | 13.0 | 13.04 | 2399848.0 |
| 2024-09-04 | ABR.D | Stock | 17.81 | 18.11 | 17.81 | 18.03 | 17489.0 |
| 2024-09-04 | ABR.E | Stock | 17.96 | 18.3 | 17.92 | 18.2499 | 34008.0 |
| 2024-09-04 | ABR.F | Stock | 18.5213 | 18.72 | 18.5213 | 18.66 | 16492.0 |
| 2024-09-04 | ABSI | Stock | 3.91 | 4.14 | 3.8201 | 4.05 | 688631.0 |
| 2024-09-04 | ABT | Stock | 114.69 | 115.59 | 113.57 | 114.4 | 3513378.0 |
| 2024-09-04 | ABTC | Stock | 46.275 | 46.67100000000001 | 44.8875 | 45.1725 | 1175.6666666666667 |
| 2024-09-04 | ABTS | Stock | 7.35 | 7.65 | 7.0725 | 7.3965 | 116.0 |
| 2024-09-04 | ABUS | Stock | 3.96 | 4.19 | 3.93 | 4.09 | 1431963.0 |
> showing 50 of 7,118 rows — these rows as CSV