PREVIEW / stock_30min / 2014-09-12

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-12.parquet
  size:    1.6 MB
  rows:    83,406
  symbols: 3,574

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
2014-09-12 04:00:00	AAPL	Stock	25.3325	25.3325	25.3325	25.3325	1200.0
2014-09-12 04:30:00	AAPL	Stock	25.2575	25.305	25.2575	25.3	3560.0
2014-09-12 05:00:00	AAPL	Stock	25.295	25.295	25.295	25.295	4740.0
2014-09-12 05:30:00	AAPL	Stock	25.295	25.295	25.2775	25.2775	2400.0
2014-09-12 06:00:00	AAPL	Stock	25.295	25.3	25.2875	25.3	21560.0
2014-09-12 06:30:00	AAPL	Stock	25.295	25.31	25.2775	25.2925	24044.0
2014-09-12 07:00:00	AAPL	Stock	25.2925	25.325	25.185	25.185	269512.0
2014-09-12 07:30:00	AAPL	Stock	25.185	25.2825	25.1475	25.2375	353028.0
2014-09-12 08:00:00	AAPL	Stock	25.165	25.35	25.165	25.2625	1065512.0
2014-09-12 08:30:00	AAPL	Stock	25.2675	25.2875	25.2375	25.25	361492.0
2014-09-12 09:00:00	AAPL	Stock	25.26	25.3	25.2525	25.3	275996.0
2014-09-12 09:30:00	AAPL	Stock	25.305	25.45	25.27	25.3325	36906144.0
2014-09-12 10:00:00	AAPL	Stock	25.3325	25.4175	25.29	25.3788	19307692.0
2014-09-12 10:30:00	AAPL	Stock	25.38	25.4225	25.355	25.41	13535524.0
2014-09-12 11:00:00	AAPL	Stock	25.4125	25.5175	25.405	25.4625	22826956.0
2014-09-12 11:30:00	AAPL	Stock	25.4625	25.465	25.3825	25.405	11558668.0
2014-09-12 12:00:00	AAPL	Stock	25.405	25.4725	25.3725	25.445	9526308.0
2014-09-12 12:30:00	AAPL	Stock	25.4425	25.5475	25.3975	25.495	18933660.0
2014-09-12 13:00:00	AAPL	Stock	25.4925	25.5375	25.455	25.4875	12151788.0
2014-09-12 13:30:00	AAPL	Stock	25.4875	25.51	25.4575	25.4925	9792136.0
2014-09-12 14:00:00	AAPL	Stock	25.49	25.535	25.4375	25.44	12794792.0
2014-09-12 14:30:00	AAPL	Stock	25.445	25.47	25.37	25.395	17707768.0
2014-09-12 15:00:00	AAPL	Stock	25.395	25.4825	25.3752	25.4025	14639412.0
2014-09-12 15:30:00	AAPL	Stock	25.4022	25.425	25.3425	25.4175	27736184.0
2014-09-12 16:00:00	AAPL	Stock	25.415	25.4225	25.375	25.41	9232300.0
2014-09-12 16:30:00	AAPL	Stock	25.41	25.4275	25.41	25.4225	539428.0
2014-09-12 17:00:00	AAPL	Stock	25.42	25.4375	25.42	25.4375	92128.0
2014-09-12 17:30:00	AAPL	Stock	25.4425	25.4475	25.4175	25.4175	98364.0
2014-09-12 18:00:00	AAPL	Stock	25.415	25.4275	25.4	25.4175	140144.0
2014-09-12 18:30:00	AAPL	Stock	25.4225	25.43	25.4125	25.415	104956.0
2014-09-12 19:00:00	AAPL	Stock	25.425	25.435	25.4125	25.415	5616308.0
2014-09-12 19:30:00	AAPL	Stock	25.415	25.425	25.4	25.4	103744.0
2014-09-12 07:00:00	MSFT	Stock	46.96	46.96	46.94	46.94	902.0
2014-09-12 07:30:00	MSFT	Stock	46.94	46.97	46.9	46.96	5592.0
2014-09-12 08:00:00	MSFT	Stock	46.96	46.97	46.96	46.96	4200.0
2014-09-12 08:30:00	MSFT	Stock	46.97	46.97	46.97	46.97	100.0
2014-09-12 09:00:00	MSFT	Stock	46.93	46.97	46.91	46.97	2317.0
2014-09-12 09:30:00	MSFT	Stock	46.91	47.02	46.61	46.72	6522191.0
2014-09-12 10:00:00	MSFT	Stock	46.725	46.88	46.65	46.69	4237095.0
2014-09-12 10:30:00	MSFT	Stock	46.69	46.83	46.65	46.8	1919402.0
2014-09-12 11:00:00	MSFT	Stock	46.792	46.83	46.74	46.8	1222285.0
2014-09-12 11:30:00	MSFT	Stock	46.79	46.8	46.7	46.74	994685.0
2014-09-12 12:00:00	MSFT	Stock	46.74	46.75	46.7	46.725	1371750.0
2014-09-12 12:30:00	MSFT	Stock	46.72	46.73	46.65	46.65	2281546.0
2014-09-12 13:00:00	MSFT	Stock	46.66	46.71	46.61	46.635	2710423.0
2014-09-12 13:30:00	MSFT	Stock	46.64	46.68	46.6	46.66	1182687.0
2014-09-12 14:00:00	MSFT	Stock	46.66	46.7	46.62	46.656	1972909.0
2014-09-12 14:30:00	MSFT	Stock	46.66	46.71	46.61	46.67	2592937.0
2014-09-12 15:00:00	MSFT	Stock	46.67	46.73	46.65	46.7	1692129.0
2014-09-12 15:30:00	MSFT	Stock	46.7	46.75	46.65	46.7	3580728.0

> showing 50 of 83,406 rows — these rows as CSV

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