PREVIEW / stock_daily / 2015-04-20

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-20.parquet
  size:    223 KB
  rows:    6,638
  symbols: 3,506

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-04-20	AAPL	Stock	31.3925	32.03	31.2925	31.9	188217200.0
2015-04-20	MSFT	Stock	41.73	43.17	41.68	42.91	46057700.0
2015-04-20	NVDA	Stock	0.5575	0.561	0.5512	0.5522	231624000.0
2015-04-20	AMZN	Stock	18.9275	19.597	18.85	19.4755	100322000.0
2015-04-20	GOOGL	Stock	26.6875	27.29	26.6675	27.2265	38521280.0
2015-04-20	META	Stock	81.54	83.15	81.24	83.09	28796800.0
2015-04-20	TSLA	Stock	13.7853	13.8567	13.59	13.6847	38389500.0
2015-04-20	TLT	Stock	130.94	131.01	129.93	130.29	4949441.0
2015-04-20	ES	Stock	50.16	50.94	49.87	50.5	1341300.0
2015-04-20	CL	Stock	68.7	69.2	68.31	68.46	4681500.0
2015-04-20	A	Stock	43.33	43.44	43.15	43.19	1410600.0
2015-04-20	AA.B-DELISTED	Stock	45.65	46.2	45.59	45.86	69757.0
2015-04-20	AABA-DELISTED	Stock	44.73	44.91	44.41	44.65	9086997.0
2015-04-20	AAC-DELISTED	Stock	31.74	33.85	31.35	33.0	125067.0
2015-04-20	AACG	Stock	4.59	4.59	4.5	4.55	15400.0
2015-04-20	AAIC-DELISTED	Stock	24.06	24.11	24.0	24.07	129204.0
2015-04-20	AAL	Stock	48.61	49.78	47.91	49.76	9523500.0
2015-04-20	AAMC-DELISTED	Stock	66.1824	68.2206	66.1588	68.2206	13814.0
2015-04-20	AAME	Stock	3.97	3.97	3.97	3.97	100.0
2015-04-20	AAMI	Stock	18.77	19.06	18.67	18.98	95400.0
2015-04-20	AAOI	Stock	14.8	15.04	14.6	14.76	219100.0
2015-04-20	AAON	Stock	15.8267	16.2933	15.8	16.1467	173400.0
2015-04-20	AAP	Stock	149.83	152.53	149.83	152.4	890000.0
2015-04-20	AAT	Stock	41.29	41.6	41.08	41.19	187400.0
2015-04-20	AAU-DELISTED	Stock	0.82	0.83	0.8	0.8066	107237.0
2015-04-20	AAUAF-DELISTED	Stock	0.82	0.83	0.8	0.8066	107990.0
2015-04-20	AAV-DELISTED	Stock	6.06	6.14	6.02	6.12	95545.0
2015-04-20	AAVL-DELISTED	Stock	40.02	40.65	39.15	39.55	176978.0
2015-04-20	AAWW-DELISTED	Stock	43.61	44.22	43.502	43.76	106448.0
2015-04-20	AAXJ	Stock	67.84	68.1	67.67	67.95	725999.0
2015-04-20	AAXN-DELISTED	Stock	29.01	30.47	28.6	30.36	3945675.0
2015-04-20	AB	Stock	31.49	31.85	31.49	31.59	132300.0
2015-04-20	ABAC-DELISTED	Stock	1.71	1.74	1.7018	1.74	4300.0
2015-04-20	ABAX-DELISTED	Stock	62.48	63.98	62.3	63.01	98532.0
2015-04-20	ABB-DELISTED	Stock	21.9	22.02	21.8184	21.84	542124.0
2015-04-20	ABBNY-DELISTED	Stock	21.9	22.02	21.8184	21.84	590470.0
2015-04-20	ABBV	Stock	62.91	64.0	62.8	63.54	12779200.0
2015-04-20	ABC-DELISTED	Stock	112.96	113.56	112.89	113.19	1253285.0
2015-04-20	ABCB	Stock	25.81	26.13	25.5	25.67	115100.0
2015-04-20	ABCD-DELISTED	Stock	3.12	3.25	3.11	3.1499	384263.0
2015-04-20	ABCO-DELISTED	Stock	52.53	53.02	51.73	51.96	211851.0
2015-04-20	ABCW-DELISTED	Stock	34.5	34.5	34.22	34.46	8891.0
2015-04-20	ABDC-DELISTED	Stock	14.01	14.01	13.85	13.9	28470.0
2015-04-20	ABE-DELISTED	Stock	13.19	13.2806	13.17	13.27	4490.0
2015-04-20	ABEO	Stock	83.75	83.75	78.25	79.75	2320.0
2015-04-20	ABEOW-DELISTED	Stock	1.38	1.38	1.38	1.38	1000.0
2015-04-20	ABEV	Stock	6.26	6.3	6.19	6.2	11665900.0
2015-04-20	ABG	Stock	85.74	88.2	85.5	88.05	318500.0
2015-04-20	ABGB-DELISTED	Stock	17.03	17.05	16.82	16.9	34482.0
2015-04-20	ABIL-DELISTED	Stock	10.05	10.12	9.9	10.11	11100.0

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

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