PREVIEW / stock_30min / 2018-05-31

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-31.parquet
  size:    1.7 MB
  rows:    83,382
  symbols: 2,830

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-31 04:00:00	AAPL	Stock	46.975	46.975	46.975	46.975	2020.0
2018-05-31 04:30:00	AAPL	Stock	46.975	46.975	46.975	46.975	18192.0
2018-05-31 05:00:00	AAPL	Stock	46.975	46.975	46.975	46.975	7772.0
2018-05-31 05:30:00	AAPL	Stock	46.975	46.975	46.95	46.95	8400.0
2018-05-31 06:00:00	AAPL	Stock	46.95	46.95	46.925	46.925	18944.0
2018-05-31 06:30:00	AAPL	Stock	46.925	46.925	46.925	46.925	6800.0
2018-05-31 07:00:00	AAPL	Stock	46.93	46.965	46.925	46.95	38364.0
2018-05-31 07:30:00	AAPL	Stock	46.955	46.975	46.95	46.975	29232.0
2018-05-31 08:00:00	AAPL	Stock	46.95	46.98	46.9325	46.96	35148.0
2018-05-31 08:30:00	AAPL	Stock	46.9375	46.96	46.925	46.9375	44848.0
2018-05-31 09:00:00	AAPL	Stock	46.9375	46.9375	46.7975	46.81	165456.0
2018-05-31 09:30:00	AAPL	Stock	46.8125	46.9625	46.75	46.83	8768768.0
2018-05-31 10:00:00	AAPL	Stock	46.8325	46.8625	46.725	46.8025	4975164.0
2018-05-31 10:30:00	AAPL	Stock	46.8	46.8375	46.535	46.6475	6094480.0
2018-05-31 11:00:00	AAPL	Stock	46.6475	46.8237	46.6225	46.8237	4098216.0
2018-05-31 11:30:00	AAPL	Stock	46.82	47.0575	46.79	46.9625	8001468.0
2018-05-31 12:00:00	AAPL	Stock	46.9625	46.9675	46.835	46.8538	3900988.0
2018-05-31 12:30:00	AAPL	Stock	46.8525	46.95	46.8325	46.91	2688484.0
2018-05-31 13:00:00	AAPL	Stock	46.91	46.9175	46.8175	46.885	2937892.0
2018-05-31 13:30:00	AAPL	Stock	46.8875	46.91	46.7125	46.725	3020532.0
2018-05-31 14:00:00	AAPL	Stock	46.7232	46.77	46.625	46.7225	4254996.0
2018-05-31 14:30:00	AAPL	Stock	46.7225	46.82	46.6987	46.8175	3305540.0
2018-05-31 15:00:00	AAPL	Stock	46.815	46.865	46.7712	46.8125	3386080.0
2018-05-31 15:30:00	AAPL	Stock	46.8125	46.8288	46.67	46.72	11028104.0
2018-05-31 16:00:00	AAPL	Stock	46.72	46.756	46.6875	46.756	27201148.0
2018-05-31 16:30:00	AAPL	Stock	46.715	46.745	46.71	46.71	32024.0
2018-05-31 17:00:00	AAPL	Stock	46.7175	46.72	46.7025	46.7035	25640.0
2018-05-31 17:30:00	AAPL	Stock	46.735	46.735	46.705	46.705	4596.0
2018-05-31 18:30:00	AAPL	Stock	46.7325	46.7325	46.7175	46.73	5160.0
2018-05-31 19:00:00	AAPL	Stock	46.73	46.73	46.7175	46.73	7436.0
2018-05-31 19:30:00	AAPL	Stock	46.7175	46.7425	46.7175	46.7425	15088.0
2018-05-31 04:30:00	MSFT	Stock	99.19	99.2	99.19	99.19	699.0
2018-05-31 06:00:00	MSFT	Stock	99.18	99.19	99.18	99.19	1900.0
2018-05-31 07:00:00	MSFT	Stock	99.0	99.0	99.0	99.0	2029.0
2018-05-31 07:30:00	MSFT	Stock	99.0	99.0	99.0	99.0	707.0
2018-05-31 08:00:00	MSFT	Stock	99.0	99.14	98.91	99.07	8146.0
2018-05-31 08:30:00	MSFT	Stock	99.07	99.13	99.03	99.07	13877.0
2018-05-31 09:00:00	MSFT	Stock	99.03	99.3	98.78	99.3	23409.0
2018-05-31 09:30:00	MSFT	Stock	99.29	99.559	98.89	99.4	2665602.0
2018-05-31 10:00:00	MSFT	Stock	99.41	99.52	99.1	99.236	1528775.0
2018-05-31 10:30:00	MSFT	Stock	99.23	99.31	98.73	98.905	1303665.0
2018-05-31 11:00:00	MSFT	Stock	98.9	99.32	98.82	99.29	1110723.0
2018-05-31 11:30:00	MSFT	Stock	99.3	99.99	99.18	99.78	2080844.0
2018-05-31 12:00:00	MSFT	Stock	99.78	99.9	99.65	99.69	931907.0
2018-05-31 12:30:00	MSFT	Stock	99.69	99.87	99.59	99.855	670021.0
2018-05-31 13:00:00	MSFT	Stock	99.86	99.863	99.6	99.66	588740.0
2018-05-31 13:30:00	MSFT	Stock	99.665	99.7	99.26	99.3	888327.0
2018-05-31 14:00:00	MSFT	Stock	99.31	99.32	99.075	99.105	1116796.0
2018-05-31 14:30:00	MSFT	Stock	99.1	99.19	98.945	99.03	1051568.0
2018-05-31 15:00:00	MSFT	Stock	99.03	99.12	98.9	99.015	1103841.0

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

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