PREVIEW / stock_daily / 2024-09-10
file: by_date/stock_daily/2024/2024-09-10.parquet size: 242 KB rows: 7,086 symbols: 741
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-09-10 | AAPL | Stock | 218.92 | 221.48 | 216.73 | 220.11 | 51098090.0 |
| 2024-09-10 | MSFT | Stock | 408.2 | 416.33 | 407.7 | 414.2 | 19266520.0 |
| 2024-09-10 | NVDA | Stock | 107.81 | 109.4 | 104.95 | 108.1 | 263088262.0 |
| 2024-09-10 | AMZN | Stock | 177.49 | 180.5 | 176.79 | 179.55 | 36017295.0 |
| 2024-09-10 | GOOGL | Stock | 150.45 | 151.27 | 148.34 | 148.66 | 31118765.0 |
| 2024-09-10 | META | Stock | 508.16 | 514.18 | 500.0278 | 504.79 | 9314085.0 |
| 2024-09-10 | TSLA | Stock | 220.07 | 226.4 | 218.6377 | 226.17 | 78474879.0 |
| 2024-09-10 | TLT | Stock | 99.87 | 100.91 | 99.82 | 100.69 | 31703409.0 |
| 2024-09-10 | ES | Stock | 68.17 | 68.6 | 67.54 | 68.0 | 2567934.0 |
| 2024-09-10 | CL | Stock | 107.0 | 107.76 | 106.59 | 106.84 | 4047986.0 |
| 2024-09-10 | A | Stock | 137.53 | 138.21 | 135.94 | 138.03 | 1324946.0 |
| 2024-09-10 | AA | Stock | 28.78 | 28.84 | 27.77 | 28.17 | 4676725.0 |
| 2024-09-10 | AACG | Stock | 0.54 | 0.6034 | 0.54 | 0.5609 | 4090.0 |
| 2024-09-10 | AACT | Stock | 10.8 | 10.8 | 10.77 | 10.79 | 584605.0 |
| 2024-09-10 | AAGR-DELISTED | Stock | 0.13 | 0.1377 | 0.128 | 0.131 | 170696.0 |
| 2024-09-10 | AAGRW-DELISTED | Stock | 0.0086 | 0.0087 | 0.0086 | 0.0087 | 600.0 |
| 2024-09-10 | AAL | Stock | 11.21 | 11.25 | 10.87 | 10.99 | 31693207.0 |
| 2024-09-10 | AAMC-DELISTED | Stock | 1.4001 | 1.5 | 1.4001 | 1.49 | 18581.0 |
| 2024-09-10 | AAME | Stock | 1.73 | 1.73 | 1.715 | 1.72 | 2172.0 |
| 2024-09-10 | AAMI | Stock | 23.1 | 23.37 | 22.65 | 23.36 | 174707.0 |
| 2024-09-10 | AAN-DELISTED | Stock | 10.09 | 10.09 | 10.04 | 10.06 | 419846.0 |
| 2024-09-10 | AAOI | Stock | 13.1 | 13.25 | 12.15 | 12.515 | 1752807.0 |
| 2024-09-10 | AAON | Stock | 88.67 | 89.59 | 86.695 | 88.26 | 328540.0 |
| 2024-09-10 | AAP | Stock | 38.59 | 39.47 | 38.11 | 38.53 | 2594508.0 |
| 2024-09-10 | AAT | Stock | 25.65 | 26.08 | 25.54 | 26.06 | 232506.0 |
| 2024-09-10 | AATC | Stock | 7.3 | 7.49 | 7.3 | 7.48 | 6089.0 |
| 2024-09-10 | AAUAF-DELISTED | Stock | 0.0466 | 0.0466 | 0.037 | 0.04 | 13867.0 |
| 2024-09-10 | AAXJ | Stock | 70.9 | 71.07 | 70.261 | 70.75 | 276249.0 |
| 2024-09-10 | AB | Stock | 33.31 | 33.67 | 32.93 | 33.63 | 158032.0 |
| 2024-09-10 | ABAT | Stock | 1.03 | 1.06 | 1.01 | 1.04 | 158258.0 |
| 2024-09-10 | ABBV | Stock | 196.12 | 199.47 | 192.91 | 199.35 | 5930329.0 |
| 2024-09-10 | ABCB | Stock | 59.69 | 59.895 | 58.33 | 59.6 | 346338.0 |
| 2024-09-10 | ABCL | Stock | 2.4 | 2.595 | 2.335 | 2.58 | 3258864.0 |
| 2024-09-10 | ABEO | Stock | 5.64 | 5.64 | 5.52 | 5.56 | 81799.0 |
| 2024-09-10 | ABEV | Stock | 2.35 | 2.38 | 2.34 | 2.37 | 49003005.0 |
| 2024-09-10 | ABG | Stock | 221.86 | 223.28 | 208.54 | 216.53 | 293583.0 |
| 2024-09-10 | ABLLW | Stock | 1.4 | 1.44 | 1.35 | 1.44 | 11817.0 |
| 2024-09-10 | ABLV | Stock | 1.29 | 1.34 | 1.22 | 1.25 | 2379.0 |
| 2024-09-10 | ABM | Stock | 50.01 | 50.595 | 49.4 | 49.92 | 604098.0 |
| 2024-09-10 | ABNB | Stock | 117.01 | 117.4063 | 112.86 | 115.12 | 4064764.0 |
| 2024-09-10 | ABOS | Stock | 2.41 | 2.5396 | 2.38 | 2.51 | 118115.0 |
| 2024-09-10 | ABR | Stock | 13.49 | 13.61 | 13.31 | 13.55 | 1646374.0 |
| 2024-09-10 | ABR.D | Stock | 18.12 | 18.27 | 18.11 | 18.27 | 17438.0 |
| 2024-09-10 | ABR.E | Stock | 18.1 | 18.26 | 18.035 | 18.1757 | 3464.0 |
| 2024-09-10 | ABR.F | Stock | 18.77 | 18.8 | 18.65 | 18.8 | 10070.0 |
| 2024-09-10 | ABSI | Stock | 3.49 | 3.67 | 3.36 | 3.67 | 2192535.0 |
| 2024-09-10 | ABT | Stock | 116.15 | 117.25 | 115.43 | 117.11 | 4835860.0 |
| 2024-09-10 | ABTC | Stock | 32.197500000000005 | 33.75 | 28.8825 | 33.75 | 5331.533333333333 |
| 2024-09-10 | ABTS | Stock | 6.9 | 7.146 | 5.64 | 6.0315 | 14378.0 |
| 2024-09-10 | ABUS | Stock | 4.49 | 4.6 | 4.36 | 4.56 | 1631039.0 |
> showing 50 of 7,086 rows — these rows as CSV