PREVIEW / stock_daily / 2021-06-28

all stock daily files

  file:    by_date/stock_daily/2021/2021-06-28.parquet
  size:    260 KB
  rows:    7,940
  symbols: 2,937

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-28	AAPL	Stock	133.41	135.25	133.35	134.78	62111300.0
2021-06-28	MSFT	Stock	266.19	268.9	265.91	268.72	19590000.0
2021-06-28	NVDA	Stock	19.3613	20.0788	19.319	19.985	495436000.0
2021-06-28	AMZN	Stock	170.8	172.4	170.6755	172.1945	44856000.0
2021-06-28	GOOGL	Stock	122.6785	122.7848	121.4055	122.536	28525420.0
2021-06-28	META	Stock	342.46	358.14	341.77	355.64	29156100.0
2021-06-28	TSLA	Stock	223.88	231.5667	223.44	229.5733	64884600.0
2021-06-28	TLT	Stock	142.72	143.8	142.7	143.47	11460926.0
2021-06-28	ES	Stock	80.5	81.81	80.5	81.46	1490300.0
2021-06-28	CL	Stock	81.6	82.3	81.52	81.72	2735300.0
2021-06-28	A	Stock	147.63	148.04	146.43	147.93	1645000.0
2021-06-28	AA	Stock	36.17	36.61	35.67	36.09	8758200.0
2021-06-28	AAC-DELISTED	Stock	9.84	9.86	9.74	9.8	757405.0
2021-06-28	AACG	Stock	3.05	3.09	2.91	2.95	27900.0
2021-06-28	AAIC-DELISTED	Stock	4.04	4.18	4.03	4.17	423261.0
2021-06-28	AAIC.C-DELISTED	Stock	25.06	25.14	24.895	25.14	5412.0
2021-06-28	AAL	Stock	22.09	22.09	21.14	21.39	48437800.0
2021-06-28	AAM.A-DELISTED	Stock	26.15	26.25	26.045	26.14	59887.0
2021-06-28	AAM.B-DELISTED	Stock	27.115	27.115	26.92	26.92	13218.0
2021-06-28	AAMC-DELISTED	Stock	5.6912	5.7751	5.6912	5.7751	2601.0
2021-06-28	AAME	Stock	4.34	4.34	4.18	4.29	20400.0
2021-06-28	AAMI	Stock	23.9	23.9	23.58	23.62	285600.0
2021-06-28	AAN-DELISTED	Stock	32.79	34.37	32.6	33.99	427700.0
2021-06-28	AAOI	Stock	8.87	9.25	8.84	8.86	762100.0
2021-06-28	AAON	Stock	40.8467	41.1733	40.22	40.9467	351300.0
2021-06-28	AAP	Stock	204.07	204.59	202.25	204.51	548000.0
2021-06-28	AAQC-DELISTED	Stock	9.72	9.72	9.68	9.71	69823.0
2021-06-28	AAT	Stock	37.5	37.5	36.34	36.95	283500.0
2021-06-28	AAU-DELISTED	Stock	0.5	0.5024	0.491	0.4979	728021.0
2021-06-28	AAUAF-DELISTED	Stock	0.5	0.5024	0.491	0.498	769273.0
2021-06-28	AAWW-DELISTED	Stock	68.01	68.9199	66.2	67.25	395733.0
2021-06-28	AAXJ	Stock	94.92	95.16	94.862	95.13	759129.0
2021-06-28	AB	Stock	45.96	46.7	45.23	46.69	195400.0
2021-06-28	ABB-DELISTED	Stock	34.46	34.51	34.31	34.46	1133750.0
2021-06-28	ABBNY-DELISTED	Stock	34.46	34.51	34.31	34.46	1214429.0
2021-06-28	ABBV	Stock	113.26	114.11	112.84	113.0	5141800.0
2021-06-28	ABC-DELISTED	Stock	116.27	116.27	114.26	114.74	665660.0
2021-06-28	ABCB	Stock	52.63	52.63	51.1	51.57	345000.0
2021-06-28	ABCL	Stock	20.54	20.833	20.05	20.19	2760800.0
2021-06-28	ABCM-DELISTED	Stock	19.67	19.8776	19.34	19.55	194148.0
2021-06-28	ABEO	Stock	43.25	43.5	41.75	42.25	41860.0
2021-06-28	ABEV	Stock	3.51	3.57	3.44	3.53	27948300.0
2021-06-28	ABG	Stock	168.61	169.19	164.73	166.14	233300.0
2021-06-28	ABGI-DELISTED	Stock	9.8	9.8695	9.75	9.85	24279.0
2021-06-28	ABM	Stock	44.97	44.97	44.01	44.58	350100.0
2021-06-28	ABMD-DELISTED	Stock	312.5	314.18	309.71	312.72	146801.0
2021-06-28	ABNB	Stock	148.615	150.93	147.08	149.94	6451000.0
2021-06-28	ABR	Stock	18.39	18.4	17.88	18.11	1351900.0
2021-06-28	ABR.D	Stock	25.49	25.49	25.4	25.42	81402.0
2021-06-28	ABST-DELISTED	Stock	14.45	14.52	14.36	14.49	84285.0

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

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