PREVIEW / stock_daily / 2019-09-16

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-16.parquet
  size:    222 KB
  rows:    6,610
  symbols: 2,524

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-09-16	AAPL	Stock	54.4325	55.0325	54.39	54.975	84632400.0
2019-09-16	MSFT	Stock	135.83	136.7	135.66	136.33	16731400.0
2019-09-16	NVDA	Stock	4.473	4.54	4.4625	4.5052	231832000.0
2019-09-16	AMZN	Stock	91.201	91.2845	90.01	90.392	73510000.0
2019-09-16	GOOGL	Stock	61.522	61.951	61.2595	61.5815	28217600.0
2019-09-16	META	Stock	186.93	187.79	185.77	186.22	8444800.0
2019-09-16	TSLA	Stock	16.4	16.4953	16.078	16.1873	70921500.0
2019-09-16	TLT	Stock	137.88	138.57	137.2544	138.28	10971572.0
2019-09-16	ES	Stock	82.6	82.6	82.18	82.44	1083000.0
2019-09-16	CL	Stock	70.1	70.39	68.97	69.43	4116900.0
2019-09-16	A	Stock	77.32	77.43	76.46	77.15	2874500.0
2019-09-16	AA	Stock	22.56	22.87	22.38	22.56	2866100.0
2019-09-16	AABA-DELISTED	Stock	70.02	70.251	70.0	70.22	9535511.0
2019-09-16	AAC-DELISTED	Stock	0.7933	0.834	0.765	0.8076	132883.0
2019-09-16	AACG	Stock	1.8	1.85	1.8	1.81	5500.0
2019-09-16	AAIC-DELISTED	Stock	5.56	5.58	5.47	5.53	311429.0
2019-09-16	AAIC.C-DELISTED	Stock	21.98	22.0001	21.8793	21.9	37786.0
2019-09-16	AAL	Stock	28.56	28.79	27.7	27.77	15507800.0
2019-09-16	AAM.A-DELISTED	Stock	26.2	26.25	26.11	26.25	33330.0
2019-09-16	AAM.B-DELISTED	Stock	26.44	26.49	26.28	26.35	29469.0
2019-09-16	AAMC-DELISTED	Stock	3.1029	3.3618	3.1029	3.1676	20614.0
2019-09-16	AAME	Stock	2.74	2.74	2.55	2.73	3100.0
2019-09-16	AAMI	Stock	10.66	10.77	10.47	10.54	764500.0
2019-09-16	AAOI	Stock	11.15	11.67	11.15	11.4	387600.0
2019-09-16	AAON	Stock	33.1733	33.9467	32.3267	33.8	171000.0
2019-09-16	AAP	Stock	156.0	158.26	155.7	156.07	904800.0
2019-09-16	AAT	Stock	47.05	47.48	46.62	46.76	789900.0
2019-09-16	AAU-DELISTED	Stock	0.72	0.7261	0.709	0.7098	173360.0
2019-09-16	AAUAF-DELISTED	Stock	0.72	0.7261	0.709	0.7098	183532.0
2019-09-16	AAWW-DELISTED	Stock	26.85	28.5	26.75	27.75	284157.0
2019-09-16	AAXJ	Stock	68.16	68.345	67.95	68.11	980944.0
2019-09-16	AAXN-DELISTED	Stock	64.84	66.8	64.3956	66.2	296145.0
2019-09-16	AB	Stock	29.49	29.91	29.4	29.66	187000.0
2019-09-16	ABB-DELISTED	Stock	20.27	20.29	20.225	20.26	1044924.0
2019-09-16	ABBNY-DELISTED	Stock	20.27	20.29	20.225	20.27	1096541.0
2019-09-16	ABBV	Stock	70.37	70.96	69.72	70.58	5992000.0
2019-09-16	ABC-DELISTED	Stock	82.68	83.89	82.37	83.74	852442.0
2019-09-16	ABCB	Stock	38.89	39.74	38.77	39.23	467500.0
2019-09-16	ABDC-DELISTED	Stock	8.85	8.87	8.76	8.86	29415.0
2019-09-16	ABEO	Stock	73.5	75.25	71.75	74.75	18668.0
2019-09-16	ABEV	Stock	4.64	4.72	4.63	4.69	10865300.0
2019-09-16	ABG	Stock	99.54	100.02	97.66	99.1	145200.0
2019-09-16	ABIL-DELISTED	Stock	0.58	0.65	0.58	0.61	217875.0
2019-09-16	ABM	Stock	36.1	36.86	36.02	36.65	187700.0
2019-09-16	ABMD-DELISTED	Stock	185.0	191.655	182.58	190.36	467101.0
2019-09-16	ABR	Stock	12.9	12.97	12.79	12.83	1029200.0
2019-09-16	ABR.A-DELISTED	Stock	26.01	26.01	26.0	26.0	1409.0
2019-09-16	ABR.B-DELISTED	Stock	25.8412	25.8412	25.84	25.84	255.0
2019-09-16	ABR.C-DELISTED	Stock	26.35	26.37	26.35	26.37	519.0
2019-09-16	ABT	Stock	83.91	83.91	83.03	83.36	3991200.0

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

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