PREVIEW / stock_30min / 2017-08-07

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-07.parquet
  size:    1.6 MB
  rows:    80,920
  symbols: 2,988

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-08-07 04:00:00	AAPL	Stock	39.275	39.275	39.2375	39.2375	12700.0
2017-08-07 04:30:00	AAPL	Stock	39.2625	39.2625	39.2625	39.2625	1860.0
2017-08-07 05:00:00	AAPL	Stock	39.2625	39.2675	39.245	39.245	3696.0
2017-08-07 05:30:00	AAPL	Stock	39.245	39.245	39.2125	39.2425	3664.0
2017-08-07 06:00:00	AAPL	Stock	39.205	39.24	39.2025	39.24	8200.0
2017-08-07 06:30:00	AAPL	Stock	39.2375	39.2375	39.205	39.225	5580.0
2017-08-07 07:00:00	AAPL	Stock	39.215	39.225	39.2	39.2	33404.0
2017-08-07 07:30:00	AAPL	Stock	39.1875	39.22	39.1875	39.21	46616.0
2017-08-07 08:00:00	AAPL	Stock	39.2125	39.2425	39.015	39.2425	133132.0
2017-08-07 08:30:00	AAPL	Stock	39.2425	39.2625	39.2175	39.235	77680.0
2017-08-07 09:00:00	AAPL	Stock	39.2325	39.3025	39.21	39.25	249008.0
2017-08-07 09:30:00	AAPL	Stock	39.2525	39.375	39.1675	39.3575	11467444.0
2017-08-07 10:00:00	AAPL	Stock	39.3612	39.4325	39.3125	39.3838	6992880.0
2017-08-07 10:30:00	AAPL	Stock	39.3828	39.425	39.345	39.385	4287428.0
2017-08-07 11:00:00	AAPL	Stock	39.3875	39.485	39.3475	39.4625	4602660.0
2017-08-07 11:30:00	AAPL	Stock	39.4625	39.5375	39.4375	39.5095	5141536.0
2017-08-07 12:00:00	AAPL	Stock	39.503	39.5475	39.4725	39.4835	3352068.0
2017-08-07 12:30:00	AAPL	Stock	39.485	39.4933	39.4175	39.485	3861048.0
2017-08-07 13:00:00	AAPL	Stock	39.485	39.4975	39.4625	39.4825	2463840.0
2017-08-07 13:30:00	AAPL	Stock	39.485	39.4975	39.4575	39.4873	2175484.0
2017-08-07 14:00:00	AAPL	Stock	39.485	39.5325	39.4675	39.53	2800188.0
2017-08-07 14:30:00	AAPL	Stock	39.53	39.6125	39.5275	39.574	4665252.0
2017-08-07 15:00:00	AAPL	Stock	39.573	39.73	39.55	39.73	6530616.0
2017-08-07 15:30:00	AAPL	Stock	39.7275	39.73	39.6525	39.6975	11066876.0
2017-08-07 16:00:00	AAPL	Stock	39.7025	39.7175	39.6475	39.6975	6746648.0
2017-08-07 16:30:00	AAPL	Stock	39.7075	39.7075	39.6875	39.7075	1514744.0
2017-08-07 17:00:00	AAPL	Stock	39.7075	39.7075	39.6875	39.6875	14228.0
2017-08-07 17:30:00	AAPL	Stock	39.6875	39.6875	39.67	39.675	16692.0
2017-08-07 18:00:00	AAPL	Stock	39.6825	39.6875	39.67	39.6875	13004.0
2017-08-07 18:30:00	AAPL	Stock	39.6875	39.6875	39.6725	39.6725	3612.0
2017-08-07 19:00:00	AAPL	Stock	39.675	39.6825	39.675	39.675	17280.0
2017-08-07 19:30:00	AAPL	Stock	39.685	39.6875	39.675	39.6875	22652.0
2017-08-07 05:00:00	MSFT	Stock	72.84	72.84	72.84	72.84	100.0
2017-08-07 05:30:00	MSFT	Stock	72.84	72.84	72.84	72.84	900.0
2017-08-07 07:30:00	MSFT	Stock	72.89	72.89	72.8	72.8	299.0
2017-08-07 08:00:00	MSFT	Stock	72.7	72.89	72.7	72.89	240.0
2017-08-07 08:30:00	MSFT	Stock	72.89	72.89	72.89	72.89	150.0
2017-08-07 09:00:00	MSFT	Stock	72.85	73.18	72.71	72.8	24289.0
2017-08-07 09:30:00	MSFT	Stock	72.8	72.9	72.55	72.63	2018051.0
2017-08-07 10:00:00	MSFT	Stock	72.63	72.675	72.5	72.57	1077220.0
2017-08-07 10:30:00	MSFT	Stock	72.57	72.77	72.54	72.655	1083472.0
2017-08-07 11:00:00	MSFT	Stock	72.655	72.655	72.465	72.565	1094211.0
2017-08-07 11:30:00	MSFT	Stock	72.57	72.61	72.41	72.416	1000454.0
2017-08-07 12:00:00	MSFT	Stock	72.415	72.427	72.33	72.39	1013335.0
2017-08-07 12:30:00	MSFT	Stock	72.395	72.41	72.36	72.375	498398.0
2017-08-07 13:00:00	MSFT	Stock	72.38	72.5	72.37	72.485	550507.0
2017-08-07 13:30:00	MSFT	Stock	72.485	72.51	72.43	72.445	469231.0
2017-08-07 14:00:00	MSFT	Stock	72.44	72.48	72.38	72.395	745184.0
2017-08-07 14:30:00	MSFT	Stock	72.39	72.43	72.315	72.325	711434.0
2017-08-07 15:00:00	MSFT	Stock	72.321	72.4	72.26	72.4	848561.0

> showing 50 of 80,920 rows — these rows as CSV

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