PREVIEW / stock_daily / 2020-10-20

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-20.parquet
  size:    228 KB
  rows:    6,937
  symbols: 2,453

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-20	AAPL	Stock	116.2	118.98	115.63	117.51	124423700.0
2020-10-20	MSFT	Stock	215.8	217.37	213.09	214.65	22753500.0
2020-10-20	NVDA	Stock	13.5835	13.7998	13.507	13.6455	229212000.0
2020-10-20	AMZN	Stock	161.114	163.3	159.6005	160.8505	90194000.0
2020-10-20	GOOGL	Stock	76.1555	78.692	76.025	77.554	41718300.0
2020-10-20	META	Stock	263.06	269.7	262.88	267.56	18763200.0
2020-10-20	TSLA	Stock	143.9167	143.9167	139.6833	140.6467	94968900.0
2020-10-20	TLT	Stock	159.86	160.01	158.95	159.25	11189208.0
2020-10-20	ES	Stock	91.6	92.98	91.21	92.24	1157400.0
2020-10-20	CL	Stock	80.07	80.76	79.71	79.83	2960900.0
2020-10-20	A	Stock	105.89	106.94	105.56	105.61	771000.0
2020-10-20	AA	Stock	12.9	13.1	12.74	12.8	4542600.0
2020-10-20	AACG	Stock	1.24	1.29	1.24	1.25	96600.0
2020-10-20	AACQ-DELISTED	Stock	9.79	9.8	9.7	9.8	23741.0
2020-10-20	AACQU-DELISTED	Stock	10.28	10.29	10.26	10.27	60093.0
2020-10-20	AACQW-DELISTED	Stock	1.33	1.43	1.33	1.34	176062.0
2020-10-20	AAIC-DELISTED	Stock	2.68	2.74	2.64	2.67	178548.0
2020-10-20	AAL	Stock	12.75	13.0	12.59	12.8	46748800.0
2020-10-20	AAM.A-DELISTED	Stock	26.0912	26.17	26.04	26.11	14021.0
2020-10-20	AAM.B-DELISTED	Stock	26.78	27.02	26.75	26.82	33031.0
2020-10-20	AAMC-DELISTED	Stock	7.2059	7.2059	6.8111	7.0	9092.0
2020-10-20	AAME	Stock	2.2	2.21	2.2	2.2	1800.0
2020-10-20	AAMI	Stock	15.62	15.65	15.3	15.39	331700.0
2020-10-20	AAOI	Stock	11.0	11.093	10.75	10.86	246700.0
2020-10-20	AAON	Stock	41.12	41.4	40.68	40.9267	134550.0
2020-10-20	AAP	Stock	154.68	154.98	152.69	153.02	614400.0
2020-10-20	AAT	Stock	23.86	24.2	23.81	23.88	183500.0
2020-10-20	AAU-DELISTED	Stock	0.872	0.9358	0.8658	0.9216	296286.0
2020-10-20	AAUAF-DELISTED	Stock	0.872	0.9358	0.8658	0.9262	338492.0
2020-10-20	AAWW-DELISTED	Stock	64.82	65.16	62.51	64.07	355464.0
2020-10-20	AAXJ	Stock	79.97	80.64	79.75	80.18	2051350.0
2020-10-20	AAXN-DELISTED	Stock	108.41	109.34	105.27	106.07	502271.0
2020-10-20	AB	Stock	32.65	33.04	32.54	32.96	344500.0
2020-10-20	ABB-DELISTED	Stock	26.84	26.97	26.69	26.72	1083536.0
2020-10-20	ABBNY-DELISTED	Stock	26.84	26.97	26.69	26.73	1171344.0
2020-10-20	ABBV	Stock	84.19	84.83	83.42	84.25	6932100.0
2020-10-20	ABC-DELISTED	Stock	98.17	99.0	97.395	98.0	558359.0
2020-10-20	ABCB	Stock	26.36	27.37	26.2	26.85	324200.0
2020-10-20	ABEO	Stock	33.25	33.75	32.25	33.0	39468.0
2020-10-20	ABEV	Stock	2.41	2.43	2.39	2.42	22171300.0
2020-10-20	ABG	Stock	116.78	120.87	115.5	120.1	417300.0
2020-10-20	ABM	Stock	34.12	34.7	33.86	34.13	181700.0
2020-10-20	ABMD-DELISTED	Stock	283.35	285.25	277.0	277.28	79094.0
2020-10-20	ABR	Stock	11.44	11.51	11.33	11.37	772500.0
2020-10-20	ABR.A-DELISTED	Stock	25.2728	25.3898	25.18	25.18	1976.0
2020-10-20	ABR.C-DELISTED	Stock	25.516	25.5219	25.48	25.5	1490.0
2020-10-20	ABT	Stock	108.35	109.89	108.11	108.36	3873500.0
2020-10-20	ABTC	Stock	121800.0	123000.0	105990.0	111600.0	14.933333333333334
2020-10-20	ABTS	Stock	20.55	21.0	17.7	18.45	82787.0
2020-10-20	ABTX-DELISTED	Stock	26.25	26.735	26.12	26.43	15915.0

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

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