PREVIEW / stock_daily / 2018-12-03

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-03.parquet
  size:    221 KB
  rows:    6,560
  symbols: 2,697

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-12-03	AAPL	Stock	46.115	46.235	45.3025	46.205	163210000.0
2018-12-03	MSFT	Stock	113.0	113.42	110.73	112.09	34732800.0
2018-12-03	NVDA	Stock	4.315	4.367	4.1835	4.251	890804000.0
2018-12-03	AMZN	Stock	88.473	88.917	86.5	88.618	137246000.0
2018-12-03	GOOGL	Stock	56.608	56.75	55.5865	55.818	57528980.0
2018-12-03	META	Stock	143.0	143.68	140.76	141.09	24819200.0
2018-12-03	TSLA	Stock	24.0	24.4	23.4667	23.8993	124597500.0
2018-12-03	TLT	Stock	114.68	115.88	114.66	115.88	9763851.0
2018-12-03	ES	Stock	68.25	68.74	67.52	68.74	1955500.0
2018-12-03	CL	Stock	63.46	63.9	63.11	63.76	4878600.0
2018-12-03	A	Stock	73.33	74.79	73.19	74.67	4265200.0
2018-12-03	AA	Stock	32.9	33.469	31.78	32.05	2946200.0
2018-12-03	AABA-DELISTED	Stock	68.14	68.64	66.73	66.82	6499966.0
2018-12-03	AAC-DELISTED	Stock	2.16	2.3531	2.06	2.31	403108.0
2018-12-03	AACG	Stock	1.12	1.2	1.1	1.15	412700.0
2018-12-03	AAIC-DELISTED	Stock	8.65	8.69	8.53	8.67	345098.0
2018-12-03	AAL	Stock	40.57	40.58	39.14	39.65	6578000.0
2018-12-03	AAM.A-DELISTED	Stock	23.27	23.34	23.17	23.26	33994.0
2018-12-03	AAM.B-DELISTED	Stock	23.45	23.45	23.1838	23.25	33033.0
2018-12-03	AAMC-DELISTED	Stock	14.0059	14.7029	13.9706	14.7029	5821.0
2018-12-03	AAME	Stock	2.86	2.86	2.66	2.66	1300.0
2018-12-03	AAMI	Stock	13.31	13.44	13.13	13.29	302600.0
2018-12-03	AAOI	Stock	21.12	21.92	20.88	21.58	704000.0
2018-12-03	AAON	Stock	25.4733	25.96	25.2267	25.86	291750.0
2018-12-03	AAP	Stock	178.97	179.79	174.85	177.89	895200.0
2018-12-03	AAT	Stock	41.79	41.93	41.22	41.91	208900.0
2018-12-03	AAU-DELISTED	Stock	0.5705	0.65	0.5704	0.64	367080.0
2018-12-03	AAUAF-DELISTED	Stock	0.5705	0.65	0.5704	0.64	398982.0
2018-12-03	AAWW-DELISTED	Stock	53.58	54.89	53.58	54.5446	170078.0
2018-12-03	AAXJ	Stock	68.43	68.6	67.87	68.29	3513209.0
2018-12-03	AAXN-DELISTED	Stock	43.91	45.5	43.8	45.18	1363913.0
2018-12-03	AB	Stock	30.57	30.9	30.17	30.85	377300.0
2018-12-03	ABAC-DELISTED	Stock	1.5804	1.6	1.44	1.4701	13417.0
2018-12-03	ABB-DELISTED	Stock	20.42	20.46	20.22	20.3	2028756.0
2018-12-03	ABBNY-DELISTED	Stock	20.42	20.46	20.22	20.31	2123456.0
2018-12-03	ABBV	Stock	94.32	94.72	92.82	93.66	6673900.0
2018-12-03	ABC-DELISTED	Stock	88.98	89.675	88.05	89.01	1031251.0
2018-12-03	ABCB	Stock	43.43	43.43	42.24	42.9	385600.0
2018-12-03	ABCD-DELISTED	Stock	14.47	14.49	14.46	14.48	242527.0
2018-12-03	ABDC-DELISTED	Stock	6.49	6.59	6.4001	6.58	37134.0
2018-12-03	ABEO	Stock	207.5	215.5	203.0	212.5	26188.0
2018-12-03	ABEV	Stock	4.35	4.37	4.28	4.32	22078500.0
2018-12-03	ABG	Stock	70.1	71.03	69.17	70.14	250800.0
2018-12-03	ABIL-DELISTED	Stock	2.71	2.7123	2.51	2.62	311740.0
2018-12-03	ABM	Stock	32.06	32.17	30.51	31.02	399400.0
2018-12-03	ABMD-DELISTED	Stock	339.62	344.99	333.21	343.37	397248.0
2018-12-03	ABR	Stock	11.91	12.05	11.84	11.89	1769300.0
2018-12-03	ABR.A-DELISTED	Stock	25.4111	25.4656	25.4111	25.4656	1804.0
2018-12-03	ABR.B-DELISTED	Stock	25.188	25.188	25.188	25.188	400.0
2018-12-03	ABR.C-DELISTED	Stock	25.4013	25.53	25.4013	25.512	4948.0

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

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