PREVIEW / stock_daily / 2025-01-27
file: by_date/stock_daily/2025/2025-01-27.parquet size: 245 KB rows: 7,147 symbols: 522
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-27 | AAPL | Stock | 224.02 | 232.15 | 223.98 | 229.86 | 90518098.0 |
| 2025-01-27 | MSFT | Stock | 424.01 | 435.2 | 423.5 | 434.56 | 32806233.0 |
| 2025-01-27 | NVDA | Stock | 124.8 | 128.4 | 116.7 | 118.42 | 810353797.0 |
| 2025-01-27 | AMZN | Stock | 226.21 | 235.61 | 225.86 | 235.42 | 47966359.0 |
| 2025-01-27 | GOOGL | Stock | 192.41 | 196.88 | 190.73 | 191.81 | 41728893.0 |
| 2025-01-27 | META | Stock | 626.61 | 663.87 | 625.1 | 659.88 | 27637379.0 |
| 2025-01-27 | TSLA | Stock | 394.8 | 406.69 | 389.0 | 397.15 | 57325762.0 |
| 2025-01-27 | TLT | Stock | 88.155 | 88.43 | 87.85 | 88.25 | 42864203.0 |
| 2025-01-27 | ES | Stock | 56.9 | 58.56 | 56.825 | 58.23 | 5780816.0 |
| 2025-01-27 | CL | Stock | 89.53 | 91.41 | 88.96 | 91.21 | 5009130.0 |
| 2025-01-27 | A | Stock | 151.56 | 152.22 | 148.7301 | 150.96 | 2165473.0 |
| 2025-01-27 | AA | Stock | 36.27 | 36.6 | 34.91 | 34.97 | 8114608.0 |
| 2025-01-27 | AACG | Stock | 0.8 | 0.8401 | 0.8 | 0.8301 | 22186.0 |
| 2025-01-27 | AACT | Stock | 11.015 | 11.015 | 11.0 | 11.01 | 11677.0 |
| 2025-01-27 | AAGR-DELISTED | Stock | 0.0 | 0.008 | 0.0 | 0.0 | 3078.0 |
| 2025-01-27 | AAL | Stock | 16.82 | 17.54 | 16.705 | 17.2 | 39926683.0 |
| 2025-01-27 | AAM | Stock | 10.15 | 10.19 | 10.13 | 10.154 | 144852.0 |
| 2025-01-27 | AAME | Stock | 1.44 | 1.65 | 1.44 | 1.65 | 33465.0 |
| 2025-01-27 | AAMI | Stock | 25.0 | 25.87 | 25.0 | 25.38 | 113452.0 |
| 2025-01-27 | AAOI | Stock | 28.58 | 29.72 | 23.94 | 24.54 | 6320008.0 |
| 2025-01-27 | AAON | Stock | 129.28 | 129.385 | 110.82 | 112.7 | 1792749.0 |
| 2025-01-27 | AAP | Stock | 48.35 | 49.38 | 47.9941 | 49.22 | 1767107.0 |
| 2025-01-27 | AAPG | Stock | 17.39 | 17.5 | 17.0 | 17.25 | 315841.0 |
| 2025-01-27 | AAT | Stock | 24.36 | 25.06 | 24.305 | 24.92 | 224898.0 |
| 2025-01-27 | AATC | Stock | 8.5 | 8.6125 | 7.76 | 8.47 | 28966.0 |
| 2025-01-27 | AAUAF-DELISTED | Stock | 0.08 | 0.099 | 0.079 | 0.08 | 41785.0 |
| 2025-01-27 | AAXJ | Stock | 71.72 | 71.97 | 71.42 | 71.6 | 695144.0 |
| 2025-01-27 | AB | Stock | 40.28 | 40.6 | 39.26 | 39.96 | 760936.0 |
| 2025-01-27 | ABAT | Stock | 1.32 | 1.44 | 1.2301 | 1.32 | 3819717.0 |
| 2025-01-27 | ABBV | Stock | 172.66 | 177.45 | 172.59 | 176.9 | 6792422.0 |
| 2025-01-27 | ABCB | Stock | 64.91 | 66.18 | 64.505 | 65.1 | 294013.0 |
| 2025-01-27 | ABCL | Stock | 3.38 | 3.4599 | 3.265 | 3.36 | 4049049.0 |
| 2025-01-27 | ABEO | Stock | 5.24 | 5.7 | 5.24 | 5.3 | 477367.0 |
| 2025-01-27 | ABEV | Stock | 1.815 | 1.84 | 1.8 | 1.83 | 134909361.0 |
| 2025-01-27 | ABG | Stock | 262.5 | 272.0 | 261.085 | 271.12 | 177876.0 |
| 2025-01-27 | ABLLW | Stock | 1.08 | 1.1 | 1.05 | 1.06 | 13610.0 |
| 2025-01-27 | ABLV | Stock | 1.01 | 1.14 | 1.01 | 1.14 | 5906.0 |
| 2025-01-27 | ABLVW | Stock | 0.0396 | 0.0396 | 0.0202 | 0.0202 | 1261.0 |
| 2025-01-27 | ABM | Stock | 52.63 | 53.29 | 52.475 | 53.09 | 255986.0 |
| 2025-01-27 | ABNB | Stock | 125.94 | 129.06 | 125.64 | 128.96 | 4654579.0 |
| 2025-01-27 | ABOS | Stock | 1.62 | 1.728 | 1.575 | 1.62 | 203349.0 |
| 2025-01-27 | ABPWW | Stock | 0.0625 | 0.0625 | 0.05 | 0.05 | 34947.0 |
| 2025-01-27 | ABR | Stock | 13.34 | 13.635 | 13.29 | 13.61 | 2274465.0 |
| 2025-01-27 | ABR.D | Stock | 18.45 | 18.5 | 18.3501 | 18.47 | 6696.0 |
| 2025-01-27 | ABR.E | Stock | 18.18 | 18.2 | 18.13 | 18.2 | 3418.0 |
| 2025-01-27 | ABR.F | Stock | 22.15 | 22.46 | 22.125 | 22.46 | 28387.0 |
| 2025-01-27 | ABSI | Stock | 3.88 | 4.1981 | 3.67 | 3.81 | 4278632.0 |
| 2025-01-27 | ABT | Stock | 126.73 | 129.76 | 125.474 | 129.43 | 11675902.0 |
| 2025-01-27 | ABTC | Stock | 28.5 | 29.025000000000002 | 24.8025 | 25.98 | 40754.666666666664 |
| 2025-01-27 | ABTS | Stock | 7.6485 | 7.65 | 7.05 | 7.05 | 1324.0 |
> showing 50 of 7,147 rows — these rows as CSV