PREVIEW / stock_daily / 2024-08-26
file: by_date/stock_daily/2024/2024-08-26.parquet size: 245 KB rows: 7,181 symbols: 809
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-26 | AAPL | Stock | 226.76 | 227.28 | 223.8905 | 227.18 | 27778761.0 |
| 2024-08-26 | MSFT | Stock | 416.365 | 417.2799 | 411.34 | 413.49 | 11192074.0 |
| 2024-08-26 | NVDA | Stock | 129.57 | 131.26 | 124.37 | 126.46 | 322371271.0 |
| 2024-08-26 | AMZN | Stock | 176.7 | 177.4682 | 174.3 | 175.5 | 22140886.0 |
| 2024-08-26 | GOOGL | Stock | 166.38 | 167.55 | 164.455 | 166.16 | 14190417.0 |
| 2024-08-26 | META | Stock | 527.6 | 528.0 | 514.95 | 521.12 | 8973523.0 |
| 2024-08-26 | TSLA | Stock | 218.75 | 219.09 | 211.01 | 213.21 | 59062276.0 |
| 2024-08-26 | TLT | Stock | 98.69 | 98.6975 | 98.08 | 98.14 | 23198710.0 |
| 2024-08-26 | ES | Stock | 67.0 | 67.23 | 66.65 | 66.97 | 1386617.0 |
| 2024-08-26 | CL | Stock | 104.07 | 105.23 | 104.05 | 105.09 | 2385760.0 |
| 2024-08-26 | A | Stock | 141.11 | 141.18 | 139.96 | 140.49 | 993417.0 |
| 2024-08-26 | AA | Stock | 35.0 | 35.18 | 34.47 | 34.56 | 5279853.0 |
| 2024-08-26 | AACG | Stock | 0.5805 | 0.6395 | 0.58 | 0.61 | 43464.0 |
| 2024-08-26 | AACT | Stock | 10.74 | 10.76 | 10.74 | 10.75 | 2535739.0 |
| 2024-08-26 | AAGR-DELISTED | Stock | 0.14 | 0.1499 | 0.138 | 0.145 | 284255.0 |
| 2024-08-26 | AAGRW-DELISTED | Stock | 0.0095 | 0.0096 | 0.0095 | 0.0095 | 532.0 |
| 2024-08-26 | AAL | Stock | 10.43 | 10.445 | 10.2 | 10.21 | 20768264.0 |
| 2024-08-26 | AAMC-DELISTED | Stock | 2.37 | 2.37 | 2.34 | 2.34 | 63692.0 |
| 2024-08-26 | AAME | Stock | 1.61 | 1.61 | 1.5401 | 1.6 | 1410.0 |
| 2024-08-26 | AAMI | Stock | 23.89 | 23.89 | 23.51 | 23.59 | 142407.0 |
| 2024-08-26 | AAN-DELISTED | Stock | 10.09 | 10.095 | 10.08 | 10.08 | 326294.0 |
| 2024-08-26 | AAOI | Stock | 9.78 | 9.81 | 9.43 | 9.62 | 1376356.0 |
| 2024-08-26 | AAON | Stock | 94.98 | 95.5999 | 93.72 | 93.85 | 269275.0 |
| 2024-08-26 | AAP | Stock | 49.71 | 49.83 | 48.36 | 49.11 | 3417081.0 |
| 2024-08-26 | AAT | Stock | 26.91 | 27.04 | 26.54 | 26.55 | 158529.0 |
| 2024-08-26 | AATC | Stock | 7.2 | 7.45 | 7.15 | 7.4175 | 8300.0 |
| 2024-08-26 | AAUAF-DELISTED | Stock | 0.04928 | 0.04928 | 0.0462 | 0.0462 | 31978.0 |
| 2024-08-26 | AAXJ | Stock | 73.4 | 73.4 | 72.83 | 72.96 | 100066.0 |
| 2024-08-26 | AB | Stock | 34.97 | 35.15 | 34.55 | 34.93 | 208439.0 |
| 2024-08-26 | ABAT | Stock | 1.07 | 1.1 | 1.04 | 1.08 | 314966.0 |
| 2024-08-26 | ABBV | Stock | 197.56 | 197.9699 | 196.07 | 197.44 | 3780274.0 |
| 2024-08-26 | ABCB | Stock | 62.56 | 62.835 | 61.07 | 61.25 | 242704.0 |
| 2024-08-26 | ABCL | Stock | 2.63 | 2.7 | 2.59 | 2.69 | 1177784.0 |
| 2024-08-26 | ABEO | Stock | 5.6 | 5.76 | 5.49 | 5.74 | 341991.0 |
| 2024-08-26 | ABEV | Stock | 2.39 | 2.42 | 2.375 | 2.39 | 27322001.0 |
| 2024-08-26 | ABG | Stock | 245.05 | 245.948 | 243.03 | 244.06 | 161218.0 |
| 2024-08-26 | ABLLW | Stock | 1.4 | 1.44 | 1.375 | 1.4 | 18793.0 |
| 2024-08-26 | ABLV | Stock | 1.69 | 1.77 | 1.61 | 1.61 | 4816.0 |
| 2024-08-26 | ABM | Stock | 55.88 | 56.55 | 55.7 | 55.79 | 292710.0 |
| 2024-08-26 | ABNB | Stock | 116.85 | 117.39 | 115.35 | 115.71 | 4488733.0 |
| 2024-08-26 | ABOS | Stock | 3.0 | 3.01 | 2.9 | 2.94 | 125900.0 |
| 2024-08-26 | ABR | Stock | 13.4 | 13.57 | 13.3777 | 13.51 | 2130837.0 |
| 2024-08-26 | ABR.D | Stock | 17.7372 | 17.94 | 17.65 | 17.7599 | 22152.0 |
| 2024-08-26 | ABR.E | Stock | 17.512 | 17.53 | 17.41 | 17.45 | 11977.0 |
| 2024-08-26 | ABR.F | Stock | 18.28 | 18.34 | 18.1101 | 18.19 | 31289.0 |
| 2024-08-26 | ABSI | Stock | 4.49 | 4.6 | 4.42 | 4.49 | 659090.0 |
| 2024-08-26 | ABT | Stock | 112.735 | 113.255 | 112.06 | 112.7 | 3127280.0 |
| 2024-08-26 | ABTC | Stock | 58.5 | 58.5 | 55.282500000000006 | 57.3375 | 4104.333333333333 |
| 2024-08-26 | ABTS | Stock | 7.47 | 7.566 | 7.29 | 7.3365 | 674.0 |
| 2024-08-26 | ABUS | Stock | 3.938 | 3.94 | 3.865 | 3.87 | 764131.0 |
> showing 50 of 7,181 rows — these rows as CSV