PREVIEW / stock_daily / 2024-08-20
file: by_date/stock_daily/2024/2024-08-20.parquet size: 245 KB rows: 7,136 symbols: 788
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-08-20 | AAPL | Stock | 225.77 | 227.17 | 225.45 | 226.51 | 29461125.0 |
| 2024-08-20 | MSFT | Stock | 421.7 | 425.86 | 421.64 | 424.8 | 15844865.0 |
| 2024-08-20 | NVDA | Stock | 128.4 | 129.88 | 125.89 | 127.25 | 292246621.0 |
| 2024-08-20 | AMZN | Stock | 177.92 | 179.01 | 177.4308 | 178.88 | 24780384.0 |
| 2024-08-20 | GOOGL | Stock | 166.9 | 168.64 | 166.82 | 167.18 | 18341533.0 |
| 2024-08-20 | META | Stock | 528.35 | 531.09 | 525.88 | 526.73 | 7706911.0 |
| 2024-08-20 | TSLA | Stock | 224.88 | 228.22 | 219.56 | 221.1 | 73384314.0 |
| 2024-08-20 | TLT | Stock | 98.32 | 98.855 | 98.12 | 98.67 | 25239303.0 |
| 2024-08-20 | ES | Stock | 65.9 | 66.125 | 65.72 | 66.0 | 2113075.0 |
| 2024-08-20 | CL | Stock | 102.0 | 103.1 | 101.72 | 103.06 | 2612530.0 |
| 2024-08-20 | A | Stock | 140.6 | 141.535 | 139.43 | 139.75 | 1148776.0 |
| 2024-08-20 | AA | Stock | 34.1 | 34.75 | 33.68 | 33.76 | 5073076.0 |
| 2024-08-20 | AACG | Stock | 0.5681 | 0.6771 | 0.5151 | 0.649 | 158196.0 |
| 2024-08-20 | AACT | Stock | 10.76 | 10.77 | 10.76 | 10.76 | 103890.0 |
| 2024-08-20 | AAGR-DELISTED | Stock | 0.112 | 0.1589 | 0.112 | 0.148 | 1359261.0 |
| 2024-08-20 | AAGRW-DELISTED | Stock | 0.0091 | 0.0119 | 0.0091 | 0.0096 | 35913.0 |
| 2024-08-20 | AAL | Stock | 10.31 | 10.45 | 10.21 | 10.29 | 23488970.0 |
| 2024-08-20 | AAMC-DELISTED | Stock | 2.31 | 2.35 | 2.31 | 2.34 | 9726.0 |
| 2024-08-20 | AAME | Stock | 1.595 | 1.6 | 1.51 | 1.51 | 12371.0 |
| 2024-08-20 | AAMI | Stock | 23.63 | 23.63 | 22.98 | 23.19 | 102032.0 |
| 2024-08-20 | AAN-DELISTED | Stock | 10.09 | 10.09 | 10.08 | 10.08 | 484854.0 |
| 2024-08-20 | AAOI | Stock | 8.59 | 8.86 | 8.54 | 8.78 | 1536325.0 |
| 2024-08-20 | AAON | Stock | 91.15 | 91.15 | 89.36 | 89.56 | 265547.0 |
| 2024-08-20 | AAP | Stock | 60.85 | 61.18 | 60.2835 | 60.81 | 965890.0 |
| 2024-08-20 | AAT | Stock | 25.82 | 25.82 | 25.44 | 25.63 | 193268.0 |
| 2024-08-20 | AATC | Stock | 7.31 | 7.39 | 7.12 | 7.25 | 30361.0 |
| 2024-08-20 | AAUAF-DELISTED | Stock | 0.0432 | 0.055 | 0.0432 | 0.053 | 173048.0 |
| 2024-08-20 | AAXJ | Stock | 73.38 | 73.39 | 72.815 | 72.94 | 234621.0 |
| 2024-08-20 | AB | Stock | 34.45 | 34.68 | 34.31 | 34.34 | 216196.0 |
| 2024-08-20 | ABAT | Stock | 1.05 | 1.07 | 1.0308 | 1.07 | 167073.0 |
| 2024-08-20 | ABBV | Stock | 197.12 | 197.48 | 194.13 | 196.15 | 3458512.0 |
| 2024-08-20 | ABCB | Stock | 58.43 | 58.46 | 57.51 | 57.72 | 248527.0 |
| 2024-08-20 | ABCL | Stock | 2.64 | 2.65 | 2.56 | 2.6 | 2673802.0 |
| 2024-08-20 | ABEO | Stock | 5.2 | 5.34 | 5.05 | 5.13 | 307313.0 |
| 2024-08-20 | ABEV | Stock | 2.39 | 2.4 | 2.37 | 2.37 | 22556819.0 |
| 2024-08-20 | ABG | Stock | 229.03 | 230.37 | 224.97 | 226.26 | 99341.0 |
| 2024-08-20 | ABLLW | Stock | 1.33 | 1.49 | 1.25 | 1.49 | 154898.0 |
| 2024-08-20 | ABLV | Stock | 1.83 | 1.9 | 1.54 | 1.73 | 17556.0 |
| 2024-08-20 | ABM | Stock | 54.58 | 54.65 | 54.11 | 54.25 | 232234.0 |
| 2024-08-20 | ABNB | Stock | 118.94 | 119.28 | 117.175 | 117.38 | 3904351.0 |
| 2024-08-20 | ABOS | Stock | 2.86 | 3.1 | 2.72 | 2.83 | 262628.0 |
| 2024-08-20 | ABR | Stock | 13.1 | 13.12 | 12.89 | 12.89 | 2842161.0 |
| 2024-08-20 | ABR.D | Stock | 17.53 | 17.67 | 17.5 | 17.51 | 15859.0 |
| 2024-08-20 | ABR.E | Stock | 17.37 | 17.5 | 17.3 | 17.35 | 4746.0 |
| 2024-08-20 | ABR.F | Stock | 18.19 | 18.28 | 18.0 | 18.07 | 35210.0 |
| 2024-08-20 | ABSI | Stock | 4.18 | 4.3 | 4.06 | 4.23 | 846784.0 |
| 2024-08-20 | ABT | Stock | 111.82 | 112.09 | 110.33 | 110.77 | 5719265.0 |
| 2024-08-20 | ABTC | Stock | 62.699999999999996 | 66.15 | 49.245 | 56.2425 | 8439.533333333333 |
| 2024-08-20 | ABTS | Stock | 7.35 | 8.3475 | 7.35 | 8.1015 | 486.0 |
| 2024-08-20 | ABUS | Stock | 3.76 | 3.85 | 3.76 | 3.83 | 1102517.0 |
> showing 50 of 7,136 rows — these rows as CSV