PREVIEW / stock_daily / 2020-06-12

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-12.parquet
  size:    221 KB
  rows:    6,669
  symbols: 2,379

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-12	AAPL	Stock	86.18	86.95	83.555	84.7	200146000.0
2020-06-12	MSFT	Stock	190.54	191.72	185.18	187.74	43373600.0
2020-06-12	NVDA	Stock	9.1625	9.1872	8.7032	8.9325	570908000.0
2020-06-12	AMZN	Stock	130.0605	131.074	125.1675	127.251	108722000.0
2020-06-12	GOOGL	Stock	71.293	71.7252	69.29	70.646	36675120.0
2020-06-12	META	Stock	229.9	231.66	224.5	228.58	22091400.0
2020-06-12	TSLA	Stock	65.3333	65.8653	60.84	62.352	251451000.0
2020-06-12	TLT	Stock	162.41	163.66	162.05	162.3	9716433.0
2020-06-12	ES	Stock	85.55	86.17	83.19	84.31	2108300.0
2020-06-12	CL	Stock	73.59	73.76	72.36	72.79	4357600.0
2020-06-12	A	Stock	86.83	87.3	83.99	86.11	1520000.0
2020-06-12	AA	Stock	11.2	11.62	11.045	11.53	10185600.0
2020-06-12	AACG	Stock	1.2	1.23	1.01	1.14	64200.0
2020-06-12	AAIC-DELISTED	Stock	3.03	3.03	2.82	2.99	452393.0
2020-06-12	AAIC.C-DELISTED	Stock	19.28	20.45	19.28	20.45	3333.0
2020-06-12	AAL	Stock	16.82	17.31	15.67	16.74	161101800.0
2020-06-12	AAM.A-DELISTED	Stock	25.92	26.16	25.75	25.91	35763.0
2020-06-12	AAM.B-DELISTED	Stock	25.73	26.1699	25.73	25.92	11267.0
2020-06-12	AAMC-DELISTED	Stock	4.7191	4.7191	4.2941	4.6029	38355.0
2020-06-12	AAME	Stock	1.88	1.88	1.85	1.88	600.0
2020-06-12	AAMI	Stock	9.56	9.56	8.88	9.12	500200.0
2020-06-12	AAOI	Stock	9.02	9.27	8.57	8.81	481500.0
2020-06-12	AAON	Stock	35.9333	35.9333	34.06	34.64	258600.0
2020-06-12	AAP	Stock	137.05	137.29	131.31	135.73	682700.0
2020-06-12	AAT	Stock	29.83	30.29	28.86	29.95	504800.0
2020-06-12	AAU-DELISTED	Stock	0.5	0.527	0.4958	0.5199	262752.0
2020-06-12	AAUAF-DELISTED	Stock	0.5	0.527	0.4958	0.5199	268890.0
2020-06-12	AAWW-DELISTED	Stock	40.06	40.625	38.44	39.37	406227.0
2020-06-12	AAXJ	Stock	68.57	68.67	67.4	68.26	1678000.0
2020-06-12	AAXN-DELISTED	Stock	96.21	97.6	91.63	94.11	833165.0
2020-06-12	AB	Stock	25.06	25.7	24.89	25.41	322100.0
2020-06-12	ABB-DELISTED	Stock	21.22	21.27	20.505	20.86	1921500.0
2020-06-12	ABBNY-DELISTED	Stock	21.22	21.27	20.505	20.87	2039531.0
2020-06-12	ABBV	Stock	93.74	94.74	91.03	92.46	8010100.0
2020-06-12	ABC-DELISTED	Stock	95.48	95.6409	92.62	94.85	1213891.0
2020-06-12	ABCB	Stock	24.77	24.8	22.97	24.04	463900.0
2020-06-12	ABEO	Stock	68.5	74.0	68.25	73.5	57576.0
2020-06-12	ABEV	Stock	2.71	2.75	2.61	2.71	44167900.0
2020-06-12	ABG	Stock	77.9	78.32	73.8	76.07	403900.0
2020-06-12	ABM	Stock	32.76	33.09	30.83	31.62	421400.0
2020-06-12	ABMD-DELISTED	Stock	239.77	247.74	235.12	241.27	239978.0
2020-06-12	ABR	Stock	9.6	9.91	9.37	9.86	2297800.0
2020-06-12	ABR.A-DELISTED	Stock	23.05	24.44	23.05	24.0	17235.0
2020-06-12	ABR.B-DELISTED	Stock	22.55	23.1773	22.55	23.1773	13610.0
2020-06-12	ABR.C-DELISTED	Stock	24.455	25.325	23.08	24.3	11593.0
2020-06-12	ABT	Stock	89.25	90.19	87.59	89.02	5590400.0
2020-06-12	ABTC	Stock	307800.0	330000.0	302100.0	319800.0	4.293333333333334
2020-06-12	ABTS	Stock	19.35	19.5	15.75	16.5	9453.0
2020-06-12	ABTX-DELISTED	Stock	25.85	25.89	24.07	25.02	51220.0
2020-06-12	ABUS	Stock	1.67	1.76	1.66	1.73	576600.0

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

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