PREVIEW / stock_daily / 2024-04-05
file: by_date/stock_daily/2024/2024-04-05.parquet size: 233 KB rows: 7,231 symbols: 1,019
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-04-05 | AAPL | Stock | 169.59 | 170.39 | 168.95 | 169.58 | 42055200.0 |
| 2024-04-05 | MSFT | Stock | 420.01 | 426.51 | 418.32 | 425.52 | 16544300.0 |
| 2024-04-05 | NVDA | Stock | 86.866 | 88.481 | 85.926 | 88.008 | 399678000.0 |
| 2024-04-05 | AMZN | Stock | 182.38 | 186.27 | 181.97 | 185.07 | 42335200.0 |
| 2024-04-05 | GOOGL | Stock | 150.03 | 153.42 | 149.6 | 152.5 | 23459246.0 |
| 2024-04-05 | META | Stock | 516.86 | 530.7 | 514.41 | 527.34 | 19242000.0 |
| 2024-04-05 | TSLA | Stock | 169.08 | 170.86 | 160.51 | 164.9 | 141250700.0 |
| 2024-04-05 | TLT | Stock | 91.69 | 92.18 | 91.38 | 91.39 | 42495899.0 |
| 2024-04-05 | ES | Stock | 58.55 | 58.85 | 58.06 | 58.51 | 1426100.0 |
| 2024-04-05 | CL | Stock | 87.73 | 88.12 | 87.15 | 87.88 | 3479600.0 |
| 2024-04-05 | A | Stock | 144.18 | 145.5 | 143.43 | 144.12 | 1655800.0 |
| 2024-04-05 | AA | Stock | 35.77 | 36.72 | 35.645 | 36.49 | 4506000.0 |
| 2024-04-05 | AACG | Stock | 1.08 | 1.1 | 1.01 | 1.06 | 48200.0 |
| 2024-04-05 | AACIU | Stock | 11.07 | 11.1 | 11.01 | 11.01 | 924.0 |
| 2024-04-05 | AACIW-DELISTED | Stock | 0.1 | 0.1307 | 0.1 | 0.1304 | 99623.0 |
| 2024-04-05 | AACT | Stock | 10.56 | 10.575 | 10.56 | 10.575 | 15000.0 |
| 2024-04-05 | AAGR-DELISTED | Stock | 0.291 | 0.3125 | 0.291 | 0.3039 | 89353.0 |
| 2024-04-05 | AAGRW-DELISTED | Stock | 0.0114 | 0.0115 | 0.0114 | 0.0115 | 734.0 |
| 2024-04-05 | AAL | Stock | 13.83 | 13.94 | 13.7 | 13.76 | 30612400.0 |
| 2024-04-05 | AAMC-DELISTED | Stock | 3.39 | 3.97 | 3.19 | 3.97 | 15000.0 |
| 2024-04-05 | AAME | Stock | 2.22 | 2.26 | 2.19 | 2.19 | 2200.0 |
| 2024-04-05 | AAMI | Stock | 22.74 | 23.02 | 22.51 | 22.92 | 142100.0 |
| 2024-04-05 | AAN-DELISTED | Stock | 7.21 | 7.255 | 7.1 | 7.2 | 141000.0 |
| 2024-04-05 | AAOI | Stock | 12.81 | 13.04 | 12.52 | 12.52 | 1695800.0 |
| 2024-04-05 | AAON | Stock | 85.75 | 89.99 | 85.75 | 89.92 | 471600.0 |
| 2024-04-05 | AAP | Stock | 79.11 | 79.96 | 76.78 | 77.34 | 1638700.0 |
| 2024-04-05 | AAT | Stock | 20.74 | 20.87 | 20.63 | 20.77 | 133500.0 |
| 2024-04-05 | AATC | Stock | 6.535 | 6.598 | 6.5 | 6.598 | 1623.0 |
| 2024-04-05 | AAUAF-DELISTED | Stock | 0.12 | 0.138 | 0.103 | 0.109 | 659612.0 |
| 2024-04-05 | AAXJ | Stock | 67.8 | 68.135 | 67.6 | 67.97 | 706708.0 |
| 2024-04-05 | AB | Stock | 34.12 | 34.66 | 34.02 | 34.3 | 212900.0 |
| 2024-04-05 | ABAT | Stock | 1.8 | 1.8 | 1.72 | 1.76 | 577279.0 |
| 2024-04-05 | ABBV | Stock | 168.0 | 171.04 | 167.29 | 170.0 | 7029700.0 |
| 2024-04-05 | ABCB | Stock | 46.59 | 47.25 | 46.53 | 47.03 | 260200.0 |
| 2024-04-05 | ABCL | Stock | 4.36 | 4.45 | 4.26 | 4.34 | 769300.0 |
| 2024-04-05 | ABEO | Stock | 7.64 | 7.82 | 7.32 | 7.44 | 218300.0 |
| 2024-04-05 | ABEV | Stock | 2.45 | 2.45 | 2.36 | 2.41 | 28569600.0 |
| 2024-04-05 | ABG | Stock | 221.47 | 224.61 | 220.68 | 224.06 | 140100.0 |
| 2024-04-05 | ABLLW | Stock | 0.566 | 0.6 | 0.5525 | 0.6 | 38750.0 |
| 2024-04-05 | ABLV | Stock | 2.05 | 2.43 | 1.81 | 2.42 | 417000.0 |
| 2024-04-05 | ABM | Stock | 44.44 | 44.57 | 43.93 | 44.15 | 751100.0 |
| 2024-04-05 | ABNB | Stock | 159.15 | 162.71 | 158.9 | 161.77 | 2225600.0 |
| 2024-04-05 | ABOS | Stock | 3.8 | 3.94 | 3.73 | 3.85 | 138100.0 |
| 2024-04-05 | ABR | Stock | 12.76 | 12.99 | 12.68 | 12.96 | 1613100.0 |
| 2024-04-05 | ABR.D | Stock | 19.66 | 19.7 | 19.58 | 19.64 | 5952.0 |
| 2024-04-05 | ABR.E | Stock | 19.7499 | 19.7499 | 19.6 | 19.63 | 972.0 |
| 2024-04-05 | ABR.F | Stock | 20.1 | 20.2899 | 20.08 | 20.09 | 9632.0 |
| 2024-04-05 | ABSI | Stock | 5.53 | 5.74 | 5.44 | 5.74 | 952100.0 |
| 2024-04-05 | ABT | Stock | 109.7 | 111.26 | 109.54 | 111.2 | 5590300.0 |
| 2024-04-05 | ABTC | Stock | 93.0 | 101.10000000000001 | 93.0 | 96.75 | 3350.6666666666665 |
> showing 50 of 7,231 rows — these rows as CSV