PREVIEW / stock_daily / 2024-08-27
file: by_date/stock_daily/2024/2024-08-27.parquet size: 246 KB rows: 7,130 symbols: 785
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-27 | AAPL | Stock | 225.995 | 228.85 | 224.89 | 228.03 | 35037027.0 |
| 2024-08-27 | MSFT | Stock | 412.86 | 414.36 | 410.25 | 413.84 | 13171807.0 |
| 2024-08-27 | NVDA | Stock | 125.05 | 129.2 | 123.88 | 128.3 | 294835455.0 |
| 2024-08-27 | AMZN | Stock | 174.15 | 174.89 | 172.25 | 173.12 | 29380560.0 |
| 2024-08-27 | GOOGL | Stock | 165.835 | 166.4426 | 164.46 | 164.68 | 11821941.0 |
| 2024-08-27 | META | Stock | 518.98 | 524.01 | 515.31 | 519.1 | 5790789.0 |
| 2024-08-27 | TSLA | Stock | 213.25 | 215.66 | 206.94 | 209.21 | 61673498.0 |
| 2024-08-27 | TLT | Stock | 97.49 | 98.08 | 97.41 | 97.97 | 21507650.0 |
| 2024-08-27 | ES | Stock | 66.86 | 67.1099 | 66.3 | 66.44 | 1530828.0 |
| 2024-08-27 | CL | Stock | 105.31 | 106.04 | 104.62 | 105.92 | 3041864.0 |
| 2024-08-27 | A | Stock | 140.48 | 141.2099 | 139.71 | 141.1 | 931078.0 |
| 2024-08-27 | AA | Stock | 34.35 | 35.105 | 34.09 | 34.3 | 3488805.0 |
| 2024-08-27 | AACG | Stock | 0.5279 | 0.6012 | 0.5279 | 0.59 | 35447.0 |
| 2024-08-27 | AACT | Stock | 10.76 | 10.765 | 10.75 | 10.76 | 1784887.0 |
| 2024-08-27 | AAGR-DELISTED | Stock | 0.148 | 0.148 | 0.1344 | 0.1405 | 75210.0 |
| 2024-08-27 | AAGRW-DELISTED | Stock | 0.0095 | 0.0095 | 0.0095 | 0.0095 | 107.0 |
| 2024-08-27 | AAL | Stock | 10.26 | 10.27 | 9.98 | 10.17 | 23167420.0 |
| 2024-08-27 | AAMC-DELISTED | Stock | 1.38 | 1.5 | 1.1407 | 1.4 | 236286.0 |
| 2024-08-27 | AAME | Stock | 1.53 | 1.61 | 1.53 | 1.6 | 10157.0 |
| 2024-08-27 | AAMI | Stock | 23.59 | 23.825 | 23.2701 | 23.56 | 246046.0 |
| 2024-08-27 | AAN-DELISTED | Stock | 10.08 | 10.09 | 10.07 | 10.07 | 313246.0 |
| 2024-08-27 | AAOI | Stock | 9.54 | 9.685 | 9.14 | 9.18 | 1105098.0 |
| 2024-08-27 | AAON | Stock | 93.0 | 94.1073 | 91.9 | 93.19 | 271880.0 |
| 2024-08-27 | AAP | Stock | 49.0 | 49.05 | 47.77 | 47.85 | 3158424.0 |
| 2024-08-27 | AAT | Stock | 26.39 | 27.03 | 26.33 | 26.9 | 225889.0 |
| 2024-08-27 | AATC | Stock | 7.4 | 7.49 | 7.34 | 7.4 | 4254.0 |
| 2024-08-27 | AAUAF-DELISTED | Stock | 0.0462 | 0.05 | 0.0462 | 0.05 | 33859.0 |
| 2024-08-27 | AAXJ | Stock | 72.94 | 73.2 | 72.81 | 73.18 | 150553.0 |
| 2024-08-27 | AB | Stock | 34.81 | 34.94 | 34.63 | 34.77 | 136358.0 |
| 2024-08-27 | ABAT | Stock | 1.09 | 1.13 | 1.08 | 1.1 | 369129.0 |
| 2024-08-27 | ABBV | Stock | 197.99 | 198.3 | 195.18 | 195.92 | 2405813.0 |
| 2024-08-27 | ABCB | Stock | 60.75 | 61.34 | 60.1388 | 60.53 | 219796.0 |
| 2024-08-27 | ABCL | Stock | 2.69 | 2.708 | 2.57 | 2.61 | 1264902.0 |
| 2024-08-27 | ABEO | Stock | 5.73 | 5.73 | 5.445 | 5.6 | 189677.0 |
| 2024-08-27 | ABEV | Stock | 2.38 | 2.39 | 2.35 | 2.37 | 27670711.0 |
| 2024-08-27 | ABG | Stock | 243.24 | 243.495 | 239.905 | 240.36 | 108266.0 |
| 2024-08-27 | ABLLW | Stock | 1.3501 | 1.42 | 1.35 | 1.4 | 42647.0 |
| 2024-08-27 | ABLV | Stock | 1.6101 | 1.6101 | 1.6101 | 1.6101 | 608.0 |
| 2024-08-27 | ABM | Stock | 55.7 | 56.0 | 55.32 | 55.94 | 284497.0 |
| 2024-08-27 | ABNB | Stock | 115.3 | 117.42 | 115.17 | 116.74 | 3426368.0 |
| 2024-08-27 | ABOS | Stock | 2.95 | 2.9517 | 2.75 | 2.81 | 152875.0 |
| 2024-08-27 | ABR | Stock | 13.495 | 13.6627 | 13.43 | 13.61 | 2674427.0 |
| 2024-08-27 | ABR.D | Stock | 17.7 | 17.92 | 17.7 | 17.83 | 14970.0 |
| 2024-08-27 | ABR.E | Stock | 17.55 | 18.06 | 17.55 | 17.65 | 10350.0 |
| 2024-08-27 | ABR.F | Stock | 18.2 | 18.47 | 18.14 | 18.47 | 24942.0 |
| 2024-08-27 | ABSI | Stock | 4.45 | 4.51 | 4.26 | 4.49 | 670575.0 |
| 2024-08-27 | ABT | Stock | 113.055 | 113.17 | 112.14 | 113.1 | 2597913.0 |
| 2024-08-27 | ABTC | Stock | 57.375 | 59.595 | 55.5 | 58.035000000000004 | 2975.2666666666664 |
| 2024-08-27 | ABTS | Stock | 7.62 | 7.629 | 7.263 | 7.4625 | 333.0 |
| 2024-08-27 | ABUS | Stock | 3.87 | 3.895 | 3.805 | 3.87 | 460379.0 |
> showing 50 of 7,130 rows — these rows as CSV