PREVIEW / stock_daily / 2014-03-05

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-05.parquet
  size:    217 KB
  rows:    6,476
  symbols: 3,529

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-03-05	AAPL	Stock	18.9614	19.0982	18.8975	19.0129	200062800.0
2014-03-05	MSFT	Stock	38.25	38.27	37.93	38.11	20520100.0
2014-03-05	NVDA	Stock	0.4615	0.4662	0.4595	0.466	241472000.0
2014-03-05	AMZN	Stock	18.2065	18.6365	18.195	18.6185	76966000.0
2014-03-05	META	Stock	69.69	71.97	69.62	71.57	74567700.0
2014-03-05	TSLA	Stock	17.1147	17.1327	16.7867	16.844	89035500.0
2014-03-05	TLT	Stock	107.34	107.78	107.2	107.62	4798744.0
2014-03-05	ES	Stock	44.1	44.12	43.63	43.76	1438200.0
2014-03-05	CL	Stock	62.82	62.95	62.54	62.62	2401100.0
2014-03-05	A	Stock	41.2804	41.4878	41.1731	41.3448	4352673.0
2014-03-05	AABA-DELISTED	Stock	39.83	40.15	39.19	39.51	11984810.0
2014-03-05	AACG	Stock	4.36	4.36	4.25	4.26	9000.0
2014-03-05	AAIC-DELISTED	Stock	26.84	27.28	26.75	27.26	123920.0
2014-03-05	AAL	Stock	37.6	38.03	37.51	37.86	8793500.0
2014-03-05	AAMC-DELISTED	Stock	230.8176	231.7647	222.3529	227.9412	25466.0
2014-03-05	AAME	Stock	3.82	3.93	3.77	3.87	9000.0
2014-03-05	AAOI	Stock	24.74	25.37	24.27	25.15	163300.0
2014-03-05	AAON	Stock	13.6133	13.88	13.4889	13.6667	150750.0
2014-03-05	AAP	Stock	126.42	126.71	125.08	125.59	692600.0
2014-03-05	AAT	Stock	33.52	33.82	33.19	33.44	68300.0
2014-03-05	AAU-DELISTED	Stock	1.6	1.639	1.59	1.62	205116.0
2014-03-05	AAUAF-DELISTED	Stock	1.6	1.639	1.59	1.62	208374.0
2014-03-05	AAV-DELISTED	Stock	4.03	4.08	4.01	4.05	194978.0
2014-03-05	AAWW-DELISTED	Stock	30.93	31.59	30.8	31.4	165097.0
2014-03-05	AAXJ	Stock	58.0	58.22	57.91	58.21	656688.0
2014-03-05	AAXN-DELISTED	Stock	20.29	20.44	19.5401	19.88	1437183.0
2014-03-05	AB	Stock	24.25	24.3	23.96	24.15	264100.0
2014-03-05	ABAC-DELISTED	Stock	2.0	2.05	1.92	1.98	164293.0
2014-03-05	ABAX-DELISTED	Stock	38.59	38.96	38.39	38.9	132676.0
2014-03-05	ABB-DELISTED	Stock	25.7	25.77	25.64	25.73	966281.0
2014-03-05	ABBNY-DELISTED	Stock	25.7	25.77	25.64	25.74	1067124.0
2014-03-05	ABBV	Stock	51.68	52.12	51.3	51.7	5251100.0
2014-03-05	ABC-DELISTED	Stock	69.0	69.15	68.7	68.9	1299402.0
2014-03-05	ABCB	Stock	21.2	21.36	21.04	21.24	57700.0
2014-03-05	ABCD-DELISTED	Stock	1.96	2.0299	1.92	1.97	41758.0
2014-03-05	ABCO-DELISTED	Stock	67.0	68.24	65.89	66.83	319243.0
2014-03-05	ABE-DELISTED	Stock	12.56	12.56	12.4801	12.5	19945.0
2014-03-05	ABEO	Stock	450.0	487.5	450.0	475.0	21.0
2014-03-05	ABEV	Stock	7.22	7.27	7.08	7.23	7551700.0
2014-03-05	ABFS-DELISTED	Stock	35.08	36.0	34.9	35.75	304373.0
2014-03-05	ABG	Stock	53.06	53.39	52.4	52.82	262500.0
2014-03-05	ABGB-DELISTED	Stock	23.57	23.58	23.4	23.44	11517.0
2014-03-05	ABM	Stock	28.81	28.82	27.63	28.14	626000.0
2014-03-05	ABMD-DELISTED	Stock	28.47	29.24	28.145	29.15	318744.0
2014-03-05	ABR	Stock	6.87	6.88	6.73	6.84	1131100.0
2014-03-05	ABR.A-DELISTED	Stock	24.25	24.34	24.21	24.34	3236.0
2014-03-05	ABR.B-DELISTED	Stock	22.97	23.0	22.86	23.0	10413.0
2014-03-05	ABR.C-DELISTED	Stock	24.25	24.25	24.13	24.198	24869.0
2014-03-05	ABT	Stock	40.49	40.49	39.76	39.79	8285200.0
2014-03-05	ABTL-DELISTED	Stock	14.76	15.61	14.72	14.88	175106.0

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

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