PREVIEW / stock_daily / 2024-10-16
file: by_date/stock_daily/2024/2024-10-16.parquet size: 246 KB rows: 7,151 symbols: 718
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-10-16 | AAPL | Stock | 231.6 | 232.12 | 229.84 | 231.78 | 33426011.0 |
| 2024-10-16 | MSFT | Stock | 415.17 | 416.36 | 410.48 | 416.12 | 14853265.0 |
| 2024-10-16 | NVDA | Stock | 133.98 | 136.62 | 131.58 | 135.72 | 261306828.0 |
| 2024-10-16 | AMZN | Stock | 187.05 | 187.78 | 185.61 | 186.89 | 22640345.0 |
| 2024-10-16 | GOOGL | Stock | 164.53 | 165.8 | 163.74 | 165.16 | 16406030.0 |
| 2024-10-16 | META | Stock | 581.395 | 582.08 | 574.03 | 576.79 | 10308248.0 |
| 2024-10-16 | TSLA | Stock | 221.4 | 222.8199 | 218.93 | 221.33 | 49244037.0 |
| 2024-10-16 | TLT | Stock | 95.39 | 95.62 | 95.14 | 95.31 | 32281486.0 |
| 2024-10-16 | ES | Stock | 65.72 | 65.94 | 65.28 | 65.75 | 2188933.0 |
| 2024-10-16 | CL | Stock | 100.88 | 101.4 | 100.66 | 101.19 | 4110901.0 |
| 2024-10-16 | A | Stock | 141.51 | 142.565 | 138.44 | 139.11 | 1679957.0 |
| 2024-10-16 | AA | Stock | 42.09 | 42.24 | 41.56 | 42.07 | 6542119.0 |
| 2024-10-16 | AACG | Stock | 1.0 | 1.09 | 0.972 | 1.01 | 134038.0 |
| 2024-10-16 | AACT | Stock | 10.82 | 10.869 | 10.82 | 10.8349 | 3851.0 |
| 2024-10-16 | AAGR-DELISTED | Stock | 0.014 | 0.03 | 0.0002 | 0.0002 | 17210.0 |
| 2024-10-16 | AAL | Stock | 12.19 | 12.92 | 12.14 | 12.89 | 52289982.0 |
| 2024-10-16 | AAM | Stock | 10.02 | 10.03 | 10.02 | 10.02 | 1303385.0 |
| 2024-10-16 | AAME | Stock | 1.72 | 1.72 | 1.51 | 1.52 | 33758.0 |
| 2024-10-16 | AAMI | Stock | 26.91 | 27.195 | 26.83 | 27.0 | 196820.0 |
| 2024-10-16 | AAOI | Stock | 17.96 | 19.44 | 17.3401 | 18.97 | 3663931.0 |
| 2024-10-16 | AAON | Stock | 111.57 | 113.74 | 110.23 | 110.86 | 671242.0 |
| 2024-10-16 | AAP | Stock | 39.93 | 39.93 | 38.58 | 38.62 | 2668475.0 |
| 2024-10-16 | AAT | Stock | 27.99 | 28.42 | 27.85 | 27.92 | 167534.0 |
| 2024-10-16 | AATC | Stock | 7.3125 | 7.58 | 7.26 | 7.26 | 9445.0 |
| 2024-10-16 | AAUAF-DELISTED | Stock | 0.0465 | 0.0486 | 0.0462 | 0.0486 | 32057.0 |
| 2024-10-16 | AAXJ | Stock | 77.69 | 78.16 | 77.69 | 77.92 | 355360.0 |
| 2024-10-16 | AB | Stock | 36.95 | 37.97 | 36.66 | 37.72 | 461107.0 |
| 2024-10-16 | ABAT | Stock | 1.0 | 1.04 | 0.9701 | 1.04 | 400284.0 |
| 2024-10-16 | ABBV | Stock | 190.45 | 191.035 | 188.73 | 190.46 | 4955646.0 |
| 2024-10-16 | ABCB | Stock | 65.43 | 66.45 | 65.16 | 66.05 | 356896.0 |
| 2024-10-16 | ABCL | Stock | 2.56 | 2.62 | 2.54 | 2.62 | 1158041.0 |
| 2024-10-16 | ABEO | Stock | 6.54 | 6.6769 | 6.29 | 6.52 | 234671.0 |
| 2024-10-16 | ABEV | Stock | 2.28 | 2.32 | 2.27 | 2.3 | 18221682.0 |
| 2024-10-16 | ABG | Stock | 229.5 | 237.12 | 228.78 | 234.99 | 112965.0 |
| 2024-10-16 | ABLLW | Stock | 1.635 | 1.67 | 1.54 | 1.615 | 17848.0 |
| 2024-10-16 | ABLV | Stock | 0.885 | 0.94 | 0.885 | 0.94 | 4626.0 |
| 2024-10-16 | ABLVW | Stock | 0.0191 | 0.0191 | 0.0191 | 0.0191 | 1368.0 |
| 2024-10-16 | ABM | Stock | 53.52 | 54.29 | 53.465 | 53.87 | 305893.0 |
| 2024-10-16 | ABNB | Stock | 134.73 | 137.395 | 134.32 | 135.15 | 3682323.0 |
| 2024-10-16 | ABOS | Stock | 2.36 | 2.4198 | 2.323 | 2.39 | 110358.0 |
| 2024-10-16 | ABR | Stock | 15.32 | 15.55 | 15.27 | 15.29 | 2105149.0 |
| 2024-10-16 | ABR.D | Stock | 19.41 | 19.75 | 19.3 | 19.52 | 23471.0 |
| 2024-10-16 | ABR.E | Stock | 19.94 | 20.08 | 19.6 | 19.77 | 4364.0 |
| 2024-10-16 | ABR.F | Stock | 19.61 | 19.87 | 19.4 | 19.61 | 31176.0 |
| 2024-10-16 | ABSI | Stock | 4.0 | 4.24 | 3.99 | 4.13 | 737181.0 |
| 2024-10-16 | ABT | Stock | 118.01 | 119.52 | 116.64 | 117.82 | 7056099.0 |
| 2024-10-16 | ABTC | Stock | 42.75 | 50.752500000000005 | 41.25 | 49.057500000000005 | 9131.8 |
| 2024-10-16 | ABTS | Stock | 6.99 | 7.95 | 6.396 | 6.75 | 2042.0 |
| 2024-10-16 | ABUS | Stock | 4.15 | 4.3491 | 4.1 | 4.2 | 3341126.0 |
| 2024-10-16 | ABVC | Stock | 0.54 | 0.57 | 0.53 | 0.5583 | 150766.0 |
> showing 50 of 7,151 rows — these rows as CSV