PREVIEW / stock_daily / 2018-06-28

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-28.parquet
  size:    219 KB
  rows:    6,534
  symbols: 2,804

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-06-28	AAPL	Stock	46.025	46.5525	45.95	46.375	69460800.0
2018-06-28	MSFT	Stock	97.38	99.11	97.26	98.63	26650700.0
2018-06-28	NVDA	Stock	5.883	6.0335	5.8752	6.0215	338012000.0
2018-06-28	AMZN	Stock	83.627	85.275	83.0585	85.0725	90594000.0
2018-06-28	GOOGL	Stock	55.6195	56.7	55.3036	56.339	29733500.0
2018-06-28	META	Stock	195.18	197.34	193.26	196.23	18172400.0
2018-06-28	TSLA	Stock	23.244	23.8013	23.074	23.3287	125970000.0
2018-06-28	TLT	Stock	122.13	122.2452	121.83	122.14	7109543.0
2018-06-28	ES	Stock	58.15	58.53	57.96	58.28	1762100.0
2018-06-28	CL	Stock	64.65	64.98	64.33	64.93	2891900.0
2018-06-28	A	Stock	61.13	61.64	60.42	61.29	1564100.0
2018-06-28	AA	Stock	45.23	46.68	45.074	46.47	2273000.0
2018-06-28	AABA-DELISTED	Stock	72.7	74.61	71.98	74.44	7114106.0
2018-06-28	AAC-DELISTED	Stock	9.19	9.36	8.91	9.19	131437.0
2018-06-28	AACG	Stock	4.98	5.01	4.96	5.01	1600.0
2018-06-28	AAIC-DELISTED	Stock	10.3	10.455	10.21	10.42	1021948.0
2018-06-28	AAL	Stock	38.33	38.53	37.06	38.2	7909700.0
2018-06-28	AAM.A-DELISTED	Stock	25.1816	25.32	25.1816	25.2769	20000.0
2018-06-28	AAM.B-DELISTED	Stock	24.78	24.88	24.69	24.87	60722.0
2018-06-28	AAMC-DELISTED	Stock	19.8529	20.2941	19.8529	20.2941	2438.0
2018-06-28	AAMI	Stock	14.44	14.6	14.34	14.34	424500.0
2018-06-28	AAOI	Stock	41.2	43.13	40.665	42.63	571800.0
2018-06-28	AAON	Stock	22.0	22.1667	21.7	22.1333	261150.0
2018-06-28	AAP	Stock	134.2	136.18	133.32	135.11	1039800.0
2018-06-28	AAT	Stock	38.2	38.49	38.09	38.3	293000.0
2018-06-28	AAU-DELISTED	Stock	0.7179	0.7279	0.7114	0.7197	48508.0
2018-06-28	AAUAF-DELISTED	Stock	0.7179	0.7279	0.7114	0.7152	51826.0
2018-06-28	AAV-DELISTED	Stock	3.25	3.25	3.075	3.15	208209.0
2018-06-28	AAWW-DELISTED	Stock	69.15	70.975	68.1	70.4	167105.0
2018-06-28	AAXJ	Stock	70.04	70.77	70.0	70.72	973115.0
2018-06-28	AAXN-DELISTED	Stock	61.84	64.42	61.75	64.05	448850.0
2018-06-28	AB	Stock	28.35	28.75	28.35	28.7	281400.0
2018-06-28	ABAC-DELISTED	Stock	2.61	3.0076	2.56	2.7906	72875.0
2018-06-28	ABAX-DELISTED	Stock	83.0	83.15	82.93	83.15	390233.0
2018-06-28	ABB-DELISTED	Stock	21.34	21.475	21.2155	21.455	1399380.0
2018-06-28	ABBNY-DELISTED	Stock	21.34	21.475	21.2155	21.45	1469954.0
2018-06-28	ABBV	Stock	91.34	92.61	90.81	92.43	6698900.0
2018-06-28	ABC-DELISTED	Stock	83.24	86.76	82.14	86.1	4530390.0
2018-06-28	ABCB	Stock	54.0	54.55	53.75	54.0	115000.0
2018-06-28	ABCD-DELISTED	Stock	10.67	11.09	10.67	11.08	106560.0
2018-06-28	ABDC-DELISTED	Stock	6.5	6.5	6.2	6.26	88810.0
2018-06-28	ABEO	Stock	392.5	412.5	382.5	411.25	27440.0
2018-06-28	ABEOW-DELISTED	Stock	11.18	11.18	11.1583	11.1583	200.0
2018-06-28	ABEV	Stock	4.67	4.74	4.65	4.69	31576700.0
2018-06-28	ABG	Stock	69.25	70.55	69.25	70.15	145400.0
2018-06-28	ABIL-DELISTED	Stock	8.37	8.37	5.85	7.15	658509.0
2018-06-28	ABM	Stock	29.65	29.76	29.22	29.31	376700.0
2018-06-28	ABMD-DELISTED	Stock	409.09	417.4992	398.0	413.94	530918.0
2018-06-28	ABR	Stock	10.2	10.67	10.2	10.45	9127100.0
2018-06-28	ABR.A-DELISTED	Stock	25.94	26.0	25.94	26.0	5441.0

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

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