PREVIEW / stock_daily / 2019-03-06

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-06.parquet
  size:    220 KB
  rows:    6,513
  symbols: 2,602

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-06	AAPL	Stock	43.6675	43.8725	43.485	43.63	83241600.0
2019-03-06	MSFT	Stock	111.87	112.66	111.43	111.75	17687000.0
2019-03-06	NVDA	Stock	3.904	3.9125	3.7985	3.8013	403524000.0
2019-03-06	AMZN	Stock	84.7985	84.8875	83.414	83.4475	79920000.0
2019-03-06	GOOGL	Stock	58.588	58.737	58.1525	58.247	23601040.0
2019-03-06	META	Stock	172.9	173.57	171.27	172.51	21531700.0
2019-03-06	TSLA	Stock	18.432	18.7673	18.2927	18.416	155032500.0
2019-03-06	TLT	Stock	119.92	120.52	119.89	120.28	7766707.0
2019-03-06	ES	Stock	68.77	69.22	68.4	69.07	1921100.0
2019-03-06	CL	Stock	65.72	65.91	65.12	65.61	2764200.0
2019-03-06	A	Stock	79.82	79.98	78.73	78.75	1750500.0
2019-03-06	AA	Stock	29.06	29.155	28.14	28.25	2465600.0
2019-03-06	AABA-DELISTED	Stock	75.68	75.68	74.47	74.8	4800690.0
2019-03-06	AAC-DELISTED	Stock	2.58	2.5831	2.2601	2.365	305513.0
2019-03-06	AACG	Stock	1.21	1.21	1.11	1.18	240100.0
2019-03-06	AAIC-DELISTED	Stock	8.24	8.27	8.15	8.16	483259.0
2019-03-06	AAL	Stock	33.22	33.42	32.52	32.76	6420800.0
2019-03-06	AAM.A-DELISTED	Stock	25.035	25.12	25.035	25.12	18132.0
2019-03-06	AAM.B-DELISTED	Stock	24.8	24.82	24.74	24.82	21005.0
2019-03-06	AAMC-DELISTED	Stock	11.8118	12.2588	10.5176	10.5882	13518.0
2019-03-06	AAME	Stock	2.85	2.85	2.85	2.85	100.0
2019-03-06	AAMI	Stock	14.2	14.21	13.91	13.95	301400.0
2019-03-06	AAOI	Stock	13.58	13.71	13.11	13.3	973100.0
2019-03-06	AAON	Stock	28.2067	28.3867	27.8933	28.28	280950.0
2019-03-06	AAP	Stock	157.82	159.13	156.42	157.97	1067900.0
2019-03-06	AAT	Stock	44.16	44.99	44.02	44.77	338400.0
2019-03-06	AAU-DELISTED	Stock	0.6644	0.6644	0.6	0.6178	188159.0
2019-03-06	AAUAF-DELISTED	Stock	0.6644	0.6644	0.6	0.63	190998.0
2019-03-06	AAWW-DELISTED	Stock	51.42	51.89	49.92	49.92	253077.0
2019-03-06	AAXJ	Stock	70.26	70.39	69.98	69.98	663136.0
2019-03-06	AAXN-DELISTED	Stock	51.51	52.23	49.8102	49.98	405993.0
2019-03-06	AB	Stock	29.83	29.87	29.53	29.84	197400.0
2019-03-06	ABB-DELISTED	Stock	19.44	19.46	19.34	19.345	2056719.0
2019-03-06	ABBNY-DELISTED	Stock	19.44	19.46	19.34	19.35	2134439.0
2019-03-06	ABBV	Stock	79.13	79.13	77.56	78.09	5293200.0
2019-03-06	ABC-DELISTED	Stock	79.63	79.63	76.53	76.63	2118953.0
2019-03-06	ABCB	Stock	40.7	40.84	39.25	39.28	362500.0
2019-03-06	ABDC-DELISTED	Stock	7.1966	7.33	7.14	7.25	30034.0
2019-03-06	ABEO	Stock	196.75	198.5	175.5	176.25	21808.0
2019-03-06	ABEV	Stock	4.39	4.42	4.23	4.23	29692000.0
2019-03-06	ABG	Stock	67.84	68.13	66.69	66.99	294100.0
2019-03-06	ABIL-DELISTED	Stock	1.84	1.87	1.76	1.7872	53956.0
2019-03-06	ABM	Stock	36.09	36.65	35.9	36.55	797900.0
2019-03-06	ABMD-DELISTED	Stock	334.23	336.18	317.43	317.78	512093.0
2019-03-06	ABR	Stock	12.93	12.94	12.78	12.85	544500.0
2019-03-06	ABR.A-DELISTED	Stock	25.47	25.5993	25.43	25.5993	600.0
2019-03-06	ABR.B-DELISTED	Stock	25.5256	25.6	25.5256	25.6	5000.0
2019-03-06	ABT	Stock	78.11	78.22	77.52	77.7	4182100.0
2019-03-06	ABTC	Stock	303900.0	303900.0	303000.0	303300.0	0.2
2019-03-06	ABTS	Stock	52.5	67.5	51.0	51.0	12067.0

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

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