PREVIEW / stock_daily / 2021-04-13

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-13.parquet
  size:    253 KB
  rows:    7,729
  symbols: 2,919

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-13	AAPL	Stock	132.44	134.66	131.93	134.43	91266500.0
2021-04-13	MSFT	Stock	257.26	259.19	256.83	258.49	23837500.0
2021-04-13	NVDA	Stock	15.2315	15.7	15.1258	15.6795	676212000.0
2021-04-13	AMZN	Stock	170.0425	171.6	169.7815	170.0	66316000.0
2021-04-13	GOOGL	Stock	112.5495	113.1735	112.1525	112.7215	25681560.0
2021-04-13	META	Stock	312.21	314.43	309.32	309.76	14036900.0
2021-04-13	TSLA	Stock	237.5667	254.3333	236.8867	254.1067	133958400.0
2021-04-13	TLT	Stock	137.3	138.51	137.2	138.48	13232786.0
2021-04-13	ES	Stock	85.87	87.78	85.86	87.44	1623900.0
2021-04-13	CL	Stock	79.5	79.83	79.12	79.73	4442500.0
2021-04-13	A	Stock	131.6	133.27	131.47	132.97	1593700.0
2021-04-13	AA	Stock	31.98	32.18	30.83	31.24	3412600.0
2021-04-13	AAC-DELISTED	Stock	9.99	9.99	9.9	9.9	121432.0
2021-04-13	AACG	Stock	3.74	3.75	3.21	3.31	293900.0
2021-04-13	AACQ-DELISTED	Stock	10.22	10.27	10.19	10.22	546769.0
2021-04-13	AACQU-DELISTED	Stock	10.872	10.91	10.75	10.81	90097.0
2021-04-13	AACQW-DELISTED	Stock	1.76	2.0	1.75	1.97	188548.0
2021-04-13	AAIC-DELISTED	Stock	4.0	4.04	3.96	3.99	113530.0
2021-04-13	AAIC.C-DELISTED	Stock	23.8	23.8907	23.7995	23.8842	4574.0
2021-04-13	AAL	Stock	22.18	22.65	21.66	22.56	44741600.0
2021-04-13	AAM.A-DELISTED	Stock	26.02	26.07	25.98	26.07	18502.0
2021-04-13	AAM.B-DELISTED	Stock	26.62	26.73	26.5986	26.67	37181.0
2021-04-13	AAMC-DELISTED	Stock	5.6029	5.7764	5.6029	5.7764	8065.0
2021-04-13	AAME	Stock	3.67	3.69	3.43	3.48	102700.0
2021-04-13	AAMI	Stock	23.43	23.51	22.79	23.2	1003100.0
2021-04-13	AAN-DELISTED	Stock	24.75	24.9	24.0	24.19	173900.0
2021-04-13	AAOI	Stock	8.24	8.39	8.11	8.22	649900.0
2021-04-13	AAON	Stock	46.3	46.3	45.1933	45.8867	208500.0
2021-04-13	AAP	Stock	188.77	188.91	185.44	187.41	632300.0
2021-04-13	AAT	Stock	33.1	33.48	32.74	33.45	255100.0
2021-04-13	AAU-DELISTED	Stock	0.4921	0.5155	0.4921	0.5071	1614508.0
2021-04-13	AAUAF-DELISTED	Stock	0.4921	0.5155	0.4921	0.5016	1649053.0
2021-04-13	AAWW-DELISTED	Stock	64.56	64.745	63.26	64.45	228109.0
2021-04-13	AAXJ	Stock	92.51	93.08	92.35	92.88	1985848.0
2021-04-13	AB	Stock	40.25	40.84	39.94	40.49	502800.0
2021-04-13	ABB-DELISTED	Stock	31.57	31.74	31.42	31.7	898601.0
2021-04-13	ABBNY-DELISTED	Stock	31.57	31.74	31.42	31.7	994967.0
2021-04-13	ABBV	Stock	108.03	108.36	107.03	108.22	6165100.0
2021-04-13	ABC-DELISTED	Stock	116.89	117.27	116.26	117.19	807376.0
2021-04-13	ABCB	Stock	52.11	52.11	50.17	50.26	434300.0
2021-04-13	ABCL	Stock	27.98	28.81	27.32	28.26	886100.0
2021-04-13	ABCM-DELISTED	Stock	19.29	19.82	19.29	19.6	150135.0
2021-04-13	ABEO	Stock	38.25	39.25	38.0	38.5	42880.0
2021-04-13	ABEV	Stock	2.73	2.81	2.71	2.77	23036800.0
2021-04-13	ABG	Stock	200.35	201.49	195.72	198.77	195500.0
2021-04-13	ABGI-DELISTED	Stock	9.96	9.96	9.9202	9.96	2382.0
2021-04-13	ABM	Stock	52.65	53.01	51.96	52.69	298100.0
2021-04-13	ABMD-DELISTED	Stock	334.13	336.77	328.425	329.39	130517.0
2021-04-13	ABNB	Stock	175.265	178.61	172.14	177.95	3573600.0
2021-04-13	ABR	Stock	16.4	16.5	16.26	16.34	860100.0

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

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