PREVIEW / stock_daily / 2019-12-30

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-30.parquet
  size:    222 KB
  rows:    6,596
  symbols: 2,423

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-12-30	AAPL	Stock	72.365	73.1725	71.305	72.88	144114400.0
2019-12-30	MSFT	Stock	158.99	159.02	156.73	157.59	16348400.0
2019-12-30	NVDA	Stock	5.8998	5.905	5.7765	5.808	258056000.0
2019-12-30	AMZN	Stock	93.7	94.2	92.031	92.3445	73494000.0
2019-12-30	GOOGL	Stock	67.8405	67.85	66.8918	66.9855	20011840.0
2019-12-30	META	Stock	207.86	207.9	203.9	204.41	10524300.0
2019-12-30	TSLA	Stock	28.586	28.6	27.284	27.6467	188796000.0
2019-12-30	TLT	Stock	135.89	136.9	135.66	136.82	7979841.0
2019-12-30	ES	Stock	84.11	84.42	83.78	84.41	1352500.0
2019-12-30	CL	Stock	68.87	69.1	68.55	68.79	1810700.0
2019-12-30	A	Stock	85.34	85.4	84.64	84.9	742800.0
2019-12-30	AA	Stock	21.7	21.7	21.3	21.34	2299200.0
2019-12-30	AACG	Stock	1.4	1.41	1.37	1.38	44500.0
2019-12-30	AAIC-DELISTED	Stock	5.64	5.7	5.59	5.61	597745.0
2019-12-30	AAIC.C-DELISTED	Stock	21.45	21.6786	21.31	21.31	22010.0
2019-12-30	AAL	Stock	28.5	28.53	28.07	28.3	4940300.0
2019-12-30	AAM.A-DELISTED	Stock	26.5716	26.61	26.507	26.6	13933.0
2019-12-30	AAM.B-DELISTED	Stock	27.2546	27.29	27.16	27.29	17112.0
2019-12-30	AAMC-DELISTED	Stock	3.9706	3.9706	3.25	3.2933	69523.0
2019-12-30	AAME	Stock	1.85	1.92	1.85	1.92	700.0
2019-12-30	AAMI	Stock	10.15	10.15	10.05	10.07	283600.0
2019-12-30	AAOI	Stock	11.5	11.83	11.214	11.61	484700.0
2019-12-30	AAON	Stock	33.1333	33.1867	32.58	32.92	183150.0
2019-12-30	AAP	Stock	158.35	160.26	157.43	159.12	563400.0
2019-12-30	AAT	Stock	45.11	45.51	45.01	45.5	272800.0
2019-12-30	AAU-DELISTED	Stock	0.5515	0.5869	0.5515	0.5701	243645.0
2019-12-30	AAUAF-DELISTED	Stock	0.5515	0.5869	0.5515	0.5735	268367.0
2019-12-30	AAWW-DELISTED	Stock	26.94	27.2266	26.42	26.58	160768.0
2019-12-30	AAXJ	Stock	73.86	73.86	73.17	73.26	517624.0
2019-12-30	AAXN-DELISTED	Stock	72.9	74.64	72.59	73.51	320232.0
2019-12-30	AB	Stock	29.95	30.3	29.81	30.25	253900.0
2019-12-30	ABB-DELISTED	Stock	24.16	24.16	24.01	24.02	919362.0
2019-12-30	ABBNY-DELISTED	Stock	24.16	24.16	24.01	24.02	1500246.0
2019-12-30	ABBV	Stock	89.22	89.73	88.16	88.52	7014800.0
2019-12-30	ABC-DELISTED	Stock	84.95	85.23	83.58	83.65	431192.0
2019-12-30	ABCB	Stock	42.98	43.03	42.59	42.64	231000.0
2019-12-30	ABDC-DELISTED	Stock	9.15	9.19	9.06	9.09	53729.0
2019-12-30	ABEO	Stock	84.75	88.0	80.25	87.25	62044.0
2019-12-30	ABEV	Stock	4.72	4.74	4.65	4.65	8934900.0
2019-12-30	ABG	Stock	113.82	113.82	111.6	112.29	98500.0
2019-12-30	ABM	Stock	38.5	38.58	38.2	38.37	226200.0
2019-12-30	ABMD-DELISTED	Stock	169.69	170.7	166.08	167.22	442287.0
2019-12-30	ABR	Stock	14.56	14.58	14.42	14.45	772500.0
2019-12-30	ABR.A-DELISTED	Stock	26.25	26.3639	26.25	26.3	1276.0
2019-12-30	ABR.B-DELISTED	Stock	25.76	25.76	25.76	25.76	150.0
2019-12-30	ABR.C-DELISTED	Stock	26.49	26.65	26.4011	26.5499	1269.0
2019-12-30	ABT	Stock	87.52	87.79	86.61	86.8	2706100.0
2019-12-30	ABTC	Stock	246600.0	256200.0	235800.0	242100.0	3.9466666666666668
2019-12-30	ABTS	Stock	32.625	32.85	31.695	32.22	107.0
2019-12-30	ABTX-DELISTED	Stock	37.38	37.89	37.35	37.5	95516.0

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

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