PREVIEW / stock_daily / 2019-04-09

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-09.parquet
  size:    220 KB
  rows:    6,529
  symbols: 2,590

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-04-09	AAPL	Stock	50.08	50.7125	49.8075	49.875	143072800.0
2019-04-09	MSFT	Stock	118.63	119.54	118.58	119.28	17612000.0
2019-04-09	NVDA	Stock	4.761	4.7722	4.689	4.7315	439972000.0
2019-04-09	AMZN	Stock	92.2745	92.6545	91.589	91.792	74288000.0
2019-04-09	GOOGL	Stock	60.0945	60.3575	59.919	60.1345	19676800.0
2019-04-09	META	Stock	175.62	179.19	175.55	177.58	19751000.0
2019-04-09	TSLA	Stock	18.11	18.3333	17.974	18.154	88560000.0
2019-04-09	TLT	Stock	124.22	124.335	123.77	123.98	7020320.0
2019-04-09	ES	Stock	70.65	70.84	70.42	70.78	1377200.0
2019-04-09	CL	Stock	67.81	68.14	67.6	68.11	2102100.0
2019-04-09	A	Stock	81.56	81.72	81.27	81.42	1254700.0
2019-04-09	AA	Stock	29.38	29.5	28.93	29.1	2355300.0
2019-04-09	AABA-DELISTED	Stock	74.28	75.73	73.63	75.62	14539684.0
2019-04-09	AAC-DELISTED	Stock	2.06	2.13	1.97	2.1	75149.0
2019-04-09	AACG	Stock	1.14	2.54	1.14	2.12	52444800.0
2019-04-09	AAIC-DELISTED	Stock	7.96	8.0	7.91	7.93	263995.0
2019-04-09	AAIC.C-DELISTED	Stock	23.65	23.7139	23.63	23.65	3486.0
2019-04-09	AAL	Stock	33.37	33.52	32.6	33.31	8119100.0
2019-04-09	AAM.A-DELISTED	Stock	24.77	24.82	24.7	24.75	16777.0
2019-04-09	AAM.B-DELISTED	Stock	24.69	24.74	24.61	24.63	35466.0
2019-04-09	AAMC-DELISTED	Stock	8.7647	9.0441	8.737	8.7647	17891.0
2019-04-09	AAME	Stock	2.58	2.58	2.35	2.35	9500.0
2019-04-09	AAMI	Stock	14.02	14.02	13.775	13.97	399000.0
2019-04-09	AAOI	Stock	12.39	12.48	11.9	12.06	849500.0
2019-04-09	AAON	Stock	30.4067	30.4067	29.7933	29.86	184800.0
2019-04-09	AAP	Stock	176.9	177.72	175.33	175.65	616200.0
2019-04-09	AAT	Stock	45.66	46.17	45.51	45.51	225300.0
2019-04-09	AAU-DELISTED	Stock	0.58	0.5835	0.565	0.565	37541.0
2019-04-09	AAUAF-DELISTED	Stock	0.58	0.5835	0.565	0.5717	39048.0
2019-04-09	AAWW-DELISTED	Stock	50.2	50.21	48.64	49.11	199585.0
2019-04-09	AAXJ	Stock	72.99	73.06	72.86	72.94	1150675.0
2019-04-09	AAXN-DELISTED	Stock	59.83	60.3578	58.45	58.67	458549.0
2019-04-09	AB	Stock	29.19	29.31	28.92	29.02	227600.0
2019-04-09	ABB-DELISTED	Stock	19.61	19.62	19.465	19.49	1539939.0
2019-04-09	ABBNY-DELISTED	Stock	19.61	19.62	19.465	19.48	1689433.0
2019-04-09	ABBV	Stock	83.77	83.78	82.5	82.69	3712700.0
2019-04-09	ABC-DELISTED	Stock	77.72	78.04	76.5	77.45	643436.0
2019-04-09	ABCB	Stock	35.92	36.05	34.66	34.74	260600.0
2019-04-09	ABDC-DELISTED	Stock	7.99	8.0	7.85	7.85	13296.0
2019-04-09	ABEO	Stock	188.75	190.25	180.5	181.0	9660.0
2019-04-09	ABEV	Stock	4.48	4.57	4.46	4.56	31511600.0
2019-04-09	ABG	Stock	71.8	72.33	71.27	71.74	104900.0
2019-04-09	ABIL-DELISTED	Stock	1.71	1.72	1.68	1.6983	24567.0
2019-04-09	ABM	Stock	37.02	37.02	36.49	36.49	235000.0
2019-04-09	ABMD-DELISTED	Stock	281.53	284.41	281.19	281.89	259327.0
2019-04-09	ABR	Stock	13.55	13.65	13.46	13.49	900600.0
2019-04-09	ABR.A-DELISTED	Stock	25.7487	25.7487	25.65	25.6722	1600.0
2019-04-09	ABR.B-DELISTED	Stock	25.52	25.679	25.4801	25.679	1400.0
2019-04-09	ABT	Stock	78.24	78.96	78.06	78.67	4836700.0
2019-04-09	ABTC	Stock	303000.0	303900.0	301260.0	303000.0	0.3733333333333333

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

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