PREVIEW / stock_daily / 2012-07-25

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-25.parquet
  size:    197 KB
  rows:    6,126
  symbols: 3,494

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-07-25	AAPL	Stock	20.5164	20.7429	20.3571	20.5346	877312800.0
2012-07-25	MSFT	Stock	29.24	29.33	28.78	28.83	45579500.0
2012-07-25	NVDA	Stock	0.32	0.3305	0.3185	0.3273	415044000.0
2012-07-25	AMZN	Stock	11.1	11.125	10.7955	10.8525	72934000.0
2012-07-25	META	Stock	28.39	29.49	28.08	29.34	17230200.0
2012-07-25	TSLA	Stock	1.9947	1.9987	1.9167	1.93	42633000.0
2012-07-25	TLT	Stock	131.63	132.215	131.48	132.16	5327969.0
2012-07-25	ES	Stock	39.58	39.78	39.26	39.48	666500.0
2012-07-25	CL	Stock	51.18	51.395	50.795	51.125	3331200.0
2012-07-25	A	Stock	25.6938	26.1373	25.5794	25.8512	2485924.0
2012-07-25	AABA-DELISTED	Stock	15.52	15.64	15.4	15.49	14972944.0
2012-07-25	AACC-DELISTED	Stock	6.17	6.17	5.9925	6.05	15626.0
2012-07-25	AACG	Stock	3.8	3.87	3.8	3.82	2600.0
2012-07-25	AAIC-DELISTED	Stock	22.2	22.2998	22.02	22.03	50424.0
2012-07-25	AAME	Stock	2.77	2.77	2.62	2.7	1900.0
2012-07-25	AAMRQ-DELISTED	Stock	0.514	0.525	0.51	0.513	276272.0
2012-07-25	AAON	Stock	5.5496	5.5941	5.3422	5.3837	131625.0
2012-07-25	AAP	Stock	71.45	72.92	71.16	72.55	1574300.0
2012-07-25	AAT	Stock	24.94	24.95	24.63	24.89	153200.0
2012-07-25	AAU-DELISTED	Stock	1.91	2.04	1.8602	1.89	96561.0
2012-07-25	AAUAF-DELISTED	Stock	1.91	2.04	1.8602	1.89	97361.0
2012-07-25	AAV-DELISTED	Stock	3.48	3.5	3.42	3.445	159964.0
2012-07-25	AAWW-DELISTED	Stock	42.44	44.3	41.3901	43.14	283689.0
2012-07-25	AAXJ	Stock	51.0	51.18	50.61	50.85	158402.0
2012-07-25	AAXN-DELISTED	Stock	4.79	4.93	4.76	4.87	292910.0
2012-07-25	AB	Stock	11.94	12.12	11.74	11.86	194600.0
2012-07-25	ABAC-DELISTED	Stock	1.11	1.14	1.11	1.11	1118.0
2012-07-25	ABAX-DELISTED	Stock	36.23	36.69	35.905	36.36	100531.0
2012-07-25	ABB-DELISTED	Stock	16.0	16.0	15.73	15.84	2462955.0
2012-07-25	ABBNY-DELISTED	Stock	16.0	16.0	15.73	15.85	2571957.0
2012-07-25	ABC-DELISTED	Stock	38.36	38.4	37.82	37.97	1585612.0
2012-07-25	ABCB	Stock	11.76	11.88	11.43	11.61	40900.0
2012-07-25	ABCD-DELISTED	Stock	1.08	1.08	1.08	1.08	100.0
2012-07-25	ABCO-DELISTED	Stock	44.9	45.02	44.0	44.7	236904.0
2012-07-25	ABCW-DELISTED	Stock	0.45	0.49	0.4	0.4	15396.0
2012-07-25	ABE-DELISTED	Stock	19.05	19.1	18.96	18.96	10522.0
2012-07-25	ABEO	Stock	462.5	612.5	412.5	612.5	66.0
2012-07-25	ABFS-DELISTED	Stock	11.26	11.38	11.03	11.13	215637.0
2012-07-25	ABG	Stock	26.23	26.8	25.57	26.12	547800.0
2012-07-25	ABM	Stock	18.6	18.75	18.46	18.57	366700.0
2012-07-25	ABMD-DELISTED	Stock	22.13	22.15	21.43	21.7	372379.0
2012-07-25	ABR	Stock	5.4	5.4	5.3	5.39	15500.0
2012-07-25	ABT	Stock	30.8032	30.8991	30.5872	30.7648	11305336.0
2012-07-25	ABTL-DELISTED	Stock	3.65	3.75	3.6	3.71	21936.0
2012-07-25	ABUS	Stock	2.7	2.96	2.69	2.87	25300.0
2012-07-25	ABV-DELISTED	Stock	36.75	36.82	36.14	36.18	1936453.0
2012-07-25	ABVA-DELISTED	Stock	4.34	4.516	4.34	4.35	1800.0
2012-07-25	ABX-DELISTED	Stock	33.82	34.45	33.32	33.82	9355134.0
2012-07-25	ACAD	Stock	1.59	1.59	1.54	1.55	179000.0
2012-07-25	ACAS-DELISTED	Stock	9.62	9.77	9.53	9.71	2521021.0

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

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