PREVIEW / stock_daily / 2013-03-04
file: by_date/stock_daily/2013/2013-03-04.parquet size: 207 KB rows: 6,293 symbols: 3,512
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-04 | AAPL | Stock | 15.2786 | 15.2929 | 14.9643 | 15.0018 | 582755600.0 |
| 2013-03-04 | MSFT | Stock | 27.85 | 28.15 | 27.7 | 28.15 | 38157500.0 |
| 2013-03-04 | NVDA | Stock | 0.3155 | 0.3195 | 0.313 | 0.3165 | 353680000.0 |
| 2013-03-04 | AMZN | Stock | 13.268 | 13.665 | 13.207 | 13.6555 | 69060000.0 |
| 2013-03-04 | META | Stock | 27.76 | 28.06 | 27.44 | 27.72 | 32400700.0 |
| 2013-03-04 | TSLA | Stock | 2.318 | 2.3887 | 2.3133 | 2.372 | 26365500.0 |
| 2013-03-04 | TLT | Stock | 118.79 | 118.97 | 118.26 | 118.27 | 4511507.0 |
| 2013-03-04 | ES | Stock | 41.67 | 42.5 | 41.67 | 42.3 | 1381300.0 |
| 2013-03-04 | CL | Stock | 57.04 | 57.44 | 56.93 | 57.42 | 2275200.0 |
| 2013-03-04 | A | Stock | 29.8641 | 30.1717 | 29.6996 | 30.0644 | 3404270.0 |
| 2013-03-04 | AABA-DELISTED | Stock | 22.33 | 22.74 | 22.2 | 22.7 | 29164038.0 |
| 2013-03-04 | AACC-DELISTED | Stock | 5.21 | 5.8 | 5.21 | 5.77 | 14190.0 |
| 2013-03-04 | AACG | Stock | 4.22 | 4.66 | 4.0 | 4.1 | 5200.0 |
| 2013-03-04 | AAIC-DELISTED | Stock | 26.1 | 26.3218 | 25.911 | 26.04 | 194634.0 |
| 2013-03-04 | AAMC-DELISTED | Stock | 37.0588 | 39.6912 | 37.0588 | 38.3088 | 45693.0 |
| 2013-03-04 | AAME | Stock | 3.42 | 3.42 | 3.35 | 3.4 | 22900.0 |
| 2013-03-04 | AAMRQ-DELISTED | Stock | 2.535 | 2.71 | 2.53 | 2.64 | 8715347.0 |
| 2013-03-04 | AAON | Stock | 7.1111 | 7.2178 | 7.0489 | 7.197 | 206213.0 |
| 2013-03-04 | AAP | Stock | 76.24 | 77.25 | 76.1 | 77.02 | 1098400.0 |
| 2013-03-04 | AAT | Stock | 30.54 | 31.01 | 30.43 | 30.97 | 120400.0 |
| 2013-03-04 | AAU-DELISTED | Stock | 1.99 | 2.0 | 1.85 | 1.85 | 540071.0 |
| 2013-03-04 | AAUAF-DELISTED | Stock | 1.99 | 2.0 | 1.85 | 1.85 | 547433.0 |
| 2013-03-04 | AAV-DELISTED | Stock | 3.01 | 3.05 | 2.98 | 2.99 | 236006.0 |
| 2013-03-04 | AAWW-DELISTED | Stock | 46.5 | 46.5 | 45.33 | 45.64 | 324542.0 |
| 2013-03-04 | AAXJ | Stock | 59.58 | 59.66 | 59.29 | 59.66 | 454439.0 |
| 2013-03-04 | AAXN-DELISTED | Stock | 7.43 | 7.87 | 7.43 | 7.85 | 1220541.0 |
| 2013-03-04 | AB | Stock | 22.76 | 22.9 | 22.5 | 22.67 | 388100.0 |
| 2013-03-04 | ABAC-DELISTED | Stock | 0.877 | 0.88 | 0.85 | 0.88 | 2074.0 |
| 2013-03-04 | ABAX-DELISTED | Stock | 42.97 | 43.1399 | 42.19 | 43.02 | 111177.0 |
| 2013-03-04 | ABB-DELISTED | Stock | 22.4 | 22.685 | 22.34 | 22.65 | 1986912.0 |
| 2013-03-04 | ABBNY-DELISTED | Stock | 22.4 | 22.685 | 22.34 | 22.66 | 2233240.0 |
| 2013-03-04 | ABBV | Stock | 37.53 | 38.25 | 37.53 | 38.24 | 5420800.0 |
| 2013-03-04 | ABC-DELISTED | Stock | 47.78 | 48.25 | 47.66 | 48.24 | 2112888.0 |
| 2013-03-04 | ABCB | Stock | 13.9 | 14.1 | 13.87 | 13.99 | 34400.0 |
| 2013-03-04 | ABCD-DELISTED | Stock | 1.22 | 1.22 | 1.11 | 1.12 | 26109.0 |
| 2013-03-04 | ABCO-DELISTED | Stock | 52.23 | 53.29 | 51.62 | 53.19 | 316519.0 |
| 2013-03-04 | ABCW-DELISTED | Stock | 0.6 | 0.6 | 0.59 | 0.59 | 10894.0 |
| 2013-03-04 | ABE-DELISTED | Stock | 21.43 | 21.43 | 21.11 | 21.2 | 13159.0 |
| 2013-03-04 | ABFS-DELISTED | Stock | 11.05 | 11.21 | 10.87 | 10.9 | 393067.0 |
| 2013-03-04 | ABG | Stock | 33.45 | 34.02 | 32.66 | 33.26 | 495400.0 |
| 2013-03-04 | ABM | Stock | 22.73 | 22.91 | 22.54 | 22.74 | 370200.0 |
| 2013-03-04 | ABMD-DELISTED | Stock | 15.93 | 16.42 | 15.72 | 15.87 | 476192.0 |
| 2013-03-04 | ABR | Stock | 7.94 | 8.2 | 7.91 | 8.1 | 284600.0 |
| 2013-03-04 | ABR.A-DELISTED | Stock | 25.47 | 25.55 | 25.37 | 25.4 | 10400.0 |
| 2013-03-04 | ABT | Stock | 33.51 | 34.33 | 33.4 | 34.31 | 6613700.0 |
| 2013-03-04 | ABTL-DELISTED | Stock | 4.24 | 4.47 | 4.24 | 4.3 | 23173.0 |
| 2013-03-04 | ABUS | Stock | 4.5 | 4.5 | 4.42 | 4.49 | 9500.0 |
| 2013-03-04 | ABV-DELISTED | Stock | 44.7 | 44.955 | 44.57 | 44.89 | 1305112.0 |
| 2013-03-04 | ABX-DELISTED | Stock | 29.34 | 29.45 | 28.51 | 28.64 | 12681162.0 |
| 2013-03-04 | ACAD | Stock | 6.37 | 6.5 | 6.25 | 6.33 | 895100.0 |
> showing 50 of 6,293 rows — these rows as CSV