PREVIEW / stock_daily / 2013-05-02

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-02.parquet
  size:    209 KB
  rows:    6,297
  symbols: 3,492

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-05-02	AAPL	Stock	15.7779	16.0211	15.7368	15.9114	421828400.0
2013-05-02	MSFT	Stock	32.63	33.17	32.39	33.16	46059500.0
2013-05-02	NVDA	Stock	0.341	0.3462	0.339	0.3453	323480000.0
2013-05-02	AMZN	Stock	12.447	12.6465	12.289	12.6275	78724000.0
2013-05-02	META	Stock	28.01	29.02	27.98	28.97	104257000.0
2013-05-02	TSLA	Stock	3.59	3.6847	3.58	3.6073	45756000.0
2013-05-02	TLT	Stock	123.59	123.97	123.51	123.85	4171750.0
2013-05-02	ES	Stock	45.24	45.53	45.0	45.27	1100700.0
2013-05-02	CL	Stock	59.58	60.55	59.38	60.365	2341200.0
2013-05-02	A	Stock	29.6781	29.8426	29.4993	29.671	4805905.0
2013-05-02	AABA-DELISTED	Stock	24.34	24.97	24.18	24.97	10372138.0
2013-05-02	AACC-DELISTED	Stock	6.49	6.49	6.45	6.46	4208280.0
2013-05-02	AAIC-DELISTED	Stock	26.2	26.89	26.06	26.87	193402.0
2013-05-02	AAMC-DELISTED	Stock	55.5882	57.3529	55.5882	57.3529	26109.0
2013-05-02	AAME	Stock	3.59	3.59	3.32	3.4	3100.0
2013-05-02	AAMRQ-DELISTED	Stock	4.22	4.32	4.22	4.31	3058287.0
2013-05-02	AAON	Stock	8.1452	8.163	8.1185	8.1422	121500.0
2013-05-02	AAP	Stock	84.44	84.98	83.93	84.59	674500.0
2013-05-02	AAT	Stock	34.28	36.27	34.28	35.31	305800.0
2013-05-02	AAU-DELISTED	Stock	1.62	1.62	1.57	1.58	23878.0
2013-05-02	AAUAF-DELISTED	Stock	1.62	1.62	1.57	1.58	25478.0
2013-05-02	AAV-DELISTED	Stock	3.8	3.85	3.69	3.7	272243.0
2013-05-02	AAWW-DELISTED	Stock	40.47	41.0	38.07	40.16	527924.0
2013-05-02	AAXJ	Stock	59.945	60.17	59.8	60.15	319773.0
2013-05-02	AAXN-DELISTED	Stock	8.66	8.84	8.5699	8.74	437966.0
2013-05-02	AB	Stock	24.5	24.76	23.92	24.15	357400.0
2013-05-02	ABAC-DELISTED	Stock	0.685	0.69	0.68	0.69	37646.0
2013-05-02	ABAX-DELISTED	Stock	42.32	43.23	42.12	43.1	103917.0
2013-05-02	ABB-DELISTED	Stock	22.19	22.39	22.18	22.31	1914598.0
2013-05-02	ABBNY-DELISTED	Stock	22.18	22.39	22.18	22.3	2662412.0
2013-05-02	ABBV	Stock	45.68	45.68	43.86	43.99	9649400.0
2013-05-02	ABC-DELISTED	Stock	53.85	54.86	53.77	54.84	1585736.0
2013-05-02	ABCB	Stock	13.9	14.25	13.84	14.08	458400.0
2013-05-02	ABCD-DELISTED	Stock	0.97	0.9701	0.97	0.97	23870.0
2013-05-02	ABCO-DELISTED	Stock	49.04	50.17	48.92	49.55	184337.0
2013-05-02	ABCW-DELISTED	Stock	0.6255	0.65	0.62	0.62	70953.0
2013-05-02	ABE-DELISTED	Stock	21.44	21.552	21.42	21.492	17839.0
2013-05-02	ABEO	Stock	587.5	600.0	575.0	600.0	9.0
2013-05-02	ABFS-DELISTED	Stock	9.81	10.13	9.73	9.83	493632.0
2013-05-02	ABG	Stock	38.93	40.5	38.5	40.22	228200.0
2013-05-02	ABM	Stock	22.28	22.61	22.06	22.18	243400.0
2013-05-02	ABMD-DELISTED	Stock	18.9	20.45	18.78	19.85	1219087.0
2013-05-02	ABR	Stock	7.41	7.55	7.36	7.55	114500.0
2013-05-02	ABR.A-DELISTED	Stock	26.05	26.11	25.9804	26.1	3621.0
2013-05-02	ABT	Stock	36.95	37.15	36.83	37.06	4202800.0
2013-05-02	ABTL-DELISTED	Stock	4.46	4.56	4.46	4.49	60206.0
2013-05-02	ABUS	Stock	4.8	4.8	4.66	4.7	43200.0
2013-05-02	ABV-DELISTED	Stock	40.96	41.02	40.28	40.56	2781812.0
2013-05-02	ABX-DELISTED	Stock	19.6	19.75	19.15	19.55	14953302.0
2013-05-02	ACAD	Stock	12.05	12.65	12.05	12.33	2708300.0

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

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