PREVIEW / stock_daily / 2024-04-22
file: by_date/stock_daily/2024/2024-04-22.parquet size: 229 KB rows: 7,169 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-22 | AAPL | Stock | 165.52 | 167.26 | 164.77 | 165.84 | 48116400.0 |
| 2024-04-22 | MSFT | Stock | 400.08 | 402.85 | 395.75 | 400.96 | 20286900.0 |
| 2024-04-22 | NVDA | Stock | 78.104 | 80.073 | 76.4 | 79.518 | 596341000.0 |
| 2024-04-22 | AMZN | Stock | 176.94 | 178.87 | 174.56 | 177.23 | 37924900.0 |
| 2024-04-22 | GOOGL | Stock | 154.31 | 157.64 | 154.06 | 156.28 | 26446206.0 |
| 2024-04-22 | META | Stock | 489.72 | 492.01 | 473.4 | 481.73 | 17271100.0 |
| 2024-04-22 | TSLA | Stock | 140.56 | 144.44 | 138.8 | 142.05 | 107097600.0 |
| 2024-04-22 | TLT | Stock | 88.68 | 89.12 | 88.645 | 89.0 | 24969046.0 |
| 2024-04-22 | ES | Stock | 59.68 | 60.85 | 59.46 | 60.3 | 1559400.0 |
| 2024-04-22 | CL | Stock | 87.4 | 88.73 | 87.24 | 88.33 | 3954100.0 |
| 2024-04-22 | A | Stock | 133.54 | 135.02 | 131.78 | 133.91 | 850500.0 |
| 2024-04-22 | AA | Stock | 35.73 | 36.64 | 35.25 | 36.35 | 7838900.0 |
| 2024-04-22 | AACG | Stock | 0.99 | 1.01 | 0.87 | 0.89 | 12600.0 |
| 2024-04-22 | AACT | Stock | 10.61 | 10.625 | 10.61 | 10.61 | 70300.0 |
| 2024-04-22 | AAGR-DELISTED | Stock | 0.337 | 0.3459 | 0.3095 | 0.32 | 70664.0 |
| 2024-04-22 | AAGRW-DELISTED | Stock | 0.0169 | 0.0169 | 0.0143 | 0.0143 | 1444.0 |
| 2024-04-22 | AAL | Stock | 14.28 | 14.68 | 14.18 | 14.53 | 27763800.0 |
| 2024-04-22 | AAMC-DELISTED | Stock | 3.01 | 3.86 | 3.01 | 3.25 | 41900.0 |
| 2024-04-22 | AAME | Stock | 1.92 | 2.08 | 1.91 | 1.96 | 10600.0 |
| 2024-04-22 | AAMI | Stock | 23.13 | 23.54 | 22.94 | 23.3 | 188600.0 |
| 2024-04-22 | AAN-DELISTED | Stock | 7.5 | 7.55 | 7.32 | 7.37 | 315700.0 |
| 2024-04-22 | AAOI | Stock | 12.11 | 12.16 | 10.72 | 11.13 | 2482800.0 |
| 2024-04-22 | AAON | Stock | 85.86 | 87.87 | 85.6 | 86.73 | 344800.0 |
| 2024-04-22 | AAP | Stock | 79.21 | 79.41 | 76.56 | 77.22 | 2041600.0 |
| 2024-04-22 | AAT | Stock | 20.98 | 21.41 | 20.91 | 21.28 | 232500.0 |
| 2024-04-22 | AATC | Stock | 6.33 | 6.35 | 6.22 | 6.34 | 6321.0 |
| 2024-04-22 | AAUAF-DELISTED | Stock | 0.118 | 0.1246 | 0.112 | 0.1222 | 200274.0 |
| 2024-04-22 | AAXJ | Stock | 65.84 | 66.455 | 65.652 | 66.35 | 595964.0 |
| 2024-04-22 | AB | Stock | 33.09 | 33.73 | 33.0 | 33.65 | 224300.0 |
| 2024-04-22 | ABAT | Stock | 1.34 | 1.36 | 1.26 | 1.34 | 624498.0 |
| 2024-04-22 | ABBV | Stock | 167.68 | 169.59 | 166.92 | 167.89 | 5580700.0 |
| 2024-04-22 | ABCB | Stock | 46.32 | 47.22 | 46.12 | 46.77 | 238900.0 |
| 2024-04-22 | ABCL | Stock | 3.89 | 4.01 | 3.83 | 4.01 | 1076200.0 |
| 2024-04-22 | ABEO | Stock | 7.63 | 7.73 | 7.26 | 7.36 | 1028000.0 |
| 2024-04-22 | ABEV | Stock | 2.3 | 2.33 | 2.28 | 2.3 | 12017400.0 |
| 2024-04-22 | ABG | Stock | 215.08 | 218.81 | 214.5 | 216.86 | 152200.0 |
| 2024-04-22 | ABLLW | Stock | 0.5016 | 0.52 | 0.47668 | 0.5199 | 32329.0 |
| 2024-04-22 | ABLV | Stock | 1.641 | 1.65 | 1.595 | 1.61 | 43600.0 |
| 2024-04-22 | ABM | Stock | 44.5 | 44.87 | 44.37 | 44.46 | 504800.0 |
| 2024-04-22 | ABNB | Stock | 156.19 | 157.25 | 153.765 | 156.61 | 3030000.0 |
| 2024-04-22 | ABOS | Stock | 3.21 | 3.259 | 3.12 | 3.13 | 479000.0 |
| 2024-04-22 | ABR | Stock | 12.62 | 12.85 | 12.56 | 12.76 | 2635800.0 |
| 2024-04-22 | ABR.D | Stock | 17.9 | 18.1807 | 17.77 | 17.92 | 15581.0 |
| 2024-04-22 | ABR.E | Stock | 17.75 | 17.75 | 17.5 | 17.65 | 4071.0 |
| 2024-04-22 | ABR.F | Stock | 18.64 | 18.64 | 18.42 | 18.43 | 32673.0 |
| 2024-04-22 | ABSI | Stock | 4.77 | 4.88 | 4.48 | 4.51 | 1622800.0 |
| 2024-04-22 | ABT | Stock | 107.48 | 107.9 | 106.27 | 107.07 | 4948300.0 |
| 2024-04-22 | ABTC | Stock | 112.5 | 114.0 | 102.0 | 104.25 | 17430.666666666668 |
| 2024-04-22 | ABTS | Stock | 11.565 | 11.565 | 11.04 | 11.04 | 473.0 |
| 2024-04-22 | ABUS | Stock | 2.73 | 2.77 | 2.64 | 2.64 | 740400.0 |
> showing 50 of 7,169 rows — these rows as CSV