PREVIEW / stock_daily / 2024-08-14
file: by_date/stock_daily/2024/2024-08-14.parquet size: 244 KB rows: 7,150 symbols: 838
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-14 | AAPL | Stock | 220.57 | 223.03 | 219.7 | 221.72 | 40469178.0 |
| 2024-08-14 | MSFT | Stock | 414.8 | 417.72 | 412.4456 | 416.86 | 17335007.0 |
| 2024-08-14 | NVDA | Stock | 118.53 | 118.6 | 114.07 | 118.08 | 336201390.0 |
| 2024-08-14 | AMZN | Stock | 172.11 | 172.28 | 168.86 | 170.1 | 28234369.0 |
| 2024-08-14 | GOOGL | Stock | 162.4 | 163.22 | 157.71 | 160.37 | 40591126.0 |
| 2024-08-14 | META | Stock | 528.06 | 534.0 | 523.13 | 526.76 | 11302923.0 |
| 2024-08-14 | TSLA | Stock | 207.39 | 208.44 | 198.75 | 201.38 | 69966096.0 |
| 2024-08-14 | TLT | Stock | 97.55 | 98.16 | 97.5082 | 97.89 | 31334061.0 |
| 2024-08-14 | ES | Stock | 65.35 | 66.75 | 65.25 | 66.45 | 2414989.0 |
| 2024-08-14 | CL | Stock | 100.18 | 102.42 | 99.75 | 102.18 | 3120991.0 |
| 2024-08-14 | A | Stock | 137.93 | 138.69 | 135.88 | 136.03 | 1066809.0 |
| 2024-08-14 | AA | Stock | 31.81 | 31.97 | 30.88 | 31.1 | 5031986.0 |
| 2024-08-14 | AACG | Stock | 0.62 | 0.623 | 0.58742 | 0.58742 | 14505.0 |
| 2024-08-14 | AACIU | Stock | 10.95 | 14.16 | 10.81 | 11.51 | 34429.0 |
| 2024-08-14 | AACIW-DELISTED | Stock | 0.111 | 0.1401 | 0.1109 | 0.1299 | 159416.0 |
| 2024-08-14 | AACT | Stock | 10.76 | 10.76 | 10.75 | 10.755 | 76000.0 |
| 2024-08-14 | AAGR-DELISTED | Stock | 0.135 | 0.135 | 0.1212 | 0.1237 | 309714.0 |
| 2024-08-14 | AAL | Stock | 9.88 | 9.97 | 9.7 | 9.74 | 29616303.0 |
| 2024-08-14 | AAMC-DELISTED | Stock | 2.56 | 2.98 | 2.41 | 2.75 | 6424.0 |
| 2024-08-14 | AAME | Stock | 1.58 | 1.62 | 1.5001 | 1.6 | 7715.0 |
| 2024-08-14 | AAMI | Stock | 22.85 | 23.0 | 22.56 | 22.98 | 115950.0 |
| 2024-08-14 | AAN-DELISTED | Stock | 10.08 | 10.1 | 10.06 | 10.06 | 654546.0 |
| 2024-08-14 | AAOI | Stock | 8.11 | 8.19 | 7.72 | 8.14 | 1541245.0 |
| 2024-08-14 | AAON | Stock | 88.11 | 88.66 | 86.9 | 87.97 | 252846.0 |
| 2024-08-14 | AAP | Stock | 60.65 | 61.37 | 60.0 | 60.5 | 812191.0 |
| 2024-08-14 | AAT | Stock | 24.71 | 25.22 | 24.51 | 24.82 | 652620.0 |
| 2024-08-14 | AATC | Stock | 7.34 | 7.38 | 7.3 | 7.3475 | 6294.0 |
| 2024-08-14 | AAUAF-DELISTED | Stock | 0.0432 | 0.04758 | 0.0432 | 0.0451 | 174554.0 |
| 2024-08-14 | AAXJ | Stock | 71.5 | 71.53 | 70.92 | 71.17 | 158764.0 |
| 2024-08-14 | AB | Stock | 33.76 | 34.4422 | 33.705 | 34.16 | 360218.0 |
| 2024-08-14 | ABAT | Stock | 1.11 | 1.12 | 1.04 | 1.05 | 183159.0 |
| 2024-08-14 | ABBV | Stock | 191.0 | 193.35 | 190.47 | 193.0 | 4076076.0 |
| 2024-08-14 | ABCB | Stock | 56.39 | 56.39 | 55.11 | 56.18 | 238956.0 |
| 2024-08-14 | ABCL | Stock | 2.72 | 2.72 | 2.57 | 2.62 | 1179463.0 |
| 2024-08-14 | ABEO | Stock | 5.05 | 5.2992 | 4.84 | 4.95 | 412797.0 |
| 2024-08-14 | ABEV | Stock | 2.32 | 2.35 | 2.31 | 2.32 | 17348458.0 |
| 2024-08-14 | ABG | Stock | 228.86 | 228.86 | 223.14 | 223.21 | 120632.0 |
| 2024-08-14 | ABLLW | Stock | 1.39 | 1.39 | 1.21 | 1.27 | 77043.0 |
| 2024-08-14 | ABLV | Stock | 1.3 | 1.55 | 1.3 | 1.35 | 41918.0 |
| 2024-08-14 | ABM | Stock | 53.2 | 53.35 | 52.565 | 53.3 | 256393.0 |
| 2024-08-14 | ABNB | Stock | 117.72 | 118.74 | 116.18 | 116.24 | 3487943.0 |
| 2024-08-14 | ABOS | Stock | 2.78 | 2.8286 | 2.41 | 2.515 | 250805.0 |
| 2024-08-14 | ABR | Stock | 13.57 | 13.67 | 13.47 | 13.6 | 1972208.0 |
| 2024-08-14 | ABR.D | Stock | 17.63 | 17.6999 | 17.5 | 17.5 | 9956.0 |
| 2024-08-14 | ABR.E | Stock | 17.7 | 17.7 | 17.55 | 17.55 | 2956.0 |
| 2024-08-14 | ABR.F | Stock | 18.64 | 18.64 | 18.385 | 18.48 | 19435.0 |
| 2024-08-14 | ABSI | Stock | 3.97 | 3.97 | 3.675 | 3.73 | 1164033.0 |
| 2024-08-14 | ABT | Stock | 108.07 | 110.18 | 107.71 | 109.89 | 5687116.0 |
| 2024-08-14 | ABTC | Stock | 59.25 | 59.955 | 54.54 | 54.824999999999996 | 1490.2666666666667 |
| 2024-08-14 | ABTS | Stock | 7.197 | 7.197 | 7.0515 | 7.194 | 333.0 |
> showing 50 of 7,150 rows — these rows as CSV