PREVIEW / stock_30min / 2016-04-01

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-01.parquet
  size:    1.6 MB
  rows:    81,782
  symbols: 3,345

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
2016-04-01 04:00:00	AAPL	Stock	27.1725	27.1725	27.1	27.125	6400.0
2016-04-01 04:30:00	AAPL	Stock	27.1125	27.15	27.1125	27.15	4000.0
2016-04-01 05:30:00	AAPL	Stock	27.1375	27.1375	27.1375	27.1375	428.0
2016-04-01 06:30:00	AAPL	Stock	27.1175	27.12	27.1125	27.1125	11720.0
2016-04-01 07:00:00	AAPL	Stock	27.13	27.1925	27.13	27.1925	34920.0
2016-04-01 07:30:00	AAPL	Stock	27.17	27.19	27.1575	27.16	17752.0
2016-04-01 08:00:00	AAPL	Stock	27.1725	27.25	27.1125	27.225	329540.0
2016-04-01 08:30:00	AAPL	Stock	27.225	27.2875	27.1525	27.1875	261012.0
2016-04-01 09:00:00	AAPL	Stock	27.1875	27.2175	27.15	27.1825	226596.0
2016-04-01 09:30:00	AAPL	Stock	27.185	27.2725	27.05	27.1725	14859056.0
2016-04-01 10:00:00	AAPL	Stock	27.1725	27.3142	27.1175	27.205	9341096.0
2016-04-01 10:30:00	AAPL	Stock	27.205	27.3975	27.205	27.3975	7626336.0
2016-04-01 11:00:00	AAPL	Stock	27.3975	27.425	27.35	27.4025	6512416.0
2016-04-01 11:30:00	AAPL	Stock	27.4025	27.5	27.375	27.385	8338368.0
2016-04-01 12:00:00	AAPL	Stock	27.3825	27.44	27.3675	27.395	3237692.0
2016-04-01 12:30:00	AAPL	Stock	27.3942	27.43	27.3675	27.3975	2656164.0
2016-04-01 13:00:00	AAPL	Stock	27.3988	27.4675	27.3875	27.4425	2530712.0
2016-04-01 13:30:00	AAPL	Stock	27.442	27.45	27.3778	27.4212	3528540.0
2016-04-01 14:00:00	AAPL	Stock	27.4225	27.455	27.3825	27.4025	3662668.0
2016-04-01 14:30:00	AAPL	Stock	27.4025	27.445	27.3875	27.42	3377196.0
2016-04-01 15:00:00	AAPL	Stock	27.42	27.44	27.3775	27.425	4281500.0
2016-04-01 15:30:00	AAPL	Stock	27.425	27.5	27.415	27.49	12468972.0
2016-04-01 16:00:00	AAPL	Stock	27.4975	27.51	27.2582	27.505	9740344.0
2016-04-01 16:30:00	AAPL	Stock	27.5025	27.505	27.4925	27.5	136912.0
2016-04-01 17:00:00	AAPL	Stock	27.495	27.5	27.49	27.49	31176.0
2016-04-01 17:30:00	AAPL	Stock	27.48	27.4975	27.4775	27.4975	44072.0
2016-04-01 18:00:00	AAPL	Stock	27.5	27.505	27.4925	27.5	22752.0
2016-04-01 18:30:00	AAPL	Stock	27.5	27.5	27.49	27.49	3716.0
2016-04-01 19:00:00	AAPL	Stock	27.4975	27.4975	27.4825	27.4875	8768.0
2016-04-01 19:30:00	AAPL	Stock	27.4975	27.505	27.49	27.5	11200.0
2016-04-01 04:30:00	MSFT	Stock	55.03	55.03	55.03	55.03	300.0
2016-04-01 07:00:00	MSFT	Stock	55.03	55.03	55.03	55.03	400.0
2016-04-01 07:30:00	MSFT	Stock	54.95	54.99	54.95	54.99	500.0
2016-04-01 08:00:00	MSFT	Stock	55.0	55.0	54.95	54.95	1281.0
2016-04-01 08:30:00	MSFT	Stock	54.92	55.23	54.92	55.23	13416.0
2016-04-01 09:00:00	MSFT	Stock	54.95	55.15	54.72	55.15	84741.0
2016-04-01 09:30:00	MSFT	Stock	55.07	55.23	54.57	54.84	3100473.0
2016-04-01 10:00:00	MSFT	Stock	54.84	55.1	54.805	54.84	1932489.0
2016-04-01 10:30:00	MSFT	Stock	54.84	55.36	54.815	55.35	1121734.0
2016-04-01 11:00:00	MSFT	Stock	55.345	55.37	55.1	55.12	1357024.0
2016-04-01 11:30:00	MSFT	Stock	55.12	55.175	55.06	55.075	1349270.0
2016-04-01 12:00:00	MSFT	Stock	55.075	55.1	54.86	54.965	1103546.0
2016-04-01 12:30:00	MSFT	Stock	54.97	55.13	54.89	55.11	621424.0
2016-04-01 13:00:00	MSFT	Stock	55.11	55.18	55.09	55.125	793131.0
2016-04-01 13:30:00	MSFT	Stock	55.125	55.38	55.12	55.304	920595.0
2016-04-01 14:00:00	MSFT	Stock	55.31	55.39	55.28	55.35	810625.0
2016-04-01 14:30:00	MSFT	Stock	55.354	55.525	55.35	55.375	1094263.0
2016-04-01 15:00:00	MSFT	Stock	55.38	55.47	55.38	55.435	979136.0
2016-04-01 15:30:00	MSFT	Stock	55.44	55.61	55.41	55.57	3144239.0
2016-04-01 16:00:00	MSFT	Stock	55.555	55.59	55.209	55.5	4674538.0

> showing 50 of 81,782 rows — these rows as CSV

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