PREVIEW / stock_daily / 2015-01-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-01-23.parquet
  size:    222 KB
  rows:    6,626
  symbols: 3,521

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-23	AAPL	Stock	28.075	28.4375	27.8825	28.245	185859200.0
2015-01-23	MSFT	Stock	47.36	47.39	46.8	47.18	26211600.0
2015-01-23	NVDA	Stock	0.5168	0.5188	0.5125	0.5178	120416000.0
2015-01-23	AMZN	Stock	15.404	15.8465	15.386	15.6195	89928000.0
2015-01-23	GOOGL	Stock	26.9015	27.2705	26.7875	27.0975	45965800.0
2015-01-23	META	Stock	77.65	78.19	77.04	77.83	16746500.0
2015-01-23	TSLA	Stock	13.3527	13.5667	13.222	13.4193	51579000.0
2015-01-23	TLT	Stock	134.3	135.12	134.15	134.77	7334591.0
2015-01-23	ES	Stock	55.71	56.16	55.46	55.84	1176700.0
2015-01-23	CL	Stock	68.85	69.0	67.1	67.14	4587800.0
2015-01-23	A	Stock	39.6	39.6	38.76	38.81	1519300.0
2015-01-23	AA.B-DELISTED	Stock	50.86	51.2	50.24	50.89	23121.0
2015-01-23	AABA-DELISTED	Stock	48.78	49.23	48.63	48.9501	13419019.0
2015-01-23	AAC-DELISTED	Stock	29.07	29.07	27.89	27.9	41367.0
2015-01-23	AACG	Stock	4.93	5.0	4.7	4.85	30900.0
2015-01-23	AAIC-DELISTED	Stock	27.01	27.05	26.7	26.86	127331.0
2015-01-23	AAL	Stock	55.4	55.98	54.8	55.69	9488800.0
2015-01-23	AAMC-DELISTED	Stock	69.4132	69.4132	61.9118	65.8265	68626.0
2015-01-23	AAME	Stock	3.85	3.88	3.85	3.88	1300.0
2015-01-23	AAMI	Stock	16.32	16.32	15.36	15.66	126400.0
2015-01-23	AAOI	Stock	9.0	9.47	8.96	9.21	180900.0
2015-01-23	AAON	Stock	15.0467	15.1133	14.82	14.98	129450.0
2015-01-23	AAP	Stock	156.99	158.05	154.64	155.78	685500.0
2015-01-23	AAT	Stock	44.3	44.4	43.81	43.89	122600.0
2015-01-23	AAU-DELISTED	Stock	1.16	1.21	1.12	1.15	295767.0
2015-01-23	AAUAF-DELISTED	Stock	1.18	1.23	1.14	1.15	291554.0
2015-01-23	AAV-DELISTED	Stock	4.13	4.26	4.13	4.17	185646.0
2015-01-23	AAVL-DELISTED	Stock	43.0	43.0	39.55	39.92	275561.0
2015-01-23	AAWW-DELISTED	Stock	46.99	47.09	46.26	46.67	85988.0
2015-01-23	AAXJ	Stock	63.87	64.04	63.81	63.83	870938.0
2015-01-23	AAXN-DELISTED	Stock	27.38	28.3	27.18	27.61	1648897.0
2015-01-23	AB	Stock	26.61	26.7	26.36	26.4	348300.0
2015-01-23	ABAC-DELISTED	Stock	1.5	1.65	1.41	1.5199	7733.0
2015-01-23	ABAX-DELISTED	Stock	59.29	60.17	58.555	59.9	171879.0
2015-01-23	ABB-DELISTED	Stock	19.85	19.95	19.78	19.79	1746625.0
2015-01-23	ABBNY-DELISTED	Stock	19.85	19.95	19.78	19.8	1923202.0
2015-01-23	ABBV	Stock	63.66	63.66	62.35	62.43	6881100.0
2015-01-23	ABC-DELISTED	Stock	94.38	95.16	94.3	94.73	1653217.0
2015-01-23	ABCB	Stock	24.66	24.69	23.98	24.16	42600.0
2015-01-23	ABCD-DELISTED	Stock	2.36	2.48	2.31	2.42	80428.0
2015-01-23	ABCO-DELISTED	Stock	45.25	47.3	44.78	46.61	568770.0
2015-01-23	ABCW-DELISTED	Stock	34.55	34.75	33.3	33.3	1044.0
2015-01-23	ABDC-DELISTED	Stock	12.89	12.913	12.85	12.88	17168.0
2015-01-23	ABE-DELISTED	Stock	13.43	13.43	13.3923	13.396	749.0
2015-01-23	ABEO	Stock	79.75	81.0	77.25	78.5	280.0
2015-01-23	ABEV	Stock	6.62	6.66	6.56	6.62	8474500.0
2015-01-23	ABG	Stock	74.03	75.03	74.03	74.73	214300.0
2015-01-23	ABGB-DELISTED	Stock	15.44	15.44	14.56	14.91	108312.0
2015-01-23	ABM	Stock	29.6	29.8	29.29	29.49	145900.0
2015-01-23	ABMD-DELISTED	Stock	39.01	39.95	38.8488	39.48	329112.0

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

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