PREVIEW / stock_daily / 2020-10-13

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-13.parquet
  size:    228 KB
  rows:    6,916
  symbols: 2,450

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-10-13	AAPL	Stock	125.27	125.39	119.65	121.1	262330500.0
2020-10-13	MSFT	Stock	222.72	225.21	220.43	222.86	28950800.0
2020-10-13	NVDA	Stock	14.2965	14.3485	14.0188	14.2482	344604000.0
2020-10-13	AMZN	Stock	173.3995	174.619	171.211	172.1815	114894000.0
2020-10-13	GOOGL	Stock	78.8505	79.258	77.9315	78.3535	39072180.0
2020-10-13	META	Stock	277.58	279.1	273.39	276.14	18063300.0
2020-10-13	TSLA	Stock	147.7833	149.63	145.5333	148.8833	103391100.0
2020-10-13	TLT	Stock	161.21	161.83	161.18	161.75	7914641.0
2020-10-13	ES	Stock	91.9	92.92	91.18	92.66	1016500.0
2020-10-13	CL	Stock	80.5	80.99	79.85	80.26	3042800.0
2020-10-13	A	Stock	105.44	106.01	104.96	105.42	915500.0
2020-10-13	AA	Stock	12.44	12.83	12.36	12.72	5930800.0
2020-10-13	AACG	Stock	1.24	1.29	1.06	1.09	184800.0
2020-10-13	AACQ-DELISTED	Stock	9.8225	9.91	9.77	9.79	46070.0
2020-10-13	AACQU-DELISTED	Stock	10.265	10.265	10.255	10.255	897.0
2020-10-13	AACQW-DELISTED	Stock	1.4	1.46	1.33	1.3499	98979.0
2020-10-13	AAIC-DELISTED	Stock	2.84	2.89	2.83	2.85	126857.0
2020-10-13	AAIC.C-DELISTED	Stock	18.78	18.8	18.735	18.8	1001.0
2020-10-13	AAL	Stock	12.59	12.64	12.2	12.22	63372200.0
2020-10-13	AAM.A-DELISTED	Stock	26.36	26.415	26.2001	26.415	22718.0
2020-10-13	AAM.B-DELISTED	Stock	27.39	27.39	27.13	27.2904	25045.0
2020-10-13	AAMC-DELISTED	Stock	5.9206	6.4647	5.8144	5.8144	21046.0
2020-10-13	AAME	Stock	2.03	2.33	2.02	2.1	59800.0
2020-10-13	AAMI	Stock	15.09	15.76	15.09	15.57	529300.0
2020-10-13	AAOI	Stock	11.37	11.71	11.2	11.5	254700.0
2020-10-13	AAON	Stock	43.1267	43.6	42.3667	42.7133	253350.0
2020-10-13	AAP	Stock	155.61	158.08	155.22	157.38	753400.0
2020-10-13	AAT	Stock	25.85	25.9	24.8	25.03	274100.0
2020-10-13	AAU-DELISTED	Stock	0.7605	0.8487	0.7605	0.8469	402458.0
2020-10-13	AAUAF-DELISTED	Stock	0.7605	0.8487	0.7605	0.8484	432324.0
2020-10-13	AAWW-DELISTED	Stock	67.13	68.3	66.1801	66.87	191616.0
2020-10-13	AAXJ	Stock	80.64	80.775	80.32	80.67	789791.0
2020-10-13	AAXN-DELISTED	Stock	99.0	101.87	98.595	101.74	319376.0
2020-10-13	AB	Stock	32.37	32.47	31.61	32.37	736500.0
2020-10-13	ABB-DELISTED	Stock	26.93	26.93	26.73	26.77	720648.0
2020-10-13	ABBNY-DELISTED	Stock	26.93	26.93	26.73	26.77	803134.0
2020-10-13	ABBV	Stock	88.01	88.8	87.47	87.83	7851700.0
2020-10-13	ABC-DELISTED	Stock	96.18	97.55	95.59	97.26	491910.0
2020-10-13	ABCB	Stock	26.33	26.34	25.43	25.55	261700.0
2020-10-13	ABEO	Stock	32.0	34.75	32.0	34.25	55476.0
2020-10-13	ABEV	Stock	2.48	2.51	2.44	2.49	13605400.0
2020-10-13	ABG	Stock	111.94	114.26	111.18	112.63	129600.0
2020-10-13	ABM	Stock	36.8	37.25	36.58	37.12	230200.0
2020-10-13	ABMD-DELISTED	Stock	278.2336	280.95	274.96	277.02	112536.0
2020-10-13	ABR	Stock	11.81	11.93	11.74	11.77	537500.0
2020-10-13	ABR.A-DELISTED	Stock	25.27	25.27	25.15	25.15	343.0
2020-10-13	ABR.B-DELISTED	Stock	25.1	25.1	25.1	25.1	175.0
2020-10-13	ABR.C-DELISTED	Stock	25.59	25.784	25.59	25.6175	617.0
2020-10-13	ABT	Stock	110.5	110.99	108.25	108.37	4773600.0
2020-10-13	ABTC	Stock	141000.0	149400.0	135030.0	144900.0	13.4

> showing 50 of 6,916 rows — these rows as CSV

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