PREVIEW / stock_daily / 2013-08-07

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-07.parquet
  size:    212 KB
  rows:    6,359
  symbols: 3,512

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-08-07	AAPL	Stock	16.5643	16.6786	16.4918	16.6064	298858000.0
2013-08-07	MSFT	Stock	31.54	32.1	31.25	32.06	38078600.0
2013-08-07	NVDA	Stock	0.3632	0.3688	0.363	0.365	244380000.0
2013-08-07	AMZN	Stock	15.0075	15.0495	14.8075	14.8455	39220000.0
2013-08-07	META	Stock	38.61	38.94	37.7	38.87	68854800.0
2013-08-07	TSLA	Stock	9.4593	9.4633	8.824	8.9487	273183000.0
2013-08-07	TLT	Stock	106.17	106.94	106.17	106.8	7183382.0
2013-08-07	ES	Stock	43.63	44.29	43.62	44.16	1575500.0
2013-08-07	CL	Stock	60.8	61.17	60.65	60.94	2469800.0
2013-08-07	A	Stock	32.8183	33.2332	32.6323	33.1044	2379536.0
2013-08-07	AABA-DELISTED	Stock	27.31	27.51	27.06	27.385	9413652.0
2013-08-07	AACG	Stock	4.95	4.95	4.9	4.9	700.0
2013-08-07	AAIC-DELISTED	Stock	24.41	24.51	23.63	24.14	186220.0
2013-08-07	AAMC-DELISTED	Stock	107.3529	107.3529	100.4412	101.3235	10537.0
2013-08-07	AAME	Stock	3.78	3.84	3.78	3.84	1100.0
2013-08-07	AAMRQ-DELISTED	Stock	5.925	5.93	5.76	5.855	2418703.0
2013-08-07	AAON	Stock	10.2222	10.3467	10.2	10.3111	192600.0
2013-08-07	AAP	Stock	82.82	82.93	81.82	82.29	996400.0
2013-08-07	AAT	Stock	33.38	33.38	32.43	32.54	58800.0
2013-08-07	AAU-DELISTED	Stock	1.67	1.7	1.6	1.63	72500.0
2013-08-07	AAUAF-DELISTED	Stock	1.67	1.7	1.6	1.63	72700.0
2013-08-07	AAV-DELISTED	Stock	3.57	3.57	3.45	3.49	383045.0
2013-08-07	AAWW-DELISTED	Stock	43.35	43.825	42.89	43.06	190522.0
2013-08-07	AAXJ	Stock	55.21	55.32	54.96	54.99	667880.0
2013-08-07	AAXN-DELISTED	Stock	8.7	8.79	8.635	8.72	189251.0
2013-08-07	AB	Stock	22.81	22.96	22.22	22.93	200600.0
2013-08-07	ABAC-DELISTED	Stock	0.5835	0.5868	0.5835	0.5868	2600.0
2013-08-07	ABAX-DELISTED	Stock	40.3	41.49	40.3	40.96	205908.0
2013-08-07	ABB-DELISTED	Stock	22.05	22.15	22.025	22.13	712995.0
2013-08-07	ABBNY-DELISTED	Stock	22.05	22.15	22.025	22.12	718290.0
2013-08-07	ABBV	Stock	44.7	44.86	44.22	44.57	3299400.0
2013-08-07	ABC-DELISTED	Stock	58.31	59.17	58.21	58.75	1395641.0
2013-08-07	ABCB	Stock	19.25	19.45	19.25	19.27	43300.0
2013-08-07	ABCD-DELISTED	Stock	1.27	1.27	1.27	1.27	100.0
2013-08-07	ABCO-DELISTED	Stock	59.85	60.2	59.51	59.79	147219.0
2013-08-07	ABCW-DELISTED	Stock	0.43	0.43	0.4	0.4	39040.0
2013-08-07	ABE-DELISTED	Stock	19.81	19.81	19.55	19.67	16459.0
2013-08-07	ABEO	Stock	562.5	562.5	475.0	525.0	22.0
2013-08-07	ABFS-DELISTED	Stock	20.65	20.73	19.49	19.6	1030016.0
2013-08-07	ABG	Stock	50.54	50.89	50.29	50.62	122600.0
2013-08-07	ABM	Stock	25.91	26.09	25.75	25.84	67400.0
2013-08-07	ABMD-DELISTED	Stock	22.3	22.3	21.85	22.05	295290.0
2013-08-07	ABR	Stock	7.49	7.56	7.33	7.42	105700.0
2013-08-07	ABR.A-DELISTED	Stock	25.2	25.2	25.17	25.17	1264.0
2013-08-07	ABR.B-DELISTED	Stock	24.3	24.3899	24.3	24.3	1500.0
2013-08-07	ABT	Stock	36.07	36.29	35.83	35.93	7220100.0
2013-08-07	ABTL-DELISTED	Stock	6.28	6.36	5.92	6.19	145791.0
2013-08-07	ABUS	Stock	5.7	5.76	5.41	5.42	92600.0
2013-08-07	ABV-DELISTED	Stock	37.15	37.41	37.01	37.01	1918011.0
2013-08-07	ABX-DELISTED	Stock	15.57	15.97	15.53	15.545	11741123.0

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

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