PREVIEW / stock_daily / 2013-10-16
file: by_date/stock_daily/2013/2013-10-16.parquet size: 215 KB rows: 6,444 symbols: 3,563
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-10-16 | AAPL | Stock | 17.8854 | 17.9475 | 17.8296 | 17.8968 | 251101200.0 |
| 2013-10-16 | MSFT | Stock | 34.6 | 34.9 | 34.56 | 34.64 | 35111600.0 |
| 2013-10-16 | NVDA | Stock | 0.3875 | 0.3915 | 0.387 | 0.39 | 210072000.0 |
| 2013-10-16 | AMZN | Stock | 15.419 | 15.54 | 15.2775 | 15.5245 | 43414000.0 |
| 2013-10-16 | META | Stock | 50.04 | 51.24 | 49.9 | 51.14 | 64678000.0 |
| 2013-10-16 | TSLA | Stock | 12.3267 | 12.4867 | 12.1393 | 12.2373 | 123081000.0 |
| 2013-10-16 | TLT | Stock | 104.47 | 105.86 | 104.27 | 105.85 | 14461015.0 |
| 2013-10-16 | ES | Stock | 41.32 | 41.57 | 41.17 | 41.53 | 1589200.0 |
| 2013-10-16 | CL | Stock | 61.33 | 62.35 | 61.23 | 62.28 | 2544400.0 |
| 2013-10-16 | A | Stock | 36.6381 | 37.1888 | 36.4378 | 36.8813 | 3478224.0 |
| 2013-10-16 | AABA-DELISTED | Stock | 33.9 | 34.11 | 32.83 | 33.09 | 43980025.0 |
| 2013-10-16 | AACG | Stock | 4.6 | 4.6 | 4.45 | 4.53 | 6900.0 |
| 2013-10-16 | AAIC-DELISTED | Stock | 24.1 | 24.3599 | 23.8 | 24.21 | 143832.0 |
| 2013-10-16 | AAMC-DELISTED | Stock | 173.0324 | 175.0 | 155.8824 | 157.0559 | 11563.0 |
| 2013-10-16 | AAME | Stock | 4.03 | 4.04 | 3.97 | 4.04 | 3200.0 |
| 2013-10-16 | AAMRQ-DELISTED | Stock | 5.03 | 5.16 | 5.0 | 5.14 | 4868458.0 |
| 2013-10-16 | AAOI | Stock | 10.28 | 10.28 | 10.01 | 10.25 | 7100.0 |
| 2013-10-16 | AAON | Stock | 12.0889 | 12.1511 | 11.76 | 11.8622 | 203175.0 |
| 2013-10-16 | AAP | Stock | 97.26 | 99.3 | 95.15 | 96.16 | 7301800.0 |
| 2013-10-16 | AAT | Stock | 32.19 | 32.7 | 32.12 | 32.5 | 92200.0 |
| 2013-10-16 | AAU-DELISTED | Stock | 1.23 | 1.27 | 1.21 | 1.24 | 36052.0 |
| 2013-10-16 | AAUAF-DELISTED | Stock | 1.23 | 1.27 | 1.21 | 1.24 | 36352.0 |
| 2013-10-16 | AAV-DELISTED | Stock | 3.8 | 3.87 | 3.8 | 3.81 | 73217.0 |
| 2013-10-16 | AAWW-DELISTED | Stock | 44.33 | 45.08 | 43.98 | 44.51 | 147201.0 |
| 2013-10-16 | AAXJ | Stock | 60.75 | 61.05 | 60.6 | 61.0 | 345893.0 |
| 2013-10-16 | AAXN-DELISTED | Stock | 15.0 | 15.2601 | 14.91 | 15.12 | 798475.0 |
| 2013-10-16 | AB | Stock | 20.39 | 20.89 | 20.01 | 20.73 | 375100.0 |
| 2013-10-16 | ABAC-DELISTED | Stock | 1.73 | 1.95 | 1.66 | 1.73 | 239440.0 |
| 2013-10-16 | ABAX-DELISTED | Stock | 39.13 | 39.97 | 38.58 | 38.93 | 441748.0 |
| 2013-10-16 | ABB-DELISTED | Stock | 23.13 | 23.26 | 23.1 | 23.25 | 1265948.0 |
| 2013-10-16 | ABBNY-DELISTED | Stock | 23.11 | 23.26 | 23.1 | 23.23 | 1325217.0 |
| 2013-10-16 | ABBV | Stock | 46.31 | 47.27 | 46.2 | 47.06 | 4399900.0 |
| 2013-10-16 | ABC-DELISTED | Stock | 63.03 | 63.76 | 62.94 | 63.73 | 996149.0 |
| 2013-10-16 | ABCB | Stock | 18.0 | 18.19 | 17.88 | 17.93 | 344600.0 |
| 2013-10-16 | ABCD-DELISTED | Stock | 1.34 | 1.375 | 1.335 | 1.35 | 25425.0 |
| 2013-10-16 | ABCO-DELISTED | Stock | 66.12 | 67.64 | 65.92 | 67.09 | 210837.0 |
| 2013-10-16 | ABE-DELISTED | Stock | 20.1 | 20.18 | 19.96 | 20.14 | 10569.0 |
| 2013-10-16 | ABEO | Stock | 437.5 | 487.5 | 437.5 | 487.5 | 28.0 |
| 2013-10-16 | ABFS-DELISTED | Stock | 24.15 | 24.48 | 23.4268 | 24.41 | 366856.0 |
| 2013-10-16 | ABG | Stock | 52.41 | 53.21 | 52.22 | 52.47 | 259500.0 |
| 2013-10-16 | ABM | Stock | 27.22 | 27.24 | 26.96 | 27.01 | 264100.0 |
| 2013-10-16 | ABMD-DELISTED | Stock | 20.25 | 20.45 | 20.04 | 20.26 | 253865.0 |
| 2013-10-16 | ABR | Stock | 6.76 | 6.91 | 6.76 | 6.88 | 226400.0 |
| 2013-10-16 | ABR.A-DELISTED | Stock | 24.819 | 24.819 | 24.5 | 24.5 | 200.0 |
| 2013-10-16 | ABR.B-DELISTED | Stock | 23.5 | 23.93 | 23.48 | 23.89 | 2380.0 |
| 2013-10-16 | ABT | Stock | 34.35 | 36.07 | 34.24 | 35.9 | 16953000.0 |
| 2013-10-16 | ABTL-DELISTED | Stock | 7.79 | 8.93 | 7.36 | 8.85 | 523367.0 |
| 2013-10-16 | ABUS | Stock | 9.2 | 9.49 | 8.81 | 8.82 | 259500.0 |
| 2013-10-16 | ABV-DELISTED | Stock | 39.08 | 39.34 | 38.69 | 38.86 | 1490108.0 |
| 2013-10-16 | ABX-DELISTED | Stock | 17.7 | 17.86 | 17.39 | 17.63 | 12771327.0 |
> showing 50 of 6,444 rows — these rows as CSV