PREVIEW / stock_30min / 2017-11-22

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-22.parquet
  size:    1.6 MB
  rows:    82,424
  symbols: 2,944

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-11-22 04:00:00	AAPL	Stock	43.3	43.36	43.3	43.3475	1732.0
2017-11-22 04:30:00	AAPL	Stock	43.3125	43.3325	43.3075	43.3075	3720.0
2017-11-22 05:00:00	AAPL	Stock	43.3325	43.3325	43.3325	43.3325	9984.0
2017-11-22 05:30:00	AAPL	Stock	43.3325	43.3325	43.3	43.3	5276.0
2017-11-22 06:00:00	AAPL	Stock	43.3025	43.325	43.3025	43.305	1600.0
2017-11-22 06:30:00	AAPL	Stock	43.3175	43.3175	43.315	43.315	800.0
2017-11-22 07:00:00	AAPL	Stock	43.305	43.4375	43.305	43.4125	62608.0
2017-11-22 07:30:00	AAPL	Stock	43.39	43.4125	43.365	43.4125	95272.0
2017-11-22 08:00:00	AAPL	Stock	43.425	43.4375	43.33	43.395	150232.0
2017-11-22 08:30:00	AAPL	Stock	43.395	43.4	43.3375	43.345	168040.0
2017-11-22 09:00:00	AAPL	Stock	43.3575	43.395	43.3375	43.3375	73612.0
2017-11-22 09:30:00	AAPL	Stock	43.36	43.565	43.2625	43.3412	16324388.0
2017-11-22 10:00:00	AAPL	Stock	43.335	43.5075	43.325	43.4875	7114692.0
2017-11-22 10:30:00	AAPL	Stock	43.4925	43.65	43.455	43.6225	7754228.0
2017-11-22 11:00:00	AAPL	Stock	43.6225	43.75	43.5825	43.6025	7214524.0
2017-11-22 11:30:00	AAPL	Stock	43.6025	43.639	43.465	43.57	6257628.0
2017-11-22 12:00:00	AAPL	Stock	43.5685	43.6325	43.5025	43.5325	3441324.0
2017-11-22 12:30:00	AAPL	Stock	43.535	43.5975	43.5175	43.5675	2680780.0
2017-11-22 13:00:00	AAPL	Stock	43.5675	43.575	43.4775	43.565	3404736.0
2017-11-22 13:30:00	AAPL	Stock	43.565	43.5875	43.5452	43.5848	2592804.0
2017-11-22 14:00:00	AAPL	Stock	43.5875	43.6	43.55	43.5725	2699720.0
2017-11-22 14:30:00	AAPL	Stock	43.575	43.675	43.57	43.6225	2887580.0
2017-11-22 15:00:00	AAPL	Stock	43.6225	43.6575	43.5875	43.6338	3229548.0
2017-11-22 15:30:00	AAPL	Stock	43.635	43.75	43.6125	43.735	9382640.0
2017-11-22 16:00:00	AAPL	Stock	43.7375	43.75	43.7125	43.74	14156068.0
2017-11-22 16:30:00	AAPL	Stock	43.74	43.745	43.7375	43.74	708304.0
2017-11-22 17:00:00	AAPL	Stock	43.7375	43.7375	43.6875	43.725	10744.0
2017-11-22 17:30:00	AAPL	Stock	43.7125	43.725	43.7075	43.7075	13460.0
2017-11-22 18:00:00	AAPL	Stock	43.7175	43.745	43.7075	43.7425	24240.0
2017-11-22 18:30:00	AAPL	Stock	43.725	43.7425	43.725	43.7375	13040.0
2017-11-22 19:00:00	AAPL	Stock	43.7375	43.745	43.7375	43.7425	16960.0
2017-11-22 19:30:00	AAPL	Stock	43.745	43.745	43.7375	43.745	40876.0
2017-11-22 04:00:00	MSFT	Stock	83.72	83.72	83.72	83.72	100.0
2017-11-22 04:30:00	MSFT	Stock	83.72	83.72	83.72	83.72	2600.0
2017-11-22 05:30:00	MSFT	Stock	83.72	83.72	83.72	83.72	300.0
2017-11-22 07:00:00	MSFT	Stock	83.72	83.72	83.72	83.72	100.0
2017-11-22 08:00:00	MSFT	Stock	83.9	83.95	83.9	83.95	9113.0
2017-11-22 08:30:00	MSFT	Stock	83.9	83.92	83.87	83.92	1050.0
2017-11-22 09:00:00	MSFT	Stock	83.81	83.96	83.81	83.83	4308.0
2017-11-22 09:30:00	MSFT	Stock	83.83	83.9	83.215	83.36	1801393.0
2017-11-22 10:00:00	MSFT	Stock	83.37	83.46	83.32	83.32	1565465.0
2017-11-22 10:30:00	MSFT	Stock	83.32	83.445	83.24	83.275	1285791.0
2017-11-22 11:00:00	MSFT	Stock	83.28	83.45	83.25	83.395	961510.0
2017-11-22 11:30:00	MSFT	Stock	83.4	83.47	83.31	83.41	928148.0
2017-11-22 12:00:00	MSFT	Stock	83.41	83.45	83.34	83.41	612361.0
2017-11-22 12:30:00	MSFT	Stock	83.41	83.45	83.36	83.425	445356.0
2017-11-22 13:00:00	MSFT	Stock	83.425	83.47	83.3	83.324	510548.0
2017-11-22 13:30:00	MSFT	Stock	83.32	83.41	83.305	83.308	482044.0
2017-11-22 14:00:00	MSFT	Stock	83.3	83.321	83.22	83.23	469203.0
2017-11-22 14:30:00	MSFT	Stock	83.225	83.33	83.22	83.23	545168.0

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

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