PREVIEW / stock_30min / 2013-05-07

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-07.parquet
  size:    1.5 MB
  rows:    78,697
  symbols: 3,510

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-05-07 04:00:00	AAPL	Stock	16.5239	16.5239	16.5118	16.5118	33908.0
2013-05-07 04:30:00	AAPL	Stock	16.5239	16.5239	16.4957	16.5071	24500.0
2013-05-07 05:00:00	AAPL	Stock	16.5139	16.5139	16.5139	16.5139	2800.0
2013-05-07 05:30:00	AAPL	Stock	16.5143	16.5168	16.5143	16.5168	8400.0
2013-05-07 06:00:00	AAPL	Stock	16.5232	16.5475	16.52	16.5379	18452.0
2013-05-07 06:30:00	AAPL	Stock	16.5443	16.5496	16.5232	16.5232	11200.0
2013-05-07 07:00:00	AAPL	Stock	16.5232	16.6071	16.5229	16.5964	454888.0
2013-05-07 07:30:00	AAPL	Stock	16.5954	16.5954	16.5536	16.5689	617792.0
2013-05-07 08:00:00	AAPL	Stock	16.5671	16.6054	16.5218	16.5857	1642592.0
2013-05-07 08:30:00	AAPL	Stock	16.5861	16.6175	16.5846	16.6	2141440.0
2013-05-07 09:00:00	AAPL	Stock	16.6025	16.625	16.5946	16.6071	3247524.0
2013-05-07 09:30:00	AAPL	Stock	16.6071	16.6339	16.4839	16.5179	92739892.0
2013-05-07 10:00:00	AAPL	Stock	16.5171	16.5196	16.2036	16.325	104516664.0
2013-05-07 10:30:00	AAPL	Stock	16.3279	16.3475	16.275	16.3018	39070388.0
2013-05-07 11:00:00	AAPL	Stock	16.3018	16.4068	16.2893	16.3518	36435644.0
2013-05-07 11:30:00	AAPL	Stock	16.3482	16.3711	16.2932	16.3061	22800680.0
2013-05-07 12:00:00	AAPL	Stock	16.3036	16.3575	16.3004	16.3243	14174860.0
2013-05-07 12:30:00	AAPL	Stock	16.3264	16.3781	16.2921	16.3639	18817372.0
2013-05-07 13:00:00	AAPL	Stock	16.3639	16.3671	16.3171	16.3444	12433848.0
2013-05-07 13:30:00	AAPL	Stock	16.3427	16.3879	16.3321	16.3818	13204716.0
2013-05-07 14:00:00	AAPL	Stock	16.3821	16.4389	16.3689	16.41	26930064.0
2013-05-07 14:30:00	AAPL	Stock	16.41	16.4207	16.3725	16.417	19308772.0
2013-05-07 15:00:00	AAPL	Stock	16.4143	16.4171	16.3679	16.3968	17489696.0
2013-05-07 15:30:00	AAPL	Stock	16.3946	16.4029	16.3396	16.3818	32984000.0
2013-05-07 16:00:00	AAPL	Stock	16.3818	16.3956	16.3754	16.3843	8961316.0
2013-05-07 16:30:00	AAPL	Stock	16.3825	16.4004	16.3807	16.3996	208712.0
2013-05-07 17:00:00	AAPL	Stock	16.395	16.4196	16.3807	16.4143	287616.0
2013-05-07 17:30:00	AAPL	Stock	16.4107	16.4196	16.4043	16.4143	94640.0
2013-05-07 18:00:00	AAPL	Stock	16.4111	16.4164	16.4011	16.4021	46340.0
2013-05-07 18:30:00	AAPL	Stock	16.4021	16.4021	16.3746	16.3746	221564.0
2013-05-07 19:00:00	AAPL	Stock	16.3732	16.3739	16.3625	16.37	30212.0
2013-05-07 19:30:00	AAPL	Stock	16.3714	16.3746	16.3571	16.3711	300748.0
2013-05-07 07:00:00	MSFT	Stock	33.77	33.77	33.6	33.6	1825.0
2013-05-07 07:30:00	MSFT	Stock	33.64	33.68	33.64	33.68	3000.0
2013-05-07 08:00:00	MSFT	Stock	33.72	33.97	33.59	33.74	13636.0
2013-05-07 08:30:00	MSFT	Stock	33.69	33.75	33.69	33.7	28517.0
2013-05-07 09:00:00	MSFT	Stock	33.7	33.76	33.65	33.65	69573.0
2013-05-07 09:30:00	MSFT	Stock	33.65	33.79	33.55	33.64	5608259.0
2013-05-07 10:00:00	MSFT	Stock	33.64	33.65	33.47	33.59	4780001.0
2013-05-07 10:30:00	MSFT	Stock	33.589	33.59	33.34	33.382	2759532.0
2013-05-07 11:00:00	MSFT	Stock	33.385	33.52	33.38	33.435	2624259.0
2013-05-07 11:30:00	MSFT	Stock	33.435	33.44	33.27	33.33	2752174.0
2013-05-07 12:00:00	MSFT	Stock	33.325	33.34	33.24	33.284	2471884.0
2013-05-07 12:30:00	MSFT	Stock	33.28	33.38	33.26	33.355	1844527.0
2013-05-07 13:00:00	MSFT	Stock	33.35	33.39	33.29	33.339	3742942.0
2013-05-07 13:30:00	MSFT	Stock	33.339	33.42	33.32	33.383	1776957.0
2013-05-07 14:00:00	MSFT	Stock	33.389	33.4	33.36	33.38	1417797.0
2013-05-07 14:30:00	MSFT	Stock	33.385	33.39	33.32	33.362	2089744.0
2013-05-07 15:00:00	MSFT	Stock	33.37	33.42	33.315	33.35	2216578.0
2013-05-07 15:30:00	MSFT	Stock	33.35	33.375	33.26	33.3	5495369.0

> showing 50 of 78,697 rows — these rows as CSV

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