PREVIEW / stock_daily / 2021-03-26

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-26.parquet
  size:    252 KB
  rows:    7,689
  symbols: 2,897

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-26	AAPL	Stock	120.35	121.48	118.92	121.21	94071200.0
2021-03-26	MSFT	Stock	231.55	236.71	231.55	236.48	25479900.0
2021-03-26	NVDA	Stock	12.5545	12.8563	12.3735	12.8393	363968000.0
2021-03-26	AMZN	Stock	152.203	152.833	149.8	152.6015	66258000.0
2021-03-26	GOOGL	Stock	101.5895	101.9692	100.1925	101.2365	27977500.0
2021-03-26	META	Stock	278.3	284.5	277.77	283.02	17629200.0
2021-03-26	TSLA	Stock	213.9567	214.6067	199.9633	206.2367	101558400.0
2021-03-26	TLT	Stock	136.42	137.2392	136.22	136.66	8433292.0
2021-03-26	ES	Stock	85.56	86.0	84.55	85.79	1386900.0
2021-03-26	CL	Stock	77.79	79.26	77.52	79.22	4170300.0
2021-03-26	A	Stock	122.54	125.71	122.03	125.64	1441900.0
2021-03-26	AA	Stock	30.41	32.8	30.15	32.78	9604300.0
2021-03-26	AAC-DELISTED	Stock	9.85	9.96	9.75	9.96	155151.0
2021-03-26	AACG	Stock	4.3	5.44	4.3	4.92	5809500.0
2021-03-26	AACQ-DELISTED	Stock	10.1	10.29	10.05	10.28	1382904.0
2021-03-26	AACQU-DELISTED	Stock	10.8	10.91	10.63	10.76	1785.0
2021-03-26	AACQW-DELISTED	Stock	1.94	2.15	1.82	1.94	140428.0
2021-03-26	AAIC-DELISTED	Stock	4.02	4.06	3.97	4.03	186034.0
2021-03-26	AAIC.C-DELISTED	Stock	23.2	23.54	23.2	23.54	5819.0
2021-03-26	AAL	Stock	23.14	23.29	22.28	22.93	36972400.0
2021-03-26	AAM.A-DELISTED	Stock	25.97	26.04	25.88	26.04	10252.0
2021-03-26	AAM.B-DELISTED	Stock	26.84	26.87	26.67	26.87	6529.0
2021-03-26	AAMC-DELISTED	Stock	4.9235	5.1471	4.8176	5.065	40916.0
2021-03-26	AAME	Stock	3.95	4.0	3.56	3.64	265000.0
2021-03-26	AAMI	Stock	19.65	19.72	19.24	19.59	361500.0
2021-03-26	AAN-DELISTED	Stock	25.75	26.48	25.43	25.99	394700.0
2021-03-26	AAOI	Stock	7.88	8.29	7.88	8.29	511100.0
2021-03-26	AAON	Stock	47.4133	48.5333	47.0	48.22	210150.0
2021-03-26	AAP	Stock	186.79	187.68	184.83	187.32	804400.0
2021-03-26	AAT	Stock	33.2	33.56	32.99	33.41	221800.0
2021-03-26	AAU-DELISTED	Stock	0.535	0.5655	0.535	0.5622	2162502.0
2021-03-26	AAUAF-DELISTED	Stock	0.535	0.5655	0.535	0.5622	2220572.0
2021-03-26	AAWW-DELISTED	Stock	56.32	58.29	56.0	58.15	330325.0
2021-03-26	AAXJ	Stock	91.17	92.75	90.87	92.56	1124747.0
2021-03-26	AB	Stock	39.17	39.64	38.86	39.55	486800.0
2021-03-26	ABB-DELISTED	Stock	31.18	31.59	31.13	31.59	1752595.0
2021-03-26	ABBNY-DELISTED	Stock	31.18	31.59	31.13	31.59	1876287.0
2021-03-26	ABBV	Stock	103.87	106.12	103.84	105.98	6596900.0
2021-03-26	ABC-DELISTED	Stock	118.0	118.85	117.24	118.69	550566.0
2021-03-26	ABCB	Stock	53.47	55.01	53.15	54.94	613200.0
2021-03-26	ABCL	Stock	26.898	27.11	24.07	24.75	1703200.0
2021-03-26	ABCM-DELISTED	Stock	19.7	19.89	19.51	19.89	28469.0
2021-03-26	ABEO	Stock	47.0	47.0	43.5	45.0	72308.0
2021-03-26	ABEV	Stock	2.7	2.73	2.65	2.68	11584300.0
2021-03-26	ABG	Stock	192.42	199.43	190.57	199.29	206600.0
2021-03-26	ABGI-DELISTED	Stock	9.75	9.8	9.75	9.79	1617.0
2021-03-26	ABM	Stock	50.5	52.52	50.18	52.49	538500.0
2021-03-26	ABMD-DELISTED	Stock	295.73	302.05	290.47	301.61	151031.0
2021-03-26	ABNB	Stock	178.416	181.0	168.0	174.4	3562900.0
2021-03-26	ABR	Stock	15.86	15.93	15.0	15.4	5779300.0

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

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