PREVIEW / stock_30min / 2012-03-30

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-30.parquet
  size:    1.4 MB
  rows:    76,587
  symbols: 3,557

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-03-30 04:00:00	AAPL	Stock	21.6193	21.6193	21.6193	21.6193	9800.0
2012-03-30 04:30:00	AAPL	Stock	21.6196	21.655	21.6196	21.655	16800.0
2012-03-30 05:00:00	AAPL	Stock	21.6189	21.655	21.6189	21.655	28588.0
2012-03-30 05:30:00	AAPL	Stock	21.6429	21.6782	21.6429	21.6782	5600.0
2012-03-30 06:00:00	AAPL	Stock	21.6789	21.6789	21.6432	21.6786	39256.0
2012-03-30 06:30:00	AAPL	Stock	21.6786	21.7143	21.6786	21.7104	27608.0
2012-03-30 07:00:00	AAPL	Stock	21.7068	21.7975	21.7068	21.7768	1034124.0
2012-03-30 07:30:00	AAPL	Stock	21.7732	21.8429	21.77	21.8111	1168832.0
2012-03-30 08:00:00	AAPL	Stock	21.8179	21.8661	21.7496	21.7768	3382736.0
2012-03-30 08:30:00	AAPL	Stock	21.7761	21.7761	21.7	21.7036	2850904.0
2012-03-30 09:00:00	AAPL	Stock	21.7064	21.7821	21.6536	21.7264	4738580.0
2012-03-30 09:30:00	AAPL	Stock	21.7418	21.8057	21.6171	21.6407	105659232.0
2012-03-30 10:00:00	AAPL	Stock	21.6399	21.6857	21.4732	21.4857	96328316.0
2012-03-30 10:30:00	AAPL	Stock	21.4871	21.5343	21.355	21.5224	129765804.0
2012-03-30 11:00:00	AAPL	Stock	21.5218	21.5868	21.5129	21.5732	51550380.0
2012-03-30 11:30:00	AAPL	Stock	21.5707	21.5732	21.5004	21.5311	29651608.0
2012-03-30 12:00:00	AAPL	Stock	21.5307	21.5339	21.4393	21.5104	40012560.0
2012-03-30 12:30:00	AAPL	Stock	21.5089	21.5136	21.4611	21.4725	21046116.0
2012-03-30 13:00:00	AAPL	Stock	21.4686	21.5179	21.4625	21.4929	16398844.0
2012-03-30 13:30:00	AAPL	Stock	21.4929	21.4993	21.4572	21.4746	14757176.0
2012-03-30 14:00:00	AAPL	Stock	21.4739	21.5046	21.4414	21.45	19779088.0
2012-03-30 14:30:00	AAPL	Stock	21.4504	21.4661	21.4125	21.442	42277620.0
2012-03-30 15:00:00	AAPL	Stock	21.4431	21.475	21.4286	21.4446	39072516.0
2012-03-30 15:30:00	AAPL	Stock	21.4439	21.4514	21.3939	21.4096	77409472.0
2012-03-30 16:00:00	AAPL	Stock	21.4121	21.5312	21.4004	21.4214	23099496.0
2012-03-30 16:30:00	AAPL	Stock	21.4196	21.4457	21.4097	21.4196	974680.0
2012-03-30 17:00:00	AAPL	Stock	21.4214	21.4214	21.4118	21.4125	344904.0
2012-03-30 17:30:00	AAPL	Stock	21.4168	21.445	21.4111	21.445	748076.0
2012-03-30 18:00:00	AAPL	Stock	21.4457	21.455	21.4329	21.4511	491764.0
2012-03-30 18:30:00	AAPL	Stock	21.4536	21.4875	21.4393	21.4793	843640.0
2012-03-30 19:00:00	AAPL	Stock	21.4793	21.4882	21.47	21.4857	507864.0
2012-03-30 19:30:00	AAPL	Stock	21.48	21.48	21.4668	21.475	174132.0
2012-03-30 07:30:00	MSFT	Stock	32.28	32.28	32.1	32.25	15953.0
2012-03-30 08:00:00	MSFT	Stock	32.25	32.38	32.2	32.35	19813.0
2012-03-30 08:30:00	MSFT	Stock	32.34	32.4	32.34	32.34	5800.0
2012-03-30 09:00:00	MSFT	Stock	32.32	32.42	32.32	32.4	10098.0
2012-03-30 09:30:00	MSFT	Stock	32.4	32.41	32.14	32.15	2591367.0
2012-03-30 10:00:00	MSFT	Stock	32.143	32.23	32.14	32.175	1727387.0
2012-03-30 10:30:00	MSFT	Stock	32.175	32.189	32.04	32.13	2175307.0
2012-03-30 11:00:00	MSFT	Stock	32.135	32.3	32.125	32.29	1361393.0
2012-03-30 11:30:00	MSFT	Stock	32.29	32.4	32.29	32.35	2248706.0
2012-03-30 12:00:00	MSFT	Stock	32.345	32.36	32.28	32.32	1744951.0
2012-03-30 12:30:00	MSFT	Stock	32.32	32.34	32.28	32.28	1832921.0
2012-03-30 13:00:00	MSFT	Stock	32.29	32.3	32.27	32.298	1027232.0
2012-03-30 13:30:00	MSFT	Stock	32.29	32.31	32.24	32.245	1484991.0
2012-03-30 14:00:00	MSFT	Stock	32.25	32.31	32.24	32.286	1245845.0
2012-03-30 14:30:00	MSFT	Stock	32.285	32.3	32.22	32.22	1005043.0
2012-03-30 15:00:00	MSFT	Stock	32.23	32.24	32.12	32.185	2221986.0
2012-03-30 15:30:00	MSFT	Stock	32.185	32.27	32.18	32.24	5098512.0
2012-03-30 16:00:00	MSFT	Stock	32.24	32.3	32.2	32.26	5437555.0

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

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