PREVIEW / stock_daily / 2012-10-02

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-02.parquet
  size:    199 KB
  rows:    6,139
  symbols: 3,475

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-10-02	AAPL	Stock	23.6361	23.7982	23.2375	23.6182	627992400.0
2012-10-02	MSFT	Stock	29.68	29.89	29.5	29.66	43338900.0
2012-10-02	NVDA	Stock	0.3303	0.3303	0.3255	0.3293	295492000.0
2012-10-02	AMZN	Stock	12.64	12.6575	12.4515	12.53	43916000.0
2012-10-02	META	Stock	22.08	22.49	21.82	22.27	29341400.0
2012-10-02	TSLA	Stock	1.952	1.9927	1.9333	1.9867	10935000.0
2012-10-02	TLT	Stock	123.91	124.518	123.81	124.25	3540098.0
2012-10-02	ES	Stock	38.66	38.9	38.58	38.77	1832200.0
2012-10-02	CL	Stock	54.135	54.285	53.75	53.96	2655400.0
2012-10-02	A	Stock	27.9542	28.176	27.568	27.804	4474019.0
2012-10-02	AABA-DELISTED	Stock	16.02	16.04	15.88	15.935	13643722.0
2012-10-02	AACC-DELISTED	Stock	7.43	7.6	7.2608	7.46	8683.0
2012-10-02	AACG	Stock	5.5	5.53	5.5	5.5	1100.0
2012-10-02	AAIC-DELISTED	Stock	24.16	24.21	23.92	24.14	181795.0
2012-10-02	AAME	Stock	2.71	2.79	2.63	2.79	12700.0
2012-10-02	AAMRQ-DELISTED	Stock	0.3725	0.3985	0.3725	0.3915	893234.0
2012-10-02	AAON	Stock	5.7867	5.8281	5.6681	5.7156	111375.0
2012-10-02	AAP	Stock	68.25	68.63	67.85	68.54	596200.0
2012-10-02	AAT	Stock	27.0	27.19	26.79	27.15	133700.0
2012-10-02	AAU-DELISTED	Stock	2.64	2.643	2.555	2.59	118083.0
2012-10-02	AAUAF-DELISTED	Stock	2.65	2.653	2.565	2.58	118339.0
2012-10-02	AAV-DELISTED	Stock	3.94	4.07	3.89	4.035	521357.0
2012-10-02	AAWW-DELISTED	Stock	52.33	52.35	50.9	50.99	107991.0
2012-10-02	AAXJ	Stock	56.96	57.12	56.56	56.79	244748.0
2012-10-02	AAXN-DELISTED	Stock	6.22	6.22	5.94	6.05	703213.0
2012-10-02	AB	Stock	15.5	15.63	15.11	15.41	232000.0
2012-10-02	ABAC-DELISTED	Stock	1.57	1.5784	1.52	1.54	5325.0
2012-10-02	ABAX-DELISTED	Stock	38.28	38.52	37.52	37.76	108009.0
2012-10-02	ABB-DELISTED	Stock	19.32	19.33	18.99	19.09	2279322.0
2012-10-02	ABBNY-DELISTED	Stock	19.31	19.33	18.99	19.1	2373999.0
2012-10-02	ABC-DELISTED	Stock	39.03	39.3	38.76	39.03	2135387.0
2012-10-02	ABCB	Stock	12.72	12.74	12.4	12.51	54500.0
2012-10-02	ABCD-DELISTED	Stock	1.0	1.05	0.99	0.99	7577.0
2012-10-02	ABCO-DELISTED	Stock	48.25	48.47	47.82	48.21	187791.0
2012-10-02	ABCW-DELISTED	Stock	0.4	0.4	0.385	0.385	672.0
2012-10-02	ABE-DELISTED	Stock	20.78	20.78	20.7	20.7	356.0
2012-10-02	ABEO	Stock	525.0	562.5	525.0	562.5	3.0
2012-10-02	ABFS-DELISTED	Stock	7.79	7.82	7.49	7.565	310939.0
2012-10-02	ABG	Stock	28.26	28.26	27.66	28.15	256800.0
2012-10-02	ABM	Stock	18.93	19.05	18.83	19.05	299100.0
2012-10-02	ABMD-DELISTED	Stock	21.11	21.2581	20.75	20.8	353614.0
2012-10-02	ABR	Stock	6.14	6.18	5.95	6.12	76800.0
2012-10-02	ABT	Stock	33.3077	33.3941	32.8231	32.8855	14995415.0
2012-10-02	ABTL-DELISTED	Stock	3.9	3.96	3.77	3.87	7161.0
2012-10-02	ABUS	Stock	3.34	3.34	3.28	3.33	32200.0
2012-10-02	ABV-DELISTED	Stock	39.15	39.51	39.11	39.41	2081670.0
2012-10-02	ABVA-DELISTED	Stock	4.73	4.73	4.73	4.73	100.0
2012-10-02	ABX-DELISTED	Stock	42.08	42.13	41.33	41.61	4784983.0
2012-10-02	ACAD	Stock	2.49	2.54	2.36	2.4	869900.0
2012-10-02	ACAS-DELISTED	Stock	11.58	11.67	11.52	11.59	1643509.0

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

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