PREVIEW / stock_30min / 2014-12-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-03.parquet
  size:    1.6 MB
  rows:    83,546
  symbols: 3,565

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
2014-12-03 04:00:00	AAPL	Stock	28.6475	28.7625	28.6175	28.645	12220.0
2014-12-03 04:30:00	AAPL	Stock	28.645	28.69	28.625	28.69	35068.0
2014-12-03 05:00:00	AAPL	Stock	28.6775	28.6775	28.6775	28.6775	4880.0
2014-12-03 05:30:00	AAPL	Stock	28.64	28.64	28.6025	28.6025	4400.0
2014-12-03 06:00:00	AAPL	Stock	28.5825	28.595	28.51	28.5475	35920.0
2014-12-03 06:30:00	AAPL	Stock	28.5275	28.58	28.515	28.57	21828.0
2014-12-03 07:00:00	AAPL	Stock	28.57	28.595	28.5375	28.5825	109968.0
2014-12-03 07:30:00	AAPL	Stock	28.5825	28.6125	28.565	28.5925	64120.0
2014-12-03 08:00:00	AAPL	Stock	28.6	28.6575	28.5375	28.59	329056.0
2014-12-03 08:30:00	AAPL	Stock	28.59	28.6375	28.555	28.625	190668.0
2014-12-03 09:00:00	AAPL	Stock	28.63	28.9875	28.63	28.9425	1645296.0
2014-12-03 09:30:00	AAPL	Stock	28.94	29.0875	28.84	28.955	33465896.0
2014-12-03 10:00:00	AAPL	Stock	28.955	28.98	28.805	28.84	18722468.0
2014-12-03 10:30:00	AAPL	Stock	28.8275	28.9375	28.7775	28.8125	12556092.0
2014-12-03 11:00:00	AAPL	Stock	28.81	28.9625	28.81	28.9162	12017236.0
2014-12-03 11:30:00	AAPL	Stock	28.9175	28.975	28.8925	28.915	6813856.0
2014-12-03 12:00:00	AAPL	Stock	28.9165	28.9325	28.8375	28.8525	5372324.0
2014-12-03 12:30:00	AAPL	Stock	28.85	28.9225	28.82	28.9125	5097448.0
2014-12-03 13:00:00	AAPL	Stock	28.9125	28.935	28.86	28.9012	4688260.0
2014-12-03 13:30:00	AAPL	Stock	28.9	28.96	28.8902	28.955	5046116.0
2014-12-03 14:00:00	AAPL	Stock	28.955	28.9725	28.925	28.96	5425532.0
2014-12-03 14:30:00	AAPL	Stock	28.9578	28.9675	28.9175	28.9525	4647404.0
2014-12-03 15:00:00	AAPL	Stock	28.9525	29.04	28.94	29.04	9134636.0
2014-12-03 15:30:00	AAPL	Stock	29.0398	29.0525	28.9825	28.9825	14768356.0
2014-12-03 16:00:00	AAPL	Stock	28.9825	28.995	28.6048	28.9882	18860380.0
2014-12-03 16:30:00	AAPL	Stock	28.975	28.9825	28.9025	28.9675	1097972.0
2014-12-03 17:00:00	AAPL	Stock	28.9675	28.9875	28.9322	28.9322	215724.0
2014-12-03 17:30:00	AAPL	Stock	28.9925	28.995	28.98	28.9922	134200.0
2014-12-03 18:00:00	AAPL	Stock	28.9875	28.9925	28.975	28.9752	50404.0
2014-12-03 18:30:00	AAPL	Stock	28.98	28.9875	28.975	28.9875	37364.0
2014-12-03 19:00:00	AAPL	Stock	28.99	29.025	28.99	29.0225	98152.0
2014-12-03 19:30:00	AAPL	Stock	29.01	29.0225	29.005	29.005	56576.0
2014-12-03 05:00:00	MSFT	Stock	48.52	48.52	48.48	48.48	700.0
2014-12-03 05:30:00	MSFT	Stock	48.49	48.49	48.48	48.48	500.0
2014-12-03 07:00:00	MSFT	Stock	48.5	48.5	48.5	48.5	200.0
2014-12-03 07:30:00	MSFT	Stock	48.51	48.52	48.51	48.52	800.0
2014-12-03 08:00:00	MSFT	Stock	48.51	48.52	48.47	48.47	3224.0
2014-12-03 08:30:00	MSFT	Stock	48.35	48.42	48.35	48.42	651.0
2014-12-03 09:00:00	MSFT	Stock	48.45	48.5	48.4	48.48	5600.0
2014-12-03 09:30:00	MSFT	Stock	48.48	48.5	48.06	48.17	2681052.0
2014-12-03 10:00:00	MSFT	Stock	48.17	48.2	47.805	47.97	2195526.0
2014-12-03 10:30:00	MSFT	Stock	47.965	48.24	47.965	48.166	1188769.0
2014-12-03 11:00:00	MSFT	Stock	48.16	48.28	48.11	48.23	982919.0
2014-12-03 11:30:00	MSFT	Stock	48.23	48.32	48.08	48.147	946700.0
2014-12-03 12:00:00	MSFT	Stock	48.145	48.2	48.08	48.15	619981.0
2014-12-03 12:30:00	MSFT	Stock	48.14	48.15	48.065	48.1	504024.0
2014-12-03 13:00:00	MSFT	Stock	48.1	48.25	48.1	48.235	523947.0
2014-12-03 13:30:00	MSFT	Stock	48.235	48.33	48.22	48.275	658971.0
2014-12-03 14:00:00	MSFT	Stock	48.275	48.29	48.22	48.225	600908.0
2014-12-03 14:30:00	MSFT	Stock	48.22	48.26	48.2	48.235	497824.0

> showing 50 of 83,546 rows — these rows as CSV

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