PREVIEW / stock_daily / 2011-06-24

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-24.parquet
  size:    200 KB
  rows:    6,125
  symbols: 3,565

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
2011-06-24	AAPL	Stock	11.8346	11.8982	11.6104	11.6554	439807200.0
2011-06-24	MSFT	Stock	24.51	24.54	24.19	24.3	101387200.0
2011-06-24	NVDA	Stock	0.4032	0.4068	0.391	0.3935	529052000.0
2011-06-24	AMZN	Stock	9.694	9.746	9.5675	9.6275	72290000.0
2011-06-24	TSLA	Stock	1.8427	1.8647	1.8173	1.838	54127500.0
2011-06-24	TLT	Stock	97.36	97.6901	96.98	96.98	7960827.0
2011-06-24	ES	Stock	34.61	34.92	34.59	34.64	1403500.0
2011-06-24	CL	Stock	43.045	43.26	42.615	42.73	6827800.0
2011-06-24	A	Stock	35.279	35.2861	34.5851	34.6853	3699527.0
2011-06-24	AABA-DELISTED	Stock	15.08	15.16	14.85	14.88	22884807.0
2011-06-24	AACC-DELISTED	Stock	3.67	3.805	3.58	3.62	1702572.0
2011-06-24	AACG	Stock	10.07	10.17	9.5	9.59	44100.0
2011-06-24	AAIC-DELISTED	Stock	30.79	32.03	30.79	31.88	350332.0
2011-06-24	AAME	Stock	2.01	2.05	1.91	1.91	2600.0
2011-06-24	AAON	Stock	6.4652	6.4652	6.2637	6.2963	366863.0
2011-06-24	AAP	Stock	58.97	59.34	57.7	57.99	1133900.0
2011-06-24	AAT	Stock	21.88	22.49	21.76	22.36	792000.0
2011-06-24	AATI-DELISTED	Stock	6.05	6.05	6.03	6.04	1154029.0
2011-06-24	AAU-DELISTED	Stock	3.31	3.33	3.19	3.21	118434.0
2011-06-24	AAUAF-DELISTED	Stock	3.31	3.33	3.19	3.21	119034.0
2011-06-24	AAV-DELISTED	Stock	7.7	7.93	7.7	7.8	239686.0
2011-06-24	AAWW-DELISTED	Stock	58.4	59.19	57.05	57.37	135167.0
2011-06-24	AAXJ	Stock	60.11	60.29	59.5	59.57	631787.0
2011-06-24	AAXN-DELISTED	Stock	4.38	4.38	4.25	4.26	700769.0
2011-06-24	AB	Stock	19.27	19.27	18.75	18.8	201800.0
2011-06-24	ABAC-DELISTED	Stock	2.48	2.62	2.31	2.41	32290.0
2011-06-24	ABAX-DELISTED	Stock	28.44	28.44	27.63	27.77	155859.0
2011-06-24	ABB-DELISTED	Stock	25.23	25.25	24.68	24.71	2768995.0
2011-06-24	ABBC-DELISTED	Stock	10.05	10.12	9.48	9.96	254178.0
2011-06-24	ABBNY-DELISTED	Stock	25.23	25.25	24.68	24.71	3170395.0
2011-06-24	ABC-DELISTED	Stock	41.25	41.34	40.05	40.15	2908442.0
2011-06-24	ABCB	Stock	8.79	9.03	8.74	8.94	141200.0
2011-06-24	ABCD-DELISTED	Stock	3.3	3.49	3.23	3.44	621571.0
2011-06-24	ABCO-DELISTED	Stock	26.62	27.25	26.62	27.24	188496.0
2011-06-24	ABCW-DELISTED	Stock	0.75	0.75	0.69	0.69	4500.0
2011-06-24	ABD-DELISTED	Stock	7.66	7.67	7.316	7.37	557460.0
2011-06-24	ABE-DELISTED	Stock	18.29	18.45	18.28	18.36	16184.0
2011-06-24	ABEO	Stock	2337.5	2337.5	2075.0	2187.5	9.0
2011-06-24	ABFS-DELISTED	Stock	22.75	23.19	22.71	22.91	437269.0
2011-06-24	ABG	Stock	17.47	17.66	17.14	17.31	687500.0
2011-06-24	ABH-DELISTED	Stock	21.84	22.2	21.61	21.78	247956.0
2011-06-24	ABM	Stock	23.12	23.17	22.7	22.85	213800.0
2011-06-24	ABMD-DELISTED	Stock	16.19	16.37	16.0	16.09	481532.0
2011-06-24	ABR	Stock	4.63	4.69	4.54	4.6	77800.0
2011-06-24	ABT	Stock	24.892	24.892	24.6953	24.8296	10831388.0
2011-06-24	ABTL-DELISTED	Stock	4.9995	5.1525	4.9051	5.0	4870.0
2011-06-24	ABUS	Stock	2.58	2.58	2.44	2.5	19500.0
2011-06-24	ABV-DELISTED	Stock	32.17	32.31	31.7	31.77	1419303.0
2011-06-24	ABVA-DELISTED	Stock	4.93	4.99	4.92	4.99	1000.0
2011-06-24	ABVT-DELISTED	Stock	70.27	70.47	69.2	69.64	230794.0

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

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