PREVIEW / stock_daily / 2019-04-26

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-26.parquet
  size:    220 KB
  rows:    6,520
  symbols: 2,567

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-26	AAPL	Stock	51.225	51.25	50.53	51.075	74596400.0
2019-04-26	MSFT	Stock	129.7	130.52	129.02	129.89	23654900.0
2019-04-26	NVDA	Stock	4.5178	4.5222	4.3325	4.4522	868988000.0
2019-04-26	AMZN	Stock	96.45	97.55	94.9	97.5315	168652000.0
2019-04-26	GOOGL	Stock	63.669	63.9455	63.25	63.871	27228380.0
2019-04-26	META	Stock	192.5	192.9	189.09	191.49	22075000.0
2019-04-26	TSLA	Stock	16.4333	16.4453	15.4087	15.676	335410500.0
2019-04-26	TLT	Stock	123.98	124.02	123.64	123.81	5950651.0
2019-04-26	ES	Stock	71.49	71.78	70.95	71.02	1098100.0
2019-04-26	CL	Stock	69.58	71.5	69.48	71.3	5956000.0
2019-04-26	A	Stock	76.98	77.46	76.3	77.42	1608900.0
2019-04-26	AA	Stock	27.05	27.25	26.84	26.91	2257700.0
2019-04-26	AABA-DELISTED	Stock	76.44	76.68	75.53	76.11	2713984.0
2019-04-26	AAC-DELISTED	Stock	1.59	1.66	1.525	1.64	74926.0
2019-04-26	AACG	Stock	2.2	2.21	2.02	2.04	346600.0
2019-04-26	AAIC-DELISTED	Stock	7.76	7.9	7.76	7.87	235679.0
2019-04-26	AAIC.C-DELISTED	Stock	23.2	23.4	23.2	23.4	7599.0
2019-04-26	AAL	Stock	32.15	33.92	32.1	33.06	9623100.0
2019-04-26	AAM.A-DELISTED	Stock	25.14	25.15	25.04	25.13	22371.0
2019-04-26	AAM.B-DELISTED	Stock	25.14	25.1417	24.98	25.128	90246.0
2019-04-26	AAMC-DELISTED	Stock	8.5294	8.6176	7.6912	7.6912	14518.0
2019-04-26	AAME	Stock	2.49	2.49	2.49	2.49	300.0
2019-04-26	AAMI	Stock	14.57	14.67	14.43	14.67	238300.0
2019-04-26	AAOI	Stock	12.41	12.65	12.305	12.58	405800.0
2019-04-26	AAON	Stock	32.4467	33.3333	32.0533	33.1867	194100.0
2019-04-26	AAP	Stock	170.31	170.73	168.17	170.19	690700.0
2019-04-26	AAT	Stock	46.45	46.6	46.06	46.52	198700.0
2019-04-26	AAU-DELISTED	Stock	0.55	0.555	0.55	0.555	84475.0
2019-04-26	AAUAF-DELISTED	Stock	0.55	0.555	0.55	0.555	89566.0
2019-04-26	AAWW-DELISTED	Stock	47.71	48.22	47.0	48.22	118265.0
2019-04-26	AAXJ	Stock	72.01	72.2	71.77	72.12	810574.0
2019-04-26	AAXN-DELISTED	Stock	62.68	63.21	62.205	62.84	400301.0
2019-04-26	AB	Stock	28.85	29.27	28.85	29.14	270500.0
2019-04-26	ABB-DELISTED	Stock	20.42	20.555	20.365	20.52	1249146.0
2019-04-26	ABBNY-DELISTED	Stock	20.42	20.555	20.365	20.52	1304137.0
2019-04-26	ABBV	Stock	79.67	80.65	79.4	79.7	5790000.0
2019-04-26	ABC-DELISTED	Stock	74.09	74.85	73.55	74.04	612532.0
2019-04-26	ABCB	Stock	36.03	36.56	35.92	36.47	361300.0
2019-04-26	ABDC-DELISTED	Stock	8.14	8.41	8.14	8.41	37566.0
2019-04-26	ABEO	Stock	206.0	206.0	199.5	203.75	6960.0
2019-04-26	ABEV	Stock	4.6	4.66	4.57	4.62	16108400.0
2019-04-26	ABG	Stock	79.44	81.48	79.2	81.05	128100.0
2019-04-26	ABIL-DELISTED	Stock	1.47	1.47	1.42	1.46	40742.0
2019-04-26	ABM	Stock	37.06	37.51	36.77	37.28	257300.0
2019-04-26	ABMD-DELISTED	Stock	268.4	276.96	268.4	274.92	519409.0
2019-04-26	ABR	Stock	13.85	13.94	13.77	13.78	1313800.0
2019-04-26	ABR.A-DELISTED	Stock	26.11	26.345	26.1001	26.345	2559.0
2019-04-26	ABR.B-DELISTED	Stock	25.63	25.6337	25.63	25.6302	1400.0
2019-04-26	ABR.C-DELISTED	Stock	26.42	26.42	26.2239	26.3359	2857.0
2019-04-26	ABT	Stock	78.46	78.57	77.53	78.56	4286500.0

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

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