PREVIEW / stock_daily / 2010-06-24

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-24.parquet
  size:    187 KB
  rows:    5,883
  symbols: 3,460

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-24	AAPL	Stock	9.6786	9.7571	9.575	9.6071	714277200.0
2010-06-24	MSFT	Stock	25.46	25.72	24.93	25.0	85243400.0
2010-06-24	NVDA	Stock	0.2905	0.292	0.2768	0.2778	725028000.0
2010-06-24	AMZN	Stock	6.0305	6.0425	5.84	5.9165	155422000.0
2010-06-24	TLT	Stock	99.35	99.59	98.35	98.65	6184567.0
2010-06-24	ES	Stock	25.62	26.0	25.52	25.72	1088700.0
2010-06-24	CL	Stock	40.15	40.5	39.97	40.16	4429800.0
2010-06-24	A	Stock	22.6967	22.8326	21.917	22.0029	5806453.0
2010-06-24	AABA-DELISTED	Stock	15.1	15.19	14.7	14.83	18256167.0
2010-06-24	AACC-DELISTED	Stock	4.66	4.82	4.66	4.71	37746.0
2010-06-24	AACG	Stock	3.39	3.39	3.24	3.24	10800.0
2010-06-24	AAI-DELISTED	Stock	5.22	5.24	5.07	5.07	2303873.0
2010-06-24	AAIC-DELISTED	Stock	19.51	19.64	19.31	19.51	59828.0
2010-06-24	AAME	Stock	1.46	1.46	1.37	1.42	3100.0
2010-06-24	AAON	Stock	4.7052	4.8	4.6637	4.7091	131119.0
2010-06-24	AAP	Stock	50.68	51.11	50.11	50.94	1117900.0
2010-06-24	AATI-DELISTED	Stock	3.35	3.45	3.31	3.31	131704.0
2010-06-24	AAU-DELISTED	Stock	0.96	0.9601	0.9302	0.95	36445.0
2010-06-24	AAUAF-DELISTED	Stock	0.96	0.9601	0.9302	0.95	38045.0
2010-06-24	AAV-DELISTED	Stock	6.54	6.6	6.35	6.39	381927.0
2010-06-24	AAWW-DELISTED	Stock	50.88	52.38	50.7415	51.01	187880.0
2010-06-24	AAXJ	Stock	54.69	54.69	53.77	53.88	171220.0
2010-06-24	AAXN-DELISTED	Stock	3.93	4.05	3.92	3.96	727659.0
2010-06-24	AB	Stock	28.99	29.04	28.1	28.23	317400.0
2010-06-24	ABAX-DELISTED	Stock	21.48	21.7	21.05	21.29	164039.0
2010-06-24	ABB-DELISTED	Stock	18.39	18.4	17.96	18.05	4814289.0
2010-06-24	ABBC-DELISTED	Stock	8.82	8.92	8.66	8.69	83905.0
2010-06-24	ABBNY-DELISTED	Stock	18.39	18.4	17.96	18.05	4990113.0
2010-06-24	ABC-DELISTED	Stock	31.83	31.93	31.45	31.58	2837975.0
2010-06-24	ABCB	Stock	9.8232	10.0521	9.7237	9.8531	53554.0
2010-06-24	ABCD-DELISTED	Stock	4.45	4.57	4.34	4.36	108210.0
2010-06-24	ABCO-DELISTED	Stock	20.9	21.63	20.9	21.13	75231.0
2010-06-24	ABCW-DELISTED	Stock	0.6592	0.6592	0.5992	0.6008	81810.0
2010-06-24	ABD-DELISTED	Stock	5.34	5.34	5.1595	5.31	656580.0
2010-06-24	ABE-DELISTED	Stock	15.98	16.0097	15.86	15.93	9575.0
2010-06-24	ABEO	Stock	2937.5	3000.0	2700.0	2700.0	30.0
2010-06-24	ABFS-DELISTED	Stock	20.37	20.47	20.02	20.08	454173.0
2010-06-24	ABG	Stock	11.57	11.77	11.23	11.28	380000.0
2010-06-24	ABII-DELISTED	Stock	60.86	61.4	60.01	60.05	49166.0
2010-06-24	ABK-DELISTED	Stock	0.77	0.81	0.75	0.759	7712253.0
2010-06-24	ABM	Stock	21.79	22.3	21.79	21.95	326700.0
2010-06-24	ABMD-DELISTED	Stock	9.37	9.52	9.36	9.4399	135175.0
2010-06-24	ABR	Stock	5.11	5.24	4.8	5.2	245700.0
2010-06-24	ABT	Stock	22.7329	22.9632	22.661	22.7713	14688829.0
2010-06-24	ABTL-DELISTED	Stock	5.9	6.0026	5.8487	5.9	18612.0
2010-06-24	ABV-DELISTED	Stock	106.63	106.94	104.66	104.78	480528.0
2010-06-24	ABVA-DELISTED	Stock	2.4	2.53	2.35	2.53	3598.0
2010-06-24	ABVT-DELISTED	Stock	48.64	49.13	47.79	47.99	152507.0
2010-06-24	ABX-DELISTED	Stock	44.76	45.35	44.48	44.5899	7576320.0
2010-06-24	ACAD	Stock	1.23	1.25	1.22	1.22	152700.0

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

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