PREVIEW / stock_30min / 2017-01-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-13.parquet
  size:    1.6 MB
  rows:    80,100
  symbols: 3,137

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
2017-01-13 06:30:00	AAPL	Stock	29.795	29.795	29.7775	29.7775	4400.0
2017-01-13 07:00:00	AAPL	Stock	29.795	29.81	29.795	29.805	3596.0
2017-01-13 07:30:00	AAPL	Stock	29.8025	29.8125	29.8	29.8	8944.0
2017-01-13 08:00:00	AAPL	Stock	29.8	29.835	29.7875	29.7975	93084.0
2017-01-13 08:30:00	AAPL	Stock	29.7875	29.805	29.7775	29.78	48268.0
2017-01-13 09:00:00	AAPL	Stock	29.7875	29.8075	29.745	29.78	161576.0
2017-01-13 09:30:00	AAPL	Stock	29.7775	29.905	29.775	29.806	16898352.0
2017-01-13 10:00:00	AAPL	Stock	29.805	29.8425	29.7575	29.78	6442920.0
2017-01-13 10:30:00	AAPL	Stock	29.7795	29.7875	29.715	29.7442	6761808.0
2017-01-13 11:00:00	AAPL	Stock	29.745	29.7775	29.72	29.7688	4820760.0
2017-01-13 11:30:00	AAPL	Stock	29.77	29.79	29.7625	29.781	4375180.0
2017-01-13 12:00:00	AAPL	Stock	29.7825	29.7825	29.7075	29.725	4888320.0
2017-01-13 12:30:00	AAPL	Stock	29.725	29.79	29.725	29.7775	3747816.0
2017-01-13 13:00:00	AAPL	Stock	29.7775	29.7948	29.7625	29.765	3302912.0
2017-01-13 13:30:00	AAPL	Stock	29.7675	29.775	29.75	29.7525	2988236.0
2017-01-13 14:00:00	AAPL	Stock	29.7525	29.765	29.7075	29.71	4201804.0
2017-01-13 14:30:00	AAPL	Stock	29.7112	29.795	29.705	29.7605	4991276.0
2017-01-13 15:00:00	AAPL	Stock	29.761	29.7625	29.7125	29.7238	4831768.0
2017-01-13 15:30:00	AAPL	Stock	29.7238	29.7625	29.7025	29.7575	14084908.0
2017-01-13 16:00:00	AAPL	Stock	29.755	29.76	29.725	29.7525	8659560.0
2017-01-13 16:30:00	AAPL	Stock	29.7525	29.7625	29.75	29.76	310720.0
2017-01-13 17:00:00	AAPL	Stock	29.76	29.7625	29.7525	29.7525	250292.0
2017-01-13 17:30:00	AAPL	Stock	29.7525	29.755	29.7525	29.755	11444.0
2017-01-13 18:00:00	AAPL	Stock	29.755	29.76	29.755	29.76	19000.0
2017-01-13 18:30:00	AAPL	Stock	29.75	29.7625	29.75	29.75	33164.0
2017-01-13 19:00:00	AAPL	Stock	29.75	29.755	29.75	29.75	6600.0
2017-01-13 19:30:00	AAPL	Stock	29.75	29.755	29.75	29.755	31816.0
2017-01-13 07:00:00	MSFT	Stock	62.6	62.6	62.6	62.6	1520.0
2017-01-13 07:30:00	MSFT	Stock	62.72	62.72	62.72	62.72	2715.0
2017-01-13 08:00:00	MSFT	Stock	62.61	62.76	62.61	62.7	4253.0
2017-01-13 08:30:00	MSFT	Stock	62.75	62.75	62.7	62.75	2405.0
2017-01-13 09:00:00	MSFT	Stock	62.66	62.75	62.55	62.62	9168.0
2017-01-13 09:30:00	MSFT	Stock	62.62	62.865	62.35	62.59	2537999.0
2017-01-13 10:00:00	MSFT	Stock	62.59	62.62	62.445	62.475	1164527.0
2017-01-13 10:30:00	MSFT	Stock	62.48	62.63	62.47	62.595	675920.0
2017-01-13 11:00:00	MSFT	Stock	62.6	62.62	62.43	62.575	897391.0
2017-01-13 11:30:00	MSFT	Stock	62.575	62.66	62.53	62.635	636698.0
2017-01-13 12:00:00	MSFT	Stock	62.63	62.72	62.5	62.52	1097751.0
2017-01-13 12:30:00	MSFT	Stock	62.52	62.66	62.48	62.63	877336.0
2017-01-13 13:00:00	MSFT	Stock	62.64	62.675	62.58	62.594	489998.0
2017-01-13 13:30:00	MSFT	Stock	62.6	62.67	62.585	62.645	625080.0
2017-01-13 14:00:00	MSFT	Stock	62.645	62.65	62.53	62.544	804409.0
2017-01-13 14:30:00	MSFT	Stock	62.55	62.62	62.51	62.605	931225.0
2017-01-13 15:00:00	MSFT	Stock	62.605	62.62	62.53	62.53	809993.0
2017-01-13 15:30:00	MSFT	Stock	62.53	62.71	62.48	62.685	3058284.0
2017-01-13 16:00:00	MSFT	Stock	62.7	62.7	62.58	62.68	3259158.0
2017-01-13 16:30:00	MSFT	Stock	62.67	62.68	62.64	62.64	5802.0
2017-01-13 17:00:00	MSFT	Stock	62.68	62.75	62.67	62.7	55436.0
2017-01-13 18:00:00	MSFT	Stock	62.65	62.75	62.65	62.75	700.0
2017-01-13 19:30:00	MSFT	Stock	62.75	62.75	62.75	62.75	100.0

> showing 50 of 80,100 rows — these rows as CSV

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