PREVIEW / stock_daily / 2024-07-15
file: by_date/stock_daily/2024/2024-07-15.parquet size: 246 KB rows: 7,233 symbols: 908
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-15 | AAPL | Stock | 236.48 | 237.23 | 233.09 | 234.4 | 60417545.0 |
| 2024-07-15 | MSFT | Stock | 453.3 | 457.26 | 451.43 | 453.96 | 13885752.0 |
| 2024-07-15 | NVDA | Stock | 130.56 | 131.39 | 127.18 | 128.44 | 204540380.0 |
| 2024-07-15 | AMZN | Stock | 194.56 | 196.19 | 190.83 | 192.72 | 38796833.0 |
| 2024-07-15 | GOOGL | Stock | 184.92 | 188.24 | 184.92 | 186.53 | 16474043.0 |
| 2024-07-15 | META | Stock | 498.63 | 506.6799 | 493.37 | 496.16 | 12317618.0 |
| 2024-07-15 | TSLA | Stock | 255.97 | 265.6 | 251.73 | 252.64 | 146642359.0 |
| 2024-07-15 | TLT | Stock | 93.0 | 93.3 | 92.78 | 92.86 | 37918854.0 |
| 2024-07-15 | ES | Stock | 59.86 | 60.16 | 59.07 | 59.26 | 1577285.0 |
| 2024-07-15 | CL | Stock | 98.09 | 98.3 | 97.21 | 97.25 | 2902335.0 |
| 2024-07-15 | A | Stock | 132.01 | 133.14 | 130.775 | 131.01 | 975803.0 |
| 2024-07-15 | AA | Stock | 39.0 | 40.06 | 38.5518 | 39.3 | 3606809.0 |
| 2024-07-15 | AACG | Stock | 0.6665 | 0.8298 | 0.6665 | 0.7631 | 76970.0 |
| 2024-07-15 | AACIU | Stock | 11.93 | 11.93 | 11.93 | 11.93 | 244.0 |
| 2024-07-15 | AACIW-DELISTED | Stock | 0.17 | 0.1789 | 0.15 | 0.178 | 21204.0 |
| 2024-07-15 | AACT | Stock | 10.71 | 10.71 | 10.69 | 10.69 | 28029.0 |
| 2024-07-15 | AAGR-DELISTED | Stock | 0.1788 | 0.1788 | 0.17 | 0.171 | 375968.0 |
| 2024-07-15 | AAGRW-DELISTED | Stock | 0.0116 | 0.0116 | 0.0083 | 0.01 | 23215.0 |
| 2024-07-15 | AAL | Stock | 10.67 | 10.77 | 10.56 | 10.63 | 28503284.0 |
| 2024-07-15 | AAMC-DELISTED | Stock | 2.23 | 2.5 | 2.01 | 2.39 | 5321.0 |
| 2024-07-15 | AAME | Stock | 1.68 | 1.68 | 1.6 | 1.61 | 3665.0 |
| 2024-07-15 | AAMI | Stock | 24.13 | 24.51 | 24.0 | 24.31 | 132220.0 |
| 2024-07-15 | AAN-DELISTED | Stock | 9.99 | 10.0 | 9.97 | 9.97 | 433305.0 |
| 2024-07-15 | AAOI | Stock | 9.57 | 10.29 | 9.45 | 10.2 | 2822953.0 |
| 2024-07-15 | AAON | Stock | 91.06 | 91.92 | 90.22 | 91.11 | 354554.0 |
| 2024-07-15 | AAP | Stock | 62.6 | 63.62 | 61.8 | 62.42 | 1109296.0 |
| 2024-07-15 | AAT | Stock | 23.81 | 24.29 | 23.76 | 24.01 | 240629.0 |
| 2024-07-15 | AATC | Stock | 6.33 | 6.33 | 6.28 | 6.28 | 2737.0 |
| 2024-07-15 | AAUAF-DELISTED | Stock | 0.05 | 0.0545 | 0.0473 | 0.05 | 32448.0 |
| 2024-07-15 | AAXJ | Stock | 74.76 | 74.78 | 74.255 | 74.34 | 236375.0 |
| 2024-07-15 | AB | Stock | 33.75 | 34.04 | 33.63 | 33.74 | 266654.0 |
| 2024-07-15 | ABAT | Stock | 1.12 | 1.13 | 1.1 | 1.12 | 425545.0 |
| 2024-07-15 | ABBV | Stock | 168.91 | 170.365 | 167.42 | 168.03 | 2317946.0 |
| 2024-07-15 | ABCB | Stock | 55.59 | 57.52 | 54.69 | 56.15 | 469087.0 |
| 2024-07-15 | ABCL | Stock | 3.18 | 3.245 | 3.06 | 3.2 | 866013.0 |
| 2024-07-15 | ABEO | Stock | 5.58 | 5.7 | 5.3 | 5.39 | 475248.0 |
| 2024-07-15 | ABEV | Stock | 2.15 | 2.15 | 2.12 | 2.14 | 13060766.0 |
| 2024-07-15 | ABG | Stock | 247.74 | 255.32 | 245.76 | 249.61 | 201736.0 |
| 2024-07-15 | ABLLW | Stock | 0.58 | 0.6555 | 0.58 | 0.63 | 21234.0 |
| 2024-07-15 | ABLV | Stock | 1.21 | 1.358 | 1.18 | 1.19 | 11465.0 |
| 2024-07-15 | ABM | Stock | 51.19 | 52.32 | 51.1 | 51.33 | 562148.0 |
| 2024-07-15 | ABNB | Stock | 145.88 | 148.47 | 144.75 | 147.22 | 3528583.0 |
| 2024-07-15 | ABOS | Stock | 2.86 | 3.0 | 2.8 | 2.895 | 758932.0 |
| 2024-07-15 | ABR | Stock | 12.38 | 13.48 | 12.01 | 13.36 | 16269297.0 |
| 2024-07-15 | ABR.D | Stock | 17.06 | 17.54 | 16.76 | 17.51 | 104149.0 |
| 2024-07-15 | ABR.E | Stock | 16.91 | 17.25 | 16.6501 | 17.06 | 73820.0 |
| 2024-07-15 | ABR.F | Stock | 18.55 | 19.0 | 18.3 | 18.63 | 134890.0 |
| 2024-07-15 | ABSI | Stock | 4.2 | 4.2 | 3.85 | 3.95 | 1544668.0 |
| 2024-07-15 | ABT | Stock | 103.93 | 104.16 | 102.58 | 102.96 | 3850120.0 |
| 2024-07-15 | ABTC | Stock | 86.25 | 90.75 | 84.0 | 87.0 | 10263.133333333333 |
> showing 50 of 7,233 rows — these rows as CSV