PREVIEW / stock_daily / 2014-08-04

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-04.parquet
  size:    221 KB
  rows:    6,608
  symbols: 3,562

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
2014-08-04	AAPL	Stock	24.0925	24.145	23.7925	23.8975	159832000.0
2014-08-04	MSFT	Stock	42.97	43.47	42.81	43.37	34277400.0
2014-08-04	NVDA	Stock	0.4418	0.4455	0.439	0.4412	241724000.0
2014-08-04	AMZN	Stock	15.442	15.809	15.425	15.6825	84018000.0
2014-08-04	GOOGL	Stock	28.8255	29.191	28.613	29.1135	30496360.0
2014-08-04	META	Stock	72.36	73.88	72.36	73.51	30777000.0
2014-08-04	TSLA	Stock	15.6253	16.0333	15.5513	15.9013	89395500.0
2014-08-04	TLT	Stock	114.53	114.81	114.26	114.26	5183753.0
2014-08-04	ES	Stock	43.79	43.79	42.44	43.19	3623500.0
2014-08-04	CL	Stock	63.88	64.13	63.56	63.76	4342400.0
2014-08-04	A	Stock	40.1931	40.3433	39.7639	40.2432	1338725.0
2014-08-04	AABA-DELISTED	Stock	35.71	36.66	35.65	36.51	12614154.0
2014-08-04	AACG	Stock	4.47	4.75	4.47	4.75	6400.0
2014-08-04	AAIC-DELISTED	Stock	26.17	26.549	26.17	26.51	205370.0
2014-08-04	AAL	Stock	39.49	39.85	37.63	38.14	11090100.0
2014-08-04	AAMC-DELISTED	Stock	164.7059	166.1765	142.65	161.2471	161476.0
2014-08-04	AAME	Stock	4.08	4.08	3.91	3.97	8200.0
2014-08-04	AAOI	Stock	19.0	20.13	18.75	19.23	363700.0
2014-08-04	AAON	Stock	13.1733	13.3933	12.9067	13.3733	333300.0
2014-08-04	AAP	Stock	121.72	124.35	121.17	124.02	819200.0
2014-08-04	AAT	Stock	34.31	34.59	34.02	34.5	162600.0
2014-08-04	AAU-DELISTED	Stock	1.36	1.4	1.36	1.38	95339.0
2014-08-04	AAUAF-DELISTED	Stock	1.36	1.4	1.36	1.38	98407.0
2014-08-04	AAV-DELISTED	Stock	5.31	5.38	5.28	5.36	118033.0
2014-08-04	AAVL-DELISTED	Stock	24.98	26.3999	24.0	24.25	133629.0
2014-08-04	AAWW-DELISTED	Stock	32.16	32.45	31.26	32.26	381837.0
2014-08-04	AAXJ	Stock	65.05	65.31	64.82	65.26	746286.0
2014-08-04	AAXN-DELISTED	Stock	11.51	11.6386	11.28	11.44	673948.0
2014-08-04	AB	Stock	26.03	26.63	25.71	26.47	344800.0
2014-08-04	ABAC-DELISTED	Stock	1.98	2.0	1.96	1.99	25175.0
2014-08-04	ABAX-DELISTED	Stock	47.21	47.5699	45.99	47.45	175322.0
2014-08-04	ABB-DELISTED	Stock	22.85	22.88	22.67	22.83	1117429.0
2014-08-04	ABBNY-DELISTED	Stock	22.85	22.88	22.67	22.83	1190699.0
2014-08-04	ABBV	Stock	52.58	53.4	52.37	53.29	10456300.0
2014-08-04	ABC-DELISTED	Stock	77.28	77.92	76.54	77.8	3058113.0
2014-08-04	ABCB	Stock	21.78	21.78	21.38	21.62	107900.0
2014-08-04	ABCD-DELISTED	Stock	2.0	2.25	1.84	1.92	7800.0
2014-08-04	ABCO-DELISTED	Stock	47.68	47.68	46.37	46.88	405960.0
2014-08-04	ABDC-DELISTED	Stock	12.97	13.15	12.36	12.98	69198.0
2014-08-04	ABE-DELISTED	Stock	14.46	14.48	14.3468	14.43	18374.0
2014-08-04	ABEO	Stock	337.5	350.0	325.0	337.5	19.0
2014-08-04	ABEV	Stock	6.92	6.94	6.78	6.88	20659600.0
2014-08-04	ABG	Stock	68.46	69.28	68.25	68.68	178900.0
2014-08-04	ABGB-DELISTED	Stock	26.33	26.85	26.33	26.85	1136.0
2014-08-04	ABM	Stock	24.65	24.79	24.22	24.71	227700.0
2014-08-04	ABMD-DELISTED	Stock	25.54	25.734	24.68	25.3	328410.0
2014-08-04	ABR	Stock	7.11	7.11	6.94	7.0	305100.0
2014-08-04	ABR.A-DELISTED	Stock	25.02	25.05	24.82	24.9999	7475.0
2014-08-04	ABR.B-DELISTED	Stock	24.6308	24.64	24.5	24.55	7274.0
2014-08-04	ABR.C-DELISTED	Stock	25.34	25.44	25.25	25.2899	4736.0

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

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