PREVIEW / stock_daily / 2024-07-16
file: by_date/stock_daily/2024/2024-07-16.parquet size: 247 KB rows: 7,213 symbols: 909
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-16 | AAPL | Stock | 235.0 | 236.27 | 232.33 | 234.82 | 38423976.0 |
| 2024-07-16 | MSFT | Stock | 454.22 | 454.3 | 446.66 | 449.52 | 16506904.0 |
| 2024-07-16 | NVDA | Stock | 128.44 | 129.04 | 124.58 | 126.36 | 209554139.0 |
| 2024-07-16 | AMZN | Stock | 195.59 | 196.62 | 192.24 | 193.02 | 31779801.0 |
| 2024-07-16 | GOOGL | Stock | 187.36 | 188.68 | 183.3736 | 183.92 | 18290722.0 |
| 2024-07-16 | META | Stock | 501.5 | 503.9499 | 485.79 | 489.79 | 13858907.0 |
| 2024-07-16 | TSLA | Stock | 255.31 | 258.62 | 245.8001 | 256.56 | 125795790.0 |
| 2024-07-16 | TLT | Stock | 93.53 | 94.21 | 93.39 | 94.17 | 36383720.0 |
| 2024-07-16 | ES | Stock | 59.58 | 59.81 | 59.16 | 59.72 | 1365102.0 |
| 2024-07-16 | CL | Stock | 97.39 | 97.95 | 97.03 | 97.4 | 2789374.0 |
| 2024-07-16 | A | Stock | 131.99 | 136.1899 | 131.595 | 136.06 | 1019726.0 |
| 2024-07-16 | AA | Stock | 38.17 | 38.69 | 37.46 | 38.66 | 6171375.0 |
| 2024-07-16 | AACG | Stock | 0.6506 | 0.7475 | 0.552 | 0.67 | 203999.0 |
| 2024-07-16 | AACIW-DELISTED | Stock | 0.18 | 0.18 | 0.13 | 0.15 | 282300.0 |
| 2024-07-16 | AACT | Stock | 10.71 | 10.71 | 10.69 | 10.7 | 816077.0 |
| 2024-07-16 | AAGR-DELISTED | Stock | 0.17 | 0.19 | 0.1677 | 0.185 | 2230214.0 |
| 2024-07-16 | AAGRW-DELISTED | Stock | 0.0101 | 0.0128 | 0.0101 | 0.0122 | 16137.0 |
| 2024-07-16 | AAL | Stock | 10.65 | 11.24 | 10.65 | 11.19 | 48563990.0 |
| 2024-07-16 | AAMC-DELISTED | Stock | 2.49 | 2.55 | 2.35 | 2.5 | 6578.0 |
| 2024-07-16 | AAME | Stock | 1.625 | 1.7 | 1.61 | 1.66 | 2556.0 |
| 2024-07-16 | AAMI | Stock | 24.55 | 25.06 | 24.405 | 24.95 | 131356.0 |
| 2024-07-16 | AAN-DELISTED | Stock | 9.98 | 9.99 | 9.97 | 9.99 | 511837.0 |
| 2024-07-16 | AAOI | Stock | 10.37 | 12.11 | 10.35 | 11.89 | 4275016.0 |
| 2024-07-16 | AAON | Stock | 92.06 | 94.665 | 91.6301 | 94.62 | 449936.0 |
| 2024-07-16 | AAP | Stock | 62.86 | 64.11 | 62.3 | 63.66 | 1025719.0 |
| 2024-07-16 | AAT | Stock | 24.16 | 24.72 | 24.16 | 24.64 | 270669.0 |
| 2024-07-16 | AATC | Stock | 6.08 | 6.33 | 6.08 | 6.33 | 4140.0 |
| 2024-07-16 | AAUAF-DELISTED | Stock | 0.05 | 0.0533 | 0.05 | 0.05176 | 118651.0 |
| 2024-07-16 | AAXJ | Stock | 74.3 | 74.75 | 74.19 | 74.7 | 801234.0 |
| 2024-07-16 | AB | Stock | 33.93 | 33.9313 | 33.47 | 33.74 | 557264.0 |
| 2024-07-16 | ABAT | Stock | 1.12 | 1.13 | 1.09 | 1.12 | 457788.0 |
| 2024-07-16 | ABBV | Stock | 168.6 | 169.85 | 167.26 | 169.2 | 3727059.0 |
| 2024-07-16 | ABCB | Stock | 56.89 | 59.45 | 56.705 | 58.94 | 484103.0 |
| 2024-07-16 | ABCL | Stock | 3.24 | 3.49 | 3.21 | 3.49 | 1714024.0 |
| 2024-07-16 | ABEO | Stock | 5.47 | 5.56 | 5.28 | 5.34 | 491681.0 |
| 2024-07-16 | ABEV | Stock | 2.15 | 2.18 | 2.14 | 2.18 | 15721335.0 |
| 2024-07-16 | ABG | Stock | 254.51 | 259.67 | 252.94 | 259.62 | 215074.0 |
| 2024-07-16 | ABLLW | Stock | 0.61 | 0.66 | 0.61 | 0.65 | 80423.0 |
| 2024-07-16 | ABLV | Stock | 1.19 | 1.32 | 1.19 | 1.2 | 2237.0 |
| 2024-07-16 | ABM | Stock | 51.76 | 52.99 | 51.595 | 52.93 | 537436.0 |
| 2024-07-16 | ABNB | Stock | 148.47 | 151.64 | 147.88 | 151.26 | 4045942.0 |
| 2024-07-16 | ABOS | Stock | 2.92 | 3.165 | 2.92 | 3.15 | 600043.0 |
| 2024-07-16 | ABR | Stock | 13.25 | 13.8 | 13.15 | 13.71 | 6827901.0 |
| 2024-07-16 | ABR.D | Stock | 17.6985 | 18.0 | 17.5201 | 17.89 | 61074.0 |
| 2024-07-16 | ABR.E | Stock | 17.21 | 17.6 | 17.2 | 17.5 | 75127.0 |
| 2024-07-16 | ABR.F | Stock | 18.74 | 18.92 | 18.6301 | 18.79 | 47846.0 |
| 2024-07-16 | ABSI | Stock | 4.055 | 4.55 | 4.035 | 4.35 | 2528292.0 |
| 2024-07-16 | ABT | Stock | 102.915 | 103.87 | 102.51 | 102.72 | 6612381.0 |
| 2024-07-16 | ABTC | Stock | 84.75 | 87.75 | 81.0 | 83.25 | 8050.0 |
| 2024-07-16 | ABTS | Stock | 7.6522 | 8.19 | 7.6515 | 8.1 | 334.0 |
> showing 50 of 7,213 rows — these rows as CSV