PREVIEW / stock_daily / 2019-04-23

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-23.parquet
  size:    221 KB
  rows:    6,544
  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-23	AAPL	Stock	51.1075	51.9375	50.975	51.87	93292000.0
2019-04-23	MSFT	Stock	124.1	125.58	123.83	125.44	24025500.0
2019-04-23	NVDA	Stock	4.725	4.7982	4.7152	4.7668	346856000.0
2019-04-23	AMZN	Stock	94.56	96.463	94.479	96.1885	92808000.0
2019-04-23	GOOGL	Stock	62.832	63.7215	62.5988	63.5295	31868980.0
2019-04-23	META	Stock	182.74	184.22	181.48	183.78	19954800.0
2019-04-23	TSLA	Stock	17.3433	17.7067	17.05	17.5933	164158500.0
2019-04-23	TLT	Stock	122.61	122.7	122.39	122.57	6239726.0
2019-04-23	ES	Stock	70.2	70.52	69.85	70.4	1983900.0
2019-04-23	CL	Stock	69.33	69.78	68.87	69.01	3388000.0
2019-04-23	A	Stock	74.28	76.8	73.76	75.56	4607100.0
2019-04-23	AA	Stock	28.08	28.92	28.08	28.53	4784800.0
2019-04-23	AABA-DELISTED	Stock	75.54	76.535	75.37	76.06	1976612.0
2019-04-23	AAC-DELISTED	Stock	1.49	1.63	1.36	1.62	391809.0
2019-04-23	AACG	Stock	2.3	2.48	2.25	2.35	321800.0
2019-04-23	AAIC-DELISTED	Stock	7.7	7.79	7.69	7.75	410164.0
2019-04-23	AAIC.C-DELISTED	Stock	23.21	23.3	23.21	23.3	1600.0
2019-04-23	AAL	Stock	33.43	34.18	33.42	33.97	3329800.0
2019-04-23	AAM.A-DELISTED	Stock	25.06	25.06	25.0301	25.05	38368.0
2019-04-23	AAM.B-DELISTED	Stock	24.96	25.03	24.94	24.995	98158.0
2019-04-23	AAMC-DELISTED	Stock	8.3471	8.3471	8.3471	8.3471	765.0
2019-04-23	AAME	Stock	2.69	2.69	2.69	2.69	1200.0
2019-04-23	AAMI	Stock	14.48	14.77	14.44	14.69	377000.0
2019-04-23	AAOI	Stock	12.41	12.58	12.3	12.4	460900.0
2019-04-23	AAON	Stock	31.86	32.76	31.5933	32.5533	203700.0
2019-04-23	AAP	Stock	171.09	173.72	170.26	172.47	925000.0
2019-04-23	AAT	Stock	43.9	45.11	43.49	45.11	269900.0
2019-04-23	AAU-DELISTED	Stock	0.55	0.5535	0.55	0.5503	95665.0
2019-04-23	AAUAF-DELISTED	Stock	0.55	0.5535	0.55	0.5503	104368.0
2019-04-23	AAWW-DELISTED	Stock	49.06	50.06	48.6005	49.63	70071.0
2019-04-23	AAXJ	Stock	72.58	73.0389	72.57	72.94	1267539.0
2019-04-23	AAXN-DELISTED	Stock	61.07	63.18	60.99	62.86	374970.0
2019-04-23	AB	Stock	29.75	30.19	29.62	30.11	321800.0
2019-04-23	ABB-DELISTED	Stock	20.6	20.71	20.58	20.645	1506596.0
2019-04-23	ABBNY-DELISTED	Stock	20.6	20.71	20.58	20.64	1598882.0
2019-04-23	ABBV	Stock	78.15	79.66	77.75	78.66	9920600.0
2019-04-23	ABC-DELISTED	Stock	71.2	73.99	70.91	73.43	1413758.0
2019-04-23	ABCB	Stock	34.75	35.84	33.57	35.26	584400.0
2019-04-23	ABDC-DELISTED	Stock	8.05	8.2	8.05	8.05	56532.0
2019-04-23	ABEO	Stock	200.5	208.75	196.0	206.0	20720.0
2019-04-23	ABEV	Stock	4.46	4.54	4.46	4.5	20240800.0
2019-04-23	ABG	Stock	77.93	82.3	75.42	76.83	319800.0
2019-04-23	ABIL-DELISTED	Stock	1.5	1.555	1.45	1.52	66762.0
2019-04-23	ABM	Stock	37.52	38.17	37.45	37.93	294100.0
2019-04-23	ABMD-DELISTED	Stock	260.81	263.95	256.16	262.16	566830.0
2019-04-23	ABR	Stock	13.6	13.77	13.6	13.74	1091900.0
2019-04-23	ABR.A-DELISTED	Stock	25.97	26.0704	25.911	26.0065	3423.0
2019-04-23	ABR.B-DELISTED	Stock	25.57	25.57	25.57	25.57	600.0
2019-04-23	ABR.C-DELISTED	Stock	26.59	26.59	26.43	26.46	1200.0
2019-04-23	ABT	Stock	74.63	76.41	74.43	76.1	6823500.0

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

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