PREVIEW / stock_daily / 2024-05-09
file: by_date/stock_daily/2024/2024-05-09.parquet size: 230 KB rows: 7,160 symbols: 959
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-05-09 | AAPL | Stock | 182.56 | 184.66 | 182.11 | 184.57 | 48983000.0 |
| 2024-05-09 | MSFT | Stock | 410.57 | 412.72 | 409.1 | 412.32 | 14689700.0 |
| 2024-05-09 | NVDA | Stock | 90.529 | 91.072 | 88.231 | 88.747 | 378013000.0 |
| 2024-05-09 | AMZN | Stock | 188.88 | 191.7 | 187.44 | 189.5 | 43368400.0 |
| 2024-05-09 | GOOGL | Stock | 169.39 | 170.69 | 168.18 | 169.96 | 15346700.0 |
| 2024-05-09 | META | Stock | 470.0 | 476.08 | 467.63 | 475.42 | 9437700.0 |
| 2024-05-09 | TSLA | Stock | 175.01 | 175.62 | 171.37 | 171.97 | 65950300.0 |
| 2024-05-09 | TLT | Stock | 89.87 | 90.77 | 89.82 | 90.63 | 39606723.0 |
| 2024-05-09 | ES | Stock | 60.94 | 61.86 | 60.66 | 61.76 | 1376500.0 |
| 2024-05-09 | CL | Stock | 93.75 | 94.32 | 93.51 | 94.08 | 4639600.0 |
| 2024-05-09 | A | Stock | 143.11 | 145.48 | 142.82 | 145.14 | 1254000.0 |
| 2024-05-09 | AA | Stock | 36.86 | 37.69 | 36.47 | 37.36 | 4989000.0 |
| 2024-05-09 | AACG | Stock | 0.87 | 0.98 | 0.87 | 0.9 | 2900.0 |
| 2024-05-09 | AACIW-DELISTED | Stock | 0.14 | 0.16 | 0.14 | 0.157 | 337520.0 |
| 2024-05-09 | AACT | Stock | 10.635 | 10.635 | 10.62 | 10.62 | 13000.0 |
| 2024-05-09 | AAGR-DELISTED | Stock | 0.41 | 0.4408 | 0.4 | 0.4302 | 49137.0 |
| 2024-05-09 | AAGRW-DELISTED | Stock | 0.01275 | 0.0135 | 0.01275 | 0.0134 | 1654.0 |
| 2024-05-09 | AAL | Stock | 14.36 | 14.63 | 14.32 | 14.48 | 23590200.0 |
| 2024-05-09 | AAMC-DELISTED | Stock | 2.85 | 3.01 | 2.83 | 2.86 | 3900.0 |
| 2024-05-09 | AAME | Stock | 1.78 | 1.99 | 1.78 | 1.87 | 6900.0 |
| 2024-05-09 | AAMI | Stock | 22.56 | 23.17 | 22.56 | 23.11 | 180600.0 |
| 2024-05-09 | AAN-DELISTED | Stock | 7.59 | 7.6 | 7.365 | 7.43 | 195600.0 |
| 2024-05-09 | AAOI | Stock | 10.79 | 11.07 | 10.42 | 10.54 | 3191700.0 |
| 2024-05-09 | AAON | Stock | 77.18 | 78.0 | 76.68 | 77.75 | 634500.0 |
| 2024-05-09 | AAP | Stock | 74.54 | 75.82 | 74.0 | 75.64 | 766600.0 |
| 2024-05-09 | AAT | Stock | 22.21 | 22.31 | 22.06 | 22.2 | 152800.0 |
| 2024-05-09 | AATC | Stock | 6.63 | 6.65 | 6.61 | 6.65 | 1731.0 |
| 2024-05-09 | AAUAF-DELISTED | Stock | 0.119 | 0.14 | 0.118 | 0.12995 | 95330.0 |
| 2024-05-09 | AAXJ | Stock | 70.43 | 70.695 | 70.33 | 70.65 | 599968.0 |
| 2024-05-09 | AB | Stock | 32.36 | 33.07 | 32.26 | 33.01 | 190200.0 |
| 2024-05-09 | ABAT | Stock | 1.35 | 1.38 | 1.33 | 1.36 | 259606.0 |
| 2024-05-09 | ABBV | Stock | 160.81 | 161.32 | 160.02 | 160.4 | 3570000.0 |
| 2024-05-09 | ABCB | Stock | 49.84 | 50.12 | 49.38 | 50.07 | 242200.0 |
| 2024-05-09 | ABCL | Stock | 3.86 | 4.015 | 3.85 | 3.95 | 1021000.0 |
| 2024-05-09 | ABEO | Stock | 4.47 | 4.7 | 4.33 | 4.45 | 526700.0 |
| 2024-05-09 | ABEV | Stock | 2.34 | 2.36 | 2.32 | 2.34 | 7472500.0 |
| 2024-05-09 | ABG | Stock | 221.01 | 226.63 | 220.31 | 226.28 | 136100.0 |
| 2024-05-09 | ABLLW | Stock | 0.56 | 0.599 | 0.55 | 0.56 | 14047.0 |
| 2024-05-09 | ABLV | Stock | 1.4 | 1.65 | 1.34 | 1.6 | 19100.0 |
| 2024-05-09 | ABM | Stock | 44.97 | 45.4 | 44.63 | 45.37 | 1110600.0 |
| 2024-05-09 | ABNB | Stock | 146.6 | 150.005 | 145.57 | 147.05 | 14802600.0 |
| 2024-05-09 | ABOS | Stock | 3.42 | 3.64 | 3.404 | 3.57 | 173300.0 |
| 2024-05-09 | ABR | Stock | 13.33 | 13.4 | 12.6 | 12.84 | 14004400.0 |
| 2024-05-09 | ABR.D | Stock | 18.5 | 18.5319 | 18.0 | 18.08 | 18731.0 |
| 2024-05-09 | ABR.E | Stock | 18.1126 | 18.215 | 17.63 | 17.72 | 17259.0 |
| 2024-05-09 | ABR.F | Stock | 19.5263 | 19.5263 | 18.805 | 18.925 | 26103.0 |
| 2024-05-09 | ABSI | Stock | 4.98 | 5.16 | 4.94 | 5.14 | 496500.0 |
| 2024-05-09 | ABT | Stock | 104.73 | 105.01 | 104.5 | 104.67 | 5902000.0 |
| 2024-05-09 | ABTC | Stock | 121.5 | 121.5 | 112.5 | 116.25 | 2829.3333333333335 |
| 2024-05-09 | ABTS | Stock | 12.135 | 12.375 | 12.105 | 12.21 | 773.0 |
> showing 50 of 7,160 rows — these rows as CSV