PREVIEW / stock_daily / 2021-05-18

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-18.parquet
  size:    255 KB
  rows:    7,810
  symbols: 2,926

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-18	AAPL	Stock	126.56	126.99	124.78	124.85	63342900.0
2021-05-18	MSFT	Stock	246.27	246.41	242.9	243.08	20168000.0
2021-05-18	NVDA	Stock	14.267	14.4042	14.004	14.0158	186256000.0
2021-05-18	AMZN	Stock	164.629	165.6	161.5185	161.614	56568000.0
2021-05-18	GOOGL	Stock	115.1175	115.3841	113.1095	113.1235	22203700.0
2021-05-18	META	Stock	315.59	316.5	309.81	309.96	14522400.0
2021-05-18	TSLA	Stock	189.3333	198.75	187.7933	192.6233	110491800.0
2021-05-18	TLT	Stock	136.4	136.57	136.07	136.44	11423065.0
2021-05-18	ES	Stock	83.95	84.71	83.65	84.27	1369500.0
2021-05-18	CL	Stock	83.16	83.88	82.76	83.11	3024200.0
2021-05-18	A	Stock	129.95	129.95	128.68	128.75	1777600.0
2021-05-18	AA	Stock	41.11	41.69	39.58	39.84	5665200.0
2021-05-18	AAC-DELISTED	Stock	9.76	9.79	9.75	9.77	515766.0
2021-05-18	AACG	Stock	2.9	3.0	2.86	2.95	79400.0
2021-05-18	AACQ-DELISTED	Stock	9.89	9.89	9.85	9.87	485030.0
2021-05-18	AACQU-DELISTED	Stock	10.35	10.4764	10.35	10.4	3100.0
2021-05-18	AACQW-DELISTED	Stock	1.6	1.63	1.5	1.54	42424.0
2021-05-18	AAIC-DELISTED	Stock	4.01	4.1	4.0	4.02	138556.0
2021-05-18	AAIC.C-DELISTED	Stock	24.24	24.65	24.24	24.65	2388.0
2021-05-18	AAL	Stock	23.54	23.94	23.08	23.56	38662400.0
2021-05-18	AAM.A-DELISTED	Stock	26.24	26.35	26.24	26.35	7170.0
2021-05-18	AAM.B-DELISTED	Stock	27.15	27.15	27.07	27.15	2303.0
2021-05-18	AAMC-DELISTED	Stock	5.0	5.3324	5.0	5.1294	19462.0
2021-05-18	AAME	Stock	4.51	4.76	4.4	4.51	113400.0
2021-05-18	AAMI	Stock	23.0	23.32	22.89	22.9	334800.0
2021-05-18	AAN-DELISTED	Stock	33.01	33.5	32.41	32.47	192700.0
2021-05-18	AAOI	Stock	7.79	8.04	7.73	7.78	405700.0
2021-05-18	AAON	Stock	45.3333	46.0333	44.26	44.36	214350.0
2021-05-18	AAP	Stock	204.62	204.83	199.99	200.04	800800.0
2021-05-18	AAQC-DELISTED	Stock	9.7499	9.7499	9.7211	9.7211	658.0
2021-05-18	AAT	Stock	35.36	35.82	35.13	35.19	219400.0
2021-05-18	AAU-DELISTED	Stock	0.577	0.577	0.55	0.5542	952088.0
2021-05-18	AAUAF-DELISTED	Stock	0.577	0.577	0.55	0.5501	1012007.0
2021-05-18	AAWW-DELISTED	Stock	75.18	75.36	73.565	74.0885	199665.0
2021-05-18	AAXJ	Stock	91.8335	92.3985	91.79	91.86	764523.0
2021-05-18	AB	Stock	43.61	44.13	43.52	43.52	255100.0
2021-05-18	ABB-DELISTED	Stock	34.16	34.17	33.83	33.84	1270877.0
2021-05-18	ABBNY-DELISTED	Stock	34.16	34.17	33.83	33.84	2413212.0
2021-05-18	ABBV	Stock	116.11	117.9	115.32	117.21	8174900.0
2021-05-18	ABC-DELISTED	Stock	117.41	118.235	115.28	116.99	943086.0
2021-05-18	ABCB	Stock	56.44	57.37	56.06	56.25	556900.0
2021-05-18	ABCL	Stock	33.87	34.0	32.6	32.99	659600.0
2021-05-18	ABCM-DELISTED	Stock	19.93	21.11	19.82	20.595	271918.0
2021-05-18	ABEO	Stock	33.75	40.25	33.75	39.0	80056.0
2021-05-18	ABEV	Stock	3.34	3.38	3.31	3.33	19918800.0
2021-05-18	ABG	Stock	205.9	207.65	201.51	201.75	119300.0
2021-05-18	ABGI-DELISTED	Stock	9.93	9.94	9.93	9.94	809.0
2021-05-18	ABM	Stock	52.61	52.7	51.22	51.31	257100.0
2021-05-18	ABMD-DELISTED	Stock	266.72	277.47	265.41	272.96	251472.0
2021-05-18	ABNB	Stock	134.0	138.4	131.49	135.02	18555600.0

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

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