PREVIEW / stock_daily / 2024-06-14
file: by_date/stock_daily/2024/2024-06-14.parquet size: 231 KB rows: 7,216 symbols: 950
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-14 | AAPL | Stock | 213.85 | 215.17 | 211.3 | 212.49 | 70122700.0 |
| 2024-06-14 | MSFT | Stock | 438.28 | 443.14 | 436.72 | 442.57 | 13582000.0 |
| 2024-06-14 | NVDA | Stock | 129.96 | 132.84 | 128.32 | 131.88 | 309320400.0 |
| 2024-06-14 | AMZN | Stock | 183.08 | 183.72 | 182.23 | 183.66 | 25456400.0 |
| 2024-06-14 | GOOGL | Stock | 174.22 | 177.0623 | 174.15 | 176.79 | 18063555.0 |
| 2024-06-14 | META | Stock | 502.65 | 507.15 | 500.75 | 504.16 | 10243300.0 |
| 2024-06-14 | TSLA | Stock | 185.8 | 186.0 | 176.92 | 178.01 | 82038200.0 |
| 2024-06-14 | TLT | Stock | 94.42 | 94.84 | 94.24 | 94.67 | 28776710.0 |
| 2024-06-14 | ES | Stock | 58.4 | 59.15 | 58.02 | 59.01 | 1677400.0 |
| 2024-06-14 | CL | Stock | 94.5 | 94.72 | 93.83 | 94.62 | 2722800.0 |
| 2024-06-14 | A | Stock | 130.0 | 130.74 | 129.24 | 129.85 | 2163300.0 |
| 2024-06-14 | AA | Stock | 37.86 | 38.15 | 37.21 | 37.9 | 3228400.0 |
| 2024-06-14 | AACG | Stock | 0.81 | 0.87 | 0.81 | 0.84 | 3400.0 |
| 2024-06-14 | AACIW-DELISTED | Stock | 0.1284 | 0.13 | 0.1254 | 0.13 | 38484.0 |
| 2024-06-14 | AACT | Stock | 10.66 | 10.662 | 10.65 | 10.66 | 143500.0 |
| 2024-06-14 | AAGR-DELISTED | Stock | 0.3592 | 0.3592 | 0.31 | 0.34 | 82159.0 |
| 2024-06-14 | AAGRW-DELISTED | Stock | 0.0131 | 0.0131 | 0.0131 | 0.0131 | 100.0 |
| 2024-06-14 | AAL | Stock | 11.32 | 11.36 | 11.09 | 11.28 | 42272500.0 |
| 2024-06-14 | AAMC-DELISTED | Stock | 2.331 | 2.331 | 2.23 | 2.305 | 1700.0 |
| 2024-06-14 | AAME | Stock | 1.9 | 1.92 | 1.78 | 1.83 | 11100.0 |
| 2024-06-14 | AAMI | Stock | 22.22 | 22.52 | 22.15 | 22.41 | 270500.0 |
| 2024-06-14 | AAN-DELISTED | Stock | 7.58 | 7.66 | 7.46 | 7.54 | 265700.0 |
| 2024-06-14 | AAOI | Stock | 10.05 | 10.23 | 9.82 | 10.08 | 1182800.0 |
| 2024-06-14 | AAON | Stock | 74.23 | 76.68 | 73.54 | 75.96 | 868000.0 |
| 2024-06-14 | AAP | Stock | 63.27 | 63.62 | 60.8 | 63.42 | 1885700.0 |
| 2024-06-14 | AAT | Stock | 21.62 | 21.77 | 21.46 | 21.65 | 369000.0 |
| 2024-06-14 | AATC | Stock | 6.11 | 6.11 | 5.815 | 5.86 | 30233.0 |
| 2024-06-14 | AAUAF-DELISTED | Stock | 0.0646 | 0.0688 | 0.0639 | 0.065 | 30436.0 |
| 2024-06-14 | AAXJ | Stock | 71.67 | 71.7 | 71.345 | 71.7 | 244222.0 |
| 2024-06-14 | AB | Stock | 32.92 | 33.22 | 32.81 | 33.01 | 150500.0 |
| 2024-06-14 | ABAT | Stock | 1.17 | 1.18 | 1.03 | 1.06 | 629783.0 |
| 2024-06-14 | ABBV | Stock | 166.47 | 169.24 | 166.0 | 168.59 | 4377600.0 |
| 2024-06-14 | ABCB | Stock | 46.89 | 47.11 | 46.49 | 46.79 | 240600.0 |
| 2024-06-14 | ABCL | Stock | 3.32 | 3.38 | 3.22 | 3.23 | 1224900.0 |
| 2024-06-14 | ABEO | Stock | 4.64 | 4.65 | 4.51 | 4.57 | 232300.0 |
| 2024-06-14 | ABEV | Stock | 2.05 | 2.11 | 2.05 | 2.11 | 20650500.0 |
| 2024-06-14 | ABG | Stock | 229.6 | 231.37 | 225.96 | 229.93 | 198800.0 |
| 2024-06-14 | ABLLW | Stock | 0.38 | 0.43 | 0.3775 | 0.43 | 52500.0 |
| 2024-06-14 | ABLV | Stock | 1.095 | 1.095 | 1.02 | 1.02 | 1000.0 |
| 2024-06-14 | ABLVW | Stock | 0.0586 | 0.0586 | 0.0254 | 0.0475 | 13984.0 |
| 2024-06-14 | ABM | Stock | 50.01 | 50.42 | 49.14 | 49.17 | 589500.0 |
| 2024-06-14 | ABNB | Stock | 145.5 | 146.05 | 144.28 | 145.97 | 2754600.0 |
| 2024-06-14 | ABOS | Stock | 2.63 | 2.66 | 2.57 | 2.64 | 205100.0 |
| 2024-06-14 | ABR | Stock | 13.65 | 13.81 | 13.6 | 13.69 | 1195300.0 |
| 2024-06-14 | ABR.D | Stock | 18.56 | 18.6 | 18.53 | 18.5999 | 6008.0 |
| 2024-06-14 | ABR.E | Stock | 18.39 | 18.42 | 18.16 | 18.16 | 3602.0 |
| 2024-06-14 | ABR.F | Stock | 19.95 | 20.07 | 19.87 | 19.87 | 4876.0 |
| 2024-06-14 | ABSI | Stock | 4.35 | 4.37 | 3.92 | 3.98 | 1763500.0 |
| 2024-06-14 | ABT | Stock | 103.29 | 103.72 | 102.43 | 103.68 | 3683100.0 |
| 2024-06-14 | ABTC | Stock | 96.0 | 97.5 | 93.75 | 97.5 | 3041.3333333333335 |
> showing 50 of 7,216 rows — these rows as CSV