PREVIEW / stock_daily / 2024-10-24
file: by_date/stock_daily/2024/2024-10-24.parquet size: 244 KB rows: 7,081 symbols: 664
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-10-24 | AAPL | Stock | 229.98 | 230.82 | 228.41 | 230.57 | 29139253.0 |
| 2024-10-24 | MSFT | Stock | 425.325 | 425.9782 | 422.4 | 424.73 | 13673846.0 |
| 2024-10-24 | NVDA | Stock | 140.82 | 141.35 | 138.46 | 140.41 | 169814072.0 |
| 2024-10-24 | AMZN | Stock | 185.25 | 187.11 | 183.86 | 186.38 | 20394618.0 |
| 2024-10-24 | GOOGL | Stock | 162.83 | 163.33 | 161.01 | 162.72 | 22412527.0 |
| 2024-10-24 | META | Stock | 567.125 | 568.8799 | 561.52 | 567.78 | 6990609.0 |
| 2024-10-24 | TSLA | Stock | 244.68 | 262.1199 | 242.65 | 260.48 | 201835645.0 |
| 2024-10-24 | TLT | Stock | 92.23 | 93.0 | 91.96 | 92.66 | 32507395.0 |
| 2024-10-24 | ES | Stock | 67.23 | 67.23 | 66.5 | 66.82 | 1442736.0 |
| 2024-10-24 | CL | Stock | 99.0 | 99.98 | 98.83 | 99.74 | 5134844.0 |
| 2024-10-24 | A | Stock | 133.14 | 133.31 | 130.69 | 130.69 | 1768041.0 |
| 2024-10-24 | AA | Stock | 42.2 | 42.355 | 41.05 | 42.02 | 3665555.0 |
| 2024-10-24 | AACG | Stock | 1.0 | 1.01 | 0.9 | 1.01 | 70350.0 |
| 2024-10-24 | AACT | Stock | 10.85 | 10.87 | 10.845 | 10.86 | 65012.0 |
| 2024-10-24 | AAL | Stock | 13.18 | 13.63 | 12.415 | 12.78 | 65471503.0 |
| 2024-10-24 | AAME | Stock | 1.665 | 1.665 | 1.6416 | 1.6416 | 453.0 |
| 2024-10-24 | AAMI | Stock | 25.67 | 26.27 | 25.625 | 26.03 | 180406.0 |
| 2024-10-24 | AAOI | Stock | 17.26 | 17.68 | 16.995 | 17.45 | 1641899.0 |
| 2024-10-24 | AAON | Stock | 106.71 | 107.895 | 105.75 | 106.26 | 207610.0 |
| 2024-10-24 | AAP | Stock | 37.64 | 38.148 | 36.9 | 37.28 | 2260291.0 |
| 2024-10-24 | AAT | Stock | 27.67 | 27.77 | 27.385 | 27.76 | 244939.0 |
| 2024-10-24 | AATC | Stock | 7.44 | 7.444 | 7.402 | 7.402 | 1800.0 |
| 2024-10-24 | AAUAF-DELISTED | Stock | 0.05 | 0.0548 | 0.05 | 0.05 | 63263.0 |
| 2024-10-24 | AAXJ | Stock | 77.33 | 77.38 | 76.84 | 77.15 | 557944.0 |
| 2024-10-24 | AB | Stock | 37.66 | 38.5 | 37.56 | 38.36 | 533410.0 |
| 2024-10-24 | ABAT | Stock | 1.01 | 1.02 | 0.99 | 1.01 | 226080.0 |
| 2024-10-24 | ABBV | Stock | 188.43 | 190.47 | 188.17 | 189.65 | 6610730.0 |
| 2024-10-24 | ABCB | Stock | 62.72 | 63.09 | 61.655 | 63.03 | 505315.0 |
| 2024-10-24 | ABCL | Stock | 2.8 | 2.8398 | 2.64 | 2.7 | 3245585.0 |
| 2024-10-24 | ABEO | Stock | 6.22 | 6.47 | 6.12 | 6.34 | 208686.0 |
| 2024-10-24 | ABEV | Stock | 2.25 | 2.29 | 2.235 | 2.27 | 20114027.0 |
| 2024-10-24 | ABG | Stock | 229.85 | 231.31 | 224.23 | 225.14 | 269038.0 |
| 2024-10-24 | ABLLW | Stock | 1.46 | 1.49 | 1.46 | 1.4601 | 1981.0 |
| 2024-10-24 | ABLV | Stock | 0.895 | 0.92 | 0.8603 | 0.892 | 20334.0 |
| 2024-10-24 | ABM | Stock | 53.35 | 53.64 | 52.71 | 53.16 | 466153.0 |
| 2024-10-24 | ABNB | Stock | 133.55 | 133.75 | 131.66 | 132.75 | 2615059.0 |
| 2024-10-24 | ABOS | Stock | 2.71 | 2.75 | 2.68 | 2.74 | 65049.0 |
| 2024-10-24 | ABR | Stock | 15.3 | 15.48 | 15.205 | 15.41 | 2192069.0 |
| 2024-10-24 | ABR.D | Stock | 19.794 | 19.85 | 19.75 | 19.8399 | 6419.0 |
| 2024-10-24 | ABR.E | Stock | 20.1 | 20.1 | 20.028 | 20.028 | 1502.0 |
| 2024-10-24 | ABR.F | Stock | 20.2 | 20.3 | 20.02 | 20.04 | 15950.0 |
| 2024-10-24 | ABSI | Stock | 4.17 | 4.23 | 4.02 | 4.11 | 736149.0 |
| 2024-10-24 | ABT | Stock | 117.21 | 117.41 | 116.21 | 116.54 | 3623680.0 |
| 2024-10-24 | ABTC | Stock | 42.7725 | 45.5175 | 42.7575 | 44.790000000000006 | 3545.133333333333 |
| 2024-10-24 | ABTS | Stock | 7.05 | 7.05 | 6.3765 | 6.405 | 908.0 |
| 2024-10-24 | ABUS | Stock | 4.04 | 4.08 | 4.01 | 4.05 | 391219.0 |
| 2024-10-24 | ABVC | Stock | 0.57 | 0.7378 | 0.5504 | 0.719 | 1421338.0 |
| 2024-10-24 | ABVE | Stock | 0.5152 | 0.55 | 0.5 | 0.5099 | 50174.0 |
| 2024-10-24 | ABVEW | Stock | 0.0245 | 0.0245 | 0.01456 | 0.0198 | 3576.0 |
| 2024-10-24 | ABVX | Stock | 10.19 | 10.56 | 10.14 | 10.45 | 406801.0 |
> showing 50 of 7,081 rows — these rows as CSV