PREVIEW / stock_daily / 2024-08-02
file: by_date/stock_daily/2024/2024-08-02.parquet size: 245 KB rows: 7,197 symbols: 878
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-02 | AAPL | Stock | 219.15 | 225.6 | 217.71 | 219.86 | 95497629.0 |
| 2024-08-02 | MSFT | Stock | 412.49 | 415.0 | 404.34 | 408.49 | 28377211.0 |
| 2024-08-02 | NVDA | Stock | 103.76 | 108.72 | 101.37 | 107.27 | 470949053.0 |
| 2024-08-02 | AMZN | Stock | 166.75 | 168.77 | 160.55 | 167.9 | 141181160.0 |
| 2024-08-02 | GOOGL | Stock | 166.44 | 168.51 | 164.67 | 166.66 | 29130102.0 |
| 2024-08-02 | META | Stock | 489.0 | 501.145 | 476.15 | 488.14 | 23161870.0 |
| 2024-08-02 | TSLA | Stock | 214.88 | 216.13 | 205.78 | 207.67 | 81287173.0 |
| 2024-08-02 | TLT | Stock | 97.0 | 98.37 | 96.8901 | 98.28 | 91912942.0 |
| 2024-08-02 | ES | Stock | 67.95 | 68.72 | 65.77 | 67.11 | 2855545.0 |
| 2024-08-02 | CL | Stock | 102.0 | 103.35 | 100.68 | 102.81 | 4577530.0 |
| 2024-08-02 | A | Stock | 141.98 | 143.17 | 135.76 | 139.04 | 2179257.0 |
| 2024-08-02 | AA | Stock | 31.05 | 31.06 | 29.27 | 29.47 | 6812212.0 |
| 2024-08-02 | AACG | Stock | 0.66788 | 0.669 | 0.6 | 0.601 | 22002.0 |
| 2024-08-02 | AACIU | Stock | 11.83 | 14.76 | 10.08 | 11.45 | 14673.0 |
| 2024-08-02 | AACIW-DELISTED | Stock | 0.1299 | 0.1351 | 0.1205 | 0.135 | 32255.0 |
| 2024-08-02 | AACT | Stock | 10.75 | 10.75 | 10.74 | 10.75 | 53450.0 |
| 2024-08-02 | AAGR-DELISTED | Stock | 0.146 | 0.146 | 0.1351 | 0.14 | 478213.0 |
| 2024-08-02 | AAGRW-DELISTED | Stock | 0.0097 | 0.0097 | 0.0097 | 0.0097 | 100.0 |
| 2024-08-02 | AAL | Stock | 9.93 | 9.93 | 9.59 | 9.63 | 48017867.0 |
| 2024-08-02 | AAMC-DELISTED | Stock | 3.3 | 3.4 | 2.88 | 3.29 | 14740.0 |
| 2024-08-02 | AAME | Stock | 1.5 | 1.53 | 1.5 | 1.53 | 1741.0 |
| 2024-08-02 | AAMI | Stock | 23.69 | 23.87 | 23.03 | 23.47 | 224006.0 |
| 2024-08-02 | AAN-DELISTED | Stock | 10.04 | 10.1 | 10.03 | 10.03 | 538513.0 |
| 2024-08-02 | AAOI | Stock | 7.94 | 7.98 | 7.5 | 7.65 | 3092977.0 |
| 2024-08-02 | AAON | Stock | 92.88 | 92.88 | 84.95 | 85.78 | 1021366.0 |
| 2024-08-02 | AAP | Stock | 61.08 | 61.53 | 58.85 | 61.05 | 1197933.0 |
| 2024-08-02 | AAT | Stock | 25.27 | 25.865 | 25.27 | 25.73 | 277254.0 |
| 2024-08-02 | AATC | Stock | 6.81 | 7.0559 | 6.61 | 7.01 | 21288.0 |
| 2024-08-02 | AAUAF-DELISTED | Stock | 0.0509 | 0.052 | 0.05 | 0.051 | 63023.0 |
| 2024-08-02 | AAXJ | Stock | 69.93 | 70.075 | 69.58 | 69.99 | 549779.0 |
| 2024-08-02 | AB | Stock | 35.25 | 35.25 | 34.06 | 34.16 | 449645.0 |
| 2024-08-02 | ABAT | Stock | 1.0 | 1.0199 | 0.97 | 0.9936 | 482886.0 |
| 2024-08-02 | ABBV | Stock | 190.98 | 193.91 | 186.46 | 189.29 | 6103796.0 |
| 2024-08-02 | ABCB | Stock | 56.02 | 57.17 | 55.5 | 56.32 | 445004.0 |
| 2024-08-02 | ABCL | Stock | 2.87 | 3.0 | 2.8602 | 2.92 | 1356315.0 |
| 2024-08-02 | ABEO | Stock | 4.7 | 4.77 | 4.63 | 4.7 | 330238.0 |
| 2024-08-02 | ABEV | Stock | 2.06 | 2.09 | 2.05 | 2.07 | 19304496.0 |
| 2024-08-02 | ABG | Stock | 239.76 | 242.425 | 228.21 | 235.35 | 324532.0 |
| 2024-08-02 | ABLLW | Stock | 0.98 | 1.02 | 0.95 | 1.0 | 58162.0 |
| 2024-08-02 | ABLV | Stock | 1.11 | 1.19 | 1.09 | 1.09 | 6673.0 |
| 2024-08-02 | ABM | Stock | 54.02 | 55.195 | 53.7 | 54.75 | 350942.0 |
| 2024-08-02 | ABNB | Stock | 129.31 | 129.6 | 126.5 | 128.23 | 7659529.0 |
| 2024-08-02 | ABOS | Stock | 3.05 | 3.15 | 2.965 | 2.99 | 373758.0 |
| 2024-08-02 | ABR | Stock | 12.99 | 13.86 | 12.86 | 13.34 | 6914409.0 |
| 2024-08-02 | ABR.D | Stock | 17.57 | 17.84 | 17.33 | 17.4 | 57324.0 |
| 2024-08-02 | ABR.E | Stock | 18.03 | 18.5 | 17.6 | 17.65 | 11750.0 |
| 2024-08-02 | ABR.F | Stock | 18.61 | 18.76 | 18.0 | 18.5 | 43350.0 |
| 2024-08-02 | ABSI | Stock | 3.75 | 3.91 | 3.61 | 3.91 | 1379494.0 |
| 2024-08-02 | ABT | Stock | 110.18 | 112.04 | 108.4 | 111.31 | 9668838.0 |
| 2024-08-02 | ABTC | Stock | 62.55 | 63.36000000000001 | 53.25 | 55.5225 | 3161.2666666666664 |
> showing 50 of 7,197 rows — these rows as CSV