PREVIEW / stock_daily / 2020-11-25

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-25.parquet
  size:    234 KB
  rows:    7,105
  symbols: 2,549

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-11-25	AAPL	Stock	115.55	116.75	115.17	116.03	76499200.0
2020-11-25	MSFT	Stock	215.11	215.29	212.46	213.87	21012900.0
2020-11-25	NVDA	Stock	13.0325	13.2695	13.02	13.2348	259916000.0
2020-11-25	AMZN	Stock	157.0935	159.9	157.013	159.2535	75808000.0
2020-11-25	GOOGL	Stock	88.3905	88.519	87.418	88.2065	19599140.0
2020-11-25	META	Stock	278.14	280.18	272.65	275.59	12467000.0
2020-11-25	TSLA	Stock	183.3533	191.3333	181.79	191.3333	146790600.0
2020-11-25	TLT	Stock	159.25	159.91	158.62	158.68	9146000.0
2020-11-25	ES	Stock	87.75	88.49	86.4	88.43	1620200.0
2020-11-25	CL	Stock	85.14	85.47	84.44	84.75	3135700.0
2020-11-25	A	Stock	116.09	116.96	113.41	114.35	2862500.0
2020-11-25	AA	Stock	20.68	20.84	20.26	20.37	5405700.0
2020-11-25	AACG	Stock	1.26	1.29	1.22	1.27	199200.0
2020-11-25	AACQ-DELISTED	Stock	9.94	9.94	9.8	9.92	346608.0
2020-11-25	AACQU-DELISTED	Stock	10.2718	10.33	10.27	10.33	42336.0
2020-11-25	AACQW-DELISTED	Stock	1.38	1.4201	1.26	1.4201	61301.0
2020-11-25	AAIC-DELISTED	Stock	3.28	3.31	3.22	3.3	156095.0
2020-11-25	AAIC.C-DELISTED	Stock	20.32	20.32	20.04	20.04	1194.0
2020-11-25	AAL	Stock	14.77	15.08	14.37	14.94	101052500.0
2020-11-25	AAM.A-DELISTED	Stock	26.65	26.65	26.48	26.5	12411.0
2020-11-25	AAM.B-DELISTED	Stock	27.56	27.62	27.42	27.44	7508.0
2020-11-25	AAMC-DELISTED	Stock	6.7286	6.7286	6.6471	6.6471	4230.0
2020-11-25	AAME	Stock	2.15	2.21	2.05	2.06	17900.0
2020-11-25	AAMI	Stock	18.28	18.32	18.05	18.09	447500.0
2020-11-25	AAOI	Stock	7.97	8.59	7.88	8.43	1077500.0
2020-11-25	AAON	Stock	44.3	45.0667	43.3733	43.9133	236400.0
2020-11-25	AAP	Stock	150.44	150.61	147.3	149.4	795200.0
2020-11-25	AAT	Stock	31.25	31.48	30.16	30.49	400200.0
2020-11-25	AAU-DELISTED	Stock	0.98	1.02	0.9772	1.015	338557.0
2020-11-25	AAUAF-DELISTED	Stock	0.98	1.02	0.9772	0.996	357524.0
2020-11-25	AAWW-DELISTED	Stock	56.66	56.675	54.86	56.06	241419.0
2020-11-25	AAXJ	Stock	86.11	86.35	85.83	86.31	1133509.0
2020-11-25	AAXN-DELISTED	Stock	127.68	128.23	125.29	127.59	344671.0
2020-11-25	AB	Stock	32.0	32.32	31.59	31.89	305900.0
2020-11-25	ABB-DELISTED	Stock	26.61	26.62	26.46	26.55	1335941.0
2020-11-25	ABBNY-DELISTED	Stock	26.61	26.62	26.46	26.55	1429624.0
2020-11-25	ABBV	Stock	103.82	104.46	103.39	104.2	6368100.0
2020-11-25	ABC-DELISTED	Stock	103.39	103.94	101.49	103.13	574563.0
2020-11-25	ABCB	Stock	35.35	35.98	34.77	35.73	356500.0
2020-11-25	ABCM-DELISTED	Stock	18.52	18.89	18.42	18.46	92982.0
2020-11-25	ABEO	Stock	35.0	35.75	34.5	35.25	46696.0
2020-11-25	ABEV	Stock	2.74	2.79	2.74	2.76	15415800.0
2020-11-25	ABG	Stock	125.19	127.19	118.7	120.82	143500.0
2020-11-25	ABM	Stock	40.81	41.08	39.97	40.26	353200.0
2020-11-25	ABMD-DELISTED	Stock	265.68	266.025	261.575	263.68	104125.0
2020-11-25	ABR	Stock	13.73	13.87	13.57	13.73	811400.0
2020-11-25	ABR.A-DELISTED	Stock	25.55	25.59	25.463	25.5001	3377.0
2020-11-25	ABR.B-DELISTED	Stock	25.39	25.45	25.373	25.39	3795.0
2020-11-25	ABR.C-DELISTED	Stock	25.815	25.95	25.815	25.88	1569.0
2020-11-25	ABST-DELISTED	Stock	10.04	10.21	9.95	10.15	71577.0

> showing 50 of 7,105 rows — these rows as CSV

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