PREVIEW / stock_daily / 2024-07-11
file: by_date/stock_daily/2024/2024-07-11.parquet size: 245 KB rows: 7,212 symbols: 912
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-11 | AAPL | Stock | 231.39 | 232.39 | 225.77 | 227.57 | 63317600.0 |
| 2024-07-11 | MSFT | Stock | 462.98 | 464.78 | 451.55 | 454.7 | 22200596.0 |
| 2024-07-11 | NVDA | Stock | 135.75 | 136.15 | 127.05 | 127.4 | 370958164.0 |
| 2024-07-11 | AMZN | Stock | 200.09 | 200.2699 | 192.86 | 195.05 | 44024311.0 |
| 2024-07-11 | GOOGL | Stock | 189.845 | 190.86 | 185.08 | 185.57 | 25625784.0 |
| 2024-07-11 | META | Stock | 530.89 | 535.46 | 508.3733 | 512.7 | 16098384.0 |
| 2024-07-11 | TSLA | Stock | 263.3 | 271.0 | 239.65 | 241.03 | 219760263.0 |
| 2024-07-11 | TLT | Stock | 93.68 | 94.135 | 93.47 | 93.54 | 49761785.0 |
| 2024-07-11 | ES | Stock | 58.64 | 59.7203 | 58.47 | 59.4 | 2567169.0 |
| 2024-07-11 | CL | Stock | 97.35 | 97.97 | 97.22 | 97.76 | 3624044.0 |
| 2024-07-11 | A | Stock | 128.8 | 131.535 | 127.8775 | 130.82 | 1627639.0 |
| 2024-07-11 | AA | Stock | 40.31 | 40.515 | 38.35 | 39.18 | 8755772.0 |
| 2024-07-11 | AACG | Stock | 0.827 | 0.827 | 0.79965 | 0.8 | 7113.0 |
| 2024-07-11 | AACIW-DELISTED | Stock | 0.1582 | 0.17 | 0.111 | 0.17 | 2118.0 |
| 2024-07-11 | AACT | Stock | 10.7 | 10.7 | 10.68 | 10.685 | 57392.0 |
| 2024-07-11 | AAGR-DELISTED | Stock | 0.175 | 0.187 | 0.1728 | 0.1868 | 771750.0 |
| 2024-07-11 | AAGRW-DELISTED | Stock | 0.01 | 0.012 | 0.01 | 0.0102 | 172380.0 |
| 2024-07-11 | AAL | Stock | 10.68 | 10.76 | 10.34 | 10.73 | 80103423.0 |
| 2024-07-11 | AAMC-DELISTED | Stock | 2.1 | 2.12 | 1.99 | 1.99 | 7114.0 |
| 2024-07-11 | AAME | Stock | 1.58 | 1.58 | 1.58 | 1.58 | 347.0 |
| 2024-07-11 | AAMI | Stock | 23.1 | 23.71 | 22.8673 | 23.46 | 153268.0 |
| 2024-07-11 | AAN-DELISTED | Stock | 9.98 | 10.01 | 9.96 | 9.96 | 663614.0 |
| 2024-07-11 | AAOI | Stock | 9.35 | 9.44 | 9.03 | 9.23 | 1543225.0 |
| 2024-07-11 | AAON | Stock | 86.04 | 88.9486 | 85.08 | 88.57 | 456039.0 |
| 2024-07-11 | AAP | Stock | 59.92 | 62.12 | 59.415 | 61.73 | 1439012.0 |
| 2024-07-11 | AAT | Stock | 22.66 | 23.24 | 22.59 | 23.19 | 241599.0 |
| 2024-07-11 | AATC | Stock | 6.25 | 6.335 | 6.25 | 6.3 | 7753.0 |
| 2024-07-11 | AAUAF-DELISTED | Stock | 0.0521 | 0.0589 | 0.049 | 0.049 | 39963.0 |
| 2024-07-11 | AAXJ | Stock | 75.33 | 75.47 | 74.83 | 75.0 | 244903.0 |
| 2024-07-11 | AB | Stock | 33.72 | 34.2205 | 33.57 | 33.97 | 312379.0 |
| 2024-07-11 | ABAT | Stock | 1.11 | 1.15 | 1.055 | 1.1 | 719865.0 |
| 2024-07-11 | ABBV | Stock | 167.52 | 170.35 | 167.35 | 169.91 | 3355440.0 |
| 2024-07-11 | ABCB | Stock | 53.04 | 54.61 | 52.94 | 54.38 | 411316.0 |
| 2024-07-11 | ABCL | Stock | 2.91 | 3.14 | 2.88 | 3.13 | 2027225.0 |
| 2024-07-11 | ABEO | Stock | 5.13 | 5.305 | 5.06 | 5.19 | 515546.0 |
| 2024-07-11 | ABEV | Stock | 2.14 | 2.17 | 2.1201 | 2.14 | 32811420.0 |
| 2024-07-11 | ABG | Stock | 234.09 | 244.48 | 234.09 | 243.55 | 197502.0 |
| 2024-07-11 | ABLLW | Stock | 0.62 | 0.64 | 0.6066 | 0.61 | 50064.0 |
| 2024-07-11 | ABLV | Stock | 1.2 | 1.26 | 1.19 | 1.19 | 2991.0 |
| 2024-07-11 | ABM | Stock | 49.82 | 50.8 | 49.53 | 50.55 | 377918.0 |
| 2024-07-11 | ABNB | Stock | 150.55 | 152.0 | 144.13 | 146.0 | 6264316.0 |
| 2024-07-11 | ABOS | Stock | 2.35 | 2.65 | 2.35 | 2.62 | 819607.0 |
| 2024-07-11 | ABR | Stock | 15.37 | 15.55 | 15.3 | 15.53 | 3897936.0 |
| 2024-07-11 | ABR.D | Stock | 19.46 | 19.4746 | 19.342 | 19.42 | 25247.0 |
| 2024-07-11 | ABR.E | Stock | 19.01 | 19.17 | 18.8 | 19.07 | 9759.0 |
| 2024-07-11 | ABR.F | Stock | 20.3998 | 20.4 | 20.28 | 20.32 | 13226.0 |
| 2024-07-11 | ABSI | Stock | 3.69 | 4.04 | 3.57 | 4.03 | 2424097.0 |
| 2024-07-11 | ABT | Stock | 103.38 | 104.64 | 103.06 | 104.18 | 4556126.0 |
| 2024-07-11 | ABTC | Stock | 84.75 | 84.75 | 81.75 | 84.0 | 2382.2 |
| 2024-07-11 | ABTS | Stock | 6.804 | 7.35 | 6.714 | 6.765 | 1206.0 |
> showing 50 of 7,212 rows — these rows as CSV