PREVIEW / stock_daily / 2020-04-21

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-21.parquet
  size:    214 KB
  rows:    6,568
  symbols: 2,330

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-04-21	AAPL	Stock	69.07	69.3125	66.3575	67.0925	180991600.0
2020-04-21	MSFT	Stock	173.5	173.67	166.11	167.82	56203700.0
2020-04-21	NVDA	Stock	7.0578	7.1192	6.6778	6.7378	735160000.0
2020-04-21	AMZN	Stock	120.8305	121.4155	113.983	116.406	149534000.0
2020-04-21	GOOGL	Stock	62.1355	62.5	60.25	60.608	49648080.0
2020-04-21	META	Stock	175.25	175.38	168.34	170.8	24850500.0
2020-04-21	TSLA	Stock	48.6747	50.222	44.9193	45.7813	303136500.0
2020-04-21	TLT	Stock	171.93	172.15	170.78	171.29	7850725.0
2020-04-21	ES	Stock	86.52	88.43	86.17	87.2	1764000.0
2020-04-21	CL	Stock	71.5	71.75	70.25	70.61	3142800.0
2020-04-21	A	Stock	75.76	75.8	73.71	73.75	2848100.0
2020-04-21	AA	Stock	7.1	7.39	7.06	7.32	6156400.0
2020-04-21	AACG	Stock	0.78	0.78	0.7	0.77	10300.0
2020-04-21	AAIC-DELISTED	Stock	2.62	2.84	2.58	2.81	525228.0
2020-04-21	AAIC.C-DELISTED	Stock	16.6	17.0	16.24	17.0	1919.0
2020-04-21	AAL	Stock	10.8	11.22	10.7	11.0	49882300.0
2020-04-21	AAM.A-DELISTED	Stock	25.0299	25.3	24.65	25.25	90863.0
2020-04-21	AAM.B-DELISTED	Stock	25.25	25.4	24.83	25.225	13865.0
2020-04-21	AAME	Stock	1.85	1.85	1.67	1.67	7600.0
2020-04-21	AAMI	Stock	4.98	5.51	4.93	5.39	632900.0
2020-04-21	AAOI	Stock	8.15	8.502	8.1	8.28	755000.0
2020-04-21	AAON	Stock	29.9067	30.7533	29.6733	29.8667	239850.0
2020-04-21	AAP	Stock	115.47	117.2	112.97	113.51	777900.0
2020-04-21	AAT	Stock	24.57	25.71	24.57	25.46	213600.0
2020-04-21	AAU-DELISTED	Stock	0.36	0.365	0.34	0.347	208438.0
2020-04-21	AAUAF-DELISTED	Stock	0.36	0.365	0.34	0.3569	212130.0
2020-04-21	AAWW-DELISTED	Stock	25.12	27.15	24.13	26.89	689691.0
2020-04-21	AAXJ	Stock	61.76	61.895	61.2	61.2	663091.0
2020-04-21	AAXN-DELISTED	Stock	74.75	76.41	69.65	70.59	627488.0
2020-04-21	AB	Stock	20.0	20.21	19.13	19.36	446200.0
2020-04-21	ABB-DELISTED	Stock	17.04	17.22	16.87	16.92	1555218.0
2020-04-21	ABBNY-DELISTED	Stock	17.04	17.22	16.87	16.91	1705529.0
2020-04-21	ABBV	Stock	82.51	82.97	80.02	80.36	9627500.0
2020-04-21	ABC-DELISTED	Stock	88.44	88.62	84.43	85.57	946580.0
2020-04-21	ABCB	Stock	21.42	22.72	21.14	22.48	360100.0
2020-04-21	ABEO	Stock	62.0	62.5	58.0	59.25	39768.0
2020-04-21	ABEV	Stock	2.18	2.27	2.18	2.23	21572800.0
2020-04-21	ABG	Stock	52.62	52.95	51.14	52.0	348000.0
2020-04-21	ABM	Stock	29.95	30.88	29.63	30.13	360600.0
2020-04-21	ABMD-DELISTED	Stock	164.4	167.78	161.99	164.16	246582.0
2020-04-21	ABR	Stock	5.8	6.18	5.68	6.15	1997000.0
2020-04-21	ABR.A-DELISTED	Stock	20.28	22.38	20.25	21.6	7036.0
2020-04-21	ABR.B-DELISTED	Stock	18.8	21.2672	18.5564	20.8	2681.0
2020-04-21	ABR.C-DELISTED	Stock	20.7	23.33	20.7	21.75	5982.0
2020-04-21	ABT	Stock	96.1	96.97	93.62	94.05	12030300.0
2020-04-21	ABTC	Stock	207300.0	232200.0	207300.0	224400.0	1.8133333333333332
2020-04-21	ABTS	Stock	12.12	13.35	10.05	11.775	1147.0
2020-04-21	ABTX-DELISTED	Stock	21.39	22.29	21.11	21.91	61168.0
2020-04-21	ABUS	Stock	1.23	1.24	1.13	1.2	498300.0
2020-04-21	ACA	Stock	38.92	39.96	37.51	37.6	393070.0

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

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