PREVIEW / stock_daily / 2010-10-29
file: by_date/stock_daily/2010/2010-10-29.parquet size: 193 KB rows: 6,006 symbols: 3,520
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-29 | AAPL | Stock | 10.8654 | 10.9243 | 10.7454 | 10.7493 | 430511200.0 |
| 2010-10-29 | MSFT | Stock | 27.15 | 27.2 | 26.48 | 26.67 | 114193200.0 |
| 2010-10-29 | NVDA | Stock | 0.3008 | 0.3038 | 0.2975 | 0.3005 | 554664000.0 |
| 2010-10-29 | AMZN | Stock | 8.29 | 8.425 | 8.2405 | 8.2615 | 99970000.0 |
| 2010-10-29 | TSLA | Stock | 1.4093 | 1.4567 | 1.4033 | 1.456 | 4209000.0 |
| 2010-10-29 | TLT | Stock | 99.82 | 100.4601 | 99.62 | 100.42 | 6753774.0 |
| 2010-10-29 | ES | Stock | 31.15 | 31.46 | 31.0 | 31.28 | 1336400.0 |
| 2010-10-29 | CL | Stock | 37.68 | 38.72 | 37.45 | 38.56 | 8847000.0 |
| 2010-10-29 | A | Stock | 24.907 | 25.0429 | 24.7639 | 24.8927 | 2703592.0 |
| 2010-10-29 | AABA-DELISTED | Stock | 16.37 | 16.52 | 16.33 | 16.5 | 15416098.0 |
| 2010-10-29 | AACC-DELISTED | Stock | 5.54 | 5.8 | 5.5 | 5.8 | 10542.0 |
| 2010-10-29 | AACG | Stock | 3.21 | 3.28 | 3.21 | 3.28 | 1000.0 |
| 2010-10-29 | AAI-DELISTED | Stock | 7.41 | 7.44 | 7.38 | 7.4 | 12009939.0 |
| 2010-10-29 | AAIC-DELISTED | Stock | 22.9 | 23.9 | 22.81 | 23.69 | 59186.0 |
| 2010-10-29 | AAON | Stock | 4.8593 | 4.879 | 4.8395 | 4.8494 | 89100.0 |
| 2010-10-29 | AAP | Stock | 63.9 | 65.01 | 63.49 | 64.98 | 1058500.0 |
| 2010-10-29 | AATI-DELISTED | Stock | 3.78 | 3.8 | 3.76 | 3.76 | 165538.0 |
| 2010-10-29 | AAU-DELISTED | Stock | 2.88 | 2.89 | 2.83 | 2.89 | 163379.0 |
| 2010-10-29 | AAUAF-DELISTED | Stock | 2.89 | 2.9 | 2.84 | 2.88 | 163124.0 |
| 2010-10-29 | AAV-DELISTED | Stock | 6.13 | 6.27 | 6.13 | 6.207 | 423908.0 |
| 2010-10-29 | AAWW-DELISTED | Stock | 53.05 | 53.4901 | 51.98 | 52.25 | 245566.0 |
| 2010-10-29 | AAXJ | Stock | 62.08 | 62.36 | 61.94 | 62.29 | 502916.0 |
| 2010-10-29 | AAXN-DELISTED | Stock | 3.93 | 4.01 | 3.88 | 3.96 | 381976.0 |
| 2010-10-29 | AB | Stock | 24.65 | 24.94 | 23.78 | 24.4 | 1380700.0 |
| 2010-10-29 | ABAC-DELISTED | Stock | 5.99 | 5.99 | 5.69 | 5.69 | 26905.0 |
| 2010-10-29 | ABAX-DELISTED | Stock | 23.75 | 24.09 | 23.5 | 24.01 | 67975.0 |
| 2010-10-29 | ABB-DELISTED | Stock | 20.74 | 20.8 | 20.59 | 20.68 | 2118937.0 |
| 2010-10-29 | ABBC-DELISTED | Stock | 10.65 | 10.82 | 10.55 | 10.74 | 36017.0 |
| 2010-10-29 | ABBNY-DELISTED | Stock | 20.74 | 20.8 | 20.59 | 20.69 | 2137276.0 |
| 2010-10-29 | ABC-DELISTED | Stock | 33.31 | 33.35 | 32.7 | 32.83 | 3206216.0 |
| 2010-10-29 | ABCB | Stock | 9.27 | 9.31 | 9.25 | 9.27 | 51400.0 |
| 2010-10-29 | ABCD-DELISTED | Stock | 3.0 | 3.2 | 3.0 | 3.1 | 25789.0 |
| 2010-10-29 | ABCO-DELISTED | Stock | 23.32 | 23.55 | 23.24 | 23.4 | 42103.0 |
| 2010-10-29 | ABCW-DELISTED | Stock | 0.67 | 0.6897 | 0.6627 | 0.67 | 40870.0 |
| 2010-10-29 | ABD-DELISTED | Stock | 6.17 | 6.27 | 6.15 | 6.23 | 451900.0 |
| 2010-10-29 | ABE-DELISTED | Stock | 18.95 | 19.09 | 18.929 | 19.08 | 3565.0 |
| 2010-10-29 | ABEO | Stock | 3700.0 | 3787.5 | 3700.0 | 3750.0 | 29.0 |
| 2010-10-29 | ABFS-DELISTED | Stock | 25.15 | 25.45 | 24.95 | 25.31 | 129673.0 |
| 2010-10-29 | ABG | Stock | 14.33 | 14.59 | 14.26 | 14.42 | 140600.0 |
| 2010-10-29 | ABK-DELISTED | Stock | 0.9 | 0.902 | 0.82 | 0.8278 | 13050112.0 |
| 2010-10-29 | ABM | Stock | 22.5 | 22.72 | 22.4 | 22.55 | 153300.0 |
| 2010-10-29 | ABMD-DELISTED | Stock | 10.22 | 10.35 | 10.22 | 10.3 | 78236.0 |
| 2010-10-29 | ABR | Stock | 5.31 | 5.36 | 5.27 | 5.3 | 44100.0 |
| 2010-10-29 | ABT | Stock | 24.844 | 24.8824 | 24.4362 | 24.6233 | 21343268.0 |
| 2010-10-29 | ABTL-DELISTED | Stock | 4.0 | 4.299 | 3.995 | 4.2 | 10925.0 |
| 2010-10-29 | ABV-DELISTED | Stock | 135.97 | 139.4 | 135.97 | 139.21 | 812154.0 |
| 2010-10-29 | ABVA-DELISTED | Stock | 2.87 | 2.93 | 2.8497 | 2.92 | 4500.0 |
| 2010-10-29 | ABVT-DELISTED | Stock | 56.22 | 57.15 | 55.96 | 56.91 | 96272.0 |
| 2010-10-29 | ABX-DELISTED | Stock | 47.55 | 48.31 | 47.47 | 48.09 | 8257854.0 |
| 2010-10-29 | ACAD | Stock | 0.76 | 0.8 | 0.74 | 0.76 | 381700.0 |
> showing 50 of 6,006 rows — these rows as CSV