PREVIEW / stock_daily / 2024-07-10
file: by_date/stock_daily/2024/2024-07-10.parquet size: 245 KB rows: 7,209 symbols: 905
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-10 | AAPL | Stock | 229.3 | 233.08 | 229.25 | 232.98 | 61446706.0 |
| 2024-07-10 | MSFT | Stock | 461.22 | 466.46 | 458.855 | 466.25 | 17818221.0 |
| 2024-07-10 | NVDA | Stock | 134.03 | 135.1 | 132.42 | 134.91 | 245704084.0 |
| 2024-07-10 | AMZN | Stock | 199.995 | 200.11 | 197.69 | 199.79 | 32178698.0 |
| 2024-07-10 | GOOGL | Stock | 189.15 | 191.75 | 189.03 | 191.18 | 15952454.0 |
| 2024-07-10 | META | Stock | 530.79 | 538.88 | 528.36 | 534.69 | 10843140.0 |
| 2024-07-10 | TSLA | Stock | 262.8 | 267.59 | 257.86 | 263.26 | 127929780.0 |
| 2024-07-10 | TLT | Stock | 92.45 | 92.68 | 92.2603 | 92.64 | 23572469.0 |
| 2024-07-10 | ES | Stock | 58.0 | 58.17 | 57.29 | 58.09 | 1832586.0 |
| 2024-07-10 | CL | Stock | 97.16 | 97.615 | 96.85 | 97.39 | 2562229.0 |
| 2024-07-10 | A | Stock | 126.42 | 127.14 | 125.542 | 127.07 | 1801686.0 |
| 2024-07-10 | AA | Stock | 40.66 | 40.8 | 38.23 | 38.46 | 6086027.0 |
| 2024-07-10 | AACG | Stock | 0.83 | 0.8347 | 0.804 | 0.817 | 5869.0 |
| 2024-07-10 | AACIW-DELISTED | Stock | 0.1299 | 0.1503 | 0.1298 | 0.1503 | 21318.0 |
| 2024-07-10 | AACT | Stock | 10.69 | 10.6903 | 10.685 | 10.69 | 6142.0 |
| 2024-07-10 | AAGR-DELISTED | Stock | 0.1665 | 0.179 | 0.165 | 0.1734 | 658480.0 |
| 2024-07-10 | AAGRW-DELISTED | Stock | 0.0127 | 0.0127 | 0.012 | 0.012 | 12168.0 |
| 2024-07-10 | AAL | Stock | 11.04 | 11.22 | 10.994 | 11.15 | 28365228.0 |
| 2024-07-10 | AAMC-DELISTED | Stock | 1.91 | 2.04 | 1.81 | 1.85 | 9277.0 |
| 2024-07-10 | AAME | Stock | 1.565 | 1.62 | 1.55 | 1.56 | 2983.0 |
| 2024-07-10 | AAMI | Stock | 22.18 | 22.81 | 21.98 | 22.79 | 542390.0 |
| 2024-07-10 | AAN-DELISTED | Stock | 9.98 | 10.05 | 9.94 | 9.95 | 1112569.0 |
| 2024-07-10 | AAOI | Stock | 8.62 | 9.09 | 8.3 | 9.01 | 1628401.0 |
| 2024-07-10 | AAON | Stock | 84.26 | 85.789 | 83.67 | 85.34 | 432547.0 |
| 2024-07-10 | AAP | Stock | 58.85 | 58.88 | 58.17 | 58.74 | 903953.0 |
| 2024-07-10 | AAT | Stock | 22.19 | 22.28 | 21.9 | 22.1 | 152850.0 |
| 2024-07-10 | AATC | Stock | 6.32 | 6.35 | 6.25 | 6.25 | 4812.0 |
| 2024-07-10 | AAUAF-DELISTED | Stock | 0.0526 | 0.0568 | 0.05065 | 0.0528 | 111493.0 |
| 2024-07-10 | AAXJ | Stock | 74.32 | 74.52 | 74.18 | 74.49 | 367962.0 |
| 2024-07-10 | AB | Stock | 33.94 | 34.2 | 33.65 | 33.82 | 445734.0 |
| 2024-07-10 | ABAT | Stock | 1.12 | 1.14 | 1.02 | 1.08 | 762166.0 |
| 2024-07-10 | ABBV | Stock | 167.45 | 168.45 | 166.1101 | 168.14 | 3738187.0 |
| 2024-07-10 | ABCB | Stock | 51.0 | 52.18 | 50.55 | 52.11 | 246198.0 |
| 2024-07-10 | ABCL | Stock | 2.9 | 2.96 | 2.73 | 2.8 | 1555835.0 |
| 2024-07-10 | ABEO | Stock | 5.01 | 5.18 | 4.9 | 4.99 | 310219.0 |
| 2024-07-10 | ABEV | Stock | 2.1 | 2.13 | 2.09 | 2.12 | 18048760.0 |
| 2024-07-10 | ABG | Stock | 224.24 | 228.56 | 224.24 | 227.28 | 159241.0 |
| 2024-07-10 | ABLLW | Stock | 0.63 | 0.63 | 0.6 | 0.6237 | 1500.0 |
| 2024-07-10 | ABLV | Stock | 1.1 | 1.17 | 1.1 | 1.17 | 1575.0 |
| 2024-07-10 | ABM | Stock | 49.23 | 49.25 | 48.72 | 49.02 | 649158.0 |
| 2024-07-10 | ABNB | Stock | 153.11 | 153.2 | 150.09 | 151.84 | 3175153.0 |
| 2024-07-10 | ABOS | Stock | 2.29 | 2.35 | 2.28 | 2.29 | 202588.0 |
| 2024-07-10 | ABR | Stock | 15.02 | 15.15 | 14.85 | 15.09 | 3106626.0 |
| 2024-07-10 | ABR.D | Stock | 19.38 | 19.5 | 19.38 | 19.47 | 8402.0 |
| 2024-07-10 | ABR.E | Stock | 18.75 | 19.05 | 18.75 | 19.05 | 3668.0 |
| 2024-07-10 | ABR.F | Stock | 20.27 | 20.4999 | 20.27 | 20.3 | 34284.0 |
| 2024-07-10 | ABSI | Stock | 3.75 | 3.81 | 3.51 | 3.61 | 1437093.0 |
| 2024-07-10 | ABT | Stock | 101.42 | 103.08 | 101.27 | 103.05 | 6445983.0 |
| 2024-07-10 | ABTC | Stock | 84.0 | 84.74249999999999 | 82.5 | 84.0 | 956.6666666666666 |
| 2024-07-10 | ABTS | Stock | 6.9315 | 7.347 | 6.9315 | 6.9315 | 303.0 |
> showing 50 of 7,209 rows — these rows as CSV