PREVIEW / stock_daily / 2024-09-27
file: by_date/stock_daily/2024/2024-09-27.parquet size: 244 KB rows: 7,071 symbols: 708
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-27 | AAPL | Stock | 228.46 | 229.52 | 227.3 | 227.79 | 31435043.0 |
| 2024-09-27 | MSFT | Stock | 431.52 | 431.85 | 427.47 | 428.02 | 15358028.0 |
| 2024-09-27 | NVDA | Stock | 123.97 | 124.03 | 119.26 | 121.4 | 267631269.0 |
| 2024-09-27 | AMZN | Stock | 190.68 | 190.9 | 187.34 | 187.97 | 34935169.0 |
| 2024-09-27 | GOOGL | Stock | 162.81 | 165.7 | 162.6261 | 163.95 | 21101307.0 |
| 2024-09-27 | META | Stock | 570.1 | 570.8399 | 564.51 | 567.36 | 9046796.0 |
| 2024-09-27 | TSLA | Stock | 257.375 | 260.6999 | 254.12 | 260.46 | 69087286.0 |
| 2024-09-27 | TLT | Stock | 98.54 | 98.755 | 98.21 | 98.57 | 28317628.0 |
| 2024-09-27 | ES | Stock | 66.18 | 67.675 | 66.18 | 67.52 | 1766829.0 |
| 2024-09-27 | CL | Stock | 102.78 | 103.88 | 102.66 | 103.66 | 4372463.0 |
| 2024-09-27 | A | Stock | 147.18 | 150.08 | 147.18 | 148.06 | 2172758.0 |
| 2024-09-27 | AA | Stock | 39.53 | 40.2999 | 39.0901 | 39.27 | 5556433.0 |
| 2024-09-27 | AACG | Stock | 0.7499 | 0.7499 | 0.7103 | 0.7302 | 26100.0 |
| 2024-09-27 | AACT | Stock | 10.81 | 10.83 | 10.81 | 10.8299 | 2476.0 |
| 2024-09-27 | AAGR-DELISTED | Stock | 0.0201 | 0.03 | 0.012 | 0.012 | 913726.0 |
| 2024-09-27 | AAGRW-DELISTED | Stock | 0.0009 | 0.00367 | 0.0009 | 0.00367 | 29838.0 |
| 2024-09-27 | AAL | Stock | 11.82 | 11.86 | 11.56 | 11.56 | 30712823.0 |
| 2024-09-27 | AAM | Stock | 10.03 | 10.03 | 10.01 | 10.01 | 537105.0 |
| 2024-09-27 | AAME | Stock | 1.625 | 1.72 | 1.5987 | 1.68 | 11310.0 |
| 2024-09-27 | AAMI | Stock | 25.66 | 26.16 | 25.42 | 25.42 | 111058.0 |
| 2024-09-27 | AAN-DELISTED | Stock | 10.05 | 10.07 | 10.03 | 10.05 | 1423647.0 |
| 2024-09-27 | AAOI | Stock | 14.83 | 15.27 | 13.55 | 13.735 | 2687557.0 |
| 2024-09-27 | AAON | Stock | 107.34 | 108.24 | 106.59 | 107.09 | 231410.0 |
| 2024-09-27 | AAP | Stock | 40.83 | 42.49 | 40.83 | 41.38 | 2765416.0 |
| 2024-09-27 | AAT | Stock | 26.77 | 26.86 | 26.45 | 26.57 | 197608.0 |
| 2024-09-27 | AATC | Stock | 7.85 | 7.9 | 7.81 | 7.9 | 10996.0 |
| 2024-09-27 | AAUAF-DELISTED | Stock | 0.0662 | 0.0662 | 0.05 | 0.05 | 48204.0 |
| 2024-09-27 | AAXJ | Stock | 79.69 | 80.21 | 79.52 | 79.71 | 2995368.0 |
| 2024-09-27 | AB | Stock | 35.0 | 35.1 | 34.8 | 35.01 | 174317.0 |
| 2024-09-27 | ABAT | Stock | 0.93 | 1.01 | 0.8721 | 0.9803 | 803083.0 |
| 2024-09-27 | ABBV | Stock | 192.6 | 196.13 | 190.27 | 194.79 | 4313697.0 |
| 2024-09-27 | ABCB | Stock | 61.92 | 62.39 | 61.09 | 61.32 | 235735.0 |
| 2024-09-27 | ABCL | Stock | 2.6 | 2.6391 | 2.56 | 2.61 | 1556933.0 |
| 2024-09-27 | ABEO | Stock | 5.94 | 6.22 | 5.85 | 5.89 | 328421.0 |
| 2024-09-27 | ABEV | Stock | 2.36 | 2.41 | 2.36 | 2.4 | 57851891.0 |
| 2024-09-27 | ABG | Stock | 242.03 | 246.795 | 239.92 | 244.35 | 179815.0 |
| 2024-09-27 | ABLLW | Stock | 1.68 | 1.76 | 1.61 | 1.7 | 5202.0 |
| 2024-09-27 | ABLV | Stock | 0.85 | 1.0 | 0.85 | 0.98 | 21211.0 |
| 2024-09-27 | ABM | Stock | 51.91 | 52.215 | 51.15 | 51.36 | 263008.0 |
| 2024-09-27 | ABNB | Stock | 130.16 | 130.31 | 128.17 | 128.25 | 2462932.0 |
| 2024-09-27 | ABOS | Stock | 2.49 | 2.55 | 2.47 | 2.48 | 134084.0 |
| 2024-09-27 | ABR | Stock | 15.63 | 15.75 | 15.53 | 15.66 | 2069129.0 |
| 2024-09-27 | ABR.D | Stock | 19.3775 | 19.4 | 19.18 | 19.4 | 7919.0 |
| 2024-09-27 | ABR.E | Stock | 19.61 | 19.7999 | 19.5 | 19.5 | 2727.0 |
| 2024-09-27 | ABR.F | Stock | 19.34 | 19.4 | 19.12 | 19.36 | 62213.0 |
| 2024-09-27 | ABSI | Stock | 4.13 | 4.17 | 3.93 | 3.97 | 540582.0 |
| 2024-09-27 | ABT | Stock | 112.93 | 113.38 | 112.32 | 112.43 | 3326199.0 |
| 2024-09-27 | ABTC | Stock | 44.730000000000004 | 55.3275 | 44.2275 | 54.7575 | 8126.466666666666 |
| 2024-09-27 | ABTS | Stock | 7.5 | 7.875 | 7.5 | 7.6995 | 246.0 |
| 2024-09-27 | ABUS | Stock | 3.96 | 3.96 | 3.79 | 3.83 | 943592.0 |
> showing 50 of 7,071 rows — these rows as CSV