PREVIEW / stock_daily / 2024-10-03
file: by_date/stock_daily/2024/2024-10-03.parquet size: 243 KB rows: 7,049 symbols: 688
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-10-03 | AAPL | Stock | 225.14 | 226.805 | 223.32 | 225.67 | 32539942.0 |
| 2024-10-03 | MSFT | Stock | 417.63 | 419.55 | 414.29 | 416.54 | 13001635.0 |
| 2024-10-03 | NVDA | Stock | 120.92 | 124.36 | 120.3401 | 122.85 | 274781885.0 |
| 2024-10-03 | AMZN | Stock | 183.045 | 183.44 | 180.875 | 181.96 | 29349313.0 |
| 2024-10-03 | GOOGL | Stock | 164.41 | 166.64 | 163.923 | 165.86 | 15073101.0 |
| 2024-10-03 | META | Stock | 570.15 | 583.36 | 568.73 | 582.77 | 11344630.0 |
| 2024-10-03 | TSLA | Stock | 244.48 | 249.79 | 237.81 | 240.66 | 80186336.0 |
| 2024-10-03 | TLT | Stock | 97.34 | 97.51 | 96.74 | 96.74 | 39677767.0 |
| 2024-10-03 | ES | Stock | 66.65 | 66.99 | 65.57 | 65.89 | 1529573.0 |
| 2024-10-03 | CL | Stock | 101.65 | 101.75 | 99.77 | 99.97 | 4602676.0 |
| 2024-10-03 | A | Stock | 145.43 | 145.98 | 144.09 | 144.55 | 1078917.0 |
| 2024-10-03 | AA | Stock | 37.95 | 38.6077 | 37.755 | 38.17 | 4283789.0 |
| 2024-10-03 | AACG | Stock | 0.9 | 0.92 | 0.856 | 0.88 | 46745.0 |
| 2024-10-03 | AACT | Stock | 10.8386 | 10.8386 | 10.835 | 10.835 | 2967.0 |
| 2024-10-03 | AAGR-DELISTED | Stock | 0.021 | 0.057 | 0.021 | 0.0331 | 304234.0 |
| 2024-10-03 | AAL | Stock | 10.69 | 10.94 | 10.565 | 10.82 | 32096016.0 |
| 2024-10-03 | AAM | Stock | 10.02 | 10.02 | 10.01 | 10.015 | 396347.0 |
| 2024-10-03 | AAME | Stock | 1.69 | 1.69 | 1.6 | 1.66 | 4525.0 |
| 2024-10-03 | AAMI | Stock | 23.61 | 23.69 | 22.82 | 23.18 | 268838.0 |
| 2024-10-03 | AAN-DELISTED | Stock | 10.08 | 10.1 | 10.08 | 10.09 | 2764992.0 |
| 2024-10-03 | AAOI | Stock | 13.65 | 14.44 | 13.38 | 14.195 | 1310512.0 |
| 2024-10-03 | AAON | Stock | 107.32 | 107.7725 | 105.87 | 107.19 | 290802.0 |
| 2024-10-03 | AAP | Stock | 36.9 | 39.24 | 36.4 | 38.89 | 4813514.0 |
| 2024-10-03 | AAT | Stock | 26.08 | 26.1439 | 25.87 | 26.11 | 113264.0 |
| 2024-10-03 | AATC | Stock | 7.78 | 7.78 | 7.57 | 7.57 | 2193.0 |
| 2024-10-03 | AAUAF-DELISTED | Stock | 0.0412 | 0.051 | 0.0412 | 0.0504 | 30104.0 |
| 2024-10-03 | AAXJ | Stock | 79.53 | 80.45 | 79.46 | 80.09 | 1080958.0 |
| 2024-10-03 | AB | Stock | 34.71 | 34.9 | 34.51 | 34.85 | 131414.0 |
| 2024-10-03 | ABAT | Stock | 1.03 | 1.08 | 0.97 | 0.9819 | 520924.0 |
| 2024-10-03 | ABBV | Stock | 196.87 | 197.05 | 194.74 | 195.45 | 3363341.0 |
| 2024-10-03 | ABCB | Stock | 59.12 | 60.72 | 59.12 | 60.54 | 237433.0 |
| 2024-10-03 | ABCL | Stock | 2.48 | 2.5 | 2.441 | 2.48 | 1234426.0 |
| 2024-10-03 | ABEO | Stock | 6.17 | 6.4229 | 6.17 | 6.38 | 204360.0 |
| 2024-10-03 | ABEV | Stock | 2.49 | 2.5 | 2.46 | 2.48 | 49212507.0 |
| 2024-10-03 | ABG | Stock | 225.59 | 225.59 | 221.96 | 223.51 | 105989.0 |
| 2024-10-03 | ABLLW | Stock | 1.56 | 1.56 | 1.56 | 1.56 | 423.0 |
| 2024-10-03 | ABLV | Stock | 0.95 | 0.95 | 0.92 | 0.928 | 16967.0 |
| 2024-10-03 | ABM | Stock | 51.04 | 51.31 | 50.65 | 51.18 | 246743.0 |
| 2024-10-03 | ABNB | Stock | 124.6 | 125.555 | 123.58 | 125.29 | 2228290.0 |
| 2024-10-03 | ABOS | Stock | 2.5 | 2.51 | 2.39 | 2.39 | 116523.0 |
| 2024-10-03 | ABR | Stock | 14.99 | 15.11 | 14.89 | 15.1 | 1721366.0 |
| 2024-10-03 | ABR.D | Stock | 19.6 | 19.7 | 19.55 | 19.56 | 16880.0 |
| 2024-10-03 | ABR.E | Stock | 20.06 | 20.4 | 19.8 | 20.05 | 12222.0 |
| 2024-10-03 | ABR.F | Stock | 19.4 | 19.6 | 19.4 | 19.4 | 18024.0 |
| 2024-10-03 | ABSI | Stock | 3.74 | 3.905 | 3.73 | 3.81 | 566316.0 |
| 2024-10-03 | ABT | Stock | 113.505 | 113.51 | 111.79 | 112.23 | 3325792.0 |
| 2024-10-03 | ABTC | Stock | 46.5075 | 50.685 | 43.574999999999996 | 43.807500000000005 | 1272.0 |
| 2024-10-03 | ABTS | Stock | 6.4736 | 7.485 | 6.45 | 7.035 | 1084.0 |
| 2024-10-03 | ABUS | Stock | 3.9 | 3.975 | 3.8148 | 3.85 | 706476.0 |
| 2024-10-03 | ABVC | Stock | 0.605 | 0.668 | 0.605 | 0.6375 | 42883.0 |
> showing 50 of 7,049 rows — these rows as CSV