PREVIEW / stock_daily / 2019-04-25

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-25.parquet
  size:    219 KB
  rows:    6,516
  symbols: 2,567

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-04-25	AAPL	Stock	51.7075	51.94	51.28	51.32	74172800.0
2019-04-25	MSFT	Stock	130.06	131.37	128.83	129.15	38033900.0
2019-04-25	NVDA	Stock	4.7388	4.7612	4.5925	4.6728	499296000.0
2019-04-25	AMZN	Stock	95.85	96.1225	95.0155	95.1125	121982000.0
2019-04-25	GOOGL	Stock	63.515	63.64	62.9	63.367	31343220.0
2019-04-25	META	Stock	196.98	198.48	192.12	193.26	54148800.0
2019-04-25	TSLA	Stock	17.0	17.2667	16.4047	16.5087	327741000.0
2019-04-25	TLT	Stock	123.49	123.62	123.1	123.39	5380867.0
2019-04-25	ES	Stock	70.53	71.24	70.38	70.84	1663600.0
2019-04-25	CL	Stock	68.5	68.97	68.04	68.69	3191200.0
2019-04-25	A	Stock	75.26	77.04	74.94	76.72	1481400.0
2019-04-25	AA	Stock	28.04	28.04	27.01	27.11	3153400.0
2019-04-25	AABA-DELISTED	Stock	75.21	76.51	74.88	76.5	2731548.0
2019-04-25	AAC-DELISTED	Stock	1.51	1.6	1.435	1.56	234198.0
2019-04-25	AACG	Stock	2.31	2.44	2.19	2.21	236000.0
2019-04-25	AAIC-DELISTED	Stock	7.92	7.92	7.73	7.77	418324.0
2019-04-25	AAIC.C-DELISTED	Stock	23.2	23.2	23.115	23.2	13361.0
2019-04-25	AAL	Stock	34.05	34.25	33.13	33.41	6156500.0
2019-04-25	AAM.A-DELISTED	Stock	25.1	25.15	25.05	25.05	116665.0
2019-04-25	AAM.B-DELISTED	Stock	25.1372	25.15	25.05	25.14	289074.0
2019-04-25	AAMC-DELISTED	Stock	8.1912	8.1912	8.1912	8.1912	537.0
2019-04-25	AAME	Stock	2.44	2.59	2.44	2.49	2700.0
2019-04-25	AAMI	Stock	14.56	14.64	14.32	14.59	312100.0
2019-04-25	AAOI	Stock	12.75	12.75	12.33	12.41	370800.0
2019-04-25	AAON	Stock	32.5667	32.7133	31.8	32.4667	182550.0
2019-04-25	AAP	Stock	169.8	171.57	165.87	170.64	1265000.0
2019-04-25	AAT	Stock	45.85	46.13	45.52	46.08	240800.0
2019-04-25	AAU-DELISTED	Stock	0.555	0.555	0.55	0.555	68038.0
2019-04-25	AAUAF-DELISTED	Stock	0.555	0.555	0.55	0.555	69176.0
2019-04-25	AAWW-DELISTED	Stock	49.41	49.52	47.64	47.77	156304.0
2019-04-25	AAXJ	Stock	71.67	71.915	71.47	71.89	1958150.0
2019-04-25	AAXN-DELISTED	Stock	62.58	63.16	61.8	62.86	275374.0
2019-04-25	AB	Stock	29.62	29.75	28.75	29.07	426200.0
2019-04-25	ABB-DELISTED	Stock	20.54	20.6	20.445	20.465	2156279.0
2019-04-25	ABBNY-DELISTED	Stock	20.54	20.6	20.445	20.47	2208995.0
2019-04-25	ABBV	Stock	80.05	80.47	76.91	79.34	10442900.0
2019-04-25	ABC-DELISTED	Stock	73.83	73.855	72.63	73.7	824620.0
2019-04-25	ABCB	Stock	35.39	36.18	34.96	36.15	446300.0
2019-04-25	ABDC-DELISTED	Stock	8.05	8.15	7.97	8.15	46658.0
2019-04-25	ABEO	Stock	208.75	210.25	202.0	206.75	13452.0
2019-04-25	ABEV	Stock	4.48	4.64	4.44	4.62	25578800.0
2019-04-25	ABG	Stock	79.44	80.09	77.82	79.02	162100.0
2019-04-25	ABIL-DELISTED	Stock	1.47	1.4957	1.43	1.4586	104322.0
2019-04-25	ABM	Stock	37.45	37.45	36.82	37.06	233200.0
2019-04-25	ABMD-DELISTED	Stock	268.9	278.4707	265.0	267.97	409301.0
2019-04-25	ABR	Stock	13.88	13.94	13.72	13.82	747900.0
2019-04-25	ABR.A-DELISTED	Stock	26.1093	26.1803	26.0501	26.1803	1000.0
2019-04-25	ABR.C-DELISTED	Stock	26.1594	26.32	26.1593	26.32	1253.0
2019-04-25	ABT	Stock	76.62	78.18	76.37	78.11	6011700.0
2019-04-25	ABTC	Stock	304500.0	306300.0	304500.0	305400.0	0.3466666666666667

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

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