PREVIEW / stock_daily / 2024-08-16
file: by_date/stock_daily/2024/2024-08-16.parquet size: 243 KB rows: 7,144 symbols: 831
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-16 | AAPL | Stock | 223.92 | 226.8271 | 223.6501 | 226.05 | 42335671.0 |
| 2024-08-16 | MSFT | Stock | 420.6 | 421.34 | 417.3 | 418.47 | 21182409.0 |
| 2024-08-16 | NVDA | Stock | 121.94 | 125.0 | 121.18 | 124.58 | 295500300.0 |
| 2024-08-16 | AMZN | Stock | 177.04 | 178.34 | 176.2601 | 177.06 | 30446587.0 |
| 2024-08-16 | GOOGL | Stock | 161.47 | 165.06 | 161.13 | 162.96 | 24208647.0 |
| 2024-08-16 | META | Stock | 531.9 | 533.66 | 524.66 | 527.42 | 14459289.0 |
| 2024-08-16 | TSLA | Stock | 211.15 | 219.8 | 210.8 | 216.12 | 88290605.0 |
| 2024-08-16 | TLT | Stock | 97.44 | 97.5399 | 97.01 | 97.44 | 28540965.0 |
| 2024-08-16 | ES | Stock | 65.06 | 65.205 | 64.72 | 65.11 | 2237491.0 |
| 2024-08-16 | CL | Stock | 101.66 | 102.08 | 101.23 | 101.99 | 2824865.0 |
| 2024-08-16 | A | Stock | 139.79 | 140.9 | 138.52 | 140.04 | 1250141.0 |
| 2024-08-16 | AA | Stock | 31.75 | 32.42 | 31.7 | 32.12 | 4336188.0 |
| 2024-08-16 | AACG | Stock | 0.618 | 0.6201 | 0.5954 | 0.6 | 10578.0 |
| 2024-08-16 | AACT | Stock | 10.77 | 10.77 | 10.76 | 10.76 | 33306.0 |
| 2024-08-16 | AAGR-DELISTED | Stock | 0.12 | 0.1321 | 0.12 | 0.1231 | 329716.0 |
| 2024-08-16 | AAL | Stock | 10.02 | 10.14 | 9.97 | 10.05 | 35293300.0 |
| 2024-08-16 | AAMC-DELISTED | Stock | 2.4 | 2.685 | 2.2 | 2.31 | 7240.0 |
| 2024-08-16 | AAME | Stock | 1.5407 | 1.5695 | 1.51 | 1.55 | 9502.0 |
| 2024-08-16 | AAMI | Stock | 23.25 | 23.7 | 23.1975 | 23.68 | 108849.0 |
| 2024-08-16 | AAN-DELISTED | Stock | 10.08 | 10.085 | 10.07 | 10.07 | 822312.0 |
| 2024-08-16 | AAOI | Stock | 8.46 | 8.65 | 8.22 | 8.28 | 1171266.0 |
| 2024-08-16 | AAON | Stock | 89.33 | 89.33 | 88.2 | 88.69 | 203905.0 |
| 2024-08-16 | AAP | Stock | 62.27 | 62.8 | 61.74 | 62.19 | 967709.0 |
| 2024-08-16 | AAT | Stock | 25.36 | 25.61 | 25.18 | 25.38 | 204363.0 |
| 2024-08-16 | AATC | Stock | 7.47 | 7.88 | 7.47 | 7.7 | 24639.0 |
| 2024-08-16 | AAUAF-DELISTED | Stock | 0.0478 | 0.0549 | 0.0469 | 0.048 | 30415.0 |
| 2024-08-16 | AAXJ | Stock | 72.35 | 72.91 | 72.35 | 72.89 | 224958.0 |
| 2024-08-16 | AB | Stock | 34.52 | 35.05 | 34.52 | 34.76 | 328788.0 |
| 2024-08-16 | ABAT | Stock | 1.05 | 1.06 | 1.02 | 1.03 | 200041.0 |
| 2024-08-16 | ABBV | Stock | 193.88 | 194.25 | 192.27 | 193.9 | 3442855.0 |
| 2024-08-16 | ABCB | Stock | 57.01 | 58.57 | 57.01 | 58.16 | 242323.0 |
| 2024-08-16 | ABCL | Stock | 2.67 | 2.67 | 2.58 | 2.61 | 1751382.0 |
| 2024-08-16 | ABEO | Stock | 5.0 | 5.06 | 4.88 | 5.0 | 161087.0 |
| 2024-08-16 | ABEV | Stock | 2.46 | 2.47 | 2.39 | 2.39 | 27727113.0 |
| 2024-08-16 | ABG | Stock | 231.49 | 235.21 | 229.42 | 230.36 | 93088.0 |
| 2024-08-16 | ABLLW | Stock | 1.24 | 1.3 | 1.24 | 1.3 | 17809.0 |
| 2024-08-16 | ABLV | Stock | 1.54 | 1.56 | 1.5 | 1.51 | 2916.0 |
| 2024-08-16 | ABM | Stock | 54.32 | 54.55 | 53.74 | 54.11 | 287714.0 |
| 2024-08-16 | ABNB | Stock | 117.9 | 118.8 | 116.22 | 116.31 | 4519366.0 |
| 2024-08-16 | ABOS | Stock | 2.62 | 2.62 | 2.5 | 2.57 | 126722.0 |
| 2024-08-16 | ABR | Stock | 13.33 | 13.47 | 13.24 | 13.38 | 2856372.0 |
| 2024-08-16 | ABR.D | Stock | 17.79 | 17.8 | 17.5 | 17.64 | 37008.0 |
| 2024-08-16 | ABR.E | Stock | 17.58 | 17.6999 | 17.21 | 17.65 | 18678.0 |
| 2024-08-16 | ABR.F | Stock | 18.48 | 18.6 | 18.25 | 18.43 | 77889.0 |
| 2024-08-16 | ABSI | Stock | 4.2 | 4.42 | 3.935 | 4.01 | 1320011.0 |
| 2024-08-16 | ABT | Stock | 111.36 | 111.6 | 110.57 | 111.0 | 4393847.0 |
| 2024-08-16 | ABTC | Stock | 56.175000000000004 | 64.41 | 53.955 | 61.455000000000005 | 1671.6666666666667 |
| 2024-08-16 | ABTS | Stock | 8.79 | 8.79 | 8.2485 | 8.2485 | 184.0 |
| 2024-08-16 | ABUS | Stock | 3.75 | 3.77 | 3.695 | 3.71 | 360502.0 |
| 2024-08-16 | ABVC | Stock | 0.74 | 0.74 | 0.6593 | 0.6594 | 106489.0 |
> showing 50 of 7,144 rows — these rows as CSV