PREVIEW / stock_30min / 2017-04-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-13.parquet
  size:    1.6 MB
  rows:    80,501
  symbols: 3,048

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-04-13 04:00:00	AAPL	Stock	35.4625	35.4625	35.4	35.4	4020.0
2017-04-13 06:00:00	AAPL	Stock	35.385	35.395	35.385	35.395	4400.0
2017-04-13 07:00:00	AAPL	Stock	35.375	35.375	35.3725	35.375	25804.0
2017-04-13 07:30:00	AAPL	Stock	35.375	35.375	35.355	35.3625	13800.0
2017-04-13 08:00:00	AAPL	Stock	35.3725	35.415	35.36	35.4125	47672.0
2017-04-13 08:30:00	AAPL	Stock	35.415	35.43	35.4	35.4	42288.0
2017-04-13 09:00:00	AAPL	Stock	35.4	35.485	35.395	35.46	153052.0
2017-04-13 09:30:00	AAPL	Stock	35.46	35.5325	35.39	35.4965	9829648.0
2017-04-13 10:00:00	AAPL	Stock	35.4975	35.555	35.4968	35.5225	5075180.0
2017-04-13 10:30:00	AAPL	Stock	35.5248	35.585	35.5125	35.5675	3944300.0
2017-04-13 11:00:00	AAPL	Stock	35.5675	35.595	35.5275	35.5755	3232628.0
2017-04-13 11:30:00	AAPL	Stock	35.575	35.58	35.53	35.545	2440464.0
2017-04-13 12:00:00	AAPL	Stock	35.545	35.5475	35.485	35.505	3411924.0
2017-04-13 12:30:00	AAPL	Stock	35.5075	35.5362	35.4625	35.48	2756432.0
2017-04-13 13:00:00	AAPL	Stock	35.4825	35.4875	35.3975	35.4675	3656436.0
2017-04-13 13:30:00	AAPL	Stock	35.4685	35.495	35.415	35.425	2441004.0
2017-04-13 14:00:00	AAPL	Stock	35.425	35.495	35.425	35.47	3287060.0
2017-04-13 14:30:00	AAPL	Stock	35.4675	35.5075	35.465	35.4975	2452200.0
2017-04-13 15:00:00	AAPL	Stock	35.4975	35.5075	35.4325	35.4425	3634044.0
2017-04-13 15:30:00	AAPL	Stock	35.4375	35.45	35.2625	35.2675	12489928.0
2017-04-13 16:00:00	AAPL	Stock	35.2625	35.3	35.2625	35.2775	5049772.0
2017-04-13 16:30:00	AAPL	Stock	35.28	35.3075	35.275	35.29	153396.0
2017-04-13 17:00:00	AAPL	Stock	35.285	35.305	35.28	35.2875	13568.0
2017-04-13 17:30:00	AAPL	Stock	35.2825	35.2825	35.275	35.275	14096.0
2017-04-13 18:00:00	AAPL	Stock	35.2675	35.275	35.2625	35.275	5916.0
2017-04-13 18:30:00	AAPL	Stock	35.275	35.275	35.26	35.26	74992.0
2017-04-13 19:00:00	AAPL	Stock	35.265	35.275	35.25	35.25	12420.0
2017-04-13 19:30:00	AAPL	Stock	35.26	35.265	35.26	35.265	1200.0
2017-04-13 08:00:00	MSFT	Stock	65.17	65.18	65.17	65.18	1132.0
2017-04-13 09:00:00	MSFT	Stock	65.18	65.29	65.15	65.29	17653.0
2017-04-13 09:30:00	MSFT	Stock	65.29	65.66	64.98	65.59	2433673.0
2017-04-13 10:00:00	MSFT	Stock	65.6	65.72	65.59	65.715	944527.0
2017-04-13 10:30:00	MSFT	Stock	65.72	65.86	65.69	65.83	1300872.0
2017-04-13 11:00:00	MSFT	Stock	65.83	65.85	65.599	65.61	843946.0
2017-04-13 11:30:00	MSFT	Stock	65.61	65.66	65.54	65.56	527601.0
2017-04-13 12:00:00	MSFT	Stock	65.56	65.565	65.41	65.48	791354.0
2017-04-13 12:30:00	MSFT	Stock	65.48	65.5	65.265	65.31	758450.0
2017-04-13 13:00:00	MSFT	Stock	65.305	65.315	65.14	65.255	893003.0
2017-04-13 13:30:00	MSFT	Stock	65.25	65.33	65.15	65.18	622614.0
2017-04-13 14:00:00	MSFT	Stock	65.18	65.32	65.17	65.28	732479.0
2017-04-13 14:30:00	MSFT	Stock	65.27	65.315	65.19	65.265	639327.0
2017-04-13 15:00:00	MSFT	Stock	65.26	65.3	65.13	65.21	805193.0
2017-04-13 15:30:00	MSFT	Stock	65.205	65.24	64.95	64.96	3268256.0
2017-04-13 16:00:00	MSFT	Stock	64.95	64.99	64.93	64.93	1738482.0
2017-04-13 16:30:00	MSFT	Stock	64.95	64.96	64.9	64.9	10706.0
2017-04-13 17:00:00	MSFT	Stock	64.98	64.99	64.96	64.96	8800.0
2017-04-13 17:30:00	MSFT	Stock	64.96	64.96	64.91	64.95	1958.0
2017-04-13 18:00:00	MSFT	Stock	64.95	64.95	64.95	64.95	200.0
2017-04-13 18:30:00	MSFT	Stock	64.95	64.95	64.95	64.95	100.0
2017-04-13 19:00:00	MSFT	Stock	64.94	64.94	64.9	64.9	580.0

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

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