PREVIEW / stock_daily / 2021-06-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-22.parquet
  size:    258 KB
  rows:    7,872
  symbols: 2,905

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
2021-06-22	AAPL	Stock	132.13	134.08	131.62	133.98	74783600.0
2021-06-22	MSFT	Stock	262.72	265.79	262.4	265.51	24694100.0
2021-06-22	NVDA	Stock	18.4715	18.9638	18.386	18.8868	580144000.0
2021-06-22	AMZN	Stock	172.903	176.189	172.8045	175.272	66902000.0
2021-06-22	GOOGL	Stock	121.75	122.4	121.064	122.3305	22390200.0
2021-06-22	META	Stock	332.69	339.92	332.6	339.03	15345300.0
2021-06-22	TSLA	Stock	206.0833	209.5233	205.1667	207.9033	57476700.0
2021-06-22	TLT	Stock	142.17	143.68	142.12	143.64	14530318.0
2021-06-22	ES	Stock	80.63	80.94	80.2	80.22	1406600.0
2021-06-22	CL	Stock	81.46	81.69	81.03	81.29	3159900.0
2021-06-22	A	Stock	146.37	147.68	145.83	146.63	1366200.0
2021-06-22	AA	Stock	33.38	34.08	32.78	33.91	6153300.0
2021-06-22	AAC-DELISTED	Stock	9.75	9.79	9.75	9.76	37135.0
2021-06-22	AACG	Stock	2.92	3.01	2.8	2.83	70800.0
2021-06-22	AACQ-DELISTED	Stock	9.55	9.74	8.75	9.39	2162630.0
2021-06-22	AACQU-DELISTED	Stock	10.39	10.658	9.85	10.17	18393.0
2021-06-22	AACQW-DELISTED	Stock	2.16	2.35	2.06	2.19	482250.0
2021-06-22	AAIC-DELISTED	Stock	4.02	4.02	3.92	3.95	398540.0
2021-06-22	AAIC.C-DELISTED	Stock	24.8689	24.919	24.7517	24.835	3908.0
2021-06-22	AAL	Stock	22.35	22.38	21.85	22.11	22745000.0
2021-06-22	AAM.A-DELISTED	Stock	26.19	26.36	26.19	26.26	48171.0
2021-06-22	AAM.B-DELISTED	Stock	27.105	27.2	27.105	27.2	10603.0
2021-06-22	AAMC-DELISTED	Stock	5.5382	5.7351	5.5382	5.5735	11720.0
2021-06-22	AAME	Stock	4.05	4.13	4.01	4.04	23400.0
2021-06-22	AAMI	Stock	23.62	23.805	23.02	23.8	594100.0
2021-06-22	AAN-DELISTED	Stock	34.75	34.75	33.19	33.43	273900.0
2021-06-22	AAOI	Stock	8.33	8.53	8.291	8.47	531500.0
2021-06-22	AAON	Stock	41.6667	41.6667	40.92	41.3133	246600.0
2021-06-22	AAP	Stock	199.06	201.04	197.42	200.04	448300.0
2021-06-22	AAQC-DELISTED	Stock	9.7	9.71	9.68	9.69	5111.0
2021-06-22	AAT	Stock	37.83	38.08	37.37	37.56	196400.0
2021-06-22	AAU-DELISTED	Stock	0.4869	0.496	0.485	0.4941	496102.0
2021-06-22	AAUAF-DELISTED	Stock	0.4869	0.496	0.485	0.4958	517348.0
2021-06-22	AAWW-DELISTED	Stock	68.23	69.08	67.5	68.52	319765.0
2021-06-22	AAXJ	Stock	92.75	92.75	92.09	92.6	1025744.0
2021-06-22	AB	Stock	44.45	45.11	44.06	44.94	187600.0
2021-06-22	ABB-DELISTED	Stock	33.65	33.95	33.53	33.84	1310949.0
2021-06-22	ABBNY-DELISTED	Stock	33.65	33.95	33.53	33.84	1462695.0
2021-06-22	ABBV	Stock	114.49	115.28	113.88	114.7	4359900.0
2021-06-22	ABC-DELISTED	Stock	116.19	117.34	115.96	116.69	681827.0
2021-06-22	ABCB	Stock	52.14	52.39	51.0	51.89	253900.0
2021-06-22	ABCL	Stock	22.5	22.85	21.933	22.07	1539300.0
2021-06-22	ABCM-DELISTED	Stock	18.83	19.0	18.81	18.95	22596.0
2021-06-22	ABEO	Stock	41.25	41.5	40.0	41.25	35368.0
2021-06-22	ABEV	Stock	3.69	3.69	3.61	3.66	35306100.0
2021-06-22	ABG	Stock	161.31	161.88	157.79	161.85	227300.0
2021-06-22	ABGI-DELISTED	Stock	9.9	9.9	9.8	9.9	32612.0
2021-06-22	ABM	Stock	45.45	45.45	44.57	45.33	275400.0
2021-06-22	ABMD-DELISTED	Stock	325.11	328.52	324.06	327.32	114445.0
2021-06-22	ABNB	Stock	149.75	151.647	148.4	149.68	5790400.0

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

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