PREVIEW / stock_30min / 2012-05-30

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-30.parquet
  size:    1.4 MB
  rows:    76,112
  symbols: 3,544

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
2012-05-30 04:00:00	AAPL	Stock	20.3668	20.3668	20.3218	20.3482	28168.0
2012-05-30 04:30:00	AAPL	Stock	20.3218	20.3218	20.3214	20.3214	5712.0
2012-05-30 05:00:00	AAPL	Stock	20.3214	20.3357	20.2975	20.3357	33600.0
2012-05-30 05:30:00	AAPL	Stock	20.3357	20.3357	20.3107	20.3107	11200.0
2012-05-30 06:00:00	AAPL	Stock	20.3179	20.3179	20.3179	20.3179	16800.0
2012-05-30 06:30:00	AAPL	Stock	20.305	20.305	20.2907	20.2907	16800.0
2012-05-30 07:00:00	AAPL	Stock	20.29	20.3836	20.2543	20.3411	575204.0
2012-05-30 07:30:00	AAPL	Stock	20.3314	20.4207	20.3211	20.3571	495152.0
2012-05-30 08:00:00	AAPL	Stock	20.3343	20.3621	20.2786	20.2964	1570716.0
2012-05-30 08:30:00	AAPL	Stock	20.2957	20.3354	20.2696	20.3182	919016.0
2012-05-30 09:00:00	AAPL	Stock	20.3107	20.3661	20.3089	20.3429	2845864.0
2012-05-30 09:30:00	AAPL	Stock	20.3286	20.3921	20.2343	20.2964	59885504.0
2012-05-30 10:00:00	AAPL	Stock	20.295	20.4575	20.2679	20.4064	54374516.0
2012-05-30 10:30:00	AAPL	Stock	20.4061	20.4107	20.2896	20.3118	30135280.0
2012-05-30 11:00:00	AAPL	Stock	20.3111	20.4161	20.3071	20.4071	26179132.0
2012-05-30 11:30:00	AAPL	Stock	20.4043	20.4586	20.3857	20.4182	32108272.0
2012-05-30 12:00:00	AAPL	Stock	20.4136	20.4271	20.3575	20.4032	20412560.0
2012-05-30 12:30:00	AAPL	Stock	20.3996	20.5154	20.3932	20.4854	33878096.0
2012-05-30 13:00:00	AAPL	Stock	20.4796	20.5	20.4407	20.49	19659808.0
2012-05-30 13:30:00	AAPL	Stock	20.4879	20.6143	20.4821	20.6111	37853032.0
2012-05-30 14:00:00	AAPL	Stock	20.6139	20.6914	20.5725	20.6096	59436244.0
2012-05-30 14:30:00	AAPL	Stock	20.6096	20.6689	20.5901	20.6232	25683644.0
2012-05-30 15:00:00	AAPL	Stock	20.625	20.6964	20.5171	20.6796	48770764.0
2012-05-30 15:30:00	AAPL	Stock	20.6804	20.7139	20.6464	20.6789	63540372.0
2012-05-30 16:00:00	AAPL	Stock	20.6846	20.6957	20.4732	20.6714	8204252.0
2012-05-30 16:30:00	AAPL	Stock	20.6643	20.6846	20.5621	20.6571	450268.0
2012-05-30 17:00:00	AAPL	Stock	20.6589	20.6607	20.4885	20.6607	241500.0
2012-05-30 17:30:00	AAPL	Stock	20.6611	20.6679	20.6557	20.6646	74620.0
2012-05-30 18:00:00	AAPL	Stock	20.6646	20.6679	20.6536	20.6557	131768.0
2012-05-30 18:30:00	AAPL	Stock	20.6557	20.6607	20.6307	20.6411	148876.0
2012-05-30 19:00:00	AAPL	Stock	20.6429	20.6518	20.6336	20.6425	106036.0
2012-05-30 19:30:00	AAPL	Stock	20.6429	20.6429	20.6089	20.6218	183652.0
2012-05-30 06:30:00	MSFT	Stock	29.26	29.26	29.25	29.25	600.0
2012-05-30 07:00:00	MSFT	Stock	29.3	29.3	29.3	29.3	100.0
2012-05-30 08:00:00	MSFT	Stock	29.47	29.54	29.38	29.4	5112.0
2012-05-30 08:30:00	MSFT	Stock	29.35	29.35	29.35	29.35	300.0
2012-05-30 09:00:00	MSFT	Stock	29.34	29.35	29.32	29.33	4748.0
2012-05-30 09:30:00	MSFT	Stock	29.32	29.36	29.195	29.29	3896338.0
2012-05-30 10:00:00	MSFT	Stock	29.29	29.34	29.22	29.258	3968257.0
2012-05-30 10:30:00	MSFT	Stock	29.25	29.26	29.17	29.18	3609340.0
2012-05-30 11:00:00	MSFT	Stock	29.18	29.26	29.18	29.21	3726037.0
2012-05-30 11:30:00	MSFT	Stock	29.21	29.26	29.12	29.229	3404589.0
2012-05-30 12:00:00	MSFT	Stock	29.23	29.27	29.14	29.185	2948084.0
2012-05-30 12:30:00	MSFT	Stock	29.185	29.31	29.17	29.28	1483860.0
2012-05-30 13:00:00	MSFT	Stock	29.28	29.29	29.22	29.26	1414514.0
2012-05-30 13:30:00	MSFT	Stock	29.255	29.43	29.25	29.415	2494508.0
2012-05-30 14:00:00	MSFT	Stock	29.417	29.479	29.36	29.41	2946510.0
2012-05-30 14:30:00	MSFT	Stock	29.415	29.45	29.33	29.395	1832177.0
2012-05-30 15:00:00	MSFT	Stock	29.39	29.45	29.23	29.38	2755979.0
2012-05-30 15:30:00	MSFT	Stock	29.38	29.45	29.34	29.34	4979109.0

> showing 50 of 76,112 rows — these rows as CSV

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