PREVIEW / stock_daily / 2021-05-06

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-06.parquet
  size:    255 KB
  rows:    7,808
  symbols: 2,949

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-05-06	AAPL	Stock	127.89	129.75	127.13	129.74	78128300.0
2021-05-06	MSFT	Stock	246.45	249.86	244.69	249.73	26491100.0
2021-05-06	NVDA	Stock	14.4952	14.5712	14.218	14.523	193380000.0
2021-05-06	AMZN	Stock	163.5	165.72	162.36	165.3185	88954000.0
2021-05-06	GOOGL	Stock	115.3165	116.8675	114.6521	116.8675	25190460.0
2021-05-06	META	Stock	314.52	320.24	313.27	320.02	19012200.0
2021-05-06	TSLA	Stock	226.92	227.0067	216.6667	221.18	83353800.0
2021-05-06	TLT	Stock	139.25	140.19	139.2003	139.92	21907928.0
2021-05-06	ES	Stock	83.97	84.43	83.26	84.33	1378100.0
2021-05-06	CL	Stock	81.63	82.4	81.37	82.31	3850100.0
2021-05-06	A	Stock	132.31	132.6	130.77	132.4	1150400.0
2021-05-06	AA	Stock	40.89	41.44	39.28	39.89	7164000.0
2021-05-06	AAC-DELISTED	Stock	9.82	9.86	9.8	9.85	328248.0
2021-05-06	AACG	Stock	3.0	3.02	2.82	2.86	61400.0
2021-05-06	AACQ-DELISTED	Stock	10.05	10.1	9.88	9.93	1036222.0
2021-05-06	AACQU-DELISTED	Stock	10.71	10.72	10.5	10.5	9244.0
2021-05-06	AACQW-DELISTED	Stock	1.96	1.99	1.63	1.75	311985.0
2021-05-06	AAIC-DELISTED	Stock	3.86	4.12	3.82	4.07	453115.0
2021-05-06	AAIC.C-DELISTED	Stock	24.5	24.5	24.32	24.375	3397.0
2021-05-06	AAL	Stock	21.51	21.75	21.16	21.49	25632600.0
2021-05-06	AAM.A-DELISTED	Stock	26.15	26.15	25.95	26.05	14837.0
2021-05-06	AAM.B-DELISTED	Stock	27.04	27.04	26.77	26.87	15503.0
2021-05-06	AAMC-DELISTED	Stock	4.9706	5.2946	4.9559	5.2946	42048.0
2021-05-06	AAME	Stock	4.08	4.1	3.91	4.0	208600.0
2021-05-06	AAMI	Stock	22.6	23.1	22.55	23.09	259700.0
2021-05-06	AAN-DELISTED	Stock	31.22	32.6	31.1	31.84	467200.0
2021-05-06	AAOI	Stock	7.0	7.24	6.75	7.22	989600.0
2021-05-06	AAON	Stock	42.2133	43.3	42.0	42.68	271200.0
2021-05-06	AAP	Stock	204.19	204.88	202.07	204.16	513700.0
2021-05-06	AAT	Stock	34.39	35.07	34.1	34.86	312100.0
2021-05-06	AAU-DELISTED	Stock	0.55	0.557	0.54	0.542	744251.0
2021-05-06	AAUAF-DELISTED	Stock	0.55	0.557	0.54	0.5418	778559.0
2021-05-06	AAWW-DELISTED	Stock	71.63	71.72	68.92	71.2201	456875.0
2021-05-06	AAXJ	Stock	92.94	93.419	92.71	93.39	1635249.0
2021-05-06	AB	Stock	45.85	46.92	44.71	46.3	757900.0
2021-05-06	ABB-DELISTED	Stock	33.62	33.78	33.43	33.77	1123961.0
2021-05-06	ABBNY-DELISTED	Stock	33.62	33.78	33.43	33.77	1219821.0
2021-05-06	ABBV	Stock	115.0	116.18	114.16	116.08	5803800.0
2021-05-06	ABC-DELISTED	Stock	117.4	118.18	114.0654	117.63	1242231.0
2021-05-06	ABCB	Stock	56.37	57.14	55.87	57.0	289200.0
2021-05-06	ABCL	Stock	28.502	29.01	27.55	28.7	850500.0
2021-05-06	ABCM-DELISTED	Stock	20.61	20.88	20.54	20.78	462688.0
2021-05-06	ABEO	Stock	40.25	40.5	37.0	38.0	80936.0
2021-05-06	ABEV	Stock	3.06	3.12	2.98	3.12	66787700.0
2021-05-06	ABG	Stock	206.58	209.34	203.46	209.17	91900.0
2021-05-06	ABGI-DELISTED	Stock	9.8599	9.97	9.8599	9.97	1450.0
2021-05-06	ABM	Stock	52.46	52.74	51.7	52.28	352400.0
2021-05-06	ABMD-DELISTED	Stock	300.88	301.28	288.01	295.73	351179.0
2021-05-06	ABNB	Stock	161.91	162.105	150.7	153.64	8529000.0
2021-05-06	ABR	Stock	17.75	17.8	17.15	17.25	2227900.0

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

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