PREVIEW / stock_daily / 2019-03-07

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-07.parquet
  size:    220 KB
  rows:    6,525
  symbols: 2,610

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
2019-03-07	AAPL	Stock	43.4675	43.61	43.005	43.125	99185600.0
2019-03-07	MSFT	Stock	111.4	111.55	109.87	110.39	25339000.0
2019-03-07	NVDA	Stock	3.7775	3.7872	3.685	3.7315	450104000.0
2019-03-07	AMZN	Stock	83.3685	83.4875	81.0255	81.2975	99140000.0
2019-03-07	GOOGL	Stock	58.025	58.179	57.0858	57.5425	30086560.0
2019-03-07	META	Stock	171.5	171.74	167.61	169.13	18306500.0
2019-03-07	TSLA	Stock	18.5893	18.98	18.2833	18.4393	141637500.0
2019-03-07	TLT	Stock	120.64	121.26	120.61	121.06	8187227.0
2019-03-07	ES	Stock	69.37	69.81	69.09	69.39	2173700.0
2019-03-07	CL	Stock	65.24	65.74	64.78	65.34	4365700.0
2019-03-07	A	Stock	78.69	79.1	78.01	78.73	1818100.0
2019-03-07	AA	Stock	28.16	28.3	27.31	27.36	3102400.0
2019-03-07	AABA-DELISTED	Stock	74.16	74.21	72.18	72.52	7764970.0
2019-03-07	AAC-DELISTED	Stock	2.35	2.38	2.24	2.325	171384.0
2019-03-07	AACG	Stock	1.2	1.2	1.12	1.14	73800.0
2019-03-07	AAIC-DELISTED	Stock	8.16	8.195	8.02	8.03	434530.0
2019-03-07	AAL	Stock	32.7	32.7	31.62	32.22	7112400.0
2019-03-07	AAM.A-DELISTED	Stock	25.1136	25.14	25.07	25.1	14008.0
2019-03-07	AAM.B-DELISTED	Stock	24.84	24.85	24.71	24.72	21153.0
2019-03-07	AAMC-DELISTED	Stock	11.1118	11.1118	10.1853	10.3824	36618.0
2019-03-07	AAME	Stock	2.7	2.72	2.66	2.66	1500.0
2019-03-07	AAMI	Stock	13.92	13.94	13.6	13.62	326900.0
2019-03-07	AAOI	Stock	13.26	13.44	13.01	13.01	633300.0
2019-03-07	AAON	Stock	28.2267	28.3533	27.9067	27.96	143700.0
2019-03-07	AAP	Stock	157.09	157.31	154.01	154.13	940700.0
2019-03-07	AAT	Stock	44.92	45.44	44.68	44.75	287100.0
2019-03-07	AAU-DELISTED	Stock	0.61	0.6164	0.6	0.6101	311767.0
2019-03-07	AAUAF-DELISTED	Stock	0.61	0.6164	0.6	0.61	313731.0
2019-03-07	AAWW-DELISTED	Stock	49.83	50.27	48.64	49.01	186978.0
2019-03-07	AAXJ	Stock	69.59	69.6	68.68	68.78	1157728.0
2019-03-07	AAXN-DELISTED	Stock	49.82	50.075	48.2	48.45	468275.0
2019-03-07	AB	Stock	29.81	29.84	28.95	29.0	406100.0
2019-03-07	ABB-DELISTED	Stock	19.06	19.08	18.87	18.93	2479939.0
2019-03-07	ABBNY-DELISTED	Stock	19.05	19.08	18.87	18.93	2558208.0
2019-03-07	ABBV	Stock	77.77	79.12	77.44	78.24	6642500.0
2019-03-07	ABC-DELISTED	Stock	77.02	77.51	76.02	76.31	1917623.0
2019-03-07	ABCB	Stock	39.21	39.5	38.09	38.14	416300.0
2019-03-07	ABDC-DELISTED	Stock	7.24	7.36	7.17	7.29	21102.0
2019-03-07	ABEO	Stock	175.75	183.5	175.0	181.0	10484.0
2019-03-07	ABEV	Stock	4.27	4.32	4.21	4.26	24049100.0
2019-03-07	ABG	Stock	66.99	67.59	65.54	66.39	164800.0
2019-03-07	ABIL-DELISTED	Stock	1.81	2.12	1.8	2.015	840800.0
2019-03-07	ABM	Stock	36.37	36.37	31.81	33.57	1694400.0
2019-03-07	ABMD-DELISTED	Stock	317.85	320.39	311.4	317.45	300462.0
2019-03-07	ABR	Stock	12.83	12.85	12.68	12.71	859900.0
2019-03-07	ABR.A-DELISTED	Stock	25.35	25.6782	25.35	25.6782	6905.0
2019-03-07	ABR.B-DELISTED	Stock	25.4	25.5271	25.3245	25.5271	1475.0
2019-03-07	ABR.C-DELISTED	Stock	25.68	25.89	25.5371	25.75	5874.0
2019-03-07	ABT	Stock	77.69	77.95	76.61	76.8	5292600.0
2019-03-07	ABTC	Stock	303450.0	305100.0	302400.0	304200.0	4.666666666666667

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

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