PREVIEW / stock_daily / 2024-07-17
file: by_date/stock_daily/2024/2024-07-17.parquet size: 245 KB rows: 7,176 symbols: 896
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-17 | AAPL | Stock | 229.45 | 231.4599 | 226.64 | 228.88 | 55794059.0 |
| 2024-07-17 | MSFT | Stock | 442.59 | 444.85 | 439.18 | 443.52 | 21267819.0 |
| 2024-07-17 | NVDA | Stock | 121.35 | 121.85 | 116.72 | 117.99 | 382651729.0 |
| 2024-07-17 | AMZN | Stock | 191.35 | 191.58 | 185.99 | 187.93 | 48315738.0 |
| 2024-07-17 | GOOGL | Stock | 182.965 | 183.55 | 179.9 | 181.02 | 20734071.0 |
| 2024-07-17 | META | Stock | 479.17 | 479.17 | 459.12 | 461.99 | 27867614.0 |
| 2024-07-17 | TSLA | Stock | 252.73 | 258.47 | 246.182 | 248.5 | 115169051.0 |
| 2024-07-17 | TLT | Stock | 93.92 | 94.4 | 93.69 | 94.19 | 29036838.0 |
| 2024-07-17 | ES | Stock | 59.74 | 61.805 | 59.64 | 61.55 | 2556775.0 |
| 2024-07-17 | CL | Stock | 97.96 | 99.63 | 97.74 | 99.39 | 4060329.0 |
| 2024-07-17 | A | Stock | 135.16 | 136.0 | 133.42 | 133.5 | 999523.0 |
| 2024-07-17 | AA | Stock | 38.24 | 38.68 | 36.81 | 36.81 | 7544786.0 |
| 2024-07-17 | AACG | Stock | 0.5511 | 0.6665 | 0.5511 | 0.5851 | 150320.0 |
| 2024-07-17 | AACIW-DELISTED | Stock | 0.153 | 0.165 | 0.1109 | 0.111 | 162204.0 |
| 2024-07-17 | AACT | Stock | 10.705 | 10.71 | 10.69 | 10.69 | 58114.0 |
| 2024-07-17 | AAGR-DELISTED | Stock | 0.185 | 0.185 | 0.1771 | 0.182 | 378615.0 |
| 2024-07-17 | AAL | Stock | 10.99 | 11.11 | 10.835 | 11.01 | 32042607.0 |
| 2024-07-17 | AAMC-DELISTED | Stock | 2.43 | 2.55 | 2.43 | 2.55 | 2215.0 |
| 2024-07-17 | AAME | Stock | 1.6637 | 1.72 | 1.6354 | 1.71 | 7234.0 |
| 2024-07-17 | AAMI | Stock | 24.75 | 25.25 | 24.75 | 25.02 | 164315.0 |
| 2024-07-17 | AAN-DELISTED | Stock | 9.97 | 9.985 | 9.97 | 9.97 | 376815.0 |
| 2024-07-17 | AAOI | Stock | 11.29 | 11.95 | 10.5801 | 10.955 | 2593846.0 |
| 2024-07-17 | AAON | Stock | 94.13 | 94.1615 | 88.15 | 88.18 | 775636.0 |
| 2024-07-17 | AAP | Stock | 63.03 | 64.92 | 62.2105 | 64.44 | 1367782.0 |
| 2024-07-17 | AAT | Stock | 24.56 | 25.12 | 24.51 | 24.54 | 343300.0 |
| 2024-07-17 | AATC | Stock | 6.33 | 6.65 | 6.29 | 6.65 | 3617.0 |
| 2024-07-17 | AAUAF-DELISTED | Stock | 0.051 | 0.0526 | 0.0505 | 0.0523 | 28626.0 |
| 2024-07-17 | AAXJ | Stock | 73.74 | 73.905 | 73.385 | 73.42 | 1264483.0 |
| 2024-07-17 | AB | Stock | 33.72 | 34.1 | 33.67 | 33.76 | 234040.0 |
| 2024-07-17 | ABAT | Stock | 1.12 | 1.13 | 1.06 | 1.08 | 469468.0 |
| 2024-07-17 | ABBV | Stock | 169.51 | 175.74 | 169.51 | 175.27 | 6912568.0 |
| 2024-07-17 | ABCB | Stock | 58.08 | 60.53 | 58.08 | 59.28 | 549473.0 |
| 2024-07-17 | ABCL | Stock | 3.4 | 3.6 | 3.3613 | 3.37 | 1203174.0 |
| 2024-07-17 | ABEO | Stock | 5.28 | 5.52 | 5.17 | 5.42 | 543444.0 |
| 2024-07-17 | ABEV | Stock | 2.16 | 2.2 | 2.15 | 2.18 | 20675035.0 |
| 2024-07-17 | ABG | Stock | 256.23 | 258.005 | 254.7 | 255.84 | 169702.0 |
| 2024-07-17 | ABLLW | Stock | 0.65 | 0.67 | 0.6 | 0.67 | 9816.0 |
| 2024-07-17 | ABLV | Stock | 1.15 | 1.265 | 1.15 | 1.265 | 636.0 |
| 2024-07-17 | ABM | Stock | 52.69 | 54.03 | 52.585 | 53.76 | 488280.0 |
| 2024-07-17 | ABNB | Stock | 149.24 | 150.1 | 147.26 | 148.0 | 3213372.0 |
| 2024-07-17 | ABOS | Stock | 3.11 | 3.2 | 3.07 | 3.07 | 492757.0 |
| 2024-07-17 | ABR | Stock | 13.5 | 14.04 | 13.26 | 13.49 | 6095523.0 |
| 2024-07-17 | ABR.D | Stock | 17.99 | 18.1099 | 17.805 | 17.94 | 37786.0 |
| 2024-07-17 | ABR.E | Stock | 17.5 | 17.6513 | 17.4 | 17.45 | 15804.0 |
| 2024-07-17 | ABR.F | Stock | 18.89 | 19.09 | 18.51 | 18.77 | 59263.0 |
| 2024-07-17 | ABSI | Stock | 4.26 | 4.5 | 4.18 | 4.38 | 2130534.0 |
| 2024-07-17 | ABT | Stock | 102.65 | 105.65 | 102.5 | 104.68 | 11055286.0 |
| 2024-07-17 | ABTC | Stock | 84.0 | 84.75 | 79.5 | 81.75 | 3371.4666666666667 |
| 2024-07-17 | ABTS | Stock | 8.175 | 8.175 | 7.65 | 7.86 | 458.0 |
| 2024-07-17 | ABUS | Stock | 3.8 | 3.8299 | 3.67 | 3.78 | 1226964.0 |
> showing 50 of 7,176 rows — these rows as CSV