PREVIEW / stock_daily / 2012-07-18

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-18.parquet
  size:    198 KB
  rows:    6,138
  symbols: 3,496

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-18	AAPL	Stock	21.6639	21.7264	21.5557	21.6521	252700000.0
2012-07-18	MSFT	Stock	29.6	30.45	29.46	30.45	41090400.0
2012-07-18	NVDA	Stock	0.3085	0.331	0.307	0.3265	616008000.0
2012-07-18	AMZN	Stock	10.8075	10.9335	10.7855	10.8735	41860000.0
2012-07-18	META	Stock	28.31	29.29	28.15	29.11	16841800.0
2012-07-18	TSLA	Stock	2.0947	2.2447	2.0707	2.1433	43228500.0
2012-07-18	TLT	Stock	129.26	129.337	128.79	128.82	4012171.0
2012-07-18	ES	Stock	39.9	40.26	39.66	40.26	1162700.0
2012-07-18	CL	Stock	52.495	53.03	52.385	52.64	2789200.0
2012-07-18	A	Stock	26.5594	27.7468	26.5594	27.4392	3921250.0
2012-07-18	AABA-DELISTED	Stock	15.64	15.75	15.51	15.71	19052699.0
2012-07-18	AACC-DELISTED	Stock	6.94	6.96	6.87	6.96	16604.0
2012-07-18	AACG	Stock	4.32	4.36	4.2	4.2	27500.0
2012-07-18	AAIC-DELISTED	Stock	22.85	22.92	22.75	22.84	42742.0
2012-07-18	AAME	Stock	2.62	2.8	2.62	2.75	6300.0
2012-07-18	AAMRQ-DELISTED	Stock	0.525	0.53	0.5105	0.5105	634519.0
2012-07-18	AAON	Stock	6.0148	6.1659	5.9881	6.1304	76275.0
2012-07-18	AAP	Stock	72.02	74.39	72.01	73.91	1133000.0
2012-07-18	AAT	Stock	25.27	25.32	25.08	25.21	62200.0
2012-07-18	AAU-DELISTED	Stock	1.87	1.9148	1.87	1.87	27359.0
2012-07-18	AAUAF-DELISTED	Stock	1.87	1.92	1.86	1.86	27685.0
2012-07-18	AAV-DELISTED	Stock	3.13	3.24	3.13	3.23	101263.0
2012-07-18	AAWW-DELISTED	Stock	45.13	46.5999	44.76	46.51	122426.0
2012-07-18	AAXJ	Stock	51.55	52.22	51.55	52.1	144811.0
2012-07-18	AAXN-DELISTED	Stock	5.2	5.31	4.95	5.01	307476.0
2012-07-18	AB	Stock	12.47	12.64	12.38	12.55	252200.0
2012-07-18	ABAC-DELISTED	Stock	1.13	1.17	1.13	1.15	650.0
2012-07-18	ABAX-DELISTED	Stock	39.73	40.58	39.61	39.79	107067.0
2012-07-18	ABB-DELISTED	Stock	15.9	16.23	15.86	16.16	5177472.0
2012-07-18	ABBNY-DELISTED	Stock	15.9	16.23	15.86	16.17	12692791.0
2012-07-18	ABC-DELISTED	Stock	39.79	40.36	39.47	39.75	2631958.0
2012-07-18	ABCB	Stock	12.41	12.87	12.41	12.65	37300.0
2012-07-18	ABCD-DELISTED	Stock	1.06	1.1	1.04	1.09	27377.0
2012-07-18	ABCO-DELISTED	Stock	50.2	50.2	49.19	49.5	109064.0
2012-07-18	ABCW-DELISTED	Stock	0.42	0.445	0.41	0.42	16292.0
2012-07-18	ABE-DELISTED	Stock	19.0	19.04	18.93	19.04	34284.0
2012-07-18	ABEO	Stock	650.0	662.5	537.5	562.5	118.0
2012-07-18	ABFS-DELISTED	Stock	11.45	11.95	11.42	11.91	237595.0
2012-07-18	ABG	Stock	26.47	27.74	26.34	27.35	341700.0
2012-07-18	ABM	Stock	18.62	19.69	18.62	19.43	955000.0
2012-07-18	ABMD-DELISTED	Stock	24.15	24.93	23.5	23.92	685218.0
2012-07-18	ABR	Stock	5.25	5.36	5.25	5.32	22700.0
2012-07-18	ABT	Stock	31.6428	32.0506	31.5804	31.6332	14898916.0
2012-07-18	ABTL-DELISTED	Stock	3.65	3.65	3.5128	3.56	71813.0
2012-07-18	ABUS	Stock	2.55	2.59	2.4	2.42	56300.0
2012-07-18	ABV-DELISTED	Stock	36.43	37.38	36.41	37.25	1802997.0
2012-07-18	ABVA-DELISTED	Stock	4.45	4.45	4.45	4.45	100.0
2012-07-18	ABX-DELISTED	Stock	34.41	34.72	33.95	34.31	7162549.0
2012-07-18	ACAD	Stock	1.62	1.63	1.58	1.58	265000.0
2012-07-18	ACAS-DELISTED	Stock	9.82	9.96	9.79	9.82	2332642.0

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

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