PREVIEW / stock_daily / 2012-03-14

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-14.parquet
  size:    200 KB
  rows:    6,184
  symbols: 3,554

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-03-14	AAPL	Stock	20.6446	21.24	20.55	21.0564	1418844000.0
2012-03-14	MSFT	Stock	32.53	32.88	32.49	32.77	41986900.0
2012-03-14	NVDA	Stock	0.3698	0.3705	0.358	0.3592	735708000.0
2012-03-14	AMZN	Stock	9.1825	9.216	9.057	9.113	73994000.0
2012-03-14	TSLA	Stock	2.4	2.4	2.32	2.3527	12772500.0
2012-03-14	TLT	Stock	112.7	112.75	110.95	111.04	24515309.0
2012-03-14	ES	Stock	37.54	37.64	36.63	36.74	1432300.0
2012-03-14	CL	Stock	47.575	47.87	47.535	47.575	3552000.0
2012-03-14	A	Stock	32.289	32.3534	31.9456	32.1674	3831499.0
2012-03-14	AABA-DELISTED	Stock	14.54	14.6401	14.42	14.63	14572730.0
2012-03-14	AACC-DELISTED	Stock	4.83	5.04	4.631	4.79	28335.0
2012-03-14	AACG	Stock	6.3	6.36	6.3	6.3	10800.0
2012-03-14	AAIC-DELISTED	Stock	24.95	25.0	24.5	24.58	56919.0
2012-03-14	AAME	Stock	2.91	2.96	2.8	2.88	7600.0
2012-03-14	AAMRQ-DELISTED	Stock	0.49	0.51	0.49	0.5098	2554977.0
2012-03-14	AAON	Stock	5.6622	5.9259	5.6119	5.8667	236588.0
2012-03-14	AAP	Stock	88.49	89.41	88.24	89.17	791200.0
2012-03-14	AAT	Stock	22.34	22.57	21.99	22.11	202300.0
2012-03-14	AAU-DELISTED	Stock	2.77	2.88	2.6	2.67	219331.0
2012-03-14	AAUAF-DELISTED	Stock	2.8	2.88	2.6	2.67	220131.0
2012-03-14	AAV-DELISTED	Stock	3.73	3.76	3.64	3.67	407394.0
2012-03-14	AAWW-DELISTED	Stock	46.1	46.21	44.76	45.55	340080.0
2012-03-14	AAXJ	Stock	58.02	58.25	57.428	57.506	271656.0
2012-03-14	AAXN-DELISTED	Stock	4.11	4.14	4.01	4.06	345886.0
2012-03-14	AB	Stock	15.6	15.6	14.88	15.1	317500.0
2012-03-14	ABAC-DELISTED	Stock	1.59	1.69	1.59	1.66	34008.0
2012-03-14	ABAX-DELISTED	Stock	27.7	27.94	27.35	27.47	56823.0
2012-03-14	ABB-DELISTED	Stock	20.55	20.73	20.51	20.65	2477772.0
2012-03-14	ABBNY-DELISTED	Stock	20.55	20.73	20.51	20.66	2813222.0
2012-03-14	ABC-DELISTED	Stock	37.88	38.51	37.82	38.25	3146476.0
2012-03-14	ABCB	Stock	12.27	12.44	12.17	12.4	43300.0
2012-03-14	ABCD-DELISTED	Stock	3.04	3.04	2.8708	2.95	10642.0
2012-03-14	ABCO-DELISTED	Stock	42.33	43.54	42.3	42.82	298867.0
2012-03-14	ABCW-DELISTED	Stock	0.5522	0.5522	0.5522	0.5522	8320.0
2012-03-14	ABD-DELISTED	Stock	12.31	12.5	12.24	12.5	357160.0
2012-03-14	ABE-DELISTED	Stock	19.51	19.55	19.36	19.36	5101.0
2012-03-14	ABEO	Stock	1412.5	1437.5	1375.0	1400.0	3.0
2012-03-14	ABFS-DELISTED	Stock	18.69	18.788	18.28	18.55	113413.0
2012-03-14	ABG	Stock	27.35	27.75	27.2	27.26	220000.0
2012-03-14	ABH-DELISTED	Stock	15.59	15.59	15.05	15.28	181587.0
2012-03-14	ABM	Stock	23.61	23.75	23.31	23.35	129500.0
2012-03-14	ABMD-DELISTED	Stock	22.37	22.41	22.05	22.21	365430.0
2012-03-14	ABR	Stock	5.28	5.49	5.28	5.36	43400.0
2012-03-14	ABT	Stock	28.2218	28.3034	28.1403	28.3034	15118174.0
2012-03-14	ABTL-DELISTED	Stock	4.9527	5.1043	4.7	4.7	42756.0
2012-03-14	ABUS	Stock	2.38	2.38	2.28	2.3	15800.0
2012-03-14	ABV-DELISTED	Stock	41.26	41.85	41.155	41.21	3011834.0
2012-03-14	ABVA-DELISTED	Stock	4.22	4.31	4.12	4.23	9922.0
2012-03-14	ABVT-DELISTED	Stock	71.97	72.28	71.3	71.91	101391.0
2012-03-14	ABX-DELISTED	Stock	44.71	44.73	42.72	43.28	22126579.0

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

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