PREVIEW / stock_daily / 2014-08-12

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-12.parquet
  size:    220 KB
  rows:    6,598
  symbols: 3,568

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-12	AAPL	Stock	24.01	24.22	23.9025	23.9925	135180000.0
2014-08-12	MSFT	Stock	43.04	43.59	43.0	43.52	21431100.0
2014-08-12	NVDA	Stock	0.4723	0.475	0.4673	0.4725	296152000.0
2014-08-12	AMZN	Stock	15.9445	16.0655	15.8475	15.966	38316000.0
2014-08-12	GOOGL	Stock	28.75	28.795	28.4955	28.606	27891220.0
2014-08-12	META	Stock	73.09	73.33	72.22	72.83	27419000.0
2014-08-12	TSLA	Stock	17.2053	17.3533	16.972	17.3307	95734500.0
2014-08-12	TLT	Stock	115.41	115.44	114.73	114.76	8125463.0
2014-08-12	ES	Stock	43.2	43.42	43.04	43.27	764100.0
2014-08-12	CL	Stock	64.53	64.84	64.33	64.42	4138700.0
2014-08-12	A	Stock	39.3348	39.392	38.8412	38.8698	3693656.0
2014-08-12	AABA-DELISTED	Stock	35.8	35.99	35.1521	35.52	12374585.0
2014-08-12	AACG	Stock	4.53	4.53	4.44	4.49	9600.0
2014-08-12	AAIC-DELISTED	Stock	26.93	27.08	26.83	27.0	117488.0
2014-08-12	AAL	Stock	38.14	38.14	37.27	37.52	6223700.0
2014-08-12	AAMC-DELISTED	Stock	165.7294	170.5882	163.8235	164.7088	13423.0
2014-08-12	AAME	Stock	4.24	4.24	4.07	4.1	9000.0
2014-08-12	AAOI	Stock	18.16	18.23	16.83	16.98	311400.0
2014-08-12	AAON	Stock	12.6533	12.7867	12.32	12.36	201000.0
2014-08-12	AAP	Stock	125.21	125.59	123.5	124.71	613300.0
2014-08-12	AAT	Stock	34.89	35.16	34.71	34.87	82600.0
2014-08-12	AAU-DELISTED	Stock	1.52	1.53	1.42	1.48	182227.0
2014-08-12	AAUAF-DELISTED	Stock	1.51	1.52	1.42	1.49	183799.0
2014-08-12	AAV-DELISTED	Stock	5.46	5.55	5.3	5.31	336691.0
2014-08-12	AAVL-DELISTED	Stock	23.5	24.13	22.51	23.75	118473.0
2014-08-12	AAWW-DELISTED	Stock	34.07	34.16	33.48	33.53	113325.0
2014-08-12	AAXJ	Stock	64.78	64.96	64.64	64.93	380711.0
2014-08-12	AAXN-DELISTED	Stock	12.34	12.46	11.97	12.02	752875.0
2014-08-12	AB	Stock	25.2	25.47	25.0	25.15	286000.0
2014-08-12	ABAC-DELISTED	Stock	1.98	1.99	1.8111	1.85	48610.0
2014-08-12	ABAX-DELISTED	Stock	44.98	46.42	44.94	46.42	115508.0
2014-08-12	ABB-DELISTED	Stock	22.43	22.51	22.41	22.455	643180.0
2014-08-12	ABBNY-DELISTED	Stock	22.43	22.51	22.41	22.45	688672.0
2014-08-12	ABBV	Stock	53.22	53.3	52.57	52.84	8524600.0
2014-08-12	ABC-DELISTED	Stock	75.94	76.12	75.6	75.83	970889.0
2014-08-12	ABCB	Stock	22.15	22.23	22.04	22.12	102400.0
2014-08-12	ABCD-DELISTED	Stock	1.91	1.93	1.81	1.88	8536.0
2014-08-12	ABCO-DELISTED	Stock	49.78	50.5	49.44	50.27	242247.0
2014-08-12	ABDC-DELISTED	Stock	12.08	12.7199	12.08	12.41	204407.0
2014-08-12	ABE-DELISTED	Stock	14.42	14.45	14.39	14.41	6746.0
2014-08-12	ABEO	Stock	350.0	375.0	325.0	375.0	24.0
2014-08-12	ABEV	Stock	6.89	6.96	6.85	6.93	9420400.0
2014-08-12	ABG	Stock	69.21	69.7	68.5	68.93	108500.0
2014-08-12	ABGB-DELISTED	Stock	25.44	26.3	25.44	26.23	11649.0
2014-08-12	ABM	Stock	25.42	25.78	25.21	25.38	217200.0
2014-08-12	ABMD-DELISTED	Stock	25.49	25.82	25.28	25.51	180218.0
2014-08-12	ABR	Stock	7.08	7.08	6.97	6.97	186000.0
2014-08-12	ABR.A-DELISTED	Stock	25.0952	25.15	25.0252	25.15	4608.0
2014-08-12	ABR.B-DELISTED	Stock	24.43	24.6702	24.43	24.6699	6391.0
2014-08-12	ABR.C-DELISTED	Stock	25.49	25.49	25.36	25.48	5009.0

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

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