PREVIEW / stock_daily / 2020-03-11

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-11.parquet
  size:    219 KB
  rows:    6,642
  symbols: 2,403

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-03-11	AAPL	Stock	69.3475	70.305	67.965	68.8575	255598800.0
2020-03-11	MSFT	Stock	157.13	157.7	151.15	153.63	56371600.0
2020-03-11	NVDA	Stock	6.3865	6.415	6.0642	6.1618	499964000.0
2020-03-11	AMZN	Stock	92.8925	93.566	90.075	91.043	112496000.0
2020-03-11	GOOGL	Stock	62.4135	62.8465	59.557	60.545	54833880.0
2020-03-11	META	Stock	174.01	175.88	167.66	170.24	20373900.0
2020-03-11	TSLA	Stock	42.68	43.572	40.8667	42.282	199837500.0
2020-03-11	TLT	Stock	165.43	167.03	155.63	156.53	29594066.0
2020-03-11	ES	Stock	89.23	89.59	86.26	87.79	2653800.0
2020-03-11	CL	Stock	70.14	70.81	67.78	68.9	6860400.0
2020-03-11	A	Stock	70.76	71.73	67.57	68.84	4985900.0
2020-03-11	AA	Stock	8.85	9.23	8.3	9.2	9442000.0
2020-03-11	AACG	Stock	0.96	0.97	0.96	0.96	35600.0
2020-03-11	AAIC-DELISTED	Stock	4.81	4.82	4.42	4.44	659859.0
2020-03-11	AAIC.C-DELISTED	Stock	20.19	20.19	19.075	19.74	6945.0
2020-03-11	AAL	Stock	16.31	16.49	15.52	16.26	43705800.0
2020-03-11	AAM.A-DELISTED	Stock	25.4	25.54	25.0	25.12	63970.0
2020-03-11	AAM.B-DELISTED	Stock	26.01	26.01	25.15	25.35	32563.0
2020-03-11	AAMC-DELISTED	Stock	5.8647	5.8647	5.8647	5.8647	2281.0
2020-03-11	AAME	Stock	2.58	2.61	2.58	2.58	1200.0
2020-03-11	AAMI	Stock	6.47	6.81	6.03	6.63	807000.0
2020-03-11	AAOI	Stock	7.83	8.04	6.99	7.04	933700.0
2020-03-11	AAON	Stock	33.6733	33.8133	28.4533	29.48	1897500.0
2020-03-11	AAP	Stock	132.47	132.8	123.41	125.62	2077500.0
2020-03-11	AAT	Stock	37.54	37.62	35.41	35.64	335300.0
2020-03-11	AAU-DELISTED	Stock	0.37	0.37	0.3	0.3068	553164.0
2020-03-11	AAUAF-DELISTED	Stock	0.37	0.37	0.3	0.3068	614048.0
2020-03-11	AAWW-DELISTED	Stock	20.38	20.6	17.25	17.97	1555577.0
2020-03-11	AAXJ	Stock	65.55	65.84	64.53	64.62	2961410.0
2020-03-11	AAXN-DELISTED	Stock	64.88	66.36	59.6	60.48	895370.0
2020-03-11	AB	Stock	28.73	28.82	26.6	26.61	848400.0
2020-03-11	ABB-DELISTED	Stock	19.46	19.58	18.65	18.82	2745812.0
2020-03-11	ABBNY-DELISTED	Stock	19.46	19.58	18.65	18.83	2947194.0
2020-03-11	ABBV	Stock	85.8	86.64	83.57	84.85	10382200.0
2020-03-11	ABC-DELISTED	Stock	84.08	86.12	83.05	84.93	1751580.0
2020-03-11	ABCB	Stock	27.08	27.53	25.21	25.74	735000.0
2020-03-11	ABEO	Stock	58.75	59.75	53.0	54.75	48228.0
2020-03-11	ABEV	Stock	3.05	3.07	2.75	2.85	37799800.0
2020-03-11	ABG	Stock	74.85	76.9	70.29	72.41	358200.0
2020-03-11	ABM	Stock	31.03	31.23	28.78	29.41	344400.0
2020-03-11	ABMD-DELISTED	Stock	161.68	161.68	149.17	151.16	707533.0
2020-03-11	ABR	Stock	10.6	10.68	9.91	10.13	2120000.0
2020-03-11	ABR.A-DELISTED	Stock	24.99	25.7549	24.25	25.0	15116.0
2020-03-11	ABR.B-DELISTED	Stock	24.17	24.1971	24.0	24.1971	6566.0
2020-03-11	ABR.C-DELISTED	Stock	25.5	25.6271	25.01	25.5469	13899.0
2020-03-11	ABT	Stock	78.53	79.07	76.35	78.09	11534200.0
2020-03-11	ABTC	Stock	174000.0	194100.0	168000.0	183600.0	6.319999999999999
2020-03-11	ABTS	Stock	21.9	29.85	18.9	24.6	16587.0
2020-03-11	ABTX-DELISTED	Stock	27.33	28.3	25.8487	26.26	122423.0
2020-03-11	ABUS	Stock	2.75	2.75	2.56	2.58	387000.0

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

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