PREVIEW / stock_daily / 2013-06-26

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-26.parquet
  size:    209 KB
  rows:    6,341
  symbols: 3,530

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-26	AAPL	Stock	14.425	14.4568	14.1307	14.2168	367724000.0
2013-06-26	MSFT	Stock	34.12	34.48	33.89	34.35	48665900.0
2013-06-26	NVDA	Stock	0.3595	0.36	0.352	0.3535	579752000.0
2013-06-26	AMZN	Stock	13.699	13.899	13.675	13.8785	60590000.0
2013-06-26	META	Stock	24.51	24.65	23.99	24.16	29890300.0
2013-06-26	TSLA	Stock	6.92	7.058	6.844	7.048	99039000.0
2013-06-26	TLT	Stock	109.0	109.05	108.04	108.58	13582107.0
2013-06-26	ES	Stock	40.82	41.36	40.76	41.26	1232100.0
2013-06-26	CL	Stock	56.78	57.2	56.42	57.0	4130400.0
2013-06-26	A	Stock	30.8298	30.9657	30.2432	30.2861	5163932.0
2013-06-26	AABA-DELISTED	Stock	25.17	25.68	25.01	25.28	12106003.0
2013-06-26	AACG	Stock	4.21	4.3	4.21	4.3	200.0
2013-06-26	AAIC-DELISTED	Stock	26.0	26.086	25.4	25.58	195339.0
2013-06-26	AAMC-DELISTED	Stock	76.4706	76.4706	76.4706	76.4706	1391.0
2013-06-26	AAME	Stock	3.85	3.91	3.85	3.91	2300.0
2013-06-26	AAMRQ-DELISTED	Stock	4.02	4.15	3.96	3.97	2591383.0
2013-06-26	AAON	Stock	9.6622	9.7452	9.5022	9.5289	116100.0
2013-06-26	AAP	Stock	80.78	81.05	79.47	79.75	1178600.0
2013-06-26	AAT	Stock	30.15	30.21	29.79	30.05	243500.0
2013-06-26	AAU-DELISTED	Stock	1.1	1.2	1.08	1.18	231339.0
2013-06-26	AAUAF-DELISTED	Stock	1.12	1.22	1.1	1.18	227684.0
2013-06-26	AAV-DELISTED	Stock	3.94	3.97	3.86	3.97	142101.0
2013-06-26	AAWW-DELISTED	Stock	44.05	44.72	43.7	43.89	162030.0
2013-06-26	AAXJ	Stock	53.73	54.2	53.64	54.1	658268.0
2013-06-26	AAXN-DELISTED	Stock	8.74	8.74	8.57	8.59	314434.0
2013-06-26	AB	Stock	21.41	21.79	21.25	21.32	583300.0
2013-06-26	ABAC-DELISTED	Stock	0.62	0.62	0.55	0.5999	28599.0
2013-06-26	ABAX-DELISTED	Stock	46.26	46.72	45.655	46.38	88449.0
2013-06-26	ABB-DELISTED	Stock	21.33	21.47	21.27	21.34	1298172.0
2013-06-26	ABBNY-DELISTED	Stock	21.33	21.47	21.27	21.34	1300420.0
2013-06-26	ABBV	Stock	43.1	43.61	43.03	43.38	4733700.0
2013-06-26	ABC-DELISTED	Stock	53.77	55.29	53.77	55.05	2455994.0
2013-06-26	ABCB	Stock	16.51	16.51	16.13	16.35	47000.0
2013-06-26	ABCD-DELISTED	Stock	1.28	1.336	1.28	1.336	1200.0
2013-06-26	ABCO-DELISTED	Stock	54.01	54.44	53.43	54.13	118173.0
2013-06-26	ABCW-DELISTED	Stock	0.56	0.585	0.56	0.56	2435.0
2013-06-26	ABE-DELISTED	Stock	19.1301	19.36	19.13	19.36	14414.0
2013-06-26	ABEO	Stock	612.5	612.5	537.5	600.0	15.0
2013-06-26	ABFS-DELISTED	Stock	19.62	19.76	18.98	19.32	355346.0
2013-06-26	ABG	Stock	38.28	39.38	37.79	39.02	223500.0
2013-06-26	ABM	Stock	24.28	24.34	24.06	24.23	133200.0
2013-06-26	ABMD-DELISTED	Stock	20.92	21.41	20.79	21.16	215080.0
2013-06-26	ABR	Stock	6.4	6.5	6.07	6.07	138400.0
2013-06-26	ABR.A-DELISTED	Stock	24.7	24.7	24.34	24.45	4300.0
2013-06-26	ABR.B-DELISTED	Stock	23.9	24.28	23.9	24.0001	1950.0
2013-06-26	ABT	Stock	35.41	35.79	35.14	35.6	6877400.0
2013-06-26	ABTL-DELISTED	Stock	4.66	4.75	4.57	4.64	24633.0
2013-06-26	ABUS	Stock	4.75	4.77	4.67	4.77	16200.0
2013-06-26	ABV-DELISTED	Stock	35.65	36.44	35.6	36.27	4859645.0
2013-06-26	ABX-DELISTED	Stock	15.47	15.52	14.75	14.77	34596707.0

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

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