PREVIEW / stock_30min / 2012-06-29

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-29.parquet
  size:    1.5 MB
  rows:    78,694
  symbols: 3,540

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
2012-06-29 04:00:00	AAPL	Stock	20.3393	20.4643	20.3393	20.4496	61600.0
2012-06-29 05:00:00	AAPL	Stock	20.4554	20.4554	20.4286	20.4286	14840.0
2012-06-29 05:30:00	AAPL	Stock	20.4514	20.4539	20.4514	20.4539	19600.0
2012-06-29 06:00:00	AAPL	Stock	20.4464	20.4839	20.4464	20.475	56000.0
2012-06-29 06:30:00	AAPL	Stock	20.4689	20.4689	20.4621	20.4646	11200.0
2012-06-29 07:00:00	AAPL	Stock	20.4732	20.5354	20.4646	20.535	282156.0
2012-06-29 07:30:00	AAPL	Stock	20.5218	20.5236	20.4821	20.5107	636216.0
2012-06-29 08:00:00	AAPL	Stock	20.5107	20.5982	20.4893	20.5968	2971220.0
2012-06-29 08:30:00	AAPL	Stock	20.5893	20.6525	20.5796	20.6086	2739072.0
2012-06-29 09:00:00	AAPL	Stock	20.6161	20.6607	20.5971	20.6429	2532572.0
2012-06-29 09:30:00	AAPL	Stock	20.6429	20.6486	20.5089	20.5637	61457508.0
2012-06-29 10:00:00	AAPL	Stock	20.5636	20.6782	20.5636	20.6768	42728980.0
2012-06-29 10:30:00	AAPL	Stock	20.6764	20.6829	20.6168	20.6479	27472956.0
2012-06-29 11:00:00	AAPL	Stock	20.645	20.6964	20.6321	20.6964	23870616.0
2012-06-29 11:30:00	AAPL	Stock	20.6964	20.7268	20.6893	20.7189	24075884.0
2012-06-29 12:00:00	AAPL	Stock	20.7211	20.745	20.7125	20.7268	18915932.0
2012-06-29 12:30:00	AAPL	Stock	20.7239	20.7304	20.6929	20.7071	17693816.0
2012-06-29 13:00:00	AAPL	Stock	20.7068	20.7279	20.7029	20.7029	13589688.0
2012-06-29 13:30:00	AAPL	Stock	20.7043	20.7339	20.7036	20.7301	13754524.0
2012-06-29 14:00:00	AAPL	Stock	20.7282	20.821	20.7218	20.8143	30137744.0
2012-06-29 14:30:00	AAPL	Stock	20.8143	20.8464	20.8093	20.8307	28967568.0
2012-06-29 15:00:00	AAPL	Stock	20.83	20.8375	20.7929	20.8055	24256848.0
2012-06-29 15:30:00	AAPL	Stock	20.8062	20.8571	20.7789	20.8571	51463300.0
2012-06-29 16:00:00	AAPL	Stock	20.8571	20.8613	20.7149	20.8336	23183440.0
2012-06-29 16:30:00	AAPL	Stock	20.8321	20.8571	20.8	20.8254	2243500.0
2012-06-29 17:00:00	AAPL	Stock	20.8571	20.8571	20.8286	20.8393	131376.0
2012-06-29 17:30:00	AAPL	Stock	20.8346	20.8379	20.8218	20.8321	115024.0
2012-06-29 18:00:00	AAPL	Stock	20.8321	20.8321	20.8257	20.8286	175056.0
2012-06-29 18:30:00	AAPL	Stock	20.8286	20.8321	20.8232	20.8321	208432.0
2012-06-29 19:00:00	AAPL	Stock	20.8289	20.8321	20.825	20.8289	266952.0
2012-06-29 19:30:00	AAPL	Stock	20.8257	20.8339	20.8257	20.8268	147112.0
2012-06-29 06:30:00	MSFT	Stock	30.18	30.18	30.18	30.18	200.0
2012-06-29 07:00:00	MSFT	Stock	30.39	30.4	30.39	30.4	4966.0
2012-06-29 07:30:00	MSFT	Stock	30.31	30.42	30.27	30.42	1491.0
2012-06-29 08:00:00	MSFT	Stock	30.33	30.4	30.2	30.39	20774.0
2012-06-29 08:30:00	MSFT	Stock	30.4	30.4	30.31	30.37	21609.0
2012-06-29 09:00:00	MSFT	Stock	30.37	30.44	30.33	30.44	82312.0
2012-06-29 09:30:00	MSFT	Stock	30.44	30.69	30.14	30.26	7108307.0
2012-06-29 10:00:00	MSFT	Stock	30.26	30.56	30.26	30.525	4452200.0
2012-06-29 10:30:00	MSFT	Stock	30.52	30.56	30.42	30.495	2810595.0
2012-06-29 11:00:00	MSFT	Stock	30.5	30.56	30.43	30.525	2599692.0
2012-06-29 11:30:00	MSFT	Stock	30.53	30.58	30.45	30.455	2176904.0
2012-06-29 12:00:00	MSFT	Stock	30.451	30.485	30.43	30.48	1984874.0
2012-06-29 12:30:00	MSFT	Stock	30.471	30.53	30.43	30.53	1719949.0
2012-06-29 13:00:00	MSFT	Stock	30.525	30.55	30.48	30.48	1887515.0
2012-06-29 13:30:00	MSFT	Stock	30.485	30.51	30.47	30.5	1093217.0
2012-06-29 14:00:00	MSFT	Stock	30.49	30.58	30.48	30.56	2754641.0
2012-06-29 14:30:00	MSFT	Stock	30.56	30.57	30.46	30.495	2240992.0
2012-06-29 15:00:00	MSFT	Stock	30.495	30.495	30.38	30.45	2839118.0
2012-06-29 15:30:00	MSFT	Stock	30.45	30.59	30.4	30.58	12483603.0

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

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