PREVIEW / stock_daily / 2012-09-24

all stock daily files

  file:    by_date/stock_daily/2012/2012-09-24.parquet
  size:    199 KB
  rows:    6,170
  symbols: 3,500

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-09-24	AAPL	Stock	24.5307	24.8257	24.3929	24.6711	639766400.0
2012-09-24	MSFT	Stock	31.0	31.07	30.64	30.78	46825900.0
2012-09-24	NVDA	Stock	0.3362	0.342	0.3358	0.3415	357832000.0
2012-09-24	AMZN	Stock	12.761	12.78	12.65	12.74	54158000.0
2012-09-24	META	Stock	21.78	21.98	20.36	20.79	79106500.0
2012-09-24	TSLA	Stock	1.9673	2.0687	1.96	2.044	19528500.0
2012-09-24	TLT	Stock	122.25	122.7	122.18	122.5	3627471.0
2012-09-24	ES	Stock	37.42	38.09	37.34	38.08	2221900.0
2012-09-24	CL	Stock	53.135	53.62	53.075	53.47	2546000.0
2012-09-24	A	Stock	27.804	27.897	27.4464	27.6753	2860168.0
2012-09-24	AABA-DELISTED	Stock	15.69	16.04	15.6	15.995	21865257.0
2012-09-24	AACC-DELISTED	Stock	7.4	7.43	7.21	7.38	21035.0
2012-09-24	AACG	Stock	4.79	4.79	4.77	4.77	1000.0
2012-09-24	AAIC-DELISTED	Stock	24.87	25.15	24.82	25.1	495491.0
2012-09-24	AAME	Stock	2.65	2.65	2.58	2.64	4400.0
2012-09-24	AAMRQ-DELISTED	Stock	0.422	0.424	0.39	0.4063	1060471.0
2012-09-24	AAON	Stock	5.9052	6.0267	5.8844	6.0059	300375.0
2012-09-24	AAP	Stock	68.0	68.45	67.66	67.84	785400.0
2012-09-24	AAT	Stock	26.9	27.21	26.9	27.15	190600.0
2012-09-24	AAU-DELISTED	Stock	2.9	2.9299	2.75	2.85	374798.0
2012-09-24	AAUAF-DELISTED	Stock	2.9	2.9299	2.75	2.82	383198.0
2012-09-24	AAV-DELISTED	Stock	3.84	3.86	3.76	3.78	98536.0
2012-09-24	AAWW-DELISTED	Stock	55.06	56.05	54.63	55.57	142685.0
2012-09-24	AAXJ	Stock	56.02	56.44	56.02	56.35	99608.0
2012-09-24	AAXN-DELISTED	Stock	5.61	5.71	5.57	5.605	340846.0
2012-09-24	AB	Stock	15.49	15.92	15.44	15.9	396000.0
2012-09-24	ABAC-DELISTED	Stock	1.2	1.29	1.13	1.17	16226.0
2012-09-24	ABAX-DELISTED	Stock	37.04	38.24	36.14	38.05	75440.0
2012-09-24	ABB-DELISTED	Stock	19.3	19.47	19.24	19.38	1583464.0
2012-09-24	ABBNY-DELISTED	Stock	19.3	19.47	19.24	19.38	1614038.0
2012-09-24	ABC-DELISTED	Stock	38.86	39.45	38.66	39.36	3080085.0
2012-09-24	ABCB	Stock	12.83	12.91	12.68	12.88	30500.0
2012-09-24	ABCD-DELISTED	Stock	1.0	1.03	0.99	1.03	1000.0
2012-09-24	ABCO-DELISTED	Stock	45.97	47.14	45.97	46.82	100952.0
2012-09-24	ABCW-DELISTED	Stock	0.41	0.41	0.38	0.38	23048.0
2012-09-24	ABE-DELISTED	Stock	20.38	20.45	20.2905	20.45	23895.0
2012-09-24	ABEO	Stock	562.5	575.0	525.0	575.0	6.0
2012-09-24	ABFS-DELISTED	Stock	7.44	7.95	7.44	7.88	650963.0
2012-09-24	ABG	Stock	28.02	28.34	27.94	28.18	193400.0
2012-09-24	ABM	Stock	18.86	18.94	18.65	18.8	369200.0
2012-09-24	ABMD-DELISTED	Stock	21.95	21.95	21.34	21.56	462595.0
2012-09-24	ABR	Stock	6.32	6.38	6.03	6.08	116100.0
2012-09-24	ABT	Stock	33.3941	33.4804	33.2693	33.3989	8572322.0
2012-09-24	ABTL-DELISTED	Stock	3.64	3.67	3.5	3.65	35172.0
2012-09-24	ABUS	Stock	4.04	4.04	3.98	3.98	5100.0
2012-09-24	ABV-DELISTED	Stock	38.33	38.53	38.2	38.37	1905883.0
2012-09-24	ABVA-DELISTED	Stock	4.45	4.58	4.45	4.58	2000.0
2012-09-24	ABX-DELISTED	Stock	42.15	42.5	41.25	41.3	8989040.0
2012-09-24	ACAD	Stock	2.65	2.79	2.58	2.69	1391100.0
2012-09-24	ACAS-DELISTED	Stock	11.73	11.82	11.68	11.76	1476665.0

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

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