PREVIEW / stock_daily / 2013-12-27

all stock daily files

  file:    by_date/stock_daily/2013/2013-12-27.parquet
  size:    217 KB
  rows:    6,459
  symbols: 3,539

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-12-27	AAPL	Stock	20.1364	20.1575	19.9821	20.0032	225884400.0
2013-12-27	MSFT	Stock	37.58	37.62	37.17	37.29	14563000.0
2013-12-27	NVDA	Stock	0.3938	0.3948	0.3915	0.394	210976000.0
2013-12-27	AMZN	Stock	20.2325	20.2815	19.8125	19.904	39738000.0
2013-12-27	META	Stock	57.48	57.68	55.25	55.44	60466000.0
2013-12-27	TSLA	Stock	10.3533	10.3667	10.0533	10.0747	81903000.0
2013-12-27	TLT	Stock	102.07	102.31	101.69	101.81	4755262.0
2013-12-27	ES	Stock	42.13	42.41	42.01	42.2	1051200.0
2013-12-27	CL	Stock	65.07	65.45	64.99	65.37	1814500.0
2013-12-27	A	Stock	40.9371	41.073	40.8584	40.8941	913034.0
2013-12-27	AABA-DELISTED	Stock	40.72	40.75	40.32	40.476	5865927.0
2013-12-27	AACG	Stock	4.04	4.05	4.0	4.04	2500.0
2013-12-27	AAIC-DELISTED	Stock	26.55	26.82	26.17	26.4	214345.0
2013-12-27	AAL	Stock	25.95	26.1	24.91	24.94	13221000.0
2013-12-27	AAMC-DELISTED	Stock	264.7059	266.7235	264.7059	265.2941	7456.0
2013-12-27	AAME	Stock	4.02	4.05	3.99	4.05	5000.0
2013-12-27	AAOI	Stock	15.0	15.08	14.85	14.89	66800.0
2013-12-27	AAON	Stock	14.5867	14.7422	14.3156	14.5511	208350.0
2013-12-27	AAP	Stock	110.3	111.94	109.63	109.92	364200.0
2013-12-27	AAT	Stock	31.5	31.77	31.41	31.65	136800.0
2013-12-27	AAU-DELISTED	Stock	1.15	1.181	1.1	1.15	133435.0
2013-12-27	AAUAF-DELISTED	Stock	1.13	1.16	1.1	1.15	137563.0
2013-12-27	AAV-DELISTED	Stock	4.36	4.3832	4.29	4.34	110561.0
2013-12-27	AAWW-DELISTED	Stock	40.4	40.63	40.09	40.63	196029.0
2013-12-27	AAXJ	Stock	59.59	59.66	59.45	59.45	641911.0
2013-12-27	AAXN-DELISTED	Stock	16.45	16.69	15.87	15.94	930012.0
2013-12-27	AB	Stock	21.54	21.78	21.43	21.7	461600.0
2013-12-27	ABAC-DELISTED	Stock	2.27	2.32	2.15	2.21	26200.0
2013-12-27	ABAX-DELISTED	Stock	39.07	39.71	38.89	39.63	107763.0
2013-12-27	ABB-DELISTED	Stock	26.48	26.56	26.36	26.44	785960.0
2013-12-27	ABBNY-DELISTED	Stock	26.5	26.56	26.36	26.44	952888.0
2013-12-27	ABBV	Stock	52.92	53.05	52.38	52.55	2354100.0
2013-12-27	ABC-DELISTED	Stock	70.45	70.45	69.825	70.22	805014.0
2013-12-27	ABCB	Stock	21.51	21.58	21.06	21.38	37900.0
2013-12-27	ABCD-DELISTED	Stock	1.61	1.819	1.61	1.7735	42851.0
2013-12-27	ABCO-DELISTED	Stock	63.02	63.14	62.35	62.92	74875.0
2013-12-27	ABE-DELISTED	Stock	13.75	13.8	13.65	13.77	15538.0
2013-12-27	ABEO	Stock	287.5	325.0	275.0	325.0	37.0
2013-12-27	ABEV	Stock	7.19	7.38	7.17	7.37	6966100.0
2013-12-27	ABFS-DELISTED	Stock	34.84	34.99	33.99	34.68	227217.0
2013-12-27	ABG	Stock	54.33	54.55	53.4	54.0	99100.0
2013-12-27	ABGB-DELISTED	Stock	15.17	15.37	14.93	15.28	100596.0
2013-12-27	ABM	Stock	28.62	28.75	28.46	28.66	161900.0
2013-12-27	ABMD-DELISTED	Stock	27.06	27.86	26.67	27.04	114947.0
2013-12-27	ABR	Stock	6.63	6.66	6.55	6.58	130300.0
2013-12-27	ABR.B-DELISTED	Stock	21.75	22.92	21.75	22.3	19264.0
2013-12-27	ABT	Stock	38.52	38.53	38.23	38.37	2705600.0
2013-12-27	ABTL-DELISTED	Stock	15.5253	16.015	15.28	15.29	182770.0
2013-12-27	ABUS	Stock	8.43	8.43	7.74	7.78	162600.0
2013-12-27	ABX-DELISTED	Stock	17.36	17.51	17.3	17.49	7142006.0

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

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