PREVIEW / stock_daily / 2021-04-12

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-12.parquet
  size:    256 KB
  rows:    7,723
  symbols: 2,903

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-12	AAPL	Stock	132.52	132.85	130.63	131.24	91420000.0
2021-04-12	MSFT	Stock	254.71	257.67	254.62	255.91	27148700.0
2021-04-12	NVDA	Stock	14.2898	15.3525	14.1393	15.209	869324000.0
2021-04-12	AMZN	Stock	167.7605	169.752	167.5575	168.9695	65636000.0
2021-04-12	GOOGL	Stock	112.706	112.8443	111.391	112.231	25023660.0
2021-04-12	META	Stock	311.05	312.15	307.93	311.54	10881900.0
2021-04-12	TSLA	Stock	228.5667	234.9333	227.3633	233.9933	87407100.0
2021-04-12	TLT	Stock	137.46	137.53	137.1	137.45	7658990.0
2021-04-12	ES	Stock	86.21	87.28	85.87	86.41	1251200.0
2021-04-12	CL	Stock	79.8	80.46	79.62	80.16	3510400.0
2021-04-12	A	Stock	131.44	132.18	130.84	131.27	1166300.0
2021-04-12	AA	Stock	31.5	31.88	31.1	31.77	4418500.0
2021-04-12	AAC-DELISTED	Stock	9.89	9.95	9.88	9.95	6981.0
2021-04-12	AACG	Stock	4.05	4.05	3.72	3.76	173700.0
2021-04-12	AACQ-DELISTED	Stock	10.24	10.365	10.18	10.3	409184.0
2021-04-12	AACQU-DELISTED	Stock	10.9	10.9999	10.85	10.9221	8585.0
2021-04-12	AACQW-DELISTED	Stock	1.95	2.06	1.83	1.84	94259.0
2021-04-12	AAIC-DELISTED	Stock	3.975	4.03	3.975	4.0	63150.0
2021-04-12	AAIC.C-DELISTED	Stock	23.7	23.9399	23.7	23.75	7250.0
2021-04-12	AAL	Stock	23.23	23.32	22.72	22.91	27165700.0
2021-04-12	AAM.A-DELISTED	Stock	26.0714	26.0714	25.98	26.01	10770.0
2021-04-12	AAM.B-DELISTED	Stock	26.72	26.79	26.66	26.67	38428.0
2021-04-12	AAMC-DELISTED	Stock	5.7559	5.7559	5.6505	5.6505	7354.0
2021-04-12	AAME	Stock	3.86	3.97	3.59	3.64	153200.0
2021-04-12	AAMI	Stock	22.84	23.54	22.63	23.38	724800.0
2021-04-12	AAN-DELISTED	Stock	24.78	24.998	24.42	24.88	127400.0
2021-04-12	AAOI	Stock	8.41	8.45	8.17	8.27	342400.0
2021-04-12	AAON	Stock	46.4933	46.72	46.0733	46.4533	201300.0
2021-04-12	AAP	Stock	184.05	188.53	184.05	188.06	613600.0
2021-04-12	AAT	Stock	33.21	33.26	32.6	33.21	127000.0
2021-04-12	AAU-DELISTED	Stock	0.532	0.532	0.4864	0.51	1676331.0
2021-04-12	AAUAF-DELISTED	Stock	0.5445	0.5472	0.4864	0.51	1928507.0
2021-04-12	AAWW-DELISTED	Stock	63.12	64.25	63.12	64.12	177996.0
2021-04-12	AAXJ	Stock	92.59	92.59	92.175	92.41	2127319.0
2021-04-12	AB	Stock	40.25	40.39	39.88	40.25	281900.0
2021-04-12	ABB-DELISTED	Stock	31.79	31.8171	31.6582	31.77	560893.0
2021-04-12	ABBNY-DELISTED	Stock	31.71	31.8171	31.65	31.77	847065.0
2021-04-12	ABBV	Stock	107.82	108.57	107.36	108.25	5647500.0
2021-04-12	ABC-DELISTED	Stock	116.97	118.5053	116.4304	117.55	758375.0
2021-04-12	ABCB	Stock	52.44	53.22	51.92	52.28	372000.0
2021-04-12	ABCL	Stock	28.115	28.68	26.8	27.92	1606100.0
2021-04-12	ABCM-DELISTED	Stock	19.36	19.74	19.31	19.39	70466.0
2021-04-12	ABEO	Stock	40.25	41.0	38.25	38.75	44192.0
2021-04-12	ABEV	Stock	2.78	2.78	2.73	2.74	13955000.0
2021-04-12	ABG	Stock	199.28	199.95	195.52	199.29	186800.0
2021-04-12	ABGI-DELISTED	Stock	10.0	10.02	9.98	10.01	18899.0
2021-04-12	ABM	Stock	53.53	54.03	52.98	53.03	426000.0
2021-04-12	ABMD-DELISTED	Stock	329.14	333.82	328.715	333.43	79478.0
2021-04-12	ABNB	Stock	179.68	181.49	176.25	176.49	2619800.0
2021-04-12	ABR	Stock	16.0	16.35	15.98	16.34	1066500.0

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

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