PREVIEW / stock_daily / 2021-04-27

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-27.parquet
  size:    254 KB
  rows:    7,785
  symbols: 2,933

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-27	AAPL	Stock	135.01	135.41	134.11	134.39	66015800.0
2021-04-27	MSFT	Stock	261.58	263.19	260.12	261.97	31014200.0
2021-04-27	NVDA	Stock	15.5785	15.6705	15.3545	15.3818	164572000.0
2021-04-27	AMZN	Stock	172.1735	173.0	169.9005	170.8715	76542000.0
2021-04-27	GOOGL	Stock	115.8816	115.9225	114.308	114.549	44385600.0
2021-04-27	META	Stock	304.28	305.34	301.11	303.57	15309300.0
2021-04-27	TSLA	Stock	239.32	241.3333	234.45	234.9133	88311000.0
2021-04-27	TLT	Stock	139.59	139.82	138.525	138.64	14137281.0
2021-04-27	ES	Stock	87.66	88.02	86.88	87.02	904000.0
2021-04-27	CL	Stock	78.96	79.13	78.41	78.56	4148900.0
2021-04-27	A	Stock	136.93	137.44	136.23	136.48	1752900.0
2021-04-27	AA	Stock	36.04	37.7	35.82	36.75	5855200.0
2021-04-27	AAC-DELISTED	Stock	9.8395	9.8694	9.7911	9.8	105181.0
2021-04-27	AACG	Stock	3.1	3.28	3.05	3.2	346600.0
2021-04-27	AACQ-DELISTED	Stock	10.1	10.22	10.01	10.04	946586.0
2021-04-27	AACQU-DELISTED	Stock	10.61	10.8929	10.61	10.8929	3371.0
2021-04-27	AACQW-DELISTED	Stock	1.72	1.865	1.62	1.865	287329.0
2021-04-27	AAIC-DELISTED	Stock	4.14	4.21	4.13	4.14	153012.0
2021-04-27	AAIC.C-DELISTED	Stock	24.0746	24.15	24.045	24.11	1706.0
2021-04-27	AAL	Stock	22.01	22.07	21.6	21.76	26767100.0
2021-04-27	AAM.A-DELISTED	Stock	26.09	26.12	26.08	26.1	16813.0
2021-04-27	AAM.B-DELISTED	Stock	27.0	27.06	26.91	26.98	15142.0
2021-04-27	AAMC-DELISTED	Stock	5.1029	5.2618	5.0706	5.2059	61492.0
2021-04-27	AAME	Stock	4.21	4.21	4.01	4.02	62400.0
2021-04-27	AAMI	Stock	23.43	23.64	23.29	23.42	427000.0
2021-04-27	AAN-DELISTED	Stock	30.25	34.26	29.61	34.16	935000.0
2021-04-27	AAOI	Stock	8.29	8.29	8.1	8.13	360100.0
2021-04-27	AAON	Stock	45.9067	46.0133	45.3333	45.6867	101100.0
2021-04-27	AAP	Stock	198.56	199.16	197.06	197.28	578400.0
2021-04-27	AAT	Stock	34.4	34.9	34.4	34.61	256600.0
2021-04-27	AAU-DELISTED	Stock	0.58	0.58	0.5556	0.556	1092538.0
2021-04-27	AAUAF-DELISTED	Stock	0.58	0.58	0.555	0.555	1131988.0
2021-04-27	AAWW-DELISTED	Stock	67.99	69.64	67.99	68.99	331986.0
2021-04-27	AAXJ	Stock	94.78	95.01	94.67	94.85	515829.0
2021-04-27	AB	Stock	42.89	43.13	42.4	42.97	247200.0
2021-04-27	ABB-DELISTED	Stock	33.12	33.19	32.93	33.06	1001102.0
2021-04-27	ABBNY-DELISTED	Stock	33.12	33.19	32.93	33.06	1101957.0
2021-04-27	ABBV	Stock	111.25	111.85	110.58	111.44	3522900.0
2021-04-27	ABC-DELISTED	Stock	119.3	119.765	117.78	118.79	820607.0
2021-04-27	ABCB	Stock	51.36	52.19	51.13	52.15	313900.0
2021-04-27	ABCL	Stock	31.31	31.445	29.18	29.48	855100.0
2021-04-27	ABCM-DELISTED	Stock	21.11	21.3	21.01	21.15	188986.0
2021-04-27	ABEO	Stock	43.5	44.75	41.75	42.0	46240.0
2021-04-27	ABEV	Stock	2.83	2.87	2.82	2.82	11813000.0
2021-04-27	ABG	Stock	207.0	207.93	199.21	204.73	222900.0
2021-04-27	ABGI-DELISTED	Stock	9.9793	9.98	9.91	9.95	81500.0
2021-04-27	ABM	Stock	53.29	53.5	52.57	52.68	341200.0
2021-04-27	ABMD-DELISTED	Stock	348.79	349.14	340.16	340.27	159498.0
2021-04-27	ABNB	Stock	176.165	179.61	174.8	177.94	2883000.0
2021-04-27	ABR	Stock	17.4	17.66	17.33	17.49	956000.0

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

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