PREVIEW / stock_daily / 2024-02-21
file: by_date/stock_daily/2024/2024-02-21.parquet size: 233 KB rows: 7,265 symbols: 1,118
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-02-21 | AAPL | Stock | 181.94 | 182.89 | 180.66 | 182.32 | 41529700.0 |
| 2024-02-21 | MSFT | Stock | 400.17 | 402.29 | 397.22 | 402.18 | 18631100.0 |
| 2024-02-21 | NVDA | Stock | 68.006 | 68.888 | 66.248 | 67.472 | 690298000.0 |
| 2024-02-21 | AMZN | Stock | 168.94 | 170.23 | 167.14 | 168.59 | 44575600.0 |
| 2024-02-21 | GOOGL | Stock | 141.45 | 142.69 | 140.675 | 142.55 | 23315687.0 |
| 2024-02-21 | META | Stock | 466.5 | 469.0 | 461.79 | 468.03 | 12977100.0 |
| 2024-02-21 | TSLA | Stock | 193.36 | 199.44 | 191.95 | 194.77 | 103844000.0 |
| 2024-02-21 | TLT | Stock | 92.83 | 92.895 | 92.0063 | 92.18 | 36404244.0 |
| 2024-02-21 | ES | Stock | 57.81 | 59.36 | 57.53 | 58.42 | 3286400.0 |
| 2024-02-21 | CL | Stock | 84.99 | 85.6 | 84.92 | 85.31 | 3369000.0 |
| 2024-02-21 | A | Stock | 133.36 | 135.45 | 133.17 | 135.33 | 1134700.0 |
| 2024-02-21 | AA | Stock | 27.12 | 28.04 | 27.07 | 27.96 | 5642100.0 |
| 2024-02-21 | AACG | Stock | 1.25 | 1.34 | 1.25 | 1.34 | 6400.0 |
| 2024-02-21 | AAGR-DELISTED | Stock | 0.85 | 0.85 | 0.786 | 0.8 | 56344.0 |
| 2024-02-21 | AAGRW-DELISTED | Stock | 0.015 | 0.015 | 0.015 | 0.015 | 5000.0 |
| 2024-02-21 | AAL | Stock | 14.59 | 14.86 | 14.57 | 14.79 | 23032400.0 |
| 2024-02-21 | AAMC-DELISTED | Stock | 4.35 | 4.51 | 4.35 | 4.4 | 2300.0 |
| 2024-02-21 | AAME | Stock | 2.57 | 2.58 | 2.56 | 2.58 | 1500.0 |
| 2024-02-21 | AAMI | Stock | 22.39 | 22.746 | 22.275 | 22.49 | 299500.0 |
| 2024-02-21 | AAN-DELISTED | Stock | 10.46 | 10.55 | 10.27 | 10.37 | 144100.0 |
| 2024-02-21 | AAOI | Stock | 19.0 | 19.6 | 18.48 | 19.19 | 2534500.0 |
| 2024-02-21 | AAON | Stock | 81.48 | 81.97 | 81.01 | 81.91 | 396300.0 |
| 2024-02-21 | AAP | Stock | 61.08 | 62.29 | 60.43 | 61.17 | 1434800.0 |
| 2024-02-21 | AAT | Stock | 21.58 | 21.93 | 21.58 | 21.86 | 587300.0 |
| 2024-02-21 | AATC | Stock | 7.2 | 7.45 | 7.1 | 7.45 | 9989.0 |
| 2024-02-21 | AAU-DELISTED | Stock | 0.135 | 0.1389 | 0.135 | 0.1351 | 81802.0 |
| 2024-02-21 | AAUAF-DELISTED | Stock | 0.135 | 0.1389 | 0.135 | 0.137 | 83862.0 |
| 2024-02-21 | AAXJ | Stock | 66.11 | 66.345 | 65.96 | 66.15 | 592281.0 |
| 2024-02-21 | AB | Stock | 32.43 | 32.86 | 32.33 | 32.55 | 132000.0 |
| 2024-02-21 | ABAT | Stock | 1.96 | 2.005 | 1.85 | 1.91 | 507527.0 |
| 2024-02-21 | ABBV | Stock | 176.29 | 176.63 | 173.5 | 175.14 | 3819100.0 |
| 2024-02-21 | ABCB | Stock | 46.41 | 46.56 | 46.07 | 46.4 | 513200.0 |
| 2024-02-21 | ABCL | Stock | 5.25 | 5.252 | 4.65 | 4.81 | 3579300.0 |
| 2024-02-21 | ABEO | Stock | 6.69 | 6.95 | 6.48 | 6.75 | 212800.0 |
| 2024-02-21 | ABEV | Stock | 2.58 | 2.6 | 2.56 | 2.6 | 12866700.0 |
| 2024-02-21 | ABG | Stock | 207.5 | 211.0 | 205.99 | 208.79 | 150900.0 |
| 2024-02-21 | ABLLW | Stock | 0.87 | 0.88 | 0.835 | 0.8728 | 21458.0 |
| 2024-02-21 | ABLV | Stock | 2.718 | 2.96 | 2.488 | 2.95 | 58500.0 |
| 2024-02-21 | ABM | Stock | 40.41 | 40.82 | 39.8 | 39.99 | 613900.0 |
| 2024-02-21 | ABNB | Stock | 145.98 | 149.26 | 145.396 | 149.24 | 4570800.0 |
| 2024-02-21 | ABOS | Stock | 3.33 | 3.48 | 3.29 | 3.35 | 326600.0 |
| 2024-02-21 | ABR | Stock | 13.3 | 13.42 | 13.01 | 13.08 | 5526300.0 |
| 2024-02-21 | ABR.D | Stock | 18.12 | 18.19 | 17.9 | 17.95 | 15306.0 |
| 2024-02-21 | ABR.E | Stock | 18.2 | 18.2 | 18.02 | 18.02 | 4519.0 |
| 2024-02-21 | ABR.F | Stock | 18.63 | 18.835 | 18.5601 | 18.77 | 16101.0 |
| 2024-02-21 | ABSI | Stock | 4.7 | 5.0 | 4.67 | 4.915 | 740000.0 |
| 2024-02-21 | ABT | Stock | 115.96 | 117.98 | 115.96 | 117.87 | 6144600.0 |
| 2024-02-21 | ABTC | Stock | 165.75 | 190.125 | 156.525 | 184.5 | 5628.0 |
| 2024-02-21 | ABTS | Stock | 14.49 | 15.15 | 14.49 | 14.49 | 547.0 |
| 2024-02-21 | ABUS | Stock | 2.87 | 2.9 | 2.84 | 2.88 | 1002900.0 |
> showing 50 of 7,265 rows — these rows as CSV