PREVIEW / stock_daily / 2019-01-02

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-02.parquet
  size:    218 KB
  rows:    6,546
  symbols: 2,666

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-02	AAPL	Stock	38.7225	39.7125	38.5575	39.48	148158800.0
2019-01-02	MSFT	Stock	99.55	101.75	98.94	101.12	35329300.0
2019-01-02	NVDA	Stock	3.266	3.462	3.2513	3.4055	508752000.0
2019-01-02	AMZN	Stock	73.26	77.668	73.0465	76.9565	159662000.0
2019-01-02	GOOGL	Stock	51.36	53.0395	51.2638	52.734	31867900.0
2019-01-02	META	Stock	128.99	137.51	128.56	135.68	28146200.0
2019-01-02	TSLA	Stock	20.4067	21.0087	19.92	20.6747	174879000.0
2019-01-02	TLT	Stock	121.66	122.16	121.3401	122.15	19841527.0
2019-01-02	ES	Stock	64.93	64.95	63.14	63.49	1493400.0
2019-01-02	CL	Stock	59.24	59.52	58.62	59.25	4559400.0
2019-01-02	A	Stock	66.5	66.57	65.3	65.69	2113300.0
2019-01-02	AA	Stock	25.955	26.847	25.48	26.24	3067000.0
2019-01-02	AABA-DELISTED	Stock	56.78	58.01	56.47	57.49	10028124.0
2019-01-02	AAC-DELISTED	Stock	1.4	1.76	1.33	1.63	371498.0
2019-01-02	AACG	Stock	0.91	1.0	0.9	0.94	30600.0
2019-01-02	AAIC-DELISTED	Stock	7.14	7.39	6.92	7.31	496637.0
2019-01-02	AAL	Stock	31.46	32.65	31.05	32.48	5229500.0
2019-01-02	AAM.A-DELISTED	Stock	22.45	22.9199	22.45	22.84	34386.0
2019-01-02	AAM.B-DELISTED	Stock	22.1	22.72	22.0679	22.6	43578.0
2019-01-02	AAMC-DELISTED	Stock	8.8324	9.1147	8.65	8.8265	30525.0
2019-01-02	AAME	Stock	2.43	2.49	2.43	2.49	1800.0
2019-01-02	AAMI	Stock	10.51	11.21	10.5	11.16	542600.0
2019-01-02	AAOI	Stock	15.0	16.29	14.85	15.88	478300.0
2019-01-02	AAON	Stock	23.0467	23.6	22.9133	23.38	187200.0
2019-01-02	AAP	Stock	156.16	159.92	153.82	157.92	1291000.0
2019-01-02	AAT	Stock	39.69	39.69	38.94	39.3	235000.0
2019-01-02	AAU-DELISTED	Stock	0.69	0.7	0.66	0.6915	202495.0
2019-01-02	AAUAF-DELISTED	Stock	0.69	0.7	0.66	0.698	206531.0
2019-01-02	AAWW-DELISTED	Stock	41.28	42.7	40.7	41.72	376487.0
2019-01-02	AAXJ	Stock	62.58	63.2	62.41	63.09	865569.0
2019-01-02	AAXN-DELISTED	Stock	42.99	45.12	42.62	45.12	724494.0
2019-01-02	AB	Stock	26.96	28.05	26.91	27.27	859500.0
2019-01-02	ABAC-DELISTED	Stock	1.17	1.6534	1.05	1.36	1337290.0
2019-01-02	ABB-DELISTED	Stock	18.62	19.085	18.54	19.0	1853716.0
2019-01-02	ABBNY-DELISTED	Stock	18.62	19.085	18.54	19.0	1916503.0
2019-01-02	ABBV	Stock	91.24	91.26	88.42	89.23	6908400.0
2019-01-02	ABC-DELISTED	Stock	73.74	74.765	73.11	74.42	978856.0
2019-01-02	ABCB	Stock	31.27	32.55	31.27	31.95	488700.0
2019-01-02	ABDC-DELISTED	Stock	6.47	6.64	6.4501	6.6	159044.0
2019-01-02	ABEO	Stock	175.0	179.5	170.25	175.75	16636.0
2019-01-02	ABEOW-DELISTED	Stock	3.459	3.46	3.4464	3.4464	1100.0
2019-01-02	ABEV	Stock	4.0	4.24	3.97	4.2	20573600.0
2019-01-02	ABG	Stock	65.71	68.46	65.71	68.12	252900.0
2019-01-02	ABIL-DELISTED	Stock	1.83	1.9932	1.81	1.9499	292884.0
2019-01-02	ABM	Stock	31.51	31.63	30.66	31.28	1039300.0
2019-01-02	ABMD-DELISTED	Stock	315.94	320.71	307.03	309.96	450070.0
2019-01-02	ABR	Stock	10.0	10.19	9.94	10.18	715900.0
2019-01-02	ABR.A-DELISTED	Stock	25.1499	25.47	25.1	25.47	2100.0
2019-01-02	ABR.B-DELISTED	Stock	24.99	25.18	24.9	24.99	2758.0
2019-01-02	ABR.C-DELISTED	Stock	26.05	26.4	25.95	26.19	925.0

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

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