PREVIEW / stock_daily / 2019-06-20

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-20.parquet
  size:    221 KB
  rows:    6,590
  symbols: 2,563

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-20	AAPL	Stock	50.0925	50.1525	49.5075	49.865	86056000.0
2019-06-20	MSFT	Stock	137.45	137.66	135.72	136.95	33042600.0
2019-06-20	NVDA	Stock	3.9192	3.9333	3.838	3.8525	350168000.0
2019-06-20	AMZN	Stock	96.6665	96.76	95.29	95.9095	64344000.0
2019-06-20	GOOGL	Stock	56.085	56.136	55.35	55.66	24018160.0
2019-06-20	META	Stock	190.95	191.16	187.64	189.53	14635700.0
2019-06-20	TSLA	Stock	14.8667	15.1267	14.4233	14.6413	177952500.0
2019-06-20	TLT	Stock	132.91	133.505	132.59	132.89	10721526.0
2019-06-20	ES	Stock	77.46	77.87	76.65	77.53	1764500.0
2019-06-20	CL	Stock	73.81	74.12	73.31	73.6	2754500.0
2019-06-20	A	Stock	73.22	73.42	72.36	73.32	2077800.0
2019-06-20	AA	Stock	23.06	23.25	22.46	22.51	2519300.0
2019-06-20	AABA-DELISTED	Stock	69.9	70.09	68.76	69.29	5287274.0
2019-06-20	AAC-DELISTED	Stock	0.7	0.73	0.6524	0.6556	705036.0
2019-06-20	AACG	Stock	2.57	2.93	2.56	2.66	637200.0
2019-06-20	AAIC-DELISTED	Stock	7.08	7.08	6.96	7.01	410600.0
2019-06-20	AAIC.C-DELISTED	Stock	21.57	21.8	21.57	21.79	27215.0
2019-06-20	AAL	Stock	33.66	33.81	31.9	32.15	8969200.0
2019-06-20	AAM.A-DELISTED	Stock	25.85	25.92	25.76	25.8	11659.0
2019-06-20	AAM.B-DELISTED	Stock	25.8931	25.9499	25.86	25.9057	38891.0
2019-06-20	AAMC-DELISTED	Stock	4.1382	4.3147	4.0567	4.1	16487.0
2019-06-20	AAME	Stock	2.47	2.48	2.47	2.48	1500.0
2019-06-20	AAMI	Stock	11.14	11.2	11.01	11.04	453600.0
2019-06-20	AAOI	Stock	8.93	9.09	8.77	8.88	299500.0
2019-06-20	AAON	Stock	32.58	33.0467	32.2133	32.9333	198450.0
2019-06-20	AAP	Stock	154.32	154.95	151.27	153.27	874700.0
2019-06-20	AAT	Stock	47.97	48.11	47.65	48.03	487200.0
2019-06-20	AAU-DELISTED	Stock	0.585	0.6098	0.5799	0.6	314962.0
2019-06-20	AAUAF-DELISTED	Stock	0.585	0.6098	0.5799	0.6	330388.0
2019-06-20	AAWW-DELISTED	Stock	42.67	42.87	41.63	41.95	176029.0
2019-06-20	AAXJ	Stock	69.93	70.04	69.38	69.66	1022225.0
2019-06-20	AAXN-DELISTED	Stock	70.21	73.26	70.15	73.25	791540.0
2019-06-20	AB	Stock	29.4	29.79	29.1	29.39	251600.0
2019-06-20	ABB-DELISTED	Stock	19.79	19.8	19.65	19.79	1565464.0
2019-06-20	ABBNY-DELISTED	Stock	19.79	19.8	19.65	19.79	1903857.0
2019-06-20	ABBV	Stock	78.24	79.17	78.08	78.34	5347000.0
2019-06-20	ABC-DELISTED	Stock	86.97	86.97	84.36	85.54	1538052.0
2019-06-20	ABCB	Stock	38.47	38.47	37.11	37.96	259300.0
2019-06-20	ABDC-DELISTED	Stock	8.48	8.65	8.48	8.53	21662.0
2019-06-20	ABEO	Stock	124.0	130.0	117.75	119.0	48460.0
2019-06-20	ABEV	Stock	4.79	4.87	4.78	4.82	13904900.0
2019-06-20	ABG	Stock	83.37	84.09	82.08	83.16	145900.0
2019-06-20	ABIL-DELISTED	Stock	1.02	1.06	0.92	0.9747	237976.0
2019-06-20	ABM	Stock	40.0	40.24	39.78	40.0	283800.0
2019-06-20	ABMD-DELISTED	Stock	258.04	262.49	253.2	260.35	310830.0
2019-06-20	ABR	Stock	12.46	12.46	12.31	12.43	982800.0
2019-06-20	ABR.A-DELISTED	Stock	26.035	26.3496	26.035	26.349	551.0
2019-06-20	ABR.C-DELISTED	Stock	26.0289	26.1491	26.02	26.08	2200.0
2019-06-20	ABT	Stock	84.84	85.32	84.32	84.94	6436400.0
2019-06-20	ABTC	Stock	1950000.0	2179500.0	990000.0	1096500.0	127.06666666666666

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

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