PREVIEW / stock_30min / 2019-05-30

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-30.parquet
  size:    1.7 MB
  rows:    83,139
  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-30 04:00:00	AAPL	Stock	44.465	44.5	44.465	44.5	1200.0
2019-05-30 04:30:00	AAPL	Stock	44.5	44.5	44.4625	44.4625	2000.0
2019-05-30 05:30:00	AAPL	Stock	44.52	44.52	44.52	44.52	400.0
2019-05-30 06:00:00	AAPL	Stock	44.5625	44.575	44.5375	44.575	4192.0
2019-05-30 06:30:00	AAPL	Stock	44.5375	44.5375	44.4025	44.4625	30888.0
2019-05-30 07:00:00	AAPL	Stock	44.4925	44.5125	44.43	44.4875	42268.0
2019-05-30 07:30:00	AAPL	Stock	44.4925	44.5175	44.42	44.42	32884.0
2019-05-30 08:00:00	AAPL	Stock	44.495	44.515	44.37	44.45	101824.0
2019-05-30 08:30:00	AAPL	Stock	44.4875	44.62	44.4375	44.5625	176140.0
2019-05-30 09:00:00	AAPL	Stock	44.5525	44.5775	44.4775	44.5075	246140.0
2019-05-30 09:30:00	AAPL	Stock	44.4975	44.8075	44.41	44.6768	13759984.0
2019-05-30 10:00:00	AAPL	Stock	44.675	44.6925	44.5075	44.6135	6185172.0
2019-05-30 10:30:00	AAPL	Stock	44.6125	44.7125	44.4475	44.5325	5327316.0
2019-05-30 11:00:00	AAPL	Stock	44.5325	44.55	44.41	44.4725	3960524.0
2019-05-30 11:30:00	AAPL	Stock	44.4725	44.534	44.3775	44.4425	3657124.0
2019-05-30 12:00:00	AAPL	Stock	44.4425	44.4675	44.285	44.3305	4296236.0
2019-05-30 12:30:00	AAPL	Stock	44.33	44.475	44.3075	44.42	3210916.0
2019-05-30 13:00:00	AAPL	Stock	44.42	44.4462	44.295	44.365	2689088.0
2019-05-30 13:30:00	AAPL	Stock	44.3725	44.4425	44.2975	44.4075	2756988.0
2019-05-30 14:00:00	AAPL	Stock	44.4075	44.4475	44.2525	44.28	3135316.0
2019-05-30 14:30:00	AAPL	Stock	44.28	44.3775	44.1675	44.37	4204832.0
2019-05-30 15:00:00	AAPL	Stock	44.37	44.4462	44.1825	44.41	4815564.0
2019-05-30 15:30:00	AAPL	Stock	44.41	44.6175	44.3588	44.5625	8833892.0
2019-05-30 16:00:00	AAPL	Stock	44.575	44.595	44.55	44.5825	3603792.0
2019-05-30 16:30:00	AAPL	Stock	44.5775	44.585	44.5625	44.5625	37596.0
2019-05-30 17:00:00	AAPL	Stock	44.5625	44.5625	44.525	44.525	13872.0
2019-05-30 17:30:00	AAPL	Stock	44.545	44.545	44.475	44.475	25316.0
2019-05-30 18:00:00	AAPL	Stock	44.505	44.54	44.505	44.525	18804.0
2019-05-30 18:30:00	AAPL	Stock	44.505	44.525	44.5025	44.525	5612.0
2019-05-30 19:00:00	AAPL	Stock	44.5225	44.5225	44.5175	44.52	1600.0
2019-05-30 19:30:00	AAPL	Stock	44.52	44.52	44.1	44.2	79996.0
2019-05-30 04:00:00	MSFT	Stock	125.32	125.65	125.32	125.65	200.0
2019-05-30 05:30:00	MSFT	Stock	125.6	125.6	125.6	125.6	100.0
2019-05-30 06:30:00	MSFT	Stock	125.4	125.4	125.4	125.4	398.0
2019-05-30 07:00:00	MSFT	Stock	125.25	125.3	125.21	125.23	2752.0
2019-05-30 07:30:00	MSFT	Stock	125.21	125.36	125.21	125.3	4760.0
2019-05-30 08:00:00	MSFT	Stock	125.37	125.39	125.07	125.3	11052.0
2019-05-30 08:30:00	MSFT	Stock	125.39	125.5	125.39	125.484	5019.0
2019-05-30 09:00:00	MSFT	Stock	125.32	125.47	125.15	125.26	10485.0
2019-05-30 09:30:00	MSFT	Stock	125.26	125.74	125.02	125.35	1491290.0
2019-05-30 10:00:00	MSFT	Stock	125.34	125.398	125.02	125.27	1035442.0
2019-05-30 10:30:00	MSFT	Stock	125.275	125.48	125.075	125.16	907882.0
2019-05-30 11:00:00	MSFT	Stock	125.15	125.43	124.96	125.26	745892.0
2019-05-30 11:30:00	MSFT	Stock	125.26	125.395	125.097	125.25	694952.0
2019-05-30 12:00:00	MSFT	Stock	125.26	125.33	125.12	125.18	584198.0
2019-05-30 12:30:00	MSFT	Stock	125.17	125.65	125.103	125.47	596247.0
2019-05-30 13:00:00	MSFT	Stock	125.47	125.57	125.09	125.22	732787.0
2019-05-30 13:30:00	MSFT	Stock	125.22	125.28	124.89	125.155	1302198.0
2019-05-30 14:00:00	MSFT	Stock	125.15	125.23	124.94	124.95	922221.0
2019-05-30 14:30:00	MSFT	Stock	124.95	125.39	124.78	125.38	1326135.0

> showing 50 of 83,139 rows — these rows as CSV

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