PREVIEW / stock_30min / 2014-03-26

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-26.parquet
  size:    1.6 MB
  rows:    84,190
  symbols: 3,526

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-03-26 05:00:00	AAPL	Stock	19.5257	19.5257	19.5257	19.5257	5600.0
2014-03-26 05:30:00	AAPL	Stock	19.4857	19.4857	19.4857	19.4857	22400.0
2014-03-26 06:00:00	AAPL	Stock	19.5296	19.5314	19.5296	19.5314	5600.0
2014-03-26 06:30:00	AAPL	Stock	19.5286	19.5286	19.5179	19.5218	48552.0
2014-03-26 07:00:00	AAPL	Stock	19.5357	19.5357	19.5011	19.5071	69160.0
2014-03-26 07:30:00	AAPL	Stock	19.5011	19.5286	19.4829	19.5286	132440.0
2014-03-26 08:00:00	AAPL	Stock	19.5314	19.5479	19.4989	19.5311	918736.0
2014-03-26 08:30:00	AAPL	Stock	19.5304	19.5464	19.5179	19.5404	788732.0
2014-03-26 09:00:00	AAPL	Stock	19.5411	19.5539	19.52	19.5268	973196.0
2014-03-26 09:30:00	AAPL	Stock	19.5186	19.605	19.5186	19.6046	37585464.0
2014-03-26 10:00:00	AAPL	Stock	19.6046	19.6071	19.54	19.5536	22651300.0
2014-03-26 10:30:00	AAPL	Stock	19.5511	19.5996	19.5268	19.5295	12115768.0
2014-03-26 11:00:00	AAPL	Stock	19.5311	19.5925	19.5218	19.575	12656448.0
2014-03-26 11:30:00	AAPL	Stock	19.577	19.5804	19.5357	19.5554	10949708.0
2014-03-26 12:00:00	AAPL	Stock	19.5575	19.5589	19.4704	19.4875	12864404.0
2014-03-26 12:30:00	AAPL	Stock	19.4857	19.5389	19.4786	19.5311	8402688.0
2014-03-26 13:00:00	AAPL	Stock	19.5311	19.5332	19.48	19.4854	6321700.0
2014-03-26 13:30:00	AAPL	Stock	19.4807	19.4968	19.3048	19.3736	25607596.0
2014-03-26 14:00:00	AAPL	Stock	19.3707	19.372	19.245	19.3268	20901832.0
2014-03-26 14:30:00	AAPL	Stock	19.3229	19.4182	19.2961	19.395	13837180.0
2014-03-26 15:00:00	AAPL	Stock	19.3982	19.4089	19.3107	19.3182	12738432.0
2014-03-26 15:30:00	AAPL	Stock	19.3211	19.3507	19.2774	19.2779	23004464.0
2014-03-26 16:00:00	AAPL	Stock	19.2779	19.4636	19.2482	19.2504	13598284.0
2014-03-26 16:30:00	AAPL	Stock	19.2518	19.538	19.25	19.2614	730968.0
2014-03-26 17:00:00	AAPL	Stock	19.2625	19.2779	19.2507	19.2625	380436.0
2014-03-26 17:30:00	AAPL	Stock	19.2779	19.2779	19.2543	19.26	421428.0
2014-03-26 18:00:00	AAPL	Stock	19.2607	19.2679	19.2546	19.2589	168336.0
2014-03-26 18:30:00	AAPL	Stock	19.2639	19.2779	19.2521	19.2521	1144024.0
2014-03-26 19:00:00	AAPL	Stock	19.2521	19.2643	19.2457	19.2457	113400.0
2014-03-26 19:30:00	AAPL	Stock	19.2357	19.25	19.2357	19.2425	188244.0
2014-03-26 08:00:00	MSFT	Stock	40.64	40.64	40.5	40.5	4049.0
2014-03-26 08:30:00	MSFT	Stock	40.5	40.55	40.5	40.52	10094.0
2014-03-26 09:00:00	MSFT	Stock	40.52	40.55	40.43	40.43	29665.0
2014-03-26 09:30:00	MSFT	Stock	40.46	40.705	40.26	40.325	4557115.0
2014-03-26 10:00:00	MSFT	Stock	40.325	40.33	40.03	40.055	2192921.0
2014-03-26 10:30:00	MSFT	Stock	40.055	40.07	39.67	39.69	4258147.0
2014-03-26 11:00:00	MSFT	Stock	39.685	39.97	39.6	39.894	2391876.0
2014-03-26 11:30:00	MSFT	Stock	39.89	39.92	39.74	39.85	1420749.0
2014-03-26 12:00:00	MSFT	Stock	39.85	39.88	39.72	39.86	2062796.0
2014-03-26 12:30:00	MSFT	Stock	39.86	39.92	39.81	39.9	1573688.0
2014-03-26 13:00:00	MSFT	Stock	39.9	40.01	39.89	39.896	2223140.0
2014-03-26 13:30:00	MSFT	Stock	39.89	39.95	39.8	39.93	2890175.0
2014-03-26 14:00:00	MSFT	Stock	39.93	40.01	39.86	39.999	2172511.0
2014-03-26 14:30:00	MSFT	Stock	39.994	40.035	39.91	40.0	2624557.0
2014-03-26 15:00:00	MSFT	Stock	39.99	40.015	39.89	39.915	1890809.0
2014-03-26 15:30:00	MSFT	Stock	39.915	39.975	39.79	39.79	5997569.0
2014-03-26 16:00:00	MSFT	Stock	39.79	39.876	39.72	39.79	2485009.0
2014-03-26 16:30:00	MSFT	Stock	39.843	39.912	39.72	39.79	157363.0
2014-03-26 17:00:00	MSFT	Stock	39.79	39.79	39.78	39.78	8527.0
2014-03-26 17:30:00	MSFT	Stock	39.79	39.79	39.79	39.79	122583.0

> showing 50 of 84,190 rows — these rows as CSV

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