PREVIEW / stock_daily / 2018-10-29

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-29.parquet
  size:    221 KB
  rows:    6,544
  symbols: 2,712

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
2018-10-29	AAPL	Stock	54.7975	54.9225	51.5225	53.06	183742000.0
2018-10-29	MSFT	Stock	108.11	108.7	101.63	103.85	55162000.0
2018-10-29	NVDA	Stock	5.0998	5.1032	4.4002	4.6405	758016000.0
2018-10-29	AMZN	Stock	83.0	83.287	74.75	76.944	277322000.0
2018-10-29	GOOGL	Stock	54.827	55.4415	50.36	51.7365	81289040.0
2018-10-29	META	Stock	148.5	148.83	139.03	142.09	31336800.0
2018-10-29	TSLA	Stock	22.498	23.144	21.7667	22.3233	217290000.0
2018-10-29	TLT	Stock	114.84	115.02	114.26	114.73	7679887.0
2018-10-29	ES	Stock	63.04	64.02	62.87	63.93	1045800.0
2018-10-29	CL	Stock	59.13	59.81	57.41	57.88	9710000.0
2018-10-29	A	Stock	63.65	64.17	61.13	62.08	2919900.0
2018-10-29	AA	Stock	34.6	35.12	33.4	33.82	2219600.0
2018-10-29	AABA-DELISTED	Stock	60.56	60.77	56.1	56.86	6884761.0
2018-10-29	AAC-DELISTED	Stock	6.74	6.9	6.52	6.53	208537.0
2018-10-29	AACG	Stock	1.19	1.19	1.08	1.12	37900.0
2018-10-29	AAIC-DELISTED	Stock	8.45	8.56	8.33	8.38	344411.0
2018-10-29	AAL	Stock	33.14	33.99	31.95	32.6	9405500.0
2018-10-29	AAM.A-DELISTED	Stock	24.64	24.799	24.627	24.79	12319.0
2018-10-29	AAM.B-DELISTED	Stock	24.5386	24.7499	24.5386	24.748	27043.0
2018-10-29	AAMC-DELISTED	Stock	14.0147	14.0147	11.6807	11.7647	26663.0
2018-10-29	AAME	Stock	2.94	2.94	2.71	2.71	1300.0
2018-10-29	AAMI	Stock	11.49	11.62	11.35	11.43	363300.0
2018-10-29	AAOI	Stock	20.86	21.453	20.085	20.32	1067300.0
2018-10-29	AAON	Stock	22.2933	22.9333	21.6533	21.8667	205500.0
2018-10-29	AAP	Stock	166.71	168.52	162.91	164.87	1627400.0
2018-10-29	AAT	Stock	37.34	37.92	37.28	37.85	306500.0
2018-10-29	AAU-DELISTED	Stock	0.572	0.572	0.543	0.5703	131176.0
2018-10-29	AAUAF-DELISTED	Stock	0.572	0.572	0.543	0.5703	136688.0
2018-10-29	AAWW-DELISTED	Stock	51.78	52.44	48.82	49.25	131068.0
2018-10-29	AAXJ	Stock	62.41	62.47	60.48	61.12	1547641.0
2018-10-29	AAXN-DELISTED	Stock	58.08	59.35	54.81	55.87	346559.0
2018-10-29	AB	Stock	28.68	29.04	28.08	28.46	360800.0
2018-10-29	ABAC-DELISTED	Stock	1.68	1.7422	1.68	1.68	5901.0
2018-10-29	ABB-DELISTED	Stock	19.75	19.75	19.08	19.3	4603826.0
2018-10-29	ABBNY-DELISTED	Stock	19.75	19.75	19.08	19.29	5346888.0
2018-10-29	ABBV	Stock	82.15	83.17	79.94	81.36	4343900.0
2018-10-29	ABC-DELISTED	Stock	85.91	87.73	84.88	86.02	620443.0
2018-10-29	ABCB	Stock	42.32	43.16	41.81	42.33	167400.0
2018-10-29	ABCD-DELISTED	Stock	14.36	14.43	14.36	14.405	424246.0
2018-10-29	ABDC-DELISTED	Stock	5.81	5.98	5.71	5.98	55694.0
2018-10-29	ABEO	Stock	227.0	234.5	218.25	223.0	20620.0
2018-10-29	ABEOW-DELISTED	Stock	4.57	4.6	4.55	4.55	4417.0
2018-10-29	ABEV	Stock	4.25	4.28	4.08	4.12	38976500.0
2018-10-29	ABG	Stock	67.96	68.71	63.99	65.05	790000.0
2018-10-29	ABIL-DELISTED	Stock	3.05	3.07	2.88	2.96	34135.0
2018-10-29	ABM	Stock	30.87	31.37	29.91	30.3	676400.0
2018-10-29	ABMD-DELISTED	Stock	331.39	339.69	313.4	320.03	519776.0
2018-10-29	ABR	Stock	11.86	12.04	11.73	11.78	978600.0
2018-10-29	ABR.A-DELISTED	Stock	25.5	25.6862	25.5	25.5	1800.0
2018-10-29	ABR.B-DELISTED	Stock	25.2711	25.4007	25.2711	25.35	2783.0

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

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