PREVIEW / stock_30min / 2017-08-17

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-17.parquet
  size:    1.6 MB
  rows:    80,464
  symbols: 2,960

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-17 04:00:00	AAPL	Stock	40.21	40.21	40.21	40.21	400.0
2017-08-17 06:00:00	AAPL	Stock	40.175	40.175	40.175	40.175	400.0
2017-08-17 06:30:00	AAPL	Stock	40.195	40.2	40.195	40.2	4400.0
2017-08-17 07:00:00	AAPL	Stock	40.2125	40.22	40.1375	40.1375	7400.0
2017-08-17 07:30:00	AAPL	Stock	40.13	40.175	40.08	40.1	32844.0
2017-08-17 08:00:00	AAPL	Stock	40.1	40.1625	40.065	40.0775	91604.0
2017-08-17 08:30:00	AAPL	Stock	40.09	40.15	40.09	40.1125	126876.0
2017-08-17 09:00:00	AAPL	Stock	40.125	40.1625	40.095	40.1575	177356.0
2017-08-17 09:30:00	AAPL	Stock	40.13	40.1775	39.91	39.96	11903084.0
2017-08-17 10:00:00	AAPL	Stock	39.96	39.97	39.6005	39.7425	12885212.0
2017-08-17 10:30:00	AAPL	Stock	39.7475	39.865	39.715	39.765	7399160.0
2017-08-17 11:00:00	AAPL	Stock	39.77	39.9288	39.7675	39.8425	6225708.0
2017-08-17 11:30:00	AAPL	Stock	39.8425	39.8825	39.745	39.82	4215820.0
2017-08-17 12:00:00	AAPL	Stock	39.82	39.8782	39.6575	39.775	5551672.0
2017-08-17 12:30:00	AAPL	Stock	39.775	39.7975	39.635	39.675	4441648.0
2017-08-17 13:00:00	AAPL	Stock	39.6725	39.74	39.61	39.7175	4891064.0
2017-08-17 13:30:00	AAPL	Stock	39.72	39.7975	39.6825	39.77	4082832.0
2017-08-17 14:00:00	AAPL	Stock	39.7725	39.794	39.62	39.71	4539020.0
2017-08-17 14:30:00	AAPL	Stock	39.71	39.7525	39.64	39.688	4135116.0
2017-08-17 15:00:00	AAPL	Stock	39.69	39.695	39.4775	39.53	8462476.0
2017-08-17 15:30:00	AAPL	Stock	39.5275	39.6375	39.46	39.465	12416572.0
2017-08-17 16:00:00	AAPL	Stock	39.48	40.1575	39.465	39.5275	7554736.0
2017-08-17 16:30:00	AAPL	Stock	39.55	39.615	39.465	39.5075	307396.0
2017-08-17 17:00:00	AAPL	Stock	39.5325	39.55	39.5	39.525	55920.0
2017-08-17 17:30:00	AAPL	Stock	39.525	39.525	39.465	39.4875	468700.0
2017-08-17 18:00:00	AAPL	Stock	39.4875	39.5225	39.4825	39.4975	70964.0
2017-08-17 18:30:00	AAPL	Stock	39.49	39.5	39.4825	39.49	40072.0
2017-08-17 19:00:00	AAPL	Stock	39.4875	39.525	39.4875	39.5	87944.0
2017-08-17 19:30:00	AAPL	Stock	39.515	39.525	39.5	39.505	35236.0
2017-08-17 06:30:00	MSFT	Stock	73.4	73.4	73.4	73.4	700.0
2017-08-17 07:30:00	MSFT	Stock	73.42	73.42	73.4	73.4	3495.0
2017-08-17 08:00:00	MSFT	Stock	73.55	73.55	73.26	73.26	598.0
2017-08-17 08:30:00	MSFT	Stock	73.4	73.41	73.4	73.41	400.0
2017-08-17 09:00:00	MSFT	Stock	73.31	73.55	73.31	73.55	2588.0
2017-08-17 09:30:00	MSFT	Stock	73.58	73.87	73.48	73.76	1776739.0
2017-08-17 10:00:00	MSFT	Stock	73.76	73.79	73.12	73.26	2138623.0
2017-08-17 10:30:00	MSFT	Stock	73.26	73.36	73.09	73.1	1406267.0
2017-08-17 11:00:00	MSFT	Stock	73.11	73.33	73.09	73.2	1052918.0
2017-08-17 11:30:00	MSFT	Stock	73.21	73.28	73.11	73.143	612508.0
2017-08-17 12:00:00	MSFT	Stock	73.145	73.22	72.875	72.92	1347978.0
2017-08-17 12:30:00	MSFT	Stock	72.92	72.94	72.68	72.74	866491.0
2017-08-17 13:00:00	MSFT	Stock	72.74	72.82	72.55	72.805	1009556.0
2017-08-17 13:30:00	MSFT	Stock	72.81	73.0	72.773	72.9	1261797.0
2017-08-17 14:00:00	MSFT	Stock	72.905	72.93	72.63	72.82	876116.0
2017-08-17 14:30:00	MSFT	Stock	72.81	72.86	72.65	72.716	752121.0
2017-08-17 15:00:00	MSFT	Stock	72.72	72.73	72.51	72.58	1160058.0
2017-08-17 15:30:00	MSFT	Stock	72.57	72.71	72.4	72.41	3512398.0
2017-08-17 16:00:00	MSFT	Stock	72.4	72.47	72.34	72.4	2611347.0
2017-08-17 16:30:00	MSFT	Stock	72.38	72.4	72.24	72.24	5018.0
2017-08-17 17:00:00	MSFT	Stock	72.24	72.34	72.24	72.34	3100.0

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

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