PREVIEW / stock_daily / 2018-09-06

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-06.parquet
  size:    217 KB
  rows:    6,496
  symbols: 2,737

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
2018-09-06	AAPL	Stock	56.5575	56.8375	55.325	55.775	137160000.0
2018-09-06	MSFT	Stock	108.25	108.99	107.51	108.74	23477600.0
2018-09-06	NVDA	Stock	6.944	6.9465	6.7848	6.818	322796000.0
2018-09-06	AMZN	Stock	100.3255	100.375	96.7605	97.9155	149774000.0
2018-09-06	GOOGL	Stock	59.9285	59.9493	58.1805	59.1995	46854440.0
2018-09-06	META	Stock	166.98	166.98	160.0	162.53	41514800.0
2018-09-06	TSLA	Stock	18.9867	19.4113	18.592	18.73	112212000.0
2018-09-06	TLT	Stock	119.76	120.4	119.6947	120.15	9566047.0
2018-09-06	ES	Stock	63.3	63.85	63.08	63.51	1061600.0
2018-09-06	CL	Stock	66.33	67.17	66.09	67.0	3295100.0
2018-09-06	A	Stock	67.0	67.55	66.83	67.36	1031500.0
2018-09-06	AA	Stock	42.9	42.93	40.12	40.36	6537200.0
2018-09-06	AABA-DELISTED	Stock	65.59	66.36	63.94	64.13	5660373.0
2018-09-06	AAC-DELISTED	Stock	8.05	8.17	7.89	8.02	205531.0
2018-09-06	AACG	Stock	2.07	2.09	1.9	1.9	222000.0
2018-09-06	AAIC-DELISTED	Stock	10.26	10.3	10.235	10.26	245954.0
2018-09-06	AAL	Stock	39.48	39.69	38.25	38.48	6917300.0
2018-09-06	AAM.A-DELISTED	Stock	25.45	25.5396	25.45	25.51	24296.0
2018-09-06	AAM.B-DELISTED	Stock	25.1	25.1199	25.0	25.05	51689.0
2018-09-06	AAMC-DELISTED	Stock	17.6029	17.6029	17.6029	17.6029	347.0
2018-09-06	AAMI	Stock	12.68	12.74	12.57	12.63	420600.0
2018-09-06	AAOI	Stock	34.06	34.52	32.05	32.24	1519900.0
2018-09-06	AAON	Stock	26.6333	26.8333	26.4333	26.5	237150.0
2018-09-06	AAP	Stock	167.97	169.39	166.77	167.22	775600.0
2018-09-06	AAT	Stock	39.09	39.34	38.98	38.98	161400.0
2018-09-06	AAU-DELISTED	Stock	0.6491	0.69	0.6401	0.6884	253146.0
2018-09-06	AAUAF-DELISTED	Stock	0.6491	0.69	0.6401	0.6884	255659.0
2018-09-06	AAV-DELISTED	Stock	2.6	2.61	2.45	2.5	342250.0
2018-09-06	AAWW-DELISTED	Stock	61.8	62.5	61.1	62.15	121013.0
2018-09-06	AAXJ	Stock	69.43	69.58	68.86	69.19	983617.0
2018-09-06	AAXN-DELISTED	Stock	68.89	70.5	68.77	70.28	465754.0
2018-09-06	AB	Stock	30.3	30.5	30.15	30.35	151300.0
2018-09-06	ABAC-DELISTED	Stock	1.99	3.2	1.8901	2.03	2522773.0
2018-09-06	ABB-DELISTED	Stock	23.43	23.55	23.2401	23.4	2850124.0
2018-09-06	ABBNY-DELISTED	Stock	23.43	23.55	23.2401	23.4	3280757.0
2018-09-06	ABBV	Stock	94.79	95.08	92.79	93.74	5416300.0
2018-09-06	ABC-DELISTED	Stock	89.61	89.92	87.6	88.38	1072922.0
2018-09-06	ABCB	Stock	49.75	50.0	49.48	49.5	181700.0
2018-09-06	ABCD-DELISTED	Stock	12.9	12.93	12.52	12.605	69134.0
2018-09-06	ABDC-DELISTED	Stock	6.16	6.23	6.11	6.17	34573.0
2018-09-06	ABEO	Stock	373.75	377.5	340.0	342.5	23164.0
2018-09-06	ABEV	Stock	4.44	4.47	4.33	4.44	39795700.0
2018-09-06	ABG	Stock	73.4	73.5	71.55	71.65	114500.0
2018-09-06	ABIL-DELISTED	Stock	3.51	3.5139	3.3701	3.47	41658.0
2018-09-06	ABM	Stock	31.94	32.06	31.54	31.54	580400.0
2018-09-06	ABMD-DELISTED	Stock	385.1	386.44	376.14	383.23	355212.0
2018-09-06	ABR	Stock	12.09	12.22	12.07	12.1	917400.0
2018-09-06	ABR.A-DELISTED	Stock	25.84	25.96	25.84	25.88	1108.0
2018-09-06	ABR.B-DELISTED	Stock	25.48	25.48	25.44	25.44	1000.0
2018-09-06	ABR.C-DELISTED	Stock	26.04	26.08	26.04	26.08	200.0

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

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