PREVIEW / stock_daily / 2021-04-26

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-26.parquet
  size:    256 KB
  rows:    7,790
  symbols: 2,938

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-26	AAPL	Stock	134.83	135.06	133.56	134.72	66905100.0
2021-04-26	MSFT	Stock	261.66	262.44	260.17	261.55	19763300.0
2021-04-26	NVDA	Stock	15.185	15.479	15.125	15.478	197796000.0
2021-04-26	AMZN	Stock	167.4	171.4225	166.547	170.45	97614000.0
2021-04-26	GOOGL	Stock	115.226	116.2265	114.8658	115.4965	32037840.0
2021-04-26	META	Stock	303.34	305.8	301.56	303.04	16172600.0
2021-04-26	TSLA	Stock	247.0	249.7667	244.2033	246.0667	93115500.0
2021-04-26	TLT	Stock	140.15	140.51	139.85	139.86	9103549.0
2021-04-26	ES	Stock	88.13	88.19	87.23	87.77	846500.0
2021-04-26	CL	Stock	79.75	79.89	78.97	79.28	3920000.0
2021-04-26	A	Stock	137.21	137.83	136.68	137.34	1287400.0
2021-04-26	AA	Stock	35.16	37.06	34.995	36.8	7747600.0
2021-04-26	AAC-DELISTED	Stock	9.79	9.86	9.78	9.8	83946.0
2021-04-26	AACG	Stock	2.89	3.18	2.88	3.03	279700.0
2021-04-26	AACQ-DELISTED	Stock	10.0099	10.08	10.0099	10.07	412010.0
2021-04-26	AACQU-DELISTED	Stock	10.36	10.9	10.36	10.5972	362.0
2021-04-26	AACQW-DELISTED	Stock	1.6	1.74	1.6	1.71	95948.0
2021-04-26	AAIC-DELISTED	Stock	4.15	4.205	4.125	4.15	167438.0
2021-04-26	AAIC.C-DELISTED	Stock	23.9	24.15	23.8999	24.1305	16366.0
2021-04-26	AAL	Stock	21.52	22.05	21.48	22.04	44349200.0
2021-04-26	AAM.A-DELISTED	Stock	26.04	26.12	26.04	26.1199	13514.0
2021-04-26	AAM.B-DELISTED	Stock	26.98	27.0	26.8216	26.97	33731.0
2021-04-26	AAMC-DELISTED	Stock	5.1529	5.2353	4.9102	5.2059	183022.0
2021-04-26	AAME	Stock	4.01	4.2	4.0	4.19	386500.0
2021-04-26	AAMI	Stock	23.32	23.47	23.09	23.38	613700.0
2021-04-26	AAN-DELISTED	Stock	25.75	26.99	25.75	26.43	268700.0
2021-04-26	AAOI	Stock	8.29	8.46	8.17	8.28	511300.0
2021-04-26	AAON	Stock	46.6667	46.7333	45.6333	45.6933	117150.0
2021-04-26	AAP	Stock	199.07	199.49	196.32	197.14	497700.0
2021-04-26	AAT	Stock	34.48	35.35	34.47	34.5	321000.0
2021-04-26	AAU-DELISTED	Stock	0.57	0.584	0.56	0.5762	1183521.0
2021-04-26	AAUAF-DELISTED	Stock	0.57	0.584	0.56	0.5795	1234070.0
2021-04-26	AAWW-DELISTED	Stock	67.86	68.5959	66.37	67.33	393583.0
2021-04-26	AAXJ	Stock	94.38	94.81	94.315	94.78	2443720.0
2021-04-26	AB	Stock	42.27	42.77	42.27	42.63	328300.0
2021-04-26	ABB-DELISTED	Stock	32.65	32.77	32.59	32.76	1147125.0
2021-04-26	ABBNY-DELISTED	Stock	32.65	32.77	32.59	32.75	1236810.0
2021-04-26	ABBV	Stock	111.56	112.04	110.85	111.39	5202300.0
2021-04-26	ABC-DELISTED	Stock	121.78	121.78	119.51	119.74	340229.0
2021-04-26	ABCB	Stock	51.87	52.83	51.21	51.42	283800.0
2021-04-26	ABCL	Stock	29.55	31.81	29.132	31.6	679700.0
2021-04-26	ABCM-DELISTED	Stock	20.75	21.07	20.59	21.07	52017.0
2021-04-26	ABEO	Stock	40.0	44.0	40.0	42.75	61696.0
2021-04-26	ABEV	Stock	2.92	2.93	2.87	2.87	14615600.0
2021-04-26	ABG	Stock	213.2	214.35	206.57	207.94	169100.0
2021-04-26	ABGI-DELISTED	Stock	9.93	9.96	9.93	9.95	2380.0
2021-04-26	ABM	Stock	53.8	54.46	53.13	53.23	380500.0
2021-04-26	ABMD-DELISTED	Stock	352.63	353.2	346.65	348.08	167658.0
2021-04-26	ABNB	Stock	175.21	176.031	171.07	174.88	2549400.0
2021-04-26	ABR	Stock	17.29	17.72	17.25	17.37	1209700.0

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

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