PREVIEW / stock_30min / 2013-09-25

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-25.parquet
  size:    1.5 MB
  rows:    80,690
  symbols: 3,536

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-09-25 04:00:00	AAPL	Stock	17.4643	17.4643	17.2361	17.3571	78848.0
2013-09-25 04:30:00	AAPL	Stock	17.3571	17.3936	17.3571	17.3589	26124.0
2013-09-25 05:00:00	AAPL	Stock	17.3571	17.4214	17.3571	17.4214	106148.0
2013-09-25 05:30:00	AAPL	Stock	17.4214	17.44	17.4214	17.4396	19600.0
2013-09-25 06:00:00	AAPL	Stock	17.4375	17.4375	17.4286	17.4286	8540.0
2013-09-25 06:30:00	AAPL	Stock	17.4196	17.4589	17.4196	17.4589	126000.0
2013-09-25 07:00:00	AAPL	Stock	17.4614	17.4814	17.4146	17.4179	331240.0
2013-09-25 07:30:00	AAPL	Stock	17.4193	17.4543	17.4164	17.4361	47600.0
2013-09-25 08:00:00	AAPL	Stock	17.4482	17.5	17.4125	17.5	842772.0
2013-09-25 08:30:00	AAPL	Stock	17.5025	17.545	17.4679	17.5286	1520596.0
2013-09-25 09:00:00	AAPL	Stock	17.5271	17.5625	17.4582	17.4696	1939504.0
2013-09-25 09:30:00	AAPL	Stock	17.4714	17.4871	17.2014	17.2246	84726908.0
2013-09-25 10:00:00	AAPL	Stock	17.2232	17.2964	17.195	17.2821	41772780.0
2013-09-25 10:30:00	AAPL	Stock	17.2821	17.3125	17.21	17.2171	23017904.0
2013-09-25 11:00:00	AAPL	Stock	17.2161	17.2739	17.1939	17.2496	19224296.0
2013-09-25 11:30:00	AAPL	Stock	17.2493	17.2768	17.2314	17.2561	10529204.0
2013-09-25 12:00:00	AAPL	Stock	17.2575	17.3036	17.2339	17.275	10796408.0
2013-09-25 12:30:00	AAPL	Stock	17.2732	17.3179	17.2679	17.2907	10058524.0
2013-09-25 13:00:00	AAPL	Stock	17.2921	17.3125	17.2579	17.2686	8991780.0
2013-09-25 13:30:00	AAPL	Stock	17.2618	17.2743	17.2354	17.2657	10471916.0
2013-09-25 14:00:00	AAPL	Stock	17.2646	17.2914	17.2354	17.2446	8315216.0
2013-09-25 14:30:00	AAPL	Stock	17.2446	17.2671	17.2346	17.2407	8390536.0
2013-09-25 15:00:00	AAPL	Stock	17.2379	17.2746	17.2075	17.2225	15141504.0
2013-09-25 15:30:00	AAPL	Stock	17.2179	17.2643	17.1964	17.1979	31076248.0
2013-09-25 16:00:00	AAPL	Stock	17.1975	17.4679	17.1941	17.1941	11336052.0
2013-09-25 16:30:00	AAPL	Stock	17.2018	17.2214	17.1975	17.2196	335664.0
2013-09-25 17:00:00	AAPL	Stock	17.2179	17.2179	17.2079	17.2143	265832.0
2013-09-25 17:30:00	AAPL	Stock	17.2204	17.2225	17.1975	17.215	394688.0
2013-09-25 18:00:00	AAPL	Stock	17.2179	17.2282	17.1975	17.2243	357980.0
2013-09-25 18:30:00	AAPL	Stock	17.2246	17.2275	17.22	17.2271	49924.0
2013-09-25 19:00:00	AAPL	Stock	17.2271	17.2286	17.2218	17.2218	28896.0
2013-09-25 19:30:00	AAPL	Stock	17.2232	17.2304	17.2232	17.2304	79100.0
2013-09-25 04:30:00	MSFT	Stock	32.15	32.15	32.15	32.15	1000.0
2013-09-25 07:00:00	MSFT	Stock	32.51	32.54	32.45	32.45	700.0
2013-09-25 07:30:00	MSFT	Stock	32.46	32.46	32.46	32.46	500.0
2013-09-25 08:00:00	MSFT	Stock	32.31	32.5	32.31	32.49	5310.0
2013-09-25 08:30:00	MSFT	Stock	32.49	32.5	32.49	32.5	4440.0
2013-09-25 09:00:00	MSFT	Stock	32.5	32.51	32.455	32.49	178868.0
2013-09-25 09:30:00	MSFT	Stock	32.52	32.68	32.46	32.66	3948675.0
2013-09-25 10:00:00	MSFT	Stock	32.67	32.67	32.42	32.625	2259216.0
2013-09-25 10:30:00	MSFT	Stock	32.625	32.66	32.56	32.604	1548944.0
2013-09-25 11:00:00	MSFT	Stock	32.605	32.8	32.5	32.77	2823078.0
2013-09-25 11:30:00	MSFT	Stock	32.77	32.79	32.679	32.69	1322856.0
2013-09-25 12:00:00	MSFT	Stock	32.695	32.73	32.58	32.595	1488008.0
2013-09-25 12:30:00	MSFT	Stock	32.6	32.61	32.525	32.561	1370828.0
2013-09-25 13:00:00	MSFT	Stock	32.57	32.6	32.51	32.545	903289.0
2013-09-25 13:30:00	MSFT	Stock	32.545	32.547	32.4	32.49	1816774.0
2013-09-25 14:00:00	MSFT	Stock	32.488	32.53	32.43	32.49	1132233.0
2013-09-25 14:30:00	MSFT	Stock	32.493	32.6	32.47	32.536	899207.0
2013-09-25 15:00:00	MSFT	Stock	32.53	32.63	32.5	32.56	1432060.0

> showing 50 of 80,690 rows — these rows as CSV

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