PREVIEW / stock_daily / 2020-05-27

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-27.parquet
  size:    218 KB
  rows:    6,600
  symbols: 2,340

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-05-27	AAPL	Stock	79.035	79.6775	78.2725	79.5275	112945200.0
2020-05-27	MSFT	Stock	180.2	181.99	176.6	181.81	39517100.0
2020-05-27	NVDA	Stock	8.625	8.6328	7.9968	8.5252	1175892000.0
2020-05-27	AMZN	Stock	120.2495	120.679	116.5	120.5195	101138000.0
2020-05-27	GOOGL	Stock	71.0	71.2672	69.73	71.014	31683700.0
2020-05-27	META	Stock	229.07	230.56	221.13	229.14	34697600.0
2020-05-27	TSLA	Stock	54.724	55.1807	52.3333	54.682	173242500.0
2020-05-27	TLT	Stock	162.785	163.91	162.59	163.03	8047360.0
2020-05-27	ES	Stock	79.06	79.06	75.91	77.47	1889400.0
2020-05-27	CL	Stock	69.68	70.66	69.44	70.59	3811400.0
2020-05-27	A	Stock	86.3	86.48	84.37	86.18	1917600.0
2020-05-27	AA	Stock	9.12	9.79	8.925	9.76	11370400.0
2020-05-27	AACG	Stock	0.89	0.93	0.89	0.9	10100.0
2020-05-27	AAIC-DELISTED	Stock	2.53	2.58	2.4	2.55	550017.0
2020-05-27	AAIC.C-DELISTED	Stock	17.0811	17.23	16.75	17.19	7050.0
2020-05-27	AAL	Stock	12.43	12.55	11.07	11.98	99314800.0
2020-05-27	AAM.A-DELISTED	Stock	26.3381	26.4	26.19	26.4	14386.0
2020-05-27	AAM.B-DELISTED	Stock	26.53	26.53	26.18	26.49	22644.0
2020-05-27	AAMC-DELISTED	Stock	4.9071	5.0709	4.8559	5.0709	5936.0
2020-05-27	AAME	Stock	1.95	1.95	1.95	1.95	500.0
2020-05-27	AAMI	Stock	8.95	9.05	8.7	8.81	668900.0
2020-05-27	AAOI	Stock	9.06	9.11	8.66	9.05	633100.0
2020-05-27	AAON	Stock	36.7267	37.6067	36.24	36.6533	429300.0
2020-05-27	AAP	Stock	137.5	141.78	136.31	141.71	815200.0
2020-05-27	AAT	Stock	28.01	28.52	27.21	28.09	339300.0
2020-05-27	AAU-DELISTED	Stock	0.43	0.4689	0.425	0.4493	292127.0
2020-05-27	AAUAF-DELISTED	Stock	0.43	0.49	0.425	0.49	313631.0
2020-05-27	AAWW-DELISTED	Stock	39.66	39.66	37.93	39.16	413087.0
2020-05-27	AAXJ	Stock	63.96	64.01	63.175	63.73	870264.0
2020-05-27	AAXN-DELISTED	Stock	76.79	76.79	71.21	75.71	491246.0
2020-05-27	AB	Stock	25.5	26.2	25.4	26.07	538200.0
2020-05-27	ABB-DELISTED	Stock	19.66	19.69	19.345	19.555	1590032.0
2020-05-27	ABBNY-DELISTED	Stock	19.66	19.69	19.345	19.56	1728163.0
2020-05-27	ABBV	Stock	90.54	91.0	88.56	89.98	12529500.0
2020-05-27	ABC-DELISTED	Stock	90.96	93.45	90.745	93.32	819196.0
2020-05-27	ABCB	Stock	25.39	26.89	24.91	26.73	800300.0
2020-05-27	ABEO	Stock	77.0	83.25	75.5	82.5	45892.0
2020-05-27	ABEV	Stock	2.5	2.59	2.42	2.59	50629800.0
2020-05-27	ABG	Stock	79.53	81.86	77.06	79.08	303600.0
2020-05-27	ABM	Stock	34.33	34.44	32.73	33.5	484300.0
2020-05-27	ABMD-DELISTED	Stock	210.0	210.0	200.46	207.52	251098.0
2020-05-27	ABR	Stock	8.69	8.95	8.15	8.51	2249800.0
2020-05-27	ABR.A-DELISTED	Stock	23.9055	24.12	23.9055	24.12	1922.0
2020-05-27	ABR.B-DELISTED	Stock	23.31	23.31	23.31	23.31	100.0
2020-05-27	ABR.C-DELISTED	Stock	24.45	24.6499	24.3385	24.424	4522.0
2020-05-27	ABT	Stock	89.28	90.78	88.17	90.76	5420600.0
2020-05-27	ABTC	Stock	310800.0	330000.0	302100.0	309900.0	4.546666666666667
2020-05-27	ABTS	Stock	10.5	10.5	8.865	9.195	3087.0
2020-05-27	ABTX-DELISTED	Stock	27.38	28.18	26.84	27.93	63904.0
2020-05-27	ABUS	Stock	2.18	2.29	2.01	2.22	1205100.0

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

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