PREVIEW / stock_daily / 2024-04-17
file: by_date/stock_daily/2024/2024-04-17.parquet size: 230 KB rows: 7,196 symbols: 1,010
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-17 | AAPL | Stock | 169.61 | 170.65 | 168.0 | 168.0 | 50901200.0 |
| 2024-04-17 | MSFT | Stock | 417.25 | 418.88 | 410.33 | 411.84 | 15855500.0 |
| 2024-04-17 | NVDA | Stock | 88.34 | 88.775 | 83.95 | 84.035 | 495400000.0 |
| 2024-04-17 | AMZN | Stock | 184.31 | 184.57 | 179.82 | 181.28 | 31359700.0 |
| 2024-04-17 | GOOGL | Stock | 155.62 | 157.08 | 154.58 | 155.47 | 21763130.0 |
| 2024-04-17 | META | Stock | 503.1 | 503.16 | 487.14 | 494.17 | 12193700.0 |
| 2024-04-17 | TSLA | Stock | 157.64 | 158.33 | 153.78 | 155.45 | 82439700.0 |
| 2024-04-17 | TLT | Stock | 88.87 | 89.375 | 88.46 | 89.28 | 57946990.0 |
| 2024-04-17 | ES | Stock | 57.54 | 58.57 | 57.07 | 58.51 | 1994000.0 |
| 2024-04-17 | CL | Stock | 86.5 | 86.83 | 85.92 | 86.75 | 3886200.0 |
| 2024-04-17 | A | Stock | 137.24 | 137.46 | 132.87 | 134.55 | 2084100.0 |
| 2024-04-17 | AA | Stock | 37.16 | 37.48 | 35.21 | 35.55 | 12618800.0 |
| 2024-04-17 | AACG | Stock | 0.98 | 0.98 | 0.95 | 0.97 | 3200.0 |
| 2024-04-17 | AACIW-DELISTED | Stock | 0.145 | 0.1552 | 0.111 | 0.1122 | 115840.0 |
| 2024-04-17 | AACT | Stock | 10.61 | 10.62 | 10.61 | 10.61 | 117100.0 |
| 2024-04-17 | AAGR-DELISTED | Stock | 0.3582 | 0.4078 | 0.3508 | 0.3639 | 113774.0 |
| 2024-04-17 | AAGRW-DELISTED | Stock | 0.017 | 0.017 | 0.0125 | 0.0125 | 11952.0 |
| 2024-04-17 | AAL | Stock | 13.45 | 13.97 | 13.38 | 13.89 | 52414800.0 |
| 2024-04-17 | AAMC-DELISTED | Stock | 3.4 | 3.65 | 3.0 | 3.22 | 19800.0 |
| 2024-04-17 | AAME | Stock | 2.12 | 2.14 | 1.96 | 1.96 | 9400.0 |
| 2024-04-17 | AAMI | Stock | 22.98 | 22.98 | 22.38 | 22.41 | 192000.0 |
| 2024-04-17 | AAN-DELISTED | Stock | 7.11 | 7.17 | 7.01 | 7.09 | 216100.0 |
| 2024-04-17 | AAOI | Stock | 12.04 | 13.2 | 11.805 | 11.98 | 2541200.0 |
| 2024-04-17 | AAON | Stock | 88.86 | 88.86 | 86.03 | 86.3 | 476900.0 |
| 2024-04-17 | AAP | Stock | 72.78 | 74.5 | 72.25 | 74.05 | 1773800.0 |
| 2024-04-17 | AAT | Stock | 20.43 | 20.63 | 20.31 | 20.46 | 213800.0 |
| 2024-04-17 | AATC | Stock | 6.5 | 6.5 | 6.35 | 6.35 | 1233.0 |
| 2024-04-17 | AAUAF-DELISTED | Stock | 0.121 | 0.125 | 0.11 | 0.12215 | 121617.0 |
| 2024-04-17 | AAXJ | Stock | 65.89 | 66.01 | 65.41 | 65.56 | 415584.0 |
| 2024-04-17 | AB | Stock | 32.93 | 33.32 | 32.31 | 32.45 | 201400.0 |
| 2024-04-17 | ABAT | Stock | 1.51 | 1.58 | 1.39 | 1.43 | 684543.0 |
| 2024-04-17 | ABBV | Stock | 164.15 | 164.74 | 163.23 | 164.25 | 4792200.0 |
| 2024-04-17 | ABCB | Stock | 44.67 | 45.17 | 44.43 | 44.51 | 205900.0 |
| 2024-04-17 | ABCL | Stock | 4.06 | 4.15 | 3.92 | 3.92 | 1069400.0 |
| 2024-04-17 | ABEO | Stock | 7.76 | 8.45 | 7.73 | 7.93 | 729600.0 |
| 2024-04-17 | ABEV | Stock | 2.28 | 2.28 | 2.24 | 2.26 | 15315900.0 |
| 2024-04-17 | ABG | Stock | 218.24 | 218.25 | 211.58 | 211.87 | 141500.0 |
| 2024-04-17 | ABLLW | Stock | 0.5148 | 0.595 | 0.5042 | 0.5042 | 10598.0 |
| 2024-04-17 | ABLV | Stock | 1.8 | 1.836 | 1.72 | 1.725 | 54200.0 |
| 2024-04-17 | ABLVW | Stock | 0.0455 | 0.0455 | 0.04 | 0.04 | 2223.0 |
| 2024-04-17 | ABM | Stock | 44.67 | 44.94 | 43.55 | 43.64 | 894200.0 |
| 2024-04-17 | ABNB | Stock | 158.45 | 159.7 | 156.41 | 158.37 | 3905000.0 |
| 2024-04-17 | ABOS | Stock | 3.5 | 3.63 | 3.46 | 3.47 | 150900.0 |
| 2024-04-17 | ABR | Stock | 12.25 | 12.32 | 12.12 | 12.15 | 2448400.0 |
| 2024-04-17 | ABR.D | Stock | 18.06 | 18.35 | 17.9 | 17.93 | 11863.0 |
| 2024-04-17 | ABR.E | Stock | 18.45 | 18.45 | 17.75 | 17.8406 | 5384.0 |
| 2024-04-17 | ABR.F | Stock | 18.9 | 19.205 | 18.9 | 19.02 | 21796.0 |
| 2024-04-17 | ABSI | Stock | 5.4 | 5.57 | 5.25 | 5.29 | 1155400.0 |
| 2024-04-17 | ABT | Stock | 107.53 | 108.72 | 104.25 | 105.9 | 12002900.0 |
| 2024-04-17 | ABTC | Stock | 105.0 | 106.5 | 97.5 | 101.25 | 2296.0 |
> showing 50 of 7,196 rows — these rows as CSV