PREVIEW / stock_daily / 2024-06-05
file: by_date/stock_daily/2024/2024-06-05.parquet size: 232 KB rows: 7,250 symbols: 984
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-06-05 | AAPL | Stock | 195.4 | 196.9 | 194.87 | 195.87 | 54156800.0 |
| 2024-06-05 | MSFT | Stock | 417.81 | 424.08 | 416.3 | 424.01 | 16988000.0 |
| 2024-06-05 | NVDA | Stock | 118.371 | 122.449 | 117.468 | 122.44 | 528402000.0 |
| 2024-06-05 | AMZN | Stock | 180.1 | 181.5 | 178.75 | 181.28 | 32116400.0 |
| 2024-06-05 | GOOGL | Stock | 175.2 | 176.645 | 173.9339 | 175.41 | 22068519.0 |
| 2024-06-05 | META | Stock | 484.45 | 496.65 | 483.91 | 495.06 | 15690500.0 |
| 2024-06-05 | TSLA | Stock | 175.35 | 176.15 | 172.13 | 175.0 | 57953800.0 |
| 2024-06-05 | TLT | Stock | 93.0 | 93.35 | 92.3887 | 93.35 | 43153858.0 |
| 2024-06-05 | ES | Stock | 60.79 | 60.82 | 59.46 | 59.52 | 1865400.0 |
| 2024-06-05 | CL | Stock | 93.67 | 93.96 | 93.16 | 93.66 | 2636800.0 |
| 2024-06-05 | A | Stock | 130.54 | 134.2 | 130.01 | 133.56 | 2707500.0 |
| 2024-06-05 | AA | Stock | 41.85 | 42.74 | 41.78 | 42.59 | 3355500.0 |
| 2024-06-05 | AACG | Stock | 0.89 | 0.9 | 0.85 | 0.87 | 28100.0 |
| 2024-06-05 | AACIW-DELISTED | Stock | 0.13 | 0.1385 | 0.1276 | 0.13 | 166001.0 |
| 2024-06-05 | AACT | Stock | 10.656 | 10.665 | 10.656 | 10.665 | 113100.0 |
| 2024-06-05 | AAGR-DELISTED | Stock | 0.3549 | 0.3699 | 0.3549 | 0.3649 | 16492.0 |
| 2024-06-05 | AAGRW-DELISTED | Stock | 0.014 | 0.0165 | 0.012 | 0.0165 | 1959.0 |
| 2024-06-05 | AAL | Stock | 11.51 | 11.77 | 11.45 | 11.62 | 34340900.0 |
| 2024-06-05 | AAMC-DELISTED | Stock | 2.71 | 2.72 | 2.46 | 2.635 | 10300.0 |
| 2024-06-05 | AAME | Stock | 1.79 | 1.83 | 1.78 | 1.82 | 8800.0 |
| 2024-06-05 | AAMI | Stock | 22.68 | 22.75 | 22.46 | 22.67 | 195200.0 |
| 2024-06-05 | AAN-DELISTED | Stock | 8.11 | 8.47 | 8.07 | 8.46 | 212200.0 |
| 2024-06-05 | AAOI | Stock | 10.1 | 10.62 | 9.99 | 10.58 | 1505400.0 |
| 2024-06-05 | AAON | Stock | 73.17 | 74.17 | 72.61 | 73.47 | 815800.0 |
| 2024-06-05 | AAP | Stock | 65.75 | 66.18 | 63.81 | 65.27 | 1579600.0 |
| 2024-06-05 | AAT | Stock | 21.89 | 22.02 | 21.66 | 21.83 | 327100.0 |
| 2024-06-05 | AATC | Stock | 6.121 | 6.18 | 6.1 | 6.18 | 4107.0 |
| 2024-06-05 | AAUAF-DELISTED | Stock | 0.11324 | 0.11324 | 0.09 | 0.1 | 117087.0 |
| 2024-06-05 | AAXJ | Stock | 71.1 | 71.46 | 70.79 | 71.46 | 365303.0 |
| 2024-06-05 | AB | Stock | 33.58 | 34.19 | 33.42 | 33.87 | 263600.0 |
| 2024-06-05 | ABAT | Stock | 1.49 | 1.5 | 1.45 | 1.47 | 436772.0 |
| 2024-06-05 | ABBV | Stock | 162.9 | 165.98 | 162.16 | 165.44 | 5100500.0 |
| 2024-06-05 | ABCB | Stock | 47.74 | 47.83 | 47.04 | 47.55 | 180500.0 |
| 2024-06-05 | ABCL | Stock | 3.78 | 3.82 | 3.72 | 3.75 | 1539400.0 |
| 2024-06-05 | ABEO | Stock | 4.33 | 4.63 | 4.3 | 4.52 | 497900.0 |
| 2024-06-05 | ABEV | Stock | 2.22 | 2.23 | 2.17 | 2.2 | 25893400.0 |
| 2024-06-05 | ABG | Stock | 237.89 | 238.0 | 233.55 | 236.73 | 127700.0 |
| 2024-06-05 | ABLLW | Stock | 0.3411 | 0.4075 | 0.34 | 0.3401 | 38476.0 |
| 2024-06-05 | ABLV | Stock | 1.22 | 1.36 | 1.18 | 1.19 | 4800.0 |
| 2024-06-05 | ABLVW | Stock | 0.0383 | 0.0383 | 0.0376 | 0.0381 | 5227.0 |
| 2024-06-05 | ABM | Stock | 47.56 | 47.95 | 47.37 | 47.76 | 564600.0 |
| 2024-06-05 | ABNB | Stock | 147.98 | 148.7 | 145.141 | 145.78 | 3121500.0 |
| 2024-06-05 | ABOS | Stock | 2.76 | 2.76 | 2.58 | 2.58 | 560700.0 |
| 2024-06-05 | ABR | Stock | 13.86 | 14.23 | 13.72 | 14.18 | 2673200.0 |
| 2024-06-05 | ABR.D | Stock | 18.93 | 18.93 | 18.5 | 18.65 | 10408.0 |
| 2024-06-05 | ABR.E | Stock | 18.2 | 18.355 | 18.2 | 18.321 | 4107.0 |
| 2024-06-05 | ABR.F | Stock | 20.05 | 20.1223 | 19.71 | 19.71 | 13986.0 |
| 2024-06-05 | ABSI | Stock | 4.38 | 4.63 | 4.3 | 4.62 | 898900.0 |
| 2024-06-05 | ABT | Stock | 102.93 | 103.42 | 101.98 | 103.23 | 3302300.0 |
| 2024-06-05 | ABTC | Stock | 94.5 | 94.5 | 87.0 | 90.0 | 2144.0 |
> showing 50 of 7,250 rows — these rows as CSV