PREVIEW / stock_daily / 2015-01-09

all stock daily files

  file:    by_date/stock_daily/2015/2015-01-09.parquet
  size:    222 KB
  rows:    6,625
  symbols: 3,517

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-01-09	AAPL	Stock	28.1675	28.3125	27.5525	28.0025	214798000.0
2015-01-09	MSFT	Stock	47.61	47.82	46.9	47.19	23944200.0
2015-01-09	NVDA	Stock	0.4982	0.5022	0.4915	0.4985	209540000.0
2015-01-09	AMZN	Stock	15.074	15.1435	14.834	14.8465	51848000.0
2015-01-09	GOOGL	Stock	25.409	25.43	24.9325	25.036	42000480.0
2015-01-09	META	Stock	78.2	78.62	77.2	77.74	21157000.0
2015-01-09	TSLA	Stock	13.928	13.9987	13.664	13.7773	70024500.0
2015-01-09	TLT	Stock	129.2	131.11	129.04	131.07	9398821.0
2015-01-09	ES	Stock	54.16	54.28	53.11	53.48	1595600.0
2015-01-09	CL	Stock	69.35	69.44	68.55	68.6	2284300.0
2015-01-09	A	Stock	41.0	41.0	40.29	40.59	1644900.0
2015-01-09	AA.B-DELISTED	Stock	51.5	51.64	50.45	51.55	101885.0
2015-01-09	AABA-DELISTED	Stock	50.28	50.41	49.62	49.72	6745512.0
2015-01-09	AAC-DELISTED	Stock	29.38	30.3963	28.8301	30.14	66935.0
2015-01-09	AACG	Stock	4.1	4.48	4.1	4.29	8600.0
2015-01-09	AAIC-DELISTED	Stock	26.68	26.68	26.2805	26.32	120857.0
2015-01-09	AAL	Stock	53.67	53.91	51.82	52.02	12351600.0
2015-01-09	AAMC-DELISTED	Stock	95.4853	97.9853	91.8412	91.8412	79584.0
2015-01-09	AAME	Stock	3.95	4.01	3.94	4.0	3700.0
2015-01-09	AAMI	Stock	15.47	15.54	15.1	15.4	127800.0
2015-01-09	AAOI	Stock	10.0	10.16	9.87	10.11	114700.0
2015-01-09	AAON	Stock	14.3333	14.3333	14.1267	14.2733	165900.0
2015-01-09	AAP	Stock	159.95	161.62	158.39	160.3	912100.0
2015-01-09	AAT	Stock	42.11	42.41	41.84	42.25	126000.0
2015-01-09	AAU-DELISTED	Stock	1.13	1.22	1.0886	1.14	584049.0
2015-01-09	AAUAF-DELISTED	Stock	1.1	1.19	1.06	1.14	604490.0
2015-01-09	AAV-DELISTED	Stock	4.51	4.61	4.435	4.58	172654.0
2015-01-09	AAVL-DELISTED	Stock	59.25	60.3499	57.0	58.66	426452.0
2015-01-09	AAWW-DELISTED	Stock	48.34	48.63	47.36	47.57	159589.0
2015-01-09	AAXJ	Stock	61.49	61.61	61.17	61.36	2575706.0
2015-01-09	AAXN-DELISTED	Stock	26.62	26.63	26.01	26.27	1355690.0
2015-01-09	AB	Stock	25.55	25.75	25.2	25.61	203400.0
2015-01-09	ABAC-DELISTED	Stock	1.63	1.63	1.52	1.54	5366.0
2015-01-09	ABAX-DELISTED	Stock	58.42	58.7095	56.78	57.08	188135.0
2015-01-09	ABB-DELISTED	Stock	20.04	20.16	19.94	20.08	1446123.0
2015-01-09	ABBNY-DELISTED	Stock	20.04	20.16	19.94	20.09	1626503.0
2015-01-09	ABBV	Stock	66.69	67.2	65.11	65.78	8779900.0
2015-01-09	ABC-DELISTED	Stock	92.44	93.27	92.32	93.0	1351848.0
2015-01-09	ABCB	Stock	24.65	24.65	23.94	23.97	62800.0
2015-01-09	ABCD-DELISTED	Stock	1.74	1.75	1.74	1.75	10000.0
2015-01-09	ABCO-DELISTED	Stock	48.62	50.61	48.44	49.92	190406.0
2015-01-09	ABCW-DELISTED	Stock	34.83	34.83	34.71	34.75	1934.0
2015-01-09	ABDC-DELISTED	Stock	13.025	13.1399	12.83	13.06	24911.0
2015-01-09	ABE-DELISTED	Stock	13.11	13.2	13.03	13.2	3666.0
2015-01-09	ABEO	Stock	81.25	81.25	80.0	81.0	460.0
2015-01-09	ABEOW-DELISTED	Stock	0.75	0.95	0.71	0.71	3850.0
2015-01-09	ABEV	Stock	6.24	6.33	6.22	6.28	14704800.0
2015-01-09	ABG	Stock	75.29	75.44	74.35	74.45	207100.0
2015-01-09	ABGB-DELISTED	Stock	13.2	13.34	13.09	13.11	49141.0
2015-01-09	ABIL-DELISTED	Stock	9.78	9.9	9.77	9.86	9900.0

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

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