PREVIEW / stock_daily / 2013-03-26

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-26.parquet
  size:    207 KB
  rows:    6,278
  symbols: 3,500

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
2013-03-26	AAPL	Stock	16.6229	16.6371	16.4475	16.4693	294294000.0
2013-03-26	MSFT	Stock	28.24	28.34	28.11	28.16	27824300.0
2013-03-26	NVDA	Stock	0.311	0.3128	0.3098	0.3125	232540000.0
2013-03-26	AMZN	Stock	12.8525	13.074	12.814	13.0155	48420000.0
2013-03-26	META	Stock	25.08	25.48	25.03	25.21	26957200.0
2013-03-26	TSLA	Stock	2.532	2.548	2.5107	2.524	27123000.0
2013-03-26	TLT	Stock	116.87	117.91	116.78	117.36	5093190.0
2013-03-26	ES	Stock	42.69	42.9	42.59	42.82	1302100.0
2013-03-26	CL	Stock	57.4	58.68	57.4	58.66	3123400.0
2013-03-26	A	Stock	29.6137	29.9142	29.5565	29.9142	3511496.0
2013-03-26	AABA-DELISTED	Stock	23.48	23.62	23.35	23.59	16257586.0
2013-03-26	AACC-DELISTED	Stock	6.54	6.64	6.5	6.59	426312.0
2013-03-26	AAIC-DELISTED	Stock	24.88	25.31	24.83	25.21	512414.0
2013-03-26	AAMC-DELISTED	Stock	39.7059	40.8824	39.7059	39.8529	11761.0
2013-03-26	AAME	Stock	3.35	3.35	3.25	3.27	7600.0
2013-03-26	AAMRQ-DELISTED	Stock	4.03	4.14	3.95	3.96	4702582.0
2013-03-26	AAON	Stock	8.1452	8.2133	8.0059	8.0593	239963.0
2013-03-26	AAP	Stock	80.86	81.61	80.56	81.6	969300.0
2013-03-26	AAT	Stock	32.44	32.46	32.17	32.36	79800.0
2013-03-26	AAU-DELISTED	Stock	2.2	2.25	2.135	2.2	111252.0
2013-03-26	AAUAF-DELISTED	Stock	2.19	2.24	2.13	2.2	112303.0
2013-03-26	AAV-DELISTED	Stock	3.47	3.56	3.46	3.5	655751.0
2013-03-26	AAWW-DELISTED	Stock	41.93	42.15	41.64	41.75	133316.0
2013-03-26	AAXJ	Stock	58.6	59.0	58.6	58.98	447902.0
2013-03-26	AAXN-DELISTED	Stock	8.04	8.1	7.975	8.02	335257.0
2013-03-26	AB	Stock	21.4	21.75	21.23	21.75	165100.0
2013-03-26	ABAC-DELISTED	Stock	0.68	0.72	0.68	0.69	20924.0
2013-03-26	ABAX-DELISTED	Stock	47.39	47.39	46.77	47.32	94578.0
2013-03-26	ABB-DELISTED	Stock	22.63	22.92	22.6	22.92	1839220.0
2013-03-26	ABBNY-DELISTED	Stock	22.63	22.92	22.6	22.92	1869981.0
2013-03-26	ABBV	Stock	39.57	40.52	39.57	40.21	7249500.0
2013-03-26	ABC-DELISTED	Stock	50.86	51.21	50.47	50.7	2330740.0
2013-03-26	ABCB	Stock	14.4	14.49	14.32	14.39	30000.0
2013-03-26	ABCD-DELISTED	Stock	1.03	1.08	0.9317	1.04	15933.0
2013-03-26	ABCO-DELISTED	Stock	51.31	51.75	50.73	51.73	97755.0
2013-03-26	ABCW-DELISTED	Stock	0.62	0.67	0.59	0.67	40297.0
2013-03-26	ABE-DELISTED	Stock	20.54	20.9	20.54	20.81	7067.0
2013-03-26	ABEO	Stock	525.0	587.5	525.0	562.5	44.0
2013-03-26	ABFS-DELISTED	Stock	11.92	11.9775	11.53	11.615	212801.0
2013-03-26	ABG	Stock	36.96	37.14	36.4	37.04	185000.0
2013-03-26	ABM	Stock	22.06	22.15	21.98	22.14	179800.0
2013-03-26	ABMD-DELISTED	Stock	18.04	18.46	17.81	18.35	376503.0
2013-03-26	ABR	Stock	7.77	7.84	7.7	7.84	402200.0
2013-03-26	ABR.A-DELISTED	Stock	25.65	25.79	25.55	25.7801	5800.0
2013-03-26	ABT	Stock	33.85	34.35	33.85	34.35	5855400.0
2013-03-26	ABTL-DELISTED	Stock	4.37	4.5	4.3	4.3	30297.0
2013-03-26	ABUS	Stock	4.74	4.76	4.66	4.68	73100.0
2013-03-26	ABV-DELISTED	Stock	41.45	42.1	41.38	41.81	1678518.0
2013-03-26	ABX-DELISTED	Stock	28.97	29.05	28.69	28.83	6087039.0
2013-03-26	ACAD	Stock	8.44	8.68	8.05	8.23	5123200.0

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

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