PREVIEW / stock_30min / 2013-08-08

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-08.parquet
  size:    1.5 MB
  rows:    78,992
  symbols: 3,514

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-08-08 04:00:00	AAPL	Stock	16.5679	16.5679	16.5679	16.5679	13440.0
2013-08-08 04:30:00	AAPL	Stock	16.5714	16.5714	16.5714	16.5714	2800.0
2013-08-08 05:00:00	AAPL	Stock	16.5775	16.6071	16.5775	16.6071	22400.0
2013-08-08 05:30:00	AAPL	Stock	16.6075	16.6075	16.5911	16.5982	30800.0
2013-08-08 06:00:00	AAPL	Stock	16.5857	16.5893	16.5714	16.5714	42000.0
2013-08-08 06:30:00	AAPL	Stock	16.5714	16.5714	16.5464	16.5714	32200.0
2013-08-08 07:00:00	AAPL	Stock	16.5714	16.5857	16.5625	16.575	146524.0
2013-08-08 07:30:00	AAPL	Stock	16.5789	16.5789	16.5214	16.5357	159460.0
2013-08-08 08:00:00	AAPL	Stock	16.5357	16.5982	16.5311	16.5718	1037092.0
2013-08-08 08:30:00	AAPL	Stock	16.5764	16.5871	16.5554	16.5636	735252.0
2013-08-08 09:00:00	AAPL	Stock	16.5661	16.5736	16.5357	16.5729	1092756.0
2013-08-08 09:30:00	AAPL	Stock	16.5714	16.575	16.5007	16.5258	35944832.0
2013-08-08 10:00:00	AAPL	Stock	16.5295	16.5332	16.3564	16.4179	48186096.0
2013-08-08 10:30:00	AAPL	Stock	16.4232	16.4232	16.3554	16.3925	24551828.0
2013-08-08 11:00:00	AAPL	Stock	16.3939	16.4607	16.3846	16.4561	22735664.0
2013-08-08 11:30:00	AAPL	Stock	16.457	16.4986	16.4468	16.4957	13671392.0
2013-08-08 12:00:00	AAPL	Stock	16.4943	16.5179	16.4729	16.4732	10635604.0
2013-08-08 12:30:00	AAPL	Stock	16.4732	16.4968	16.4657	16.4732	7131292.0
2013-08-08 13:00:00	AAPL	Stock	16.4736	16.4771	16.4643	16.4689	8208592.0
2013-08-08 13:30:00	AAPL	Stock	16.4675	16.5071	16.4675	16.5039	7518980.0
2013-08-08 14:00:00	AAPL	Stock	16.5039	16.5061	16.4857	16.5034	6206620.0
2013-08-08 14:30:00	AAPL	Stock	16.5034	16.5264	16.4896	16.5036	8734936.0
2013-08-08 15:00:00	AAPL	Stock	16.5036	16.5111	16.4639	16.4711	10266396.0
2013-08-08 15:30:00	AAPL	Stock	16.471	16.5132	16.4632	16.4646	20374060.0
2013-08-08 16:00:00	AAPL	Stock	16.4643	16.4675	16.4521	16.4521	24791312.0
2013-08-08 16:30:00	AAPL	Stock	16.4646	16.4714	16.4382	16.4429	444780.0
2013-08-08 17:00:00	AAPL	Stock	16.44	16.44	16.4357	16.4393	52192.0
2013-08-08 17:30:00	AAPL	Stock	16.4429	16.4464	16.44	16.4457	28280.0
2013-08-08 18:00:00	AAPL	Stock	16.4404	16.4518	16.4404	16.4518	42840.0
2013-08-08 18:30:00	AAPL	Stock	16.4561	16.4568	16.4464	16.4464	31780.0
2013-08-08 19:00:00	AAPL	Stock	16.4429	16.4429	16.4396	16.4396	27972.0
2013-08-08 19:30:00	AAPL	Stock	16.4396	16.4482	16.4346	16.4346	109396.0
2013-08-08 04:00:00	MSFT	Stock	32.21	32.21	32.21	32.21	100.0
2013-08-08 04:30:00	MSFT	Stock	32.2	32.32	32.2	32.32	1600.0
2013-08-08 05:30:00	MSFT	Stock	32.32	32.32	32.32	32.32	170.0
2013-08-08 06:00:00	MSFT	Stock	32.15	32.3	32.15	32.3	3780.0
2013-08-08 06:30:00	MSFT	Stock	32.29	32.29	32.25	32.29	5419.0
2013-08-08 07:00:00	MSFT	Stock	32.29	32.29	32.27	32.28	2539.0
2013-08-08 07:30:00	MSFT	Stock	32.28	32.29	32.25	32.26	40994.0
2013-08-08 08:00:00	MSFT	Stock	32.26	32.29	32.15	32.18	45749.0
2013-08-08 08:30:00	MSFT	Stock	32.18	32.19	32.14	32.19	30676.0
2013-08-08 09:00:00	MSFT	Stock	32.19	32.26	32.16	32.26	25720.0
2013-08-08 09:30:00	MSFT	Stock	32.24	32.32	32.11	32.19	4895738.0
2013-08-08 10:00:00	MSFT	Stock	32.18	32.44	32.05	32.425	7096300.0
2013-08-08 10:30:00	MSFT	Stock	32.42	32.895	32.35	32.87	11131749.0
2013-08-08 11:00:00	MSFT	Stock	32.87	33.03	32.84	32.885	7701904.0
2013-08-08 11:30:00	MSFT	Stock	32.885	32.89	32.67	32.755	4070747.0
2013-08-08 12:00:00	MSFT	Stock	32.75	33.06	32.75	33.005	3242714.0
2013-08-08 12:30:00	MSFT	Stock	33.005	33.07	32.96	32.99	2896227.0
2013-08-08 13:00:00	MSFT	Stock	32.99	33.05	32.92	32.99	2059812.0

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

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