PREVIEW / stock_30min / 2014-06-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-03.parquet
  size:    1.6 MB
  rows:    81,835
  symbols: 3,530

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-06-03 04:30:00	AAPL	Stock	22.3464	22.3464	22.3232	22.3232	11200.0
2014-06-03 05:00:00	AAPL	Stock	22.3214	22.3214	22.3214	22.3214	5600.0
2014-06-03 05:30:00	AAPL	Stock	22.3214	22.3361	22.3214	22.3271	16828.0
2014-06-03 06:00:00	AAPL	Stock	22.3325	22.3339	22.3304	22.3304	13916.0
2014-06-03 06:30:00	AAPL	Stock	22.3357	22.3571	22.3357	22.3571	28448.0
2014-06-03 07:00:00	AAPL	Stock	22.3571	22.3711	22.3296	22.3643	167104.0
2014-06-03 07:30:00	AAPL	Stock	22.3571	22.3571	22.3393	22.35	117880.0
2014-06-03 08:00:00	AAPL	Stock	22.3554	22.3746	22.3325	22.3679	434812.0
2014-06-03 08:30:00	AAPL	Stock	22.3611	22.4479	22.3607	22.4239	757260.0
2014-06-03 09:00:00	AAPL	Stock	22.4239	22.4707	22.4221	22.4439	1169196.0
2014-06-03 09:30:00	AAPL	Stock	22.445	22.78	22.4375	22.7551	65522212.0
2014-06-03 10:00:00	AAPL	Stock	22.7571	22.8121	22.7161	22.7325	30885400.0
2014-06-03 10:30:00	AAPL	Stock	22.735	22.7571	22.6575	22.7071	18035556.0
2014-06-03 11:00:00	AAPL	Stock	22.7093	22.7136	22.6346	22.6621	12953248.0
2014-06-03 11:30:00	AAPL	Stock	22.6596	22.6621	22.575	22.6479	18841032.0
2014-06-03 12:00:00	AAPL	Stock	22.6479	22.7446	22.6446	22.7111	9823604.0
2014-06-03 12:30:00	AAPL	Stock	22.7096	22.7286	22.6443	22.645	6076644.0
2014-06-03 13:00:00	AAPL	Stock	22.6478	22.7714	22.6454	22.7607	10956568.0
2014-06-03 13:30:00	AAPL	Stock	22.7604	22.7636	22.7057	22.725	7790916.0
2014-06-03 14:00:00	AAPL	Stock	22.7307	22.7636	22.7054	22.7307	6884584.0
2014-06-03 14:30:00	AAPL	Stock	22.7277	22.75	22.6871	22.6954	8396920.0
2014-06-03 15:00:00	AAPL	Stock	22.6961	22.7486	22.6871	22.7332	9061948.0
2014-06-03 15:30:00	AAPL	Stock	22.7375	22.7896	22.7204	22.7693	22163764.0
2014-06-03 16:00:00	AAPL	Stock	22.7693	22.7818	22.4518	22.7215	6232800.0
2014-06-03 16:30:00	AAPL	Stock	22.775	22.78	22.4409	22.78	322420.0
2014-06-03 17:00:00	AAPL	Stock	22.775	22.7929	22.775	22.7929	106400.0
2014-06-03 17:30:00	AAPL	Stock	22.7929	22.8036	22.7693	22.8036	272104.0
2014-06-03 18:00:00	AAPL	Stock	22.7971	22.8032	22.7868	22.7868	112840.0
2014-06-03 18:30:00	AAPL	Stock	22.7868	22.7868	22.7814	22.7839	19796.0
2014-06-03 19:00:00	AAPL	Stock	22.7893	22.7946	22.7857	22.7857	24164.0
2014-06-03 19:30:00	AAPL	Stock	22.8025	22.8025	22.7929	22.7932	28504.0
2014-06-03 05:00:00	MSFT	Stock	40.7	40.7	40.57	40.57	300.0
2014-06-03 05:30:00	MSFT	Stock	40.58	40.63	40.58	40.63	200.0
2014-06-03 06:00:00	MSFT	Stock	40.72	40.72	40.72	40.72	100.0
2014-06-03 07:30:00	MSFT	Stock	40.64	40.7	40.64	40.7	700.0
2014-06-03 08:30:00	MSFT	Stock	40.71	40.71	40.65	40.65	300.0
2014-06-03 09:00:00	MSFT	Stock	40.69	40.71	40.6	40.6	26808.0
2014-06-03 09:30:00	MSFT	Stock	40.6	40.68	40.35	40.46	2545882.0
2014-06-03 10:00:00	MSFT	Stock	40.47	40.525	40.3	40.31	1608458.0
2014-06-03 10:30:00	MSFT	Stock	40.315	40.35	40.29	40.35	1073216.0
2014-06-03 11:00:00	MSFT	Stock	40.35	40.4	40.32	40.38	847633.0
2014-06-03 11:30:00	MSFT	Stock	40.37	40.4	40.31	40.374	698116.0
2014-06-03 12:00:00	MSFT	Stock	40.38	40.45	40.37	40.45	486764.0
2014-06-03 12:30:00	MSFT	Stock	40.45	40.45	40.32	40.35	769414.0
2014-06-03 13:00:00	MSFT	Stock	40.345	40.42	40.34	40.395	505010.0
2014-06-03 13:30:00	MSFT	Stock	40.39	40.4	40.33	40.35	498799.0
2014-06-03 14:00:00	MSFT	Stock	40.35	40.42	40.33	40.39	822739.0
2014-06-03 14:30:00	MSFT	Stock	40.39	40.41	40.31	40.31	776594.0
2014-06-03 15:00:00	MSFT	Stock	40.315	40.32	40.285	40.305	1129683.0
2014-06-03 15:30:00	MSFT	Stock	40.3	40.31	40.25	40.28	2921008.0

> showing 50 of 81,835 rows — these rows as CSV

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