PREVIEW / stock_daily / 2013-03-19

all stock daily files

  file:    by_date/stock_daily/2013/2013-03-19.parquet
  size:    207 KB
  rows:    6,261
  symbols: 3,480

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
2013-03-19	AAPL	Stock	16.4107	16.4632	16.0179	16.2318	526775200.0
2013-03-19	MSFT	Stock	28.12	28.22	28.03	28.18	51901600.0
2013-03-19	NVDA	Stock	0.314	0.3155	0.3095	0.3118	355480000.0
2013-03-19	AMZN	Stock	12.92	12.975	12.631	12.8205	74770000.0
2013-03-19	META	Stock	26.53	26.9	26.21	26.55	25254200.0
2013-03-19	TSLA	Stock	2.35	2.3733	2.3293	2.3387	16477500.0
2013-03-19	TLT	Stock	116.78	117.89	116.7	117.43	11987175.0
2013-03-19	ES	Stock	42.51	42.69	42.23	42.39	951600.0
2013-03-19	CL	Stock	56.055	56.34	55.985	56.27	4108000.0
2013-03-19	A	Stock	30.5293	30.6295	29.7496	30.0429	8732607.0
2013-03-19	AABA-DELISTED	Stock	22.06	22.33	21.89	22.16	12656731.0
2013-03-19	AACC-DELISTED	Stock	6.5	6.5	6.48	6.485	299211.0
2013-03-19	AAIC-DELISTED	Stock	25.96	26.035	25.5801	25.72	410477.0
2013-03-19	AAMC-DELISTED	Stock	41.9118	42.3529	41.5441	42.1324	55984.0
2013-03-19	AAME	Stock	3.35	3.35	3.1	3.34	2100.0
2013-03-19	AAMRQ-DELISTED	Stock	3.91	4.15	3.91	4.02	11302670.0
2013-03-19	AAON	Stock	7.7778	7.8074	7.76	7.7778	238613.0
2013-03-19	AAP	Stock	80.64	80.94	79.77	80.07	1370300.0
2013-03-19	AAT	Stock	32.27	32.38	31.77	31.99	90700.0
2013-03-19	AAU-DELISTED	Stock	2.15	2.21	2.1	2.21	165696.0
2013-03-19	AAUAF-DELISTED	Stock	2.15	2.21	2.1	2.21	168728.0
2013-03-19	AAV-DELISTED	Stock	3.43	3.44	3.31	3.34	241656.0
2013-03-19	AAWW-DELISTED	Stock	44.3	44.348	43.19	43.69	132355.0
2013-03-19	AAXJ	Stock	58.23	58.24	57.54	57.87	426817.0
2013-03-19	AAXN-DELISTED	Stock	7.78	7.89	7.67	7.87	401011.0
2013-03-19	AB	Stock	21.88	22.0	21.26	21.61	348000.0
2013-03-19	ABAC-DELISTED	Stock	0.7	0.8	0.7	0.8	18564.0
2013-03-19	ABAX-DELISTED	Stock	46.07	46.73	45.15	46.6	133874.0
2013-03-19	ABB-DELISTED	Stock	22.77	22.8	22.45	22.615	1237830.0
2013-03-19	ABBNY-DELISTED	Stock	22.77	22.8	22.45	22.63	1257214.0
2013-03-19	ABBV	Stock	38.25	38.4	37.84	38.36	5108400.0
2013-03-19	ABC-DELISTED	Stock	51.39	52.15	49.92	50.055	16935337.0
2013-03-19	ABCB	Stock	14.43	14.45	14.1	14.19	51000.0
2013-03-19	ABCD-DELISTED	Stock	1.0844	1.12	1.0844	1.12	1115.0
2013-03-19	ABCO-DELISTED	Stock	49.52	49.7	49.23	49.54	203507.0
2013-03-19	ABCW-DELISTED	Stock	0.58	0.65	0.58	0.6	31405.0
2013-03-19	ABE-DELISTED	Stock	20.9	20.929	20.7	20.929	3708.0
2013-03-19	ABEO	Stock	662.5	750.0	662.5	750.0	4.0
2013-03-19	ABFS-DELISTED	Stock	12.64	12.78	12.39	12.41	263189.0
2013-03-19	ABG	Stock	37.36	37.51	36.8	37.07	573400.0
2013-03-19	ABM	Stock	22.0	22.17	21.89	22.01	152700.0
2013-03-19	ABMD-DELISTED	Stock	17.64	17.68	17.19	17.58	622119.0
2013-03-19	ABR	Stock	8.25	8.34	8.09	8.12	171100.0
2013-03-19	ABR.A-DELISTED	Stock	25.5	25.6	25.4	25.4999	19724.0
2013-03-19	ABT	Stock	33.52	33.74	33.27	33.54	7540600.0
2013-03-19	ABTL-DELISTED	Stock	4.23	4.25	4.23	4.25	700.0
2013-03-19	ABUS	Stock	4.48	4.53	4.46	4.49	61900.0
2013-03-19	ABV-DELISTED	Stock	43.14	43.22	42.77	43.14	1210952.0
2013-03-19	ABX-DELISTED	Stock	28.87	29.15	28.67	28.82	8998777.0
2013-03-19	ACAD	Stock	6.5	6.64	6.27	6.58	3058500.0

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

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