PREVIEW / stock_30min / 2011-11-15

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-15.parquet
  size:    1.4 MB
  rows:    73,799
  symbols: 3,523

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-11-15 04:00:00	AAPL	Stock	13.525	13.525	13.525	13.525	2800.0
2011-11-15 05:30:00	AAPL	Stock	13.5	13.5	13.4911	13.5	78400.0
2011-11-15 06:00:00	AAPL	Stock	13.4918	13.4918	13.4286	13.4286	8400.0
2011-11-15 06:30:00	AAPL	Stock	13.4839	13.4839	13.4536	13.4643	23800.0
2011-11-15 07:00:00	AAPL	Stock	13.4693	13.5239	13.4554	13.5239	190400.0
2011-11-15 07:30:00	AAPL	Stock	13.51	13.5457	13.5086	13.5268	408884.0
2011-11-15 08:00:00	AAPL	Stock	13.5271	13.5804	13.5179	13.5779	1135680.0
2011-11-15 08:30:00	AAPL	Stock	13.5789	13.6364	13.5768	13.5843	1518328.0
2011-11-15 09:00:00	AAPL	Stock	13.5964	13.625	13.545	13.6011	1263108.0
2011-11-15 09:30:00	AAPL	Stock	13.6018	13.7296	13.5518	13.7118	85792784.0
2011-11-15 10:00:00	AAPL	Stock	13.7117	13.7486	13.6757	13.7296	42764680.0
2011-11-15 10:30:00	AAPL	Stock	13.7289	13.75	13.6968	13.6986	26230960.0
2011-11-15 11:00:00	AAPL	Stock	13.6969	13.7379	13.6921	13.7189	19756772.0
2011-11-15 11:30:00	AAPL	Stock	13.7161	13.7496	13.6929	13.7472	19393220.0
2011-11-15 12:00:00	AAPL	Stock	13.7479	13.8239	13.7454	13.8239	39769632.0
2011-11-15 12:30:00	AAPL	Stock	13.8242	13.8621	13.8129	13.8525	29991612.0
2011-11-15 13:00:00	AAPL	Stock	13.8534	13.8671	13.8307	13.8518	19979176.0
2011-11-15 13:30:00	AAPL	Stock	13.8525	13.8732	13.8357	13.8404	17668672.0
2011-11-15 14:00:00	AAPL	Stock	13.8389	13.8657	13.8301	13.8643	16661484.0
2011-11-15 14:30:00	AAPL	Stock	13.8643	13.8925	13.855	13.8821	22609524.0
2011-11-15 15:00:00	AAPL	Stock	13.8807	13.9071	13.8732	13.9032	19640964.0
2011-11-15 15:30:00	AAPL	Stock	13.905	13.9107	13.88	13.8864	45044132.0
2011-11-15 16:00:00	AAPL	Stock	13.8868	13.8964	13.5406	13.8911	11202996.0
2011-11-15 16:30:00	AAPL	Stock	13.8914	13.9012	13.8886	13.8964	623532.0
2011-11-15 17:00:00	AAPL	Stock	13.8932	13.9	13.8893	13.8971	233660.0
2011-11-15 17:30:00	AAPL	Stock	13.8971	13.9018	13.8929	13.8982	235900.0
2011-11-15 18:00:00	AAPL	Stock	13.8971	13.8986	13.8868	13.8939	117180.0
2011-11-15 18:30:00	AAPL	Stock	13.8964	13.8964	13.8857	13.8857	71428.0
2011-11-15 19:00:00	AAPL	Stock	13.88	13.8857	13.8686	13.87	37016.0
2011-11-15 19:30:00	AAPL	Stock	13.8696	13.8807	13.8686	13.875	55328.0
2011-11-15 04:00:00	MSFT	Stock	26.29	26.29	26.23	26.23	863.0
2011-11-15 06:00:00	MSFT	Stock	26.43	26.43	26.43	26.43	100.0
2011-11-15 07:00:00	MSFT	Stock	26.4	26.42	26.4	26.42	3800.0
2011-11-15 07:30:00	MSFT	Stock	26.44	26.53	26.39	26.42	10101.0
2011-11-15 08:00:00	MSFT	Stock	26.44	26.51	26.44	26.5	17917.0
2011-11-15 08:30:00	MSFT	Stock	26.5	26.58	26.48	26.48	18341.0
2011-11-15 09:00:00	MSFT	Stock	26.48	26.55	26.48	26.52	37048.0
2011-11-15 09:30:00	MSFT	Stock	26.56	26.76	26.52	26.64	7737814.0
2011-11-15 10:00:00	MSFT	Stock	26.63	26.66	26.5	26.54	2445908.0
2011-11-15 10:30:00	MSFT	Stock	26.54	26.61	26.5	26.5	2401252.0
2011-11-15 11:00:00	MSFT	Stock	26.51	26.545	26.43	26.461	2501228.0
2011-11-15 11:30:00	MSFT	Stock	26.46	26.482	26.4	26.46	2201722.0
2011-11-15 12:00:00	MSFT	Stock	26.46	26.74	26.452	26.72	2951712.0
2011-11-15 12:30:00	MSFT	Stock	26.72	26.82	26.7	26.79	2637241.0
2011-11-15 13:00:00	MSFT	Stock	26.79	26.83	26.7	26.76	2277190.0
2011-11-15 13:30:00	MSFT	Stock	26.76	26.9	26.758	26.8	2463771.0
2011-11-15 14:00:00	MSFT	Stock	26.8	26.87	26.77	26.805	1914047.0
2011-11-15 14:30:00	MSFT	Stock	26.81	26.88	26.78	26.84	1508275.0
2011-11-15 15:00:00	MSFT	Stock	26.85	26.94	26.835	26.906	2420155.0
2011-11-15 15:30:00	MSFT	Stock	26.905	26.91	26.68	26.73	7218260.0

> showing 50 of 73,799 rows — these rows as CSV

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