PREVIEW / stock_daily / 2024-04-16
file: by_date/stock_daily/2024/2024-04-16.parquet size: 231 KB rows: 7,225 symbols: 996
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-04-16 | AAPL | Stock | 171.75 | 173.76 | 168.27 | 169.38 | 73711200.0 |
| 2024-04-16 | MSFT | Stock | 414.57 | 418.4 | 413.73 | 414.58 | 16765600.0 |
| 2024-04-16 | NVDA | Stock | 86.433 | 88.118 | 86.064 | 87.415 | 370453000.0 |
| 2024-04-16 | AMZN | Stock | 183.27 | 184.83 | 182.26 | 183.32 | 32891300.0 |
| 2024-04-16 | GOOGL | Stock | 154.19 | 155.65 | 153.43 | 154.4 | 20779495.0 |
| 2024-04-16 | META | Stock | 498.11 | 504.77 | 497.11 | 499.76 | 9847900.0 |
| 2024-04-16 | TSLA | Stock | 156.74 | 158.19 | 153.75 | 157.11 | 97000000.0 |
| 2024-04-16 | TLT | Stock | 88.05 | 88.58 | 87.785 | 88.3 | 45103244.0 |
| 2024-04-16 | ES | Stock | 57.9 | 57.9 | 56.67 | 57.2 | 2391600.0 |
| 2024-04-16 | CL | Stock | 86.56 | 86.73 | 86.12 | 86.17 | 3220400.0 |
| 2024-04-16 | A | Stock | 140.28 | 140.36 | 136.63 | 136.8 | 1345700.0 |
| 2024-04-16 | AA | Stock | 35.15 | 36.339 | 35.05 | 36.09 | 7126900.0 |
| 2024-04-16 | AACG | Stock | 0.86 | 0.97 | 0.86 | 0.88 | 18400.0 |
| 2024-04-16 | AACT | Stock | 10.64 | 10.64 | 10.6 | 10.6 | 23900.0 |
| 2024-04-16 | AAGR-DELISTED | Stock | 0.39 | 0.4125 | 0.3213 | 0.359 | 198823.0 |
| 2024-04-16 | AAL | Stock | 12.95 | 13.14 | 12.72 | 13.03 | 26477200.0 |
| 2024-04-16 | AAMC-DELISTED | Stock | 3.45 | 3.52 | 3.281 | 3.43 | 6300.0 |
| 2024-04-16 | AAME | Stock | 2.0 | 2.17 | 1.99 | 1.99 | 5900.0 |
| 2024-04-16 | AAMI | Stock | 22.43 | 22.765 | 22.32 | 22.74 | 149100.0 |
| 2024-04-16 | AAN-DELISTED | Stock | 7.03 | 7.06 | 6.925 | 7.05 | 173200.0 |
| 2024-04-16 | AAOI | Stock | 10.92 | 12.29 | 10.88 | 11.99 | 1892000.0 |
| 2024-04-16 | AAON | Stock | 86.44 | 88.5 | 85.7 | 88.02 | 383600.0 |
| 2024-04-16 | AAP | Stock | 69.3 | 71.93 | 68.82 | 71.61 | 1593500.0 |
| 2024-04-16 | AAT | Stock | 20.27 | 20.62 | 20.03 | 20.36 | 336300.0 |
| 2024-04-16 | AATC | Stock | 6.38 | 6.42 | 6.37 | 6.3875 | 1073.0 |
| 2024-04-16 | AAUAF-DELISTED | Stock | 0.118 | 0.12324 | 0.117 | 0.118 | 23759.0 |
| 2024-04-16 | AAXJ | Stock | 65.56 | 65.86 | 65.38 | 65.6 | 532171.0 |
| 2024-04-16 | AB | Stock | 32.4 | 33.24 | 32.33 | 32.68 | 329600.0 |
| 2024-04-16 | ABAT | Stock | 1.62 | 1.62 | 1.49 | 1.5 | 658366.0 |
| 2024-04-16 | ABBV | Stock | 162.18 | 163.74 | 162.08 | 162.54 | 4881300.0 |
| 2024-04-16 | ABCB | Stock | 44.78 | 44.84 | 44.23 | 44.44 | 155600.0 |
| 2024-04-16 | ABCL | Stock | 4.13 | 4.15 | 4.03 | 4.05 | 1271900.0 |
| 2024-04-16 | ABEO | Stock | 7.6 | 7.89 | 7.53 | 7.76 | 218600.0 |
| 2024-04-16 | ABEV | Stock | 2.27 | 2.29 | 2.25 | 2.26 | 14382700.0 |
| 2024-04-16 | ABG | Stock | 214.16 | 217.87 | 211.88 | 216.4 | 109600.0 |
| 2024-04-16 | ABLLW | Stock | 0.4525 | 0.5525 | 0.42 | 0.52 | 34773.0 |
| 2024-04-16 | ABLV | Stock | 1.91 | 1.91 | 1.75 | 1.79 | 88200.0 |
| 2024-04-16 | ABLVW | Stock | 0.045 | 0.045 | 0.045 | 0.045 | 10000.0 |
| 2024-04-16 | ABM | Stock | 44.18 | 44.4 | 43.64 | 44.28 | 716700.0 |
| 2024-04-16 | ABNB | Stock | 155.83 | 158.94 | 155.3 | 156.66 | 2728600.0 |
| 2024-04-16 | ABOS | Stock | 3.49 | 3.6 | 3.4 | 3.5 | 222700.0 |
| 2024-04-16 | ABR | Stock | 12.15 | 12.15 | 11.95 | 12.07 | 4770100.0 |
| 2024-04-16 | ABR.D | Stock | 18.1001 | 18.35 | 17.9001 | 18.03 | 14035.0 |
| 2024-04-16 | ABR.E | Stock | 17.8001 | 18.69 | 17.64 | 18.07 | 7377.0 |
| 2024-04-16 | ABR.F | Stock | 18.85 | 18.8853 | 18.75 | 18.8686 | 20419.0 |
| 2024-04-16 | ABSI | Stock | 5.32 | 5.5 | 5.24 | 5.38 | 1347600.0 |
| 2024-04-16 | ABT | Stock | 108.84 | 110.33 | 108.14 | 109.21 | 7283900.0 |
| 2024-04-16 | ABTC | Stock | 111.0 | 116.25 | 101.25 | 105.0 | 1994.6666666666667 |
| 2024-04-16 | ABTS | Stock | 11.82 | 11.85 | 11.28 | 11.55 | 1473.0 |
| 2024-04-16 | ABUS | Stock | 2.94 | 2.94 | 2.88 | 2.92 | 644000.0 |
> showing 50 of 7,225 rows — these rows as CSV