PREVIEW / stock_daily / 2024-04-18
file: by_date/stock_daily/2024/2024-04-18.parquet size: 229 KB rows: 7,165 symbols: 976
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-18 | AAPL | Stock | 168.03 | 168.64 | 166.55 | 167.04 | 43122900.0 |
| 2024-04-18 | MSFT | Stock | 410.63 | 411.89 | 403.95 | 404.27 | 21029900.0 |
| 2024-04-18 | NVDA | Stock | 84.97 | 86.19 | 82.402 | 84.671 | 447260000.0 |
| 2024-04-18 | AMZN | Stock | 181.47 | 182.39 | 178.65 | 179.22 | 30723800.0 |
| 2024-04-18 | GOOGL | Stock | 155.34 | 156.94 | 154.62 | 156.01 | 19883044.0 |
| 2024-04-18 | META | Stock | 499.82 | 512.21 | 499.04 | 501.8 | 14808700.0 |
| 2024-04-18 | TSLA | Stock | 151.25 | 152.2 | 148.7 | 149.93 | 96098800.0 |
| 2024-04-18 | TLT | Stock | 89.24 | 89.27 | 88.59 | 88.83 | 43839454.0 |
| 2024-04-18 | ES | Stock | 58.77 | 59.19 | 58.08 | 58.99 | 1626200.0 |
| 2024-04-18 | CL | Stock | 87.0 | 87.31 | 86.4 | 86.71 | 4880800.0 |
| 2024-04-18 | A | Stock | 131.26 | 134.44 | 128.34 | 132.44 | 1936600.0 |
| 2024-04-18 | AA | Stock | 35.51 | 36.4 | 33.84 | 35.47 | 11608400.0 |
| 2024-04-18 | AACG | Stock | 0.98 | 1.04 | 0.91 | 1.03 | 20900.0 |
| 2024-04-18 | AACIW-DELISTED | Stock | 0.12995 | 0.1416 | 0.1172 | 0.1172 | 1641.0 |
| 2024-04-18 | AACT | Stock | 10.6 | 10.63 | 10.6 | 10.63 | 804200.0 |
| 2024-04-18 | AAGR-DELISTED | Stock | 0.3785 | 0.394 | 0.3511 | 0.381 | 27231.0 |
| 2024-04-18 | AAL | Stock | 14.04 | 14.34 | 13.96 | 14.02 | 34966400.0 |
| 2024-04-18 | AAMC-DELISTED | Stock | 3.34 | 3.47 | 2.9 | 3.09 | 9600.0 |
| 2024-04-18 | AAME | Stock | 2.01 | 2.07 | 1.9 | 1.95 | 3500.0 |
| 2024-04-18 | AAMI | Stock | 22.6 | 22.89 | 22.48 | 22.7 | 179900.0 |
| 2024-04-18 | AAN-DELISTED | Stock | 7.13 | 7.34 | 7.075 | 7.31 | 254300.0 |
| 2024-04-18 | AAOI | Stock | 11.93 | 12.6 | 11.6 | 11.66 | 2350300.0 |
| 2024-04-18 | AAON | Stock | 86.91 | 87.65 | 84.83 | 85.24 | 395700.0 |
| 2024-04-18 | AAP | Stock | 75.04 | 77.34 | 74.46 | 77.2 | 2123200.0 |
| 2024-04-18 | AAT | Stock | 20.59 | 20.82 | 20.4 | 20.56 | 257000.0 |
| 2024-04-18 | AATC | Stock | 6.35 | 6.46 | 6.35 | 6.37 | 2482.0 |
| 2024-04-18 | AAUAF-DELISTED | Stock | 0.12 | 0.1213 | 0.115 | 0.1213 | 46482.0 |
| 2024-04-18 | AAXJ | Stock | 65.89 | 66.28 | 65.76 | 65.95 | 456763.0 |
| 2024-04-18 | AB | Stock | 32.65 | 32.94 | 32.32 | 32.47 | 148400.0 |
| 2024-04-18 | ABAT | Stock | 1.44 | 1.4495 | 1.21 | 1.36 | 734490.0 |
| 2024-04-18 | ABBV | Stock | 164.96 | 167.44 | 164.43 | 164.66 | 4480100.0 |
| 2024-04-18 | ABCB | Stock | 44.48 | 45.2 | 44.43 | 44.79 | 278000.0 |
| 2024-04-18 | ABCL | Stock | 3.95 | 3.97 | 3.84 | 3.91 | 765600.0 |
| 2024-04-18 | ABEO | Stock | 7.95 | 8.17 | 7.51 | 7.53 | 246000.0 |
| 2024-04-18 | ABEV | Stock | 2.26 | 2.29 | 2.23 | 2.28 | 18909200.0 |
| 2024-04-18 | ABG | Stock | 212.91 | 216.23 | 211.1 | 211.49 | 143100.0 |
| 2024-04-18 | ABLLW | Stock | 0.49 | 0.5 | 0.47 | 0.48 | 22779.0 |
| 2024-04-18 | ABLV | Stock | 1.691 | 1.78 | 1.68 | 1.685 | 63000.0 |
| 2024-04-18 | ABM | Stock | 43.72 | 44.06 | 43.27 | 43.8 | 489600.0 |
| 2024-04-18 | ABNB | Stock | 159.6 | 162.94 | 159.21 | 160.1 | 3930400.0 |
| 2024-04-18 | ABOS | Stock | 3.43 | 3.48 | 3.11 | 3.16 | 636700.0 |
| 2024-04-18 | ABR | Stock | 12.23 | 12.59 | 12.17 | 12.48 | 4455200.0 |
| 2024-04-18 | ABR.D | Stock | 18.0 | 18.24 | 17.9001 | 17.9952 | 9479.0 |
| 2024-04-18 | ABR.E | Stock | 17.83 | 17.91 | 17.83 | 17.89 | 2304.0 |
| 2024-04-18 | ABR.F | Stock | 18.97 | 19.0299 | 18.69 | 18.71 | 19945.0 |
| 2024-04-18 | ABSI | Stock | 5.26 | 5.38 | 4.95 | 4.97 | 1102300.0 |
| 2024-04-18 | ABT | Stock | 106.5 | 107.03 | 104.47 | 105.27 | 7306400.0 |
| 2024-04-18 | ABTC | Stock | 105.0 | 109.95 | 100.5 | 104.25 | 1313.3333333333333 |
| 2024-04-18 | ABTS | Stock | 10.845 | 11.37 | 10.845 | 11.37 | 1507.0 |
| 2024-04-18 | ABUS | Stock | 2.78 | 2.8 | 2.69 | 2.73 | 1016800.0 |
> showing 50 of 7,165 rows — these rows as CSV