PREVIEW / stock_30min / 2017-06-19

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-19.parquet
  size:    1.6 MB
  rows:    84,255
  symbols: 3,032

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-06-19 04:00:00	AAPL	Stock	35.775	35.8875	35.775	35.85	8692.0
2017-06-19 04:30:00	AAPL	Stock	35.9	35.945	35.9	35.945	1456.0
2017-06-19 05:00:00	AAPL	Stock	35.95	35.95	35.95	35.95	5680.0
2017-06-19 05:30:00	AAPL	Stock	35.95	35.95	35.9225	35.925	3276.0
2017-06-19 06:00:00	AAPL	Stock	35.915	35.955	35.85	35.955	54660.0
2017-06-19 06:30:00	AAPL	Stock	35.9225	35.9225	35.88	35.9	20200.0
2017-06-19 07:00:00	AAPL	Stock	35.89	35.9125	35.875	35.88	41952.0
2017-06-19 07:30:00	AAPL	Stock	35.875	35.915	35.86	35.915	37312.0
2017-06-19 08:00:00	AAPL	Stock	35.9125	35.965	35.875	35.95	300732.0
2017-06-19 08:30:00	AAPL	Stock	35.95	35.95	35.84	35.85	271200.0
2017-06-19 09:00:00	AAPL	Stock	35.8625	36.0775	35.8525	35.9975	649104.0
2017-06-19 09:30:00	AAPL	Stock	35.9975	36.2848	35.915	36.227	21463648.0
2017-06-19 10:00:00	AAPL	Stock	36.225	36.51	36.2148	36.4875	15175948.0
2017-06-19 10:30:00	AAPL	Stock	36.4918	36.5475	36.425	36.47	9498044.0
2017-06-19 11:00:00	AAPL	Stock	36.469	36.5175	36.4025	36.4825	5117200.0
2017-06-19 11:30:00	AAPL	Stock	36.4815	36.515	36.4425	36.455	4364972.0
2017-06-19 12:00:00	AAPL	Stock	36.4575	36.48	36.4075	36.465	4035308.0
2017-06-19 12:30:00	AAPL	Stock	36.4662	36.4922	36.4225	36.484	2969744.0
2017-06-19 13:00:00	AAPL	Stock	36.485	36.595	36.4775	36.5875	4996852.0
2017-06-19 13:30:00	AAPL	Stock	36.5875	36.685	36.5725	36.6375	6567132.0
2017-06-19 14:00:00	AAPL	Stock	36.635	36.655	36.55	36.58	5199456.0
2017-06-19 14:30:00	AAPL	Stock	36.58	36.58	36.495	36.5125	4423008.0
2017-06-19 15:00:00	AAPL	Stock	36.51	36.55	36.4825	36.5125	4910504.0
2017-06-19 15:30:00	AAPL	Stock	36.5125	36.635	36.485	36.585	13580156.0
2017-06-19 16:00:00	AAPL	Stock	36.6	36.6	36.5625	36.58	11894324.0
2017-06-19 16:30:00	AAPL	Stock	36.5625	36.63	36.5625	36.585	116464.0
2017-06-19 17:00:00	AAPL	Stock	36.585	36.6225	36.585	36.615	296796.0
2017-06-19 17:30:00	AAPL	Stock	36.615	36.6225	36.585	36.62	1056716.0
2017-06-19 18:00:00	AAPL	Stock	36.6225	36.6225	36.615	36.615	9244.0
2017-06-19 18:30:00	AAPL	Stock	36.6225	36.665	36.62	36.665	75164.0
2017-06-19 19:00:00	AAPL	Stock	36.665	36.6725	36.6075	36.66	29772.0
2017-06-19 19:30:00	AAPL	Stock	36.65	36.6825	36.6375	36.6775	43196.0
2017-06-19 05:00:00	MSFT	Stock	70.15	70.15	70.15	70.15	1000.0
2017-06-19 06:00:00	MSFT	Stock	70.22	70.22	70.22	70.22	100.0
2017-06-19 07:00:00	MSFT	Stock	70.46	70.5	70.44	70.44	2100.0
2017-06-19 07:30:00	MSFT	Stock	70.4	70.49	70.4	70.49	4990.0
2017-06-19 08:00:00	MSFT	Stock	70.49	70.6	70.44	70.55	10370.0
2017-06-19 08:30:00	MSFT	Stock	70.48	70.55	70.44	70.44	4411.0
2017-06-19 09:00:00	MSFT	Stock	70.5	70.55	70.44	70.5	8482.0
2017-06-19 09:30:00	MSFT	Stock	70.5	70.945	70.5	70.61	3033359.0
2017-06-19 10:00:00	MSFT	Stock	70.61	70.83	70.47	70.59	2285934.0
2017-06-19 10:30:00	MSFT	Stock	70.59	70.62	70.35	70.57	1389425.0
2017-06-19 11:00:00	MSFT	Stock	70.56	70.6	70.47	70.52	1054698.0
2017-06-19 11:30:00	MSFT	Stock	70.515	70.6	70.48	70.53	665966.0
2017-06-19 12:00:00	MSFT	Stock	70.54	70.66	70.5	70.65	883042.0
2017-06-19 12:30:00	MSFT	Stock	70.645	70.66	70.52	70.53	581104.0
2017-06-19 13:00:00	MSFT	Stock	70.54	70.65	70.525	70.645	528498.0
2017-06-19 13:30:00	MSFT	Stock	70.65	70.8	70.63	70.73	1118693.0
2017-06-19 14:00:00	MSFT	Stock	70.736	70.76	70.59	70.635	653731.0
2017-06-19 14:30:00	MSFT	Stock	70.63	70.71	70.594	70.67	848999.0

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

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