PREVIEW / stock_daily / 2020-01-28

all stock daily files

  file:    by_date/stock_daily/2020/2020-01-28.parquet
  size:    221 KB
  rows:    6,543
  symbols: 2,385

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-01-28	AAPL	Stock	78.15	79.6	78.0475	79.4225	162234000.0
2020-01-28	MSFT	Stock	163.78	165.76	163.07	165.46	24899900.0
2020-01-28	NVDA	Stock	6.0712	6.2318	6.0178	6.1992	310976000.0
2020-01-28	AMZN	Stock	92.025	92.9055	91.501	92.6625	56160000.0
2020-01-28	GOOGL	Stock	72.087	72.74	71.518	72.525	29731720.0
2020-01-28	META	Stock	216.14	218.74	213.52	217.79	13413800.0
2020-01-28	TSLA	Stock	37.8993	38.454	37.2053	37.7933	176827500.0
2020-01-28	TLT	Stock	143.925	144.085	142.82	143.16	10612917.0
2020-01-28	ES	Stock	91.52	92.08	91.08	91.79	1743600.0
2020-01-28	CL	Stock	70.12	70.49	69.56	69.71	2770600.0
2020-01-28	A	Stock	86.85	87.48	86.19	87.18	1652200.0
2020-01-28	AA	Stock	15.1	15.25	14.65	14.71	7371900.0
2020-01-28	AACG	Stock	1.33	1.34	1.21	1.26	33300.0
2020-01-28	AAIC-DELISTED	Stock	5.76	5.79	5.74	5.77	264639.0
2020-01-28	AAIC.C-DELISTED	Stock	22.125	22.4	22.125	22.3	6420.0
2020-01-28	AAL	Stock	26.36	27.12	26.26	26.9	11939200.0
2020-01-28	AAM.A-DELISTED	Stock	26.9	26.94	26.78	26.86	26511.0
2020-01-28	AAM.B-DELISTED	Stock	27.14	27.32	27.14	27.25	14072.0
2020-01-28	AAMC-DELISTED	Stock	3.9118	3.9235	3.9118	3.9235	2298.0
2020-01-28	AAME	Stock	1.81	2.0	1.81	1.95	4700.0
2020-01-28	AAMI	Stock	9.26	9.39	9.22	9.27	349500.0
2020-01-28	AAOI	Stock	13.35	13.38	12.91	12.94	602600.0
2020-01-28	AAON	Stock	35.78	35.8733	35.54	35.7933	149250.0
2020-01-28	AAP	Stock	139.78	140.24	137.37	138.58	924000.0
2020-01-28	AAT	Stock	47.73	47.94	47.27	47.34	147800.0
2020-01-28	AAU-DELISTED	Stock	0.51	0.5149	0.5	0.501	151268.0
2020-01-28	AAUAF-DELISTED	Stock	0.51	0.5149	0.5	0.5053	156796.0
2020-01-28	AAWW-DELISTED	Stock	24.04	24.05	23.52	23.68	175010.0
2020-01-28	AAXJ	Stock	70.84	71.31	70.53	71.1	1202675.0
2020-01-28	AAXN-DELISTED	Stock	78.31	80.14	77.79	78.96	412750.0
2020-01-28	AB	Stock	33.59	33.73	33.47	33.72	269600.0
2020-01-28	ABB-DELISTED	Stock	23.05	23.37	23.04	23.35	2625633.0
2020-01-28	ABBNY-DELISTED	Stock	23.05	23.37	23.04	23.34	2756797.0
2020-01-28	ABBV	Stock	84.99	84.99	83.64	83.77	8614400.0
2020-01-28	ABC-DELISTED	Stock	88.29	89.7	87.8317	89.1	927451.0
2020-01-28	ABCB	Stock	40.85	41.34	40.5	41.14	330000.0
2020-01-28	ABDC-DELISTED	Stock	9.45	9.45	9.27	9.29	15691.0
2020-01-28	ABEO	Stock	60.25	62.75	59.75	61.5	34876.0
2020-01-28	ABEV	Stock	4.39	4.49	4.37	4.48	12770900.0
2020-01-28	ABG	Stock	100.46	101.41	99.67	100.29	99300.0
2020-01-28	ABM	Stock	39.22	39.65	39.1	39.12	192100.0
2020-01-28	ABMD-DELISTED	Stock	182.26	187.12	181.61	187.01	433363.0
2020-01-28	ABR	Stock	14.62	14.83	14.61	14.78	486400.0
2020-01-28	ABR.A-DELISTED	Stock	26.4465	26.4465	26.4245	26.4245	970.0
2020-01-28	ABR.C-DELISTED	Stock	26.6	26.6	26.6	26.6	1209.0
2020-01-28	ABT	Stock	89.7	90.03	89.39	89.54	4983700.0
2020-01-28	ABTC	Stock	258000.0	263700.0	247800.0	258000.0	2.453333333333333
2020-01-28	ABTX-DELISTED	Stock	36.63	37.1	36.6	36.655	52713.0
2020-01-28	ABUS	Stock	2.98	2.98	2.68	2.76	331600.0
2020-01-28	ACA	Stock	44.95	45.49	44.645	45.15	324427.0

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

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