PREVIEW / stock_30min / 2017-05-04

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-04.parquet
  size:    1.6 MB
  rows:    82,083
  symbols: 3,052

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-05-04 04:00:00	AAPL	Stock	36.72	36.72	36.7125	36.7125	800.0
2017-05-04 05:00:00	AAPL	Stock	36.7425	36.7425	36.7275	36.7425	3972.0
2017-05-04 05:30:00	AAPL	Stock	36.775	36.775	36.775	36.775	3748.0
2017-05-04 06:00:00	AAPL	Stock	36.8225	36.8225	36.81	36.8125	8904.0
2017-05-04 06:30:00	AAPL	Stock	36.7875	36.84	36.7875	36.84	8444.0
2017-05-04 07:00:00	AAPL	Stock	36.8475	36.8625	36.7725	36.775	75288.0
2017-05-04 07:30:00	AAPL	Stock	36.78	36.835	36.78	36.795	66936.0
2017-05-04 08:00:00	AAPL	Stock	36.8475	36.85	36.6875	36.7025	206220.0
2017-05-04 08:30:00	AAPL	Stock	36.73	36.7375	36.635	36.635	109980.0
2017-05-04 09:00:00	AAPL	Stock	36.635	36.6875	36.62	36.6325	251628.0
2017-05-04 09:30:00	AAPL	Stock	36.6375	36.785	36.46	36.5405	17617400.0
2017-05-04 10:00:00	AAPL	Stock	36.5382	36.61	36.5125	36.5878	7628536.0
2017-05-04 10:30:00	AAPL	Stock	36.5875	36.6	36.5525	36.5675	4451032.0
2017-05-04 11:00:00	AAPL	Stock	36.5675	36.6225	36.56	36.58	5203624.0
2017-05-04 11:30:00	AAPL	Stock	36.58	36.6175	36.53	36.5485	4738668.0
2017-05-04 12:00:00	AAPL	Stock	36.55	36.57	36.4525	36.51	5872556.0
2017-05-04 12:30:00	AAPL	Stock	36.508	36.6415	36.5025	36.63	4731324.0
2017-05-04 13:00:00	AAPL	Stock	36.63	36.635	36.5712	36.605	2489812.0
2017-05-04 13:30:00	AAPL	Stock	36.605	36.6275	36.5625	36.6093	3279888.0
2017-05-04 14:00:00	AAPL	Stock	36.61	36.6475	36.55	36.64	4151008.0
2017-05-04 14:30:00	AAPL	Stock	36.636	36.6475	36.57	36.59	3177340.0
2017-05-04 15:00:00	AAPL	Stock	36.59	36.615	36.58	36.5875	2820520.0
2017-05-04 15:30:00	AAPL	Stock	36.59	36.6675	36.58	36.635	9650436.0
2017-05-04 16:00:00	AAPL	Stock	36.6325	36.655	36.6175	36.6325	7340516.0
2017-05-04 16:30:00	AAPL	Stock	36.63	36.6375	36.6275	36.6375	113720.0
2017-05-04 17:00:00	AAPL	Stock	36.6325	36.655	36.6325	36.655	25256.0
2017-05-04 17:30:00	AAPL	Stock	36.64	36.6575	36.64	36.6575	3620.0
2017-05-04 18:00:00	AAPL	Stock	36.6425	36.65	36.6375	36.6375	6212.0
2017-05-04 18:30:00	AAPL	Stock	36.6375	36.6375	36.6375	36.6375	2756.0
2017-05-04 19:00:00	AAPL	Stock	36.6425	36.6425	36.6375	36.6425	15036.0
2017-05-04 19:30:00	AAPL	Stock	36.6425	36.65	36.6375	36.65	8080.0
2017-05-04 05:00:00	MSFT	Stock	69.14	69.14	69.14	69.14	111.0
2017-05-04 08:00:00	MSFT	Stock	68.96	69.37	68.96	69.1	960.0
2017-05-04 08:30:00	MSFT	Stock	69.12	69.12	69.07	69.07	827.0
2017-05-04 09:00:00	MSFT	Stock	69.05	69.12	68.7	69.06	6659.0
2017-05-04 09:30:00	MSFT	Stock	69.03	69.08	68.77	68.79	2086427.0
2017-05-04 10:00:00	MSFT	Stock	68.79	68.82	68.71	68.81	2123805.0
2017-05-04 10:30:00	MSFT	Stock	68.81	68.9	68.755	68.815	1499439.0
2017-05-04 11:00:00	MSFT	Stock	68.811	68.94	68.77	68.92	1447711.0
2017-05-04 11:30:00	MSFT	Stock	68.92	68.94	68.75	68.783	1107786.0
2017-05-04 12:00:00	MSFT	Stock	68.785	68.85	68.64	68.73	1276927.0
2017-05-04 12:30:00	MSFT	Stock	68.73	68.84	68.7	68.84	771988.0
2017-05-04 13:00:00	MSFT	Stock	68.84	68.87	68.81	68.83	628722.0
2017-05-04 13:30:00	MSFT	Stock	68.825	68.89	68.78	68.8	1138680.0
2017-05-04 14:00:00	MSFT	Stock	68.807	68.84	68.705	68.8	948625.0
2017-05-04 14:30:00	MSFT	Stock	68.8	68.88	68.729	68.785	1511980.0
2017-05-04 15:00:00	MSFT	Stock	68.785	68.8	68.705	68.755	1212530.0
2017-05-04 15:30:00	MSFT	Stock	68.754	68.89	68.75	68.81	2807670.0
2017-05-04 16:00:00	MSFT	Stock	68.81	68.82	68.8	68.81	1186166.0
2017-05-04 17:30:00	MSFT	Stock	68.8	68.8	68.8	68.8	2000.0

> showing 50 of 82,083 rows — these rows as CSV

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