PREVIEW / stock_30min / 2011-04-25

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-25.parquet
  size:    1.4 MB
  rows:    73,894
  symbols: 3,560

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-04-25 07:00:00	AAPL	Stock	12.5893	12.5893	12.5714	12.5854	30800.0
2011-04-25 07:30:00	AAPL	Stock	12.575	12.575	12.5589	12.5589	107660.0
2011-04-25 08:00:00	AAPL	Stock	12.5639	12.5893	12.5143	12.5282	863688.0
2011-04-25 08:30:00	AAPL	Stock	12.5282	12.5357	12.5179	12.5321	895972.0
2011-04-25 09:00:00	AAPL	Stock	12.5321	12.5354	12.5093	12.5179	819616.0
2011-04-25 09:30:00	AAPL	Stock	12.5136	12.6157	12.5107	12.61	59135524.0
2011-04-25 10:00:00	AAPL	Stock	12.6095	12.6136	12.545	12.5686	31831044.0
2011-04-25 10:30:00	AAPL	Stock	12.5689	12.5714	12.5411	12.5707	17185756.0
2011-04-25 11:00:00	AAPL	Stock	12.5704	12.5836	12.5611	12.5768	13179460.0
2011-04-25 11:30:00	AAPL	Stock	12.5761	12.5782	12.5668	12.575	9442552.0
2011-04-25 12:00:00	AAPL	Stock	12.5754	12.5925	12.5739	12.5807	7978320.0
2011-04-25 12:30:00	AAPL	Stock	12.5804	12.5821	12.565	12.5771	7348068.0
2011-04-25 13:00:00	AAPL	Stock	12.5766	12.5857	12.5629	12.5631	8267812.0
2011-04-25 13:30:00	AAPL	Stock	12.5636	12.5886	12.5636	12.5796	10697120.0
2011-04-25 14:00:00	AAPL	Stock	12.5801	12.6196	12.5782	12.6179	21706272.0
2011-04-25 14:30:00	AAPL	Stock	12.6179	12.6339	12.6125	12.626	20768496.0
2011-04-25 15:00:00	AAPL	Stock	12.6261	12.6261	12.6	12.6139	13789048.0
2011-04-25 15:30:00	AAPL	Stock	12.6136	12.6225	12.6018	12.6107	25904060.0
2011-04-25 16:00:00	AAPL	Stock	12.6089	12.6143	12.5257	12.6071	10764124.0
2011-04-25 16:30:00	AAPL	Stock	12.6071	12.6153	12.5986	12.6089	439404.0
2011-04-25 17:00:00	AAPL	Stock	12.6089	12.6089	12.6011	12.6064	114996.0
2011-04-25 17:30:00	AAPL	Stock	12.6064	12.6132	12.6054	12.6132	133616.0
2011-04-25 18:00:00	AAPL	Stock	12.6139	12.6193	12.6075	12.6075	221144.0
2011-04-25 18:30:00	AAPL	Stock	12.6071	12.6075	12.5932	12.6007	267120.0
2011-04-25 19:00:00	AAPL	Stock	12.6011	12.6071	12.6	12.6032	101920.0
2011-04-25 19:30:00	AAPL	Stock	12.6036	12.6107	12.6036	12.6071	208292.0
2011-04-25 07:30:00	MSFT	Stock	25.67	25.67	25.61	25.61	3100.0
2011-04-25 08:00:00	MSFT	Stock	25.63	25.63	25.6	25.6	3800.0
2011-04-25 08:30:00	MSFT	Stock	25.6	25.62	25.57	25.58	22417.0
2011-04-25 09:00:00	MSFT	Stock	25.59	25.61	25.5	25.54	29450.0
2011-04-25 09:30:00	MSFT	Stock	25.56	25.6	25.4	25.42	3661942.0
2011-04-25 10:00:00	MSFT	Stock	25.429	25.44	25.34	25.37	3100843.0
2011-04-25 10:30:00	MSFT	Stock	25.375	25.45	25.34	25.425	3410937.0
2011-04-25 11:00:00	MSFT	Stock	25.42	25.44	25.36	25.37	1816836.0
2011-04-25 11:30:00	MSFT	Stock	25.37	25.43	25.36	25.43	2172474.0
2011-04-25 12:00:00	MSFT	Stock	25.43	25.5	25.42	25.484	1557674.0
2011-04-25 12:30:00	MSFT	Stock	25.486	25.52	25.48	25.502	1842941.0
2011-04-25 13:00:00	MSFT	Stock	25.5	25.54	25.46	25.535	1598280.0
2011-04-25 13:30:00	MSFT	Stock	25.54	25.56	25.53	25.54	2592097.0
2011-04-25 14:00:00	MSFT	Stock	25.55	25.56	25.52	25.521	1816673.0
2011-04-25 14:30:00	MSFT	Stock	25.528	25.55	25.51	25.54	1259373.0
2011-04-25 15:00:00	MSFT	Stock	25.54	25.56	25.52	25.535	1558838.0
2011-04-25 15:30:00	MSFT	Stock	25.535	25.62	25.53	25.61	4614145.0
2011-04-25 16:00:00	MSFT	Stock	25.6	25.62	25.425	25.6	2199814.0
2011-04-25 16:30:00	MSFT	Stock	25.59	25.59	25.54	25.55	8409.0
2011-04-25 17:30:00	MSFT	Stock	25.58	25.58	25.58	25.58	293.0
2011-04-25 18:00:00	MSFT	Stock	25.61	25.61	25.56	25.56	7899.0
2011-04-25 18:30:00	MSFT	Stock	25.57	25.61	25.57	25.61	4667.0
2011-04-25 19:00:00	MSFT	Stock	25.61	25.61	25.61	25.61	4870.0
2011-04-25 19:30:00	MSFT	Stock	25.62	25.62	25.59	25.61	2100.0

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

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