PREVIEW / stock_daily / 2019-09-27

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-27.parquet
  size:    220 KB
  rows:    6,600
  symbols: 2,503

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-09-27	AAPL	Stock	55.135	55.24	54.32	54.705	101408000.0
2019-09-27	MSFT	Stock	140.15	140.36	136.65	137.73	22477700.0
2019-09-27	NVDA	Stock	4.3915	4.4425	4.233	4.294	362056000.0
2019-09-27	AMZN	Stock	87.4	87.456	85.691	86.2725	78144000.0
2019-09-27	GOOGL	Stock	62.1415	62.2495	60.76	61.2975	34449620.0
2019-09-27	META	Stock	180.49	180.76	175.66	177.1	14656200.0
2019-09-27	TSLA	Stock	16.1467	16.5807	15.9153	16.142	166746000.0
2019-09-27	TLT	Stock	142.32	142.975	142.14	142.73	10387398.0
2019-09-27	ES	Stock	85.44	85.62	84.67	85.34	1420000.0
2019-09-27	CL	Stock	73.14	73.35	72.65	73.26	3766200.0
2019-09-27	A	Stock	77.02	77.31	75.92	76.39	1639800.0
2019-09-27	AA	Stock	21.08	21.23	20.43	20.61	3087400.0
2019-09-27	AABA-DELISTED	Stock	19.68	19.735	19.55	19.59	16978872.0
2019-09-27	AAC-DELISTED	Stock	0.7278	0.7289	0.6322	0.6948	82688.0
2019-09-27	AACG	Stock	1.71	1.71	1.66	1.66	10900.0
2019-09-27	AAIC-DELISTED	Stock	5.51	5.52	5.425	5.45	540640.0
2019-09-27	AAIC.C-DELISTED	Stock	21.17	21.27	21.17	21.21	1437.0
2019-09-27	AAL	Stock	27.01	27.81	26.91	27.01	5155100.0
2019-09-27	AAM.A-DELISTED	Stock	26.4476	26.51	26.3195	26.51	17859.0
2019-09-27	AAM.B-DELISTED	Stock	26.7557	26.9	26.6361	26.9	18096.0
2019-09-27	AAMC-DELISTED	Stock	3.3235	3.3235	3.0956	3.1029	10652.0
2019-09-27	AAME	Stock	2.77	2.77	2.77	2.77	100.0
2019-09-27	AAMI	Stock	9.97	10.15	9.9	10.0	492600.0
2019-09-27	AAOI	Stock	11.19	11.296	10.77	11.125	418800.0
2019-09-27	AAON	Stock	30.8267	31.38	30.1933	30.3333	401550.0
2019-09-27	AAP	Stock	161.13	162.42	160.45	161.68	531900.0
2019-09-27	AAT	Stock	46.89	47.15	46.57	46.84	325300.0
2019-09-27	AAU-DELISTED	Stock	0.68	0.6901	0.6762	0.6762	119943.0
2019-09-27	AAUAF-DELISTED	Stock	0.68	0.6901	0.6762	0.6762	123930.0
2019-09-27	AAWW-DELISTED	Stock	24.71	25.64	24.47	24.89	211783.0
2019-09-27	AAXJ	Stock	66.8	66.96	65.57	65.88	3268086.0
2019-09-27	AAXN-DELISTED	Stock	59.32	59.32	57.61	58.31	272090.0
2019-09-27	AB	Stock	29.68	29.68	28.87	29.38	175000.0
2019-09-27	ABB-DELISTED	Stock	19.58	19.62	19.48	19.57	928966.0
2019-09-27	ABBNY-DELISTED	Stock	19.58	19.62	19.48	19.57	991238.0
2019-09-27	ABBV	Stock	74.21	75.14	73.92	74.85	7677300.0
2019-09-27	ABC-DELISTED	Stock	82.33	82.36	80.43	80.93	1012492.0
2019-09-27	ABCB	Stock	39.67	40.31	39.66	40.26	512000.0
2019-09-27	ABDC-DELISTED	Stock	8.87	8.87	8.8021	8.86	6247.0
2019-09-27	ABEO	Stock	58.25	63.75	58.25	61.5	11156.0
2019-09-27	ABEV	Stock	4.68	4.72	4.65	4.69	12871200.0
2019-09-27	ABG	Stock	100.98	101.36	99.74	100.96	146200.0
2019-09-27	ABIL-DELISTED	Stock	0.58	0.5988	0.54	0.5701	7277.0
2019-09-27	ABM	Stock	36.91	37.0	36.08	36.36	618500.0
2019-09-27	ABMD-DELISTED	Stock	179.31	179.3893	174.44	175.97	439196.0
2019-09-27	ABR	Stock	13.15	13.17	13.0	13.01	580700.0
2019-09-27	ABR.A-DELISTED	Stock	26.1596	26.34	26.0396	26.0396	2500.0
2019-09-27	ABR.B-DELISTED	Stock	25.79	26.1	25.75	26.1	1400.0
2019-09-27	ABR.C-DELISTED	Stock	26.4	26.4	26.24	26.24	900.0
2019-09-27	ABT	Stock	83.04	83.34	81.42	81.84	3396600.0

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

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