PREVIEW / stock_30min / 2019-05-28

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-28.parquet
  size:    1.7 MB
  rows:    85,195
  symbols: 2,601

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
2019-05-28 04:00:00	AAPL	Stock	44.6875	44.6975	44.5625	44.565	8544.0
2019-05-28 04:30:00	AAPL	Stock	44.595	44.6075	44.5225	44.545	16560.0
2019-05-28 05:00:00	AAPL	Stock	44.625	44.625	44.5375	44.625	11856.0
2019-05-28 05:30:00	AAPL	Stock	44.6575	44.7425	44.6575	44.725	6400.0
2019-05-28 06:00:00	AAPL	Stock	44.6425	44.6425	44.4725	44.5075	22780.0
2019-05-28 06:30:00	AAPL	Stock	44.5025	44.6	44.5	44.6	4924.0
2019-05-28 07:00:00	AAPL	Stock	44.525	44.6075	44.525	44.55	20828.0
2019-05-28 07:30:00	AAPL	Stock	44.55	44.8525	44.55	44.8	49352.0
2019-05-28 08:00:00	AAPL	Stock	44.531	44.84	44.525	44.825	189152.0
2019-05-28 08:30:00	AAPL	Stock	44.835	44.8425	44.625	44.6625	152568.0
2019-05-28 09:00:00	AAPL	Stock	44.66	44.7475	44.625	44.7275	248368.0
2019-05-28 09:30:00	AAPL	Stock	44.73	45.1475	44.685	44.8825	14065280.0
2019-05-28 10:00:00	AAPL	Stock	44.881	44.9425	44.4775	44.6738	9173120.0
2019-05-28 10:30:00	AAPL	Stock	44.6725	44.7625	44.525	44.715	6273384.0
2019-05-28 11:00:00	AAPL	Stock	44.71	44.815	44.6	44.6138	5252380.0
2019-05-28 11:30:00	AAPL	Stock	44.6125	44.8575	44.575	44.76	4863696.0
2019-05-28 12:00:00	AAPL	Stock	44.7625	44.835	44.7128	44.7908	3306508.0
2019-05-28 12:30:00	AAPL	Stock	44.7925	44.8325	44.69	44.7025	2576184.0
2019-05-28 13:00:00	AAPL	Stock	44.7025	44.7375	44.64	44.6775	2701296.0
2019-05-28 13:30:00	AAPL	Stock	44.6775	44.8225	44.6675	44.8	3566260.0
2019-05-28 14:00:00	AAPL	Stock	44.8	44.8175	44.7165	44.785	3826272.0
2019-05-28 14:30:00	AAPL	Stock	44.785	44.8825	44.6825	44.7325	4915512.0
2019-05-28 15:00:00	AAPL	Stock	44.73	44.8075	44.6778	44.73	5679388.0
2019-05-28 15:30:00	AAPL	Stock	44.73	44.7875	44.5225	44.5425	13555828.0
2019-05-28 16:00:00	AAPL	Stock	44.54	44.665	44.51	44.565	15016928.0
2019-05-28 16:30:00	AAPL	Stock	44.5625	44.575	44.5025	44.565	85428.0
2019-05-28 17:00:00	AAPL	Stock	44.55	44.575	44.55	44.55	9248.0
2019-05-28 17:30:00	AAPL	Stock	44.5575	44.6025	44.5525	44.5575	85248.0
2019-05-28 18:00:00	AAPL	Stock	44.5575	44.6	44.5575	44.575	304084.0
2019-05-28 18:30:00	AAPL	Stock	44.5875	44.625	44.5875	44.6225	9512.0
2019-05-28 19:00:00	AAPL	Stock	44.6	44.6	44.58	44.58	6680.0
2019-05-28 19:30:00	AAPL	Stock	44.575	44.62	44.5625	44.5875	19044.0
2019-05-28 04:00:00	MSFT	Stock	126.29	126.29	126.0	126.16	1257.0
2019-05-28 05:00:00	MSFT	Stock	126.25	126.25	126.25	126.25	100.0
2019-05-28 05:30:00	MSFT	Stock	126.52	126.52	126.47	126.47	1334.0
2019-05-28 06:00:00	MSFT	Stock	126.47	126.47	126.18	126.18	1567.0
2019-05-28 07:00:00	MSFT	Stock	126.25	126.43	126.22	126.31	3488.0
2019-05-28 07:30:00	MSFT	Stock	126.25	126.66	126.25	126.55	1637.0
2019-05-28 08:00:00	MSFT	Stock	126.23	126.65	126.22	126.65	5030.0
2019-05-28 08:30:00	MSFT	Stock	126.65	126.73	126.42	126.5	13061.0
2019-05-28 09:00:00	MSFT	Stock	126.47	127.0	126.47	126.93	25510.0
2019-05-28 09:30:00	MSFT	Stock	126.96	128.0	126.71	127.9	1970027.0
2019-05-28 10:00:00	MSFT	Stock	127.9	127.97	127.18	127.236	1265273.0
2019-05-28 10:30:00	MSFT	Stock	127.23	127.47	126.93	127.402	1094020.0
2019-05-28 11:00:00	MSFT	Stock	127.39	127.661	127.15	127.154	730995.0
2019-05-28 11:30:00	MSFT	Stock	127.15	127.54	127.02	127.48	786977.0
2019-05-28 12:00:00	MSFT	Stock	127.48	127.63	127.44	127.54	691767.0
2019-05-28 12:30:00	MSFT	Stock	127.54	127.63	127.34	127.42	478976.0
2019-05-28 13:00:00	MSFT	Stock	127.4	127.43	127.15	127.16	391356.0
2019-05-28 13:30:00	MSFT	Stock	127.15	127.385	127.12	127.2	617180.0

> showing 50 of 85,195 rows — these rows as CSV

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