PREVIEW / stock_daily / 2024-08-19
file: by_date/stock_daily/2024/2024-08-19.parquet size: 245 KB rows: 7,158 symbols: 791
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-19 | AAPL | Stock | 225.72 | 225.99 | 223.04 | 225.89 | 39101879.0 |
| 2024-08-19 | MSFT | Stock | 418.96 | 421.75 | 416.46 | 421.53 | 14395878.0 |
| 2024-08-19 | NVDA | Stock | 124.28 | 130.0 | 123.42 | 130.0 | 313001014.0 |
| 2024-08-19 | AMZN | Stock | 177.64 | 178.3 | 176.16 | 178.22 | 29103136.0 |
| 2024-08-19 | GOOGL | Stock | 165.28 | 166.69 | 164.26 | 166.67 | 22416185.0 |
| 2024-08-19 | META | Stock | 526.87 | 531.66 | 522.76 | 529.28 | 9754208.0 |
| 2024-08-19 | TSLA | Stock | 217.07 | 222.98 | 214.09 | 222.72 | 76180294.0 |
| 2024-08-19 | TLT | Stock | 97.42 | 98.155 | 97.405 | 97.89 | 25322138.0 |
| 2024-08-19 | ES | Stock | 65.1 | 65.98 | 64.92 | 65.84 | 2678056.0 |
| 2024-08-19 | CL | Stock | 102.05 | 102.31 | 101.58 | 101.85 | 2915203.0 |
| 2024-08-19 | A | Stock | 140.55 | 141.29 | 139.28 | 140.51 | 1651923.0 |
| 2024-08-19 | AA | Stock | 32.51 | 34.14 | 32.31 | 34.0 | 7177625.0 |
| 2024-08-19 | AACG | Stock | 0.5011 | 0.614 | 0.5011 | 0.6006 | 92098.0 |
| 2024-08-19 | AACT | Stock | 10.77 | 10.77 | 10.76 | 10.76 | 9842.0 |
| 2024-08-19 | AAGR-DELISTED | Stock | 0.1231 | 0.1292 | 0.1231 | 0.128 | 78811.0 |
| 2024-08-19 | AAGRW-DELISTED | Stock | 0.009 | 0.0091 | 0.009 | 0.0091 | 552.0 |
| 2024-08-19 | AAL | Stock | 10.155 | 10.38 | 10.115 | 10.31 | 30265045.0 |
| 2024-08-19 | AAMC-DELISTED | Stock | 2.33 | 2.39 | 2.31 | 2.31 | 1179.0 |
| 2024-08-19 | AAME | Stock | 1.51 | 1.55 | 1.5 | 1.55 | 6063.0 |
| 2024-08-19 | AAMI | Stock | 23.66 | 23.735 | 23.42 | 23.52 | 89423.0 |
| 2024-08-19 | AAN-DELISTED | Stock | 10.08 | 10.1 | 10.07 | 10.08 | 1034421.0 |
| 2024-08-19 | AAOI | Stock | 8.35 | 8.75 | 8.22 | 8.6 | 1561143.0 |
| 2024-08-19 | AAON | Stock | 89.02 | 91.16 | 89.02 | 90.93 | 336733.0 |
| 2024-08-19 | AAP | Stock | 62.19 | 62.22 | 60.52 | 60.9 | 1285413.0 |
| 2024-08-19 | AAT | Stock | 25.53 | 25.93 | 25.465 | 25.92 | 160745.0 |
| 2024-08-19 | AATC | Stock | 7.47 | 7.47 | 7.12 | 7.4 | 26608.0 |
| 2024-08-19 | AAUAF-DELISTED | Stock | 0.048 | 0.0547 | 0.048 | 0.052 | 58514.0 |
| 2024-08-19 | AAXJ | Stock | 73.2 | 73.705 | 73.15 | 73.62 | 142680.0 |
| 2024-08-19 | AB | Stock | 34.83 | 34.96 | 34.38 | 34.58 | 450268.0 |
| 2024-08-19 | ABAT | Stock | 1.03 | 1.07 | 1.03 | 1.06 | 229905.0 |
| 2024-08-19 | ABBV | Stock | 193.4 | 197.18 | 193.35 | 196.87 | 4223576.0 |
| 2024-08-19 | ABCB | Stock | 58.38 | 58.84 | 57.96 | 58.73 | 220526.0 |
| 2024-08-19 | ABCL | Stock | 2.63 | 2.8 | 2.63 | 2.71 | 2459137.0 |
| 2024-08-19 | ABEO | Stock | 5.0 | 5.25 | 4.91 | 5.23 | 285202.0 |
| 2024-08-19 | ABEV | Stock | 2.4 | 2.44 | 2.39 | 2.42 | 30743074.0 |
| 2024-08-19 | ABG | Stock | 230.38 | 231.5 | 228.66 | 230.03 | 83571.0 |
| 2024-08-19 | ABLLW | Stock | 1.33 | 1.37 | 1.25 | 1.3081 | 91637.0 |
| 2024-08-19 | ABLV | Stock | 1.7 | 1.82 | 1.4531 | 1.73 | 19796.0 |
| 2024-08-19 | ABM | Stock | 54.11 | 54.62 | 54.03 | 54.61 | 180800.0 |
| 2024-08-19 | ABNB | Stock | 116.93 | 119.3 | 116.44 | 119.14 | 4133272.0 |
| 2024-08-19 | ABOS | Stock | 2.59 | 2.85 | 2.565 | 2.83 | 158650.0 |
| 2024-08-19 | ABR | Stock | 13.34 | 13.34 | 13.015 | 13.16 | 4707724.0 |
| 2024-08-19 | ABR.D | Stock | 17.67 | 17.79 | 17.55 | 17.55 | 36373.0 |
| 2024-08-19 | ABR.E | Stock | 17.5 | 17.5351 | 17.35 | 17.35 | 3328.0 |
| 2024-08-19 | ABR.F | Stock | 18.36 | 18.46 | 18.19 | 18.19 | 40562.0 |
| 2024-08-19 | ABSI | Stock | 4.09 | 4.24 | 3.98 | 4.17 | 1134226.0 |
| 2024-08-19 | ABT | Stock | 111.0 | 112.25 | 110.84 | 111.9 | 3273194.0 |
| 2024-08-19 | ABTC | Stock | 61.49999999999999 | 63.915 | 60.0 | 62.28 | 1890.3999999999999 |
| 2024-08-19 | ABTS | Stock | 7.95 | 8.2485 | 7.3305 | 7.4235 | 873.0 |
| 2024-08-19 | ABUS | Stock | 3.72 | 3.8 | 3.6828 | 3.78 | 485813.0 |
> showing 50 of 7,158 rows — these rows as CSV