PREVIEW / stock_daily / 2018-08-15

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-15.parquet
  size:    220 KB
  rows:    6,516
  symbols: 2,759

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-15	AAPL	Stock	52.305	52.685	52.0825	52.56	115230400.0
2018-08-15	MSFT	Stock	108.49	108.99	106.82	107.66	29982800.0
2018-08-15	NVDA	Stock	6.5568	6.591	6.3975	6.477	591136000.0
2018-08-15	AMZN	Stock	95.4775	95.8105	93.4895	94.131	154014000.0
2018-08-15	GOOGL	Stock	62.214	62.599	61.3122	61.611	37051160.0
2018-08-15	META	Stock	179.34	180.87	174.78	179.53	33020200.0
2018-08-15	TSLA	Stock	22.794	22.966	22.1427	22.5793	136519500.0
2018-08-15	TLT	Stock	120.66	121.13	120.57	120.84	7649988.0
2018-08-15	ES	Stock	61.92	62.75	61.78	62.34	1294400.0
2018-08-15	CL	Stock	65.44	65.91	65.12	65.83	4245700.0
2018-08-15	A	Stock	65.94	66.39	64.22	64.73	6071500.0
2018-08-15	AA	Stock	43.18	43.37	40.69	40.88	5392400.0
2018-08-15	AABA-DELISTED	Stock	66.18	67.11	65.78	67.04	8137730.0
2018-08-15	AAC-DELISTED	Stock	9.77	9.975	9.68	9.87	144602.0
2018-08-15	AACG	Stock	6.79	6.79	6.55	6.7	38800.0
2018-08-15	AAIC-DELISTED	Stock	10.11	10.18	10.03	10.12	392090.0
2018-08-15	AAL	Stock	36.96	37.51	36.42	37.44	5599200.0
2018-08-15	AAM.A-DELISTED	Stock	25.48	25.48	25.36	25.4703	22591.0
2018-08-15	AAM.B-DELISTED	Stock	25.08	25.14	25.0592	25.14	41796.0
2018-08-15	AAMC-DELISTED	Stock	19.4853	19.4853	18.9118	18.9118	1469.0
2018-08-15	AAME	Stock	2.85	2.85	2.8	2.8	1100.0
2018-08-15	AAMI	Stock	12.61	12.76	12.435	12.59	683600.0
2018-08-15	AAOI	Stock	41.25	41.66	40.05	41.34	786200.0
2018-08-15	AAON	Stock	26.4667	26.7	26.1667	26.6333	127050.0
2018-08-15	AAP	Stock	157.98	158.74	155.63	158.03	1503100.0
2018-08-15	AAT	Stock	38.7	39.13	38.55	38.97	108500.0
2018-08-15	AAU-DELISTED	Stock	0.61	0.625	0.6	0.6	234218.0
2018-08-15	AAUAF-DELISTED	Stock	0.61	0.625	0.6	0.6	244550.0
2018-08-15	AAV-DELISTED	Stock	3.15	3.15	2.855	2.9	176280.0
2018-08-15	AAWW-DELISTED	Stock	59.7	59.95	58.3	58.55	443577.0
2018-08-15	AAXJ	Stock	68.28	68.5931	67.86	68.45	1388094.0
2018-08-15	AAXN-DELISTED	Stock	61.26	62.55	59.72	61.02	651382.0
2018-08-15	AB	Stock	29.7	29.9	29.5	29.65	211400.0
2018-08-15	ABAC-DELISTED	Stock	2.1796	2.1796	2.03	2.03	19963.0
2018-08-15	ABB-DELISTED	Stock	22.16	22.16	21.95	22.115	4890872.0
2018-08-15	ABBNY-DELISTED	Stock	22.16	22.16	21.95	22.12	5567579.0
2018-08-15	ABBV	Stock	95.92	97.79	95.61	97.45	6861500.0
2018-08-15	ABC-DELISTED	Stock	83.94	85.15	83.01	85.11	1181372.0
2018-08-15	ABCB	Stock	49.05	49.55	48.65	48.7	255100.0
2018-08-15	ABCD-DELISTED	Stock	11.97	13.0	11.95	12.94	317940.0
2018-08-15	ABDC-DELISTED	Stock	6.17	6.25	6.15	6.23	48813.0
2018-08-15	ABEO	Stock	323.75	331.25	320.0	326.25	25012.0
2018-08-15	ABEV	Stock	4.94	5.03	4.89	4.98	43860000.0
2018-08-15	ABG	Stock	74.95	74.95	73.8	74.4	239300.0
2018-08-15	ABIL-DELISTED	Stock	4.75	5.33	4.65	5.0	1327361.0
2018-08-15	ABM	Stock	31.14	31.34	30.87	31.15	596100.0
2018-08-15	ABMD-DELISTED	Stock	367.36	369.7263	353.67	363.62	346077.0
2018-08-15	ABR	Stock	11.42	11.44	11.26	11.41	1382500.0
2018-08-15	ABR.A-DELISTED	Stock	25.82	25.833	25.8199	25.8199	1600.0
2018-08-15	ABR.B-DELISTED	Stock	25.311	25.3213	25.311	25.3213	1000.0

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

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