PREVIEW / stock_30min / 2014-01-17

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-17.parquet
  size:    1.6 MB
  rows:    84,719
  symbols: 3,531

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-01-17 05:00:00	AAPL	Stock	19.8214	19.8214	19.8107	19.8107	11200.0
2014-01-17 05:30:00	AAPL	Stock	19.8111	19.8154	19.8054	19.8154	24220.0
2014-01-17 06:00:00	AAPL	Stock	19.7946	19.8111	19.7768	19.7857	75572.0
2014-01-17 06:30:00	AAPL	Stock	19.7821	19.7825	19.7254	19.7464	127064.0
2014-01-17 07:00:00	AAPL	Stock	19.7325	19.7607	19.6521	19.6536	296968.0
2014-01-17 07:30:00	AAPL	Stock	19.6521	19.695	19.6464	19.695	461328.0
2014-01-17 08:00:00	AAPL	Stock	19.6964	19.7625	19.6382	19.7018	2077992.0
2014-01-17 08:30:00	AAPL	Stock	19.7054	19.7104	19.5939	19.6432	1701056.0
2014-01-17 09:00:00	AAPL	Stock	19.6543	19.7139	19.6389	19.6857	2104984.0
2014-01-17 09:30:00	AAPL	Stock	19.6957	19.7168	19.5571	19.6314	94072748.0
2014-01-17 10:00:00	AAPL	Stock	19.6325	19.6509	19.5971	19.605	19482120.0
2014-01-17 10:30:00	AAPL	Stock	19.6054	19.625	19.5789	19.6127	14298592.0
2014-01-17 11:00:00	AAPL	Stock	19.6116	19.6229	19.5904	19.6054	9822680.0
2014-01-17 11:30:00	AAPL	Stock	19.6086	19.6146	19.5843	19.5868	8786148.0
2014-01-17 12:00:00	AAPL	Stock	19.5864	19.5957	19.5796	19.5869	8037372.0
2014-01-17 12:30:00	AAPL	Stock	19.5875	19.6032	19.5789	19.5825	6807024.0
2014-01-17 13:00:00	AAPL	Stock	19.5814	19.5848	19.4875	19.5004	21736932.0
2014-01-17 13:30:00	AAPL	Stock	19.5004	19.5039	19.3896	19.4629	29225140.0
2014-01-17 14:00:00	AAPL	Stock	19.4654	19.4796	19.4396	19.4611	19538008.0
2014-01-17 14:30:00	AAPL	Stock	19.4607	19.4607	19.3961	19.4193	20333432.0
2014-01-17 15:00:00	AAPL	Stock	19.4193	19.4268	19.3254	19.3464	30234008.0
2014-01-17 15:30:00	AAPL	Stock	19.3457	19.3464	19.2821	19.3004	54256524.0
2014-01-17 16:00:00	AAPL	Stock	19.3054	19.6924	19.2946	19.3071	15024520.0
2014-01-17 16:30:00	AAPL	Stock	19.3071	19.6125	19.3	19.3096	1545488.0
2014-01-17 17:00:00	AAPL	Stock	19.3132	19.3139	19.2971	19.3082	215320.0
2014-01-17 17:30:00	AAPL	Stock	19.3082	19.3082	19.2925	19.2925	4916996.0
2014-01-17 18:00:00	AAPL	Stock	19.2961	19.3071	19.2907	19.3071	427196.0
2014-01-17 18:30:00	AAPL	Stock	19.3054	19.3071	19.3018	19.3018	64512.0
2014-01-17 19:00:00	AAPL	Stock	19.3007	19.3139	19.2971	19.3139	113652.0
2014-01-17 19:30:00	AAPL	Stock	19.3164	19.3211	19.3121	19.3179	109928.0
2014-01-17 07:30:00	MSFT	Stock	36.88	36.88	36.85	36.85	3250.0
2014-01-17 08:00:00	MSFT	Stock	36.85	36.92	36.85	36.91	13800.0
2014-01-17 08:30:00	MSFT	Stock	36.89	36.9	36.89	36.89	3300.0
2014-01-17 09:00:00	MSFT	Stock	36.88	36.92	36.79	36.79	153362.0
2014-01-17 09:30:00	MSFT	Stock	36.79	36.83	36.18	36.365	17823822.0
2014-01-17 10:00:00	MSFT	Stock	36.37	36.42	36.26	36.33	2667754.0
2014-01-17 10:30:00	MSFT	Stock	36.33	36.34	36.15	36.29	2308968.0
2014-01-17 11:00:00	MSFT	Stock	36.29	36.33	36.25	36.29	1419084.0
2014-01-17 11:30:00	MSFT	Stock	36.29	36.359	36.27	36.35	1342320.0
2014-01-17 12:00:00	MSFT	Stock	36.35	36.5	36.33	36.38	2058789.0
2014-01-17 12:30:00	MSFT	Stock	36.39	36.44	36.33	36.4	1269082.0
2014-01-17 13:00:00	MSFT	Stock	36.39	36.51	36.36	36.41	1458255.0
2014-01-17 13:30:00	MSFT	Stock	36.41	36.435	36.37	36.41	1153845.0
2014-01-17 14:00:00	MSFT	Stock	36.41	36.45	36.38	36.385	922948.0
2014-01-17 14:30:00	MSFT	Stock	36.385	36.42	36.36	36.37	962426.0
2014-01-17 15:00:00	MSFT	Stock	36.36	36.41	36.25	36.29	1734249.0
2014-01-17 15:30:00	MSFT	Stock	36.28	36.38	36.22	36.36	4906883.0
2014-01-17 16:00:00	MSFT	Stock	36.36	36.516	36.323	36.38	4174448.0
2014-01-17 16:30:00	MSFT	Stock	36.286	36.38	36.286	36.38	314162.0
2014-01-17 17:00:00	MSFT	Stock	36.38	36.38	36.38	36.38	300.0

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

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