PREVIEW / stock_daily / 2019-01-11

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-11.parquet
  size:    218 KB
  rows:    6,516
  symbols: 2,632

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-11	AAPL	Stock	38.22	38.425	37.8775	38.0725	108092800.0
2019-01-11	MSFT	Stock	103.19	103.44	101.64	102.8	28314200.0
2019-01-11	NVDA	Stock	3.6083	3.7438	3.5803	3.7208	874764000.0
2019-01-11	AMZN	Stock	82.0275	83.0145	81.811	82.028	93724000.0
2019-01-11	GOOGL	Stock	53.495	53.6685	52.8215	53.2235	30864760.0
2019-01-11	META	Stock	143.15	145.36	142.57	143.8	12908000.0
2019-01-11	TSLA	Stock	22.806	23.2273	22.5847	23.1507	75586500.0
2019-01-11	TLT	Stock	120.83	121.27	120.68	120.93	5786934.0
2019-01-11	ES	Stock	65.97	66.25	65.43	65.99	1301400.0
2019-01-11	CL	Stock	62.26	62.54	61.75	62.1	2616900.0
2019-01-11	A	Stock	69.29	70.41	68.94	70.38	1210800.0
2019-01-11	AA	Stock	28.72	28.88	27.96	28.55	3838400.0
2019-01-11	AABA-DELISTED	Stock	62.87	63.57	62.53	62.831	3420705.0
2019-01-11	AAC-DELISTED	Stock	2.21	2.46	2.15	2.43	224250.0
2019-01-11	AACG	Stock	1.04	1.06	0.97	0.99	44100.0
2019-01-11	AAIC-DELISTED	Stock	7.9	7.985	7.835	7.96	251228.0
2019-01-11	AAL	Stock	31.8	31.99	31.1	31.8	6900100.0
2019-01-11	AAM.A-DELISTED	Stock	24.03	24.1	23.9	24.04	30091.0
2019-01-11	AAM.B-DELISTED	Stock	23.7387	24.07	23.7387	24.05	35889.0
2019-01-11	AAMC-DELISTED	Stock	8.8439	8.9676	8.8439	8.9676	1550.0
2019-01-11	AAME	Stock	2.6	2.6	2.6	2.6	1800.0
2019-01-11	AAMI	Stock	11.25	11.525	10.97	11.33	663900.0
2019-01-11	AAOI	Stock	16.21	16.48	15.912	16.39	516800.0
2019-01-11	AAON	Stock	23.9667	24.06	23.72	23.8867	159300.0
2019-01-11	AAP	Stock	164.51	166.43	159.25	159.42	1299600.0
2019-01-11	AAT	Stock	40.97	41.14	40.69	40.92	199100.0
2019-01-11	AAU-DELISTED	Stock	0.8888	0.8888	0.8162	0.83	248273.0
2019-01-11	AAUAF-DELISTED	Stock	0.8888	0.8888	0.8162	0.83	272683.0
2019-01-11	AAWW-DELISTED	Stock	47.43	48.79	43.9704	48.51	266389.0
2019-01-11	AAXJ	Stock	65.28	65.55	65.17	65.47	1019251.0
2019-01-11	AAXN-DELISTED	Stock	49.56	49.89	48.499	49.43	359921.0
2019-01-11	AB	Stock	28.11	28.56	27.92	28.47	492400.0
2019-01-11	ABAC-DELISTED	Stock	1.2668	1.27	1.24	1.24	7265.0
2019-01-11	ABB-DELISTED	Stock	19.35	19.49	19.26	19.41	1757203.0
2019-01-11	ABBNY-DELISTED	Stock	19.35	19.49	19.26	19.4	3807686.0
2019-01-11	ABBV	Stock	87.54	88.31	87.54	88.31	5318100.0
2019-01-11	ABC-DELISTED	Stock	75.64	76.62	74.875	76.56	831685.0
2019-01-11	ABCB	Stock	34.11	34.91	33.82	34.81	268000.0
2019-01-11	ABDC-DELISTED	Stock	6.76	6.96	6.76	6.78	32483.0
2019-01-11	ABEO	Stock	180.25	181.25	176.75	178.5	10444.0
2019-01-11	ABEOW-DELISTED	Stock	2.8	2.8	2.8	2.8	100.0
2019-01-11	ABEV	Stock	4.54	4.65	4.53	4.63	45870600.0
2019-01-11	ABG	Stock	68.76	70.19	67.88	69.64	145500.0
2019-01-11	ABIL-DELISTED	Stock	1.86	1.9	1.85	1.8827	76878.0
2019-01-11	ABM	Stock	34.1	34.78	33.51	34.28	901300.0
2019-01-11	ABMD-DELISTED	Stock	332.77	334.1979	320.52	323.75	361483.0
2019-01-11	ABR	Stock	11.32	11.43	11.24	11.32	655500.0
2019-01-11	ABR.A-DELISTED	Stock	25.36	25.5192	25.36	25.5082	1999.0
2019-01-11	ABT	Stock	68.6	69.36	68.45	69.33	6583000.0
2019-01-11	ABTC	Stock	302700.0	303930.0	302700.0	303330.0	0.013333333333333334

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

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