PREVIEW / stock_30min / 2018-05-17

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-17.parquet
  size:    1.7 MB
  rows:    83,444
  symbols: 2,838

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-05-17 04:00:00	AAPL	Stock	46.9375	46.9375	46.9025	46.9025	1200.0
2018-05-17 05:30:00	AAPL	Stock	46.995	46.9975	46.995	46.9975	5528.0
2018-05-17 06:30:00	AAPL	Stock	46.875	46.875	46.85	46.85	5884.0
2018-05-17 07:00:00	AAPL	Stock	46.895	46.93	46.8675	46.9275	24648.0
2018-05-17 07:30:00	AAPL	Stock	46.925	46.97	46.925	46.925	12376.0
2018-05-17 08:00:00	AAPL	Stock	46.9	46.9825	46.885	46.9475	80104.0
2018-05-17 08:30:00	AAPL	Stock	46.8875	46.9375	46.85	46.9	67084.0
2018-05-17 09:00:00	AAPL	Stock	46.9125	47.015	46.9125	46.9975	111072.0
2018-05-17 09:30:00	AAPL	Stock	47.0	47.055	46.82	46.84	8530376.0
2018-05-17 10:00:00	AAPL	Stock	46.845	47.075	46.83	47.0575	5349172.0
2018-05-17 10:30:00	AAPL	Stock	47.06	47.225	47.0362	47.215	5442608.0
2018-05-17 11:00:00	AAPL	Stock	47.215	47.2275	47.07	47.085	3982264.0
2018-05-17 11:30:00	AAPL	Stock	47.09	47.1025	46.9275	46.9875	3579020.0
2018-05-17 12:00:00	AAPL	Stock	46.985	47.0325	46.9125	46.9762	2677848.0
2018-05-17 12:30:00	AAPL	Stock	46.975	47.0075	46.815	46.875	4274648.0
2018-05-17 13:00:00	AAPL	Stock	46.874	46.92	46.8125	46.8828	2168772.0
2018-05-17 13:30:00	AAPL	Stock	46.895	46.905	46.7075	46.7192	3019644.0
2018-05-17 14:00:00	AAPL	Stock	46.7125	46.7625	46.59	46.7212	4747348.0
2018-05-17 14:30:00	AAPL	Stock	46.725	46.845	46.7225	46.82	2601172.0
2018-05-17 15:00:00	AAPL	Stock	46.82	46.8325	46.7	46.75	3134436.0
2018-05-17 15:30:00	AAPL	Stock	46.7525	46.865	46.7125	46.7475	6039648.0
2018-05-17 16:00:00	AAPL	Stock	46.75	46.75	46.6525	46.705	4866856.0
2018-05-17 16:30:00	AAPL	Stock	46.7475	46.7475	46.705	46.705	23516.0
2018-05-17 17:00:00	AAPL	Stock	46.7125	46.7125	46.695	46.7	9916.0
2018-05-17 17:30:00	AAPL	Stock	46.6975	46.72	46.6975	46.71	12264.0
2018-05-17 18:00:00	AAPL	Stock	46.7125	46.7125	46.71	46.71	4500.0
2018-05-17 18:30:00	AAPL	Stock	46.705	46.7725	46.7025	46.755	91932.0
2018-05-17 19:00:00	AAPL	Stock	46.75	46.7875	46.75	46.775	17408.0
2018-05-17 19:30:00	AAPL	Stock	46.75	46.775	46.7375	46.7375	11424.0
2018-05-17 04:30:00	MSFT	Stock	97.06	97.09	97.06	97.09	359.0
2018-05-17 05:30:00	MSFT	Stock	97.06	97.09	97.06	97.09	365.0
2018-05-17 06:30:00	MSFT	Stock	96.97	96.97	96.92	96.93	518.0
2018-05-17 07:00:00	MSFT	Stock	96.85	96.95	96.83	96.95	940.0
2018-05-17 07:30:00	MSFT	Stock	96.95	96.95	96.95	96.95	180.0
2018-05-17 08:00:00	MSFT	Stock	96.98	96.98	96.79	96.9	9965.0
2018-05-17 08:30:00	MSFT	Stock	96.82	96.82	96.76	96.8	893.0
2018-05-17 09:00:00	MSFT	Stock	96.81	96.86	96.76	96.76	4280.0
2018-05-17 09:30:00	MSFT	Stock	96.76	96.94	96.63	96.73	1411086.0
2018-05-17 10:00:00	MSFT	Stock	96.74	97.223	96.74	97.214	871667.0
2018-05-17 10:30:00	MSFT	Stock	97.22	97.54	97.15	97.497	991357.0
2018-05-17 11:00:00	MSFT	Stock	97.495	97.5	97.19	97.225	639431.0
2018-05-17 11:30:00	MSFT	Stock	97.23	97.27	96.904	96.91	653838.0
2018-05-17 12:00:00	MSFT	Stock	96.91	97.05	96.85	97.0	509620.0
2018-05-17 12:30:00	MSFT	Stock	97.0	97.05	96.42	96.53	903755.0
2018-05-17 13:00:00	MSFT	Stock	96.531	96.619	96.44	96.49	528793.0
2018-05-17 13:30:00	MSFT	Stock	96.51	96.53	96.01	96.055	804784.0
2018-05-17 14:00:00	MSFT	Stock	96.05	96.26	95.83	96.185	1112476.0
2018-05-17 14:30:00	MSFT	Stock	96.204	96.51	96.19	96.5	749203.0
2018-05-17 15:00:00	MSFT	Stock	96.5	96.54	96.24	96.38	749370.0
2018-05-17 15:30:00	MSFT	Stock	96.37	96.52	96.14	96.18	2100106.0

> showing 50 of 83,444 rows — these rows as CSV

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