PREVIEW / stock_30min / 2015-09-01

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-01.parquet
  size:    1.6 MB
  rows:    84,037
  symbols: 3,473

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
2015-09-01 04:00:00	AAPL	Stock	27.8625	27.8625	27.425	27.52	62336.0
2015-09-01 04:30:00	AAPL	Stock	27.45	27.45	27.4	27.445	30380.0
2015-09-01 05:00:00	AAPL	Stock	27.445	27.62	27.445	27.545	29880.0
2015-09-01 05:30:00	AAPL	Stock	27.5425	27.575	27.4975	27.575	65160.0
2015-09-01 06:00:00	AAPL	Stock	27.52	27.5875	27.5	27.5875	99624.0
2015-09-01 06:30:00	AAPL	Stock	27.5925	27.62	27.53	27.5575	52036.0
2015-09-01 07:00:00	AAPL	Stock	27.5625	27.67	27.55	27.65	457508.0
2015-09-01 07:30:00	AAPL	Stock	27.6775	27.6775	27.575	27.6075	350364.0
2015-09-01 08:00:00	AAPL	Stock	27.6	27.6725	27.5375	27.56	1149620.0
2015-09-01 08:30:00	AAPL	Stock	27.56	27.5925	27.42	27.4375	1316460.0
2015-09-01 09:00:00	AAPL	Stock	27.4375	27.5425	27.405	27.5375	1888212.0
2015-09-01 09:30:00	AAPL	Stock	27.545	27.97	27.5175	27.715	38099500.0
2015-09-01 10:00:00	AAPL	Stock	27.7125	27.7925	27.57	27.7725	24093648.0
2015-09-01 10:30:00	AAPL	Stock	27.7725	27.925	27.6375	27.735	19391732.0
2015-09-01 11:00:00	AAPL	Stock	27.7375	27.85	27.6675	27.745	14224968.0
2015-09-01 11:30:00	AAPL	Stock	27.745	27.845	27.705	27.78	11022512.0
2015-09-01 12:00:00	AAPL	Stock	27.78	27.825	27.615	27.625	10908492.0
2015-09-01 12:30:00	AAPL	Stock	27.6275	27.6875	27.4375	27.513	19522952.0
2015-09-01 13:00:00	AAPL	Stock	27.515	27.61	27.4525	27.5275	13300020.0
2015-09-01 13:30:00	AAPL	Stock	27.5325	27.6025	27.4762	27.5575	10317856.0
2015-09-01 14:00:00	AAPL	Stock	27.5528	27.56	27.28	27.34	15397932.0
2015-09-01 14:30:00	AAPL	Stock	27.3425	27.4925	27.22	27.2375	18067604.0
2015-09-01 15:00:00	AAPL	Stock	27.2375	27.2825	27.0325	27.07	24812924.0
2015-09-01 15:30:00	AAPL	Stock	27.07	27.1588	26.84	26.9325	48420584.0
2015-09-01 16:00:00	AAPL	Stock	26.93	27.7265	26.93	27.0875	11795380.0
2015-09-01 16:30:00	AAPL	Stock	27.0825	27.0925	26.965	26.975	229776.0
2015-09-01 17:00:00	AAPL	Stock	26.9825	26.985	26.8775	26.885	228464.0
2015-09-01 17:30:00	AAPL	Stock	26.885	26.9125	26.7975	26.82	298480.0
2015-09-01 18:00:00	AAPL	Stock	26.82	26.875	26.7775	26.795	183732.0
2015-09-01 18:30:00	AAPL	Stock	26.795	26.92	26.795	26.9	150404.0
2015-09-01 19:00:00	AAPL	Stock	26.9	26.9125	26.8875	26.9	39228.0
2015-09-01 19:30:00	AAPL	Stock	26.9	27.125	26.9	27.1125	270292.0
2015-09-01 04:00:00	MSFT	Stock	42.49	42.49	42.46	42.46	200.0
2015-09-01 04:30:00	MSFT	Stock	42.4	42.4	42.3	42.3	7570.0
2015-09-01 05:00:00	MSFT	Stock	42.3	42.5	42.3	42.48	11037.0
2015-09-01 05:30:00	MSFT	Stock	42.4	42.44	42.4	42.41	1400.0
2015-09-01 06:00:00	MSFT	Stock	42.42	42.55	42.42	42.55	8917.0
2015-09-01 06:30:00	MSFT	Stock	42.55	42.55	42.4	42.45	26674.0
2015-09-01 07:00:00	MSFT	Stock	42.45	42.67	42.45	42.67	2499.0
2015-09-01 07:30:00	MSFT	Stock	42.6	42.67	42.56	42.56	1200.0
2015-09-01 08:00:00	MSFT	Stock	42.65	43.02	42.5	42.65	45813.0
2015-09-01 08:30:00	MSFT	Stock	42.58	42.58	42.4	42.49	12258.0
2015-09-01 09:00:00	MSFT	Stock	42.41	42.5	42.19	42.19	53288.0
2015-09-01 09:30:00	MSFT	Stock	42.17	42.541	42.0	42.315	5867476.0
2015-09-01 10:00:00	MSFT	Stock	42.31	42.415	42.18	42.41	3896401.0
2015-09-01 10:30:00	MSFT	Stock	42.415	42.59	42.2	42.345	4429332.0
2015-09-01 11:00:00	MSFT	Stock	42.35	42.48	42.16	42.32	1818157.0
2015-09-01 11:30:00	MSFT	Stock	42.32	42.427	42.18	42.22	2179822.0
2015-09-01 12:00:00	MSFT	Stock	42.22	42.275	42.03	42.03	1671164.0
2015-09-01 12:30:00	MSFT	Stock	42.03	42.08	41.85	41.866	2344772.0

> showing 50 of 84,037 rows — these rows as CSV

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