PREVIEW / stock_daily / 2024-04-09
file: by_date/stock_daily/2024/2024-04-09.parquet size: 232 KB rows: 7,247 symbols: 1,035
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-09 | AAPL | Stock | 168.7 | 170.08 | 168.35 | 169.67 | 42451200.0 |
| 2024-04-09 | MSFT | Stock | 426.44 | 427.74 | 421.62 | 426.28 | 12512300.0 |
| 2024-04-09 | NVDA | Stock | 87.442 | 87.635 | 83.022 | 85.354 | 503547000.0 |
| 2024-04-09 | AMZN | Stock | 187.24 | 187.34 | 184.2 | 185.67 | 36546900.0 |
| 2024-04-09 | GOOGL | Stock | 156.085 | 158.56 | 155.19 | 156.6 | 31113013.0 |
| 2024-04-09 | META | Stock | 522.23 | 525.87 | 506.74 | 516.9 | 10881400.0 |
| 2024-04-09 | TSLA | Stock | 172.91 | 179.22 | 171.92 | 176.88 | 103232700.0 |
| 2024-04-09 | TLT | Stock | 91.869 | 92.36 | 91.835 | 92.23 | 32537023.0 |
| 2024-04-09 | ES | Stock | 59.57 | 60.44 | 59.43 | 59.96 | 1862100.0 |
| 2024-04-09 | CL | Stock | 88.27 | 88.33 | 87.21 | 87.65 | 3176300.0 |
| 2024-04-09 | A | Stock | 146.0 | 147.43 | 145.5 | 147.4 | 873700.0 |
| 2024-04-09 | AA | Stock | 37.1 | 37.47 | 36.28 | 36.82 | 4750900.0 |
| 2024-04-09 | AACG | Stock | 1.06 | 1.16 | 1.01 | 1.05 | 64800.0 |
| 2024-04-09 | AACIW-DELISTED | Stock | 0.207 | 0.207 | 0.16 | 0.16 | 189530.0 |
| 2024-04-09 | AACT | Stock | 10.58 | 10.59 | 10.58 | 10.59 | 47200.0 |
| 2024-04-09 | AAGR-DELISTED | Stock | 0.3557 | 0.4498 | 0.35 | 0.4498 | 600725.0 |
| 2024-04-09 | AAGRW-DELISTED | Stock | 0.0172 | 0.0175 | 0.0126 | 0.0127 | 12807.0 |
| 2024-04-09 | AAL | Stock | 13.96 | 14.07 | 13.88 | 13.95 | 27841900.0 |
| 2024-04-09 | AAMC-DELISTED | Stock | 3.74 | 4.01 | 3.5 | 3.61 | 2300.0 |
| 2024-04-09 | AAME | Stock | 2.2 | 2.22 | 2.11 | 2.11 | 2300.0 |
| 2024-04-09 | AAMI | Stock | 23.07 | 23.07 | 22.72 | 22.94 | 107300.0 |
| 2024-04-09 | AAN-DELISTED | Stock | 7.27 | 7.63 | 7.27 | 7.61 | 179200.0 |
| 2024-04-09 | AAOI | Stock | 12.51 | 12.52 | 12.01 | 12.1 | 1959200.0 |
| 2024-04-09 | AAON | Stock | 92.88 | 93.17 | 87.37 | 89.58 | 870400.0 |
| 2024-04-09 | AAP | Stock | 78.21 | 79.85 | 78.02 | 78.46 | 1208700.0 |
| 2024-04-09 | AAT | Stock | 21.46 | 22.28 | 21.35 | 22.27 | 337900.0 |
| 2024-04-09 | AATC | Stock | 6.31 | 6.6 | 6.3 | 6.6 | 5126.0 |
| 2024-04-09 | AAUAF-DELISTED | Stock | 0.12 | 0.13 | 0.119 | 0.119 | 112523.0 |
| 2024-04-09 | AAXJ | Stock | 68.68 | 68.89 | 68.47 | 68.83 | 489156.0 |
| 2024-04-09 | AB | Stock | 34.99 | 35.1 | 34.1 | 34.47 | 211400.0 |
| 2024-04-09 | ABAT | Stock | 1.86 | 1.9 | 1.8 | 1.85 | 341164.0 |
| 2024-04-09 | ABBV | Stock | 169.73 | 170.55 | 167.4 | 170.14 | 5934000.0 |
| 2024-04-09 | ABCB | Stock | 47.54 | 48.04 | 47.54 | 47.72 | 360000.0 |
| 2024-04-09 | ABCL | Stock | 4.51 | 4.75 | 4.47 | 4.73 | 1299000.0 |
| 2024-04-09 | ABEO | Stock | 7.53 | 7.68 | 7.18 | 7.44 | 128400.0 |
| 2024-04-09 | ABEV | Stock | 2.44 | 2.46 | 2.43 | 2.45 | 7459900.0 |
| 2024-04-09 | ABG | Stock | 224.82 | 230.8 | 224.82 | 229.98 | 153900.0 |
| 2024-04-09 | ABLLW | Stock | 0.58 | 0.58 | 0.5101 | 0.58 | 5408.0 |
| 2024-04-09 | ABLV | Stock | 2.06 | 2.21 | 2.025 | 2.21 | 150600.0 |
| 2024-04-09 | ABM | Stock | 44.31 | 44.47 | 43.72 | 43.77 | 637300.0 |
| 2024-04-09 | ABNB | Stock | 161.55 | 163.205 | 159.91 | 162.66 | 2291000.0 |
| 2024-04-09 | ABOS | Stock | 3.91 | 3.975 | 3.8 | 3.84 | 216800.0 |
| 2024-04-09 | ABR | Stock | 13.0 | 13.07 | 12.9 | 12.99 | 2519600.0 |
| 2024-04-09 | ABR.D | Stock | 19.64 | 19.7 | 19.5 | 19.57 | 7403.0 |
| 2024-04-09 | ABR.E | Stock | 19.865 | 19.88 | 19.75 | 19.75 | 5850.0 |
| 2024-04-09 | ABR.F | Stock | 19.95 | 19.9997 | 19.85 | 19.95 | 5008.0 |
| 2024-04-09 | ABSI | Stock | 5.61 | 6.72 | 5.61 | 6.585 | 3301600.0 |
| 2024-04-09 | ABT | Stock | 110.59 | 112.57 | 110.58 | 112.44 | 4235700.0 |
| 2024-04-09 | ABTC | Stock | 115.5 | 141.75 | 113.25 | 133.5 | 26953.333333333332 |
| 2024-04-09 | ABTS | Stock | 10.755 | 11.4 | 9.45 | 10.65 | 29133.0 |
> showing 50 of 7,247 rows — these rows as CSV