PREVIEW / stock_daily / 2021-03-12

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-12.parquet
  size:    251 KB
  rows:    7,637
  symbols: 2,864

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-03-12	AAPL	Stock	120.4	121.17	119.16	121.03	88105100.0
2021-03-12	MSFT	Stock	234.01	235.82	233.23	235.75	22653700.0
2021-03-12	NVDA	Stock	12.6483	12.8888	12.59	12.856	243964000.0
2021-03-12	AMZN	Stock	153.75	154.949	152.275	154.4745	48438000.0
2021-03-12	GOOGL	Stock	103.8205	103.8805	101.621	102.5	33817980.0
2021-03-12	META	Stock	269.14	269.74	264.02	268.4	20600200.0
2021-03-12	TSLA	Stock	223.3333	231.6267	222.0467	231.2433	100751400.0
2021-03-12	TLT	Stock	136.4	136.4591	135.65	136.06	20402701.0
2021-03-12	ES	Stock	81.57	82.22	80.98	82.1	1177700.0
2021-03-12	CL	Stock	75.87	76.25	75.39	75.51	3141700.0
2021-03-12	A	Stock	120.57	122.03	119.28	121.44	1368700.0
2021-03-12	AA	Stock	31.89	32.48	31.28	31.51	4733000.0
2021-03-12	AACG	Stock	4.8	4.95	4.39	4.47	422400.0
2021-03-12	AACQ-DELISTED	Stock	10.56	10.78	10.5401	10.74	1126220.0
2021-03-12	AACQU-DELISTED	Stock	11.45	11.57	11.45	11.56	3793.0
2021-03-12	AACQW-DELISTED	Stock	2.38	2.55	2.35	2.5	158575.0
2021-03-12	AAIC-DELISTED	Stock	4.34	4.4	4.26	4.31	121319.0
2021-03-12	AAIC.C-DELISTED	Stock	22.23	22.25	22.2	22.22	1500.0
2021-03-12	AAL	Stock	22.18	23.54	22.13	23.37	55260300.0
2021-03-12	AAM.A-DELISTED	Stock	25.84	25.89	25.79	25.88	14571.0
2021-03-12	AAM.B-DELISTED	Stock	26.6	26.6	26.49	26.59	18301.0
2021-03-12	AAMC-DELISTED	Stock	5.4706	5.6176	4.6353	5.2882	359448.0
2021-03-12	AAME	Stock	4.37	4.37	4.1	4.37	80900.0
2021-03-12	AAMI	Stock	20.34	20.625	20.03	20.17	362900.0
2021-03-12	AAN-DELISTED	Stock	24.58	25.78	24.56	25.39	365300.0
2021-03-12	AAOI	Stock	8.8	9.055	8.71	8.95	516300.0
2021-03-12	AAON	Stock	48.6333	50.0	48.6333	49.9067	346350.0
2021-03-12	AAP	Stock	174.14	179.75	173.65	179.58	1040900.0
2021-03-12	AAT	Stock	34.87	35.67	34.73	35.49	263400.0
2021-03-12	AAU-DELISTED	Stock	0.69	0.7237	0.663	0.7121	1103613.0
2021-03-12	AAUAF-DELISTED	Stock	0.69	0.7237	0.663	0.7199	1147422.0
2021-03-12	AAWW-DELISTED	Stock	61.79	61.98	59.425	60.16	263042.0
2021-03-12	AAXJ	Stock	93.9	94.17	93.45	94.07	1289490.0
2021-03-12	AB	Stock	39.28	39.28	38.57	38.6	427700.0
2021-03-12	ABB-DELISTED	Stock	30.53	30.79	30.51	30.79	1167659.0
2021-03-12	ABBNY-DELISTED	Stock	30.53	30.79	30.51	30.79	1260728.0
2021-03-12	ABBV	Stock	107.8	108.58	107.37	108.22	5341200.0
2021-03-12	ABC-DELISTED	Stock	110.77	113.385	110.0	112.97	868448.0
2021-03-12	ABCB	Stock	54.97	55.96	54.56	55.47	452900.0
2021-03-12	ABCL	Stock	36.21	36.845	34.85	36.54	432700.0
2021-03-12	ABCM-DELISTED	Stock	21.1223	21.38	20.87	21.21	70541.0
2021-03-12	ABEO	Stock	57.0	59.5	55.75	58.75	75012.0
2021-03-12	ABEV	Stock	2.73	2.78	2.72	2.75	15919900.0
2021-03-12	ABG	Stock	190.02	191.8	185.53	191.05	114300.0
2021-03-12	ABGI-DELISTED	Stock	10.0293	10.065	10.01	10.01	1500.0
2021-03-12	ABM	Stock	50.45	52.33	50.45	51.94	615300.0
2021-03-12	ABMD-DELISTED	Stock	300.44	304.76	297.245	303.44	160782.0
2021-03-12	ABNB	Stock	196.27	208.7	192.2	206.74	5556500.0
2021-03-12	ABR	Stock	16.58	16.78	16.57	16.69	1024500.0
2021-03-12	ABR.A-DELISTED	Stock	25.71	25.72	25.6069	25.66	736.0

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

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