PREVIEW / stock_30min / 2017-01-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-27.parquet
  size:    1.6 MB
  rows:    80,539
  symbols: 3,105

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-01-27 04:30:00	AAPL	Stock	30.4675	30.4675	30.4675	30.4675	400.0
2017-01-27 07:00:00	AAPL	Stock	30.5	30.5125	30.5	30.5125	6400.0
2017-01-27 07:30:00	AAPL	Stock	30.48	30.505	30.4625	30.4775	9400.0
2017-01-27 08:00:00	AAPL	Stock	30.4775	30.5025	30.4775	30.4975	45348.0
2017-01-27 08:30:00	AAPL	Stock	30.5	30.5375	30.5	30.525	9308.0
2017-01-27 09:00:00	AAPL	Stock	30.5175	30.55	30.49	30.5125	152724.0
2017-01-27 09:30:00	AAPL	Stock	30.53	30.5875	30.4675	30.546	11450432.0
2017-01-27 10:00:00	AAPL	Stock	30.545	30.5675	30.5	30.5275	5753204.0
2017-01-27 10:30:00	AAPL	Stock	30.5275	30.545	30.4875	30.495	4307420.0
2017-01-27 11:00:00	AAPL	Stock	30.495	30.515	30.485	30.5025	4291936.0
2017-01-27 11:30:00	AAPL	Stock	30.5025	30.5092	30.49	30.495	2530964.0
2017-01-27 12:00:00	AAPL	Stock	30.495	30.525	30.4925	30.5025	2385632.0
2017-01-27 12:30:00	AAPL	Stock	30.5012	30.5025	30.4675	30.4925	3186084.0
2017-01-27 13:00:00	AAPL	Stock	30.49	30.5015	30.4875	30.491	2586848.0
2017-01-27 13:30:00	AAPL	Stock	30.49	30.4975	30.4425	30.445	4081840.0
2017-01-27 14:00:00	AAPL	Stock	30.4458	30.4458	30.4	30.435	5451040.0
2017-01-27 14:30:00	AAPL	Stock	30.4325	30.4545	30.4275	30.4375	3536460.0
2017-01-27 15:00:00	AAPL	Stock	30.435	30.45	30.4225	30.43	4706944.0
2017-01-27 15:30:00	AAPL	Stock	30.4325	30.4925	30.425	30.43	11757096.0
2017-01-27 16:00:00	AAPL	Stock	30.43	30.4875	30.4275	30.4875	6984788.0
2017-01-27 16:30:00	AAPL	Stock	30.4875	30.4925	30.445	30.4825	203276.0
2017-01-27 17:00:00	AAPL	Stock	30.4825	30.4875	30.475	30.475	27480.0
2017-01-27 17:30:00	AAPL	Stock	30.4775	30.4925	30.475	30.4925	10632.0
2017-01-27 18:00:00	AAPL	Stock	30.475	30.475	30.4275	30.43	86068.0
2017-01-27 18:30:00	AAPL	Stock	30.4375	30.4375	30.425	30.425	16976.0
2017-01-27 19:00:00	AAPL	Stock	30.425	30.425	30.255	30.375	95504.0
2017-01-27 19:30:00	AAPL	Stock	30.3875	30.3875	30.2925	30.3875	32644.0
2017-01-27 04:00:00	MSFT	Stock	65.18	65.18	64.86	64.93	400.0
2017-01-27 06:00:00	MSFT	Stock	65.17	65.2	65.1	65.2	7741.0
2017-01-27 06:30:00	MSFT	Stock	65.14	65.2	65.14	65.2	6707.0
2017-01-27 07:00:00	MSFT	Stock	65.2	65.6	65.12	65.44	51039.0
2017-01-27 07:30:00	MSFT	Stock	65.44	65.68	65.43	65.56	90389.0
2017-01-27 08:00:00	MSFT	Stock	65.55	65.6	65.23	65.4	262393.0
2017-01-27 08:30:00	MSFT	Stock	65.38	65.4	65.07	65.19	234099.0
2017-01-27 09:00:00	MSFT	Stock	65.17	65.54	64.99	65.34	895864.0
2017-01-27 09:30:00	MSFT	Stock	65.39	65.64	64.89	65.43	10318748.0
2017-01-27 10:00:00	MSFT	Stock	65.425	65.55	65.25	65.445	3649399.0
2017-01-27 10:30:00	MSFT	Stock	65.44	65.66	65.38	65.541	3038356.0
2017-01-27 11:00:00	MSFT	Stock	65.545	65.89	65.501	65.885	2986810.0
2017-01-27 11:30:00	MSFT	Stock	65.885	65.91	65.64	65.73	2873955.0
2017-01-27 12:00:00	MSFT	Stock	65.73	65.81	65.72	65.76	1539137.0
2017-01-27 12:30:00	MSFT	Stock	65.753	65.765	65.61	65.705	1273690.0
2017-01-27 13:00:00	MSFT	Stock	65.705	65.74	65.65	65.68	1440872.0
2017-01-27 13:30:00	MSFT	Stock	65.675	65.73	65.58	65.585	1386499.0
2017-01-27 14:00:00	MSFT	Stock	65.59	65.69	65.54	65.615	1413494.0
2017-01-27 14:30:00	MSFT	Stock	65.61	65.77	65.61	65.71	2128939.0
2017-01-27 15:00:00	MSFT	Stock	65.71	65.79	65.46	65.585	2191594.0
2017-01-27 15:30:00	MSFT	Stock	65.58	65.8	65.58	65.78	4079127.0
2017-01-27 16:00:00	MSFT	Stock	65.78	65.881	65.77	65.84	2012202.0
2017-01-27 16:30:00	MSFT	Stock	65.84	65.87	65.77	65.79	9310.0

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

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