PREVIEW / stock_daily / 2020-04-27

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-27.parquet
  size:    216 KB
  rows:    6,602
  symbols: 2,354

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-04-27	AAPL	Stock	70.45	71.135	69.9875	70.7925	117087600.0
2020-04-27	MSFT	Stock	176.59	176.9	173.3	174.05	33194400.0
2020-04-27	NVDA	Stock	7.3748	7.5875	7.35	7.427	479388000.0
2020-04-27	AMZN	Stock	122.16	122.244	118.15	118.8	112912000.0
2020-04-27	GOOGL	Stock	64.6	64.705	63.253	63.543	44186660.0
2020-04-27	META	Stock	192.66	193.75	187.41	187.5	29197800.0
2020-04-27	TSLA	Stock	49.174	53.2993	49.0	53.25	310221000.0
2020-04-27	TLT	Stock	169.66	169.75	167.44	167.66	9039484.0
2020-04-27	ES	Stock	87.01	87.38	85.34	85.57	1770500.0
2020-04-27	CL	Stock	71.92	71.95	70.89	71.03	2926700.0
2020-04-27	A	Stock	76.35	76.62	75.84	76.25	1295800.0
2020-04-27	AA	Stock	7.21	7.49	6.99	7.37	9549400.0
2020-04-27	AACG	Stock	0.75	0.79	0.61	0.67	62800.0
2020-04-27	AAIC-DELISTED	Stock	2.62	2.76	2.58	2.72	354967.0
2020-04-27	AAIC.C-DELISTED	Stock	16.81	17.19	16.81	17.0	1290.0
2020-04-27	AAL	Stock	10.53	10.53	10.0	10.02	67378800.0
2020-04-27	AAM.A-DELISTED	Stock	25.5	25.65	25.3606	25.6056	15350.0
2020-04-27	AAM.B-DELISTED	Stock	25.68	25.68	25.1	25.52	11716.0
2020-04-27	AAMC-DELISTED	Stock	3.9931	3.9931	3.9931	3.9931	544.0
2020-04-27	AAME	Stock	1.6	1.74	1.6	1.63	4200.0
2020-04-27	AAMI	Stock	6.95	7.31	6.75	7.15	784800.0
2020-04-27	AAOI	Stock	9.12	9.89	9.12	9.77	703500.0
2020-04-27	AAON	Stock	31.5933	32.62	31.5933	32.0333	416850.0
2020-04-27	AAP	Stock	118.49	121.09	117.47	118.95	774400.0
2020-04-27	AAT	Stock	26.21	27.88	26.04	27.59	224800.0
2020-04-27	AAU-DELISTED	Stock	0.4129	0.43	0.38	0.4226	507102.0
2020-04-27	AAUAF-DELISTED	Stock	0.4129	0.43	0.38	0.43	519983.0
2020-04-27	AAWW-DELISTED	Stock	29.94	32.44	29.88	31.39	1101177.0
2020-04-27	AAXJ	Stock	63.49	63.91	63.3197	63.86	607689.0
2020-04-27	AAXN-DELISTED	Stock	72.5	73.91	71.67	72.15	470169.0
2020-04-27	AB	Stock	20.0	21.07	20.0	21.05	403300.0
2020-04-27	ABB-DELISTED	Stock	17.61	18.07	17.5205	17.93	2095055.0
2020-04-27	ABBNY-DELISTED	Stock	17.61	18.07	17.5205	17.92	2240163.0
2020-04-27	ABBV	Stock	84.03	84.92	83.78	84.69	9209700.0
2020-04-27	ABC-DELISTED	Stock	89.59	91.35	88.76	90.72	1203670.0
2020-04-27	ABCB	Stock	22.78	24.99	22.38	24.61	352800.0
2020-04-27	ABEO	Stock	62.5	65.0	62.5	63.25	43744.0
2020-04-27	ABEV	Stock	2.06	2.12	2.04	2.08	28343200.0
2020-04-27	ABG	Stock	59.26	61.23	58.85	60.63	269600.0
2020-04-27	ABM	Stock	31.91	33.54	31.77	33.04	337500.0
2020-04-27	ABMD-DELISTED	Stock	166.28	168.51	159.01	163.72	866548.0
2020-04-27	ABR	Stock	6.01	6.29	5.84	6.14	1869500.0
2020-04-27	ABR.A-DELISTED	Stock	21.9	21.9	20.5	21.85	5119.0
2020-04-27	ABR.B-DELISTED	Stock	19.91	19.95	19.3	19.83	10227.0
2020-04-27	ABR.C-DELISTED	Stock	21.53	22.5	21.02	21.8278	5812.0
2020-04-27	ABT	Stock	95.48	95.9	94.02	94.95	6838200.0
2020-04-27	ABTC	Stock	264000.0	276600.0	255600.0	270000.0	5.319999999999999
2020-04-27	ABTS	Stock	11.7	13.05	10.665	11.4	1287.0
2020-04-27	ABTX-DELISTED	Stock	23.23	24.67	22.72	24.37	60228.0
2020-04-27	ABUS	Stock	1.22	1.22	1.17	1.19	202700.0

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

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