PREVIEW / stock_daily / 2013-06-07

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-07.parquet
  size:    212 KB
  rows:    6,371
  symbols: 3,543

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-07	AAPL	Stock	15.5893	15.83	15.4561	15.7789	404535600.0
2013-06-07	MSFT	Stock	35.25	35.78	35.06	35.67	40757300.0
2013-06-07	NVDA	Stock	0.3588	0.3635	0.3572	0.3612	274584000.0
2013-06-07	AMZN	Stock	13.487	14.005	13.4565	13.8435	92652000.0
2013-06-07	META	Stock	23.03	23.4	22.86	23.29	38699200.0
2013-06-07	TSLA	Stock	6.5333	6.86	6.4467	6.8027	160674000.0
2013-06-07	TLT	Stock	114.22	114.8299	113.16	113.16	10459370.0
2013-06-07	ES	Stock	41.73	42.4	41.71	42.38	1617500.0
2013-06-07	CL	Stock	58.51	59.14	58.42	59.1	2980200.0
2013-06-07	A	Stock	32.3033	32.8469	32.1459	32.2961	3888537.0
2013-06-07	AABA-DELISTED	Stock	26.39	27.09	26.28	27.03	16784279.0
2013-06-07	AACC-DELISTED	Stock	6.98	7.09	6.86	7.08	273869.0
2013-06-07	AACG	Stock	4.48	4.5	4.4	4.41	11600.0
2013-06-07	AAIC-DELISTED	Stock	27.72	27.89	27.31	27.45	206105.0
2013-06-07	AAMC-DELISTED	Stock	70.0	70.0	68.5294	68.5294	16969.0
2013-06-07	AAME	Stock	3.95	3.96	3.94	3.94	3300.0
2013-06-07	AAMRQ-DELISTED	Stock	4.435	4.86	4.43	4.85	5016997.0
2013-06-07	AAON	Stock	9.6622	9.7896	9.4163	9.4311	304425.0
2013-06-07	AAP	Stock	83.49	84.53	83.18	84.32	541500.0
2013-06-07	AAT	Stock	33.06	33.06	32.11	32.54	237500.0
2013-06-07	AAU-DELISTED	Stock	1.73	1.8	1.71	1.77	142239.0
2013-06-07	AAUAF-DELISTED	Stock	1.73	1.8	1.71	1.76	147108.0
2013-06-07	AAV-DELISTED	Stock	4.265	4.3	4.21	4.3	463564.0
2013-06-07	AAWW-DELISTED	Stock	45.88	46.99	45.65	46.49	173261.0
2013-06-07	AAXJ	Stock	57.49	57.78	57.2201	57.49	754552.0
2013-06-07	AAXN-DELISTED	Stock	9.45	9.48	9.31	9.42	267003.0
2013-06-07	AB	Stock	24.06	25.33	24.0	24.43	535900.0
2013-06-07	ABAC-DELISTED	Stock	0.57	0.57	0.55	0.55	56700.0
2013-06-07	ABAX-DELISTED	Stock	44.5	45.27	44.15	44.53	104561.0
2013-06-07	ABB-DELISTED	Stock	21.88	21.99	21.75	21.84	1791371.0
2013-06-07	ABBNY-DELISTED	Stock	21.88	21.99	21.75	21.85	1803630.0
2013-06-07	ABBV	Stock	43.72	44.27	43.5	44.0	5463200.0
2013-06-07	ABC-DELISTED	Stock	52.7	53.25	52.7	52.93	3446808.0
2013-06-07	ABCB	Stock	16.45	16.54	16.29	16.36	48100.0
2013-06-07	ABCD-DELISTED	Stock	1.3724	1.39	1.28	1.39	1417.0
2013-06-07	ABCO-DELISTED	Stock	52.51	52.74	51.4	52.5	194053.0
2013-06-07	ABCW-DELISTED	Stock	0.6	0.6	0.58	0.59	30306.0
2013-06-07	ABE-DELISTED	Stock	21.41	21.41	20.7174	20.85	7282.0
2013-06-07	ABEO	Stock	575.0	662.5	550.0	650.0	28.0
2013-06-07	ABFS-DELISTED	Stock	19.62	19.93	19.42	19.9	312412.0
2013-06-07	ABG	Stock	40.65	41.66	40.51	41.53	251100.0
2013-06-07	ABM	Stock	24.85	24.9	24.51	24.66	198300.0
2013-06-07	ABMD-DELISTED	Stock	21.28	21.28	20.87	21.12	355830.0
2013-06-07	ABR	Stock	6.99	7.0	6.92	6.95	132200.0
2013-06-07	ABR.A-DELISTED	Stock	25.079	25.079	24.86	24.93	10706.0
2013-06-07	ABR.B-DELISTED	Stock	24.689	24.74	24.642	24.74	3012.0
2013-06-07	ABT	Stock	36.95	37.55	36.9	37.51	5996500.0
2013-06-07	ABTL-DELISTED	Stock	4.92	4.92	4.74	4.77	7418.0
2013-06-07	ABUS	Stock	4.84	4.86	4.74	4.75	16300.0
2013-06-07	ABV-DELISTED	Stock	37.3	37.78	36.64	37.01	3567343.0

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

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