PREVIEW / stock_30min / 2018-01-08

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-08.parquet
  size:    1.7 MB
  rows:    86,539
  symbols: 2,909

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
2018-01-08 04:30:00	AAPL	Stock	43.775	43.775	43.775	43.775	1888.0
2018-01-08 06:30:00	AAPL	Stock	43.825	43.825	43.725	43.725	2884.0
2018-01-08 07:00:00	AAPL	Stock	43.7725	43.7725	43.7075	43.7075	51328.0
2018-01-08 07:30:00	AAPL	Stock	43.72	43.7225	43.6875	43.7125	33472.0
2018-01-08 08:00:00	AAPL	Stock	43.755	43.77	43.6325	43.65	104604.0
2018-01-08 08:30:00	AAPL	Stock	43.65	43.6875	43.6275	43.6875	90340.0
2018-01-08 09:00:00	AAPL	Stock	43.6875	43.6875	43.5775	43.59	177456.0
2018-01-08 09:30:00	AAPL	Stock	43.5775	43.9025	43.5675	43.75	12083644.0
2018-01-08 10:00:00	AAPL	Stock	43.75	43.75	43.6175	43.6962	6292388.0
2018-01-08 10:30:00	AAPL	Stock	43.695	43.7738	43.6645	43.7125	5330636.0
2018-01-08 11:00:00	AAPL	Stock	43.7138	43.785	43.695	43.7325	4051596.0
2018-01-08 11:30:00	AAPL	Stock	43.7325	43.76	43.7115	43.725	2703476.0
2018-01-08 12:00:00	AAPL	Stock	43.7275	43.7388	43.7025	43.7075	2246988.0
2018-01-08 12:30:00	AAPL	Stock	43.7088	43.71	43.6175	43.6325	3199848.0
2018-01-08 13:00:00	AAPL	Stock	43.635	43.7325	43.635	43.7088	2494852.0
2018-01-08 13:30:00	AAPL	Stock	43.7075	43.7162	43.6625	43.675	2123776.0
2018-01-08 14:00:00	AAPL	Stock	43.675	43.6775	43.6425	43.66	2409064.0
2018-01-08 14:30:00	AAPL	Stock	43.6575	43.66	43.57	43.61	3453692.0
2018-01-08 15:00:00	AAPL	Stock	43.61	43.6175	43.5175	43.52	5077256.0
2018-01-08 15:30:00	AAPL	Stock	43.5175	43.64	43.4825	43.585	10747072.0
2018-01-08 16:00:00	AAPL	Stock	43.6	43.6	43.55	43.56	9826288.0
2018-01-08 16:30:00	AAPL	Stock	43.56	43.56	43.5475	43.5475	53164.0
2018-01-08 17:00:00	AAPL	Stock	43.5875	43.6475	43.555	43.6125	132020.0
2018-01-08 17:30:00	AAPL	Stock	43.62	43.6225	43.61	43.61	20892.0
2018-01-08 18:00:00	AAPL	Stock	43.625	43.6375	43.6175	43.6275	12484.0
2018-01-08 18:30:00	AAPL	Stock	43.6275	43.6275	43.6125	43.6275	15180.0
2018-01-08 19:00:00	AAPL	Stock	43.625	43.6425	43.6225	43.63	29800.0
2018-01-08 19:30:00	AAPL	Stock	43.6425	43.7	43.6275	43.7	64352.0
2018-01-08 05:30:00	MSFT	Stock	88.44	88.67	88.44	88.67	4301.0
2018-01-08 06:00:00	MSFT	Stock	88.55	88.6	88.55	88.6	200.0
2018-01-08 06:30:00	MSFT	Stock	88.6	88.6	88.5	88.5	1100.0
2018-01-08 07:00:00	MSFT	Stock	88.35	88.45	88.35	88.35	7117.0
2018-01-08 07:30:00	MSFT	Stock	88.3	88.45	88.23	88.34	8158.0
2018-01-08 08:00:00	MSFT	Stock	88.3	88.51	88.21	88.39	16998.0
2018-01-08 08:30:00	MSFT	Stock	88.38	88.45	88.3	88.31	12763.0
2018-01-08 09:00:00	MSFT	Stock	88.37	88.51	88.1	88.16	20326.0
2018-01-08 09:30:00	MSFT	Stock	88.16	88.31	87.62	87.63	2428241.0
2018-01-08 10:00:00	MSFT	Stock	87.635	87.92	87.605	87.91	1416533.0
2018-01-08 10:30:00	MSFT	Stock	87.92	88.32	87.88	88.31	1241780.0
2018-01-08 11:00:00	MSFT	Stock	88.31	88.58	88.3	88.52	948465.0
2018-01-08 11:30:00	MSFT	Stock	88.526	88.575	88.42	88.45	679180.0
2018-01-08 12:00:00	MSFT	Stock	88.45	88.485	88.35	88.399	575749.0
2018-01-08 12:30:00	MSFT	Stock	88.395	88.395	88.25	88.355	563685.0
2018-01-08 13:00:00	MSFT	Stock	88.36	88.395	88.26	88.315	519196.0
2018-01-08 13:30:00	MSFT	Stock	88.315	88.34	88.26	88.305	439035.0
2018-01-08 14:00:00	MSFT	Stock	88.31	88.31	88.24	88.255	502135.0
2018-01-08 14:30:00	MSFT	Stock	88.26	88.29	88.15	88.195	607222.0
2018-01-08 15:00:00	MSFT	Stock	88.195	88.3	88.15	88.25	886923.0
2018-01-08 15:30:00	MSFT	Stock	88.255	88.44	88.18	88.22	2446466.0
2018-01-08 16:00:00	MSFT	Stock	88.28	88.35	88.18	88.24	5734004.0

> showing 50 of 86,539 rows — these rows as CSV

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