PREVIEW / stock_daily / 2019-03-13

all stock daily files

  file:    by_date/stock_daily/2019/2019-03-13.parquet
  size:    219 KB
  rows:    6,522
  symbols: 2,603

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-03-13	AAPL	Stock	45.5625	45.825	45.23	45.4275	124130000.0
2019-03-13	MSFT	Stock	114.13	115.0	113.78	114.5	35513800.0
2019-03-13	NVDA	Stock	4.1008	4.245	4.0932	4.2155	768900000.0
2019-03-13	AMZN	Stock	84.15	85.0	83.9675	84.5405	71040000.0
2019-03-13	GOOGL	Stock	60.2965	60.3562	59.8955	59.953	25887080.0
2019-03-13	META	Stock	172.32	174.03	172.12	173.37	11973300.0
2019-03-13	TSLA	Stock	18.9267	19.466	18.8467	19.264	102670500.0
2019-03-13	TLT	Stock	121.66	121.96	121.62	121.83	4386732.0
2019-03-13	ES	Stock	70.37	70.83	70.28	70.6	1385500.0
2019-03-13	CL	Stock	65.81	66.61	65.81	66.52	3894700.0
2019-03-13	A	Stock	80.22	80.74	80.02	80.13	1529100.0
2019-03-13	AA	Stock	28.62	29.32	28.56	28.98	3670400.0
2019-03-13	AABA-DELISTED	Stock	73.76	74.36	73.25	73.65	2476429.0
2019-03-13	AAC-DELISTED	Stock	2.79	2.81	2.35	2.73	353232.0
2019-03-13	AACG	Stock	1.06	1.08	1.04	1.07	23100.0
2019-03-13	AAIC-DELISTED	Stock	8.12	8.32	8.12	8.25	438654.0
2019-03-13	AAL	Stock	31.22	31.93	31.0	31.84	11092900.0
2019-03-13	AAM.A-DELISTED	Stock	25.11	25.14	25.02	25.03	31858.0
2019-03-13	AAM.B-DELISTED	Stock	24.84	24.9	24.8187	24.85	35877.0
2019-03-13	AAMC-DELISTED	Stock	10.2941	10.4853	10.2941	10.4853	3672.0
2019-03-13	AAME	Stock	2.51	2.71	2.31	2.7	5800.0
2019-03-13	AAMI	Stock	13.69	13.89	13.62	13.76	381600.0
2019-03-13	AAOI	Stock	13.76	14.77	13.7	14.08	2287800.0
2019-03-13	AAON	Stock	27.7667	28.2733	27.76	27.96	133800.0
2019-03-13	AAP	Stock	155.25	155.8	153.79	154.7	812400.0
2019-03-13	AAT	Stock	45.54	46.28	45.46	46.2	263800.0
2019-03-13	AAU-DELISTED	Stock	0.624	0.624	0.6	0.61	162530.0
2019-03-13	AAUAF-DELISTED	Stock	0.624	0.624	0.6	0.619	167100.0
2019-03-13	AAWW-DELISTED	Stock	49.53	50.4	49.52	49.81	280558.0
2019-03-13	AAXJ	Stock	69.79	69.87	69.62	69.7	1390665.0
2019-03-13	AAXN-DELISTED	Stock	48.5	48.9	47.5393	47.6	407781.0
2019-03-13	AB	Stock	29.13	29.43	29.1	29.14	197300.0
2019-03-13	ABB-DELISTED	Stock	19.1	19.26	19.05	19.225	1572814.0
2019-03-13	ABBNY-DELISTED	Stock	19.1	19.26	19.05	19.22	1621415.0
2019-03-13	ABBV	Stock	78.92	79.3	78.15	78.93	5984500.0
2019-03-13	ABC-DELISTED	Stock	79.04	80.26	78.68	79.79	856169.0
2019-03-13	ABCB	Stock	38.42	38.49	38.1	38.33	218600.0
2019-03-13	ABDC-DELISTED	Stock	7.67	7.76	7.52	7.72	47244.0
2019-03-13	ABEO	Stock	193.25	193.25	183.0	185.75	10724.0
2019-03-13	ABEV	Stock	4.4	4.41	4.33	4.38	21723800.0
2019-03-13	ABG	Stock	68.24	69.48	68.24	69.0	143200.0
2019-03-13	ABIL-DELISTED	Stock	1.85	1.85	1.8	1.81	93768.0
2019-03-13	ABM	Stock	33.44	33.94	33.13	33.85	346500.0
2019-03-13	ABMD-DELISTED	Stock	323.43	329.54	322.235	325.62	171569.0
2019-03-13	ABR	Stock	12.81	12.9	12.77	12.79	863900.0
2019-03-13	ABR.A-DELISTED	Stock	25.7515	25.77	25.44	25.7282	5027.0
2019-03-13	ABR.B-DELISTED	Stock	25.8633	25.8633	25.8	25.8	1500.0
2019-03-13	ABR.C-DELISTED	Stock	25.75	25.7999	25.75	25.765	2050.0
2019-03-13	ABT	Stock	78.67	79.15	78.07	78.62	6479200.0
2019-03-13	ABTC	Stock	304500.0	304500.0	303900.0	304200.0	0.32

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

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