PREVIEW / stock_daily / 2024-07-29
file: by_date/stock_daily/2024/2024-07-29.parquet size: 245 KB rows: 7,191 symbols: 883
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-29 | AAPL | Stock | 216.96 | 219.3 | 215.75 | 218.24 | 35125340.0 |
| 2024-07-29 | MSFT | Stock | 431.58 | 432.15 | 424.7042 | 426.73 | 14685262.0 |
| 2024-07-29 | NVDA | Stock | 113.69 | 116.28 | 111.3 | 111.59 | 245812434.0 |
| 2024-07-29 | AMZN | Stock | 183.84 | 184.75 | 182.38 | 183.2 | 32885711.0 |
| 2024-07-29 | GOOGL | Stock | 168.83 | 170.43 | 167.99 | 169.53 | 20293822.0 |
| 2024-07-29 | META | Stock | 469.88 | 473.96 | 465.02 | 465.71 | 11184837.0 |
| 2024-07-29 | TSLA | Stock | 224.9 | 234.27 | 224.7 | 232.1 | 128677225.0 |
| 2024-07-29 | TLT | Stock | 93.67 | 93.69 | 93.22 | 93.49 | 25801347.0 |
| 2024-07-29 | ES | Stock | 64.66 | 65.37 | 64.24 | 64.94 | 2313810.0 |
| 2024-07-29 | CL | Stock | 100.8 | 101.42 | 99.77 | 100.88 | 5331655.0 |
| 2024-07-29 | A | Stock | 137.585 | 137.78 | 135.62 | 137.38 | 1203346.0 |
| 2024-07-29 | AA | Stock | 33.2 | 33.46 | 32.82 | 33.02 | 4124606.0 |
| 2024-07-29 | AACG | Stock | 0.653 | 0.6893 | 0.653 | 0.653 | 6026.0 |
| 2024-07-29 | AACT | Stock | 10.73 | 10.74 | 10.73 | 10.74 | 525258.0 |
| 2024-07-29 | AAGR-DELISTED | Stock | 0.1549 | 0.1743 | 0.1525 | 0.1695 | 642275.0 |
| 2024-07-29 | AAL | Stock | 10.56 | 10.72 | 10.37 | 10.43 | 29853886.0 |
| 2024-07-29 | AAMC-DELISTED | Stock | 2.86 | 2.87 | 2.675 | 2.675 | 1145.0 |
| 2024-07-29 | AAME | Stock | 1.53 | 1.6 | 1.5 | 1.51 | 15817.0 |
| 2024-07-29 | AAMI | Stock | 26.02 | 26.24 | 25.455 | 25.75 | 177812.0 |
| 2024-07-29 | AAN-DELISTED | Stock | 9.96 | 10.0 | 9.95 | 9.98 | 328222.0 |
| 2024-07-29 | AAOI | Stock | 8.68 | 8.93 | 8.14 | 8.22 | 1313467.0 |
| 2024-07-29 | AAON | Stock | 87.83 | 88.4499 | 86.99 | 87.46 | 338137.0 |
| 2024-07-29 | AAP | Stock | 61.0 | 61.72 | 60.595 | 60.99 | 1404801.0 |
| 2024-07-29 | AAT | Stock | 25.29 | 25.41 | 24.86 | 24.86 | 153895.0 |
| 2024-07-29 | AATC | Stock | 6.8 | 6.84 | 6.79 | 6.79 | 2511.0 |
| 2024-07-29 | AAUAF-DELISTED | Stock | 0.0501 | 0.055 | 0.05 | 0.053 | 65400.0 |
| 2024-07-29 | AAXJ | Stock | 71.2 | 71.63 | 70.81 | 71.01 | 271341.0 |
| 2024-07-29 | AB | Stock | 34.98 | 35.5 | 34.52 | 34.69 | 482547.0 |
| 2024-07-29 | ABAT | Stock | 0.99 | 1.03 | 0.9733 | 1.01 | 239933.0 |
| 2024-07-29 | ABBV | Stock | 184.04 | 186.13 | 180.53 | 181.94 | 5403646.0 |
| 2024-07-29 | ABCB | Stock | 64.88 | 64.88 | 60.91 | 61.0 | 402498.0 |
| 2024-07-29 | ABCL | Stock | 3.24 | 3.26 | 3.125 | 3.23 | 759632.0 |
| 2024-07-29 | ABEO | Stock | 5.08 | 5.2101 | 4.98 | 4.98 | 387036.0 |
| 2024-07-29 | ABEV | Stock | 2.11 | 2.12 | 2.083 | 2.11 | 22727423.0 |
| 2024-07-29 | ABG | Stock | 254.97 | 257.71 | 253.5 | 255.6 | 92086.0 |
| 2024-07-29 | ABLLW | Stock | 1.04 | 1.04 | 0.9256 | 1.0 | 49323.0 |
| 2024-07-29 | ABLV | Stock | 1.21 | 1.24 | 1.15 | 1.21 | 61029.0 |
| 2024-07-29 | ABLVW | Stock | 0.0257 | 0.0569 | 0.0202 | 0.03 | 29432.0 |
| 2024-07-29 | ABM | Stock | 55.04 | 55.6 | 54.57 | 55.12 | 334323.0 |
| 2024-07-29 | ABNB | Stock | 141.24 | 142.4299 | 140.0 | 140.29 | 2701905.0 |
| 2024-07-29 | ABOS | Stock | 3.6 | 3.6 | 3.21 | 3.29 | 540157.0 |
| 2024-07-29 | ABR | Stock | 13.7 | 13.7699 | 13.47 | 13.54 | 1903651.0 |
| 2024-07-29 | ABR.D | Stock | 17.31 | 17.5523 | 17.2505 | 17.27 | 48244.0 |
| 2024-07-29 | ABR.E | Stock | 17.45 | 17.4799 | 17.28 | 17.4 | 7695.0 |
| 2024-07-29 | ABR.F | Stock | 18.75 | 18.97 | 18.59 | 18.8 | 24694.0 |
| 2024-07-29 | ABSI | Stock | 4.55 | 4.7 | 4.3 | 4.46 | 848204.0 |
| 2024-07-29 | ABT | Stock | 100.59 | 105.175 | 99.92 | 104.77 | 19384568.0 |
| 2024-07-29 | ABTC | Stock | 70.5 | 73.65 | 68.8125 | 71.175 | 2298.733333333333 |
| 2024-07-29 | ABTS | Stock | 9.0 | 9.0 | 8.532 | 8.8125 | 8085.0 |
| 2024-07-29 | ABUS | Stock | 3.91 | 3.91 | 3.71 | 3.78 | 822872.0 |
> showing 50 of 7,191 rows — these rows as CSV