PREVIEW / stock_daily / 2019-06-14

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-14.parquet
  size:    219 KB
  rows:    6,555
  symbols: 2,555

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-06-14	AAPL	Stock	47.8875	48.3975	47.575	48.185	75046000.0
2019-06-14	MSFT	Stock	132.26	133.79	131.64	132.45	17821700.0
2019-06-14	NVDA	Stock	3.6128	3.6372	3.571	3.616	394428000.0
2019-06-14	AMZN	Stock	93.2	93.8	92.95	93.4835	57024000.0
2019-06-14	GOOGL	Stock	54.487	54.738	54.0738	54.315	24586080.0
2019-06-14	META	Stock	180.51	181.84	180.0	181.33	16773700.0
2019-06-14	TSLA	Stock	14.0833	14.4433	14.0267	14.328	111501000.0
2019-06-14	TLT	Stock	131.1	131.71	131.09	131.46	5838794.0
2019-06-14	ES	Stock	76.82	77.52	76.59	77.41	1409600.0
2019-06-14	CL	Stock	72.87	73.48	72.76	73.35	2591900.0
2019-06-14	A	Stock	70.31	70.45	69.74	69.97	1602700.0
2019-06-14	AA	Stock	21.5	22.14	21.3	21.73	3210700.0
2019-06-14	AABA-DELISTED	Stock	66.23	66.48	65.76	65.99	3895819.0
2019-06-14	AAC-DELISTED	Stock	0.7491	0.7491	0.6208	0.6962	1394767.0
2019-06-14	AACG	Stock	2.13	2.14	2.05	2.11	36500.0
2019-06-14	AAIC-DELISTED	Stock	6.99	6.99	6.92	6.92	260357.0
2019-06-14	AAIC.C-DELISTED	Stock	21.71	21.7552	21.5	21.6979	6000.0
2019-06-14	AAL	Stock	32.97	33.2	32.22	32.68	6128000.0
2019-06-14	AAM.A-DELISTED	Stock	25.7421	25.77	25.72	25.73	11646.0
2019-06-14	AAM.B-DELISTED	Stock	25.8199	25.88	25.7815	25.86	23202.0
2019-06-14	AAME	Stock	2.25	2.41	2.2	2.23	6200.0
2019-06-14	AAMI	Stock	11.0	11.0	10.74	10.74	210700.0
2019-06-14	AAOI	Stock	8.87	8.915	8.56	8.89	393500.0
2019-06-14	AAON	Stock	32.54	32.8867	32.08	32.0933	109500.0
2019-06-14	AAP	Stock	150.69	152.68	150.31	151.8	769100.0
2019-06-14	AAT	Stock	46.12	47.28	45.54	47.25	2809900.0
2019-06-14	AAU-DELISTED	Stock	0.51	0.5391	0.5065	0.5318	243397.0
2019-06-14	AAUAF-DELISTED	Stock	0.51	0.5391	0.5065	0.5318	252399.0
2019-06-14	AAWW-DELISTED	Stock	42.07	42.43	40.3915	40.79	121247.0
2019-06-14	AAXJ	Stock	66.69	66.7	66.41	66.46	534231.0
2019-06-14	AAXN-DELISTED	Stock	70.66	71.48	70.605	70.67	948970.0
2019-06-14	AB	Stock	29.88	29.97	29.42	29.56	233900.0
2019-06-14	ABB-DELISTED	Stock	18.88	18.89	18.74	18.83	1501371.0
2019-06-14	ABBNY-DELISTED	Stock	18.88	18.89	18.74	18.83	1601548.0
2019-06-14	ABBV	Stock	78.95	79.34	78.21	78.69	4075900.0
2019-06-14	ABC-DELISTED	Stock	86.7	86.99	84.84	85.06	801372.0
2019-06-14	ABCB	Stock	38.13	38.43	37.62	38.28	192800.0
2019-06-14	ABDC-DELISTED	Stock	8.08	8.45	8.07	8.41	33990.0
2019-06-14	ABEO	Stock	133.75	135.0	128.75	129.25	10456.0
2019-06-14	ABEV	Stock	4.61	4.65	4.51	4.51	24640100.0
2019-06-14	ABG	Stock	80.41	81.01	79.73	79.81	85200.0
2019-06-14	ABIL-DELISTED	Stock	1.17	1.22	1.12	1.13	65580.0
2019-06-14	ABM	Stock	39.75	40.4	39.57	39.76	324200.0
2019-06-14	ABMD-DELISTED	Stock	255.38	256.05	249.52	250.96	331990.0
2019-06-14	ABR	Stock	12.18	12.35	12.13	12.3	1008800.0
2019-06-14	ABR.A-DELISTED	Stock	26.0476	26.15	26.0476	26.14	300.0
2019-06-14	ABR.B-DELISTED	Stock	25.6502	25.776	25.46	25.776	4275.0
2019-06-14	ABR.C-DELISTED	Stock	25.982	25.982	25.982	25.982	140.0
2019-06-14	ABT	Stock	82.17	82.86	82.02	82.22	4771100.0
2019-06-14	ABTC	Stock	307200.0	315000.0	305700.0	315000.0	0.41333333333333333

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

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