PREVIEW / stock_30min / 2017-07-20

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-20.parquet
  size:    1.6 MB
  rows:    80,639
  symbols: 2,978

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-07-20 04:00:00	AAPL	Stock	37.7625	37.7625	37.7275	37.7275	2160.0
2017-07-20 05:00:00	AAPL	Stock	37.755	37.755	37.65	37.65	2728.0
2017-07-20 06:00:00	AAPL	Stock	37.675	37.745	37.675	37.745	800.0
2017-07-20 06:30:00	AAPL	Stock	37.7375	37.7375	37.7375	37.7375	1200.0
2017-07-20 07:00:00	AAPL	Stock	37.7375	37.7375	37.7275	37.7275	1000.0
2017-07-20 07:30:00	AAPL	Stock	37.775	37.8475	37.7725	37.8225	25976.0
2017-07-20 08:00:00	AAPL	Stock	37.795	37.875	37.795	37.85	83660.0
2017-07-20 08:30:00	AAPL	Stock	37.85	37.8625	37.795	37.805	74192.0
2017-07-20 09:00:00	AAPL	Stock	37.82	37.92	37.795	37.875	135820.0
2017-07-20 09:30:00	AAPL	Stock	37.8625	37.935	37.725	37.7775	10136592.0
2017-07-20 10:00:00	AAPL	Stock	37.7775	37.785	37.6125	37.7398	5993384.0
2017-07-20 10:30:00	AAPL	Stock	37.74	37.771	37.5475	37.635	6396504.0
2017-07-20 11:00:00	AAPL	Stock	37.6305	37.71	37.6225	37.6375	2845676.0
2017-07-20 11:30:00	AAPL	Stock	37.6358	37.6975	37.6075	37.675	2972808.0
2017-07-20 12:00:00	AAPL	Stock	37.6735	37.7642	37.67	37.7388	1942356.0
2017-07-20 12:30:00	AAPL	Stock	37.74	37.74	37.685	37.6925	1485952.0
2017-07-20 13:00:00	AAPL	Stock	37.6938	37.7	37.625	37.6925	1965172.0
2017-07-20 13:30:00	AAPL	Stock	37.6932	37.73	37.69	37.729	1459096.0
2017-07-20 14:00:00	AAPL	Stock	37.7275	37.7275	37.6725	37.68	1766340.0
2017-07-20 14:30:00	AAPL	Stock	37.68	37.68	37.6075	37.64	3359312.0
2017-07-20 15:00:00	AAPL	Stock	37.6425	37.71	37.64	37.69	3127620.0
2017-07-20 15:30:00	AAPL	Stock	37.69	37.745	37.585	37.5875	10124644.0
2017-07-20 16:00:00	AAPL	Stock	37.585	37.63	37.5525	37.6	5553384.0
2017-07-20 16:30:00	AAPL	Stock	37.6	37.625	37.585	37.605	137452.0
2017-07-20 17:00:00	AAPL	Stock	37.6025	37.6625	37.6	37.6625	47916.0
2017-07-20 17:30:00	AAPL	Stock	37.6375	37.65	37.635	37.6375	12952.0
2017-07-20 18:00:00	AAPL	Stock	37.6275	37.6275	37.5925	37.595	33716.0
2017-07-20 18:30:00	AAPL	Stock	37.5975	37.5975	37.5925	37.5925	17000.0
2017-07-20 19:00:00	AAPL	Stock	37.5925	37.5925	37.5925	37.5925	6080.0
2017-07-20 19:30:00	AAPL	Stock	37.5975	37.61	37.5925	37.5925	26300.0
2017-07-20 04:30:00	MSFT	Stock	74.05	74.05	74.05	74.05	200.0
2017-07-20 05:00:00	MSFT	Stock	74.05	74.05	74.0	74.0	702.0
2017-07-20 06:00:00	MSFT	Stock	74.11	74.11	74.1	74.1	899.0
2017-07-20 06:30:00	MSFT	Stock	74.08	74.08	74.08	74.08	493.0
2017-07-20 07:00:00	MSFT	Stock	74.08	74.1	74.01	74.1	4460.0
2017-07-20 07:30:00	MSFT	Stock	74.09	74.12	74.08	74.12	2311.0
2017-07-20 08:00:00	MSFT	Stock	74.1	74.25	74.1	74.25	29198.0
2017-07-20 08:30:00	MSFT	Stock	74.21	74.24	74.08	74.11	41085.0
2017-07-20 09:00:00	MSFT	Stock	74.11	74.34	74.11	74.2	23911.0
2017-07-20 09:30:00	MSFT	Stock	74.17	74.24	73.28	73.63	4679623.0
2017-07-20 10:00:00	MSFT	Stock	73.62	73.92	73.5	73.63	2977909.0
2017-07-20 10:30:00	MSFT	Stock	73.63	73.85	73.41	73.835	1825335.0
2017-07-20 11:00:00	MSFT	Stock	73.836	74.13	73.82	73.985	1616213.0
2017-07-20 11:30:00	MSFT	Stock	73.985	73.99	73.84	73.925	1096155.0
2017-07-20 12:00:00	MSFT	Stock	73.92	73.95	73.84	73.88	1061128.0
2017-07-20 12:30:00	MSFT	Stock	73.875	73.975	73.86	73.88	1051815.0
2017-07-20 13:00:00	MSFT	Stock	73.88	73.938	73.79	73.91	1148613.0
2017-07-20 13:30:00	MSFT	Stock	73.915	74.07	73.895	73.966	1316905.0
2017-07-20 14:00:00	MSFT	Stock	73.96	74.01	73.78	73.78	1521258.0
2017-07-20 14:30:00	MSFT	Stock	73.78	73.86	73.62	73.8	1962687.0

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

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