PREVIEW / stock_daily / 2024-08-09
file: by_date/stock_daily/2024/2024-08-09.parquet size: 242 KB rows: 7,081 symbols: 822
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-09 | AAPL | Stock | 212.1 | 216.78 | 211.97 | 216.24 | 40729249.0 |
| 2024-08-09 | MSFT | Stock | 404.03 | 408.05 | 402.2624 | 406.02 | 17973034.0 |
| 2024-08-09 | NVDA | Stock | 105.64 | 106.6 | 103.43 | 104.75 | 285927382.0 |
| 2024-08-09 | AMZN | Stock | 166.4 | 168.55 | 165.85 | 166.94 | 35548245.0 |
| 2024-08-09 | GOOGL | Stock | 160.01 | 163.79 | 159.06 | 163.67 | 28602285.0 |
| 2024-08-09 | META | Stock | 507.71 | 518.34 | 505.7 | 517.77 | 13434637.0 |
| 2024-08-09 | TSLA | Stock | 197.05 | 200.88 | 195.11 | 200.0 | 58059915.0 |
| 2024-08-09 | TLT | Stock | 96.51 | 96.54 | 96.0906 | 96.26 | 32141763.0 |
| 2024-08-09 | ES | Stock | 65.08 | 65.17 | 63.7675 | 64.91 | 2716217.0 |
| 2024-08-09 | CL | Stock | 102.47 | 102.73 | 101.33 | 102.07 | 3565369.0 |
| 2024-08-09 | A | Stock | 136.84 | 137.86 | 136.105 | 136.9 | 713519.0 |
| 2024-08-09 | AA | Stock | 31.26 | 31.26 | 30.39 | 30.56 | 7023209.0 |
| 2024-08-09 | AACG | Stock | 0.68 | 0.68 | 0.6365 | 0.6599 | 5766.0 |
| 2024-08-09 | AACIU | Stock | 11.9 | 11.9 | 10.85 | 11.7 | 1206.0 |
| 2024-08-09 | AACIW-DELISTED | Stock | 0.1392 | 0.15 | 0.1109 | 0.111 | 134030.0 |
| 2024-08-09 | AACT | Stock | 10.74 | 10.75 | 10.74 | 10.74 | 110246.0 |
| 2024-08-09 | AAGR-DELISTED | Stock | 0.1368 | 0.1428 | 0.1321 | 0.1396 | 187578.0 |
| 2024-08-09 | AAGRW-DELISTED | Stock | 0.011 | 0.011 | 0.011 | 0.011 | 166.0 |
| 2024-08-09 | AAL | Stock | 9.89 | 9.96 | 9.72 | 9.86 | 22530845.0 |
| 2024-08-09 | AAMC-DELISTED | Stock | 2.95 | 3.0 | 2.81 | 2.95 | 6750.0 |
| 2024-08-09 | AAME | Stock | 1.51 | 1.51 | 1.51 | 1.51 | 272.0 |
| 2024-08-09 | AAMI | Stock | 22.14 | 22.565 | 21.878 | 22.41 | 120713.0 |
| 2024-08-09 | AAN-DELISTED | Stock | 10.01 | 10.02 | 10.0 | 10.02 | 736849.0 |
| 2024-08-09 | AAOI | Stock | 8.6 | 8.64 | 7.6 | 7.74 | 2342173.0 |
| 2024-08-09 | AAON | Stock | 86.09 | 87.93 | 84.98 | 86.67 | 517713.0 |
| 2024-08-09 | AAP | Stock | 61.33 | 61.33 | 59.9208 | 60.21 | 818062.0 |
| 2024-08-09 | AAT | Stock | 25.22 | 25.27 | 24.95 | 25.13 | 135022.0 |
| 2024-08-09 | AATC | Stock | 7.19 | 7.28 | 7.07 | 7.2 | 41560.0 |
| 2024-08-09 | AAUAF-DELISTED | Stock | 0.0425 | 0.05322 | 0.0425 | 0.048 | 14457.0 |
| 2024-08-09 | AAXJ | Stock | 70.47 | 70.73 | 70.16 | 70.63 | 100031.0 |
| 2024-08-09 | AB | Stock | 33.2 | 33.4799 | 33.0 | 33.29 | 188049.0 |
| 2024-08-09 | ABAT | Stock | 1.0 | 1.02 | 1.0 | 1.01 | 122444.0 |
| 2024-08-09 | ABBV | Stock | 190.78 | 191.01 | 188.1 | 189.93 | 3017656.0 |
| 2024-08-09 | ABCB | Stock | 56.41 | 56.655 | 55.66 | 56.26 | 260784.0 |
| 2024-08-09 | ABCL | Stock | 2.76 | 2.7851 | 2.59 | 2.68 | 1625327.0 |
| 2024-08-09 | ABEO | Stock | 4.49 | 4.57 | 4.3602 | 4.42 | 427199.0 |
| 2024-08-09 | ABEV | Stock | 2.26 | 2.28 | 2.25 | 2.27 | 11288715.0 |
| 2024-08-09 | ABG | Stock | 235.38 | 235.38 | 231.35 | 233.92 | 89448.0 |
| 2024-08-09 | ABLLW | Stock | 1.24 | 1.355 | 1.21 | 1.28 | 25491.0 |
| 2024-08-09 | ABLV | Stock | 1.27 | 1.36 | 1.07 | 1.18 | 30751.0 |
| 2024-08-09 | ABM | Stock | 52.45 | 52.84 | 51.8825 | 52.8 | 248531.0 |
| 2024-08-09 | ABNB | Stock | 114.465 | 116.26 | 112.6 | 115.08 | 4678165.0 |
| 2024-08-09 | ABOS | Stock | 2.73 | 2.75 | 2.605 | 2.64 | 111514.0 |
| 2024-08-09 | ABR | Stock | 13.56 | 13.69 | 13.465 | 13.55 | 1820396.0 |
| 2024-08-09 | ABR.D | Stock | 17.6 | 17.7699 | 17.37 | 17.69 | 27963.0 |
| 2024-08-09 | ABR.E | Stock | 17.44 | 17.95 | 17.44 | 17.95 | 9947.0 |
| 2024-08-09 | ABR.F | Stock | 18.73 | 18.9499 | 18.66 | 18.8 | 22397.0 |
| 2024-08-09 | ABSI | Stock | 3.76 | 3.7999 | 3.645 | 3.69 | 771734.0 |
| 2024-08-09 | ABT | Stock | 109.28 | 109.28 | 107.69 | 108.71 | 5332013.0 |
| 2024-08-09 | ABTC | Stock | 53.175 | 55.800000000000004 | 51.0 | 51.7575 | 3701.6666666666665 |
> showing 50 of 7,081 rows — these rows as CSV