PREVIEW / stock_daily / 2018-06-11

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-11.parquet
  size:    218 KB
  rows:    6,518
  symbols: 2,793

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-11	AAPL	Stock	47.8375	47.9925	47.5525	47.8075	73234000.0
2018-06-11	MSFT	Stock	101.01	101.59	100.67	101.05	23490900.0
2018-06-11	NVDA	Stock	6.5442	6.5862	6.5025	6.5155	265372000.0
2018-06-11	AMZN	Stock	84.0755	84.712	84.0295	84.456	46710000.0
2018-06-11	GOOGL	Stock	56.647	57.387	56.5699	57.045	24795400.0
2018-06-11	META	Stock	188.81	192.6	188.8	191.54	12928900.0
2018-06-11	TSLA	Stock	21.5007	22.3107	21.5	22.14	197752500.0
2018-06-11	TLT	Stock	119.07	119.391	118.94	119.31	6844224.0
2018-06-11	ES	Stock	53.61	53.63	52.76	52.87	1835600.0
2018-06-11	CL	Stock	63.35	63.91	63.35	63.75	3220300.0
2018-06-11	A	Stock	65.68	66.75	65.59	66.13	3316700.0
2018-06-11	AA	Stock	48.5	50.59	48.18	49.92	4973500.0
2018-06-11	AABA-DELISTED	Stock	80.7	81.45	80.5	80.69	9119417.0
2018-06-11	AAC-DELISTED	Stock	10.34	10.63	10.31	10.34	99396.0
2018-06-11	AACG	Stock	5.12	5.12	5.12	5.12	300.0
2018-06-11	AAIC-DELISTED	Stock	11.23	11.23	11.03	11.16	1020101.0
2018-06-11	AAL	Stock	43.25	44.93	43.25	44.16	6440700.0
2018-06-11	AAM.A-DELISTED	Stock	25.51	25.5588	25.41	25.5	56847.0
2018-06-11	AAM.B-DELISTED	Stock	24.89	24.89	24.6	24.76	163940.0
2018-06-11	AAME	Stock	2.7	2.7	2.65	2.65	2000.0
2018-06-11	AAMI	Stock	15.92	16.34	15.89	16.24	546000.0
2018-06-11	AAOI	Stock	43.07	43.38	41.302	42.52	3258600.0
2018-06-11	AAON	Stock	22.1333	22.3667	21.92	21.9333	435450.0
2018-06-11	AAP	Stock	132.24	133.18	131.34	132.73	875600.0
2018-06-11	AAT	Stock	37.22	37.43	37.17	37.31	116100.0
2018-06-11	AAU-DELISTED	Stock	0.75	0.755	0.7375	0.7472	115374.0
2018-06-11	AAUAF-DELISTED	Stock	0.75	0.755	0.7375	0.7472	124345.0
2018-06-11	AAV-DELISTED	Stock	3.1	3.2	3.075	3.075	218542.0
2018-06-11	AAWW-DELISTED	Stock	71.2	74.75	71.1	73.85	331037.0
2018-06-11	AAXJ	Stock	77.7	77.8	77.52	77.71	2515822.0
2018-06-11	AAXN-DELISTED	Stock	65.43	66.18	64.34	65.2	611303.0
2018-06-11	AB	Stock	29.25	29.58	29.2	29.5	234300.0
2018-06-11	ABAC-DELISTED	Stock	2.37	2.44	2.2422	2.34	7427.0
2018-06-11	ABAX-DELISTED	Stock	83.16	83.28	82.94	82.995	99844.0
2018-06-11	ABB-DELISTED	Stock	23.18	23.36	23.15	23.345	956476.0
2018-06-11	ABBNY-DELISTED	Stock	23.18	23.36	23.15	23.35	992793.0
2018-06-11	ABBV	Stock	100.56	101.08	99.41	99.77	5770100.0
2018-06-11	ABC-DELISTED	Stock	86.25	87.86	86.13	87.29	1252040.0
2018-06-11	ABCB	Stock	57.5	58.1	57.45	57.8	266900.0
2018-06-11	ABCD-DELISTED	Stock	10.6	10.87	10.58	10.79	104002.0
2018-06-11	ABDC-DELISTED	Stock	6.75	6.785	6.68	6.74	28695.0
2018-06-11	ABEO	Stock	407.5	413.0	395.0	396.25	24144.0
2018-06-11	ABEV	Stock	5.11	5.19	5.04	5.08	24479000.0
2018-06-11	ABG	Stock	74.35	75.5	74.25	75.15	123800.0
2018-06-11	ABIL-DELISTED	Stock	2.33	2.4495	2.33	2.42	10109.0
2018-06-11	ABLX-DELISTED	Stock	52.61	52.9056	52.6	52.7601	1602.0
2018-06-11	ABM	Stock	30.25	31.21	30.25	30.7	1677500.0
2018-06-11	ABMD-DELISTED	Stock	409.77	420.07	408.46	418.23	270261.0
2018-06-11	ABR	Stock	9.57	9.78	9.57	9.76	1804300.0
2018-06-11	ABR.A-DELISTED	Stock	25.7	25.7	25.7	25.7	174.0

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

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