PREVIEW / stock_daily / 2024-08-12
file: by_date/stock_daily/2024/2024-08-12.parquet size: 244 KB rows: 7,183 symbols: 840
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-12 | AAPL | Stock | 216.07 | 219.5099 | 215.6 | 217.53 | 36543987.0 |
| 2024-08-12 | MSFT | Stock | 407.06 | 408.76 | 404.2434 | 406.81 | 15249045.0 |
| 2024-08-12 | NVDA | Stock | 106.32 | 111.07 | 101.0 | 109.02 | 321457081.0 |
| 2024-08-12 | AMZN | Stock | 168.14 | 168.55 | 166.1101 | 166.8 | 29152650.0 |
| 2024-08-12 | GOOGL | Stock | 164.35 | 164.9 | 161.84 | 162.29 | 15895286.0 |
| 2024-08-12 | META | Stock | 516.86 | 518.02 | 509.1 | 515.95 | 9544131.0 |
| 2024-08-12 | TSLA | Stock | 199.02 | 199.26 | 194.67 | 197.49 | 61900817.0 |
| 2024-08-12 | TLT | Stock | 96.03 | 96.82 | 95.88 | 96.61 | 24261382.0 |
| 2024-08-12 | ES | Stock | 64.87 | 65.23 | 64.53 | 64.87 | 2562018.0 |
| 2024-08-12 | CL | Stock | 101.85 | 101.93 | 100.59 | 101.28 | 3610569.0 |
| 2024-08-12 | A | Stock | 136.81 | 136.81 | 134.48 | 135.6 | 1331783.0 |
| 2024-08-12 | AA | Stock | 31.03 | 31.66 | 31.01 | 31.19 | 4910226.0 |
| 2024-08-12 | AACG | Stock | 0.66 | 0.66 | 0.61 | 0.6398 | 3640.0 |
| 2024-08-12 | AACIU | Stock | 10.85 | 10.85 | 10.85 | 10.85 | 204.0 |
| 2024-08-12 | AACIW-DELISTED | Stock | 0.12 | 0.1201 | 0.1109 | 0.111 | 52344.0 |
| 2024-08-12 | AACT | Stock | 10.74 | 10.76 | 10.74 | 10.76 | 20508.0 |
| 2024-08-12 | AAGR-DELISTED | Stock | 0.1388 | 0.14 | 0.1363 | 0.139 | 158205.0 |
| 2024-08-12 | AAGRW-DELISTED | Stock | 0.011 | 0.0119 | 0.0086 | 0.0086 | 3923.0 |
| 2024-08-12 | AAL | Stock | 9.79 | 9.8 | 9.59 | 9.61 | 29680768.0 |
| 2024-08-12 | AAMC-DELISTED | Stock | 2.94 | 3.21 | 2.85 | 2.94 | 11785.0 |
| 2024-08-12 | AAME | Stock | 1.5613 | 1.5875 | 1.5 | 1.5 | 1939.0 |
| 2024-08-12 | AAMI | Stock | 22.48 | 22.57 | 22.21 | 22.4 | 171688.0 |
| 2024-08-12 | AAN-DELISTED | Stock | 10.03 | 10.04 | 10.01 | 10.01 | 459483.0 |
| 2024-08-12 | AAOI | Stock | 7.78 | 8.16 | 7.67 | 7.85 | 1350160.0 |
| 2024-08-12 | AAON | Stock | 86.64 | 87.8965 | 86.47 | 87.39 | 341400.0 |
| 2024-08-12 | AAP | Stock | 60.57 | 60.57 | 57.81 | 58.06 | 1261541.0 |
| 2024-08-12 | AAT | Stock | 25.02 | 25.17 | 24.38 | 24.45 | 156604.0 |
| 2024-08-12 | AATC | Stock | 7.24 | 7.3 | 7.18 | 7.3 | 10284.0 |
| 2024-08-12 | AAUAF-DELISTED | Stock | 0.04475 | 0.05105 | 0.0425 | 0.0435 | 159285.0 |
| 2024-08-12 | AAXJ | Stock | 70.72 | 71.155 | 70.66 | 70.96 | 477744.0 |
| 2024-08-12 | AB | Stock | 33.28 | 33.45 | 33.0 | 33.29 | 150562.0 |
| 2024-08-12 | ABAT | Stock | 1.03 | 1.04 | 0.85 | 1.04 | 195303.0 |
| 2024-08-12 | ABBV | Stock | 190.08 | 190.57 | 187.7 | 190.18 | 4758889.0 |
| 2024-08-12 | ABCB | Stock | 56.77 | 57.35 | 55.53 | 55.66 | 235868.0 |
| 2024-08-12 | ABCL | Stock | 2.69 | 2.78 | 2.4 | 2.635 | 950788.0 |
| 2024-08-12 | ABEO | Stock | 4.5 | 5.21 | 4.5 | 4.95 | 599950.0 |
| 2024-08-12 | ABEV | Stock | 2.29 | 2.3 | 2.25 | 2.26 | 21065477.0 |
| 2024-08-12 | ABG | Stock | 230.65 | 231.22 | 226.05 | 226.55 | 119019.0 |
| 2024-08-12 | ABLLW | Stock | 1.4 | 1.545 | 1.28 | 1.33 | 85334.0 |
| 2024-08-12 | ABLV | Stock | 1.1 | 1.77 | 1.1 | 1.4 | 33894.0 |
| 2024-08-12 | ABM | Stock | 52.8 | 52.84 | 52.26 | 52.47 | 233127.0 |
| 2024-08-12 | ABNB | Stock | 115.48 | 115.5 | 113.27 | 113.62 | 3958842.0 |
| 2024-08-12 | ABOS | Stock | 2.66 | 2.66 | 2.52 | 2.56 | 176188.0 |
| 2024-08-12 | ABR | Stock | 13.6 | 13.75 | 13.345 | 13.37 | 3006730.0 |
| 2024-08-12 | ABR.D | Stock | 17.7 | 17.7499 | 17.4 | 17.4 | 28495.0 |
| 2024-08-12 | ABR.E | Stock | 17.7722 | 17.82 | 17.6001 | 17.61 | 5061.0 |
| 2024-08-12 | ABR.F | Stock | 18.7 | 18.7 | 18.55 | 18.55 | 12302.0 |
| 2024-08-12 | ABSI | Stock | 3.73 | 3.78 | 3.56 | 3.66 | 666174.0 |
| 2024-08-12 | ABT | Stock | 108.4 | 108.4 | 107.105 | 107.8 | 4319145.0 |
| 2024-08-12 | ABTC | Stock | 55.125 | 55.125 | 48.75 | 51.96 | 1167.6666666666667 |
> showing 50 of 7,183 rows — these rows as CSV