PREVIEW / stock_30min / 2017-06-28

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-28.parquet
  size:    1.6 MB
  rows:    82,183
  symbols: 3,012

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-06-28 04:00:00	AAPL	Stock	35.6875	35.7125	35.425	35.5025	27768.0
2017-06-28 04:30:00	AAPL	Stock	35.5025	35.6	35.44	35.525	15436.0
2017-06-28 05:00:00	AAPL	Stock	35.6	35.6625	35.525	35.6625	19548.0
2017-06-28 05:30:00	AAPL	Stock	35.695	35.7625	35.695	35.75	29416.0
2017-06-28 06:00:00	AAPL	Stock	35.75	35.7725	35.7025	35.7025	36624.0
2017-06-28 06:30:00	AAPL	Stock	35.75	35.7625	35.7	35.75	85600.0
2017-06-28 07:00:00	AAPL	Stock	35.7475	35.8	35.675	35.765	232104.0
2017-06-28 07:30:00	AAPL	Stock	35.765	35.89	35.765	35.88	106044.0
2017-06-28 08:00:00	AAPL	Stock	35.7125	36.185	35.7025	36.0475	407944.0
2017-06-28 08:30:00	AAPL	Stock	36.05	36.15	36.05	36.0825	184368.0
2017-06-28 09:00:00	AAPL	Stock	36.1	36.1625	35.975	35.985	416064.0
2017-06-28 09:30:00	AAPL	Stock	36.1225	36.1225	35.8485	35.8915	13370176.0
2017-06-28 10:00:00	AAPL	Stock	35.8925	36.0675	35.79	36.0225	8318288.0
2017-06-28 10:30:00	AAPL	Stock	36.0275	36.315	36.0125	36.2575	8536392.0
2017-06-28 11:00:00	AAPL	Stock	36.255	36.2825	36.19	36.2235	3838328.0
2017-06-28 11:30:00	AAPL	Stock	36.225	36.3325	36.1925	36.275	3693456.0
2017-06-28 12:00:00	AAPL	Stock	36.27	36.2878	36.235	36.2675	3071420.0
2017-06-28 12:30:00	AAPL	Stock	36.2675	36.465	36.2625	36.4175	5384468.0
2017-06-28 13:00:00	AAPL	Stock	36.42	36.4975	36.3825	36.4935	3799700.0
2017-06-28 13:30:00	AAPL	Stock	36.4942	36.51	36.365	36.3675	3511376.0
2017-06-28 14:00:00	AAPL	Stock	36.37	36.4325	36.37	36.3875	3329176.0
2017-06-28 14:30:00	AAPL	Stock	36.3875	36.4775	36.3862	36.4575	2563136.0
2017-06-28 15:00:00	AAPL	Stock	36.4575	36.505	36.4425	36.5	3535656.0
2017-06-28 15:30:00	AAPL	Stock	36.4975	36.5275	36.4075	36.4575	8406528.0
2017-06-28 16:00:00	AAPL	Stock	36.4575	36.4775	36.435	36.445	6286536.0
2017-06-28 16:30:00	AAPL	Stock	36.445	36.4625	36.1362	36.4575	196576.0
2017-06-28 17:00:00	AAPL	Stock	36.4575	36.4575	36.4375	36.4375	18768.0
2017-06-28 17:30:00	AAPL	Stock	36.4375	36.4475	36.435	36.435	11184.0
2017-06-28 18:00:00	AAPL	Stock	36.445	36.4725	36.4375	36.4725	49468.0
2017-06-28 18:30:00	AAPL	Stock	36.4725	36.475	36.4625	36.4625	6756.0
2017-06-28 19:00:00	AAPL	Stock	36.4625	36.475	36.46	36.46	19340.0
2017-06-28 19:30:00	AAPL	Stock	36.4575	36.475	36.4425	36.4625	18548.0
2017-06-28 04:00:00	MSFT	Stock	68.8	68.8	68.8	68.8	200.0
2017-06-28 04:30:00	MSFT	Stock	68.51	68.55	68.5	68.55	3930.0
2017-06-28 05:30:00	MSFT	Stock	68.93	68.96	68.93	68.96	600.0
2017-06-28 07:00:00	MSFT	Stock	69.0	69.0	68.91	68.92	7040.0
2017-06-28 07:30:00	MSFT	Stock	68.96	69.05	68.88	69.03	12720.0
2017-06-28 08:00:00	MSFT	Stock	68.97	69.4	68.97	69.34	32798.0
2017-06-28 08:30:00	MSFT	Stock	69.35	69.35	69.18	69.29	4039.0
2017-06-28 09:00:00	MSFT	Stock	69.3	69.34	69.13	69.2	27675.0
2017-06-28 09:30:00	MSFT	Stock	69.2	69.34	68.79	68.945	3839658.0
2017-06-28 10:00:00	MSFT	Stock	68.94	69.28	68.91	69.09	2611410.0
2017-06-28 10:30:00	MSFT	Stock	69.09	69.54	69.05	69.49	2716054.0
2017-06-28 11:00:00	MSFT	Stock	69.49	69.51	69.28	69.41	1427433.0
2017-06-28 11:30:00	MSFT	Stock	69.41	69.5	69.3	69.35	882114.0
2017-06-28 12:00:00	MSFT	Stock	69.355	69.45	69.33	69.36	772370.0
2017-06-28 12:30:00	MSFT	Stock	69.36	69.63	69.34	69.58	1042161.0
2017-06-28 13:00:00	MSFT	Stock	69.59	69.685	69.51	69.64	870561.0
2017-06-28 13:30:00	MSFT	Stock	69.645	69.73	69.59	69.62	931163.0
2017-06-28 14:00:00	MSFT	Stock	69.63	69.68	69.51	69.52	1005098.0

> showing 50 of 82,183 rows — these rows as CSV

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