PREVIEW / stock_daily / 2018-10-22

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-22.parquet
  size:    220 KB
  rows:    6,526
  symbols: 2,703

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-22	AAPL	Stock	54.9475	55.84	54.735	55.1625	115168400.0
2018-10-22	MSFT	Stock	109.32	110.54	108.24	109.63	26545600.0
2018-10-22	NVDA	Stock	5.782	5.883	5.6768	5.7805	368844000.0
2018-10-22	AMZN	Stock	89.2	90.475	87.8	89.465	90000000.0
2018-10-22	GOOGL	Stock	55.6255	56.0845	55.0	55.5685	27116840.0
2018-10-22	META	Stock	154.76	157.34	154.46	154.78	15424700.0
2018-10-22	TSLA	Stock	17.3787	17.4573	16.8393	17.3967	84004500.0
2018-10-22	TLT	Stock	113.95	114.08	113.53	113.56	3244179.0
2018-10-22	ES	Stock	63.32	63.71	62.95	63.2	1147100.0
2018-10-22	CL	Stock	64.56	64.79	63.49	63.64	3051800.0
2018-10-22	A	Stock	64.69	64.84	63.54	64.28	2227900.0
2018-10-22	AA	Stock	38.72	39.76	38.64	39.46	3141100.0
2018-10-22	AABA-DELISTED	Stock	62.08	62.79	61.31	62.24	4964658.0
2018-10-22	AAC-DELISTED	Stock	6.96	7.24	6.93	7.1	107535.0
2018-10-22	AACG	Stock	1.19	1.25	1.08	1.08	67300.0
2018-10-22	AAIC-DELISTED	Stock	8.4	8.57	8.4	8.42	474734.0
2018-10-22	AAL	Stock	32.27	32.52	31.82	32.16	7572100.0
2018-10-22	AAM.A-DELISTED	Stock	24.1319	24.24	24.0101	24.19	18689.0
2018-10-22	AAM.B-DELISTED	Stock	24.02	24.18	23.9572	24.1	27734.0
2018-10-22	AAMC-DELISTED	Stock	14.1176	14.7574	14.1176	14.7574	3522.0
2018-10-22	AAME	Stock	2.68	2.79	2.67	2.79	2700.0
2018-10-22	AAMI	Stock	11.98	12.0	11.7	11.81	398000.0
2018-10-22	AAOI	Stock	21.85	22.785	21.85	22.31	801900.0
2018-10-22	AAON	Stock	21.5733	21.9133	21.4333	21.5867	168900.0
2018-10-22	AAP	Stock	164.39	165.65	162.99	164.77	1426000.0
2018-10-22	AAT	Stock	36.84	37.19	36.3	36.31	69900.0
2018-10-22	AAU-DELISTED	Stock	0.59	0.59	0.53	0.5647	96858.0
2018-10-22	AAUAF-DELISTED	Stock	0.59	0.59	0.53	0.5647	102540.0
2018-10-22	AAWW-DELISTED	Stock	52.5	52.65	51.92	52.49	358796.0
2018-10-22	AAXJ	Stock	65.01	65.11	64.51	64.73	749437.0
2018-10-22	AAXN-DELISTED	Stock	55.88	59.03	55.11	57.98	638308.0
2018-10-22	AB	Stock	30.37	30.37	29.62	29.78	424300.0
2018-10-22	ABAC-DELISTED	Stock	2.15	2.15	1.75	1.784	43648.0
2018-10-22	ABB-DELISTED	Stock	21.11	21.14	20.895	20.98	1640832.0
2018-10-22	ABBNY-DELISTED	Stock	21.11	21.14	20.895	20.98	1709303.0
2018-10-22	ABBV	Stock	88.53	88.53	83.5	84.27	7621100.0
2018-10-22	ABC-DELISTED	Stock	92.96	93.5	89.65	90.22	1041653.0
2018-10-22	ABCB	Stock	44.01	44.13	42.26	42.55	363800.0
2018-10-22	ABCD-DELISTED	Stock	14.4	14.41	14.38	14.39	359433.0
2018-10-22	ABDC-DELISTED	Stock	5.92	5.9697	5.87	5.92	93728.0
2018-10-22	ABEO	Stock	235.0	239.0	215.5	235.25	48900.0
2018-10-22	ABEOW-DELISTED	Stock	4.31	4.41	4.31	4.3596	800.0
2018-10-22	ABEV	Stock	4.57	4.59	4.45	4.51	32892600.0
2018-10-22	ABG	Stock	59.77	60.28	58.92	59.55	679000.0
2018-10-22	ABIL-DELISTED	Stock	3.68	3.6999	3.02	3.1347	376704.0
2018-10-22	ABM	Stock	31.91	32.05	31.38	31.6	263700.0
2018-10-22	ABMD-DELISTED	Stock	363.02	368.69	355.61	366.2	344911.0
2018-10-22	ABR	Stock	11.83	11.98	11.83	11.86	495200.0
2018-10-22	ABR.A-DELISTED	Stock	25.41	25.4225	25.325	25.41	1800.0
2018-10-22	ABR.B-DELISTED	Stock	25.38	25.38	25.21	25.22	3880.0

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

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