PREVIEW / stock_30min / 2017-05-08

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-08.parquet
  size:    1.6 MB
  rows:    81,653
  symbols: 3,043

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-08 04:00:00	AAPL	Stock	37.295	37.295	37.2475	37.2475	2132.0
2017-05-08 04:30:00	AAPL	Stock	37.255	37.255	37.25	37.25	2400.0
2017-05-08 06:00:00	AAPL	Stock	37.24	37.24	37.24	37.24	1200.0
2017-05-08 06:30:00	AAPL	Stock	37.2475	37.335	37.2475	37.335	12760.0
2017-05-08 07:00:00	AAPL	Stock	37.33	37.375	37.3075	37.3275	114416.0
2017-05-08 07:30:00	AAPL	Stock	37.3275	37.3425	37.2875	37.2875	84600.0
2017-05-08 08:00:00	AAPL	Stock	37.2475	37.345	37.2	37.2225	343940.0
2017-05-08 08:30:00	AAPL	Stock	37.22	37.295	37.215	37.275	443668.0
2017-05-08 09:00:00	AAPL	Stock	37.275	37.2875	37.2575	37.26	200484.0
2017-05-08 09:30:00	AAPL	Stock	37.2575	37.7125	37.2575	37.6175	29227556.0
2017-05-08 10:00:00	AAPL	Stock	37.615	37.7375	37.5625	37.7132	11803116.0
2017-05-08 10:30:00	AAPL	Stock	37.715	37.815	37.695	37.7975	13078796.0
2017-05-08 11:00:00	AAPL	Stock	37.7925	37.9025	37.78	37.8975	9473896.0
2017-05-08 11:30:00	AAPL	Stock	37.8998	38.02	37.889	38.015	13331152.0
2017-05-08 12:00:00	AAPL	Stock	38.015	38.244	37.9925	38.2262	17982508.0
2017-05-08 12:30:00	AAPL	Stock	38.2275	38.3125	38.1775	38.1775	14663596.0
2017-05-08 13:00:00	AAPL	Stock	38.1825	38.275	38.1125	38.2355	10799844.0
2017-05-08 13:30:00	AAPL	Stock	38.235	38.425	38.2078	38.375	11137756.0
2017-05-08 14:00:00	AAPL	Stock	38.375	38.387	38.275	38.317	7859708.0
2017-05-08 14:30:00	AAPL	Stock	38.315	38.37	38.2525	38.3525	7076676.0
2017-05-08 15:00:00	AAPL	Stock	38.35	38.395	38.2525	38.2775	7712024.0
2017-05-08 15:30:00	AAPL	Stock	38.2775	38.2962	38.21	38.2525	13940744.0
2017-05-08 16:00:00	AAPL	Stock	38.2525	38.2675	38.225	38.2525	10427316.0
2017-05-08 16:30:00	AAPL	Stock	38.25	38.2525	38.2375	38.245	172960.0
2017-05-08 17:00:00	AAPL	Stock	38.25	38.2525	38.2475	38.2475	862524.0
2017-05-08 17:30:00	AAPL	Stock	38.2475	38.2725	38.2475	38.2725	95156.0
2017-05-08 18:00:00	AAPL	Stock	38.2675	38.285	38.2675	38.285	40560.0
2017-05-08 18:30:00	AAPL	Stock	38.285	38.2875	38.28	38.2875	66252.0
2017-05-08 19:00:00	AAPL	Stock	38.2875	38.2875	38.2775	38.2875	35352.0
2017-05-08 19:30:00	AAPL	Stock	38.2875	38.3	38.285	38.3	48276.0
2017-05-08 07:00:00	MSFT	Stock	69.24	69.24	69.24	69.24	100.0
2017-05-08 08:00:00	MSFT	Stock	69.1	69.1	68.92	69.0	2700.0
2017-05-08 08:30:00	MSFT	Stock	69.09	69.09	69.0	69.0	350.0
2017-05-08 09:00:00	MSFT	Stock	69.0	69.18	69.0	69.17	2715.0
2017-05-08 09:30:00	MSFT	Stock	68.97	69.05	68.47	68.5	1972357.0
2017-05-08 10:00:00	MSFT	Stock	68.505	68.66	68.42	68.64	1121793.0
2017-05-08 10:30:00	MSFT	Stock	68.65	68.756	68.58	68.6	1375323.0
2017-05-08 11:00:00	MSFT	Stock	68.59	68.685	68.57	68.57	705112.0
2017-05-08 11:30:00	MSFT	Stock	68.575	68.69	68.57	68.658	594267.0
2017-05-08 12:00:00	MSFT	Stock	68.66	68.67	68.58	68.605	481057.0
2017-05-08 12:30:00	MSFT	Stock	68.605	68.68	68.6	68.635	409667.0
2017-05-08 13:00:00	MSFT	Stock	68.635	68.675	68.58	68.59	631839.0
2017-05-08 13:30:00	MSFT	Stock	68.59	68.71	68.58	68.705	658527.0
2017-05-08 14:00:00	MSFT	Stock	68.7	68.76	68.67	68.7	878548.0
2017-05-08 14:30:00	MSFT	Stock	68.695	68.795	68.66	68.75	966286.0
2017-05-08 15:00:00	MSFT	Stock	68.755	68.85	68.74	68.77	845399.0
2017-05-08 15:30:00	MSFT	Stock	68.76	68.95	68.67	68.94	3251394.0
2017-05-08 16:00:00	MSFT	Stock	68.94	68.94	68.623	68.87	3419939.0
2017-05-08 16:30:00	MSFT	Stock	68.85	68.85	68.85	68.85	200.0
2017-05-08 17:00:00	MSFT	Stock	68.85	68.85	68.84	68.84	1679.0

> showing 50 of 81,653 rows — these rows as CSV

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