PREVIEW / stock_daily / 2012-12-21

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-21.parquet
  size:    205 KB
  rows:    6,253
  symbols: 3,528

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-12-21	AAPL	Stock	18.3025	18.5596	18.2229	18.5475	596268400.0
2012-12-21	MSFT	Stock	27.45	27.49	27.0	27.45	98776500.0
2012-12-21	NVDA	Stock	0.3118	0.3118	0.3052	0.3088	462172000.0
2012-12-21	AMZN	Stock	12.891	12.919	12.787	12.846	94092000.0
2012-12-21	META	Stock	26.66	27.01	26.12	26.26	54555200.0
2012-12-21	TSLA	Stock	2.2627	2.278	2.2387	2.2667	22386000.0
2012-12-21	TLT	Stock	122.31	122.43	121.95	122.25	6087603.0
2012-12-21	ES	Stock	39.27	39.5	39.19	39.23	3207200.0
2012-12-21	CL	Stock	52.59	53.04	52.42	52.55	5503400.0
2012-12-21	A	Stock	29.0987	29.3634	28.3691	29.3634	6592688.0
2012-12-21	AABA-DELISTED	Stock	19.49	19.49	19.23	19.35	31072388.0
2012-12-21	AACC-DELISTED	Stock	4.52	4.59	4.26	4.48	148411.0
2012-12-21	AACG	Stock	4.61	5.69	4.61	5.6	73300.0
2012-12-21	AAIC-DELISTED	Stock	21.02	21.38	20.671	21.23	246460.0
2012-12-21	AAMC-DELISTED	Stock	23.6765	23.9706	22.9412	23.5294	66922.0
2012-12-21	AAME	Stock	2.85	2.85	2.85	2.85	300.0
2012-12-21	AAMRQ-DELISTED	Stock	0.8639	0.867	0.75	0.81	11586801.0
2012-12-21	AAON	Stock	5.9259	6.0	5.917	5.9704	1306125.0
2012-12-21	AAP	Stock	70.94	71.56	70.02	70.27	1210300.0
2012-12-21	AAT	Stock	27.31	27.83	27.26	27.49	285700.0
2012-12-21	AAU-DELISTED	Stock	2.93	3.04	2.86	3.03	171955.0
2012-12-21	AAUAF-DELISTED	Stock	2.96	3.07	2.89	3.03	171064.0
2012-12-21	AAV-DELISTED	Stock	3.33	3.33	3.2527	3.3	303226.0
2012-12-21	AAWW-DELISTED	Stock	43.4	44.45	42.82	44.44	279387.0
2012-12-21	AAXJ	Stock	58.79	58.99	58.61	58.97	297638.0
2012-12-21	AAXN-DELISTED	Stock	8.56	9.119	8.34	8.69	2022024.0
2012-12-21	AB	Stock	16.78	17.01	16.52	16.73	437100.0
2012-12-21	ABAC-DELISTED	Stock	0.85	0.92	0.85	0.88	5961.0
2012-12-21	ABAX-DELISTED	Stock	37.33	37.64	36.4	37.21	233950.0
2012-12-21	ABB-DELISTED	Stock	20.65	20.84	20.61	20.83	1679390.0
2012-12-21	ABBNY-DELISTED	Stock	20.64	20.84	20.61	20.83	1730476.0
2012-12-21	ABC-DELISTED	Stock	43.44	43.93	43.43	43.66	3637535.0
2012-12-21	ABCB	Stock	12.53	12.59	12.23	12.48	153700.0
2012-12-21	ABCD-DELISTED	Stock	1.1	1.4	1.1	1.38	63813.0
2012-12-21	ABCO-DELISTED	Stock	49.14	49.21	48.4	49.09	352438.0
2012-12-21	ABCW-DELISTED	Stock	0.3251	0.34	0.321	0.34	14456.0
2012-12-21	ABE-DELISTED	Stock	21.01	21.13	20.78	20.82	10687.0
2012-12-21	ABEO	Stock	287.5	350.0	287.5	312.5	128.0
2012-12-21	ABFS-DELISTED	Stock	9.17	9.59	8.85	9.55	726014.0
2012-12-21	ABG	Stock	31.0	31.35	30.78	31.11	480300.0
2012-12-21	ABM	Stock	20.26	20.26	19.93	20.21	525600.0
2012-12-21	ABMD-DELISTED	Stock	13.56	13.8	13.41	13.68	4610892.0
2012-12-21	ABR	Stock	6.12	6.22	5.97	5.97	141700.0
2012-12-21	ABT	Stock	31.2878	31.6956	31.187	31.6908	31168404.0
2012-12-21	ABTL-DELISTED	Stock	3.8	4.03	3.8	4.0	2643.0
2012-12-21	ABUS	Stock	5.0	5.03	4.93	4.94	5100.0
2012-12-21	ABV-DELISTED	Stock	41.45	41.76	41.39	41.69	3206375.0
2012-12-21	ABVA-DELISTED	Stock	4.69	4.723	4.59	4.62	9038.0
2012-12-21	ABX-DELISTED	Stock	33.62	33.93	33.29	33.4	11971461.0
2012-12-21	ACAD	Stock	4.6	4.67	4.5	4.51	2461800.0

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

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