PREVIEW / stock_daily / 2005-05-20
file: by_date/stock_daily/2005/2005-05-20.parquet size: 134 KB rows: 4,036 symbols: 2,511
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-20 | AAPL | Stock | 1.3304 | 1.3446 | 1.3282 | 1.3411 | 452650800.0 |
| 2005-05-20 | MSFT | Stock | 25.88 | 25.92 | 25.73 | 25.74 | 64444500.0 |
| 2005-05-20 | NVDA | Stock | 0.2151 | 0.2192 | 0.2126 | 0.2192 | 517008000.0 |
| 2005-05-20 | AMZN | Stock | 1.7725 | 1.78 | 1.748 | 1.775 | 100856000.0 |
| 2005-05-20 | CL | Stock | 25.49 | 25.58 | 25.29 | 25.56 | 3552600.0 |
| 2005-05-20 | A | Stock | 16.5236 | 16.7811 | 16.3233 | 16.7454 | 2361781.0 |
| 2005-05-20 | AABA-DELISTED | Stock | 36.5999984741211 | 36.6399993896484 | 36.1300010681152 | 36.3300018310547 | 13771900.0 |
| 2005-05-20 | AACC-DELISTED | Stock | 23.51 | 23.57 | 21.95 | 22.36 | 208645.0 |
| 2005-05-20 | AACQU-DELISTED | Stock | 6.0 | 6.0 | 6.0 | 6.0 | 1500.0 |
| 2005-05-20 | AAI-DELISTED | Stock | 9.69 | 9.79 | 9.48 | 9.69 | 1736600.0 |
| 2005-05-20 | AAIC-DELISTED | Stock | 270.0 | 271.8 | 260.2 | 268.4 | 1052000.0 |
| 2005-05-20 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 4900.0 |
| 2005-05-20 | AAON | Stock | 2.3756 | 2.3914 | 2.3664 | 2.3664 | 688753.0 |
| 2005-05-20 | AAP | Stock | 39.0 | 39.9 | 38.96 | 39.6333 | 1834800.0 |
| 2005-05-20 | AAV-DELISTED | Stock | 13.46 | 13.5 | 13.34 | 13.46 | 63800.0 |
| 2005-05-20 | AAXN-DELISTED | Stock | 11.3999996185303 | 11.6700000762939 | 11.039999961853 | 11.1199998855591 | 5303300.0 |
| 2005-05-20 | ABAX-DELISTED | Stock | 11.07 | 11.34 | 10.95 | 11.06 | 160619.0 |
| 2005-05-20 | ABB-DELISTED | Stock | 6.35 | 6.36 | 6.3 | 6.36 | 1184100.0 |
| 2005-05-20 | ABBC-DELISTED | Stock | 11.68 | 11.7 | 11.5 | 11.66 | 2110.0 |
| 2005-05-20 | ABC-DELISTED | Stock | 16.5 | 16.53 | 16.38 | 16.5 | 2978400.0 |
| 2005-05-20 | ABCB | Stock | 17.5367 | 17.5367 | 17.2936 | 17.3908 | 3393.0 |
| 2005-05-20 | ABCO-DELISTED | Stock | 22.84 | 22.84 | 22.0 | 22.64 | 263856.0 |
| 2005-05-20 | ABCW-DELISTED | Stock | 27.69 | 27.69 | 27.12 | 27.43 | 8790.0 |
| 2005-05-20 | ABE-DELISTED | Stock | 9.6 | 9.6 | 9.58 | 9.58 | 14300.0 |
| 2005-05-20 | ABFS-DELISTED | Stock | 32.39 | 32.54 | 31.87 | 32.45 | 138949.0 |
| 2005-05-20 | ABG | Stock | 14.37 | 14.4 | 14.01 | 14.28 | 45500.0 |
| 2005-05-20 | ABK-DELISTED | Stock | 72.29 | 72.36 | 71.47 | 71.84 | 556600.0 |
| 2005-05-20 | ABM | Stock | 19.49 | 19.49 | 19.06 | 19.31 | 67000.0 |
| 2005-05-20 | ABMD-DELISTED | Stock | 10.35 | 10.44 | 10.09 | 10.28 | 38230.0 |
| 2005-05-20 | ABP-DELISTED | Stock | 2.4 | 2.48 | 2.35 | 2.47 | 66500.0 |
| 2005-05-20 | ABR | Stock | 26.38 | 26.5 | 26.3 | 26.43 | 158800.0 |
| 2005-05-20 | ABT | Stock | 23.5966 | 23.5966 | 23.3855 | 23.4526 | 5602751.0 |
| 2005-05-20 | ABTL-DELISTED | Stock | 20.75 | 20.95 | 20.05 | 20.25 | 43800.0 |
| 2005-05-20 | ABV-DELISTED | Stock | 29.6 | 29.75 | 29.41 | 29.72 | 113800.0 |
| 2005-05-20 | ABVA-DELISTED | Stock | 14.8 | 14.89 | 14.8 | 14.89 | 900.0 |
| 2005-05-20 | ABX-DELISTED | Stock | 21.85 | 21.98 | 21.63 | 21.67 | 1442490.0 |
| 2005-05-20 | ACAD | Stock | 8.0 | 8.0 | 7.5 | 7.57 | 17400.0 |
| 2005-05-20 | ACAP-DELISTED | Stock | 33.85 | 34.8 | 33.75 | 34.66 | 53802.0 |
| 2005-05-20 | ACAS-DELISTED | Stock | 34.48 | 34.69 | 34.05 | 34.6 | 639755.0 |
| 2005-05-20 | ACAT-DELISTED | Stock | 21.46 | 21.92 | 21.46 | 21.87 | 47089.0 |
| 2005-05-20 | ACC-DELISTED | Stock | 20.55 | 20.65 | 20.4 | 20.65 | 87100.0 |
| 2005-05-20 | ACCL-DELISTED | Stock | 5.22 | 5.22 | 5.12 | 5.15 | 135197.0 |
| 2005-05-20 | ACE-DELISTED | Stock | 43.7 | 43.72 | 43.33 | 43.37 | 651200.0 |
| 2005-05-20 | ACF-DELISTED | Stock | 24.34 | 24.37 | 24.14 | 24.21 | 1768900.0 |
| 2005-05-20 | ACFC-DELISTED | Stock | 62.65 | 62.65 | 62.19 | 62.4 | 2374.0 |
| 2005-05-20 | ACG-DELISTED | Stock | 8.17 | 8.18 | 8.15 | 8.16 | 490900.0 |
| 2005-05-20 | ACGL | Stock | 4.83 | 4.8722 | 4.8156 | 4.8722 | 1143900.0 |
| 2005-05-20 | ACGN-DELISTED | Stock | 702.6712 | 748.0 | 702.6712 | 736.6712 | 150500.0 |
| 2005-05-20 | ACH | Stock | 20.48 | 20.5667 | 20.32 | 20.46 | 201600.0 |
| 2005-05-20 | ACH-DELISTED | Stock | 12.788 | 12.788 | 12.585 | 12.625 | 108000.0 |
> showing 50 of 4,036 rows — these rows as CSV