PREVIEW / stock_daily / 2024-08-07
file: by_date/stock_daily/2024/2024-08-07.parquet size: 245 KB rows: 7,179 symbols: 869
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-08-07 | AAPL | Stock | 206.9 | 213.64 | 206.39 | 209.82 | 59962555.0 |
| 2024-08-07 | MSFT | Stock | 408.635 | 410.08 | 397.47 | 398.43 | 19195388.0 |
| 2024-08-07 | NVDA | Stock | 107.81 | 108.8 | 98.69 | 98.91 | 404207846.0 |
| 2024-08-07 | AMZN | Stock | 166.55 | 167.58 | 161.43 | 162.77 | 46701401.0 |
| 2024-08-07 | GOOGL | Stock | 161.25 | 162.98 | 158.47 | 158.94 | 25138573.0 |
| 2024-08-07 | META | Stock | 503.13 | 510.15 | 486.86 | 488.92 | 19671723.0 |
| 2024-08-07 | TSLA | Stock | 200.77 | 203.49 | 191.48 | 191.76 | 69877788.0 |
| 2024-08-07 | TLT | Stock | 95.95 | 96.45 | 95.5 | 95.91 | 51337133.0 |
| 2024-08-07 | ES | Stock | 65.73 | 66.34 | 65.245 | 65.34 | 1808068.0 |
| 2024-08-07 | CL | Stock | 102.74 | 104.025 | 102.24 | 102.43 | 3795666.0 |
| 2024-08-07 | A | Stock | 137.25 | 138.085 | 133.69 | 133.96 | 1468451.0 |
| 2024-08-07 | AA | Stock | 30.0 | 30.52 | 28.93 | 29.21 | 9384733.0 |
| 2024-08-07 | AACG | Stock | 0.66 | 0.66 | 0.64 | 0.6489 | 21928.0 |
| 2024-08-07 | AACIW-DELISTED | Stock | 0.14 | 0.14088 | 0.1111 | 0.1111 | 62517.0 |
| 2024-08-07 | AACT | Stock | 10.75 | 10.7554 | 10.745 | 10.745 | 3811.0 |
| 2024-08-07 | AAGR-DELISTED | Stock | 0.14 | 0.1426 | 0.1347 | 0.1371 | 151553.0 |
| 2024-08-07 | AAGRW-DELISTED | Stock | 0.0128 | 0.0128 | 0.011 | 0.0127 | 468.0 |
| 2024-08-07 | AAL | Stock | 9.4 | 9.52 | 9.21 | 9.26 | 28663701.0 |
| 2024-08-07 | AAMC-DELISTED | Stock | 2.93 | 3.2999 | 2.86 | 3.0 | 6495.0 |
| 2024-08-07 | AAME | Stock | 1.57 | 1.57 | 1.57 | 1.57 | 409.0 |
| 2024-08-07 | AAMI | Stock | 22.29 | 22.31 | 21.49 | 21.55 | 185228.0 |
| 2024-08-07 | AAN-DELISTED | Stock | 10.0 | 10.06 | 9.99 | 10.0 | 586943.0 |
| 2024-08-07 | AAOI | Stock | 8.3 | 8.69 | 6.86 | 6.87 | 4169593.0 |
| 2024-08-07 | AAON | Stock | 87.66 | 89.19 | 85.26 | 85.92 | 482440.0 |
| 2024-08-07 | AAP | Stock | 59.14 | 60.58 | 58.59 | 58.99 | 1283492.0 |
| 2024-08-07 | AAT | Stock | 25.74 | 25.98 | 25.07 | 25.29 | 325320.0 |
| 2024-08-07 | AATC | Stock | 7.07 | 7.09 | 6.99 | 6.99 | 1755.0 |
| 2024-08-07 | AAUAF-DELISTED | Stock | 0.05 | 0.052 | 0.05 | 0.05 | 23404.0 |
| 2024-08-07 | AAXJ | Stock | 70.03 | 70.03 | 68.71 | 68.76 | 323345.0 |
| 2024-08-07 | AB | Stock | 33.3 | 33.63 | 32.7 | 32.88 | 350806.0 |
| 2024-08-07 | ABAT | Stock | 0.997 | 1.034 | 0.966 | 0.9749 | 225455.0 |
| 2024-08-07 | ABBV | Stock | 187.9 | 189.59 | 185.9775 | 187.51 | 6166541.0 |
| 2024-08-07 | ABCB | Stock | 56.92 | 57.48 | 55.145 | 55.4 | 218211.0 |
| 2024-08-07 | ABCL | Stock | 2.75 | 2.75 | 2.56 | 2.63 | 2998271.0 |
| 2024-08-07 | ABEO | Stock | 4.76 | 4.82 | 4.41 | 4.42 | 199548.0 |
| 2024-08-07 | ABEV | Stock | 2.17 | 2.26 | 2.15 | 2.24 | 64506924.0 |
| 2024-08-07 | ABG | Stock | 236.78 | 238.22 | 227.18 | 227.23 | 107112.0 |
| 2024-08-07 | ABLLW | Stock | 1.0 | 1.08 | 0.982 | 1.08 | 72047.0 |
| 2024-08-07 | ABLV | Stock | 1.12 | 1.56 | 1.06 | 1.12 | 40444.0 |
| 2024-08-07 | ABM | Stock | 52.65 | 53.2 | 51.67 | 51.98 | 362302.0 |
| 2024-08-07 | ABNB | Stock | 112.44 | 115.55 | 110.38 | 113.01 | 29008832.0 |
| 2024-08-07 | ABOS | Stock | 2.92 | 2.94 | 2.645 | 2.66 | 174251.0 |
| 2024-08-07 | ABR | Stock | 13.71 | 13.74 | 13.2 | 13.27 | 3854170.0 |
| 2024-08-07 | ABR.D | Stock | 17.47 | 17.8099 | 17.35 | 17.74 | 27567.0 |
| 2024-08-07 | ABR.E | Stock | 17.8999 | 17.9 | 17.6 | 17.6 | 3738.0 |
| 2024-08-07 | ABR.F | Stock | 18.62 | 18.94 | 18.52 | 18.94 | 17788.0 |
| 2024-08-07 | ABSI | Stock | 3.87 | 3.92 | 3.59 | 3.64 | 1002108.0 |
| 2024-08-07 | ABT | Stock | 109.61 | 112.35 | 109.4 | 109.94 | 6130322.0 |
| 2024-08-07 | ABTC | Stock | 52.5 | 54.75 | 47.940000000000005 | 48.75 | 2346.733333333333 |
| 2024-08-07 | ABTS | Stock | 9.1035 | 9.1035 | 7.5345 | 7.8 | 233.0 |
> showing 50 of 7,179 rows — these rows as CSV