PREVIEW / stock_30min / 2013-06-13

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-13.parquet
  size:    1.5 MB
  rows:    78,377
  symbols: 3,488

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
2013-06-13 04:00:00	AAPL	Stock	15.4214	15.4257	15.2696	15.4257	38444.0
2013-06-13 04:30:00	AAPL	Stock	15.3168	15.3168	15.3036	15.3036	5600.0
2013-06-13 05:00:00	AAPL	Stock	15.2896	15.3243	15.2896	15.3243	69580.0
2013-06-13 05:30:00	AAPL	Stock	15.3243	15.3286	15.3214	15.3286	22400.0
2013-06-13 06:30:00	AAPL	Stock	15.3896	15.3904	15.3814	15.3814	30212.0
2013-06-13 07:00:00	AAPL	Stock	15.3879	15.3889	15.3536	15.3668	180992.0
2013-06-13 07:30:00	AAPL	Stock	15.3682	15.4096	15.3486	15.3821	236600.0
2013-06-13 08:00:00	AAPL	Stock	15.3804	15.5	15.3482	15.3929	946736.0
2013-06-13 08:30:00	AAPL	Stock	15.3929	15.5357	15.3929	15.52	2818368.0
2013-06-13 09:00:00	AAPL	Stock	15.5196	15.5293	15.4375	15.4375	1819664.0
2013-06-13 09:30:00	AAPL	Stock	15.4411	15.5243	15.3757	15.4579	56009660.0
2013-06-13 10:00:00	AAPL	Stock	15.4636	15.4636	15.3125	15.3796	46217108.0
2013-06-13 10:30:00	AAPL	Stock	15.3768	15.4264	15.3454	15.3671	23108344.0
2013-06-13 11:00:00	AAPL	Stock	15.3696	15.44	15.3661	15.4182	12959576.0
2013-06-13 11:30:00	AAPL	Stock	15.4221	15.4781	15.3793	15.4643	13872264.0
2013-06-13 12:00:00	AAPL	Stock	15.4646	15.4689	15.4357	15.4482	6983284.0
2013-06-13 12:30:00	AAPL	Stock	15.4482	15.4914	15.4475	15.4911	9645496.0
2013-06-13 13:00:00	AAPL	Stock	15.4907	15.4986	15.4168	15.4282	12913404.0
2013-06-13 13:30:00	AAPL	Stock	15.4282	15.4514	15.4121	15.4493	8192212.0
2013-06-13 14:00:00	AAPL	Stock	15.4479	15.5161	15.4461	15.4907	14193844.0
2013-06-13 14:30:00	AAPL	Stock	15.4921	15.5425	15.475	15.5293	11966080.0
2013-06-13 15:00:00	AAPL	Stock	15.5271	15.5596	15.5154	15.5321	16291128.0
2013-06-13 15:30:00	AAPL	Stock	15.5321	15.6121	15.5161	15.5714	35115892.0
2013-06-13 16:00:00	AAPL	Stock	15.568	15.5804	15.4555	15.55	9375324.0
2013-06-13 16:30:00	AAPL	Stock	15.5546	15.5721	15.53	15.5489	1199100.0
2013-06-13 17:00:00	AAPL	Stock	15.5529	15.5589	15.5482	15.5589	112168.0
2013-06-13 17:30:00	AAPL	Stock	15.5745	15.5745	15.5568	15.5571	139048.0
2013-06-13 18:00:00	AAPL	Stock	15.5539	15.5643	15.5539	15.5579	68180.0
2013-06-13 18:30:00	AAPL	Stock	15.5643	15.5643	15.5571	15.5571	66388.0
2013-06-13 19:00:00	AAPL	Stock	15.5618	15.5625	15.5593	15.5625	42280.0
2013-06-13 19:30:00	AAPL	Stock	15.5646	15.5771	15.5646	15.5714	108724.0
2013-06-13 05:00:00	MSFT	Stock	34.74	34.74	34.7	34.7	2100.0
2013-06-13 05:30:00	MSFT	Stock	34.7	34.7	34.7	34.7	200.0
2013-06-13 06:00:00	MSFT	Stock	34.66	34.66	34.64	34.64	3400.0
2013-06-13 06:30:00	MSFT	Stock	34.65	34.74	34.65	34.73	4767.0
2013-06-13 07:00:00	MSFT	Stock	34.7	34.7	34.65	34.7	3600.0
2013-06-13 07:30:00	MSFT	Stock	34.7	34.72	34.7	34.72	3400.0
2013-06-13 08:00:00	MSFT	Stock	34.73	34.97	34.7	34.73	13235.0
2013-06-13 08:30:00	MSFT	Stock	34.73	34.86	34.7	34.86	21372.0
2013-06-13 09:00:00	MSFT	Stock	34.86	35.03	34.86	34.99	13954.0
2013-06-13 09:30:00	MSFT	Stock	34.99	35.02	34.61	34.649	5342901.0
2013-06-13 10:00:00	MSFT	Stock	34.65	34.73	34.59	34.68	3436924.0
2013-06-13 10:30:00	MSFT	Stock	34.69	34.79	34.65	34.72	2565414.0
2013-06-13 11:00:00	MSFT	Stock	34.72	34.75	34.65	34.69	2300812.0
2013-06-13 11:30:00	MSFT	Stock	34.69	34.73	34.65	34.71	2312617.0
2013-06-13 12:00:00	MSFT	Stock	34.71	34.75	34.67	34.705	2267372.0
2013-06-13 12:30:00	MSFT	Stock	34.71	34.72	34.65	34.69	2465628.0
2013-06-13 13:00:00	MSFT	Stock	34.69	34.7	34.65	34.66	1530770.0
2013-06-13 13:30:00	MSFT	Stock	34.665	34.69	34.63	34.67	1519941.0
2013-06-13 14:00:00	MSFT	Stock	34.67	34.76	34.67	34.72	4092706.0

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

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