PREVIEW / stock_daily / 2024-07-12
file: by_date/stock_daily/2024/2024-07-12.parquet size: 246 KB rows: 7,231 symbols: 909
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-07-12 | AAPL | Stock | 228.92 | 232.64 | 228.68 | 230.54 | 51577854.0 |
| 2024-07-12 | MSFT | Stock | 454.325 | 456.36 | 450.645 | 453.55 | 15601853.0 |
| 2024-07-12 | NVDA | Stock | 128.26 | 131.92 | 127.22 | 129.24 | 250218039.0 |
| 2024-07-12 | AMZN | Stock | 194.8 | 196.47 | 193.8301 | 194.49 | 29921513.0 |
| 2024-07-12 | GOOGL | Stock | 185.08 | 187.11 | 184.49 | 185.07 | 22898406.0 |
| 2024-07-12 | META | Stock | 497.755 | 508.09 | 494.23 | 498.87 | 19521553.0 |
| 2024-07-12 | TSLA | Stock | 235.8 | 251.84 | 233.0912 | 248.23 | 155333366.0 |
| 2024-07-12 | TLT | Stock | 93.53 | 93.94 | 93.34 | 93.94 | 27796476.0 |
| 2024-07-12 | ES | Stock | 59.61 | 60.62 | 59.23 | 60.34 | 2236271.0 |
| 2024-07-12 | CL | Stock | 98.0 | 98.635 | 97.88 | 98.07 | 2476528.0 |
| 2024-07-12 | A | Stock | 131.17 | 133.4 | 130.64 | 132.23 | 1413574.0 |
| 2024-07-12 | AA | Stock | 40.11 | 40.41 | 38.87 | 38.95 | 4855772.0 |
| 2024-07-12 | AACG | Stock | 0.822 | 0.83 | 0.8125 | 0.83 | 6034.0 |
| 2024-07-12 | AACIW-DELISTED | Stock | 0.17 | 0.17 | 0.17 | 0.17 | 3020.0 |
| 2024-07-12 | AACT | Stock | 10.685 | 10.71 | 10.6801 | 10.7 | 438655.0 |
| 2024-07-12 | AAGR-DELISTED | Stock | 0.175 | 0.194 | 0.175 | 0.179 | 459705.0 |
| 2024-07-12 | AAGRW-DELISTED | Stock | 0.0128 | 0.0128 | 0.0115 | 0.0115 | 1634.0 |
| 2024-07-12 | AAL | Stock | 10.71 | 10.8 | 10.57 | 10.68 | 32883238.0 |
| 2024-07-12 | AAMC-DELISTED | Stock | 2.0 | 2.49 | 2.0 | 2.19 | 4657.0 |
| 2024-07-12 | AAME | Stock | 1.7 | 1.7 | 1.645 | 1.67 | 3726.0 |
| 2024-07-12 | AAMI | Stock | 23.73 | 24.06 | 23.37 | 23.92 | 137709.0 |
| 2024-07-12 | AAN-DELISTED | Stock | 10.0 | 10.0 | 9.96 | 9.99 | 1541470.0 |
| 2024-07-12 | AAOI | Stock | 9.28 | 9.54 | 9.08 | 9.38 | 1186123.0 |
| 2024-07-12 | AAON | Stock | 89.21 | 90.74 | 89.18 | 90.03 | 440566.0 |
| 2024-07-12 | AAP | Stock | 61.92 | 63.98 | 61.55 | 62.92 | 1583465.0 |
| 2024-07-12 | AAT | Stock | 23.44 | 23.89 | 23.37 | 23.59 | 205396.0 |
| 2024-07-12 | AATC | Stock | 6.36 | 6.36 | 6.36 | 6.36 | 320.0 |
| 2024-07-12 | AAUAF-DELISTED | Stock | 0.0545 | 0.0562 | 0.0467 | 0.05061 | 396161.0 |
| 2024-07-12 | AAXJ | Stock | 75.31 | 75.6 | 75.23 | 75.25 | 666396.0 |
| 2024-07-12 | AB | Stock | 33.83 | 34.17 | 33.69 | 33.83 | 253239.0 |
| 2024-07-12 | ABAT | Stock | 1.1 | 1.13 | 1.08 | 1.13 | 512822.0 |
| 2024-07-12 | ABBV | Stock | 170.63 | 171.625 | 169.9 | 170.28 | 3897441.0 |
| 2024-07-12 | ABCB | Stock | 54.79 | 55.62 | 54.26 | 54.53 | 322759.0 |
| 2024-07-12 | ABCL | Stock | 3.16 | 3.25 | 3.07 | 3.12 | 1688186.0 |
| 2024-07-12 | ABEO | Stock | 5.2 | 5.6 | 5.2 | 5.51 | 631020.0 |
| 2024-07-12 | ABEV | Stock | 2.15 | 2.16 | 2.12 | 2.15 | 17495447.0 |
| 2024-07-12 | ABG | Stock | 245.0 | 250.1471 | 244.79 | 247.98 | 168600.0 |
| 2024-07-12 | ABLLW | Stock | 0.58 | 0.61 | 0.58 | 0.6 | 2106.0 |
| 2024-07-12 | ABLV | Stock | 1.19 | 1.22 | 1.12 | 1.132 | 3072.0 |
| 2024-07-12 | ABM | Stock | 50.97 | 51.5 | 50.685 | 51.28 | 359416.0 |
| 2024-07-12 | ABNB | Stock | 146.83 | 148.0 | 146.19 | 146.78 | 2883960.0 |
| 2024-07-12 | ABOS | Stock | 2.67 | 2.98 | 2.59 | 2.82 | 862895.0 |
| 2024-07-12 | ABR | Stock | 15.65 | 15.895 | 12.2475 | 12.89 | 38267215.0 |
| 2024-07-12 | ABR.D | Stock | 19.4702 | 19.62 | 16.5 | 17.1734 | 290500.0 |
| 2024-07-12 | ABR.E | Stock | 19.08 | 19.13 | 16.54 | 17.16 | 145068.0 |
| 2024-07-12 | ABR.F | Stock | 20.45 | 20.45 | 18.27 | 18.73 | 236811.0 |
| 2024-07-12 | ABSI | Stock | 4.1 | 4.34 | 3.91 | 4.03 | 2686065.0 |
| 2024-07-12 | ABT | Stock | 104.67 | 104.93 | 104.11 | 104.22 | 4149185.0 |
| 2024-07-12 | ABTC | Stock | 83.25 | 88.5 | 83.25 | 83.25 | 1907.2 |
| 2024-07-12 | ABTS | Stock | 7.08 | 7.8 | 6.9135 | 7.65 | 509.0 |
> showing 50 of 7,231 rows — these rows as CSV