PREVIEW / stock_daily / 2013-04-22

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-22.parquet
  size:    206 KB
  rows:    6,274
  symbols: 3,487

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-04-22	AAPL	Stock	14.0229	14.3643	13.9739	14.2382	429920400.0
2013-04-22	MSFT	Stock	30.3	31.18	30.27	30.83	137904000.0
2013-04-22	NVDA	Stock	0.314	0.3175	0.3115	0.3148	245568000.0
2013-04-22	AMZN	Stock	12.9675	13.23	12.9015	13.1775	42382000.0
2013-04-22	META	Stock	25.81	26.36	25.7	25.97	25687600.0
2013-04-22	TSLA	Stock	3.24	3.3467	3.1833	3.346	59091000.0
2013-04-22	TLT	Stock	122.84	123.29	122.67	122.92	4519327.0
2013-04-22	ES	Stock	44.92	44.94	44.23	44.49	1536100.0
2013-04-22	CL	Stock	59.82	60.545	59.665	60.205	3267200.0
2013-04-22	A	Stock	30.0644	30.2217	29.5708	29.9356	3272019.0
2013-04-22	AABA-DELISTED	Stock	23.71	23.96	23.47	23.945	14421649.0
2013-04-22	AACC-DELISTED	Stock	6.49	6.53	6.48	6.5	36303.0
2013-04-22	AAIC-DELISTED	Stock	25.41	25.63	24.92	25.53	273412.0
2013-04-22	AAMC-DELISTED	Stock	39.0	40.8824	39.0	40.5882	12267.0
2013-04-22	AAME	Stock	3.4	3.41	3.37	3.4	2800.0
2013-04-22	AAMRQ-DELISTED	Stock	3.83	3.85	3.66	3.67	6176704.0
2013-04-22	AAON	Stock	8.1185	8.1185	7.9644	8.0889	276413.0
2013-04-22	AAP	Stock	79.85	79.97	78.75	79.07	564400.0
2013-04-22	AAT	Stock	33.01	33.01	32.5	32.77	69300.0
2013-04-22	AAU-DELISTED	Stock	1.64	1.6904	1.62	1.65	140366.0
2013-04-22	AAUAF-DELISTED	Stock	1.62	1.6699	1.6	1.65	144486.0
2013-04-22	AAV-DELISTED	Stock	3.71	3.74	3.63	3.66	110525.0
2013-04-22	AAWW-DELISTED	Stock	37.78	38.5	37.1	38.33	208648.0
2013-04-22	AAXJ	Stock	58.43	58.62	58.24	58.59	225151.0
2013-04-22	AAXN-DELISTED	Stock	8.05	8.06	7.78	7.98	368829.0
2013-04-22	AB	Stock	22.78	22.84	22.5	22.7	173900.0
2013-04-22	ABAC-DELISTED	Stock	0.75	0.8	0.7	0.7001	86371.0
2013-04-22	ABAX-DELISTED	Stock	44.75	44.75	43.65	44.35	124222.0
2013-04-22	ABB-DELISTED	Stock	21.37	21.42	21.01	21.22	2139514.0
2013-04-22	ABBNY-DELISTED	Stock	21.37	21.42	21.01	21.21	2169396.0
2013-04-22	ABBV	Stock	43.0	44.83	42.88	44.2	8531300.0
2013-04-22	ABC-DELISTED	Stock	56.42	56.44	55.65	56.22	2537383.0
2013-04-22	ABCB	Stock	13.41	13.56	13.03	13.4	14300.0
2013-04-22	ABCD-DELISTED	Stock	0.95	0.97	0.95	0.955	54911.0
2013-04-22	ABCO-DELISTED	Stock	47.25	47.4	46.29	47.07	264246.0
2013-04-22	ABCW-DELISTED	Stock	0.6675	0.6675	0.62	0.63	3200.0
2013-04-22	ABE-DELISTED	Stock	20.96	21.68	20.341	20.72	8342.0
2013-04-22	ABEO	Stock	500.0	500.0	450.0	487.5	82.0
2013-04-22	ABFS-DELISTED	Stock	10.96	11.03	10.65	10.96	319026.0
2013-04-22	ABG	Stock	34.2	35.1	33.48	34.75	209700.0
2013-04-22	ABM	Stock	20.46	20.72	20.09	20.62	197900.0
2013-04-22	ABMD-DELISTED	Stock	17.98	18.04	17.41	17.87	220811.0
2013-04-22	ABR	Stock	7.29	7.29	7.14	7.2	197500.0
2013-04-22	ABR.A-DELISTED	Stock	26.0	26.0	25.94	25.94	1700.0
2013-04-22	ABT	Stock	37.0	37.22	36.56	36.89	5354200.0
2013-04-22	ABTL-DELISTED	Stock	4.1652	4.24	4.1	4.14	21348.0
2013-04-22	ABUS	Stock	4.78	4.78	4.62	4.7	43300.0
2013-04-22	ABV-DELISTED	Stock	39.61	39.63	39.16	39.19	2086198.0
2013-04-22	ABX-DELISTED	Stock	18.81	18.81	17.6	18.01	24025004.0
2013-04-22	ACAD	Stock	12.19	13.51	11.94	13.15	10379300.0

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

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