PREVIEW / stock_daily / 2009-05-08
file: by_date/stock_daily/2009/2009-05-08.parquet size: 181 KB rows: 5,808 symbols: 3,473
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-08 | AAPL | Stock | 4.6086 | 4.6868 | 4.5093 | 4.6139 | 467964000.0 |
| 2009-05-08 | MSFT | Stock | 19.46 | 19.64 | 19.14 | 19.42 | 67597600.0 |
| 2009-05-08 | NVDA | Stock | 0.2625 | 0.2625 | 0.2278 | 0.2312 | 2930564000.0 |
| 2009-05-08 | AMZN | Stock | 3.9845 | 4.0115 | 3.8155 | 3.8975 | 163860000.0 |
| 2009-05-08 | TLT | Stock | 95.02 | 95.39 | 94.645 | 94.94 | 2193360.0 |
| 2009-05-08 | ES | Stock | 21.42 | 21.74 | 21.1 | 21.2 | 1626900.0 |
| 2009-05-08 | CL | Stock | 31.17 | 31.225 | 30.555 | 30.91 | 6750400.0 |
| 2009-05-08 | A | Stock | 13.5622 | 13.8841 | 13.505 | 13.834 | 3597893.0 |
| 2009-05-08 | AABA-DELISTED | Stock | 14.88 | 15.3 | 14.7 | 15.15 | 22090772.0 |
| 2009-05-08 | AACC-DELISTED | Stock | 9.1 | 9.82 | 8.99 | 9.75 | 55621.0 |
| 2009-05-08 | AACG | Stock | 5.28 | 5.4 | 5.03 | 5.15 | 8800.0 |
| 2009-05-08 | AAI-DELISTED | Stock | 7.71 | 7.78 | 7.18 | 7.3 | 3388716.0 |
| 2009-05-08 | AAIC-DELISTED | Stock | 9.784 | 10.0 | 7.2 | 8.4 | 2699080.0 |
| 2009-05-08 | AAME | Stock | 0.74 | 0.8 | 0.74 | 0.8 | 6300.0 |
| 2009-05-08 | AAON | Stock | 4.1086 | 4.162 | 4.0731 | 4.1481 | 1020094.0 |
| 2009-05-08 | AAP | Stock | 42.26 | 42.54 | 41.08 | 41.7 | 1258200.0 |
| 2009-05-08 | AATI-DELISTED | Stock | 4.27 | 4.49 | 4.21 | 4.32 | 507086.0 |
| 2009-05-08 | AAU-DELISTED | Stock | 0.61 | 0.65 | 0.5906 | 0.65 | 142693.0 |
| 2009-05-08 | AAUAF-DELISTED | Stock | 0.61 | 0.65 | 0.5906 | 0.65 | 157693.0 |
| 2009-05-08 | AAV-DELISTED | Stock | 3.5 | 3.65 | 3.45 | 3.62 | 1082595.0 |
| 2009-05-08 | AAWW-DELISTED | Stock | 29.9 | 30.21 | 28.7001 | 29.57 | 291155.0 |
| 2009-05-08 | AAXJ | Stock | 42.05 | 42.89 | 41.95 | 42.87 | 374692.0 |
| 2009-05-08 | AAXN-DELISTED | Stock | 4.45 | 4.64 | 4.38 | 4.59 | 533969.0 |
| 2009-05-08 | AB | Stock | 18.39 | 18.95 | 17.75 | 18.7 | 617700.0 |
| 2009-05-08 | ABAX-DELISTED | Stock | 16.74 | 17.11 | 16.53 | 16.985 | 355394.0 |
| 2009-05-08 | ABB-DELISTED | Stock | 16.14 | 16.63 | 15.94 | 16.53 | 4269134.0 |
| 2009-05-08 | ABBC-DELISTED | Stock | 8.76 | 8.97 | 8.73 | 8.95 | 41140.0 |
| 2009-05-08 | ABBNY-DELISTED | Stock | 16.14 | 16.63 | 15.94 | 16.52 | 4274324.0 |
| 2009-05-08 | ABC-DELISTED | Stock | 18.2 | 18.33 | 18.01 | 18.12 | 2598370.0 |
| 2009-05-08 | ABCB | Stock | 5.9137 | 6.7307 | 5.9137 | 6.6237 | 24983.0 |
| 2009-05-08 | ABCO-DELISTED | Stock | 10.351 | 11.179 | 9.902 | 10.974 | 647073.0 |
| 2009-05-08 | ABCW-DELISTED | Stock | 1.63 | 1.77 | 1.57 | 1.7 | 71410.0 |
| 2009-05-08 | ABD-DELISTED | Stock | 3.21 | 3.5589 | 3.1302 | 3.18 | 476110.0 |
| 2009-05-08 | ABE-DELISTED | Stock | 14.7 | 15.03 | 14.67 | 14.93 | 23525.0 |
| 2009-05-08 | ABEO | Stock | 2062.5 | 2112.5 | 1875.0 | 1912.5 | 38.0 |
| 2009-05-08 | ABFS-DELISTED | Stock | 26.03 | 26.69 | 24.98 | 25.82 | 523788.0 |
| 2009-05-08 | ABG | Stock | 10.07 | 10.54 | 9.46 | 9.67 | 575200.0 |
| 2009-05-08 | ABII-DELISTED | Stock | 48.68 | 50.46 | 47.39 | 49.73 | 4956.0 |
| 2009-05-08 | ABK-DELISTED | Stock | 1.4 | 1.65 | 1.32 | 1.599 | 29733312.0 |
| 2009-05-08 | ABM | Stock | 17.21 | 17.25 | 16.65 | 16.91 | 246300.0 |
| 2009-05-08 | ABMD-DELISTED | Stock | 6.79 | 6.98 | 6.58 | 6.98 | 366068.0 |
| 2009-05-08 | ABR | Stock | 3.35 | 3.35 | 2.22 | 2.4 | 882100.0 |
| 2009-05-08 | ABT | Stock | 21.663 | 21.8309 | 21.4231 | 21.5574 | 20278033.0 |
| 2009-05-08 | ABTL-DELISTED | Stock | 2.4479 | 2.6042 | 2.4115 | 2.5 | 4713.0 |
| 2009-05-08 | ABV-DELISTED | Stock | 60.9 | 61.62 | 59.83 | 61.31 | 694530.0 |
| 2009-05-08 | ABVA-DELISTED | Stock | 2.13 | 2.17 | 2.05 | 2.05 | 17907.0 |
| 2009-05-08 | ABVT-DELISTED | Stock | 57.0 | 57.0 | 56.95 | 56.95 | 15800.0 |
| 2009-05-08 | ABX-DELISTED | Stock | 33.15 | 34.18 | 32.51 | 34.1 | 9702253.0 |
| 2009-05-08 | ACAD | Stock | 1.79 | 1.95 | 1.74 | 1.81 | 338800.0 |
| 2009-05-08 | ACAP-DELISTED | Stock | 41.4 | 42.08 | 40.84 | 42.08 | 50592.0 |
> showing 50 of 5,808 rows — these rows as CSV