PREVIEW / stock_daily / 2019-06-28

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-28.parquet
  size:    223 KB
  rows:    6,611
  symbols: 2,577

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-06-28	AAPL	Stock	49.67	49.875	49.2625	49.48	124442400.0
2019-06-28	MSFT	Stock	134.57	134.6	133.16	133.96	30043000.0
2019-06-28	NVDA	Stock	4.125	4.1343	4.0588	4.1057	397668000.0
2019-06-28	AMZN	Stock	95.455	95.647	94.2	94.6815	60748000.0
2019-06-28	GOOGL	Stock	53.8615	54.14	53.69	54.14	33671360.0
2019-06-28	META	Stock	190.55	193.2	189.94	193.0	16378900.0
2019-06-28	TSLA	Stock	14.7327	15.0113	14.72	14.8973	102771000.0
2019-06-28	TLT	Stock	132.58	133.08	132.4458	132.81	8149205.0
2019-06-28	ES	Stock	75.36	76.07	75.27	75.76	2590700.0
2019-06-28	CL	Stock	72.52	72.76	71.4	71.67	5443800.0
2019-06-28	A	Stock	73.26	74.7	73.1	74.67	3159700.0
2019-06-28	AA	Stock	23.1	23.42	22.85	23.41	2910100.0
2019-06-28	AABA-DELISTED	Stock	69.99	70.05	69.0	69.41	7750672.0
2019-06-28	AAC-DELISTED	Stock	0.86	0.89	0.801	0.8869	1538098.0
2019-06-28	AACG	Stock	2.9	3.24	2.66	2.7	6597100.0
2019-06-28	AAIC-DELISTED	Stock	6.77	6.925	6.77	6.88	1456687.0
2019-06-28	AAIC.C-DELISTED	Stock	21.55	21.69	21.53	21.57	4440.0
2019-06-28	AAL	Stock	32.23	32.73	32.16	32.61	5238500.0
2019-06-28	AAM.A-DELISTED	Stock	25.67	25.878	25.61	25.61	39452.0
2019-06-28	AAM.B-DELISTED	Stock	25.88	25.9399	25.795	25.86	54104.0
2019-06-28	AAMC-DELISTED	Stock	4.0853	4.2353	3.2382	3.3824	79247.0
2019-06-28	AAME	Stock	2.45	2.49	2.45	2.45	600.0
2019-06-28	AAMI	Stock	11.21	11.495	11.21	11.41	3203400.0
2019-06-28	AAOI	Stock	10.64	10.89	10.23	10.28	1465000.0
2019-06-28	AAON	Stock	33.02	34.1067	33.02	33.4533	501000.0
2019-06-28	AAP	Stock	151.98	154.45	151.4	154.14	950000.0
2019-06-28	AAT	Stock	46.3	47.2	46.2	47.12	3985000.0
2019-06-28	AAU-DELISTED	Stock	0.59	0.6022	0.578	0.59	306667.0
2019-06-28	AAUAF-DELISTED	Stock	0.59	0.6022	0.578	0.59	324216.0
2019-06-28	AAWW-DELISTED	Stock	43.98	44.69	43.0	44.63	272965.0
2019-06-28	AAXJ	Stock	69.89	69.93	69.64	69.79	2508897.0
2019-06-28	AAXN-DELISTED	Stock	66.7	66.79	64.08	64.11	8616319.0
2019-06-28	AB	Stock	29.3	29.73	29.02	29.72	218600.0
2019-06-28	ABB-DELISTED	Stock	19.93	20.07	19.92	20.035	907636.0
2019-06-28	ABBNY-DELISTED	Stock	19.93	20.07	19.92	20.03	1563599.0
2019-06-28	ABBV	Stock	70.58	72.74	70.33	72.72	21381500.0
2019-06-28	ABC-DELISTED	Stock	85.83	86.26	85.055	85.28	1289581.0
2019-06-28	ABCB	Stock	39.17	39.6	38.51	39.19	4545600.0
2019-06-28	ABDC-DELISTED	Stock	8.36	8.3757	8.3	8.33	41486.0
2019-06-28	ABEO	Stock	119.5	123.0	118.5	119.5	76672.0
2019-06-28	ABEOW-DELISTED	Stock	0.94	1.02	0.94	1.02	1400.0
2019-06-28	ABEV	Stock	4.73	4.75	4.65	4.67	20768600.0
2019-06-28	ABG	Stock	84.16	85.66	83.67	84.34	244800.0
2019-06-28	ABIL-DELISTED	Stock	0.9266	0.93	0.89	0.92	16601.0
2019-06-28	ABM	Stock	39.72	40.48	39.72	40.0	697600.0
2019-06-28	ABMD-DELISTED	Stock	256.63	260.59	253.76	260.48	316182.0
2019-06-28	ABR	Stock	11.81	12.18	11.81	12.12	10599100.0
2019-06-28	ABR.B-DELISTED	Stock	25.65	25.65	25.65	25.65	400.0
2019-06-28	ABR.C-DELISTED	Stock	25.9674	26.0369	25.9638	26.0369	1127.0
2019-06-28	ABT	Stock	83.82	84.26	83.12	84.1	16436700.0

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

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