PREVIEW / stock_daily / 2020-01-07

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-07.parquet
  size:    222 KB
  rows:    6,603
  symbols: 2,424

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-01-07	AAPL	Stock	74.96	75.225	74.37	74.5975	108872000.0
2020-01-07	MSFT	Stock	159.32	159.67	157.32	157.58	21634100.0
2020-01-07	NVDA	Stock	5.955	6.0443	5.9098	5.9983	314856000.0
2020-01-07	AMZN	Stock	95.225	95.6945	94.602	95.343	80898000.0
2020-01-07	GOOGL	Stock	70.023	70.175	69.5778	69.7555	34529120.0
2020-01-07	META	Stock	212.82	214.58	211.75	213.06	14912400.0
2020-01-07	TSLA	Stock	30.76	31.442	30.224	31.2707	268231500.0
2020-01-07	TLT	Stock	138.22	138.47	137.64	137.645	8456431.0
2020-01-07	ES	Stock	83.3	83.3	82.09	82.68	2432800.0
2020-01-07	CL	Stock	68.46	68.46	67.47	67.55	4500000.0
2020-01-07	A	Stock	83.96	85.26	83.94	85.08	1684700.0
2020-01-07	AA	Stock	21.06	21.545	20.99	21.32	4986900.0
2020-01-07	AACG	Stock	1.39	1.44	1.36	1.43	13700.0
2020-01-07	AAIC-DELISTED	Stock	5.63	5.68	5.6262	5.67	262580.0
2020-01-07	AAIC.C-DELISTED	Stock	21.73	21.73	21.72	21.73	1509.0
2020-01-07	AAL	Stock	27.56	27.68	27.06	27.22	6105900.0
2020-01-07	AAM.A-DELISTED	Stock	26.745	26.77	26.74	26.77	7022.0
2020-01-07	AAM.B-DELISTED	Stock	27.11	27.27	27.1	27.24	13191.0
2020-01-07	AAMC-DELISTED	Stock	4.0441	4.1911	3.9904	4.0879	5756.0
2020-01-07	AAME	Stock	1.86	1.98	1.8	1.8	3000.0
2020-01-07	AAMI	Stock	9.45	9.68	9.34	9.58	336600.0
2020-01-07	AAOI	Stock	12.2	12.465	12.055	12.43	330500.0
2020-01-07	AAON	Stock	33.3867	33.5667	33.0467	33.4333	106500.0
2020-01-07	AAP	Stock	156.9	157.4	152.41	154.94	1129500.0
2020-01-07	AAT	Stock	46.05	46.05	45.14	45.34	146000.0
2020-01-07	AAU-DELISTED	Stock	0.5506	0.5775	0.5501	0.575	176957.0
2020-01-07	AAUAF-DELISTED	Stock	0.5506	0.5775	0.5501	0.5718	189805.0
2020-01-07	AAWW-DELISTED	Stock	27.07	27.56	26.29	26.36	177074.0
2020-01-07	AAXJ	Stock	73.58	73.74	73.4	73.68	580108.0
2020-01-07	AAXN-DELISTED	Stock	68.82	70.73	68.315	69.76	584214.0
2020-01-07	AB	Stock	30.4	31.22	30.33	31.2	488900.0
2020-01-07	ABB-DELISTED	Stock	24.23	24.3	24.14	24.28	1124889.0
2020-01-07	ABBNY-DELISTED	Stock	24.23	24.3	24.14	24.27	1349147.0
2020-01-07	ABBV	Stock	88.93	89.54	88.26	88.89	7242500.0
2020-01-07	ABC-DELISTED	Stock	84.76	85.25	84.192	84.63	614670.0
2020-01-07	ABCB	Stock	42.21	42.36	41.99	42.15	210100.0
2020-01-07	ABDC-DELISTED	Stock	9.16	9.2	9.0753	9.1	15574.0
2020-01-07	ABEO	Stock	70.0	70.0	63.75	64.25	95260.0
2020-01-07	ABEV	Stock	4.6	4.7	4.58	4.63	13782900.0
2020-01-07	ABG	Stock	106.89	107.1	103.5	103.79	233900.0
2020-01-07	ABM	Stock	38.37	38.37	37.67	37.99	198400.0
2020-01-07	ABMD-DELISTED	Stock	178.83	182.44	177.19	180.36	716533.0
2020-01-07	ABR	Stock	14.2	14.28	14.15	14.24	606400.0
2020-01-07	ABR.A-DELISTED	Stock	26.3444	26.3444	26.29	26.3316	1800.0
2020-01-07	ABR.B-DELISTED	Stock	26.2	26.2	26.18	26.18	968.0
2020-01-07	ABR.C-DELISTED	Stock	26.6432	26.6432	26.54	26.54	300.0
2020-01-07	ABT	Stock	85.77	86.3	85.54	85.86	3408100.0
2020-01-07	ABTC	Stock	238500.0	240900.0	228000.0	228000.0	2.746666666666667
2020-01-07	ABTS	Stock	32.25	33.75	32.25	32.55	613.0
2020-01-07	ABTX-DELISTED	Stock	37.39	37.5	36.8	37.05	118305.0

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

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