PREVIEW / stock_30min / 2017-06-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-13.parquet
  size:    1.6 MB
  rows:    80,886
  symbols: 3,038

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-06-13 04:00:00	AAPL	Stock	36.7125	36.7125	36.575	36.575	16344.0
2017-06-13 04:30:00	AAPL	Stock	36.5775	36.6725	36.575	36.6725	15624.0
2017-06-13 05:00:00	AAPL	Stock	36.65	36.67	36.625	36.625	7520.0
2017-06-13 05:30:00	AAPL	Stock	36.56	36.6625	36.56	36.6625	27100.0
2017-06-13 06:00:00	AAPL	Stock	36.66	36.7075	36.605	36.7075	5480.0
2017-06-13 06:30:00	AAPL	Stock	36.68	36.68	36.6125	36.6125	22164.0
2017-06-13 07:00:00	AAPL	Stock	36.6175	36.675	36.6125	36.6325	73328.0
2017-06-13 07:30:00	AAPL	Stock	36.685	36.7975	36.685	36.75	134764.0
2017-06-13 08:00:00	AAPL	Stock	36.7275	36.7975	36.6175	36.725	553556.0
2017-06-13 08:30:00	AAPL	Stock	36.74	36.8	36.72	36.7875	402668.0
2017-06-13 09:00:00	AAPL	Stock	36.79	36.85	36.7375	36.775	475772.0
2017-06-13 09:30:00	AAPL	Stock	36.79	36.8625	36.5775	36.6815	23658632.0
2017-06-13 10:00:00	AAPL	Stock	36.68	36.68	36.48	36.56	14332000.0
2017-06-13 10:30:00	AAPL	Stock	36.56	36.6475	36.3	36.315	11590580.0
2017-06-13 11:00:00	AAPL	Stock	36.3125	36.5075	36.2875	36.4925	7394544.0
2017-06-13 11:30:00	AAPL	Stock	36.495	36.535	36.385	36.5275	5679244.0
2017-06-13 12:00:00	AAPL	Stock	36.5275	36.595	36.5175	36.53	4566804.0
2017-06-13 12:30:00	AAPL	Stock	36.53	36.6375	36.5225	36.5838	4259016.0
2017-06-13 13:00:00	AAPL	Stock	36.5825	36.605	36.54	36.5875	3235336.0
2017-06-13 13:30:00	AAPL	Stock	36.5925	36.5925	36.445	36.54	4582144.0
2017-06-13 14:00:00	AAPL	Stock	36.5388	36.555	36.4825	36.55	4091292.0
2017-06-13 14:30:00	AAPL	Stock	36.5488	36.62	36.5225	36.5975	3904008.0
2017-06-13 15:00:00	AAPL	Stock	36.5995	36.6528	36.565	36.651	4118908.0
2017-06-13 15:30:00	AAPL	Stock	36.65	36.725	36.59	36.6475	11321428.0
2017-06-13 16:00:00	AAPL	Stock	36.6475	36.655	36.375	36.65	11122756.0
2017-06-13 16:30:00	AAPL	Stock	36.655	36.6925	36.6475	36.68	44240.0
2017-06-13 17:00:00	AAPL	Stock	36.6775	36.705	36.6775	36.7	26312.0
2017-06-13 17:30:00	AAPL	Stock	36.7	36.7225	36.695	36.72	39280.0
2017-06-13 18:00:00	AAPL	Stock	36.72	36.735	36.7125	36.7175	25612.0
2017-06-13 18:30:00	AAPL	Stock	36.7325	36.7325	36.705	36.7225	18148.0
2017-06-13 19:00:00	AAPL	Stock	36.715	36.7225	36.7025	36.7225	21372.0
2017-06-13 19:30:00	AAPL	Stock	36.7125	36.725	36.7125	36.725	12320.0
2017-06-13 04:00:00	MSFT	Stock	69.98	70.0	69.98	70.0	1100.0
2017-06-13 07:00:00	MSFT	Stock	69.98	69.98	69.98	69.98	500.0
2017-06-13 07:30:00	MSFT	Stock	69.98	70.07	69.98	70.06	14748.0
2017-06-13 08:00:00	MSFT	Stock	70.0	70.15	70.0	70.1	4563.0
2017-06-13 08:30:00	MSFT	Stock	70.15	70.2	70.07	70.07	5625.0
2017-06-13 09:00:00	MSFT	Stock	70.15	70.2	69.94	70.06	35603.0
2017-06-13 09:30:00	MSFT	Stock	70.02	70.62	69.96	70.62	3643517.0
2017-06-13 10:00:00	MSFT	Stock	70.61	70.62	70.4	70.488	2486801.0
2017-06-13 10:30:00	MSFT	Stock	70.49	70.66	70.14	70.15	1871392.0
2017-06-13 11:00:00	MSFT	Stock	70.15	70.393	70.021	70.36	1533826.0
2017-06-13 11:30:00	MSFT	Stock	70.36	70.44	70.22	70.38	1117653.0
2017-06-13 12:00:00	MSFT	Stock	70.375	70.52	70.32	70.42	810917.0
2017-06-13 12:30:00	MSFT	Stock	70.42	70.77	70.41	70.73	887407.0
2017-06-13 13:00:00	MSFT	Stock	70.73	70.8	70.62	70.8	955538.0
2017-06-13 13:30:00	MSFT	Stock	70.8	70.82	70.59	70.69	1017782.0
2017-06-13 14:00:00	MSFT	Stock	70.68	70.78	70.655	70.725	1235657.0
2017-06-13 14:30:00	MSFT	Stock	70.73	70.77	70.635	70.69	572215.0
2017-06-13 15:00:00	MSFT	Stock	70.69	70.73	70.59	70.714	1138590.0

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

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