PREVIEW / stock_daily / 2020-04-08

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-08.parquet
  size:    217 KB
  rows:    6,640
  symbols: 2,385

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-08	AAPL	Stock	65.685	66.8425	65.3075	66.5175	168895200.0
2020-04-08	MSFT	Stock	165.67	166.67	163.5	165.13	48318200.0
2020-04-08	NVDA	Stock	6.5853	6.6988	6.515	6.6738	542444000.0
2020-04-08	AMZN	Stock	101.05	102.2	100.5575	102.15	79546000.0
2020-04-08	GOOGL	Stock	60.155	60.745	59.1977	60.35	40334260.0
2020-04-08	META	Stock	171.25	175.0	167.74	174.28	21664200.0
2020-04-08	TSLA	Stock	36.9467	37.1473	35.5553	36.5893	189840000.0
2020-04-08	TLT	Stock	165.11	166.19	164.13	165.09	10147077.0
2020-04-08	ES	Stock	80.24	84.03	78.89	83.35	2055600.0
2020-04-08	CL	Stock	69.64	70.75	68.85	70.22	4265600.0
2020-04-08	A	Stock	74.17	77.17	72.75	76.69	2703000.0
2020-04-08	AA	Stock	7.17	7.46	7.02	7.26	7510400.0
2020-04-08	AACG	Stock	0.9	0.9	0.82	0.88	14200.0
2020-04-08	AAIC-DELISTED	Stock	2.35	2.75	2.3	2.61	2086757.0
2020-04-08	AAIC.C-DELISTED	Stock	14.4	17.0	14.4	17.0	7576.0
2020-04-08	AAL	Stock	10.91	11.4	10.5	11.33	82718700.0
2020-04-08	AAM.A-DELISTED	Stock	23.43	24.18	23.21	23.77	40829.0
2020-04-08	AAM.B-DELISTED	Stock	23.35	24.11	23.18	23.85	73927.0
2020-04-08	AAMC-DELISTED	Stock	3.8676	3.8676	3.8676	3.8676	833.0
2020-04-08	AAME	Stock	1.93	2.14	1.93	2.14	500.0
2020-04-08	AAMI	Stock	5.93	6.19	5.54	5.81	782000.0
2020-04-08	AAOI	Stock	8.05	8.5	7.95	8.01	537600.0
2020-04-08	AAON	Stock	31.7333	32.9133	31.0467	32.7	298950.0
2020-04-08	AAP	Stock	101.83	103.95	98.96	102.52	680900.0
2020-04-08	AAT	Stock	25.0	26.98	24.5	26.75	402900.0
2020-04-08	AAU-DELISTED	Stock	0.27	0.2934	0.27	0.2928	364198.0
2020-04-08	AAUAF-DELISTED	Stock	0.27	0.2934	0.27	0.2928	420063.0
2020-04-08	AAWW-DELISTED	Stock	23.55	24.91	23.22	24.41	663574.0
2020-04-08	AAXJ	Stock	61.36	61.77	60.87	61.72	940454.0
2020-04-08	AAXN-DELISTED	Stock	70.27	73.4	69.3973	72.38	417376.0
2020-04-08	AB	Stock	20.45	21.49	20.17	20.91	568400.0
2020-04-08	ABB-DELISTED	Stock	17.51	17.92	17.49	17.83	1950120.0
2020-04-08	ABBNY-DELISTED	Stock	17.51	17.92	17.49	17.83	2177200.0
2020-04-08	ABBV	Stock	76.44	78.98	74.78	78.56	12218500.0
2020-04-08	ABC-DELISTED	Stock	87.08	89.125	85.16	88.33	1339688.0
2020-04-08	ABCB	Stock	23.27	24.44	22.68	24.11	338000.0
2020-04-08	ABEO	Stock	59.25	60.0	56.25	59.25	37008.0
2020-04-08	ABEV	Stock	2.43	2.44	2.34	2.41	19454700.0
2020-04-08	ABG	Stock	49.92	55.38	49.86	54.34	493200.0
2020-04-08	ABM	Stock	26.22	28.24	25.99	27.85	511900.0
2020-04-08	ABMD-DELISTED	Stock	153.26	157.475	151.465	156.27	388873.0
2020-04-08	ABR	Stock	5.83	6.67	5.82	6.58	4645800.0
2020-04-08	ABR.A-DELISTED	Stock	18.23	20.88	18.0274	20.88	16278.0
2020-04-08	ABR.B-DELISTED	Stock	18.15	21.3799	18.15	20.25	14295.0
2020-04-08	ABR.C-DELISTED	Stock	17.46	21.0	17.46	19.8584	11485.0
2020-04-08	ABT	Stock	82.5	85.39	81.05	84.95	9266400.0
2020-04-08	ABTC	Stock	195000.0	213000.0	191100.0	213000.0	4.1466666666666665
2020-04-08	ABTS	Stock	7.95	22.5	7.95	13.05	219313.0
2020-04-08	ABTX-DELISTED	Stock	23.51	24.8	23.08	24.34	64392.0
2020-04-08	ABUS	Stock	1.05	1.09	0.99	1.02	398500.0

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

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