PREVIEW / stock_daily / 2024-09-09
file: by_date/stock_daily/2024/2024-09-09.parquet size: 242 KB rows: 7,084 symbols: 749
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-09 | AAPL | Stock | 220.82 | 221.27 | 216.71 | 220.91 | 65734033.0 |
| 2024-09-09 | MSFT | Stock | 407.24 | 408.65 | 402.15 | 405.72 | 14604448.0 |
| 2024-09-09 | NVDA | Stock | 104.88 | 106.55 | 103.69 | 106.47 | 265705160.0 |
| 2024-09-09 | AMZN | Stock | 174.53 | 175.85 | 173.51 | 175.4 | 27895199.0 |
| 2024-09-09 | GOOGL | Stock | 152.51 | 153.4 | 147.215 | 148.71 | 39260451.0 |
| 2024-09-09 | META | Stock | 506.16 | 511.33 | 502.08 | 504.79 | 9962804.0 |
| 2024-09-09 | TSLA | Stock | 216.2 | 219.87 | 213.67 | 216.27 | 67025741.0 |
| 2024-09-09 | TLT | Stock | 99.4 | 100.1 | 99.16 | 99.99 | 26961402.0 |
| 2024-09-09 | ES | Stock | 67.52 | 68.09 | 67.4 | 68.06 | 1269327.0 |
| 2024-09-09 | CL | Stock | 107.36 | 107.82 | 106.5 | 107.11 | 4468251.0 |
| 2024-09-09 | A | Stock | 138.8 | 139.54 | 137.15 | 138.09 | 1736049.0 |
| 2024-09-09 | AA | Stock | 29.0 | 29.21 | 28.4 | 28.97 | 4738946.0 |
| 2024-09-09 | AACG | Stock | 0.5793 | 0.5793 | 0.53 | 0.54 | 21515.0 |
| 2024-09-09 | AACT | Stock | 10.7701 | 10.78 | 10.77 | 10.77 | 53145.0 |
| 2024-09-09 | AAGR-DELISTED | Stock | 0.1374 | 0.138 | 0.125 | 0.134 | 55925.0 |
| 2024-09-09 | AAGRW-DELISTED | Stock | 0.0094 | 0.0094 | 0.0094 | 0.0094 | 199.0 |
| 2024-09-09 | AAL | Stock | 10.85 | 11.225 | 10.85 | 11.22 | 44191204.0 |
| 2024-09-09 | AAMC-DELISTED | Stock | 1.57 | 1.64 | 1.3874 | 1.49 | 68105.0 |
| 2024-09-09 | AAME | Stock | 1.66 | 1.72 | 1.62 | 1.72 | 1920.0 |
| 2024-09-09 | AAMI | Stock | 23.17 | 23.43 | 22.965 | 23.12 | 197035.0 |
| 2024-09-09 | AAN-DELISTED | Stock | 9.99 | 10.07 | 9.99 | 10.07 | 743028.0 |
| 2024-09-09 | AAOI | Stock | 11.84 | 13.13 | 11.81 | 13.02 | 2821823.0 |
| 2024-09-09 | AAON | Stock | 88.14 | 89.05 | 87.615 | 88.59 | 215031.0 |
| 2024-09-09 | AAP | Stock | 39.75 | 40.37 | 38.62 | 38.72 | 3237690.0 |
| 2024-09-09 | AAT | Stock | 25.94 | 25.94 | 25.18 | 25.51 | 280630.0 |
| 2024-09-09 | AATC | Stock | 7.32 | 7.35 | 7.25 | 7.35 | 3882.0 |
| 2024-09-09 | AAUAF-DELISTED | Stock | 0.0402 | 0.0409 | 0.0402 | 0.0402 | 24684.0 |
| 2024-09-09 | AAXJ | Stock | 70.74 | 71.195 | 70.71 | 71.04 | 434099.0 |
| 2024-09-09 | AB | Stock | 33.12 | 33.76 | 33.09 | 33.34 | 155591.0 |
| 2024-09-09 | ABAT | Stock | 1.03 | 1.05 | 1.0 | 1.02 | 217610.0 |
| 2024-09-09 | ABBV | Stock | 194.97 | 196.61 | 193.94 | 196.42 | 3381524.0 |
| 2024-09-09 | ABCB | Stock | 59.23 | 59.89 | 58.7 | 59.44 | 354945.0 |
| 2024-09-09 | ABCL | Stock | 2.41 | 2.53 | 2.365 | 2.4 | 2215037.0 |
| 2024-09-09 | ABEO | Stock | 5.57 | 5.77 | 5.57 | 5.62 | 156582.0 |
| 2024-09-09 | ABEV | Stock | 2.33 | 2.38 | 2.31 | 2.37 | 64190182.0 |
| 2024-09-09 | ABG | Stock | 222.09 | 224.96 | 220.22 | 223.21 | 221855.0 |
| 2024-09-09 | ABLLW | Stock | 1.4 | 1.46 | 1.4 | 1.44 | 47244.0 |
| 2024-09-09 | ABLV | Stock | 1.21 | 1.33 | 1.21 | 1.33 | 729.0 |
| 2024-09-09 | ABM | Stock | 51.61 | 51.7506 | 49.8 | 49.94 | 1385646.0 |
| 2024-09-09 | ABNB | Stock | 115.11 | 117.92 | 114.985 | 116.36 | 4053949.0 |
| 2024-09-09 | ABOS | Stock | 2.23 | 2.445 | 2.23 | 2.44 | 193212.0 |
| 2024-09-09 | ABR | Stock | 13.47 | 13.49 | 13.2 | 13.47 | 1968670.0 |
| 2024-09-09 | ABR.D | Stock | 17.93 | 18.17 | 17.88 | 18.1202 | 12638.0 |
| 2024-09-09 | ABR.E | Stock | 17.91 | 18.24 | 17.91 | 18.1 | 10991.0 |
| 2024-09-09 | ABR.F | Stock | 18.68 | 18.83 | 18.64 | 18.79 | 6177.0 |
| 2024-09-09 | ABSI | Stock | 4.0 | 4.1 | 3.49 | 3.5 | 1993389.0 |
| 2024-09-09 | ABT | Stock | 114.46 | 116.73 | 114.32 | 116.43 | 4960568.0 |
| 2024-09-09 | ABTC | Stock | 36.09 | 37.4925 | 28.725 | 31.365000000000002 | 10449.066666666666 |
| 2024-09-09 | ABTS | Stock | 7.8735 | 7.875 | 6.75 | 6.8712 | 3272.0 |
| 2024-09-09 | ABUS | Stock | 4.58 | 4.725 | 4.44 | 4.49 | 1578904.0 |
> showing 50 of 7,084 rows — these rows as CSV