PREVIEW / stock_daily / 2009-03-26

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-26.parquet
  size:    176 KB
  rows:    5,717
  symbols: 3,413

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
2009-03-26	AAPL	Stock	3.8511	3.9279	3.8421	3.9239	616252000.0
2009-03-26	MSFT	Stock	18.17	18.88	18.12	18.83	63775100.0
2009-03-26	NVDA	Stock	0.2525	0.2645	0.2498	0.264	1333664000.0
2009-03-26	AMZN	Stock	3.6735	3.749	3.632	3.6845	133154000.0
2009-03-26	TLT	Stock	102.44	104.06	102.16	103.79	2385217.0
2009-03-26	ES	Stock	21.75	21.92	21.49	21.8	2161300.0
2009-03-26	CL	Stock	29.8	30.175	29.41	30.145	8249600.0
2009-03-26	A	Stock	11.4807	12.289	11.309	12.2604	8359201.0
2009-03-26	AABA-DELISTED	Stock	13.56	13.61	13.0	13.33	24036222.0
2009-03-26	AACC-DELISTED	Stock	6.04	6.41	5.98	6.25	75101.0
2009-03-26	AACG	Stock	4.0	4.1	3.8	4.0	91000.0
2009-03-26	AAI-DELISTED	Stock	4.44	4.72	4.43	4.68	3162625.0
2009-03-26	AAIC-DELISTED	Stock	4.6	4.6	3.8	4.4	565295.0
2009-03-26	AAON	Stock	3.676	3.8617	3.6128	3.7985	724444.0
2009-03-26	AAP	Stock	40.17	42.39	39.89	42.19	2634300.0
2009-03-26	AATI-DELISTED	Stock	3.64	4.18	3.57	3.89	390272.0
2009-03-26	AAU-DELISTED	Stock	0.75	0.83	0.75	0.82	77118.0
2009-03-26	AAUAF-DELISTED	Stock	0.75	0.83	0.75	0.82	77353.0
2009-03-26	AAV-DELISTED	Stock	2.28	2.7	2.28	2.7	2179840.0
2009-03-26	AAWW-DELISTED	Stock	18.71	19.31	18.38	19.27	429881.0
2009-03-26	AAXJ	Stock	34.31	35.19	34.31	35.19	70988.0
2009-03-26	AAXN-DELISTED	Stock	4.75	4.83	4.57	4.82	424002.0
2009-03-26	AB	Stock	15.76	16.33	15.5	16.23	802300.0
2009-03-26	ABAX-DELISTED	Stock	18.45	18.7	18.02	18.65	195227.0
2009-03-26	ABB-DELISTED	Stock	14.31	14.6826	14.2	14.63	6313286.0
2009-03-26	ABBC-DELISTED	Stock	8.95	8.95	8.75	8.9	64468.0
2009-03-26	ABBNY-DELISTED	Stock	14.31	14.6826	14.2	14.61	6337384.0
2009-03-26	ABC-DELISTED	Stock	16.24	16.37	16.1	16.32	2510638.0
2009-03-26	ABCB	Stock	6.3221	6.6334	6.1568	6.6139	23955.0
2009-03-26	ABCO-DELISTED	Stock	8.38	8.85	8.25	8.75	111076.0
2009-03-26	ABCW-DELISTED	Stock	1.28	1.61	1.23	1.49	333740.0
2009-03-26	ABD-DELISTED	Stock	1.3424	1.3759	1.2864	1.32	297770.0
2009-03-26	ABE-DELISTED	Stock	12.45	12.82	12.3717	12.8	18003.0
2009-03-26	ABEO	Stock	1937.5	2125.0	1887.5	2125.0	2.0
2009-03-26	ABFS-DELISTED	Stock	20.68	21.86	20.62	21.75	1240933.0
2009-03-26	ABG	Stock	4.29	4.78	4.29	4.71	613800.0
2009-03-26	ABII-DELISTED	Stock	43.36	45.36	43.35	45.02	28370.0
2009-03-26	ABK-DELISTED	Stock	0.92	0.92	0.81	0.86	6481871.0
2009-03-26	ABM	Stock	16.99	17.16	16.6	17.03	405000.0
2009-03-26	ABMD-DELISTED	Stock	5.51	5.66	5.31	5.5	442502.0
2009-03-26	ABR	Stock	1.15	1.17	1.0	1.06	218200.0
2009-03-26	ABT	Stock	22.2819	22.2915	21.4711	22.2867	34872238.0
2009-03-26	ABTL-DELISTED	Stock	1.2626	1.3889	1.1111	1.25	12851.0
2009-03-26	ABV-DELISTED	Stock	48.97	50.19	48.42	50.11	839714.0
2009-03-26	ABVA-DELISTED	Stock	2.1	2.1	2.1	2.1	715.0
2009-03-26	ABVT-DELISTED	Stock	47.0	47.0	43.0	43.0	313.0
2009-03-26	ABX-DELISTED	Stock	33.35	33.6	32.68	33.11	9373167.0
2009-03-26	ACAD	Stock	1.07	1.15	1.04	1.15	169700.0
2009-03-26	ACAP-DELISTED	Stock	42.21	43.91	41.23	43.74	61657.0
2009-03-26	ACAS-DELISTED	Stock	2.52	2.52	2.1	2.28	8263972.0

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

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