PREVIEW / stock_daily / 2024-11-01
file: by_date/stock_daily/2024/2024-11-01.parquet size: 245 KB rows: 7,091 symbols: 666
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-11-01 | AAPL | Stock | 220.965 | 225.35 | 220.27 | 222.91 | 61812957.0 |
| 2024-11-01 | MSFT | Stock | 409.01 | 415.5 | 407.5 | 410.37 | 22806136.0 |
| 2024-11-01 | NVDA | Stock | 134.7 | 137.31 | 134.57 | 135.4 | 199773977.0 |
| 2024-11-01 | AMZN | Stock | 199.0 | 200.5 | 197.02 | 197.93 | 96749541.0 |
| 2024-11-01 | GOOGL | Stock | 170.07 | 172.32 | 168.88 | 171.29 | 31796477.0 |
| 2024-11-01 | META | Stock | 567.605 | 573.67 | 562.56 | 567.16 | 14733037.0 |
| 2024-11-01 | TSLA | Stock | 252.043 | 254.0 | 246.63 | 248.98 | 55955335.0 |
| 2024-11-01 | TLT | Stock | 92.26 | 92.515 | 90.8 | 90.84 | 80401983.0 |
| 2024-11-01 | ES | Stock | 65.76 | 66.24 | 63.575 | 63.67 | 2211970.0 |
| 2024-11-01 | CL | Stock | 93.92 | 94.635 | 93.08 | 93.33 | 4670871.0 |
| 2024-11-01 | A | Stock | 139.135 | 140.97 | 135.27 | 136.87 | 2020764.0 |
| 2024-11-01 | AA | Stock | 40.64 | 41.19 | 40.25 | 40.57 | 3840711.0 |
| 2024-11-01 | AACG | Stock | 0.92 | 1.06 | 0.90796 | 1.01 | 218764.0 |
| 2024-11-01 | AACT | Stock | 10.88 | 10.9 | 10.87 | 10.875 | 55446.0 |
| 2024-11-01 | AAGR-DELISTED | Stock | 0.008 | 0.008 | 0.0002 | 0.0004 | 132610.0 |
| 2024-11-01 | AAL | Stock | 13.47 | 13.66 | 13.4 | 13.54 | 22706255.0 |
| 2024-11-01 | AAM | Stock | 10.04 | 10.05 | 10.03 | 10.05 | 65394.0 |
| 2024-11-01 | AAME | Stock | 1.68 | 1.68 | 1.63 | 1.63 | 1040.0 |
| 2024-11-01 | AAMI | Stock | 26.55 | 27.505 | 26.535 | 27.43 | 153375.0 |
| 2024-11-01 | AAOI | Stock | 15.96 | 17.06 | 15.91 | 16.84 | 2345775.0 |
| 2024-11-01 | AAON | Stock | 114.26 | 116.12 | 113.11 | 113.47 | 366431.0 |
| 2024-11-01 | AAP | Stock | 35.8 | 36.41 | 35.61 | 36.25 | 2579275.0 |
| 2024-11-01 | AAT | Stock | 27.12 | 27.22 | 26.52 | 26.64 | 140848.0 |
| 2024-11-01 | AATC | Stock | 7.44 | 7.65 | 7.44 | 7.58 | 1797.0 |
| 2024-11-01 | AAUAF-DELISTED | Stock | 0.0465 | 0.0526 | 0.0462 | 0.0462 | 23193.0 |
| 2024-11-01 | AAXJ | Stock | 76.69 | 76.88 | 76.22 | 76.3 | 1236636.0 |
| 2024-11-01 | AB | Stock | 37.34 | 37.8 | 37.14 | 37.43 | 313463.0 |
| 2024-11-01 | ABAT | Stock | 1.01 | 1.01 | 0.99 | 0.9933 | 231848.0 |
| 2024-11-01 | ABBV | Stock | 204.37 | 204.73 | 202.32 | 203.55 | 4217756.0 |
| 2024-11-01 | ABCB | Stock | 62.48 | 62.83 | 61.7 | 62.1 | 307044.0 |
| 2024-11-01 | ABCL | Stock | 2.74 | 2.8 | 2.715 | 2.73 | 1265075.0 |
| 2024-11-01 | ABEO | Stock | 6.47 | 6.47 | 6.22 | 6.25 | 214667.0 |
| 2024-11-01 | ABEV | Stock | 2.18 | 2.19 | 2.14 | 2.15 | 19090271.0 |
| 2024-11-01 | ABG | Stock | 228.58 | 232.94 | 226.83 | 227.98 | 137178.0 |
| 2024-11-01 | ABLLW | Stock | 1.4313 | 1.44 | 1.35 | 1.39 | 7283.0 |
| 2024-11-01 | ABLV | Stock | 0.8823 | 0.91 | 0.8823 | 0.91 | 1559.0 |
| 2024-11-01 | ABLVW | Stock | 0.01208 | 0.01208 | 0.01208 | 0.01208 | 200.0 |
| 2024-11-01 | ABM | Stock | 53.15 | 53.54 | 52.85 | 53.09 | 219173.0 |
| 2024-11-01 | ABNB | Stock | 133.96 | 136.88 | 133.8052 | 136.46 | 2897227.0 |
| 2024-11-01 | ABOS | Stock | 2.89 | 2.94 | 2.79 | 2.845 | 100295.0 |
| 2024-11-01 | ABR | Stock | 15.32 | 15.38 | 14.665 | 14.84 | 3710572.0 |
| 2024-11-01 | ABR.D | Stock | 19.93 | 19.93 | 19.0 | 19.0 | 14644.0 |
| 2024-11-01 | ABR.E | Stock | 19.52 | 19.55 | 19.4996 | 19.4996 | 2561.0 |
| 2024-11-01 | ABR.F | Stock | 20.64 | 20.9999 | 20.04 | 20.52 | 20739.0 |
| 2024-11-01 | ABSI | Stock | 3.88 | 3.95 | 3.72 | 3.92 | 1051369.0 |
| 2024-11-01 | ABT | Stock | 119.75 | 119.92 | 117.09 | 118.6 | 8976865.0 |
| 2024-11-01 | ABTC | Stock | 46.904999999999994 | 47.602500000000006 | 39.5325 | 39.9375 | 15727.466666666667 |
| 2024-11-01 | ABTS | Stock | 7.8 | 8.7 | 7.8 | 8.25 | 1513.0 |
| 2024-11-01 | ABUS | Stock | 3.85 | 3.9903 | 3.8 | 3.96 | 559122.0 |
| 2024-11-01 | ABVC | Stock | 0.724 | 0.724 | 0.639 | 0.66 | 165216.0 |
> showing 50 of 7,091 rows — these rows as CSV