PREVIEW / stock_daily / 2024-03-14
file: by_date/stock_daily/2024/2024-03-14.parquet size: 233 KB rows: 7,255 symbols: 1,065
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-03-14 | AAPL | Stock | 172.91 | 174.31 | 172.05 | 173.0 | 72913500.0 |
| 2024-03-14 | MSFT | Stock | 420.24 | 427.82 | 417.99 | 425.22 | 34157300.0 |
| 2024-03-14 | NVDA | Stock | 89.577 | 90.646 | 86.6 | 87.944 | 602318000.0 |
| 2024-03-14 | AMZN | Stock | 177.69 | 179.53 | 176.47 | 178.75 | 43705800.0 |
| 2024-03-14 | GOOGL | Stock | 141.19 | 143.585 | 140.455 | 143.1 | 42753387.0 |
| 2024-03-14 | META | Stock | 500.26 | 501.35 | 488.16 | 491.83 | 12620000.0 |
| 2024-03-14 | TSLA | Stock | 167.77 | 171.17 | 160.51 | 162.5 | 126325700.0 |
| 2024-03-14 | TLT | Stock | 93.73 | 93.75 | 92.86 | 92.97 | 58365563.0 |
| 2024-03-14 | ES | Stock | 58.95 | 59.13 | 57.76 | 59.06 | 2950300.0 |
| 2024-03-14 | CL | Stock | 88.86 | 89.05 | 88.09 | 88.35 | 4895500.0 |
| 2024-03-14 | A | Stock | 147.9 | 148.25 | 144.29 | 145.21 | 2098200.0 |
| 2024-03-14 | AA | Stock | 30.38 | 30.65 | 29.61 | 30.02 | 5678500.0 |
| 2024-03-14 | AACG | Stock | 1.57 | 1.61 | 1.57 | 1.61 | 23300.0 |
| 2024-03-14 | AACIW-DELISTED | Stock | 0.02695 | 0.02695 | 0.02695 | 0.02695 | 1916.0 |
| 2024-03-14 | AACT | Stock | 10.56 | 10.56 | 10.555 | 10.56 | 282600.0 |
| 2024-03-14 | AAGR-DELISTED | Stock | 0.48 | 0.55 | 0.47 | 0.51 | 546774.0 |
| 2024-03-14 | AAGRW-DELISTED | Stock | 0.0136 | 0.0192 | 0.0136 | 0.01635 | 1562.0 |
| 2024-03-14 | AAL | Stock | 13.96 | 14.03 | 13.78 | 13.99 | 24683800.0 |
| 2024-03-14 | AAMC-DELISTED | Stock | 3.51 | 3.55 | 3.17 | 3.44 | 14100.0 |
| 2024-03-14 | AAME | Stock | 2.92 | 2.92 | 2.67 | 2.79 | 3500.0 |
| 2024-03-14 | AAMI | Stock | 22.31 | 22.68 | 22.31 | 22.66 | 212400.0 |
| 2024-03-14 | AAN-DELISTED | Stock | 7.0 | 7.01 | 6.86 | 6.95 | 309800.0 |
| 2024-03-14 | AAOI | Stock | 13.55 | 13.66 | 12.8 | 12.92 | 2240800.0 |
| 2024-03-14 | AAON | Stock | 80.2 | 81.46 | 79.94 | 81.3 | 406500.0 |
| 2024-03-14 | AAP | Stock | 80.01 | 80.14 | 77.81 | 79.53 | 2579700.0 |
| 2024-03-14 | AAT | Stock | 21.1 | 21.1 | 20.66 | 21.01 | 396700.0 |
| 2024-03-14 | AATC | Stock | 7.4 | 7.63 | 7.27 | 7.34 | 12501.0 |
| 2024-03-14 | AAU-DELISTED | Stock | 0.14 | 0.142 | 0.14 | 0.1412 | 287854.0 |
| 2024-03-14 | AAUAF-DELISTED | Stock | 0.14 | 0.142 | 0.14 | 0.1412 | 267726.0 |
| 2024-03-14 | AAXJ | Stock | 68.38 | 68.46 | 67.79 | 67.97 | 392349.0 |
| 2024-03-14 | AB | Stock | 34.14 | 34.22 | 33.05 | 33.37 | 459800.0 |
| 2024-03-14 | ABAT | Stock | 1.91 | 2.195 | 1.89 | 2.18 | 641206.0 |
| 2024-03-14 | ABBV | Stock | 180.16 | 182.04 | 178.66 | 181.2 | 6999400.0 |
| 2024-03-14 | ABCB | Stock | 45.74 | 45.93 | 44.77 | 45.37 | 437000.0 |
| 2024-03-14 | ABCL | Stock | 4.93 | 4.93 | 4.67 | 4.7 | 1529500.0 |
| 2024-03-14 | ABEO | Stock | 8.18 | 8.38 | 7.96 | 8.14 | 212700.0 |
| 2024-03-14 | ABEV | Stock | 2.54 | 2.55 | 2.52 | 2.52 | 10962000.0 |
| 2024-03-14 | ABG | Stock | 208.49 | 210.28 | 202.98 | 204.7 | 302400.0 |
| 2024-03-14 | ABLLW | Stock | 0.61 | 0.6477 | 0.563 | 0.6424 | 19222.0 |
| 2024-03-14 | ABLV | Stock | 3.0 | 3.03 | 3.0 | 3.01 | 7700.0 |
| 2024-03-14 | ABM | Stock | 41.96 | 42.23 | 41.54 | 41.69 | 823000.0 |
| 2024-03-14 | ABNB | Stock | 165.74 | 166.72 | 162.72 | 166.44 | 5078100.0 |
| 2024-03-14 | ABOS | Stock | 4.29 | 4.35 | 4.055 | 4.09 | 262300.0 |
| 2024-03-14 | ABR | Stock | 12.94 | 13.0 | 12.57 | 12.68 | 3563800.0 |
| 2024-03-14 | ABR.D | Stock | 18.09 | 18.35 | 17.963 | 18.1345 | 31963.0 |
| 2024-03-14 | ABR.E | Stock | 18.59 | 18.6 | 18.11 | 18.54 | 3280.0 |
| 2024-03-14 | ABR.F | Stock | 19.1 | 19.1 | 19.01 | 19.08 | 16072.0 |
| 2024-03-14 | ABSI | Stock | 5.07 | 5.197 | 4.65 | 4.79 | 1100800.0 |
| 2024-03-14 | ABT | Stock | 120.01 | 120.34 | 117.85 | 118.85 | 4952200.0 |
| 2024-03-14 | ABTC | Stock | 131.25 | 131.25 | 114.0 | 117.0 | 5949.333333333333 |
> showing 50 of 7,255 rows — these rows as CSV