PREVIEW / stock_30min / 2011-01-28

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-01-28.parquet
  size:    1.5 MB
  rows:    78,015
  symbols: 3,520

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-01-28 07:00:00	AAPL	Stock	12.2225	12.2421	12.2082	12.2411	30380.0
2011-01-28 07:30:00	AAPL	Stock	12.2457	12.2457	12.245	12.245	19600.0
2011-01-28 08:00:00	AAPL	Stock	12.2411	12.2575	12.2214	12.2404	587384.0
2011-01-28 08:30:00	AAPL	Stock	12.2357	12.2882	12.2321	12.2732	1324904.0
2011-01-28 09:00:00	AAPL	Stock	12.2654	12.29	12.2554	12.29	907452.0
2011-01-28 09:30:00	AAPL	Stock	12.2921	12.3	12.2218	12.2293	39822804.0
2011-01-28 10:00:00	AAPL	Stock	12.2293	12.2339	12.1025	12.1329	67549132.0
2011-01-28 10:30:00	AAPL	Stock	12.1321	12.1629	12.1043	12.1414	48719832.0
2011-01-28 11:00:00	AAPL	Stock	12.1404	12.1493	12.1114	12.1186	30610076.0
2011-01-28 11:30:00	AAPL	Stock	12.1179	12.1179	11.9643	11.9889	78433068.0
2011-01-28 12:00:00	AAPL	Stock	11.9886	12.0454	11.9117	12.0132	70248780.0
2011-01-28 12:30:00	AAPL	Stock	12.0136	12.0586	12.0039	12.0532	34412784.0
2011-01-28 13:00:00	AAPL	Stock	12.0529	12.055	11.9932	12.0136	28985096.0
2011-01-28 13:30:00	AAPL	Stock	12.0137	12.0318	11.9825	12.0293	25369680.0
2011-01-28 14:00:00	AAPL	Stock	12.0289	12.0344	11.9975	12.0164	17028648.0
2011-01-28 14:30:00	AAPL	Stock	12.0161	12.0304	11.9968	12.0143	19968900.0
2011-01-28 15:00:00	AAPL	Stock	12.0121	12.0161	11.9771	11.9825	36533756.0
2011-01-28 15:30:00	AAPL	Stock	11.9832	12.0179	11.9793	12.0018	66439548.0
2011-01-28 16:00:00	AAPL	Stock	12.0036	12.0919	11.9821	11.9911	3176600.0
2011-01-28 16:30:00	AAPL	Stock	11.9929	12.2437	11.984	11.9982	3158904.0
2011-01-28 17:00:00	AAPL	Stock	11.9971	11.9971	11.9832	11.9832	146748.0
2011-01-28 17:30:00	AAPL	Stock	11.9857	11.9889	11.9761	11.9764	181524.0
2011-01-28 18:00:00	AAPL	Stock	11.9786	12.0036	11.9782	11.9789	80248.0
2011-01-28 18:30:00	AAPL	Stock	11.9821	11.9904	11.9786	11.9839	235116.0
2011-01-28 19:00:00	AAPL	Stock	11.9786	11.98	11.9661	11.9682	197064.0
2011-01-28 19:30:00	AAPL	Stock	11.9732	11.9732	11.9646	11.9679	330932.0
2011-01-28 04:30:00	MSFT	Stock	28.94	28.99	28.94	28.95	2136.0
2011-01-28 05:30:00	MSFT	Stock	28.95	28.95	28.95	28.95	400.0
2011-01-28 06:00:00	MSFT	Stock	28.9	28.9	28.9	28.9	300.0
2011-01-28 06:30:00	MSFT	Stock	28.91	28.93	28.88	28.93	7100.0
2011-01-28 07:00:00	MSFT	Stock	28.9	28.95	28.9	28.92	36651.0
2011-01-28 07:30:00	MSFT	Stock	28.93	28.93	28.77	28.77	51833.0
2011-01-28 08:00:00	MSFT	Stock	28.78	28.93	28.76	28.82	240699.0
2011-01-28 08:30:00	MSFT	Stock	28.82	29.0	28.8	28.95	443509.0
2011-01-28 09:00:00	MSFT	Stock	28.94	28.94	28.83	28.89	224875.0
2011-01-28 09:30:00	MSFT	Stock	28.89	28.93	28.4	28.442	20129357.0
2011-01-28 10:00:00	MSFT	Stock	28.44	28.458	28.01	28.075	18385926.0
2011-01-28 10:30:00	MSFT	Stock	28.07	28.08	27.81	27.93	13068738.0
2011-01-28 11:00:00	MSFT	Stock	27.92	28.07	27.82	27.91	10149422.0
2011-01-28 11:30:00	MSFT	Stock	27.9	27.9	27.61	27.688	11200751.0
2011-01-28 12:00:00	MSFT	Stock	27.68	27.78	27.45	27.75	12436137.0
2011-01-28 12:30:00	MSFT	Stock	27.75	27.855	27.71	27.72	6360197.0
2011-01-28 13:00:00	MSFT	Stock	27.72	27.73	27.5	27.515	5256052.0
2011-01-28 13:30:00	MSFT	Stock	27.52	27.65	27.47	27.639	6981595.0
2011-01-28 14:00:00	MSFT	Stock	27.63	27.66	27.51	27.658	5440908.0
2011-01-28 14:30:00	MSFT	Stock	27.65	27.75	27.64	27.715	5413521.0
2011-01-28 15:00:00	MSFT	Stock	27.72	27.73	27.59	27.595	6372023.0
2011-01-28 15:30:00	MSFT	Stock	27.592	27.8	27.58	27.76	12006341.0
2011-01-28 16:00:00	MSFT	Stock	27.75	28.83	27.591	27.74	548165.0
2011-01-28 16:30:00	MSFT	Stock	27.72	27.903	27.61	27.75	518377.0

> showing 50 of 78,015 rows — these rows as CSV

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