PREVIEW / stock_30min / 2007-09-28

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-28.parquet
  size:    1.2 MB
  rows:    67,256
  symbols: 3,128

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
2007-09-28 05:30:00	AAPL	Stock	5.4911	5.4911	5.4911	5.4911	2800.0
2007-09-28 06:00:00	AAPL	Stock	5.5107	5.5107	5.5107	5.5107	28000.0
2007-09-28 06:30:00	AAPL	Stock	5.5007	5.5007	5.4893	5.4893	25200.0
2007-09-28 07:00:00	AAPL	Stock	5.4893	5.4893	5.4821	5.4821	114464.0
2007-09-28 07:30:00	AAPL	Stock	5.4911	5.495	5.4907	5.495	185500.0
2007-09-28 08:00:00	AAPL	Stock	5.4929	5.4943	5.4729	5.4786	3571428.0
2007-09-28 08:30:00	AAPL	Stock	5.4786	5.4893	5.4714	5.4793	1776936.0
2007-09-28 09:00:00	AAPL	Stock	5.4771	5.4911	5.475	5.4771	1406664.0
2007-09-28 09:30:00	AAPL	Stock	5.4771	5.5125	5.4554	5.4896	105060816.0
2007-09-28 10:00:00	AAPL	Stock	5.4896	5.5021	5.4693	5.4839	60327792.0
2007-09-28 10:30:00	AAPL	Stock	5.4839	5.4936	5.4732	5.4876	44597812.0
2007-09-28 11:00:00	AAPL	Stock	5.4882	5.4939	5.4789	5.49	33910632.0
2007-09-28 11:30:00	AAPL	Stock	5.49	5.5018	5.4804	5.4889	32847080.0
2007-09-28 12:00:00	AAPL	Stock	5.4893	5.4946	5.4839	5.4904	23800728.0
2007-09-28 12:30:00	AAPL	Stock	5.4904	5.4971	5.489	5.4939	16498272.0
2007-09-28 13:00:00	AAPL	Stock	5.4939	5.5032	5.4925	5.4943	23042572.0
2007-09-28 13:30:00	AAPL	Stock	5.4943	5.5118	5.4643	5.5117	36977976.0
2007-09-28 14:00:00	AAPL	Stock	5.5111	5.5214	5.4871	5.4879	44564856.0
2007-09-28 14:30:00	AAPL	Stock	5.4882	5.4993	5.4768	5.4839	38960068.0
2007-09-28 15:00:00	AAPL	Stock	5.4832	5.4918	5.4586	5.4718	51895480.0
2007-09-28 15:30:00	AAPL	Stock	5.4714	5.4821	5.4571	5.4821	74239872.0
2007-09-28 16:00:00	AAPL	Stock	5.4821	5.492	5.4715	5.4786	20185424.0
2007-09-28 16:30:00	AAPL	Stock	5.4821	5.4855	5.4804	5.4818	63140.0
2007-09-28 17:00:00	AAPL	Stock	5.4821	5.4839	5.4821	5.4839	299796.0
2007-09-28 17:30:00	AAPL	Stock	5.4821	5.4989	5.4804	5.4818	130704.0
2007-09-28 18:00:00	AAPL	Stock	5.4804	5.5161	5.4804	5.4864	915152.0
2007-09-28 18:30:00	AAPL	Stock	5.4871	5.5214	5.4871	5.4893	162064.0
2007-09-28 19:00:00	AAPL	Stock	5.4868	5.4868	5.4786	5.4786	145152.0
2007-09-28 19:30:00	AAPL	Stock	5.4786	5.4786	5.4732	5.4768	194936.0
2007-09-28 08:00:00	MSFT	Stock	29.45	29.45	29.36	29.37	9493.0
2007-09-28 08:30:00	MSFT	Stock	29.36	29.41	29.36	29.41	1267.0
2007-09-28 09:00:00	MSFT	Stock	29.46	29.51	29.41	29.51	16930.0
2007-09-28 09:30:00	MSFT	Stock	29.51	29.69	29.46	29.56	4737532.0
2007-09-28 10:00:00	MSFT	Stock	29.56	29.59	29.47	29.47	2763070.0
2007-09-28 10:30:00	MSFT	Stock	29.47	29.48	29.35	29.36	3722037.0
2007-09-28 11:00:00	MSFT	Stock	29.35	29.38	29.23	29.3	3197121.0
2007-09-28 11:30:00	MSFT	Stock	29.3	29.36	29.28	29.32	1184862.0
2007-09-28 12:00:00	MSFT	Stock	29.32	29.36	29.29	29.31	2364732.0
2007-09-28 12:30:00	MSFT	Stock	29.31	29.37	29.3	29.318	1642084.0
2007-09-28 13:00:00	MSFT	Stock	29.318	29.35	29.3	29.35	1937680.0
2007-09-28 13:30:00	MSFT	Stock	29.35	29.39	29.31	29.33	1296648.0
2007-09-28 14:00:00	MSFT	Stock	29.33	29.35	29.3	29.3	1962780.0
2007-09-28 14:30:00	MSFT	Stock	29.305	29.35	29.27	29.3	2162732.0
2007-09-28 15:00:00	MSFT	Stock	29.3	29.34	29.23	29.34	4638158.0
2007-09-28 15:30:00	MSFT	Stock	29.34	29.47	29.3	29.47	7905178.0
2007-09-28 16:00:00	MSFT	Stock	29.46	29.49	29.32	29.47	6199317.0
2007-09-28 16:30:00	MSFT	Stock	29.46	29.49	29.383	29.383	70819.0
2007-09-28 17:00:00	MSFT	Stock	29.48	29.48	29.47	29.47	15606.0
2007-09-28 17:30:00	MSFT	Stock	29.48	29.48	29.34	29.48	5060.0
2007-09-28 18:00:00	MSFT	Stock	29.48	29.48	29.48	29.48	200.0

> showing 50 of 67,256 rows — these rows as CSV

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