PREVIEW / stock_daily / 2020-06-17

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-17.parquet
  size:    222 KB
  rows:    6,712
  symbols: 2,397

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
2020-06-17	AAPL	Stock	88.7875	88.85	87.7725	87.8975	114406400.0
2020-06-17	MSFT	Stock	195.03	196.32	193.69	194.24	25687800.0
2020-06-17	NVDA	Stock	9.1138	9.299	9.0702	9.236	408304000.0
2020-06-17	AMZN	Stock	132.375	132.75	131.591	132.049	59186000.0
2020-06-17	GOOGL	Stock	72.647	73.11	71.7563	72.627	30610000.0
2020-06-17	META	Stock	235.0	237.59	231.73	235.53	19578100.0
2020-06-17	TSLA	Stock	65.8473	67.0	65.5047	66.1193	148362000.0
2020-06-17	TLT	Stock	160.27	160.77	159.34	160.56	7113900.0
2020-06-17	ES	Stock	84.66	85.6	83.53	85.03	1279700.0
2020-06-17	CL	Stock	73.8	74.48	73.54	73.81	2410500.0
2020-06-17	A	Stock	87.85	88.75	87.46	87.92	900800.0
2020-06-17	AA	Stock	11.55	11.81	11.38	11.55	6532200.0
2020-06-17	AACG	Stock	1.26	1.3	1.11	1.12	141000.0
2020-06-17	AAIC-DELISTED	Stock	3.07	3.07	2.94	2.95	265616.0
2020-06-17	AAIC.C-DELISTED	Stock	20.49	20.49	19.95	20.17	11993.0
2020-06-17	AAL	Stock	16.76	17.05	16.16	16.98	71706700.0
2020-06-17	AAM.A-DELISTED	Stock	26.035	26.2	25.88	25.88	22131.0
2020-06-17	AAM.B-DELISTED	Stock	25.99	25.99	25.5	25.75	62876.0
2020-06-17	AAMC-DELISTED	Stock	4.8235	5.1471	4.7794	4.9294	23797.0
2020-06-17	AAME	Stock	1.87	3.48	1.87	2.77	107000.0
2020-06-17	AAMI	Stock	11.04	11.05	10.41	10.46	1102100.0
2020-06-17	AAOI	Stock	9.4	10.28	9.17	10.18	1299500.0
2020-06-17	AAON	Stock	36.1667	36.26	35.3133	35.42	209250.0
2020-06-17	AAP	Stock	144.11	150.03	142.74	148.64	1382700.0
2020-06-17	AAT	Stock	31.21	31.21	29.85	29.87	253400.0
2020-06-17	AAU-DELISTED	Stock	0.498	0.5188	0.49	0.5015	172545.0
2020-06-17	AAUAF-DELISTED	Stock	0.498	0.5188	0.49	0.5015	176211.0
2020-06-17	AAWW-DELISTED	Stock	41.08	41.4	39.72	39.89	222157.0
2020-06-17	AAXJ	Stock	68.54	68.95	68.5	68.67	759586.0
2020-06-17	AAXN-DELISTED	Stock	93.18	96.925	93.0	94.88	2217638.0
2020-06-17	AB	Stock	27.0	27.34	26.73	26.88	426100.0
2020-06-17	ABB-DELISTED	Stock	21.74	21.75	21.36	21.38	1300618.0
2020-06-17	ABBNY-DELISTED	Stock	21.74	21.75	21.36	21.37	1394923.0
2020-06-17	ABBV	Stock	96.85	97.1	95.27	95.74	6212200.0
2020-06-17	ABC-DELISTED	Stock	99.52	100.48	98.62	100.12	864331.0
2020-06-17	ABCB	Stock	25.56	25.59	24.31	24.6	411200.0
2020-06-17	ABEO	Stock	80.25	80.25	74.75	75.75	25508.0
2020-06-17	ABEV	Stock	2.6	2.7	2.58	2.64	33425900.0
2020-06-17	ABG	Stock	79.62	80.78	77.75	77.93	119300.0
2020-06-17	ABM	Stock	34.1	34.36	32.44	32.53	844000.0
2020-06-17	ABMD-DELISTED	Stock	252.04	256.0	249.153	254.74	237930.0
2020-06-17	ABR	Stock	9.87	9.97	9.59	9.69	1542700.0
2020-06-17	ABR.A-DELISTED	Stock	24.96	25.1528	24.42	25.02	5710.0
2020-06-17	ABR.B-DELISTED	Stock	23.59	23.59	23.01	23.3962	1100.0
2020-06-17	ABR.C-DELISTED	Stock	24.88	24.88	24.4	24.82	1518.0
2020-06-17	ABT	Stock	90.42	91.67	90.1	90.9	4359100.0
2020-06-17	ABTC	Stock	319800.0	323550.0	292500.0	294600.0	4.36
2020-06-17	ABTS	Stock	15.3	16.5	14.85	15.3	4787.0
2020-06-17	ABTX-DELISTED	Stock	26.63	26.63	24.86	24.87	43616.0
2020-06-17	ABUS	Stock	1.97	2.08	1.91	1.91	663200.0

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

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