PREVIEW / stock_daily / 2020-06-15

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-15.parquet
  size:    219 KB
  rows:    6,667
  symbols: 2,366

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
2020-06-15	AAPL	Stock	83.3125	86.42	83.145	85.7475	138808800.0
2020-06-15	MSFT	Stock	184.58	190.82	184.01	188.94	32770200.0
2020-06-15	NVDA	Stock	8.8152	9.1823	8.7438	9.1738	400004000.0
2020-06-15	AMZN	Stock	126.33	129.2	125.4	128.634	77302000.0
2020-06-15	GOOGL	Stock	69.4745	71.25	69.3598	71.037	30553040.0
2020-06-15	META	Stock	225.09	233.77	224.8	232.5	15340300.0
2020-06-15	TSLA	Stock	61.186	66.5893	60.5667	66.06	235458000.0
2020-06-15	TLT	Stock	163.89	164.22	162.14	162.39	7760836.0
2020-06-15	ES	Stock	83.0	85.54	82.29	84.26	1895400.0
2020-06-15	CL	Stock	72.36	73.26	71.74	72.89	3350500.0
2020-06-15	A	Stock	84.4	87.28	83.71	86.96	1551400.0
2020-06-15	AA	Stock	10.9	11.53	10.68	11.41	6956200.0
2020-06-15	AACG	Stock	1.14	1.36	1.14	1.29	159200.0
2020-06-15	AAIC-DELISTED	Stock	2.83	3.11	2.81	3.04	338274.0
2020-06-15	AAIC.C-DELISTED	Stock	20.0	20.27	19.649	20.27	5386.0
2020-06-15	AAL	Stock	15.27	17.17	15.08	16.7	122904100.0
2020-06-15	AAM.A-DELISTED	Stock	25.87	26.07	25.75	25.93	28374.0
2020-06-15	AAM.B-DELISTED	Stock	25.88	25.905	25.53	25.89	27372.0
2020-06-15	AAMC-DELISTED	Stock	4.4118	4.7412	4.2941	4.7294	16419.0
2020-06-15	AAME	Stock	1.83	1.88	1.83	1.88	700.0
2020-06-15	AAMI	Stock	9.98	10.77	9.75	10.6	4094100.0
2020-06-15	AAOI	Stock	8.56	9.25	8.56	9.03	367400.0
2020-06-15	AAON	Stock	33.58	35.62	33.2667	35.14	290250.0
2020-06-15	AAP	Stock	131.16	139.39	130.33	137.85	1074000.0
2020-06-15	AAT	Stock	28.48	30.49	28.48	30.11	368300.0
2020-06-15	AAU-DELISTED	Stock	0.52	0.528	0.49	0.4991	350860.0
2020-06-15	AAUAF-DELISTED	Stock	0.52	0.528	0.49	0.4991	382136.0
2020-06-15	AAWW-DELISTED	Stock	38.25	41.02	38.02	40.9	351724.0
2020-06-15	AAXJ	Stock	66.54	67.75	66.24	67.46	1004395.0
2020-06-15	AAXN-DELISTED	Stock	91.8	100.41	91.55	100.35	1028169.0
2020-06-15	AB	Stock	24.72	26.25	24.41	25.84	266000.0
2020-06-15	ABB-DELISTED	Stock	20.67	21.215	20.58	21.1	2692119.0
2020-06-15	ABBNY-DELISTED	Stock	20.67	21.215	20.58	21.09	2809116.0
2020-06-15	ABBV	Stock	91.27	94.03	90.78	93.08	7120200.0
2020-06-15	ABC-DELISTED	Stock	93.44	96.51	92.9	96.16	885044.0
2020-06-15	ABCB	Stock	22.6	24.42	22.43	24.14	380800.0
2020-06-15	ABEO	Stock	72.0	80.0	71.0	78.25	47236.0
2020-06-15	ABEV	Stock	2.57	2.65	2.52	2.61	28675400.0
2020-06-15	ABG	Stock	72.57	78.3	72.57	78.05	150000.0
2020-06-15	ABM	Stock	30.68	32.61	30.41	32.43	308500.0
2020-06-15	ABMD-DELISTED	Stock	239.96	246.94	236.35	246.33	220904.0
2020-06-15	ABR	Stock	9.29	9.8	9.21	9.64	2775900.0
2020-06-15	ABR.A-DELISTED	Stock	23.75	25.21	23.75	25.21	250.0
2020-06-15	ABR.B-DELISTED	Stock	22.96	23.29	22.95	23.29	2600.0
2020-06-15	ABR.C-DELISTED	Stock	24.2	24.615	23.7946	24.615	4298.0
2020-06-15	ABT	Stock	87.52	90.35	87.05	89.55	5666000.0
2020-06-15	ABTC	Stock	301200.0	336600.0	301200.0	331800.0	5.933333333333334
2020-06-15	ABTS	Stock	15.75	16.425	13.5	14.415	14187.0
2020-06-15	ABTX-DELISTED	Stock	23.92	26.05	23.92	25.81	46773.0
2020-06-15	ABUS	Stock	1.69	1.95	1.67	1.84	993000.0

> showing 50 of 6,667 rows — these rows as CSV

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