PREVIEW / stock_daily / 2019-10-25

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-25.parquet
  size:    220 KB
  rows:    6,568
  symbols: 2,462

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
2019-10-25	AAPL	Stock	60.79	61.6825	60.72	61.645	73477200.0
2019-10-25	MSFT	Stock	139.34	141.14	139.2	140.73	25959700.0
2019-10-25	NVDA	Stock	5.0025	5.1345	4.9948	5.1135	423092000.0
2019-10-25	AMZN	Stock	84.8775	88.2105	84.75	88.0665	192528000.0
2019-10-25	GOOGL	Stock	62.6	63.4	62.4575	63.215	27104960.0
2019-10-25	META	Stock	185.83	189.0	185.09	187.89	8061200.0
2019-10-25	TSLA	Stock	19.848	22.0	19.7407	21.8753	450091500.0
2019-10-25	TLT	Stock	139.53	139.55	138.31	138.52	5669966.0
2019-10-25	ES	Stock	86.33	86.55	85.2	85.31	1417000.0
2019-10-25	CL	Stock	68.4	68.75	68.21	68.41	3850300.0
2019-10-25	A	Stock	74.7	75.97	74.13	75.39	835100.0
2019-10-25	AA	Stock	20.68	21.2	20.6	21.02	5924400.0
2019-10-25	AAC-DELISTED	Stock	0.47	0.49	0.46	0.48	96204.0
2019-10-25	AACG	Stock	1.79	1.87	1.79	1.87	18400.0
2019-10-25	AAIC-DELISTED	Stock	5.72	5.78	5.68	5.73	192577.0
2019-10-25	AAIC.C-DELISTED	Stock	21.15	21.4112	21.15	21.35	2087.0
2019-10-25	AAL	Stock	29.4	30.89	29.3	30.86	13835700.0
2019-10-25	AAM.A-DELISTED	Stock	26.8436	26.87	26.7012	26.82	17276.0
2019-10-25	AAM.B-DELISTED	Stock	27.264	27.307	27.18	27.2	22223.0
2019-10-25	AAMC-DELISTED	Stock	4.4471	4.5529	4.4118	4.5529	5654.0
2019-10-25	AAME	Stock	2.2	2.2	2.13	2.19	1800.0
2019-10-25	AAMI	Stock	9.32	9.54	9.32	9.45	496600.0
2019-10-25	AAOI	Stock	9.81	10.1	9.77	9.91	465600.0
2019-10-25	AAON	Stock	31.68	32.26	31.24	31.8933	144000.0
2019-10-25	AAP	Stock	166.5	169.69	165.34	165.56	643100.0
2019-10-25	AAT	Stock	47.81	47.82	47.44	47.69	202100.0
2019-10-25	AAU-DELISTED	Stock	0.67	0.679	0.65	0.6565	306787.0
2019-10-25	AAUAF-DELISTED	Stock	0.67	0.679	0.65	0.6565	316208.0
2019-10-25	AAWW-DELISTED	Stock	23.79	25.6023	23.61	25.53	605008.0
2019-10-25	AAXJ	Stock	68.57	69.15	68.57	69.12	468531.0
2019-10-25	AAXN-DELISTED	Stock	54.69	55.17	54.2	54.26	292857.0
2019-10-25	AB	Stock	29.28	29.44	28.58	28.81	446400.0
2019-10-25	ABB-DELISTED	Stock	20.91	21.1	20.895	21.03	1631412.0
2019-10-25	ABBNY-DELISTED	Stock	20.91	21.1	20.895	21.03	1834382.0
2019-10-25	ABBV	Stock	76.39	76.79	76.22	76.53	5497000.0
2019-10-25	ABC-DELISTED	Stock	85.91	87.22	85.31	86.8	299413.0
2019-10-25	ABCB	Stock	42.88	43.5	42.88	43.29	425500.0
2019-10-25	ABDC-DELISTED	Stock	8.92	8.96	8.9	8.94	31918.0
2019-10-25	ABEO	Stock	58.5	64.75	56.0	62.5	26812.0
2019-10-25	ABEOW-DELISTED	Stock	0.1415	0.231	0.1415	0.17	2000.0
2019-10-25	ABEV	Stock	4.48	4.51	4.38	4.43	48559400.0
2019-10-25	ABG	Stock	103.15	104.14	102.63	102.93	144100.0
2019-10-25	ABIL-DELISTED	Stock	0.49	0.49	0.4568	0.4834	14896.0
2019-10-25	ABM	Stock	36.74	37.48	36.5	37.4	331500.0
2019-10-25	ABMD-DELISTED	Stock	180.48	183.7	179.46	182.38	296679.0
2019-10-25	ABR	Stock	13.35	13.48	13.28	13.4	762200.0
2019-10-25	ABR.A-DELISTED	Stock	25.9127	25.9625	25.9	25.92	2931.0
2019-10-25	ABR.B-DELISTED	Stock	25.8707	25.9033	25.87	25.8902	2307.0
2019-10-25	ABR.C-DELISTED	Stock	26.0758	26.0764	25.95	25.95	4587.0
2019-10-25	ABT	Stock	81.45	81.97	81.08	81.65	4872800.0

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

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