PREVIEW / stock_daily / 2013-07-05

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-05.parquet
  size:    208 KB
  rows:    6,323
  symbols: 3,499

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-07-05	AAPL	Stock	15.0139	15.1175	14.8339	14.9079	274024800.0
2013-07-05	MSFT	Stock	34.09	34.24	33.58	34.21	26085900.0
2013-07-05	NVDA	Stock	0.3542	0.3568	0.352	0.356	184684000.0
2013-07-05	AMZN	Stock	14.25	14.319	14.1035	14.294	39708000.0
2013-07-05	META	Stock	24.65	24.66	24.2	24.37	20229500.0
2013-07-05	TSLA	Stock	7.888	8.0187	7.7133	8.006	102280500.0
2013-07-05	TLT	Stock	107.28	107.5	106.17	106.26	14513511.0
2013-07-05	ES	Stock	41.42	41.43	40.57	41.13	766400.0
2013-07-05	CL	Stock	58.0	58.22	57.11	57.86	2501300.0
2013-07-05	A	Stock	31.0873	31.681	31.0443	31.6381	2932724.0
2013-07-05	AABA-DELISTED	Stock	25.85	26.26	25.52	25.68	11039823.0
2013-07-05	AACG	Stock	4.95	4.96	4.5	4.54	14000.0
2013-07-05	AAIC-DELISTED	Stock	26.59	26.6	24.21	24.62	494080.0
2013-07-05	AAME	Stock	3.71	3.74	3.7	3.74	3200.0
2013-07-05	AAMRQ-DELISTED	Stock	4.235	4.38	4.12	4.25	2189421.0
2013-07-05	AAON	Stock	10.2756	10.5867	10.1244	10.5867	172800.0
2013-07-05	AAP	Stock	82.62	82.9	81.45	82.58	272100.0
2013-07-05	AAT	Stock	32.4	32.4	31.3	32.26	196700.0
2013-07-05	AAU-DELISTED	Stock	1.4	1.408	1.36	1.38	72558.0
2013-07-05	AAUAF-DELISTED	Stock	1.4	1.408	1.36	1.38	74658.0
2013-07-05	AAV-DELISTED	Stock	3.96	3.96	3.8479	3.96	116598.0
2013-07-05	AAWW-DELISTED	Stock	43.15	43.345	42.11	42.68	127863.0
2013-07-05	AAXJ	Stock	54.0	54.2	53.41	53.77	299500.0
2013-07-05	AAXN-DELISTED	Stock	8.88	8.98	8.75	8.98	526515.0
2013-07-05	AB	Stock	20.11	20.32	19.22	19.73	580300.0
2013-07-05	ABAC-DELISTED	Stock	0.6	0.618	0.542	0.5555	48801.0
2013-07-05	ABAX-DELISTED	Stock	48.6	49.35	47.9	49.35	48785.0
2013-07-05	ABB-DELISTED	Stock	21.53	21.61	21.39	21.61	649614.0
2013-07-05	ABBNY-DELISTED	Stock	21.53	21.62	21.39	21.62	656963.0
2013-07-05	ABBV	Stock	42.45	42.83	42.31	42.72	2743700.0
2013-07-05	ABC-DELISTED	Stock	55.52	55.66	54.9	55.55	1627123.0
2013-07-05	ABCB	Stock	18.19	18.84	18.13	18.79	44800.0
2013-07-05	ABCD-DELISTED	Stock	1.24	1.29	1.24	1.29	300.0
2013-07-05	ABCO-DELISTED	Stock	55.78	55.78	54.12	55.04	89505.0
2013-07-05	ABCW-DELISTED	Stock	0.52	0.52	0.4655	0.4655	67039.0
2013-07-05	ABE-DELISTED	Stock	19.66	19.66	19.31	19.41	17065.0
2013-07-05	ABEO	Stock	525.0	637.5	525.0	625.0	8.0
2013-07-05	ABFS-DELISTED	Stock	23.22	23.47	22.76	22.95	249181.0
2013-07-05	ABG	Stock	41.59	42.03	40.4	41.94	139900.0
2013-07-05	ABM	Stock	24.56	24.6	24.31	24.59	265800.0
2013-07-05	ABMD-DELISTED	Stock	22.49	22.49	22.05	22.37	125046.0
2013-07-05	ABR	Stock	6.72	6.72	6.11	6.19	105700.0
2013-07-05	ABR.A-DELISTED	Stock	25.229	25.229	25.22	25.22	250.0
2013-07-05	ABR.B-DELISTED	Stock	24.2499	24.25	24.19	24.2	5724.0
2013-07-05	ABT	Stock	34.58	34.93	34.49	34.92	4664300.0
2013-07-05	ABTL-DELISTED	Stock	4.7	4.75	4.69	4.7	8713.0
2013-07-05	ABUS	Stock	4.75	4.92	4.71	4.91	22500.0
2013-07-05	ABV-DELISTED	Stock	35.75	36.17	35.55	36.13	1710363.0
2013-07-05	ABX-DELISTED	Stock	14.26	14.3	13.43	13.77	28877106.0
2013-07-05	ACAD	Stock	18.2	18.2	17.6	18.04	1262100.0

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

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