PREVIEW / stock_daily / 2013-06-12

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-12.parquet
  size:    208 KB
  rows:    6,308
  symbols: 3,504

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-06-12	AAPL	Stock	15.6964	15.7589	15.4107	15.4354	265227200.0
2013-06-12	MSFT	Stock	35.14	35.27	34.85	35.0	37372700.0
2013-06-12	NVDA	Stock	0.356	0.359	0.3493	0.3513	312588000.0
2013-06-12	AMZN	Stock	13.83	13.84	13.5225	13.5835	44778000.0
2013-06-12	META	Stock	24.16	24.26	23.58	23.77	26445800.0
2013-06-12	TSLA	Stock	6.4533	6.6987	6.3833	6.5153	137890500.0
2013-06-12	TLT	Stock	113.0	113.83	112.27	112.33	10193694.0
2013-06-12	ES	Stock	41.8	41.87	40.99	41.13	1534600.0
2013-06-12	CL	Stock	58.99	59.5	58.15	58.16	2344900.0
2013-06-12	A	Stock	32.0315	32.0672	31.3233	31.4163	3817519.0
2013-06-12	AABA-DELISTED	Stock	26.54	26.54	25.89	25.89	11409899.0
2013-06-12	AACC-DELISTED	Stock	6.57	6.58	6.5	6.5	20916.0
2013-06-12	AAIC-DELISTED	Stock	27.65	27.86	27.14	27.16	136299.0
2013-06-12	AAMC-DELISTED	Stock	70.5882	70.5882	70.5882	70.5882	6147.0
2013-06-12	AAME	Stock	3.87	3.97	3.8	3.94	10500.0
2013-06-12	AAMRQ-DELISTED	Stock	4.75	4.87	4.53	4.62	1923713.0
2013-06-12	AAON	Stock	9.36	9.52	9.2415	9.4874	203175.0
2013-06-12	AAP	Stock	83.09	83.41	82.04	82.35	461300.0
2013-06-12	AAT	Stock	32.17	32.38	31.37	31.38	80200.0
2013-06-12	AAU-DELISTED	Stock	1.73	1.7552	1.67	1.67	74911.0
2013-06-12	AAUAF-DELISTED	Stock	1.72	1.75	1.67	1.68	75933.0
2013-06-12	AAV-DELISTED	Stock	4.32	4.36	4.27	4.31	511435.0
2013-06-12	AAWW-DELISTED	Stock	46.2	46.2	45.18	45.57	133862.0
2013-06-12	AAXJ	Stock	56.04	56.21	55.46	55.68	638613.0
2013-06-12	AAXN-DELISTED	Stock	9.45	9.48	9.311	9.415	398125.0
2013-06-12	AB	Stock	25.15	25.15	24.53	24.53	179100.0
2013-06-12	ABAC-DELISTED	Stock	0.551	0.57	0.551	0.5548	1300.0
2013-06-12	ABAX-DELISTED	Stock	45.89	46.05	44.99	45.4	77256.0
2013-06-12	ABB-DELISTED	Stock	21.9	21.91	21.65	21.69	1470391.0
2013-06-12	ABBNY-DELISTED	Stock	21.9	21.91	21.65	21.7	1517023.0
2013-06-12	ABBV	Stock	43.91	44.0	42.72	42.77	3742600.0
2013-06-12	ABC-DELISTED	Stock	55.02	55.35	54.72	54.75	3537553.0
2013-06-12	ABCB	Stock	16.33	16.63	15.86	16.14	41700.0
2013-06-12	ABCD-DELISTED	Stock	1.28	1.4699	1.28	1.3	802.0
2013-06-12	ABCO-DELISTED	Stock	53.75	53.75	52.55	52.8	116121.0
2013-06-12	ABCW-DELISTED	Stock	0.58	0.58	0.58	0.58	4403.0
2013-06-12	ABE-DELISTED	Stock	20.45	20.45	20.26	20.26	5840.0
2013-06-12	ABEO	Stock	662.5	662.5	637.5	637.5	2.0
2013-06-12	ABFS-DELISTED	Stock	19.76	20.06	19.16	19.29	237296.0
2013-06-12	ABG	Stock	41.54	41.54	39.33	39.4	262900.0
2013-06-12	ABM	Stock	25.03	25.05	24.62	24.62	78800.0
2013-06-12	ABMD-DELISTED	Stock	20.88	21.1425	20.78	20.78	262921.0
2013-06-12	ABR	Stock	6.88	6.9	6.7	6.72	183500.0
2013-06-12	ABR.A-DELISTED	Stock	24.85	24.85	24.16	24.48	15725.0
2013-06-12	ABR.B-DELISTED	Stock	24.201	24.201	23.6007	24.1199	7670.0
2013-06-12	ABT	Stock	37.08	37.2	36.42	36.44	5271200.0
2013-06-12	ABTL-DELISTED	Stock	4.83	4.83	4.7	4.79	6503.0
2013-06-12	ABUS	Stock	4.79	4.79	4.7	4.74	19500.0
2013-06-12	ABV-DELISTED	Stock	36.16	36.36	35.73	35.89	3571084.0
2013-06-12	ABX-DELISTED	Stock	19.75	20.33	19.61	19.76	11803129.0

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

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