PREVIEW / stock_daily / 2015-07-06

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-06.parquet
  size:    224 KB
  rows:    6,657
  symbols: 3,487

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
2015-07-06	AAPL	Stock	31.235	31.5575	31.2125	31.5	112241600.0
2015-07-06	MSFT	Stock	43.96	44.48	43.95	44.39	23034000.0
2015-07-06	NVDA	Stock	0.5062	0.5133	0.5005	0.5043	214776000.0
2015-07-06	AMZN	Stock	21.7615	21.9865	21.676	21.802	38064000.0
2015-07-06	GOOGL	Stock	27.1125	27.429	27.1048	27.281	25613740.0
2015-07-06	META	Stock	86.49	88.19	86.39	87.55	24635900.0
2015-07-06	TSLA	Stock	18.592	18.7793	18.42	18.648	61828500.0
2015-07-06	TLT	Stock	118.05	118.65	117.06	118.15	10605806.0
2015-07-06	ES	Stock	44.88	46.55	44.64	46.31	7597500.0
2015-07-06	CL	Stock	65.68	66.31	65.63	65.96	1835600.0
2015-07-06	A	Stock	39.11	39.66	39.08	39.36	2509400.0
2015-07-06	AA.B-DELISTED	Stock	40.01	40.4	39.62	40.1099	29598.0
2015-07-06	AABA-DELISTED	Stock	38.76	39.12	38.46	38.61	11230003.0
2015-07-06	AAC-DELISTED	Stock	44.22	46.6	44.03	44.73	332484.0
2015-07-06	AACG	Stock	5.37	5.89	5.05	5.08	27900.0
2015-07-06	AAIC-DELISTED	Stock	19.5	19.8	19.5	19.79	217119.0
2015-07-06	AAL	Stock	39.09	40.0	39.08	39.73	9157700.0
2015-07-06	AAMC-DELISTED	Stock	41.1706	42.5147	41.1706	41.1912	6416.0
2015-07-06	AAME	Stock	3.7	3.71	3.45	3.63	2800.0
2015-07-06	AAMI	Stock	17.53	17.71	17.34	17.45	191400.0
2015-07-06	AAOI	Stock	16.93	17.59	16.68	17.06	166100.0
2015-07-06	AAON	Stock	15.0133	15.2467	14.98	15.1867	186150.0
2015-07-06	AAP	Stock	161.37	164.42	161.22	163.42	618200.0
2015-07-06	AAT	Stock	39.49	40.38	39.06	40.23	322600.0
2015-07-06	AAU-DELISTED	Stock	0.8597	0.8597	0.8	0.84	61916.0
2015-07-06	AAUAF-DELISTED	Stock	0.8301	0.8433	0.8	0.8433	64844.0
2015-07-06	AAV-DELISTED	Stock	6.26	6.58	6.18	6.45	170411.0
2015-07-06	AAVL-DELISTED	Stock	15.88	16.48	15.703	16.33	306555.0
2015-07-06	AAWW-DELISTED	Stock	54.25	55.23	53.6	54.88	398872.0
2015-07-06	AAXJ	Stock	61.54	62.15	61.47	61.65	1855961.0
2015-07-06	AAXN-DELISTED	Stock	31.82	32.9	31.79	32.22	975396.0
2015-07-06	AB	Stock	29.0	29.47	28.89	29.29	143600.0
2015-07-06	ABAC-DELISTED	Stock	1.27	1.2899	1.03	1.1499	69941.0
2015-07-06	ABAX-DELISTED	Stock	50.21	51.34	49.91	51.18	87562.0
2015-07-06	ABB-DELISTED	Stock	20.4	20.62	20.36	20.52	2180995.0
2015-07-06	ABBNY-DELISTED	Stock	20.4	20.62	20.36	20.52	2277788.0
2015-07-06	ABBV	Stock	67.53	69.0	67.49	68.22	17029100.0
2015-07-06	ABC-DELISTED	Stock	106.47	108.57	106.0	107.99	1272031.0
2015-07-06	ABCB	Stock	24.67	25.39	24.67	25.38	322500.0
2015-07-06	ABCD-DELISTED	Stock	4.18	4.57	4.07	4.56	620474.0
2015-07-06	ABCO-DELISTED	Stock	53.91	54.65	53.7	54.38	211634.0
2015-07-06	ABCW-DELISTED	Stock	39.64	40.95	39.535	40.94	27724.0
2015-07-06	ABDC-DELISTED	Stock	12.73	12.7377	12.16	12.34	42017.0
2015-07-06	ABE-DELISTED	Stock	12.62	12.83	12.57	12.82	18593.0
2015-07-06	ABEO	Stock	126.25	127.25	115.75	120.0	25608.0
2015-07-06	ABEOW-DELISTED	Stock	1.3	1.3	1.07	1.24	500.0
2015-07-06	ABEV	Stock	6.04	6.11	6.03	6.09	8238500.0
2015-07-06	ABG	Stock	90.44	92.4	90.1	90.92	212000.0
2015-07-06	ABGB-DELISTED	Stock	15.38	15.58	15.25	15.42	11286.0
2015-07-06	ABM	Stock	32.44	32.73	32.28	32.41	148700.0

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

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