PREVIEW / stock_daily / 2010-06-25

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-25.parquet
  size:    190 KB
  rows:    5,900
  symbols: 3,472

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
2010-06-25	AAPL	Stock	9.645	9.6525	9.4932	9.525	549942400.0
2010-06-25	MSFT	Stock	25.05	25.11	24.31	24.53	156256700.0
2010-06-25	NVDA	Stock	0.2798	0.28	0.2725	0.277	507220000.0
2010-06-25	AMZN	Stock	5.907	6.088	5.8815	6.05	115394000.0
2010-06-25	TLT	Stock	98.32	99.33	98.16	99.05	5148464.0
2010-06-25	ES	Stock	25.83	26.01	25.45	25.79	1123800.0
2010-06-25	CL	Stock	40.25	40.295	39.5	39.515	9237400.0
2010-06-25	A	Stock	22.1173	22.196	21.774	21.9528	5359792.0
2010-06-25	AABA-DELISTED	Stock	14.86	14.915	14.57	14.79	28159177.0
2010-06-25	AACC-DELISTED	Stock	4.73	4.79	4.5	4.51	777606.0
2010-06-25	AACG	Stock	3.2	3.25	3.19	3.19	1300.0
2010-06-25	AAI-DELISTED	Stock	5.1	5.16	5.03	5.11	7225337.0
2010-06-25	AAIC-DELISTED	Stock	19.6299	19.76	18.56	19.58	634195.0
2010-06-25	AAME	Stock	1.37	1.37	1.06	1.34	29500.0
2010-06-25	AAON	Stock	4.7407	4.7704	4.7091	4.7388	983644.0
2010-06-25	AAP	Stock	50.99	51.09	50.25	50.9	1431100.0
2010-06-25	AATI-DELISTED	Stock	3.32	3.44	3.27	3.39	1821612.0
2010-06-25	AAU-DELISTED	Stock	0.93	0.99	0.93	0.99	35510.0
2010-06-25	AAUAF-DELISTED	Stock	0.93	0.99	0.93	0.99	36610.0
2010-06-25	AAV-DELISTED	Stock	6.4	6.53	6.3019	6.49	349986.0
2010-06-25	AAWW-DELISTED	Stock	51.4	51.76	50.0	51.71	957482.0
2010-06-25	AAXJ	Stock	53.79	55.11	53.0	55.11	306823.0
2010-06-25	AAXN-DELISTED	Stock	3.96	4.07	3.88	4.07	1286829.0
2010-06-25	AB	Stock	28.21	28.37	27.5	27.99	316300.0
2010-06-25	ABAX-DELISTED	Stock	21.39	21.51	21.18	21.44	215506.0
2010-06-25	ABB-DELISTED	Stock	18.22	18.39	17.96	18.31	3569280.0
2010-06-25	ABBC-DELISTED	Stock	8.74	8.84	8.65	8.84	340192.0
2010-06-25	ABBNY-DELISTED	Stock	18.22	18.39	17.96	18.28	3605806.0
2010-06-25	ABC-DELISTED	Stock	31.56	32.0	31.43	31.86	4354032.0
2010-06-25	ABCB	Stock	9.9427	11.4953	9.9227	11.4953	1009685.0
2010-06-25	ABCD-DELISTED	Stock	4.35	4.42	3.99	4.1	2301775.0
2010-06-25	ABCO-DELISTED	Stock	21.19	21.77	21.12	21.4	297883.0
2010-06-25	ABCW-DELISTED	Stock	0.5782	0.606	0.529	0.53	82420.0
2010-06-25	ABD-DELISTED	Stock	5.35	5.8	5.3	5.69	1006650.0
2010-06-25	ABE-DELISTED	Stock	15.93	16.025	15.87	15.99	5107.0
2010-06-25	ABEO	Stock	2700.0	2937.5	2637.5	2662.5	27.0
2010-06-25	ABFS-DELISTED	Stock	20.09	20.52	19.83	20.45	817093.0
2010-06-25	ABG	Stock	11.4	11.47	11.08	11.37	1480300.0
2010-06-25	ABII-DELISTED	Stock	60.47	62.59	59.49	62.55	126139.0
2010-06-25	ABK-DELISTED	Stock	0.7688	0.79	0.71	0.7397	9989040.0
2010-06-25	ABM	Stock	21.98	22.42	21.76	22.37	915100.0
2010-06-25	ABMD-DELISTED	Stock	9.48	9.83	9.41	9.73	342145.0
2010-06-25	ABR	Stock	5.24	5.34	5.13	5.29	100600.0
2010-06-25	ABT	Stock	22.8481	22.8577	22.5986	22.6418	28662776.0
2010-06-25	ABTL-DELISTED	Stock	5.7996	5.8979	5.603	5.75	65087.0
2010-06-25	ABV-DELISTED	Stock	104.88	106.49	104.82	106.16	323276.0
2010-06-25	ABVA-DELISTED	Stock	2.53	2.53	2.3	2.3	750.0
2010-06-25	ABVT-DELISTED	Stock	48.01	49.41	47.5	49.38	890483.0
2010-06-25	ABX-DELISTED	Stock	45.19	46.88	45.12	46.4	10023628.0
2010-06-25	ACAD	Stock	1.22	1.26	1.18	1.22	228000.0

> showing 50 of 5,900 rows — these rows as CSV

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