PREVIEW / stock_daily / 2021-04-21

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-21.parquet
  size:    254 KB
  rows:    7,783
  symbols: 2,940

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-04-21	AAPL	Stock	132.36	133.75	131.3	133.5	68847100.0
2021-04-21	MSFT	Stock	258.94	260.68	257.25	260.58	24030400.0
2021-04-21	NVDA	Stock	15.1188	15.3625	15.1023	15.3605	216776000.0
2021-04-21	AMZN	Stock	165.8	168.143	165.1905	168.101	44224000.0
2021-04-21	GOOGL	Stock	113.6025	114.0	112.241	113.9175	23204180.0
2021-04-21	META	Stock	301.95	301.98	297.39	301.47	14863500.0
2021-04-21	TSLA	Stock	234.9233	248.28	232.6667	248.04	93646500.0
2021-04-21	TLT	Stock	139.54	139.91	139.07	139.78	11902155.0
2021-04-21	ES	Stock	90.36	91.2	89.3	89.53	1153400.0
2021-04-21	CL	Stock	81.73	82.05	80.81	81.15	3755200.0
2021-04-21	A	Stock	132.88	133.95	132.02	133.83	1173900.0
2021-04-21	AA	Stock	32.57	34.68	32.5	34.26	7890200.0
2021-04-21	AAC-DELISTED	Stock	9.8	9.81	9.77	9.8	338073.0
2021-04-21	AACG	Stock	2.82	2.95	2.75	2.76	93300.0
2021-04-21	AACQ-DELISTED	Stock	9.95	10.02	9.9201	10.0	864175.0
2021-04-21	AACQU-DELISTED	Stock	10.36	10.5	10.36	10.5	49090.0
2021-04-21	AACQW-DELISTED	Stock	1.5306	1.68	1.5	1.57	133864.0
2021-04-21	AAIC-DELISTED	Stock	3.94	4.06	3.92	4.05	176065.0
2021-04-21	AAIC.C-DELISTED	Stock	23.85	23.9	23.8	23.8	800.0
2021-04-21	AAL	Stock	20.01	21.03	19.64	21.01	49376400.0
2021-04-21	AAM.A-DELISTED	Stock	26.0601	26.1	26.0601	26.09	14190.0
2021-04-21	AAM.B-DELISTED	Stock	26.81	26.92	26.81	26.9	16782.0
2021-04-21	AAMC-DELISTED	Stock	5.35	5.5147	5.2559	5.2559	42310.0
2021-04-21	AAME	Stock	3.74	3.99	3.74	3.87	249800.0
2021-04-21	AAMI	Stock	22.67	23.32	22.67	23.12	418000.0
2021-04-21	AAN-DELISTED	Stock	24.15	25.01	24.02	25.0	300900.0
2021-04-21	AAOI	Stock	7.55	7.93	7.45	7.92	385400.0
2021-04-21	AAON	Stock	45.4733	46.46	45.4733	46.1933	89700.0
2021-04-21	AAP	Stock	194.45	202.54	194.45	199.87	1220800.0
2021-04-21	AAT	Stock	33.65	34.19	33.65	33.86	156900.0
2021-04-21	AAU-DELISTED	Stock	0.47	0.4969	0.466	0.49	1436666.0
2021-04-21	AAUAF-DELISTED	Stock	0.47	0.4969	0.466	0.495	1464454.0
2021-04-21	AAWW-DELISTED	Stock	67.34	67.575	65.89	66.82	337012.0
2021-04-21	AAXJ	Stock	92.7	93.679	92.4699	93.6	405606.0
2021-04-21	AB	Stock	39.88	40.74	39.74	40.69	387800.0
2021-04-21	ABB-DELISTED	Stock	32.28	32.75	32.19	32.74	1090689.0
2021-04-21	ABBNY-DELISTED	Stock	32.28	32.75	32.19	32.74	1280925.0
2021-04-21	ABBV	Stock	109.79	111.44	109.35	110.8	6181100.0
2021-04-21	ABC-DELISTED	Stock	121.0	121.66	120.32	121.14	365192.0
2021-04-21	ABCB	Stock	47.84	49.56	47.44	49.38	366000.0
2021-04-21	ABCL	Stock	27.8	29.3	27.376	29.06	814800.0
2021-04-21	ABCM-DELISTED	Stock	20.33	20.39	20.1283	20.3	58773.0
2021-04-21	ABEO	Stock	37.5	39.75	36.0	38.0	48044.0
2021-04-21	ABEV	Stock	2.86	2.93	2.85	2.9	10620600.0
2021-04-21	ABG	Stock	201.98	208.03	201.55	206.74	95800.0
2021-04-21	ABGI-DELISTED	Stock	9.92	9.98	9.91	9.93	2706.0
2021-04-21	ABM	Stock	51.62	52.09	51.28	51.82	543200.0
2021-04-21	ABMD-DELISTED	Stock	331.72	344.36	330.06	342.63	151159.0
2021-04-21	ABNB	Stock	168.09	170.32	164.12	167.07	3878600.0
2021-04-21	ABR	Stock	16.14	16.47	15.95	16.46	597400.0

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

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