PREVIEW / stock_30min / 2018-09-18

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-18.parquet
  size:    1.7 MB
  rows:    84,345
  symbols: 2,802

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
2018-09-18 04:00:00	AAPL	Stock	54.54	54.5825	54.525	54.5825	7340.0
2018-09-18 04:30:00	AAPL	Stock	54.53	54.5575	54.525	54.5575	13356.0
2018-09-18 05:00:00	AAPL	Stock	54.55	54.6875	54.55	54.6125	14040.0
2018-09-18 05:30:00	AAPL	Stock	54.6725	54.72	54.6725	54.6825	14868.0
2018-09-18 06:00:00	AAPL	Stock	54.6875	54.74	54.685	54.72	11492.0
2018-09-18 06:30:00	AAPL	Stock	54.72	54.74	54.6875	54.6875	27908.0
2018-09-18 07:00:00	AAPL	Stock	54.6875	54.69	54.53	54.5625	116820.0
2018-09-18 07:30:00	AAPL	Stock	54.58	54.6175	54.5	54.61	47000.0
2018-09-18 08:00:00	AAPL	Stock	54.6678	54.75	54.55	54.6425	404252.0
2018-09-18 08:30:00	AAPL	Stock	54.64	54.775	54.6375	54.725	306296.0
2018-09-18 09:00:00	AAPL	Stock	54.7225	54.7225	54.335	54.365	628296.0
2018-09-18 09:30:00	AAPL	Stock	54.4575	55.4625	54.28	55.093	24992648.0
2018-09-18 10:00:00	AAPL	Stock	55.1025	55.345	55.03	55.035	10179236.0
2018-09-18 10:30:00	AAPL	Stock	55.035	55.0975	54.835	55.0545	9327624.0
2018-09-18 11:00:00	AAPL	Stock	55.05	55.0625	54.8178	54.87	7235232.0
2018-09-18 11:30:00	AAPL	Stock	54.8725	55.0075	54.8375	54.9075	4948828.0
2018-09-18 12:00:00	AAPL	Stock	54.9062	54.97	54.8725	54.9275	3456708.0
2018-09-18 12:30:00	AAPL	Stock	54.9275	54.9975	54.5875	54.6882	5207288.0
2018-09-18 13:00:00	AAPL	Stock	54.6895	54.8475	54.6725	54.695	4073288.0
2018-09-18 13:30:00	AAPL	Stock	54.6958	54.83	54.635	54.7925	3740628.0
2018-09-18 14:00:00	AAPL	Stock	54.7925	54.87	54.72	54.8402	3473784.0
2018-09-18 14:30:00	AAPL	Stock	54.8425	54.9375	54.6962	54.7125	4751688.0
2018-09-18 15:00:00	AAPL	Stock	54.7125	54.7825	54.64	54.7425	4145836.0
2018-09-18 15:30:00	AAPL	Stock	54.7425	54.755	54.5425	54.56	11186168.0
2018-09-18 16:00:00	AAPL	Stock	54.56	54.61	54.5375	54.5575	8940464.0
2018-09-18 16:30:00	AAPL	Stock	54.5375	54.545	54.515	54.53	54504.0
2018-09-18 17:00:00	AAPL	Stock	54.52	54.5575	54.515	54.5525	64896.0
2018-09-18 17:30:00	AAPL	Stock	54.5525	54.5575	54.5478	54.5478	10804.0
2018-09-18 18:00:00	AAPL	Stock	54.5575	54.6125	54.5525	54.6125	44816.0
2018-09-18 18:30:00	AAPL	Stock	54.6125	54.625	54.575	54.5875	20232.0
2018-09-18 19:00:00	AAPL	Stock	54.605	54.625	54.59	54.6025	14944.0
2018-09-18 19:30:00	AAPL	Stock	54.615	54.625	54.6075	54.61	51748.0
2018-09-18 04:00:00	MSFT	Stock	112.2	112.31	112.2	112.3	652.0
2018-09-18 05:00:00	MSFT	Stock	112.3	112.3	112.3	112.3	1227.0
2018-09-18 05:30:00	MSFT	Stock	112.3	112.3	112.3	112.3	1910.0
2018-09-18 06:00:00	MSFT	Stock	112.4	112.4	112.4	112.4	2500.0
2018-09-18 06:30:00	MSFT	Stock	112.39	112.39	112.39	112.39	200.0
2018-09-18 07:00:00	MSFT	Stock	112.31	112.68	112.3	112.31	12409.0
2018-09-18 07:30:00	MSFT	Stock	112.4	112.49	112.4	112.49	968.0
2018-09-18 08:00:00	MSFT	Stock	112.37	112.55	112.3	112.36	11522.0
2018-09-18 08:30:00	MSFT	Stock	112.36	112.59	112.36	112.55	16508.0
2018-09-18 09:00:00	MSFT	Stock	112.55	112.55	111.95	112.07	21329.0
2018-09-18 09:30:00	MSFT	Stock	112.07	113.29	111.72	113.225	2688798.0
2018-09-18 10:00:00	MSFT	Stock	113.23	113.5	113.12	113.35	1805002.0
2018-09-18 10:30:00	MSFT	Stock	113.35	113.45	113.06	113.205	1298659.0
2018-09-18 11:00:00	MSFT	Stock	113.2	113.345	113.165	113.29	1267067.0
2018-09-18 11:30:00	MSFT	Stock	113.29	113.54	113.23	113.54	1044955.0
2018-09-18 12:00:00	MSFT	Stock	113.54	113.695	113.28	113.435	892794.0
2018-09-18 12:30:00	MSFT	Stock	113.43	113.52	113.31	113.41	832397.0
2018-09-18 13:00:00	MSFT	Stock	113.415	113.495	113.32	113.355	533101.0

> showing 50 of 84,345 rows — these rows as CSV

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