PREVIEW / stock_daily / 2024-05-22
file: by_date/stock_daily/2024/2024-05-22.parquet size: 232 KB rows: 7,239 symbols: 978
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-05-22 | AAPL | Stock | 192.27 | 192.82 | 190.27 | 190.9 | 34648500.0 |
| 2024-05-22 | MSFT | Stock | 430.09 | 432.41 | 427.13 | 430.52 | 18073700.0 |
| 2024-05-22 | NVDA | Stock | 95.459 | 96.02 | 93.249 | 94.95 | 548648000.0 |
| 2024-05-22 | AMZN | Stock | 183.88 | 185.22 | 181.97 | 183.13 | 28148800.0 |
| 2024-05-22 | GOOGL | Stock | 176.644 | 177.15 | 175.21 | 176.38 | 17880042.0 |
| 2024-05-22 | META | Stock | 467.87 | 473.72 | 465.65 | 467.78 | 10078600.0 |
| 2024-05-22 | TSLA | Stock | 182.85 | 183.8 | 178.12 | 180.11 | 88313500.0 |
| 2024-05-22 | TLT | Stock | 91.27 | 91.7799 | 91.26 | 91.7 | 38073722.0 |
| 2024-05-22 | ES | Stock | 60.65 | 61.05 | 59.76 | 59.81 | 1565600.0 |
| 2024-05-22 | CL | Stock | 94.87 | 95.08 | 94.51 | 94.76 | 3849900.0 |
| 2024-05-22 | A | Stock | 153.58 | 154.49 | 152.64 | 152.87 | 1231300.0 |
| 2024-05-22 | AA | Stock | 42.97 | 42.97 | 41.8 | 42.15 | 6324200.0 |
| 2024-05-22 | AACG | Stock | 0.95 | 0.95 | 0.91 | 0.91 | 3500.0 |
| 2024-05-22 | AACT | Stock | 10.65 | 10.66 | 10.63 | 10.66 | 85900.0 |
| 2024-05-22 | AAGR-DELISTED | Stock | 0.359 | 0.3879 | 0.34 | 0.36 | 202702.0 |
| 2024-05-22 | AAGRW-DELISTED | Stock | 0.0165 | 0.0165 | 0.01536 | 0.01538 | 635.0 |
| 2024-05-22 | AAL | Stock | 14.07 | 14.25 | 14.01 | 14.1 | 19136400.0 |
| 2024-05-22 | AAMC-DELISTED | Stock | 2.55 | 2.79 | 2.54 | 2.54 | 3400.0 |
| 2024-05-22 | AAME | Stock | 1.77 | 1.78 | 1.67 | 1.7 | 5700.0 |
| 2024-05-22 | AAMI | Stock | 22.25 | 22.555 | 22.19 | 22.27 | 286600.0 |
| 2024-05-22 | AAN-DELISTED | Stock | 7.5 | 7.551 | 7.345 | 7.41 | 129100.0 |
| 2024-05-22 | AAOI | Stock | 12.06 | 12.29 | 11.87 | 11.98 | 1051800.0 |
| 2024-05-22 | AAON | Stock | 76.65 | 77.03 | 75.73 | 76.13 | 366500.0 |
| 2024-05-22 | AAP | Stock | 70.52 | 71.32 | 69.86 | 70.24 | 1003500.0 |
| 2024-05-22 | AAT | Stock | 22.26 | 22.36 | 21.76 | 21.78 | 207100.0 |
| 2024-05-22 | AATC | Stock | 6.36 | 6.36 | 6.33 | 6.35 | 8169.0 |
| 2024-05-22 | AAUAF-DELISTED | Stock | 0.1243 | 0.13 | 0.1219 | 0.1219 | 29134.0 |
| 2024-05-22 | AAXJ | Stock | 72.71 | 72.73 | 72.27 | 72.43 | 469322.0 |
| 2024-05-22 | AB | Stock | 33.97 | 34.71 | 33.59 | 34.06 | 414700.0 |
| 2024-05-22 | ABAT | Stock | 1.45 | 1.47 | 1.43 | 1.46 | 250726.0 |
| 2024-05-22 | ABBV | Stock | 161.57 | 161.94 | 159.18 | 159.61 | 6904900.0 |
| 2024-05-22 | ABCB | Stock | 49.6 | 49.74 | 48.98 | 49.53 | 306200.0 |
| 2024-05-22 | ABCL | Stock | 3.81 | 4.035 | 3.796 | 3.86 | 1485800.0 |
| 2024-05-22 | ABEO | Stock | 4.35 | 4.39 | 4.22 | 4.29 | 343900.0 |
| 2024-05-22 | ABEV | Stock | 2.32 | 2.33 | 2.28 | 2.3 | 48089000.0 |
| 2024-05-22 | ABG | Stock | 238.59 | 240.6 | 234.66 | 234.76 | 137900.0 |
| 2024-05-22 | ABLV | Stock | 1.8 | 1.8 | 1.63 | 1.63 | 1900.0 |
| 2024-05-22 | ABM | Stock | 48.37 | 48.83 | 47.47 | 47.67 | 604100.0 |
| 2024-05-22 | ABNB | Stock | 143.94 | 144.21 | 142.36 | 142.71 | 3190800.0 |
| 2024-05-22 | ABOS | Stock | 3.82 | 3.9 | 3.6 | 3.6 | 166600.0 |
| 2024-05-22 | ABR | Stock | 13.74 | 13.78 | 13.48 | 13.49 | 2402500.0 |
| 2024-05-22 | ABR.D | Stock | 18.3941 | 18.5 | 18.3 | 18.3 | 10228.0 |
| 2024-05-22 | ABR.E | Stock | 18.0 | 18.08 | 17.85 | 17.85 | 7338.0 |
| 2024-05-22 | ABR.F | Stock | 19.8 | 19.97 | 19.8 | 19.97 | 15407.0 |
| 2024-05-22 | ABSI | Stock | 4.85 | 5.04 | 4.58 | 4.61 | 1185100.0 |
| 2024-05-22 | ABT | Stock | 102.95 | 105.14 | 102.94 | 104.82 | 5933400.0 |
| 2024-05-22 | ABTC | Stock | 123.75 | 123.75 | 108.75 | 112.5 | 12514.666666666666 |
| 2024-05-22 | ABTS | Stock | 10.08 | 10.5 | 9.93 | 9.93 | 847.0 |
| 2024-05-22 | ABUS | Stock | 3.22 | 3.43 | 3.19 | 3.41 | 2177600.0 |
| 2024-05-22 | ABVC | Stock | 1.08 | 1.09 | 1.06 | 1.07 | 159000.0 |
> showing 50 of 7,239 rows — these rows as CSV