PREVIEW / stock_daily / 2021-06-30

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-30.parquet
  size:    259 KB
  rows:    7,935
  symbols: 2,924

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-06-30	AAPL	Stock	136.17	137.41	135.87	136.96	63261400.0
2021-06-30	MSFT	Stock	270.69	271.36	269.6	270.9	21656500.0
2021-06-30	NVDA	Stock	19.9993	20.1625	19.8638	20.0025	326568000.0
2021-06-30	AMZN	Stock	172.053	173.58	171.75	172.008	48080000.0
2021-06-30	GOOGL	Stock	121.9945	122.257	121.3545	122.0895	24473980.0
2021-06-30	META	Stock	352.17	352.92	347.17	347.71	15107500.0
2021-06-30	TSLA	Stock	226.59	230.9367	226.0467	226.5667	56774700.0
2021-06-30	TLT	Stock	144.25	144.93	144.07	144.35	15708857.0
2021-06-30	ES	Stock	80.2	80.81	79.85	80.24	1311000.0
2021-06-30	CL	Stock	81.57	81.67	80.82	81.35	4687700.0
2021-06-30	A	Stock	148.68	148.78	146.66	147.81	1259300.0
2021-06-30	AA	Stock	37.2	37.804	36.68	36.84	6047800.0
2021-06-30	AAC-DELISTED	Stock	9.76	9.79	9.75	9.75	17365.0
2021-06-30	AACG	Stock	3.15	3.18	3.01	3.08	72300.0
2021-06-30	AAIC-DELISTED	Stock	4.18	4.185	4.06	4.07	222265.0
2021-06-30	AAIC.C-DELISTED	Stock	25.01	25.01	25.01	25.01	180.0
2021-06-30	AAL	Stock	21.09	21.48	20.94	21.21	26231800.0
2021-06-30	AAM.A-DELISTED	Stock	26.24	26.45	26.05	26.24	126645.0
2021-06-30	AAM.B-DELISTED	Stock	26.87	26.99	26.81	26.86	93961.0
2021-06-30	AAME	Stock	4.34	4.48	4.17	4.32	28000.0
2021-06-30	AAMI	Stock	23.51	23.6	23.18	23.43	633300.0
2021-06-30	AAN-DELISTED	Stock	32.56	32.99	31.88	31.99	301100.0
2021-06-30	AAOI	Stock	8.63	8.73	8.42	8.47	483500.0
2021-06-30	AAON	Stock	42.2267	42.6867	41.6067	41.7267	693600.0
2021-06-30	AAP	Stock	206.22	207.6	204.15	205.14	569500.0
2021-06-30	AAQC-DELISTED	Stock	9.69	9.69	9.68	9.69	3062.0
2021-06-30	AAT	Stock	37.0	37.6	36.99	37.29	304600.0
2021-06-30	AAU-DELISTED	Stock	0.495	0.5013	0.4916	0.5008	392004.0
2021-06-30	AAUAF-DELISTED	Stock	0.495	0.5013	0.4916	0.501	403319.0
2021-06-30	AAWW-DELISTED	Stock	68.39	68.45	67.36	68.13	386214.0
2021-06-30	AAXJ	Stock	94.33	94.689	94.27	94.5	275082.0
2021-06-30	AB	Stock	45.94	46.69	45.66	46.56	300000.0
2021-06-30	ABB-DELISTED	Stock	34.08	34.19	33.895	33.99	1477617.0
2021-06-30	ABBNY-DELISTED	Stock	34.08	34.19	33.895	33.99	1583351.0
2021-06-30	ABBV	Stock	112.21	112.92	111.63	112.64	5042600.0
2021-06-30	ABC-DELISTED	Stock	114.62	115.1	113.62	114.48	576964.0
2021-06-30	ABCB	Stock	50.39	50.92	50.26	50.63	320000.0
2021-06-30	ABCL	Stock	21.29	22.5	20.83	22.0	2137200.0
2021-06-30	ABCM-DELISTED	Stock	19.32	19.32	18.94	19.01	376351.0
2021-06-30	ABEO	Stock	40.75	40.75	38.75	39.0	37816.0
2021-06-30	ABEV	Stock	3.45	3.49	3.39	3.44	26478400.0
2021-06-30	ABG	Stock	163.06	172.04	162.38	171.37	316400.0
2021-06-30	ABGI-DELISTED	Stock	9.79	9.9	9.79	9.8	30848.0
2021-06-30	ABM	Stock	43.89	44.48	43.85	44.35	619500.0
2021-06-30	ABMD-DELISTED	Stock	314.37	319.36	309.92	312.36	164980.0
2021-06-30	ABNB	Stock	145.545	154.09	144.245	153.14	9798600.0
2021-06-30	ABR	Stock	18.02	18.07	17.81	17.82	1279600.0
2021-06-30	ABR.D	Stock	25.43	25.48	25.28	25.39	1214710.0
2021-06-30	ABST-DELISTED	Stock	14.41	14.5	14.32	14.48	54881.0
2021-06-30	ABT	Stock	117.0	117.18	115.25	115.93	5844600.0

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

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