PREVIEW / stock_daily / 2018-06-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-12.parquet
  size:    219 KB
  rows:    6,504
  symbols: 2,786

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-12	AAPL	Stock	47.8475	48.1525	47.7875	48.07	67644400.0
2018-06-12	MSFT	Stock	101.1	101.45	100.75	101.31	18325200.0
2018-06-12	NVDA	Stock	6.5422	6.5768	6.4915	6.5645	319160000.0
2018-06-12	AMZN	Stock	84.65	84.9755	84.576	84.9375	45184000.0
2018-06-12	GOOGL	Stock	57.051	57.4375	57.051	57.4095	26092240.0
2018-06-12	META	Stock	192.17	193.28	191.56	192.4	11562700.0
2018-06-12	TSLA	Stock	22.98	23.6647	22.5333	22.8513	335211000.0
2018-06-12	TLT	Stock	118.93	119.46	118.89	119.34	6048154.0
2018-06-12	ES	Stock	52.83	53.88	52.79	53.68	2003100.0
2018-06-12	CL	Stock	63.75	64.04	63.48	63.73	3355500.0
2018-06-12	A	Stock	65.97	66.55	65.63	66.32	2007000.0
2018-06-12	AA	Stock	49.98	50.13	49.11	49.29	1561800.0
2018-06-12	AABA-DELISTED	Stock	81.11	82.2	81.11	81.72	10375500.0
2018-06-12	AAC-DELISTED	Stock	10.37	10.46	10.12	10.31	81198.0
2018-06-12	AACG	Stock	5.24	5.24	5.13	5.13	1200.0
2018-06-12	AAIC-DELISTED	Stock	11.17	11.26	11.13	11.17	549725.0
2018-06-12	AAL	Stock	44.23	44.3	43.09	43.41	5204600.0
2018-06-12	AAM.A-DELISTED	Stock	25.41	25.55	25.41	25.49	28183.0
2018-06-12	AAM.B-DELISTED	Stock	24.76	24.83	24.65	24.69	56932.0
2018-06-12	AAMC-DELISTED	Stock	20.8824	21.0	20.0	20.7059	15851.0
2018-06-12	AAME	Stock	2.67	2.7	2.6	2.6	6800.0
2018-06-12	AAMI	Stock	16.23	16.3	16.01	16.04	415900.0
2018-06-12	AAOI	Stock	42.5	44.15	41.82	43.52	962300.0
2018-06-12	AAON	Stock	21.9	22.4	21.5667	22.3333	410400.0
2018-06-12	AAP	Stock	133.65	134.75	132.83	133.64	887700.0
2018-06-12	AAT	Stock	37.27	37.8	37.24	37.58	178000.0
2018-06-12	AAU-DELISTED	Stock	0.76	0.7716	0.74	0.7433	93814.0
2018-06-12	AAUAF-DELISTED	Stock	0.76	0.7716	0.74	0.7433	99633.0
2018-06-12	AAV-DELISTED	Stock	3.1	3.15	3.05	3.075	108682.0
2018-06-12	AAWW-DELISTED	Stock	73.85	75.2911	72.6	74.0	227569.0
2018-06-12	AAXJ	Stock	77.72	77.725	77.17	77.47	345128.0
2018-06-12	AAXN-DELISTED	Stock	65.14	66.42	64.75	65.28	584035.0
2018-06-12	AB	Stock	29.5	29.55	29.1	29.25	261800.0
2018-06-12	ABAC-DELISTED	Stock	2.33	2.3522	2.24	2.25	2814.0
2018-06-12	ABAX-DELISTED	Stock	83.1	83.18	82.98	83.01	103334.0
2018-06-12	ABB-DELISTED	Stock	23.42	23.52	23.31	23.35	2326076.0
2018-06-12	ABBNY-DELISTED	Stock	23.42	23.52	23.31	23.35	2494589.0
2018-06-12	ABBV	Stock	99.8	100.12	98.74	98.91	8060400.0
2018-06-12	ABC-DELISTED	Stock	87.44	88.05	86.25	88.05	876183.0
2018-06-12	ABCB	Stock	57.85	58.1	56.25	56.65	185200.0
2018-06-12	ABCD-DELISTED	Stock	10.75	11.0	10.64	10.69	97639.0
2018-06-12	ABDC-DELISTED	Stock	6.73	6.74	6.66	6.68	30459.0
2018-06-12	ABEO	Stock	398.75	416.25	398.75	412.5	27156.0
2018-06-12	ABEV	Stock	5.07	5.14	5.04	5.05	23436500.0
2018-06-12	ABG	Stock	76.3	76.3	73.9	74.5	257200.0
2018-06-12	ABIL-DELISTED	Stock	2.44	2.44	2.384	2.39	2939.0
2018-06-12	ABLX-DELISTED	Stock	52.92	53.155	52.8	52.87	14293.0
2018-06-12	ABM	Stock	30.82	31.17	30.48	31.09	1269300.0
2018-06-12	ABMD-DELISTED	Stock	420.0	432.375	419.0	430.84	553307.0
2018-06-12	ABR	Stock	9.75	9.9	9.74	9.89	1400000.0

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

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