PREVIEW / stock_30min / 2013-04-10

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-10.parquet
  size:    1.5 MB
  rows:    77,830
  symbols: 3,502

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-04-10 04:00:00	AAPL	Stock	15.2893	15.2893	15.2893	15.2893	2800.0
2013-04-10 06:00:00	AAPL	Stock	15.3143	15.3143	15.3143	15.3143	5600.0
2013-04-10 07:00:00	AAPL	Stock	15.315	15.3304	15.315	15.3254	56000.0
2013-04-10 07:30:00	AAPL	Stock	15.3214	15.3214	15.27	15.2832	100604.0
2013-04-10 08:00:00	AAPL	Stock	15.2857	15.3293	15.2143	15.3196	518868.0
2013-04-10 08:30:00	AAPL	Stock	15.3193	15.3196	15.25	15.2507	1317988.0
2013-04-10 09:00:00	AAPL	Stock	15.2568	15.3071	15.2568	15.3021	1821008.0
2013-04-10 09:30:00	AAPL	Stock	15.2893	15.3429	15.2146	15.2696	52367448.0
2013-04-10 10:00:00	AAPL	Stock	15.2646	15.4	15.2418	15.3546	48381452.0
2013-04-10 10:30:00	AAPL	Stock	15.3546	15.4479	15.3539	15.4246	37052820.0
2013-04-10 11:00:00	AAPL	Stock	15.4239	15.5036	15.4093	15.5032	31860276.0
2013-04-10 11:30:00	AAPL	Stock	15.5036	15.5511	15.49	15.5268	33396132.0
2013-04-10 12:00:00	AAPL	Stock	15.5257	15.5289	15.4879	15.5004	16280292.0
2013-04-10 12:30:00	AAPL	Stock	15.5007	15.5786	15.4989	15.5664	22131620.0
2013-04-10 13:00:00	AAPL	Stock	15.5639	15.5743	15.5289	15.5562	15714776.0
2013-04-10 13:30:00	AAPL	Stock	15.5568	15.5754	15.5449	15.5578	14555744.0
2013-04-10 14:00:00	AAPL	Stock	15.5582	15.5832	15.5489	15.5638	16954000.0
2013-04-10 14:30:00	AAPL	Stock	15.5608	15.5668	15.5221	15.5552	16398900.0
2013-04-10 15:00:00	AAPL	Stock	15.5557	15.5714	15.5271	15.5646	14852572.0
2013-04-10 15:30:00	AAPL	Stock	15.5646	15.6093	15.5464	15.5632	39032504.0
2013-04-10 16:00:00	AAPL	Stock	15.5604	15.5661	15.2459	15.5429	7841288.0
2013-04-10 16:30:00	AAPL	Stock	15.5432	15.6247	15.5393	15.5411	436744.0
2013-04-10 17:00:00	AAPL	Stock	15.5411	15.5604	15.5375	15.5604	256928.0
2013-04-10 17:30:00	AAPL	Stock	15.5418	15.5429	15.5375	15.5414	50372.0
2013-04-10 18:00:00	AAPL	Stock	15.5386	15.5482	15.5382	15.5393	88536.0
2013-04-10 18:30:00	AAPL	Stock	15.5414	15.5443	15.5386	15.5386	25200.0
2013-04-10 19:00:00	AAPL	Stock	15.54	15.54	15.5271	15.5357	87024.0
2013-04-10 19:30:00	AAPL	Stock	15.5357	15.5357	15.5275	15.5357	142856.0
2013-04-10 05:30:00	MSFT	Stock	29.65	29.65	29.65	29.65	200.0
2013-04-10 07:00:00	MSFT	Stock	29.65	29.65	29.53	29.6	3200.0
2013-04-10 07:30:00	MSFT	Stock	29.67	29.68	29.65	29.65	2500.0
2013-04-10 08:00:00	MSFT	Stock	29.67	29.7	29.56	29.68	10601.0
2013-04-10 08:30:00	MSFT	Stock	29.66	29.66	29.54	29.65	186485.0
2013-04-10 09:00:00	MSFT	Stock	29.67	29.7	29.61	29.61	63690.0
2013-04-10 09:30:00	MSFT	Stock	29.59	29.95	29.52	29.87	7566262.0
2013-04-10 10:00:00	MSFT	Stock	29.87	30.23	29.87	30.16	10553743.0
2013-04-10 10:30:00	MSFT	Stock	30.15	30.3	30.1	30.28	7026900.0
2013-04-10 11:00:00	MSFT	Stock	30.285	30.32	30.18	30.19	8015181.0
2013-04-10 11:30:00	MSFT	Stock	30.19	30.29	30.14	30.15	5259352.0
2013-04-10 12:00:00	MSFT	Stock	30.155	30.235	30.13	30.19	2331040.0
2013-04-10 12:30:00	MSFT	Stock	30.185	30.29	30.185	30.256	2658821.0
2013-04-10 13:00:00	MSFT	Stock	30.25	30.27	30.16	30.24	2652527.0
2013-04-10 13:30:00	MSFT	Stock	30.235	30.25	30.19	30.2	1947127.0
2013-04-10 14:00:00	MSFT	Stock	30.2	30.275	30.19	30.21	3197155.0
2013-04-10 14:30:00	MSFT	Stock	30.22	30.22	30.145	30.173	2321671.0
2013-04-10 15:00:00	MSFT	Stock	30.18	30.19	30.035	30.105	3576232.0
2013-04-10 15:30:00	MSFT	Stock	30.105	30.28	30.09	30.28	8373744.0
2013-04-10 16:00:00	MSFT	Stock	30.28	30.3	29.61	30.07	2637705.0
2013-04-10 16:30:00	MSFT	Stock	30.09	30.1	29.85	29.94	127459.0
2013-04-10 17:00:00	MSFT	Stock	29.97	30.28	29.77	29.82	76840.0

> showing 50 of 77,830 rows — these rows as CSV

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