PREVIEW / stock_daily / 2024-08-15
file: by_date/stock_daily/2024/2024-08-15.parquet size: 246 KB rows: 7,188 symbols: 825
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-15 | AAPL | Stock | 224.6 | 225.35 | 222.76 | 224.72 | 44889083.0 |
| 2024-08-15 | MSFT | Stock | 419.8 | 421.11 | 417.66 | 421.03 | 18963704.0 |
| 2024-08-15 | NVDA | Stock | 118.76 | 123.24 | 117.47 | 122.86 | 313269196.0 |
| 2024-08-15 | AMZN | Stock | 174.86 | 177.91 | 173.99 | 177.59 | 51077431.0 |
| 2024-08-15 | GOOGL | Stock | 160.5 | 161.635 | 159.61 | 161.3 | 31524252.0 |
| 2024-08-15 | META | Stock | 531.79 | 539.77 | 526.7 | 537.33 | 12987148.0 |
| 2024-08-15 | TSLA | Stock | 205.02 | 215.88 | 204.82 | 214.14 | 88686657.0 |
| 2024-08-15 | TLT | Stock | 96.405 | 97.1 | 96.21 | 97.1 | 38723695.0 |
| 2024-08-15 | ES | Stock | 65.51 | 65.925 | 64.66 | 64.85 | 3559276.0 |
| 2024-08-15 | CL | Stock | 102.48 | 102.96 | 101.16 | 101.44 | 3224428.0 |
| 2024-08-15 | A | Stock | 137.66 | 139.99 | 137.66 | 139.89 | 1095255.0 |
| 2024-08-15 | AA | Stock | 31.74 | 32.355 | 31.67 | 32.09 | 4997864.0 |
| 2024-08-15 | AACG | Stock | 0.611 | 0.6248 | 0.60245 | 0.61 | 2188.0 |
| 2024-08-15 | AACIU | Stock | 11.05 | 11.05 | 10.5 | 11.0 | 1960.0 |
| 2024-08-15 | AACT | Stock | 10.751 | 10.77 | 10.75 | 10.77 | 415336.0 |
| 2024-08-15 | AAGR-DELISTED | Stock | 0.1286 | 0.1286 | 0.1218 | 0.1233 | 158257.0 |
| 2024-08-15 | AAGRW-DELISTED | Stock | 0.009 | 0.009 | 0.009 | 0.009 | 476.0 |
| 2024-08-15 | AAL | Stock | 9.96 | 10.16 | 9.95 | 10.09 | 32214646.0 |
| 2024-08-15 | AAMC-DELISTED | Stock | 2.59 | 2.75 | 2.39 | 2.56 | 10090.0 |
| 2024-08-15 | AAME | Stock | 1.546 | 1.55 | 1.5456 | 1.55 | 1571.0 |
| 2024-08-15 | AAMI | Stock | 23.51 | 23.54 | 23.1 | 23.3 | 130944.0 |
| 2024-08-15 | AAN-DELISTED | Stock | 10.08 | 10.085 | 10.06 | 10.08 | 774939.0 |
| 2024-08-15 | AAOI | Stock | 8.3 | 8.59 | 8.2 | 8.53 | 1400668.0 |
| 2024-08-15 | AAON | Stock | 89.96 | 90.23 | 88.24 | 89.37 | 287518.0 |
| 2024-08-15 | AAP | Stock | 62.12 | 63.12 | 61.43 | 62.39 | 1158134.0 |
| 2024-08-15 | AAT | Stock | 25.21 | 25.65 | 25.01 | 25.39 | 297826.0 |
| 2024-08-15 | AATC | Stock | 7.32 | 7.51 | 7.32 | 7.51 | 12185.0 |
| 2024-08-15 | AAUAF-DELISTED | Stock | 0.0451 | 0.052 | 0.0451 | 0.0514 | 106761.0 |
| 2024-08-15 | AAXJ | Stock | 71.47 | 72.1 | 71.47 | 71.95 | 139459.0 |
| 2024-08-15 | AB | Stock | 34.74 | 35.06 | 34.47 | 34.63 | 482524.0 |
| 2024-08-15 | ABAT | Stock | 1.08 | 1.0899 | 1.04 | 1.05 | 175661.0 |
| 2024-08-15 | ABBV | Stock | 194.49 | 194.99 | 191.29 | 193.4 | 4580972.0 |
| 2024-08-15 | ABCB | Stock | 57.61 | 58.29 | 57.06 | 57.09 | 216839.0 |
| 2024-08-15 | ABCL | Stock | 2.66 | 2.73 | 2.61 | 2.62 | 1321726.0 |
| 2024-08-15 | ABEO | Stock | 4.95 | 5.31 | 4.94 | 5.0 | 345166.0 |
| 2024-08-15 | ABEV | Stock | 2.35 | 2.43 | 2.335 | 2.41 | 92185421.0 |
| 2024-08-15 | ABG | Stock | 232.34 | 236.27 | 230.04 | 231.99 | 152045.0 |
| 2024-08-15 | ABLLW | Stock | 1.2554 | 1.4 | 1.225 | 1.25 | 47537.0 |
| 2024-08-15 | ABLV | Stock | 1.39 | 1.51 | 1.36 | 1.39 | 29487.0 |
| 2024-08-15 | ABM | Stock | 54.3 | 54.52 | 53.605 | 54.45 | 297253.0 |
| 2024-08-15 | ABNB | Stock | 118.195 | 119.133 | 116.37 | 118.88 | 5215974.0 |
| 2024-08-15 | ABOS | Stock | 2.61 | 2.69 | 2.5401 | 2.575 | 141614.0 |
| 2024-08-15 | ABR | Stock | 13.71 | 13.965 | 13.58 | 13.84 | 5859209.0 |
| 2024-08-15 | ABR.D | Stock | 17.5 | 17.75 | 17.4632 | 17.73 | 33594.0 |
| 2024-08-15 | ABR.E | Stock | 17.4706 | 17.5767 | 17.4706 | 17.5767 | 9622.0 |
| 2024-08-15 | ABR.F | Stock | 18.5 | 18.59 | 18.4001 | 18.5 | 17459.0 |
| 2024-08-15 | ABSI | Stock | 3.74 | 4.345 | 3.74 | 4.14 | 2113825.0 |
| 2024-08-15 | ABT | Stock | 110.47 | 111.33 | 109.76 | 110.94 | 7116914.0 |
| 2024-08-15 | ABTC | Stock | 55.5 | 56.6025 | 53.25 | 54.2625 | 2681.0666666666666 |
| 2024-08-15 | ABTS | Stock | 7.4805 | 8.25 | 7.0785 | 7.8675 | 15674.0 |
> showing 50 of 7,188 rows — these rows as CSV