PREVIEW / stock_daily / 2020-10-19

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-19.parquet
  size:    228 KB
  rows:    6,963
  symbols: 2,474

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
2020-10-19	AAPL	Stock	119.96	120.42	115.66	115.98	120639300.0
2020-10-19	MSFT	Stock	220.42	222.3	213.72	214.22	27625800.0
2020-10-19	NVDA	Stock	13.903	13.9835	13.4068	13.4978	298068000.0
2020-10-19	AMZN	Stock	164.9805	166.45	159.637	160.3605	104472000.0
2020-10-19	GOOGL	Stock	78.7965	79.1963	76.146	76.4975	29733040.0
2020-10-19	META	Stock	265.53	268.55	259.88	261.4	13587000.0
2020-10-19	TSLA	Stock	148.7467	149.0	142.9567	143.61	108863400.0
2020-10-19	TLT	Stock	160.5	160.98	160.05	160.78	9286787.0
2020-10-19	ES	Stock	91.9	92.41	90.81	91.08	1048500.0
2020-10-19	CL	Stock	80.45	80.9	79.01	79.21	2854800.0
2020-10-19	A	Stock	106.78	107.62	105.24	105.49	636000.0
2020-10-19	AA	Stock	12.67	13.22	12.61	12.63	6672200.0
2020-10-19	AACG	Stock	1.22	1.4	1.14	1.22	682600.0
2020-10-19	AACQ-DELISTED	Stock	9.77	9.805	9.765	9.8	260453.0
2020-10-19	AACQU-DELISTED	Stock	10.35	10.38	10.3	10.38	871.0
2020-10-19	AACQW-DELISTED	Stock	1.39	1.41	1.35	1.3809	99094.0
2020-10-19	AAIC-DELISTED	Stock	2.76	2.79	2.66	2.67	177647.0
2020-10-19	AAIC.C-DELISTED	Stock	18.76	18.76	18.75	18.75	1225.0
2020-10-19	AAL	Stock	12.64	12.87	12.45	12.56	50560700.0
2020-10-19	AAM.A-DELISTED	Stock	26.23	26.23	25.94	25.97	9272.0
2020-10-19	AAM.B-DELISTED	Stock	27.32	27.32	26.83	26.86	6143.0
2020-10-19	AAMC-DELISTED	Stock	6.2176	7.5912	6.0441	7.0206	250835.0
2020-10-19	AAME	Stock	2.18	2.33	2.06	2.28	26500.0
2020-10-19	AAMI	Stock	15.86	15.97	15.41	15.49	364900.0
2020-10-19	AAOI	Stock	11.06	11.175	10.86	10.89	296200.0
2020-10-19	AAON	Stock	42.2133	42.3333	40.78	40.8933	173550.0
2020-10-19	AAP	Stock	156.11	157.35	152.77	153.25	603800.0
2020-10-19	AAT	Stock	24.14	24.14	23.58	23.6	266200.0
2020-10-19	AAU-DELISTED	Stock	0.998	0.998	0.83	0.877	877235.0
2020-10-19	AAUAF-DELISTED	Stock	0.998	0.998	0.83	0.872	902599.0
2020-10-19	AAWW-DELISTED	Stock	66.44	66.675	64.3279	64.42	327392.0
2020-10-19	AAXJ	Stock	79.89	80.27	79.34	79.49	636399.0
2020-10-19	AAXN-DELISTED	Stock	109.72	113.0	107.43	107.75	547515.0
2020-10-19	AB	Stock	32.84	33.33	32.4	32.59	431000.0
2020-10-19	ABB-DELISTED	Stock	26.82	26.9065	26.46	26.51	1502093.0
2020-10-19	ABBNY-DELISTED	Stock	26.81	26.9065	26.46	26.51	1614238.0
2020-10-19	ABBV	Stock	86.59	86.79	84.13	84.31	10288000.0
2020-10-19	ABC-DELISTED	Stock	99.53	100.715	97.18	97.82	361352.0
2020-10-19	ABCB	Stock	26.33	26.43	25.75	25.88	234900.0
2020-10-19	ABEO	Stock	34.0	34.5	32.5	32.75	35512.0
2020-10-19	ABEV	Stock	2.39	2.44	2.36	2.37	10447700.0
2020-10-19	ABG	Stock	116.49	118.97	114.4	114.66	249100.0
2020-10-19	ABM	Stock	34.75	34.97	33.76	33.88	298200.0
2020-10-19	ABMD-DELISTED	Stock	287.58	291.33	280.31	281.11	145207.0
2020-10-19	ABR	Stock	11.64	11.67	11.34	11.36	1135600.0
2020-10-19	ABR.A-DELISTED	Stock	25.35	25.35	25.23	25.23	1200.0
2020-10-19	ABR.B-DELISTED	Stock	25.16	25.16	25.16	25.16	100.0
2020-10-19	ABR.C-DELISTED	Stock	25.5	25.54	25.4	25.447	3515.0
2020-10-19	ABT	Stock	109.9	111.04	107.82	108.04	4228500.0
2020-10-19	ABTC	Stock	132600.0	134460.0	119400.0	120600.0	8.2

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

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