PREVIEW / stock_daily / 2019-11-22

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-22.parquet
  size:    221 KB
  rows:    6,590
  symbols: 2,441

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
2019-11-22	AAPL	Stock	65.6475	65.795	65.21	65.445	65325200.0
2019-11-22	MSFT	Stock	150.07	150.3	148.82	149.59	15901800.0
2019-11-22	NVDA	Stock	5.2773	5.324	5.2485	5.2722	224100000.0
2019-11-22	AMZN	Stock	86.951	87.3215	86.55	87.286	49582000.0
2019-11-22	GOOGL	Stock	65.15	65.345	64.4681	64.6835	27778240.0
2019-11-22	META	Stock	198.38	199.3	197.62	198.82	9959800.0
2019-11-22	TSLA	Stock	22.6773	22.7333	22.0	22.2027	253059000.0
2019-11-22	TLT	Stock	140.1	140.28	139.68	139.9	4666026.0
2019-11-22	ES	Stock	82.29	82.63	81.56	82.23	2143500.0
2019-11-22	CL	Stock	66.61	66.88	66.22	66.71	2616300.0
2019-11-22	A	Stock	78.61	79.19	78.23	79.12	1869700.0
2019-11-22	AA	Stock	20.39	20.945	20.39	20.56	4420100.0
2019-11-22	AACG	Stock	1.85	1.88	1.68	1.88	17700.0
2019-11-22	AAIC-DELISTED	Stock	5.68	5.75	5.66	5.7	166841.0
2019-11-22	AAIC.C-DELISTED	Stock	21.595	21.7745	21.595	21.75	758.0
2019-11-22	AAL	Stock	28.2	28.72	28.13	28.68	4827100.0
2019-11-22	AAM.A-DELISTED	Stock	26.59	26.6073	26.5655	26.58	15435.0
2019-11-22	AAM.B-DELISTED	Stock	26.97	27.09	26.97	27.09	11980.0
2019-11-22	AAMC-DELISTED	Stock	3.7262	3.7262	3.7133	3.7133	3434.0
2019-11-22	AAME	Stock	1.8	2.0	1.8	1.95	3900.0
2019-11-22	AAMI	Stock	9.48	9.635	9.475	9.61	270300.0
2019-11-22	AAOI	Stock	10.22	10.29	10.02	10.24	281800.0
2019-11-22	AAON	Stock	32.3933	32.7	31.4133	32.26	304350.0
2019-11-22	AAP	Stock	158.3	159.1	156.82	157.87	971600.0
2019-11-22	AAT	Stock	46.33	46.51	45.54	46.03	299000.0
2019-11-22	AAU-DELISTED	Stock	0.48	0.4843	0.4634	0.4674	129878.0
2019-11-22	AAUAF-DELISTED	Stock	0.48	0.4843	0.4634	0.4674	133547.0
2019-11-22	AAWW-DELISTED	Stock	24.5	25.15	24.2	25.03	184043.0
2019-11-22	AAXJ	Stock	69.91	69.92	69.61	69.8	353486.0
2019-11-22	AAXN-DELISTED	Stock	72.22	72.44	71.1707	72.09	242628.0
2019-11-22	AB	Stock	29.3	29.48	29.09	29.2	103100.0
2019-11-22	ABB-DELISTED	Stock	21.82	21.89	21.77	21.85	858186.0
2019-11-22	ABBNY-DELISTED	Stock	21.82	21.89	21.77	21.86	1103245.0
2019-11-22	ABBV	Stock	86.64	86.79	85.31	86.05	7784700.0
2019-11-22	ABC-DELISTED	Stock	89.1	90.52	88.67	90.25	899085.0
2019-11-22	ABCB	Stock	42.99	43.25	42.16	42.8	365200.0
2019-11-22	ABDC-DELISTED	Stock	9.05	9.06	9.02	9.06	36035.0
2019-11-22	ABEO	Stock	59.75	64.75	59.75	64.5	7080.0
2019-11-22	ABEOW-DELISTED	Stock	0.08	0.08	0.08	0.08	100.0
2019-11-22	ABEV	Stock	4.3	4.36	4.29	4.31	26588800.0
2019-11-22	ABG	Stock	109.17	110.98	108.22	109.69	214800.0
2019-11-22	ABIL-DELISTED	Stock	0.345	0.355	0.2468	0.3201	111597.0
2019-11-22	ABM	Stock	37.92	38.0	37.43	37.64	208300.0
2019-11-22	ABMD-DELISTED	Stock	188.13	190.81	180.8798	182.0	558017.0
2019-11-22	ABR	Stock	14.95	15.0	14.87	14.92	622800.0
2019-11-22	ABR.A-DELISTED	Stock	25.8	25.86	25.8	25.8465	600.0
2019-11-22	ABR.B-DELISTED	Stock	25.6283	25.661	25.62	25.64	3300.0
2019-11-22	ABR.C-DELISTED	Stock	26.03	26.0856	25.75	25.97	2300.0
2019-11-22	ABT	Stock	83.95	84.02	82.79	83.74	3964600.0
2019-11-22	ABTC	Stock	168300.0	231000.0	163800.0	217200.0	21.2

> showing 50 of 6,590 rows — these rows as CSV

> unlock the full archive -- $79 one-time