PREVIEW / stock_daily / 2024-07-08
file: by_date/stock_daily/2024/2024-07-08.parquet size: 245 KB rows: 7,241 symbols: 938
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-07-08 | AAPL | Stock | 227.09 | 227.85 | 223.25 | 227.82 | 57401549.0 |
| 2024-07-08 | MSFT | Stock | 466.55 | 467.7 | 464.46 | 466.24 | 12321788.0 |
| 2024-07-08 | NVDA | Stock | 127.49 | 130.77 | 127.04 | 128.2 | 231399108.0 |
| 2024-07-08 | AMZN | Stock | 200.04 | 201.2 | 197.96 | 199.29 | 32778237.0 |
| 2024-07-08 | GOOGL | Stock | 189.895 | 190.17 | 187.78 | 189.03 | 21035886.0 |
| 2024-07-08 | META | Stock | 542.35 | 542.81 | 526.65 | 529.32 | 14563001.0 |
| 2024-07-08 | TSLA | Stock | 247.71 | 259.439 | 244.57 | 252.94 | 156551782.0 |
| 2024-07-08 | TLT | Stock | 92.54 | 92.845 | 92.2246 | 92.76 | 16095651.0 |
| 2024-07-08 | ES | Stock | 57.18 | 57.49 | 57.0 | 57.31 | 1454209.0 |
| 2024-07-08 | CL | Stock | 97.23 | 97.94 | 97.12 | 97.58 | 2713655.0 |
| 2024-07-08 | A | Stock | 126.68 | 126.73 | 125.4 | 126.07 | 1818887.0 |
| 2024-07-08 | AA | Stock | 42.54 | 42.55 | 41.31 | 41.66 | 2883240.0 |
| 2024-07-08 | AACG | Stock | 0.859 | 0.859 | 0.8051 | 0.825 | 4060.0 |
| 2024-07-08 | AACIW-DELISTED | Stock | 0.143 | 0.143 | 0.12 | 0.1256 | 1400.0 |
| 2024-07-08 | AACT | Stock | 10.7 | 10.7 | 10.68 | 10.68 | 464838.0 |
| 2024-07-08 | AAGR-DELISTED | Stock | 0.175 | 0.1759 | 0.1648 | 0.175 | 784755.0 |
| 2024-07-08 | AAGRW-DELISTED | Stock | 0.0138 | 0.0144 | 0.012 | 0.012 | 15978.0 |
| 2024-07-08 | AAL | Stock | 11.08 | 11.13 | 10.91 | 10.93 | 30959416.0 |
| 2024-07-08 | AAMC-DELISTED | Stock | 2.16 | 2.31 | 1.96 | 2.14 | 4463.0 |
| 2024-07-08 | AAME | Stock | 1.61 | 1.6313 | 1.55 | 1.55 | 3278.0 |
| 2024-07-08 | AAMI | Stock | 22.56 | 22.76 | 22.32 | 22.6 | 241117.0 |
| 2024-07-08 | AAN-DELISTED | Stock | 9.98 | 10.0 | 9.97 | 9.98 | 448031.0 |
| 2024-07-08 | AAOI | Stock | 7.77 | 8.77 | 7.7401 | 8.54 | 2448132.0 |
| 2024-07-08 | AAON | Stock | 87.15 | 88.28 | 85.81 | 85.99 | 456027.0 |
| 2024-07-08 | AAP | Stock | 59.33 | 59.99 | 58.4016 | 59.3 | 1309466.0 |
| 2024-07-08 | AAT | Stock | 21.93 | 22.1 | 21.89 | 21.98 | 188134.0 |
| 2024-07-08 | AATC | Stock | 6.3525 | 6.3525 | 6.33 | 6.33 | 576.0 |
| 2024-07-08 | AAUAF-DELISTED | Stock | 0.0632 | 0.065 | 0.05699 | 0.05699 | 112654.0 |
| 2024-07-08 | AAXJ | Stock | 73.79 | 73.98 | 73.63 | 73.7 | 733914.0 |
| 2024-07-08 | AB | Stock | 33.8 | 34.1097 | 33.62 | 33.68 | 162727.0 |
| 2024-07-08 | ABAT | Stock | 1.02 | 1.19 | 1.01 | 1.19 | 872231.0 |
| 2024-07-08 | ABBV | Stock | 166.54 | 167.717 | 165.62 | 166.52 | 3085568.0 |
| 2024-07-08 | ABCB | Stock | 49.26 | 49.76 | 48.55 | 48.61 | 195149.0 |
| 2024-07-08 | ABCL | Stock | 2.7 | 2.78 | 2.69 | 2.75 | 1552467.0 |
| 2024-07-08 | ABEO | Stock | 4.54 | 4.88 | 4.5387 | 4.8 | 458255.0 |
| 2024-07-08 | ABEV | Stock | 2.06 | 2.08 | 2.05 | 2.06 | 9810504.0 |
| 2024-07-08 | ABG | Stock | 227.17 | 230.58 | 226.0 | 227.27 | 157720.0 |
| 2024-07-08 | ABLLW | Stock | 0.65 | 0.65 | 0.63 | 0.63 | 3059.0 |
| 2024-07-08 | ABLV | Stock | 1.0699 | 1.14 | 1.0699 | 1.13 | 4277.0 |
| 2024-07-08 | ABM | Stock | 49.83 | 50.12 | 49.53 | 49.61 | 275234.0 |
| 2024-07-08 | ABNB | Stock | 152.65 | 154.2 | 150.755 | 151.96 | 2835306.0 |
| 2024-07-08 | ABOS | Stock | 2.32 | 2.39 | 2.28 | 2.31 | 314167.0 |
| 2024-07-08 | ABR | Stock | 14.74 | 14.94 | 14.74 | 14.89 | 1828791.0 |
| 2024-07-08 | ABR.D | Stock | 19.29 | 19.43 | 19.1696 | 19.25 | 14711.0 |
| 2024-07-08 | ABR.E | Stock | 18.7184 | 18.89 | 18.5001 | 18.79 | 16074.0 |
| 2024-07-08 | ABR.F | Stock | 20.2 | 20.3499 | 20.1 | 20.25 | 12885.0 |
| 2024-07-08 | ABSI | Stock | 3.35 | 3.7 | 3.23 | 3.3 | 2525000.0 |
| 2024-07-08 | ABT | Stock | 103.78 | 103.85 | 101.94 | 102.12 | 3854667.0 |
| 2024-07-08 | ABTC | Stock | 90.0 | 90.75 | 84.0 | 85.5 | 1761.2666666666667 |
| 2024-07-08 | ABTS | Stock | 7.224 | 7.5735 | 7.2015 | 7.35 | 1306.0 |
> showing 50 of 7,241 rows — these rows as CSV