PREVIEW / stock_daily / 2024-04-19
file: by_date/stock_daily/2024/2024-04-19.parquet size: 229 KB rows: 7,161 symbols: 982
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-19 | AAPL | Stock | 166.21 | 166.4 | 164.08 | 165.0 | 67772100.0 |
| 2024-04-19 | MSFT | Stock | 404.03 | 405.48 | 397.77 | 399.12 | 30276500.0 |
| 2024-04-19 | NVDA | Stock | 83.15 | 84.324 | 75.606 | 76.2 | 875198000.0 |
| 2024-04-19 | AMZN | Stock | 178.74 | 179.0 | 173.44 | 174.63 | 55950000.0 |
| 2024-04-19 | GOOGL | Stock | 156.2 | 156.36 | 152.3 | 154.09 | 32615639.0 |
| 2024-04-19 | META | Stock | 502.8 | 502.8 | 475.73 | 481.07 | 25111000.0 |
| 2024-04-19 | TSLA | Stock | 148.97 | 150.94 | 146.22 | 147.05 | 86005100.0 |
| 2024-04-19 | TLT | Stock | 89.39 | 89.39 | 88.905 | 89.15 | 44826771.0 |
| 2024-04-19 | ES | Stock | 59.12 | 59.91 | 58.98 | 59.69 | 2323400.0 |
| 2024-04-19 | CL | Stock | 86.1 | 87.26 | 85.91 | 87.13 | 6005100.0 |
| 2024-04-19 | A | Stock | 133.06 | 133.74 | 132.15 | 132.73 | 1303400.0 |
| 2024-04-19 | AA | Stock | 35.2 | 36.44 | 35.06 | 35.53 | 7996500.0 |
| 2024-04-19 | AACG | Stock | 1.03 | 1.03 | 0.92 | 0.97 | 11400.0 |
| 2024-04-19 | AACT | Stock | 10.64 | 10.64 | 10.61 | 10.61 | 9000.0 |
| 2024-04-19 | AAGR-DELISTED | Stock | 0.3769 | 0.388 | 0.3248 | 0.346 | 101860.0 |
| 2024-04-19 | AAL | Stock | 13.88 | 14.28 | 13.86 | 14.11 | 27421700.0 |
| 2024-04-19 | AAMC-DELISTED | Stock | 3.19 | 3.2 | 3.01 | 3.01 | 2900.0 |
| 2024-04-19 | AAME | Stock | 2.02 | 2.04 | 1.94 | 1.96 | 4400.0 |
| 2024-04-19 | AAMI | Stock | 22.7 | 23.094 | 22.7 | 23.0 | 174200.0 |
| 2024-04-19 | AAN-DELISTED | Stock | 7.26 | 7.49 | 7.26 | 7.48 | 196100.0 |
| 2024-04-19 | AAOI | Stock | 11.58 | 12.44 | 11.58 | 12.12 | 2104000.0 |
| 2024-04-19 | AAON | Stock | 84.92 | 86.75 | 84.27 | 85.41 | 486600.0 |
| 2024-04-19 | AAP | Stock | 77.11 | 78.79 | 76.54 | 78.69 | 1732200.0 |
| 2024-04-19 | AAT | Stock | 20.48 | 21.03 | 20.48 | 20.99 | 263000.0 |
| 2024-04-19 | AATC | Stock | 6.35 | 6.35 | 6.2 | 6.225 | 6352.0 |
| 2024-04-19 | AAUAF-DELISTED | Stock | 0.118 | 0.1246 | 0.115 | 0.121 | 39904.0 |
| 2024-04-19 | AAXJ | Stock | 65.61 | 65.71 | 65.3 | 65.49 | 510655.0 |
| 2024-04-19 | AB | Stock | 32.46 | 33.38 | 32.46 | 33.03 | 206900.0 |
| 2024-04-19 | ABAT | Stock | 1.38 | 1.38 | 1.33 | 1.34 | 349650.0 |
| 2024-04-19 | ABBV | Stock | 165.02 | 166.6 | 163.25 | 166.41 | 5532400.0 |
| 2024-04-19 | ABCB | Stock | 44.56 | 46.33 | 44.3 | 46.28 | 295600.0 |
| 2024-04-19 | ABCL | Stock | 3.85 | 3.96 | 3.79 | 3.87 | 976500.0 |
| 2024-04-19 | ABEO | Stock | 7.5 | 7.69 | 7.2 | 7.57 | 386300.0 |
| 2024-04-19 | ABEV | Stock | 2.28 | 2.31 | 2.27 | 2.29 | 13706900.0 |
| 2024-04-19 | ABG | Stock | 210.92 | 215.46 | 210.49 | 215.12 | 157000.0 |
| 2024-04-19 | ABLLW | Stock | 0.475 | 0.50175 | 0.475 | 0.50175 | 9184.0 |
| 2024-04-19 | ABLV | Stock | 1.69 | 1.74 | 1.61 | 1.61 | 74100.0 |
| 2024-04-19 | ABM | Stock | 43.73 | 44.52 | 43.73 | 44.32 | 416100.0 |
| 2024-04-19 | ABNB | Stock | 159.54 | 160.335 | 154.56 | 155.01 | 3892800.0 |
| 2024-04-19 | ABOS | Stock | 3.24 | 3.3 | 3.1 | 3.15 | 307600.0 |
| 2024-04-19 | ABR | Stock | 12.43 | 12.73 | 12.4 | 12.62 | 3124800.0 |
| 2024-04-19 | ABR.D | Stock | 18.0 | 18.1 | 17.9 | 17.9 | 12030.0 |
| 2024-04-19 | ABR.E | Stock | 17.89 | 17.9 | 17.46 | 17.75 | 7364.0 |
| 2024-04-19 | ABR.F | Stock | 18.87 | 18.89 | 18.55 | 18.61 | 16993.0 |
| 2024-04-19 | ABSI | Stock | 4.95 | 5.04 | 4.7 | 4.77 | 1258000.0 |
| 2024-04-19 | ABT | Stock | 105.98 | 107.77 | 105.38 | 107.28 | 10521800.0 |
| 2024-04-19 | ABTC | Stock | 102.75 | 105.75 | 99.0 | 102.0 | 1717.3333333333333 |
| 2024-04-19 | ABTS | Stock | 11.1 | 11.685 | 11.1 | 11.565 | 1267.0 |
| 2024-04-19 | ABUS | Stock | 2.71 | 2.81 | 2.65 | 2.72 | 931100.0 |
| 2024-04-19 | ABVC | Stock | 1.04 | 1.04 | 0.965 | 0.99 | 162800.0 |
> showing 50 of 7,161 rows — these rows as CSV