PREVIEW / stock_daily / 2018-12-21

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-21.parquet
  size:    222 KB
  rows:    6,601
  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-12-21	AAPL	Stock	39.215	39.54	37.4075	37.6825	382978400.0
2018-12-21	MSFT	Stock	101.63	103.0	97.46	98.23	111242100.0
2018-12-21	NVDA	Stock	3.4042	3.4375	3.2115	3.2393	863740000.0
2018-12-21	AMZN	Stock	73.2495	74.0	68.198	68.8725	272806000.0
2018-12-21	GOOGL	Stock	51.602	51.8835	49.0595	49.5625	104649800.0
2018-12-21	META	Stock	133.39	134.9	123.42	124.95	56901500.0
2018-12-21	TSLA	Stock	21.16	21.5647	20.8293	21.318	120252000.0
2018-12-21	TLT	Stock	121.14	121.21	120.39	120.72	9945103.0
2018-12-21	ES	Stock	66.87	68.79	66.47	66.47	3747000.0
2018-12-21	CL	Stock	60.61	62.08	59.89	59.91	10032400.0
2018-12-21	A	Stock	65.22	66.23	63.22	63.29	4683100.0
2018-12-21	AA	Stock	27.33	27.43	26.19	26.39	4323600.0
2018-12-21	AABA-DELISTED	Stock	57.25	57.52	55.08	55.63	11960121.0
2018-12-21	AAC-DELISTED	Stock	1.63	1.63	1.55	1.57	257780.0
2018-12-21	AACG	Stock	1.0	1.02	1.0	1.01	80400.0
2018-12-21	AAIC-DELISTED	Stock	7.66	7.89	7.59	7.7	944494.0
2018-12-21	AAL	Stock	31.95	32.65	30.65	30.78	11800600.0
2018-12-21	AAM.A-DELISTED	Stock	21.06	21.6587	21.06	21.58	120350.0
2018-12-21	AAM.B-DELISTED	Stock	21.12	21.5277	21.0972	21.4	84677.0
2018-12-21	AAMC-DELISTED	Stock	11.4676	11.4676	8.8353	8.8353	46716.0
2018-12-21	AAME	Stock	2.34	2.34	2.33	2.33	4100.0
2018-12-21	AAMI	Stock	10.34	10.48	10.11	10.13	914700.0
2018-12-21	AAOI	Stock	15.2	15.4	14.141	14.53	1762900.0
2018-12-21	AAON	Stock	22.6533	22.7467	21.6867	21.8467	694050.0
2018-12-21	AAP	Stock	151.57	155.89	150.34	151.41	1872900.0
2018-12-21	AAT	Stock	40.41	41.07	39.99	40.21	592200.0
2018-12-21	AAU-DELISTED	Stock	0.575	0.5999	0.5722	0.586	188920.0
2018-12-21	AAUAF-DELISTED	Stock	0.575	0.5999	0.5722	0.586	196999.0
2018-12-21	AAWW-DELISTED	Stock	38.95	39.7516	36.85	36.87	690210.0
2018-12-21	AAXJ	Stock	63.28	63.63	62.48	62.7	1478054.0
2018-12-21	AAXN-DELISTED	Stock	41.5	43.4	41.3333	41.82	1864984.0
2018-12-21	AB	Stock	24.83	25.73	24.21	24.29	744600.0
2018-12-21	ABAC-DELISTED	Stock	0.92	0.98	0.92	0.9518	12892.0
2018-12-21	ABB-DELISTED	Stock	18.74	18.83	18.4	18.43	2894857.0
2018-12-21	ABBNY-DELISTED	Stock	18.74	18.83	18.4	18.44	3030341.0
2018-12-21	ABBV	Stock	84.63	88.71	83.22	84.92	16044700.0
2018-12-21	ABC-DELISTED	Stock	73.21	75.56	71.545	71.97	2168486.0
2018-12-21	ABCB	Stock	31.27	31.84	30.54	30.85	1245100.0
2018-12-21	ABDC-DELISTED	Stock	6.3	6.39	6.25	6.29	46360.0
2018-12-21	ABEO	Stock	168.0	173.0	161.25	163.5	117492.0
2018-12-21	ABEV	Stock	3.85	3.89	3.81	3.84	21912100.0
2018-12-21	ABG	Stock	64.46	66.68	62.44	62.5	740500.0
2018-12-21	ABIL-DELISTED	Stock	2.16	2.2135	1.8986	1.9414	163220.0
2018-12-21	ABM	Stock	31.04	31.23	29.98	30.19	1371000.0
2018-12-21	ABMD-DELISTED	Stock	283.8	294.04	283.31	290.29	903671.0
2018-12-21	ABR	Stock	10.15	10.37	9.96	9.96	2414700.0
2018-12-21	ABR.A-DELISTED	Stock	24.16	24.8999	24.16	24.27	3200.0
2018-12-21	ABR.B-DELISTED	Stock	23.47	24.42	23.47	24.4187	3950.0
2018-12-21	ABR.C-DELISTED	Stock	24.52	25.1	24.52	25.1	11583.0
2018-12-21	ABT	Stock	68.07	69.13	67.02	67.27	14240800.0

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

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