PREVIEW / stock_30min / 2018-09-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-26.parquet
  size:    1.7 MB
  rows:    83,957
  symbols: 2,789

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-09-26 04:00:00	AAPL	Stock	55.675	55.745	55.675	55.6875	1272.0
2018-09-26 04:30:00	AAPL	Stock	55.7	55.7375	55.6775	55.7375	3400.0
2018-09-26 05:00:00	AAPL	Stock	55.6625	55.665	55.6625	55.665	2000.0
2018-09-26 06:00:00	AAPL	Stock	55.7375	55.7475	55.7375	55.7475	3400.0
2018-09-26 06:30:00	AAPL	Stock	55.7	55.7	55.495	55.495	23208.0
2018-09-26 07:00:00	AAPL	Stock	55.4975	55.5725	55.47	55.505	80036.0
2018-09-26 07:30:00	AAPL	Stock	55.51	55.53	55.4125	55.455	63028.0
2018-09-26 08:00:00	AAPL	Stock	55.5625	55.59	55.4325	55.575	208800.0
2018-09-26 08:30:00	AAPL	Stock	55.5725	55.575	55.5125	55.5375	118380.0
2018-09-26 09:00:00	AAPL	Stock	55.55	55.55	55.25	55.2675	274344.0
2018-09-26 09:30:00	AAPL	Stock	55.25	55.81	55.25	55.775	11399128.0
2018-09-26 10:00:00	AAPL	Stock	55.7775	55.9375	55.5975	55.69	8213560.0
2018-09-26 10:30:00	AAPL	Stock	55.695	55.811	55.635	55.7	3773224.0
2018-09-26 11:00:00	AAPL	Stock	55.7	55.7975	55.635	55.79	3091740.0
2018-09-26 11:30:00	AAPL	Stock	55.791	55.8125	55.6625	55.7112	2548756.0
2018-09-26 12:00:00	AAPL	Stock	55.71	55.7125	55.5575	55.6158	2458712.0
2018-09-26 12:30:00	AAPL	Stock	55.6175	55.6275	55.4925	55.5938	2841760.0
2018-09-26 13:00:00	AAPL	Stock	55.5925	55.6	55.505	55.5588	1964080.0
2018-09-26 13:30:00	AAPL	Stock	55.56	55.57	55.415	55.495	2893860.0
2018-09-26 14:00:00	AAPL	Stock	55.49	55.7725	55.47	55.71	5088692.0
2018-09-26 14:30:00	AAPL	Stock	55.715	55.755	55.4875	55.5708	4433716.0
2018-09-26 15:00:00	AAPL	Stock	55.5725	55.635	55.44	55.6075	4293152.0
2018-09-26 15:30:00	AAPL	Stock	55.6075	55.615	54.94	55.1275	15543108.0
2018-09-26 16:00:00	AAPL	Stock	55.1425	55.1525	55.03	55.125	12154912.0
2018-09-26 16:30:00	AAPL	Stock	55.125	55.15	55.11	55.1375	33428.0
2018-09-26 17:00:00	AAPL	Stock	55.125	55.1375	55.1175	55.1175	28624.0
2018-09-26 17:30:00	AAPL	Stock	55.1125	55.15	55.1125	55.1425	12880.0
2018-09-26 18:00:00	AAPL	Stock	55.14	55.15	55.11	55.15	69468.0
2018-09-26 18:30:00	AAPL	Stock	55.145	55.175	55.1375	55.1625	9796.0
2018-09-26 19:00:00	AAPL	Stock	55.1875	55.225	55.175	55.2025	14220.0
2018-09-26 19:30:00	AAPL	Stock	55.2125	55.2125	55.1875	55.1925	32400.0
2018-09-26 07:00:00	MSFT	Stock	114.88	114.9	114.71	114.9	2173.0
2018-09-26 07:30:00	MSFT	Stock	114.9	114.9	114.8	114.83	2628.0
2018-09-26 08:00:00	MSFT	Stock	114.9	114.9	114.51	114.75	12195.0
2018-09-26 08:30:00	MSFT	Stock	114.7	114.71	114.69	114.7	4175.0
2018-09-26 09:00:00	MSFT	Stock	114.69	114.738	114.46	114.47	11355.0
2018-09-26 09:30:00	MSFT	Stock	114.47	114.81	113.939	114.52	2020245.0
2018-09-26 10:00:00	MSFT	Stock	114.52	114.71	114.135	114.21	1154867.0
2018-09-26 10:30:00	MSFT	Stock	114.21	114.675	114.17	114.5	724202.0
2018-09-26 11:00:00	MSFT	Stock	114.5	114.65	114.46	114.64	681100.0
2018-09-26 11:30:00	MSFT	Stock	114.65	114.77	114.61	114.715	564730.0
2018-09-26 12:00:00	MSFT	Stock	114.72	114.79	114.65	114.765	424880.0
2018-09-26 12:30:00	MSFT	Stock	114.76	114.775	114.505	114.655	502781.0
2018-09-26 13:00:00	MSFT	Stock	114.657	114.82	114.65	114.665	409145.0
2018-09-26 13:30:00	MSFT	Stock	114.665	114.674	114.48	114.59	391428.0
2018-09-26 14:00:00	MSFT	Stock	114.58	115.055	114.51	114.98	1568452.0
2018-09-26 14:30:00	MSFT	Stock	114.97	115.01	114.55	114.77	1059116.0
2018-09-26 15:00:00	MSFT	Stock	114.78	114.87	114.645	114.834	886592.0
2018-09-26 15:30:00	MSFT	Stock	114.83	114.83	113.74	114.13	3780915.0
2018-09-26 16:00:00	MSFT	Stock	114.13	114.17	113.89	114.03	3580501.0

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

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