PREVIEW / stock_30min / 2012-11-30

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-30.parquet
  size:    1.4 MB
  rows:    75,300
  symbols: 3,483

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-11-30 04:00:00	AAPL	Stock	21.0014	21.0375	21.0014	21.0357	31780.0
2012-11-30 04:30:00	AAPL	Stock	21.0357	21.0625	21.0357	21.0625	25200.0
2012-11-30 05:00:00	AAPL	Stock	21.045	21.045	21.045	21.045	5600.0
2012-11-30 05:30:00	AAPL	Stock	21.0536	21.0536	21.0536	21.0536	4200.0
2012-11-30 06:00:00	AAPL	Stock	21.0636	21.0636	21.0357	21.0357	32564.0
2012-11-30 06:30:00	AAPL	Stock	21.0596	21.0604	21.0429	21.0429	14000.0
2012-11-30 07:00:00	AAPL	Stock	21.0411	21.0643	21.0261	21.0643	443156.0
2012-11-30 07:30:00	AAPL	Stock	21.0539	21.0964	21.0454	21.0739	334796.0
2012-11-30 08:00:00	AAPL	Stock	21.0721	21.0893	20.9518	21.0068	1127476.0
2012-11-30 08:30:00	AAPL	Stock	21.0175	21.0193	20.9579	20.9664	788452.0
2012-11-30 09:00:00	AAPL	Stock	20.9643	20.9696	20.9254	20.9457	1317848.0
2012-11-30 09:30:00	AAPL	Stock	20.9507	21.0143	20.8807	20.9436	50166536.0
2012-11-30 10:00:00	AAPL	Stock	20.9393	20.9839	20.9221	20.9414	27766844.0
2012-11-30 10:30:00	AAPL	Stock	20.9432	20.9571	20.8518	20.905	28127148.0
2012-11-30 11:00:00	AAPL	Stock	20.9078	20.9189	20.8429	20.8668	21391664.0
2012-11-30 11:30:00	AAPL	Stock	20.8679	20.8993	20.8296	20.8911	18361532.0
2012-11-30 12:00:00	AAPL	Stock	20.8921	20.9164	20.8668	20.895	13092884.0
2012-11-30 12:30:00	AAPL	Stock	20.8921	20.9025	20.81	20.8409	21103180.0
2012-11-30 13:00:00	AAPL	Stock	20.8443	20.8914	20.8218	20.8754	13894692.0
2012-11-30 13:30:00	AAPL	Stock	20.8707	20.8914	20.8479	20.8865	10782800.0
2012-11-30 14:00:00	AAPL	Stock	20.8868	20.9157	20.8789	20.9015	14814520.0
2012-11-30 14:30:00	AAPL	Stock	20.9007	20.9036	20.8393	20.8479	12732300.0
2012-11-30 15:00:00	AAPL	Stock	20.8432	20.88	20.8214	20.8381	25704644.0
2012-11-30 15:30:00	AAPL	Stock	20.8432	20.9021	20.8336	20.8921	51399936.0
2012-11-30 16:00:00	AAPL	Stock	20.8929	20.9133	20.8819	20.9008	25821404.0
2012-11-30 16:30:00	AAPL	Stock	20.8964	20.9551	20.8401	20.9043	3172092.0
2012-11-30 17:00:00	AAPL	Stock	20.8989	20.9018	20.8921	20.8993	877268.0
2012-11-30 17:30:00	AAPL	Stock	20.8982	20.9029	20.8968	20.9029	28224.0
2012-11-30 18:00:00	AAPL	Stock	20.9032	20.9089	20.9007	20.9068	173180.0
2012-11-30 18:30:00	AAPL	Stock	20.91	20.9196	20.91	20.9175	193564.0
2012-11-30 19:00:00	AAPL	Stock	20.9168	20.9375	20.9146	20.9339	240604.0
2012-11-30 19:30:00	AAPL	Stock	20.9286	20.9425	20.9286	20.9393	147280.0
2012-11-30 04:30:00	MSFT	Stock	26.9	26.9	26.9	26.9	100.0
2012-11-30 07:00:00	MSFT	Stock	27.0	27.03	26.95	27.03	8870.0
2012-11-30 07:30:00	MSFT	Stock	27.05	27.05	27.0	27.0	8080.0
2012-11-30 08:00:00	MSFT	Stock	27.0	27.05	27.0	27.0	16208.0
2012-11-30 08:30:00	MSFT	Stock	27.0	27.02	26.95	27.0	77811.0
2012-11-30 09:00:00	MSFT	Stock	27.0	27.1	26.98	27.09	80223.0
2012-11-30 09:30:00	MSFT	Stock	27.04	27.13	26.81	26.815	5771579.0
2012-11-30 10:00:00	MSFT	Stock	26.815	26.85	26.71	26.75	8859934.0
2012-11-30 10:30:00	MSFT	Stock	26.75	26.77	26.66	26.735	6332386.0
2012-11-30 11:00:00	MSFT	Stock	26.735	26.75	26.64	26.68	3663950.0
2012-11-30 11:30:00	MSFT	Stock	26.69	26.7	26.59	26.605	5074581.0
2012-11-30 12:00:00	MSFT	Stock	26.61	26.63	26.57	26.59	3548897.0
2012-11-30 12:30:00	MSFT	Stock	26.59	26.62	26.49	26.545	5916801.0
2012-11-30 13:00:00	MSFT	Stock	26.548	26.57	26.5	26.555	3938308.0
2012-11-30 13:30:00	MSFT	Stock	26.553	26.59	26.525	26.57	2815727.0
2012-11-30 14:00:00	MSFT	Stock	26.565	26.64	26.56	26.635	3739174.0
2012-11-30 14:30:00	MSFT	Stock	26.64	26.64	26.54	26.54	2476687.0
2012-11-30 15:00:00	MSFT	Stock	26.55	26.58	26.52	26.55	4884491.0

> showing 50 of 75,300 rows — these rows as CSV

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