PREVIEW / stock_daily / 2020-10-14

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-14.parquet
  size:    228 KB
  rows:    6,935
  symbols: 2,460

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-14	AAPL	Stock	121.0	123.03	119.62	121.19	150712000.0
2020-10-14	MSFT	Stock	223.0	224.22	219.13	220.86	23421700.0
2020-10-14	NVDA	Stock	14.2905	14.3428	13.96	14.0952	276100000.0
2020-10-14	AMZN	Stock	172.35	173.244	167.0	168.1855	116254000.0
2020-10-14	GOOGL	Stock	78.73	79.1925	77.2948	78.172	33184560.0
2020-10-14	META	Stock	277.62	278.75	271.5	271.82	15577800.0
2020-10-14	TSLA	Stock	149.9267	155.3	149.1167	153.7667	143639100.0
2020-10-14	TLT	Stock	162.33	162.75	161.9674	162.12	6956736.0
2020-10-14	ES	Stock	91.99	92.7	91.24	91.83	1069700.0
2020-10-14	CL	Stock	80.44	80.63	79.42	79.86	2200100.0
2020-10-14	A	Stock	105.49	106.67	104.92	105.06	906700.0
2020-10-14	AA	Stock	12.79	13.14	12.706	13.0	7412300.0
2020-10-14	AACG	Stock	1.09	1.17	1.08	1.15	85700.0
2020-10-14	AACQ-DELISTED	Stock	9.8501	9.89	9.8	9.8018	332801.0
2020-10-14	AACQU-DELISTED	Stock	10.3722	10.4	10.21	10.3	2543.0
2020-10-14	AACQW-DELISTED	Stock	1.35	1.3999	1.33	1.3497	165240.0
2020-10-14	AAIC-DELISTED	Stock	2.85	2.89	2.83	2.83	123801.0
2020-10-14	AAIC.C-DELISTED	Stock	18.76	18.85	18.75	18.84	11200.0
2020-10-14	AAL	Stock	12.35	12.57	12.29	12.36	37500000.0
2020-10-14	AAM.A-DELISTED	Stock	26.3158	26.41	26.3158	26.41	7212.0
2020-10-14	AAM.B-DELISTED	Stock	27.35	27.38	27.185	27.38	14065.0
2020-10-14	AAMC-DELISTED	Stock	6.0294	6.0294	5.5735	5.75	52227.0
2020-10-14	AAME	Stock	2.31	2.39	2.2	2.28	86600.0
2020-10-14	AAMI	Stock	15.61	15.88	15.42	15.77	290100.0
2020-10-14	AAOI	Stock	11.5	11.56	11.11	11.18	311900.0
2020-10-14	AAON	Stock	42.7133	43.2333	42.54	42.7933	214200.0
2020-10-14	AAP	Stock	158.16	159.18	154.79	156.58	581800.0
2020-10-14	AAT	Stock	24.91	25.05	24.34	24.36	273700.0
2020-10-14	AAU-DELISTED	Stock	0.89	1.03	0.86	1.0199	1842887.0
2020-10-14	AAUAF-DELISTED	Stock	0.89	1.03	0.86	1.02	1895278.0
2020-10-14	AAWW-DELISTED	Stock	67.0	68.68	67.0	68.19	169917.0
2020-10-14	AAXJ	Stock	80.57	80.74	80.03	80.08	693611.0
2020-10-14	AAXN-DELISTED	Stock	102.0	103.71	100.17	101.39	257892.0
2020-10-14	AB	Stock	32.4	33.24	32.4	32.98	640300.0
2020-10-14	ABB-DELISTED	Stock	26.93	26.98	26.75	26.77	870856.0
2020-10-14	ABBNY-DELISTED	Stock	26.93	26.98	26.75	26.76	932934.0
2020-10-14	ABBV	Stock	86.83	87.11	85.9	86.07	5863900.0
2020-10-14	ABC-DELISTED	Stock	97.04	99.31	97.04	98.46	529320.0
2020-10-14	ABCB	Stock	25.61	25.91	25.25	25.32	252400.0
2020-10-14	ABEO	Stock	33.75	36.25	32.5	32.75	70560.0
2020-10-14	ABEV	Stock	2.49	2.53	2.48	2.51	24554200.0
2020-10-14	ABG	Stock	116.3	116.3	111.59	112.27	162900.0
2020-10-14	ABM	Stock	37.16	37.76	36.26	36.29	193500.0
2020-10-14	ABMD-DELISTED	Stock	279.25	287.51	278.63	280.825	144902.0
2020-10-14	ABR	Stock	11.81	11.98	11.72	11.74	875300.0
2020-10-14	ABR.A-DELISTED	Stock	25.2431	25.3074	25.17	25.2	4900.0
2020-10-14	ABR.B-DELISTED	Stock	25.1	25.1	25.1	25.1	367.0
2020-10-14	ABR.C-DELISTED	Stock	25.55	25.595	25.3	25.485	4800.0
2020-10-14	ABT	Stock	108.61	109.83	107.34	107.75	4191600.0
2020-10-14	ABTC	Stock	144900.0	146700.0	136800.0	140100.0	3.6

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

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