PREVIEW / stock_daily / 2019-01-07

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-07.parquet
  size:    220 KB
  rows:    6,559
  symbols: 2,665

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-01-07	AAPL	Stock	37.175	37.2075	36.475	36.9825	219111200.0
2019-01-07	MSFT	Stock	101.64	103.27	100.98	102.06	35656100.0
2019-01-07	NVDA	Stock	3.4625	3.6222	3.4108	3.585	709160000.0
2019-01-07	AMZN	Stock	80.1155	81.728	79.4595	81.4755	159864000.0
2019-01-07	GOOGL	Stock	54.0485	54.135	53.132	53.796	47453340.0
2019-01-07	META	Stock	137.56	138.87	135.91	138.05	20089300.0
2019-01-07	TSLA	Stock	21.448	22.4493	21.1833	22.3307	113268000.0
2019-01-07	TLT	Stock	122.62	122.65	121.62	121.75	8498104.0
2019-01-07	ES	Stock	63.77	64.47	63.54	63.93	1211200.0
2019-01-07	CL	Stock	59.44	60.46	59.31	59.88	4575200.0
2019-01-07	A	Stock	65.64	67.43	65.61	66.85	3235100.0
2019-01-07	AA	Stock	28.53	28.91	28.146	28.42	2441000.0
2019-01-07	AABA-DELISTED	Stock	58.9	60.2	58.45	59.65	8057459.0
2019-01-07	AAC-DELISTED	Stock	1.86	2.35	1.86	2.28	390982.0
2019-01-07	AACG	Stock	0.93	0.98	0.93	0.94	21600.0
2019-01-07	AAIC-DELISTED	Stock	7.61	7.95	7.61	7.92	483975.0
2019-01-07	AAL	Stock	31.99	33.48	31.24	32.95	8010700.0
2019-01-07	AAM.A-DELISTED	Stock	23.2	23.69	23.2	23.55	43869.0
2019-01-07	AAM.B-DELISTED	Stock	23.05	23.59	23.05	23.55	55342.0
2019-01-07	AAMC-DELISTED	Stock	8.5324	8.9618	8.5324	8.7441	3169.0
2019-01-07	AAME	Stock	2.41	3.06	2.41	2.77	2600.0
2019-01-07	AAMI	Stock	11.21	11.595	11.16	11.46	491300.0
2019-01-07	AAOI	Stock	15.68	16.033	15.33	15.68	546300.0
2019-01-07	AAON	Stock	23.7333	24.2133	23.4533	24.1	171000.0
2019-01-07	AAP	Stock	161.68	163.57	156.83	161.14	2088300.0
2019-01-07	AAT	Stock	39.82	40.62	39.75	40.25	191300.0
2019-01-07	AAU-DELISTED	Stock	0.77	0.77	0.69	0.69	197644.0
2019-01-07	AAUAF-DELISTED	Stock	0.77	0.77	0.69	0.69	206583.0
2019-01-07	AAWW-DELISTED	Stock	42.13	43.43	41.65	42.78	176598.0
2019-01-07	AAXJ	Stock	63.62	64.18	63.496	64.01	1060865.0
2019-01-07	AAXN-DELISTED	Stock	46.45	48.71	46.39	48.14	654580.0
2019-01-07	AB	Stock	28.09	28.54	27.8	27.96	492500.0
2019-01-07	ABAC-DELISTED	Stock	1.18	1.22	1.15	1.2	27894.0
2019-01-07	ABB-DELISTED	Stock	19.1	19.31	19.03	19.22	1657455.0
2019-01-07	ABBNY-DELISTED	Stock	19.1	19.31	19.03	19.22	1741223.0
2019-01-07	ABBV	Stock	90.07	90.76	89.2	90.37	7281500.0
2019-01-07	ABC-DELISTED	Stock	74.43	76.24	73.82	74.75	1372774.0
2019-01-07	ABCB	Stock	33.2	34.45	32.87	34.39	581500.0
2019-01-07	ABDC-DELISTED	Stock	6.86	6.9459	6.7801	6.92	22842.0
2019-01-07	ABEO	Stock	177.25	189.0	175.5	187.75	27528.0
2019-01-07	ABEV	Stock	4.41	4.43	4.31	4.35	29566800.0
2019-01-07	ABG	Stock	67.9	71.07	67.9	70.66	321300.0
2019-01-07	ABIL-DELISTED	Stock	1.9	2.0499	1.86	1.9725	427509.0
2019-01-07	ABM	Stock	32.12	33.63	31.58	33.48	881400.0
2019-01-07	ABMD-DELISTED	Stock	313.5	315.5	305.56	314.8	521507.0
2019-01-07	ABR	Stock	10.65	10.94	10.61	10.88	1519200.0
2019-01-07	ABR.A-DELISTED	Stock	25.3019	25.4436	25.3019	25.39	2330.0
2019-01-07	ABR.B-DELISTED	Stock	25.64	25.64	24.99	25.3	8802.0
2019-01-07	ABR.C-DELISTED	Stock	25.8	25.8	25.8	25.8	400.0
2019-01-07	ABT	Stock	68.19	69.86	68.18	69.13	9503000.0

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

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