PREVIEW / stock_30min / 2013-03-01

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-01.parquet
  size:    1.4 MB
  rows:    76,050
  symbols: 3,460

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-03-01 04:30:00	AAPL	Stock	15.8371	15.8371	15.8371	15.8371	2800.0
2013-03-01 05:00:00	AAPL	Stock	15.7911	15.7911	15.7911	15.7911	5600.0
2013-03-01 05:30:00	AAPL	Stock	15.7589	15.7589	15.7589	15.7589	5600.0
2013-03-01 06:30:00	AAPL	Stock	15.7232	15.7232	15.7143	15.7143	18676.0
2013-03-01 07:00:00	AAPL	Stock	15.7143	15.7179	15.6914	15.6914	41720.0
2013-03-01 07:30:00	AAPL	Stock	15.6961	15.7071	15.6554	15.6554	169652.0
2013-03-01 08:00:00	AAPL	Stock	15.6675	15.7679	15.625	15.6393	1709120.0
2013-03-01 08:30:00	AAPL	Stock	15.6375	15.6739	15.6175	15.6321	2577792.0
2013-03-01 09:00:00	AAPL	Stock	15.6329	15.6554	15.6304	15.6439	1895376.0
2013-03-01 09:30:00	AAPL	Stock	15.6432	15.6493	15.4446	15.4932	114031064.0
2013-03-01 10:00:00	AAPL	Stock	15.4929	15.5596	15.4243	15.4339	62311256.0
2013-03-01 10:30:00	AAPL	Stock	15.4346	15.5354	15.4321	15.5271	39890424.0
2013-03-01 11:00:00	AAPL	Stock	15.5311	15.597	15.4593	15.5096	41209952.0
2013-03-01 11:30:00	AAPL	Stock	15.5096	15.5179	15.4661	15.5069	25082400.0
2013-03-01 12:00:00	AAPL	Stock	15.5071	15.5707	15.5043	15.5264	23635248.0
2013-03-01 12:30:00	AAPL	Stock	15.5254	15.5454	15.4986	15.5263	14463568.0
2013-03-01 13:00:00	AAPL	Stock	15.5314	15.539	15.4743	15.4786	15656676.0
2013-03-01 13:30:00	AAPL	Stock	15.4786	15.4921	15.4029	15.4442	32040876.0
2013-03-01 14:00:00	AAPL	Stock	15.4439	15.4714	15.4036	15.4036	23074520.0
2013-03-01 14:30:00	AAPL	Stock	15.4043	15.4464	15.3846	15.4014	31752812.0
2013-03-01 15:00:00	AAPL	Stock	15.3993	15.4386	15.3896	15.4299	31073308.0
2013-03-01 15:30:00	AAPL	Stock	15.4311	15.4314	15.3564	15.3724	66595704.0
2013-03-01 16:00:00	AAPL	Stock	15.3754	15.498	15.355	15.3579	13414324.0
2013-03-01 16:30:00	AAPL	Stock	15.3582	15.4345	15.3546	15.3557	1484672.0
2013-03-01 17:00:00	AAPL	Stock	15.3557	15.3754	15.3557	15.3607	1144024.0
2013-03-01 17:30:00	AAPL	Stock	15.3604	15.3786	15.3589	15.375	317604.0
2013-03-01 18:00:00	AAPL	Stock	15.375	15.375	15.3696	15.3711	56980.0
2013-03-01 18:30:00	AAPL	Stock	15.3714	15.375	15.3693	15.3714	115640.0
2013-03-01 19:00:00	AAPL	Stock	15.375	15.375	15.3571	15.3714	479136.0
2013-03-01 19:30:00	AAPL	Stock	15.3707	15.3707	15.3614	15.3646	199248.0
2013-03-01 04:30:00	MSFT	Stock	27.73	27.73	27.73	27.73	400.0
2013-03-01 05:30:00	MSFT	Stock	27.72	27.72	27.72	27.72	100.0
2013-03-01 06:30:00	MSFT	Stock	27.72	27.72	27.72	27.72	400.0
2013-03-01 07:00:00	MSFT	Stock	27.71	27.71	27.71	27.71	318.0
2013-03-01 07:30:00	MSFT	Stock	27.65	27.65	27.65	27.65	400.0
2013-03-01 08:00:00	MSFT	Stock	27.7	27.77	27.63	27.77	13300.0
2013-03-01 08:30:00	MSFT	Stock	27.64	27.7	27.64	27.7	2878.0
2013-03-01 09:00:00	MSFT	Stock	27.8	27.8	27.68	27.73	21254.0
2013-03-01 09:30:00	MSFT	Stock	27.7	27.76	27.52	27.56	4398863.0
2013-03-01 10:00:00	MSFT	Stock	27.56	27.67	27.56	27.63	3381098.0
2013-03-01 10:30:00	MSFT	Stock	27.622	27.91	27.622	27.9	2433954.0
2013-03-01 11:00:00	MSFT	Stock	27.905	27.965	27.8	27.825	2251783.0
2013-03-01 11:30:00	MSFT	Stock	27.82	27.84	27.7	27.75	1255180.0
2013-03-01 12:00:00	MSFT	Stock	27.75	27.94	27.75	27.9	1943528.0
2013-03-01 12:30:00	MSFT	Stock	27.895	27.95	27.895	27.93	1508144.0
2013-03-01 13:00:00	MSFT	Stock	27.93	27.96	27.91	27.94	1002595.0
2013-03-01 13:30:00	MSFT	Stock	27.949	27.97	27.88	27.92	1401600.0
2013-03-01 14:00:00	MSFT	Stock	27.92	27.94	27.87	27.892	1382244.0
2013-03-01 14:30:00	MSFT	Stock	27.9	27.92	27.85	27.9	1487877.0
2013-03-01 15:00:00	MSFT	Stock	27.895	27.97	27.89	27.94	2372840.0

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

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