PREVIEW / stock_daily / 2013-03-22

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-22.parquet
  size:    206 KB
  rows:    6,251
  symbols: 3,474

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-22	AAPL	Stock	16.235	16.5036	16.1825	16.4968	395105200.0
2013-03-22	MSFT	Stock	28.19	28.34	28.1	28.25	28720900.0
2013-03-22	NVDA	Stock	0.3115	0.3133	0.3103	0.312	232476000.0
2013-03-22	AMZN	Stock	12.7275	12.8885	12.6035	12.8875	62492000.0
2013-03-22	META	Stock	25.8	26.01	25.63	25.73	18456300.0
2013-03-22	TSLA	Stock	2.4133	2.4533	2.4133	2.4413	6603000.0
2013-03-22	TLT	Stock	117.3	117.5	116.77	117.33	6323721.0
2013-03-22	ES	Stock	42.68	42.83	42.49	42.65	723800.0
2013-03-22	CL	Stock	56.875	57.5	56.675	57.205	4500400.0
2013-03-22	A	Stock	29.8927	29.8927	29.2632	29.5064	7615465.0
2013-03-22	AABA-DELISTED	Stock	22.88	23.26	22.72	23.25	17790566.0
2013-03-22	AACC-DELISTED	Stock	6.5	6.6	6.5	6.55	131511.0
2013-03-22	AAIC-DELISTED	Stock	25.49	25.78	25.49	25.78	446889.0
2013-03-22	AAMC-DELISTED	Stock	40.5882	41.1765	40.0	40.0	18941.0
2013-03-22	AAME	Stock	3.3	3.4	3.29	3.38	15700.0
2013-03-22	AAMRQ-DELISTED	Stock	4.435	4.52	4.17	4.17	7552887.0
2013-03-22	AAON	Stock	8.0504	8.1393	8.0237	8.077	99225.0
2013-03-22	AAP	Stock	80.12	80.44	78.97	79.81	586900.0
2013-03-22	AAT	Stock	32.0	32.19	31.88	32.08	116600.0
2013-03-22	AAU-DELISTED	Stock	2.32	2.33	2.2	2.24	80442.0
2013-03-22	AAUAF-DELISTED	Stock	2.32	2.33	2.2	2.24	80542.0
2013-03-22	AAV-DELISTED	Stock	3.3	3.48	3.27	3.48	409218.0
2013-03-22	AAWW-DELISTED	Stock	42.08	42.36	41.94	42.06	190779.0
2013-03-22	AAXJ	Stock	58.08	58.12	57.88	58.11	305909.0
2013-03-22	AAXN-DELISTED	Stock	8.08	8.24	7.99	8.16	478566.0
2013-03-22	AB	Stock	21.19	21.87	21.06	21.68	221100.0
2013-03-22	ABAC-DELISTED	Stock	0.7	0.73	0.7	0.7158	20916.0
2013-03-22	ABAX-DELISTED	Stock	46.81	46.91	46.42	46.829	92272.0
2013-03-22	ABB-DELISTED	Stock	22.58	22.67	22.485	22.64	1110176.0
2013-03-22	ABBNY-DELISTED	Stock	22.57	22.67	22.485	22.63	1146747.0
2013-03-22	ABBV	Stock	38.57	38.97	38.3	38.97	3323400.0
2013-03-22	ABC-DELISTED	Stock	49.8	49.919	49.6	49.82	2760064.0
2013-03-22	ABCB	Stock	14.31	14.34	14.28	14.32	23100.0
2013-03-22	ABCD-DELISTED	Stock	1.02	1.1	1.0	1.01	26594.0
2013-03-22	ABCO-DELISTED	Stock	50.0	51.54	50.0	51.17	254186.0
2013-03-22	ABCW-DELISTED	Stock	0.65	0.65	0.64	0.64	4328.0
2013-03-22	ABE-DELISTED	Stock	20.56	20.9	20.52	20.8396	1590.0
2013-03-22	ABEO	Stock	687.5	712.5	662.5	662.5	19.0
2013-03-22	ABFS-DELISTED	Stock	11.82	12.02	11.755	11.85	237349.0
2013-03-22	ABG	Stock	37.14	37.28	36.8	36.99	168700.0
2013-03-22	ABM	Stock	22.15	22.2	21.89	21.94	150600.0
2013-03-22	ABMD-DELISTED	Stock	17.5	17.61	17.25	17.605	200796.0
2013-03-22	ABR	Stock	7.8	7.88	7.6	7.63	5607000.0
2013-03-22	ABR.A-DELISTED	Stock	25.8	25.8	25.6	25.8	7472.0
2013-03-22	ABT	Stock	33.5	33.69	33.33	33.69	5058700.0
2013-03-22	ABTL-DELISTED	Stock	4.08	4.235	4.06	4.16	14541.0
2013-03-22	ABUS	Stock	4.74	4.79	4.67	4.7	237500.0
2013-03-22	ABV-DELISTED	Stock	42.56	42.79	41.9	42.51	2069195.0
2013-03-22	ABX-DELISTED	Stock	29.5	29.7	29.17	29.37	6838264.0
2013-03-22	ACAD	Stock	8.23	8.23	7.5	7.57	6341100.0

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

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