PREVIEW / stock_daily / 2012-07-20

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-20.parquet
  size:    198 KB
  rows:    6,103
  symbols: 3,476

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-20	AAPL	Stock	21.8939	21.9443	21.5607	21.5821	397471200.0
2012-07-20	MSFT	Stock	31.0	31.05	30.05	30.12	64021700.0
2012-07-20	NVDA	Stock	0.3278	0.33	0.3168	0.3203	451000000.0
2012-07-20	AMZN	Stock	11.268	11.4695	11.2645	11.4145	83400000.0
2012-07-20	META	Stock	29.0	29.47	28.72	28.76	11869100.0
2012-07-20	TSLA	Stock	2.138	2.15	2.0833	2.1193	23527500.0
2012-07-20	TLT	Stock	129.6	130.3	129.42	130.06	6366359.0
2012-07-20	ES	Stock	40.17	40.46	40.05	40.26	1470700.0
2012-07-20	CL	Stock	52.445	52.665	51.835	51.95	5090400.0
2012-07-20	A	Stock	27.3319	27.3319	26.7811	26.867	2571761.0
2012-07-20	AABA-DELISTED	Stock	15.75	15.94	15.68	15.91	16139827.0
2012-07-20	AACC-DELISTED	Stock	6.83	6.85	6.64	6.66	26590.0
2012-07-20	AACG	Stock	4.04	4.31	3.54	3.65	116600.0
2012-07-20	AAIC-DELISTED	Stock	22.27	22.41	22.021	22.06	55029.0
2012-07-20	AAME	Stock	2.77	2.8	2.61	2.8	2400.0
2012-07-20	AAMRQ-DELISTED	Stock	0.5395	0.55	0.53	0.54	610885.0
2012-07-20	AAON	Stock	5.9111	5.9615	5.837	5.8578	150188.0
2012-07-20	AAP	Stock	73.0	73.25	71.97	72.53	857600.0
2012-07-20	AAT	Stock	24.76	25.07	24.76	25.06	111400.0
2012-07-20	AAU-DELISTED	Stock	1.9	1.94	1.88	1.91	56831.0
2012-07-20	AAUAF-DELISTED	Stock	1.92	1.96	1.9	1.91	56346.0
2012-07-20	AAV-DELISTED	Stock	3.31	3.54	3.3	3.45	281482.0
2012-07-20	AAWW-DELISTED	Stock	46.12	46.12	43.42	43.56	197849.0
2012-07-20	AAXJ	Stock	52.04	52.2	51.78	51.94	247113.0
2012-07-20	AAXN-DELISTED	Stock	4.82	4.87	4.75	4.84	305980.0
2012-07-20	AB	Stock	12.49	12.88	11.93	11.98	230900.0
2012-07-20	ABAC-DELISTED	Stock	1.13	1.14	1.11	1.11	8690.0
2012-07-20	ABAX-DELISTED	Stock	38.98	38.98	37.11	37.28	169310.0
2012-07-20	ABB-DELISTED	Stock	16.17	16.22	16.08	16.18	2805021.0
2012-07-20	ABBNY-DELISTED	Stock	16.17	16.22	16.08	16.2	2813158.0
2012-07-20	ABC-DELISTED	Stock	39.4	39.59	39.04	39.22	1743465.0
2012-07-20	ABCB	Stock	12.01	12.2	11.91	12.03	34000.0
2012-07-20	ABCO-DELISTED	Stock	48.4	48.79	45.88	46.85	539350.0
2012-07-20	ABCW-DELISTED	Stock	0.42	0.43	0.42	0.43	12688.0
2012-07-20	ABE-DELISTED	Stock	19.3	19.3	19.11	19.2	9623.0
2012-07-20	ABEO	Stock	575.0	575.0	400.0	425.0	179.0
2012-07-20	ABFS-DELISTED	Stock	11.77	11.78	11.59	11.65	330606.0
2012-07-20	ABG	Stock	27.14	27.54	27.02	27.15	486700.0
2012-07-20	ABM	Stock	19.11	19.46	18.87	18.99	4392600.0
2012-07-20	ABMD-DELISTED	Stock	23.5	23.7674	23.18	23.33	260121.0
2012-07-20	ABR	Stock	5.35	5.36	5.28	5.31	35200.0
2012-07-20	ABT	Stock	31.4701	31.5133	31.1342	31.2158	14294706.0
2012-07-20	ABTL-DELISTED	Stock	3.72	3.76	3.63	3.74	6495.0
2012-07-20	ABUS	Stock	2.52	2.72	2.52	2.6	20700.0
2012-07-20	ABV-DELISTED	Stock	37.19	37.46	36.91	37.38	2192195.0
2012-07-20	ABX-DELISTED	Stock	34.74	35.04	34.43	34.55	6260117.0
2012-07-20	ACAD	Stock	1.58	1.58	1.5	1.56	326800.0
2012-07-20	ACAS-DELISTED	Stock	9.82	9.98	9.8	9.895	2043773.0
2012-07-20	ACAT-DELISTED	Stock	37.41	37.58	36.32	37.47	82503.0
2012-07-20	ACC-DELISTED	Stock	46.62	47.19	46.49	47.15	1607577.0

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

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