PREVIEW / stock_daily / 2020-01-13

all stock daily files

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

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-13	AAPL	Stock	77.91	79.2675	77.7875	79.24	121532000.0
2020-01-13	MSFT	Stock	161.76	163.31	161.26	163.28	21626500.0
2020-01-13	NVDA	Stock	6.1915	6.3248	6.1688	6.2995	319840000.0
2020-01-13	AMZN	Stock	94.5655	94.9	94.04	94.565	55616000.0
2020-01-13	GOOGL	Stock	71.7625	72.074	71.2685	72.0015	30746340.0
2020-01-13	META	Stock	219.6	221.97	219.21	221.91	14463400.0
2020-01-13	TSLA	Stock	32.9	35.042	32.8	34.9907	397764000.0
2020-01-13	TLT	Stock	137.88	138.09	137.39	138.02	5967295.0
2020-01-13	ES	Stock	84.49	85.33	84.41	85.15	1691100.0
2020-01-13	CL	Stock	70.16	70.56	69.8	70.14	4641300.0
2020-01-13	A	Stock	87.81	88.32	86.74	87.46	1630200.0
2020-01-13	AA	Stock	19.39	19.86	19.15	19.61	6202700.0
2020-01-13	AACG	Stock	1.52	1.7	1.42	1.52	27900.0
2020-01-13	AAIC-DELISTED	Stock	5.61	5.64	5.6	5.63	194432.0
2020-01-13	AAIC.C-DELISTED	Stock	22.04	22.04	21.77	22.0	7265.0
2020-01-13	AAL	Stock	27.32	27.53	27.16	27.39	5874400.0
2020-01-13	AAM.A-DELISTED	Stock	26.8	26.9	26.7522	26.89	11581.0
2020-01-13	AAM.B-DELISTED	Stock	27.33	27.34	27.25	27.34	12991.0
2020-01-13	AAMC-DELISTED	Stock	3.8235	3.9522	3.8235	3.9522	3094.0
2020-01-13	AAME	Stock	1.82	2.22	1.82	1.98	2400.0
2020-01-13	AAMI	Stock	10.03	10.18	9.99	10.18	343700.0
2020-01-13	AAOI	Stock	13.0	13.58	12.86	13.54	696500.0
2020-01-13	AAON	Stock	33.8667	34.66	33.8667	34.6333	119250.0
2020-01-13	AAP	Stock	145.33	147.0	142.76	145.26	2138700.0
2020-01-13	AAT	Stock	45.57	46.12	45.52	46.09	280500.0
2020-01-13	AAU-DELISTED	Stock	0.53	0.5389	0.5161	0.52	199625.0
2020-01-13	AAUAF-DELISTED	Stock	0.53	0.5389	0.5161	0.52	205011.0
2020-01-13	AAWW-DELISTED	Stock	26.59	27.4307	26.31	27.07	156835.0
2020-01-13	AAXJ	Stock	75.74	76.44	75.59	76.35	962194.0
2020-01-13	AAXN-DELISTED	Stock	69.83	70.9	69.5	70.75	338461.0
2020-01-13	AB	Stock	32.1	32.45	32.02	32.38	544600.0
2020-01-13	ABB-DELISTED	Stock	23.86	24.0	23.81	23.99	2349094.0
2020-01-13	ABBNY-DELISTED	Stock	23.86	24.0	23.81	23.99	2445124.0
2020-01-13	ABBV	Stock	89.5	89.5	87.92	88.52	9292200.0
2020-01-13	ABC-DELISTED	Stock	86.97	87.25	85.5	86.14	792001.0
2020-01-13	ABCB	Stock	42.24	42.89	42.12	42.82	259500.0
2020-01-13	ABDC-DELISTED	Stock	9.2376	9.26	9.212	9.26	39389.0
2020-01-13	ABEO	Stock	63.75	65.75	58.5	59.0	73536.0
2020-01-13	ABEV	Stock	4.55	4.66	4.54	4.6	24067500.0
2020-01-13	ABG	Stock	100.55	103.17	100.09	102.35	477800.0
2020-01-13	ABM	Stock	38.63	39.24	38.63	39.22	261500.0
2020-01-13	ABMD-DELISTED	Stock	166.5	169.98	155.77	168.13	3093260.0
2020-01-13	ABR	Stock	14.37	14.55	14.37	14.48	810200.0
2020-01-13	ABR.A-DELISTED	Stock	26.31	26.4215	26.29	26.4215	1620.0
2020-01-13	ABR.B-DELISTED	Stock	26.24	26.24	26.192	26.2027	7240.0
2020-01-13	ABR.C-DELISTED	Stock	26.59	26.75	26.59	26.72	1216.0
2020-01-13	ABT	Stock	85.5	85.73	84.74	85.12	5571500.0
2020-01-13	ABTC	Stock	213000.0	222000.0	205620.0	213000.0	4.133333333333333
2020-01-13	ABTS	Stock	31.5	31.5	31.5	31.5	26.7
2020-01-13	ABTX-DELISTED	Stock	37.25	37.33	37.0	37.33	80412.0

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

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