PREVIEW / stock_daily / 2012-05-24

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-24.parquet
  size:    198 KB
  rows:    6,186
  symbols: 3,551

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-05-24	AAPL	Stock	20.5668	20.5893	20.0439	20.19	496230000.0
2012-05-24	MSFT	Stock	29.16	29.3	28.76	29.07	52575000.0
2012-05-24	NVDA	Stock	0.3128	0.3133	0.3005	0.3028	520420000.0
2012-05-24	AMZN	Stock	10.849	10.883	10.635	10.762	62822000.0
2012-05-24	META	Stock	32.95	33.21	31.77	33.03	50237200.0
2012-05-24	TSLA	Stock	2.0833	2.0833	1.9793	2.0187	16134000.0
2012-05-24	TLT	Stock	123.23	123.79	122.75	122.94	10257193.0
2012-05-24	ES	Stock	36.28	36.51	36.0	36.32	6017600.0
2012-05-24	CL	Stock	49.22	49.82	49.22	49.565	3501000.0
2012-05-24	A	Stock	29.2132	29.4349	28.9342	29.3419	3591182.0
2012-05-24	AABA-DELISTED	Stock	15.34	15.5099	15.22	15.35	13164026.0
2012-05-24	AACC-DELISTED	Stock	5.86	5.87	5.585	5.6601	24176.0
2012-05-24	AACG	Stock	6.5	6.5	6.35	6.35	4100.0
2012-05-24	AAIC-DELISTED	Stock	22.38	22.5692	22.25	22.54	25968.0
2012-05-24	AAME	Stock	2.61	2.8	2.5	2.62	17600.0
2012-05-24	AAMRQ-DELISTED	Stock	0.46	0.47	0.46	0.463	1153565.0
2012-05-24	AAON	Stock	5.6385	5.6593	5.5289	5.6178	151538.0
2012-05-24	AAP	Stock	72.34	72.96	70.93	72.93	2484400.0
2012-05-24	AAT	Stock	22.71	23.0	22.49	22.99	97600.0
2012-05-24	AAU-DELISTED	Stock	2.05	2.11	1.99	2.05	139280.0
2012-05-24	AAUAF-DELISTED	Stock	2.03	2.1	1.98	2.05	140051.0
2012-05-24	AAV-DELISTED	Stock	2.88	2.92	2.78	2.84	163699.0
2012-05-24	AAWW-DELISTED	Stock	46.76	46.97	45.93	46.67	228420.0
2012-05-24	AAXJ	Stock	50.85	50.89	49.96	50.28	1247895.0
2012-05-24	AAXN-DELISTED	Stock	5.42	5.51	5.31	5.4	577138.0
2012-05-24	AB	Stock	13.44	13.76	13.32	13.57	242800.0
2012-05-24	ABAC-DELISTED	Stock	1.4699	1.58	1.3	1.52	21860.0
2012-05-24	ABAX-DELISTED	Stock	32.71	32.81	32.08	32.58	64139.0
2012-05-24	ABB-DELISTED	Stock	16.25	16.39	16.189	16.39	7564919.0
2012-05-24	ABBNY-DELISTED	Stock	16.25	16.4	16.189	16.4	7993213.0
2012-05-24	ABC-DELISTED	Stock	36.31	36.56	36.12	36.47	1423765.0
2012-05-24	ABCB	Stock	11.25	11.56	11.17	11.55	54000.0
2012-05-24	ABCD-DELISTED	Stock	1.35	1.35	1.22	1.27	34881.0
2012-05-24	ABCO-DELISTED	Stock	47.58	48.07	47.13	48.06	176171.0
2012-05-24	ABCW-DELISTED	Stock	0.5522	0.5522	0.5522	0.5522	8460.0
2012-05-24	ABE-DELISTED	Stock	18.04	18.05	17.89	17.92	4620.0
2012-05-24	ABEO	Stock	700.0	812.5	700.0	812.5	62.0
2012-05-24	ABFS-DELISTED	Stock	12.65	12.86	12.49	12.84	231305.0
2012-05-24	ABG	Stock	26.83	26.93	26.38	26.75	137200.0
2012-05-24	ABM	Stock	21.74	21.95	21.3	21.68	206500.0
2012-05-24	ABMD-DELISTED	Stock	21.8	22.3	21.38	21.91	371475.0
2012-05-24	ABR	Stock	5.91	5.92	5.72	5.81	42700.0
2012-05-24	ABT	Stock	29.5509	30.0163	29.5317	29.9491	14566903.0
2012-05-24	ABTL-DELISTED	Stock	3.7495	3.75	3.6137	3.75	14908.0
2012-05-24	ABUS	Stock	1.98	2.13	1.88	2.01	31000.0
2012-05-24	ABV-DELISTED	Stock	37.39	37.66	36.95	37.43	2942287.0
2012-05-24	ABVA-DELISTED	Stock	4.25	4.25	4.25	4.25	300.0
2012-05-24	ABVT-DELISTED	Stock	83.17	83.32	83.16	83.32	288315.0
2012-05-24	ABX-DELISTED	Stock	39.82	40.39	38.92	39.49	14608493.0
2012-05-24	ACAD	Stock	1.48	1.5	1.37	1.37	217000.0

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

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