PREVIEW / stock_30min / 2015-01-30

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-30.parquet
  size:    1.6 MB
  rows:    84,147
  symbols: 3,527

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-01-30 04:00:00	AAPL	Stock	29.725	29.725	29.65	29.6625	5488.0
2015-01-30 04:30:00	AAPL	Stock	29.605	29.605	29.5975	29.6025	21976.0
2015-01-30 05:00:00	AAPL	Stock	29.6	29.6625	29.5925	29.605	36280.0
2015-01-30 05:30:00	AAPL	Stock	29.5875	29.5875	29.525	29.585	14648.0
2015-01-30 06:00:00	AAPL	Stock	29.5875	29.6275	29.55	29.6275	28820.0
2015-01-30 06:30:00	AAPL	Stock	29.6475	29.65	29.565	29.57	24816.0
2015-01-30 07:00:00	AAPL	Stock	29.5975	29.6225	29.555	29.6125	133508.0
2015-01-30 07:30:00	AAPL	Stock	29.61	29.625	29.5825	29.59	213120.0
2015-01-30 08:00:00	AAPL	Stock	29.59	29.725	29.55	29.6	1292948.0
2015-01-30 08:30:00	AAPL	Stock	29.6	29.6425	29.5775	29.61	948212.0
2015-01-30 09:00:00	AAPL	Stock	29.6175	29.735	29.56	29.585	989528.0
2015-01-30 09:30:00	AAPL	Stock	29.6	30.0	29.5225	29.9075	60223708.0
2015-01-30 10:00:00	AAPL	Stock	29.9025	29.985	29.705	29.82	33067736.0
2015-01-30 10:30:00	AAPL	Stock	29.82	29.8775	29.7375	29.8125	20173040.0
2015-01-30 11:00:00	AAPL	Stock	29.8125	29.8475	29.6925	29.821	15493468.0
2015-01-30 11:30:00	AAPL	Stock	29.82	29.8525	29.7075	29.7925	12265088.0
2015-01-30 12:00:00	AAPL	Stock	29.7912	29.9075	29.78	29.9	11619616.0
2015-01-30 12:30:00	AAPL	Stock	29.9	29.905	29.8	29.84	10399624.0
2015-01-30 13:00:00	AAPL	Stock	29.84	29.895	29.7578	29.8075	9527476.0
2015-01-30 13:30:00	AAPL	Stock	29.81	29.8325	29.725	29.8025	9708304.0
2015-01-30 14:00:00	AAPL	Stock	29.8002	29.89	29.705	29.8875	13271576.0
2015-01-30 14:30:00	AAPL	Stock	29.89	29.91	29.72	29.7675	13961224.0
2015-01-30 15:00:00	AAPL	Stock	29.765	29.7825	29.425	29.525	27486180.0
2015-01-30 15:30:00	AAPL	Stock	29.5225	29.525	29.2125	29.29	41934312.0
2015-01-30 16:00:00	AAPL	Stock	29.29	29.855	29.258	29.3125	24023368.0
2015-01-30 16:30:00	AAPL	Stock	29.3025	29.779	29.29	29.3125	351268.0
2015-01-30 17:00:00	AAPL	Stock	29.32	29.35	29.29	29.345	322228.0
2015-01-30 17:30:00	AAPL	Stock	29.345	29.345	29.2925	29.335	95488.0
2015-01-30 18:00:00	AAPL	Stock	29.335	29.335	29.29	29.3225	86776.0
2015-01-30 18:30:00	AAPL	Stock	29.3225	29.3225	29.3075	29.3125	45416.0
2015-01-30 19:00:00	AAPL	Stock	29.3225	29.325	29.3125	29.3125	46808.0
2015-01-30 19:30:00	AAPL	Stock	29.3125	29.345	29.3125	29.3175	91344.0
2015-01-30 04:00:00	MSFT	Stock	42.11	42.11	42.01	42.06	12954.0
2015-01-30 04:30:00	MSFT	Stock	41.94	41.94	41.88	41.88	500.0
2015-01-30 05:00:00	MSFT	Stock	42.11	42.11	42.11	42.11	100.0
2015-01-30 05:30:00	MSFT	Stock	42.05	42.05	41.97	41.97	500.0
2015-01-30 06:00:00	MSFT	Stock	42.0	42.0	42.0	42.0	400.0
2015-01-30 06:30:00	MSFT	Stock	42.0	42.0	41.99	41.99	1600.0
2015-01-30 07:00:00	MSFT	Stock	42.04	42.04	41.93	41.94	6649.0
2015-01-30 07:30:00	MSFT	Stock	41.95	41.97	41.9	41.9	4543.0
2015-01-30 08:00:00	MSFT	Stock	41.94	41.97	41.75	41.77	16971.0
2015-01-30 08:30:00	MSFT	Stock	41.77	41.82	41.71	41.75	42258.0
2015-01-30 09:00:00	MSFT	Stock	41.75	41.76	41.48	41.48	101143.0
2015-01-30 09:30:00	MSFT	Stock	41.49	41.58	41.16	41.21	8662078.0
2015-01-30 10:00:00	MSFT	Stock	41.2	41.33	41.01	41.045	5823696.0
2015-01-30 10:30:00	MSFT	Stock	41.045	41.05	40.88	40.965	5197082.0
2015-01-30 11:00:00	MSFT	Stock	40.965	41.13	40.88	40.96	3420174.0
2015-01-30 11:30:00	MSFT	Stock	40.95	41.01	40.76	40.884	4298174.0
2015-01-30 12:00:00	MSFT	Stock	40.88	41.17	40.88	41.167	2978432.0
2015-01-30 12:30:00	MSFT	Stock	41.165	41.17	40.91	40.99	2727126.0

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

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