PREVIEW / stock_daily / 2024-07-25
file: by_date/stock_daily/2024/2024-07-25.parquet size: 246 KB rows: 7,195 symbols: 883
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-25 | AAPL | Stock | 218.93 | 220.85 | 214.62 | 217.49 | 50339326.0 |
| 2024-07-25 | MSFT | Stock | 428.8 | 429.8 | 417.51 | 418.4 | 28141807.0 |
| 2024-07-25 | NVDA | Stock | 113.04 | 116.63 | 106.3 | 112.28 | 453801180.0 |
| 2024-07-25 | AMZN | Stock | 182.91 | 183.8958 | 176.8 | 179.85 | 42326687.0 |
| 2024-07-25 | GOOGL | Stock | 172.52 | 173.42 | 167.19 | 167.28 | 44851973.0 |
| 2024-07-25 | META | Stock | 463.26 | 463.548 | 442.65 | 453.41 | 17804945.0 |
| 2024-07-25 | TSLA | Stock | 216.8 | 226.0 | 216.231 | 220.25 | 100381846.0 |
| 2024-07-25 | TLT | Stock | 92.025 | 92.86 | 91.96 | 92.27 | 44999074.0 |
| 2024-07-25 | ES | Stock | 63.42 | 64.77 | 63.115 | 63.6 | 2589923.0 |
| 2024-07-25 | CL | Stock | 97.09 | 98.31 | 96.37 | 96.49 | 4348120.0 |
| 2024-07-25 | A | Stock | 133.95 | 138.365 | 133.45 | 134.98 | 1311123.0 |
| 2024-07-25 | AA | Stock | 32.72 | 33.5423 | 32.5 | 32.91 | 5855792.0 |
| 2024-07-25 | AACG | Stock | 0.6799 | 0.68 | 0.6556 | 0.66 | 13393.0 |
| 2024-07-25 | AACIW-DELISTED | Stock | 0.13 | 0.14 | 0.1288 | 0.1288 | 82011.0 |
| 2024-07-25 | AACT | Stock | 10.72 | 10.74 | 10.72 | 10.725 | 6074.0 |
| 2024-07-25 | AAGR-DELISTED | Stock | 0.149 | 0.1637 | 0.1448 | 0.154 | 2135750.0 |
| 2024-07-25 | AAGRW-DELISTED | Stock | 0.0117 | 0.0118 | 0.0085 | 0.0085 | 5043.0 |
| 2024-07-25 | AAL | Stock | 9.92 | 10.9 | 9.755 | 10.6 | 96387565.0 |
| 2024-07-25 | AAMC-DELISTED | Stock | 3.01 | 3.03 | 2.85 | 2.87 | 4183.0 |
| 2024-07-25 | AAME | Stock | 1.62 | 1.62 | 1.56 | 1.6 | 4017.0 |
| 2024-07-25 | AAMI | Stock | 24.93 | 25.93 | 24.87 | 25.8 | 125324.0 |
| 2024-07-25 | AAN-DELISTED | Stock | 9.95 | 9.96 | 9.93 | 9.94 | 863184.0 |
| 2024-07-25 | AAOI | Stock | 8.9 | 9.04 | 8.47 | 8.61 | 2092624.0 |
| 2024-07-25 | AAON | Stock | 84.98 | 86.21 | 83.28 | 85.41 | 587669.0 |
| 2024-07-25 | AAP | Stock | 58.84 | 61.44 | 58.84 | 60.17 | 1624512.0 |
| 2024-07-25 | AAT | Stock | 24.42 | 24.89 | 24.38 | 24.61 | 222248.0 |
| 2024-07-25 | AATC | Stock | 6.6716 | 6.7125 | 6.61 | 6.7125 | 429.0 |
| 2024-07-25 | AAUAF-DELISTED | Stock | 0.05 | 0.0544 | 0.05 | 0.053 | 58787.0 |
| 2024-07-25 | AAXJ | Stock | 70.34 | 70.96 | 70.16 | 70.43 | 430197.0 |
| 2024-07-25 | AB | Stock | 34.1 | 34.93 | 34.0 | 34.42 | 376245.0 |
| 2024-07-25 | ABAT | Stock | 0.98 | 1.03 | 0.95 | 1.03 | 406834.0 |
| 2024-07-25 | ABBV | Stock | 177.0 | 186.11 | 171.802 | 182.17 | 9126080.0 |
| 2024-07-25 | ABCB | Stock | 59.65 | 62.13 | 58.88 | 60.88 | 535269.0 |
| 2024-07-25 | ABCL | Stock | 3.01 | 3.2 | 2.96 | 3.1 | 1483120.0 |
| 2024-07-25 | ABEO | Stock | 5.05 | 5.26 | 4.99 | 5.03 | 400228.0 |
| 2024-07-25 | ABEV | Stock | 2.11 | 2.13 | 2.09 | 2.1 | 14874125.0 |
| 2024-07-25 | ABG | Stock | 245.48 | 253.15 | 245.095 | 249.45 | 139457.0 |
| 2024-07-25 | ABLLW | Stock | 1.1 | 1.13 | 1.0 | 1.07 | 102291.0 |
| 2024-07-25 | ABLV | Stock | 1.23 | 1.26 | 1.15 | 1.21 | 14641.0 |
| 2024-07-25 | ABM | Stock | 54.67 | 56.02 | 54.5 | 54.61 | 537466.0 |
| 2024-07-25 | ABNB | Stock | 141.25 | 141.945 | 137.58 | 140.03 | 5590358.0 |
| 2024-07-25 | ABOS | Stock | 3.27 | 3.49 | 3.1851 | 3.41 | 301603.0 |
| 2024-07-25 | ABR | Stock | 13.06 | 13.32 | 12.97 | 13.03 | 2463658.0 |
| 2024-07-25 | ABR.D | Stock | 17.5594 | 17.5599 | 17.2 | 17.27 | 55011.0 |
| 2024-07-25 | ABR.E | Stock | 17.49 | 17.49 | 17.29 | 17.45 | 10937.0 |
| 2024-07-25 | ABR.F | Stock | 18.72 | 18.81 | 18.5 | 18.6 | 14312.0 |
| 2024-07-25 | ABSI | Stock | 4.22 | 4.5 | 4.15 | 4.38 | 732302.0 |
| 2024-07-25 | ABT | Stock | 107.02 | 108.71 | 105.92 | 105.96 | 6211051.0 |
| 2024-07-25 | ABTC | Stock | 71.25 | 72.75 | 67.5 | 68.25750000000001 | 1912.2 |
| 2024-07-25 | ABTS | Stock | 7.329 | 8.235 | 7.329 | 7.5 | 1465.0 |
> showing 50 of 7,195 rows — these rows as CSV