PREVIEW / stock_30min / 2016-11-18

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-18.parquet
  size:    1.6 MB
  rows:    82,564
  symbols: 3,177

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-11-18 04:00:00	AAPL	Stock	27.385	27.385	27.305	27.305	3684.0
2016-11-18 04:30:00	AAPL	Stock	27.2825	27.2825	27.2825	27.2825	400.0
2016-11-18 05:00:00	AAPL	Stock	27.325	27.3475	27.325	27.3475	3748.0
2016-11-18 06:30:00	AAPL	Stock	27.35	27.35	27.3375	27.3375	2000.0
2016-11-18 07:00:00	AAPL	Stock	27.3575	27.41	27.3575	27.41	17148.0
2016-11-18 07:30:00	AAPL	Stock	27.4075	27.4225	27.38	27.4225	18360.0
2016-11-18 08:00:00	AAPL	Stock	27.3875	27.475	27.3875	27.4525	74392.0
2016-11-18 08:30:00	AAPL	Stock	27.4625	27.5	27.45	27.5	74040.0
2016-11-18 09:00:00	AAPL	Stock	27.4975	27.4975	27.4125	27.4225	301172.0
2016-11-18 09:30:00	AAPL	Stock	27.43	27.635	27.4225	27.5425	22039312.0
2016-11-18 10:00:00	AAPL	Stock	27.5425	27.5625	27.4675	27.5175	7462548.0
2016-11-18 10:30:00	AAPL	Stock	27.52	27.5425	27.415	27.4725	6892324.0
2016-11-18 11:00:00	AAPL	Stock	27.4725	27.545	27.4575	27.49	6413608.0
2016-11-18 11:30:00	AAPL	Stock	27.49	27.515	27.45	27.4725	4495660.0
2016-11-18 12:00:00	AAPL	Stock	27.4725	27.5188	27.465	27.5175	3694224.0
2016-11-18 12:30:00	AAPL	Stock	27.5188	27.5475	27.5025	27.5475	3577272.0
2016-11-18 13:00:00	AAPL	Stock	27.5475	27.555	27.4975	27.4975	4402704.0
2016-11-18 13:30:00	AAPL	Stock	27.4988	27.5425	27.465	27.47	3866296.0
2016-11-18 14:00:00	AAPL	Stock	27.47	27.4875	27.4325	27.445	4526152.0
2016-11-18 14:30:00	AAPL	Stock	27.4438	27.4662	27.4275	27.435	3493812.0
2016-11-18 15:00:00	AAPL	Stock	27.4375	27.51	27.4355	27.5005	5639656.0
2016-11-18 15:30:00	AAPL	Stock	27.5	27.53	27.4812	27.515	10626540.0
2016-11-18 16:00:00	AAPL	Stock	27.515	27.5175	27.468	27.5025	8465020.0
2016-11-18 16:30:00	AAPL	Stock	27.505	27.515	27.5	27.51	300176.0
2016-11-18 17:00:00	AAPL	Stock	27.5125	27.515	27.5	27.515	57100.0
2016-11-18 17:30:00	AAPL	Stock	27.515	27.525	27.5	27.5075	125080.0
2016-11-18 18:00:00	AAPL	Stock	27.5075	27.5075	27.475	27.5	42888.0
2016-11-18 18:30:00	AAPL	Stock	27.5	27.5	27.5	27.5	66644.0
2016-11-18 19:00:00	AAPL	Stock	27.5	27.505	27.4975	27.5	39524.0
2016-11-18 19:30:00	AAPL	Stock	27.505	27.75	27.505	27.5675	151276.0
2016-11-18 08:00:00	MSFT	Stock	60.78	60.94	60.78	60.92	7418.0
2016-11-18 08:30:00	MSFT	Stock	60.92	60.92	60.81	60.9	6509.0
2016-11-18 09:00:00	MSFT	Stock	60.81	60.89	60.7	60.72	23043.0
2016-11-18 09:30:00	MSFT	Stock	60.72	61.14	60.71	60.799	5647040.0
2016-11-18 10:00:00	MSFT	Stock	60.795	60.8	60.44	60.58	2380706.0
2016-11-18 10:30:00	MSFT	Stock	60.58	60.59	60.32	60.42	2369920.0
2016-11-18 11:00:00	MSFT	Stock	60.41	60.456	60.32	60.429	1255539.0
2016-11-18 11:30:00	MSFT	Stock	60.43	60.555	60.384	60.45	1162181.0
2016-11-18 12:00:00	MSFT	Stock	60.45	60.47	60.39	60.435	685826.0
2016-11-18 12:30:00	MSFT	Stock	60.44	60.52	60.395	60.515	829841.0
2016-11-18 13:00:00	MSFT	Stock	60.51	60.57	60.495	60.53	713946.0
2016-11-18 13:30:00	MSFT	Stock	60.524	60.57	60.5	60.505	683973.0
2016-11-18 14:00:00	MSFT	Stock	60.51	60.565	60.48	60.495	787678.0
2016-11-18 14:30:00	MSFT	Stock	60.49	60.6	60.47	60.55	693297.0
2016-11-18 15:00:00	MSFT	Stock	60.55	60.575	60.45	60.5	1120871.0
2016-11-18 15:30:00	MSFT	Stock	60.5	60.56	60.3	60.37	3423067.0
2016-11-18 16:00:00	MSFT	Stock	60.35	60.495	60.29	60.35	1807809.0
2016-11-18 16:30:00	MSFT	Stock	60.35	60.4	60.35	60.4	138852.0
2016-11-18 17:00:00	MSFT	Stock	60.3	60.3	60.3	60.3	100.0
2016-11-18 17:30:00	MSFT	Stock	60.35	60.35	60.35	60.35	269403.0

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

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