PREVIEW / stock_daily / 2024-07-05
file: by_date/stock_daily/2024/2024-07-05.parquet size: 241 KB rows: 7,156 symbols: 891
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-05 | AAPL | Stock | 221.65 | 226.45 | 221.65 | 226.34 | 58287571.0 |
| 2024-07-05 | MSFT | Stock | 459.61 | 468.35 | 458.965 | 467.56 | 15453383.0 |
| 2024-07-05 | NVDA | Stock | 127.36 | 128.8452 | 125.68 | 127.875 | 113949664.0 |
| 2024-07-05 | AMZN | Stock | 198.65 | 200.55 | 198.17 | 200.0 | 37206565.0 |
| 2024-07-05 | GOOGL | Stock | 185.855 | 190.86 | 185.8 | 190.6 | 20967450.0 |
| 2024-07-05 | META | Stock | 511.6 | 540.87 | 511.6 | 539.91 | 21136609.0 |
| 2024-07-05 | TSLA | Stock | 249.81 | 252.37 | 242.46 | 251.52 | 154170000.0 |
| 2024-07-05 | TLT | Stock | 92.27 | 92.725 | 91.9 | 92.56 | 34895512.0 |
| 2024-07-05 | ES | Stock | 57.35 | 57.865 | 57.045 | 57.27 | 1690044.0 |
| 2024-07-05 | CL | Stock | 96.0 | 97.21 | 95.89 | 97.05 | 2764658.0 |
| 2024-07-05 | A | Stock | 126.4 | 126.61 | 125.29 | 126.37 | 1226172.0 |
| 2024-07-05 | AA | Stock | 42.65 | 43.1 | 42.42 | 42.44 | 2517321.0 |
| 2024-07-05 | AACG | Stock | 0.8 | 0.8597 | 0.8 | 0.859 | 5724.0 |
| 2024-07-05 | AACT | Stock | 10.7 | 10.7 | 10.67 | 10.69 | 53006.0 |
| 2024-07-05 | AAGR-DELISTED | Stock | 0.18 | 0.1809 | 0.161 | 0.179 | 1329227.0 |
| 2024-07-05 | AAGRW-DELISTED | Stock | 0.0129 | 0.01539 | 0.0128 | 0.01471 | 2975.0 |
| 2024-07-05 | AAL | Stock | 11.13 | 11.19 | 10.98 | 11.04 | 24187406.0 |
| 2024-07-05 | AAMC-DELISTED | Stock | 2.18 | 2.351 | 2.06 | 2.31 | 8132.0 |
| 2024-07-05 | AAME | Stock | 1.58 | 1.64 | 1.58 | 1.58 | 3493.0 |
| 2024-07-05 | AAMI | Stock | 22.64 | 22.74 | 22.26 | 22.37 | 213721.0 |
| 2024-07-05 | AAN-DELISTED | Stock | 9.97 | 10.0 | 9.96 | 9.98 | 502233.0 |
| 2024-07-05 | AAOI | Stock | 8.13 | 8.15 | 7.63 | 7.67 | 1579184.0 |
| 2024-07-05 | AAON | Stock | 86.13 | 87.49 | 85.51 | 87.04 | 513775.0 |
| 2024-07-05 | AAP | Stock | 59.72 | 59.92 | 58.01 | 58.72 | 1739994.0 |
| 2024-07-05 | AAT | Stock | 22.2 | 22.32 | 21.78 | 21.79 | 196470.0 |
| 2024-07-05 | AATC | Stock | 6.35 | 6.355 | 6.35 | 6.355 | 887.0 |
| 2024-07-05 | AAUAF-DELISTED | Stock | 0.0583 | 0.06 | 0.054 | 0.0579 | 70488.0 |
| 2024-07-05 | AAXJ | Stock | 73.65 | 73.77 | 73.19 | 73.74 | 405060.0 |
| 2024-07-05 | AB | Stock | 33.76 | 34.12 | 33.57 | 33.79 | 193440.0 |
| 2024-07-05 | ABAT | Stock | 1.06 | 1.06 | 1.0 | 1.01 | 1101235.0 |
| 2024-07-05 | ABBV | Stock | 164.72 | 167.31 | 163.63 | 167.25 | 4829867.0 |
| 2024-07-05 | ABCB | Stock | 49.82 | 49.98 | 48.915 | 48.94 | 185004.0 |
| 2024-07-05 | ABCL | Stock | 2.72 | 2.7399 | 2.66 | 2.69 | 1453948.0 |
| 2024-07-05 | ABEO | Stock | 4.4 | 4.55 | 4.29 | 4.54 | 367944.0 |
| 2024-07-05 | ABEV | Stock | 2.09 | 2.09 | 2.05 | 2.07 | 28109217.0 |
| 2024-07-05 | ABG | Stock | 224.68 | 225.69 | 222.9 | 224.76 | 162914.0 |
| 2024-07-05 | ABLLW | Stock | 0.64 | 0.66 | 0.5821 | 0.6 | 25334.0 |
| 2024-07-05 | ABLV | Stock | 1.09 | 1.12 | 1.05 | 1.08 | 6681.0 |
| 2024-07-05 | ABM | Stock | 50.03 | 50.28 | 49.17 | 49.45 | 290373.0 |
| 2024-07-05 | ABNB | Stock | 152.4 | 152.88 | 151.44 | 152.5 | 3813648.0 |
| 2024-07-05 | ABOS | Stock | 2.39 | 2.39 | 2.26 | 2.31 | 262809.0 |
| 2024-07-05 | ABR | Stock | 14.67 | 15.03 | 14.64 | 14.74 | 2800398.0 |
| 2024-07-05 | ABR.D | Stock | 18.95 | 19.18 | 18.9 | 19.16 | 13495.0 |
| 2024-07-05 | ABR.E | Stock | 18.5 | 19.1003 | 18.5 | 18.74 | 13323.0 |
| 2024-07-05 | ABR.F | Stock | 20.0975 | 20.2 | 20.05 | 20.1712 | 6229.0 |
| 2024-07-05 | ABSI | Stock | 3.27 | 3.38 | 3.085 | 3.17 | 1106961.0 |
| 2024-07-05 | ABT | Stock | 102.03 | 104.07 | 101.76 | 104.02 | 5620706.0 |
| 2024-07-05 | ABTC | Stock | 87.75 | 92.99249999999999 | 87.0 | 90.75 | 2003.8666666666666 |
| 2024-07-05 | ABTS | Stock | 7.5 | 8.844 | 7.2248 | 7.2248 | 3904.0 |
| 2024-07-05 | ABUS | Stock | 3.15 | 3.15 | 3.05 | 3.12 | 657486.0 |
> showing 50 of 7,156 rows — these rows as CSV