PREVIEW / stock_daily / 2018-08-14

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-14.parquet
  size:    218 KB
  rows:    6,520
  symbols: 2,776

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-08-14	AAPL	Stock	52.54	52.64	52.065	52.4375	82992000.0
2018-08-14	MSFT	Stock	108.56	109.75	108.04	109.56	16788300.0
2018-08-14	NVDA	Stock	6.5095	6.55	6.4255	6.5358	466220000.0
2018-08-14	AMZN	Stock	95.9695	96.0505	95.0	95.9825	79722000.0
2018-08-14	GOOGL	Stock	62.625	63.0295	61.977	62.907	28079820.0
2018-08-14	META	Stock	180.71	181.99	178.62	181.11	19102000.0
2018-08-14	TSLA	Stock	23.8967	23.9467	23.14	23.176	104796000.0
2018-08-14	TLT	Stock	120.54	120.56	120.03	120.14	4251313.0
2018-08-14	ES	Stock	61.57	62.15	61.54	61.8	1091600.0
2018-08-14	CL	Stock	65.56	65.9	65.49	65.52	2532400.0
2018-08-14	A	Stock	66.05	67.26	66.05	66.75	3110100.0
2018-08-14	AA	Stock	44.36	44.56	43.76	44.13	3399500.0
2018-08-14	AABA-DELISTED	Stock	69.89	69.89	67.83	68.14	11276200.0
2018-08-14	AAC-DELISTED	Stock	9.41	9.81	9.36	9.76	245922.0
2018-08-14	AACG	Stock	6.29	6.8	6.23	6.65	120700.0
2018-08-14	AAIC-DELISTED	Stock	10.18	10.23	10.15	10.16	337172.0
2018-08-14	AAL	Stock	36.84	37.56	36.83	37.09	3873000.0
2018-08-14	AAM.A-DELISTED	Stock	25.48	25.53	25.45	25.475	43342.0
2018-08-14	AAM.B-DELISTED	Stock	25.09	25.09	25.0201	25.06	23959.0
2018-08-14	AAMC-DELISTED	Stock	19.0147	19.0147	19.0147	19.0147	340.0
2018-08-14	AAME	Stock	2.65	2.9	2.4	2.4	17200.0
2018-08-14	AAMI	Stock	12.38	12.69	12.38	12.68	685000.0
2018-08-14	AAOI	Stock	42.73	43.18	41.15	41.68	973000.0
2018-08-14	AAON	Stock	26.1	26.6333	26.0	26.5	103200.0
2018-08-14	AAP	Stock	153.34	159.5	152.32	156.13	4487600.0
2018-08-14	AAT	Stock	38.32	38.75	38.32	38.61	116500.0
2018-08-14	AAU-DELISTED	Stock	0.62	0.63	0.6099	0.61	173805.0
2018-08-14	AAUAF-DELISTED	Stock	0.62	0.63	0.6099	0.61	199341.0
2018-08-14	AAV-DELISTED	Stock	3.1	3.25	3.1	3.15	81515.0
2018-08-14	AAWW-DELISTED	Stock	60.25	60.9	59.7	59.9	108269.0
2018-08-14	AAXJ	Stock	70.24	70.44	70.04	70.29	554638.0
2018-08-14	AAXN-DELISTED	Stock	61.1	62.59	60.83	62.34	408910.0
2018-08-14	AB	Stock	29.5	29.95	29.4	29.8	291500.0
2018-08-14	ABAC-DELISTED	Stock	2.1665	2.1665	2.1665	2.1665	324.0
2018-08-14	ABB-DELISTED	Stock	22.55	22.57	22.455	22.505	2292587.0
2018-08-14	ABBNY-DELISTED	Stock	22.55	22.57	22.455	22.51	2693026.0
2018-08-14	ABBV	Stock	96.72	97.35	95.74	95.92	5580800.0
2018-08-14	ABC-DELISTED	Stock	83.15	85.13	83.12	84.43	1022512.0
2018-08-14	ABCB	Stock	48.55	49.45	48.35	49.25	172300.0
2018-08-14	ABCD-DELISTED	Stock	11.68	12.19	11.5775	11.92	215755.0
2018-08-14	ABDC-DELISTED	Stock	6.21	6.24	6.1001	6.22	18783.0
2018-08-14	ABEO	Stock	325.0	332.5	319.5	325.0	19344.0
2018-08-14	ABEOW-DELISTED	Stock	8.3	8.3	8.3	8.3	100.0
2018-08-14	ABEV	Stock	4.94	5.03	4.92	5.01	34655100.0
2018-08-14	ABG	Stock	74.7	75.85	74.55	75.0	224300.0
2018-08-14	ABIL-DELISTED	Stock	5.39	5.5	4.35	4.61	1752370.0
2018-08-14	ABM	Stock	30.85	31.4	30.71	31.19	570600.0
2018-08-14	ABMD-DELISTED	Stock	368.42	372.37	361.87	371.24	288232.0
2018-08-14	ABR	Stock	11.3	11.47	11.23	11.44	1498800.0
2018-08-14	ABR.A-DELISTED	Stock	25.7	25.81	25.7	25.81	605.0

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

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