PREVIEW / stock_daily / 2021-04-09

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-09.parquet
  size:    253 KB
  rows:    7,740
  symbols: 2,920

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-09	AAPL	Stock	129.8	133.04	129.47	133.0	106686700.0
2021-04-09	MSFT	Stock	252.87	255.99	252.44	255.85	24326800.0
2021-04-09	NVDA	Stock	14.214	14.408	14.175	14.4	195172000.0
2021-04-09	AMZN	Stock	165.235	168.61	164.445	168.61	86830000.0
2021-04-09	GOOGL	Stock	112.272	113.6985	111.8628	113.5335	26145300.0
2021-04-09	META	Stock	311.4	314.74	310.33	312.46	15988600.0
2021-04-09	TSLA	Stock	225.9233	226.99	223.1433	225.6733	64311300.0
2021-04-09	TLT	Stock	137.5	138.19	137.09	137.51	8717951.0
2021-04-09	ES	Stock	87.35	87.85	86.13	86.18	1132000.0
2021-04-09	CL	Stock	79.67	80.17	79.17	79.78	3509000.0
2021-04-09	A	Stock	131.46	131.92	130.73	131.91	1552200.0
2021-04-09	AA	Stock	31.16	31.55	30.51	31.36	4317300.0
2021-04-09	AAC-DELISTED	Stock	9.8659	9.8888	9.84	9.8752	17023.0
2021-04-09	AACG	Stock	4.06	4.06	3.9	4.06	84300.0
2021-04-09	AACQ-DELISTED	Stock	10.39	10.4	10.25	10.3	989975.0
2021-04-09	AACQU-DELISTED	Stock	11.0	11.0	10.89	10.9	3044.0
2021-04-09	AACQW-DELISTED	Stock	1.95	2.1163	1.88	1.9	90257.0
2021-04-09	AAIC-DELISTED	Stock	4.02	4.0554	3.94	3.99	280982.0
2021-04-09	AAIC.C-DELISTED	Stock	23.8	23.8	23.6499	23.7075	6597.0
2021-04-09	AAL	Stock	23.45	23.67	23.25	23.54	21307700.0
2021-04-09	AAM.A-DELISTED	Stock	26.04	26.08	26.0301	26.07	13853.0
2021-04-09	AAM.B-DELISTED	Stock	26.88	26.88	26.82	26.82	5406.0
2021-04-09	AAMC-DELISTED	Stock	5.4882	5.7221	5.4882	5.6768	52013.0
2021-04-09	AAME	Stock	3.91	4.02	3.8	3.85	337100.0
2021-04-09	AAMI	Stock	22.99	23.4	22.23	22.93	1196000.0
2021-04-09	AAN-DELISTED	Stock	25.0	25.08	24.413	24.65	153600.0
2021-04-09	AAOI	Stock	8.32	8.51	8.27	8.44	350900.0
2021-04-09	AAON	Stock	45.8467	46.8867	45.5867	46.7733	183600.0
2021-04-09	AAP	Stock	182.16	184.46	181.24	183.97	831000.0
2021-04-09	AAT	Stock	32.81	33.34	32.81	33.15	190200.0
2021-04-09	AAU-DELISTED	Stock	0.549	0.55	0.5284	0.54	781653.0
2021-04-09	AAUAF-DELISTED	Stock	0.549	0.55	0.5284	0.54	809504.0
2021-04-09	AAWW-DELISTED	Stock	61.69	62.875	61.69	62.8	205023.0
2021-04-09	AAXJ	Stock	93.04	93.25	92.83	93.25	1276452.0
2021-04-09	AB	Stock	40.64	40.8	39.91	40.29	362200.0
2021-04-09	ABB-DELISTED	Stock	31.78	32.095	31.77	32.08	885938.0
2021-04-09	ABBNY-DELISTED	Stock	31.78	32.095	31.77	32.08	978326.0
2021-04-09	ABBV	Stock	106.39	107.72	106.05	107.54	5977500.0
2021-04-09	ABC-DELISTED	Stock	115.92	116.94	115.58	116.68	521487.0
2021-04-09	ABCB	Stock	52.0	52.35	51.33	52.1	261100.0
2021-04-09	ABCL	Stock	29.96	30.75	27.61	28.35	2392300.0
2021-04-09	ABCM-DELISTED	Stock	19.67	19.97	19.55	19.89	80025.0
2021-04-09	ABEO	Stock	41.25	41.75	40.25	41.0	49300.0
2021-04-09	ABEV	Stock	2.79	2.81	2.74	2.77	18051200.0
2021-04-09	ABG	Stock	195.4	199.75	195.17	198.49	95300.0
2021-04-09	ABGI-DELISTED	Stock	9.94	9.97	9.92	9.97	20823.0
2021-04-09	ABM	Stock	51.9	53.33	51.66	53.3	428700.0
2021-04-09	ABMD-DELISTED	Stock	328.54	333.9999	326.07	333.82	121590.0
2021-04-09	ABNB	Stock	179.62	182.46	177.25	179.5	2910200.0
2021-04-09	ABR	Stock	16.04	16.15	15.89	15.93	924200.0

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

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