PREVIEW / stock_daily / 2024-06-17
file: by_date/stock_daily/2024/2024-06-17.parquet size: 232 KB rows: 7,270 symbols: 972
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-06-17 | AAPL | Stock | 213.37 | 218.95 | 212.72 | 216.67 | 93728300.0 |
| 2024-06-17 | MSFT | Stock | 442.59 | 450.94 | 440.72 | 448.37 | 20790000.0 |
| 2024-06-17 | NVDA | Stock | 132.99 | 133.73 | 129.58 | 130.98 | 288504400.0 |
| 2024-06-17 | AMZN | Stock | 182.52 | 185.0 | 181.22 | 184.06 | 35601900.0 |
| 2024-06-17 | GOOGL | Stock | 175.46 | 178.36 | 174.81 | 177.24 | 19618497.0 |
| 2024-06-17 | META | Stock | 501.67 | 510.75 | 496.01 | 506.63 | 11266600.0 |
| 2024-06-17 | TSLA | Stock | 177.92 | 188.81 | 177.0 | 187.44 | 109786100.0 |
| 2024-06-17 | TLT | Stock | 93.52 | 93.81 | 93.28 | 93.73 | 31040202.0 |
| 2024-06-17 | ES | Stock | 58.48 | 58.79 | 57.51 | 57.65 | 2293000.0 |
| 2024-06-17 | CL | Stock | 94.53 | 96.08 | 94.09 | 95.95 | 3445400.0 |
| 2024-06-17 | A | Stock | 131.11 | 132.07 | 129.5 | 131.83 | 2090500.0 |
| 2024-06-17 | AA | Stock | 37.52 | 37.73 | 36.9 | 37.4 | 3847300.0 |
| 2024-06-17 | AACG | Stock | 0.8 | 0.85 | 0.8 | 0.81 | 10100.0 |
| 2024-06-17 | AACT | Stock | 10.65 | 10.66 | 10.65 | 10.65 | 1263400.0 |
| 2024-06-17 | AAGR-DELISTED | Stock | 0.34 | 0.358 | 0.3101 | 0.332 | 133089.0 |
| 2024-06-17 | AAGRW-DELISTED | Stock | 0.011 | 0.0145 | 0.011 | 0.0144 | 6885.0 |
| 2024-06-17 | AAL | Stock | 11.22 | 11.49 | 11.21 | 11.44 | 30074100.0 |
| 2024-06-17 | AAMC-DELISTED | Stock | 2.36 | 2.36 | 2.15 | 2.17 | 10500.0 |
| 2024-06-17 | AAME | Stock | 1.99 | 1.99 | 1.81 | 1.9 | 6700.0 |
| 2024-06-17 | AAMI | Stock | 22.22 | 22.36 | 21.63 | 21.78 | 248100.0 |
| 2024-06-17 | AAN-DELISTED | Stock | 9.98 | 10.065 | 9.96 | 10.06 | 7118900.0 |
| 2024-06-17 | AAOI | Stock | 10.01 | 10.305 | 9.82 | 10.17 | 1385700.0 |
| 2024-06-17 | AAON | Stock | 75.99 | 80.11 | 75.47 | 79.41 | 816500.0 |
| 2024-06-17 | AAP | Stock | 63.1 | 65.15 | 62.57 | 64.17 | 1661300.0 |
| 2024-06-17 | AAT | Stock | 21.5 | 21.6 | 21.29 | 21.54 | 249100.0 |
| 2024-06-17 | AATC | Stock | 6.0 | 6.09 | 6.0 | 6.09 | 1267.0 |
| 2024-06-17 | AAUAF-DELISTED | Stock | 0.06 | 0.0695 | 0.06 | 0.062 | 31170.0 |
| 2024-06-17 | AAXJ | Stock | 71.84 | 72.285 | 71.7 | 72.22 | 288533.0 |
| 2024-06-17 | AB | Stock | 33.0 | 33.3 | 32.55 | 33.08 | 208100.0 |
| 2024-06-17 | ABAT | Stock | 1.07 | 1.09 | 1.02 | 1.03 | 449823.0 |
| 2024-06-17 | ABBV | Stock | 168.4 | 170.4 | 167.36 | 169.68 | 4076000.0 |
| 2024-06-17 | ABCB | Stock | 46.71 | 47.87 | 46.71 | 47.84 | 298600.0 |
| 2024-06-17 | ABCL | Stock | 3.22 | 3.22 | 3.03 | 3.06 | 2006200.0 |
| 2024-06-17 | ABEO | Stock | 4.55 | 4.7 | 4.43 | 4.51 | 324500.0 |
| 2024-06-17 | ABEV | Stock | 2.09 | 2.1 | 2.08 | 2.08 | 18527700.0 |
| 2024-06-17 | ABG | Stock | 228.77 | 235.76 | 228.48 | 235.75 | 102200.0 |
| 2024-06-17 | ABLLW | Stock | 0.41 | 0.48 | 0.39585 | 0.48 | 132287.0 |
| 2024-06-17 | ABLV | Stock | 1.04 | 1.15 | 1.04 | 1.07 | 4500.0 |
| 2024-06-17 | ABLVW | Stock | 0.047 | 0.0575 | 0.047 | 0.0525 | 13762.0 |
| 2024-06-17 | ABM | Stock | 49.04 | 50.86 | 48.67 | 50.56 | 695400.0 |
| 2024-06-17 | ABNB | Stock | 147.0 | 150.12 | 146.775 | 149.5 | 5158800.0 |
| 2024-06-17 | ABOS | Stock | 2.65 | 2.65 | 2.48 | 2.5 | 276200.0 |
| 2024-06-17 | ABR | Stock | 13.63 | 14.07 | 13.61 | 14.04 | 2241200.0 |
| 2024-06-17 | ABR.D | Stock | 18.7 | 18.79 | 18.5837 | 18.5837 | 8046.0 |
| 2024-06-17 | ABR.E | Stock | 18.17 | 18.17 | 18.0572 | 18.12 | 9542.0 |
| 2024-06-17 | ABR.F | Stock | 19.86 | 19.965 | 19.78 | 19.78 | 16445.0 |
| 2024-06-17 | ABSI | Stock | 3.99 | 4.015 | 3.19 | 3.41 | 3284000.0 |
| 2024-06-17 | ABT | Stock | 102.91 | 103.94 | 102.54 | 103.45 | 3936200.0 |
| 2024-06-17 | ABTC | Stock | 93.75 | 99.0 | 93.75 | 96.0 | 2598.6666666666665 |
| 2024-06-17 | ABTS | Stock | 8.835 | 9.0 | 7.605 | 8.25 | 3593.0 |
> showing 50 of 7,270 rows — these rows as CSV