PREVIEW / stock_daily / 2021-03-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-03-08.parquet
  size:    250 KB
  rows:    7,615
  symbols: 2,857

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-08	AAPL	Stock	120.93	121.0	116.21	116.36	154376600.0
2021-03-08	MSFT	Stock	231.37	233.37	227.13	227.39	35267400.0
2021-03-08	NVDA	Stock	12.45	12.4713	11.5665	11.5933	543112000.0
2021-03-08	AMZN	Stock	150.75	153.2295	147.5655	147.5975	83700000.0
2021-03-08	GOOGL	Stock	104.203	105.687	100.2595	100.375	36867420.0
2021-03-08	META	Stock	265.55	265.58	255.05	255.31	18391800.0
2021-03-08	TSLA	Stock	200.1833	206.71	186.2633	187.6667	155361000.0
2021-03-08	TLT	Stock	138.83	138.9	137.83	137.83	15236619.0
2021-03-08	ES	Stock	80.5	81.81	79.35	80.62	1182600.0
2021-03-08	CL	Stock	75.76	77.26	75.38	76.45	4676200.0
2021-03-08	A	Stock	116.31	118.96	115.27	116.08	2766600.0
2021-03-08	AA	Stock	29.65	30.17	28.4	28.47	4985700.0
2021-03-08	AACG	Stock	4.19	4.55	3.9	4.01	382900.0
2021-03-08	AACQ-DELISTED	Stock	10.75	10.88	10.46	10.71	3807638.0
2021-03-08	AACQU-DELISTED	Stock	11.03	11.6699	11.03	11.24	519075.0
2021-03-08	AACQW-DELISTED	Stock	1.88	2.1	1.88	2.01	361876.0
2021-03-08	AAIC-DELISTED	Stock	4.15	4.39	4.14	4.36	319356.0
2021-03-08	AAIC.C-DELISTED	Stock	21.84	21.96	21.84	21.96	1202.0
2021-03-08	AAL	Stock	20.78	21.71	20.65	21.47	39776900.0
2021-03-08	AAM.A-DELISTED	Stock	25.84	25.89	25.8	25.86	46990.0
2021-03-08	AAM.B-DELISTED	Stock	26.27	26.499	26.27	26.45	14985.0
2021-03-08	AAMC-DELISTED	Stock	6.4912	6.5265	6.0206	6.1941	57249.0
2021-03-08	AAME	Stock	3.69	3.88	3.48	3.55	98000.0
2021-03-08	AAMI	Stock	19.41	19.77	19.05	19.2	356600.0
2021-03-08	AAN-DELISTED	Stock	24.0	25.129	24.0	24.76	341000.0
2021-03-08	AAOI	Stock	8.06	8.23	7.75	7.76	636800.0
2021-03-08	AAON	Stock	48.9333	49.6733	48.7533	48.7667	349350.0
2021-03-08	AAP	Stock	172.52	177.7	171.95	176.5	1330700.0
2021-03-08	AAT	Stock	34.71	36.31	34.52	36.28	696100.0
2021-03-08	AAU-DELISTED	Stock	0.65	0.66	0.61	0.6479	1255927.0
2021-03-08	AAUAF-DELISTED	Stock	0.65	0.66	0.61	0.6483	1305197.0
2021-03-08	AAWW-DELISTED	Stock	57.79	59.62	56.48	57.31	493300.0
2021-03-08	AAXJ	Stock	92.72	92.7999	91.59	91.61	1053101.0
2021-03-08	AB	Stock	37.8	38.15	37.48	37.72	525700.0
2021-03-08	ABB-DELISTED	Stock	29.93	30.37	29.87	30.0	1943511.0
2021-03-08	ABBNY-DELISTED	Stock	29.93	30.37	29.87	30.0	2058896.0
2021-03-08	ABBV	Stock	106.85	108.16	105.8	106.11	6049400.0
2021-03-08	ABC-DELISTED	Stock	105.59	109.16	105.565	107.5	887798.0
2021-03-08	ABCB	Stock	51.63	53.0	50.62	51.65	560000.0
2021-03-08	ABCL	Stock	31.19	31.468	26.375	26.76	930300.0
2021-03-08	ABCM-DELISTED	Stock	19.62	20.065	19.51	19.7	173188.0
2021-03-08	ABEO	Stock	51.0	53.5	49.75	52.5	83612.0
2021-03-08	ABEV	Stock	2.66	2.71	2.55	2.56	40346200.0
2021-03-08	ABG	Stock	174.88	180.67	169.13	180.06	380900.0
2021-03-08	ABGI-DELISTED	Stock	10.0	10.15	10.0	10.07	257438.0
2021-03-08	ABM	Stock	46.68	48.39	46.67	47.78	211900.0
2021-03-08	ABMD-DELISTED	Stock	299.05	305.415	285.33	285.87	209264.0
2021-03-08	ABNB	Stock	179.992	186.4	177.03	180.81	4988500.0
2021-03-08	ABR	Stock	15.71	16.28	15.7	15.87	1334700.0
2021-03-08	ABR.A-DELISTED	Stock	25.68	25.985	25.54	25.54	5255.0

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

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