PREVIEW / stock_daily / 2013-08-05

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-05.parquet
  size:    211 KB
  rows:    6,363
  symbols: 3,521

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-05	AAPL	Stock	16.5961	16.8096	16.5054	16.7661	318855600.0
2013-08-05	MSFT	Stock	31.9	32.0	31.64	31.7	30984000.0
2013-08-05	NVDA	Stock	0.368	0.372	0.366	0.3708	185188000.0
2013-08-05	AMZN	Stock	15.17	15.181	14.915	15.0495	44664000.0
2013-08-05	META	Stock	38.43	39.32	38.25	39.19	79994800.0
2013-08-05	TSLA	Stock	9.334	9.6593	9.31	9.6453	153010500.0
2013-08-05	TLT	Stock	106.19	106.2474	105.54	105.7	6611758.0
2013-08-05	ES	Stock	44.63	44.63	44.23	44.26	807800.0
2013-08-05	CL	Stock	60.49	61.08	60.46	60.98	2965100.0
2013-08-05	A	Stock	33.0901	33.1903	32.7611	32.8612	2621809.0
2013-08-05	AABA-DELISTED	Stock	27.71	27.8	27.45	27.67	7823658.0
2013-08-05	AACG	Stock	5.15	5.2	5.01	5.2	5600.0
2013-08-05	AAIC-DELISTED	Stock	25.04	25.09	24.57	24.66	159781.0
2013-08-05	AAMC-DELISTED	Stock	108.8235	108.8235	107.2559	107.2559	4073.0
2013-08-05	AAME	Stock	3.82	3.91	3.8	3.84	2100.0
2013-08-05	AAMRQ-DELISTED	Stock	5.885	6.05	5.88	6.05	3803283.0
2013-08-05	AAON	Stock	10.1867	10.3156	10.0222	10.2978	135450.0
2013-08-05	AAP	Stock	83.19	83.8	82.9	83.41	445700.0
2013-08-05	AAT	Stock	32.42	32.97	32.42	32.83	100400.0
2013-08-05	AAU-DELISTED	Stock	1.75	1.8	1.73	1.74	62936.0
2013-08-05	AAUAF-DELISTED	Stock	1.75	1.8	1.73	1.74	64036.0
2013-08-05	AAV-DELISTED	Stock	3.63	3.67	3.56	3.58	144124.0
2013-08-05	AAWW-DELISTED	Stock	43.57	43.99	43.55	43.8	158273.0
2013-08-05	AAXJ	Stock	56.55	56.65	56.179	56.39	271831.0
2013-08-05	AAXN-DELISTED	Stock	8.84	8.9	8.73	8.77	312007.0
2013-08-05	AB	Stock	22.76	23.22	22.55	23.12	250300.0
2013-08-05	ABAC-DELISTED	Stock	0.61	0.64	0.55	0.59	28295.0
2013-08-05	ABAX-DELISTED	Stock	40.75	40.895	40.21	40.32	93783.0
2013-08-05	ABB-DELISTED	Stock	22.12	22.22	22.06	22.21	701867.0
2013-08-05	ABBNY-DELISTED	Stock	22.12	22.22	22.06	22.22	709747.0
2013-08-05	ABBV	Stock	45.05	45.37	44.48	44.71	2953500.0
2013-08-05	ABC-DELISTED	Stock	58.38	59.095	58.29	59.03	1124043.0
2013-08-05	ABCB	Stock	19.37	19.49	19.23	19.44	35700.0
2013-08-05	ABCD-DELISTED	Stock	1.34	1.34	1.2601	1.28	2900.0
2013-08-05	ABCO-DELISTED	Stock	58.59	59.93	58.19	59.51	135360.0
2013-08-05	ABCW-DELISTED	Stock	0.415	0.425	0.405	0.425	25218.0
2013-08-05	ABE-DELISTED	Stock	19.64	19.9	19.61	19.9	5011.0
2013-08-05	ABEO	Stock	562.5	575.0	487.5	575.0	2.0
2013-08-05	ABFS-DELISTED	Stock	22.82	22.98	22.06	22.33	356649.0
2013-08-05	ABG	Stock	50.85	51.61	49.97	50.5	356700.0
2013-08-05	ABM	Stock	25.95	26.2	25.88	26.16	92400.0
2013-08-05	ABMD-DELISTED	Stock	23.05	23.18	22.43	22.64	538035.0
2013-08-05	ABR	Stock	7.48	7.5	7.27	7.5	159300.0
2013-08-05	ABR.A-DELISTED	Stock	25.1	25.2499	25.1	25.1995	1400.0
2013-08-05	ABR.B-DELISTED	Stock	24.3	24.4499	24.22	24.4489	2105.0
2013-08-05	ABT	Stock	36.64	36.78	36.44	36.45	6511300.0
2013-08-05	ABTL-DELISTED	Stock	5.53	5.65	5.52	5.64	139521.0
2013-08-05	ABUS	Stock	5.99	6.07	5.81	5.91	92100.0
2013-08-05	ABV-DELISTED	Stock	37.95	37.95	37.24	37.52	2099397.0
2013-08-05	ABX-DELISTED	Stock	16.67	16.82	16.35	16.38	11778085.0

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

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