PREVIEW / stock_daily / 2012-07-03

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-03.parquet
  size:    195 KB
  rows:    6,083
  symbols: 3,459

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
2012-07-03	AAPL	Stock	21.2457	21.4286	21.2143	21.4075	241712800.0
2012-07-03	MSFT	Stock	30.23	30.76	30.17	30.76	20938100.0
2012-07-03	NVDA	Stock	0.3362	0.3458	0.336	0.345	219284000.0
2012-07-03	AMZN	Stock	11.457	11.4765	11.3795	11.4765	26634000.0
2012-07-03	META	Stock	30.91	31.44	30.8	31.2	8763600.0
2012-07-03	TSLA	Stock	2.04	2.0667	2.0267	2.044	14205000.0
2012-07-03	TLT	Stock	125.95	126.0	125.21	125.25	5773778.0
2012-07-03	ES	Stock	39.1	39.3	39.04	39.26	712600.0
2012-07-03	CL	Stock	51.85	52.58	51.76	52.305	2071600.0
2012-07-03	A	Stock	27.7682	28.4192	27.7682	28.2833	1357039.0
2012-07-03	AABA-DELISTED	Stock	15.83	15.99	15.815	15.97	8125548.0
2012-07-03	AACC-DELISTED	Stock	7.33	7.58	7.33	7.45	49794.0
2012-07-03	AACG	Stock	4.21	4.26	4.11	4.18	3900.0
2012-07-03	AAIC-DELISTED	Stock	22.43	22.7799	22.39	22.77	41936.0
2012-07-03	AAME	Stock	2.71	2.76	2.64	2.74	7600.0
2012-07-03	AAMRQ-DELISTED	Stock	0.525	0.54	0.525	0.53	328287.0
2012-07-03	AAON	Stock	5.6415	5.7185	5.6148	5.6948	180563.0
2012-07-03	AAP	Stock	67.6	69.22	66.97	69.2	826200.0
2012-07-03	AAT	Stock	24.72	24.99	24.7	24.94	57800.0
2012-07-03	AAU-DELISTED	Stock	2.13	2.24	2.1299	2.19	66310.0
2012-07-03	AAUAF-DELISTED	Stock	2.13	2.24	2.1299	2.19	66810.0
2012-07-03	AAV-DELISTED	Stock	2.98	3.18	2.98	3.16	204990.0
2012-07-03	AAWW-DELISTED	Stock	44.21	46.19	43.7201	45.76	130846.0
2012-07-03	AAXJ	Stock	53.09	53.65	52.87	53.64	798190.0
2012-07-03	AAXN-DELISTED	Stock	5.2	5.3201	5.2	5.32	108968.0
2012-07-03	AB	Stock	12.78	12.97	12.61	12.78	88200.0
2012-07-03	ABAC-DELISTED	Stock	1.22	1.22	1.2	1.21	2487.0
2012-07-03	ABAX-DELISTED	Stock	38.88	39.72	38.4	39.41	150236.0
2012-07-03	ABB-DELISTED	Stock	16.44	16.63	16.4	16.63	1152514.0
2012-07-03	ABBNY-DELISTED	Stock	16.44	16.64	16.4	16.64	1187511.0
2012-07-03	ABC-DELISTED	Stock	39.85	39.88	39.57	39.75	954982.0
2012-07-03	ABCB	Stock	12.74	12.8	12.51	12.64	38300.0
2012-07-03	ABCD-DELISTED	Stock	1.03	1.03	0.96	0.9701	27600.0
2012-07-03	ABCO-DELISTED	Stock	51.02	51.46	51.02	51.46	80276.0
2012-07-03	ABCW-DELISTED	Stock	0.43	0.54	0.43	0.54	39595.0
2012-07-03	ABE-DELISTED	Stock	18.84	19.08	18.83	19.08	6948.0
2012-07-03	ABEO	Stock	737.5	812.5	737.5	812.5	1.0
2012-07-03	ABFS-DELISTED	Stock	12.34	12.4393	12.17	12.23	154381.0
2012-07-03	ABG	Stock	24.86	25.66	24.66	25.57	214600.0
2012-07-03	ABM	Stock	19.34	19.49	19.18	19.49	314400.0
2012-07-03	ABMD-DELISTED	Stock	23.53	23.74	23.09	23.52	222289.0
2012-07-03	ABR	Stock	5.39	5.42	5.32	5.4	78100.0
2012-07-03	ABT	Stock	30.9327	31.187	30.8943	31.1054	6650063.0
2012-07-03	ABTL-DELISTED	Stock	3.725	3.826	3.7245	3.75	14791.0
2012-07-03	ABUS	Stock	2.06	2.14	2.06	2.06	2500.0
2012-07-03	ABV-DELISTED	Stock	38.62	38.68	37.93	38.67	1612002.0
2012-07-03	ABX-DELISTED	Stock	38.47	39.0	38.2	38.7	5151178.0
2012-07-03	ACAD	Stock	1.85	1.93	1.82	1.86	651000.0
2012-07-03	ACAS-DELISTED	Stock	10.11	10.25	10.11	10.2	1511663.0
2012-07-03	ACAT-DELISTED	Stock	37.84	38.59	37.41	38.27	212073.0

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

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