PREVIEW / stock_30min / 2011-04-27

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-27.parquet
  size:    1.4 MB
  rows:    76,713
  symbols: 3,553

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-27 04:00:00	AAPL	Stock	12.5039	12.5039	12.45	12.45	6860.0
2011-04-27 04:30:00	AAPL	Stock	12.4861	12.5	12.4861	12.5	5600.0
2011-04-27 05:00:00	AAPL	Stock	12.5	12.5	12.5	12.5	8400.0
2011-04-27 05:30:00	AAPL	Stock	12.5	12.5143	12.4964	12.4964	16800.0
2011-04-27 06:30:00	AAPL	Stock	12.5139	12.5154	12.5139	12.5154	36400.0
2011-04-27 07:00:00	AAPL	Stock	12.5114	12.5268	12.5107	12.5179	40432.0
2011-04-27 07:30:00	AAPL	Stock	12.5357	12.5429	12.5357	12.5389	14000.0
2011-04-27 08:00:00	AAPL	Stock	12.535	12.5554	12.5179	12.5393	681464.0
2011-04-27 08:30:00	AAPL	Stock	12.5443	12.5786	12.5396	12.5689	1630496.0
2011-04-27 09:00:00	AAPL	Stock	12.5668	12.5804	12.5589	12.5771	976528.0
2011-04-27 09:30:00	AAPL	Stock	12.5771	12.5839	12.5021	12.5111	42596680.0
2011-04-27 10:00:00	AAPL	Stock	12.5104	12.5118	12.4071	12.4461	46730684.0
2011-04-27 10:30:00	AAPL	Stock	12.4475	12.45	12.3964	12.4018	29075928.0
2011-04-27 11:00:00	AAPL	Stock	12.4007	12.4407	12.4007	12.4334	21830788.0
2011-04-27 11:30:00	AAPL	Stock	12.4304	12.4714	12.4293	12.455	19198536.0
2011-04-27 12:00:00	AAPL	Stock	12.4554	12.4704	12.4493	12.4625	9974384.0
2011-04-27 12:30:00	AAPL	Stock	12.4625	12.5211	12.4489	12.5171	25731916.0
2011-04-27 13:00:00	AAPL	Stock	12.5161	12.5179	12.4875	12.4961	19402712.0
2011-04-27 13:30:00	AAPL	Stock	12.4962	12.515	12.4911	12.499	14023324.0
2011-04-27 14:00:00	AAPL	Stock	12.4992	12.5075	12.4821	12.4895	13663300.0
2011-04-27 14:30:00	AAPL	Stock	12.49	12.5264	12.4839	12.5254	16708356.0
2011-04-27 15:00:00	AAPL	Stock	12.5257	12.5429	12.5182	12.5289	25158028.0
2011-04-27 15:30:00	AAPL	Stock	12.5271	12.5461	12.4904	12.5086	44906120.0
2011-04-27 16:00:00	AAPL	Stock	12.5089	12.5107	12.4864	12.5107	10806432.0
2011-04-27 16:30:00	AAPL	Stock	12.5086	12.5326	12.5036	12.5057	3394832.0
2011-04-27 17:00:00	AAPL	Stock	12.5079	12.5129	12.5079	12.5086	783720.0
2011-04-27 17:30:00	AAPL	Stock	12.5086	12.5089	12.5071	12.5071	66164.0
2011-04-27 18:00:00	AAPL	Stock	12.5036	12.5054	12.4929	12.4929	288344.0
2011-04-27 18:30:00	AAPL	Stock	12.4929	12.4929	12.4682	12.4718	516544.0
2011-04-27 19:00:00	AAPL	Stock	12.4714	12.4732	12.4482	12.4732	344512.0
2011-04-27 19:30:00	AAPL	Stock	12.4743	12.4768	12.4643	12.4664	57960.0
2011-04-27 04:00:00	MSFT	Stock	26.27	26.27	26.27	26.27	100.0
2011-04-27 04:30:00	MSFT	Stock	26.27	26.27	26.27	26.27	100.0
2011-04-27 07:00:00	MSFT	Stock	26.19	26.28	26.19	26.28	1600.0
2011-04-27 07:30:00	MSFT	Stock	26.3	26.32	26.3	26.32	2397.0
2011-04-27 08:00:00	MSFT	Stock	26.32	26.36	26.28	26.3	39358.0
2011-04-27 08:30:00	MSFT	Stock	26.3	26.3	26.28	26.3	3418.0
2011-04-27 09:00:00	MSFT	Stock	26.3	26.34	26.1	26.32	85618.0
2011-04-27 09:30:00	MSFT	Stock	26.32	26.33	26.15	26.225	4989778.0
2011-04-27 10:00:00	MSFT	Stock	26.22	26.24	26.13	26.2	4260896.0
2011-04-27 10:30:00	MSFT	Stock	26.19	26.23	26.15	26.18	3627936.0
2011-04-27 11:00:00	MSFT	Stock	26.18	26.26	26.17	26.23	3981315.0
2011-04-27 11:30:00	MSFT	Stock	26.235	26.29	26.23	26.253	2825124.0
2011-04-27 12:00:00	MSFT	Stock	26.25	26.29	26.21	26.26	1883754.0
2011-04-27 12:30:00	MSFT	Stock	26.25	26.335	26.23	26.305	3340509.0
2011-04-27 13:00:00	MSFT	Stock	26.3	26.31	26.26	26.298	4670425.0
2011-04-27 13:30:00	MSFT	Stock	26.3	26.315	26.27	26.29	2779555.0
2011-04-27 14:00:00	MSFT	Stock	26.292	26.31	26.225	26.258	3266587.0
2011-04-27 14:30:00	MSFT	Stock	26.25	26.3	26.25	26.298	3547597.0
2011-04-27 15:00:00	MSFT	Stock	26.292	26.31	26.25	26.269	2939122.0

> showing 50 of 76,713 rows — these rows as CSV

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