PREVIEW / stock_daily / 2012-09-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-27.parquet
  size:    200 KB
  rows:    6,160
  symbols: 3,486

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-09-27	AAPL	Stock	23.7246	24.3632	23.5839	24.3329	594090000.0
2012-09-27	MSFT	Stock	30.17	30.4	29.89	30.16	47129900.0
2012-09-27	NVDA	Stock	0.3303	0.3325	0.3275	0.332	558888000.0
2012-09-27	AMZN	Stock	12.527	12.87	12.526	12.8295	67948000.0
2012-09-27	META	Stock	20.99	21.0	20.16	20.32	30215900.0
2012-09-27	TSLA	Stock	1.8547	1.9027	1.84	1.8993	26379000.0
2012-09-27	TLT	Stock	124.55	124.8	123.77	124.15	5147680.0
2012-09-27	ES	Stock	38.22	38.28	37.78	37.92	856100.0
2012-09-27	CL	Stock	53.525	53.8	53.17	53.675	2638600.0
2012-09-27	A	Stock	27.5322	27.7754	27.3534	27.5966	4773751.0
2012-09-27	AABA-DELISTED	Stock	15.91	16.2	15.79	16.04	24259791.0
2012-09-27	AACC-DELISTED	Stock	7.47	7.7	7.41	7.7	16759.0
2012-09-27	AACG	Stock	4.82	5.26	4.6	5.01	13300.0
2012-09-27	AAIC-DELISTED	Stock	23.92	24.21	23.87	24.06	278117.0
2012-09-27	AAME	Stock	2.75	2.75	2.75	2.75	5400.0
2012-09-27	AAMRQ-DELISTED	Stock	0.4	0.43	0.4	0.4185	6179292.0
2012-09-27	AAON	Stock	5.84	5.9259	5.76	5.9081	243675.0
2012-09-27	AAP	Stock	68.06	68.27	67.25	68.12	466000.0
2012-09-27	AAT	Stock	26.75	27.17	26.66	26.97	377300.0
2012-09-27	AAU-DELISTED	Stock	2.77	2.84	2.74	2.76	122762.0
2012-09-27	AAUAF-DELISTED	Stock	2.73	2.8	2.7	2.76	126929.0
2012-09-27	AAV-DELISTED	Stock	3.71	3.74	3.64	3.73	116728.0
2012-09-27	AAWW-DELISTED	Stock	52.5	53.57	52.07	53.33	164813.0
2012-09-27	AAXJ	Stock	56.16	56.54	55.97	56.41	169936.0
2012-09-27	AAXN-DELISTED	Stock	5.92	6.07	5.89	6.05	533364.0
2012-09-27	AB	Stock	15.6	15.76	15.45	15.62	229700.0
2012-09-27	ABAC-DELISTED	Stock	1.27	1.45	1.26	1.4484	21900.0
2012-09-27	ABAX-DELISTED	Stock	36.345	36.73	35.82	36.4	132801.0
2012-09-27	ABB-DELISTED	Stock	19.02	19.19	18.8915	19.16	1882205.0
2012-09-27	ABBNY-DELISTED	Stock	19.02	19.19	18.8915	19.18	1914492.0
2012-09-27	ABC-DELISTED	Stock	38.7	39.06	38.49	39.01	2062814.0
2012-09-27	ABCB	Stock	12.73	12.95	12.55	12.83	25800.0
2012-09-27	ABCD-DELISTED	Stock	0.97	1.01	0.97	0.99	852.0
2012-09-27	ABCO-DELISTED	Stock	47.26	47.55	46.8	47.36	131747.0
2012-09-27	ABCW-DELISTED	Stock	0.38	0.42	0.38	0.42	15428.0
2012-09-27	ABE-DELISTED	Stock	20.27	20.66	20.2504	20.65	18870.0
2012-09-27	ABEO	Stock	562.5	575.0	562.5	575.0	78.0
2012-09-27	ABFS-DELISTED	Stock	8.16	8.18	7.89	8.04	401169.0
2012-09-27	ABG	Stock	27.93	28.36	27.82	28.27	157600.0
2012-09-27	ABM	Stock	19.0	19.08	18.84	19.03	492300.0
2012-09-27	ABMD-DELISTED	Stock	21.63	21.85	21.42	21.45	344684.0
2012-09-27	ABR	Stock	6.01	6.12	5.95	6.08	68000.0
2012-09-27	ABT	Stock	33.2453	33.4181	33.1302	33.2597	7479992.0
2012-09-27	ABTL-DELISTED	Stock	3.7301	3.78	3.6716	3.78	5968.0
2012-09-27	ABUS	Stock	3.81	3.87	3.67	3.7	27200.0
2012-09-27	ABV-DELISTED	Stock	38.27	38.61	37.98	38.61	1473927.0
2012-09-27	ABVA-DELISTED	Stock	4.73	4.73	4.6	4.62	798.0
2012-09-27	ABX-DELISTED	Stock	41.39	41.86	41.02	41.85	7776371.0
2012-09-27	ACAD	Stock	2.65	2.65	2.49	2.55	1087500.0
2012-09-27	ACAS-DELISTED	Stock	11.36	11.785	11.3	11.71	2359907.0

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

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