PREVIEW / stock_30min / 2016-07-05

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-05.parquet
  size:    1.6 MB
  rows:    82,114
  symbols: 3,255

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-07-05 04:00:00	AAPL	Stock	23.95	23.95	23.8175	23.8175	24308.0
2016-07-05 04:30:00	AAPL	Stock	23.8075	23.8075	23.8075	23.8075	1200.0
2016-07-05 05:00:00	AAPL	Stock	23.79	23.79	23.73	23.77	21308.0
2016-07-05 05:30:00	AAPL	Stock	23.7475	23.7475	23.7175	23.7475	25996.0
2016-07-05 06:00:00	AAPL	Stock	23.745	23.75	23.745	23.745	11748.0
2016-07-05 06:30:00	AAPL	Stock	23.7275	23.7575	23.7275	23.7575	16200.0
2016-07-05 07:00:00	AAPL	Stock	23.7725	23.8	23.745	23.7575	118952.0
2016-07-05 07:30:00	AAPL	Stock	23.7675	23.7675	23.7125	23.74	83328.0
2016-07-05 08:00:00	AAPL	Stock	23.7512	23.815	23.7275	23.795	134408.0
2016-07-05 08:30:00	AAPL	Stock	23.795	23.83	23.7875	23.8075	165388.0
2016-07-05 09:00:00	AAPL	Stock	23.8075	23.8475	23.785	23.845	155780.0
2016-07-05 09:30:00	AAPL	Stock	23.8475	23.85	23.6588	23.7125	19064856.0
2016-07-05 10:00:00	AAPL	Stock	23.714	23.7175	23.6275	23.6712	8945592.0
2016-07-05 10:30:00	AAPL	Stock	23.67	23.72	23.6325	23.6375	7067408.0
2016-07-05 11:00:00	AAPL	Stock	23.64	23.695	23.615	23.6575	6195084.0
2016-07-05 11:30:00	AAPL	Stock	23.6575	23.6915	23.6425	23.6762	4348016.0
2016-07-05 12:00:00	AAPL	Stock	23.6775	23.75	23.6725	23.7488	3801108.0
2016-07-05 12:30:00	AAPL	Stock	23.7475	23.75	23.6775	23.705	3857184.0
2016-07-05 13:00:00	AAPL	Stock	23.7057	23.7075	23.67	23.6838	3182936.0
2016-07-05 13:30:00	AAPL	Stock	23.6838	23.6838	23.63	23.665	3769860.0
2016-07-05 14:00:00	AAPL	Stock	23.6675	23.7078	23.66	23.679	3676520.0
2016-07-05 14:30:00	AAPL	Stock	23.6775	23.705	23.6538	23.7013	3105300.0
2016-07-05 15:00:00	AAPL	Stock	23.7025	23.7262	23.6875	23.701	5218732.0
2016-07-05 15:30:00	AAPL	Stock	23.7015	23.76	23.69	23.755	12743384.0
2016-07-05 16:00:00	AAPL	Stock	23.745	23.7725	23.6447	23.7625	14284844.0
2016-07-05 16:30:00	AAPL	Stock	23.76	23.7675	23.76	23.765	53436.0
2016-07-05 17:00:00	AAPL	Stock	23.7575	23.775	23.7575	23.775	7552.0
2016-07-05 17:30:00	AAPL	Stock	23.765	23.765	23.7575	23.7575	557384.0
2016-07-05 18:00:00	AAPL	Stock	23.7625	23.7625	23.7625	23.7625	10476.0
2016-07-05 18:30:00	AAPL	Stock	23.7625	23.7625	23.7625	23.7625	1600.0
2016-07-05 19:00:00	AAPL	Stock	23.765	23.7675	23.7625	23.7625	17196.0
2016-07-05 19:30:00	AAPL	Stock	23.7625	23.7625	23.7575	23.7575	37760.0
2016-07-05 04:00:00	MSFT	Stock	51.08	51.08	50.98	50.99	300.0
2016-07-05 04:30:00	MSFT	Stock	50.95	50.95	50.95	50.95	100.0
2016-07-05 06:30:00	MSFT	Stock	50.93	50.93	50.93	50.93	200.0
2016-07-05 07:00:00	MSFT	Stock	50.96	50.96	50.89	50.89	200.0
2016-07-05 08:00:00	MSFT	Stock	50.97	50.97	50.83	50.85	13230.0
2016-07-05 08:30:00	MSFT	Stock	50.9	51.01	50.9	50.95	750.0
2016-07-05 09:00:00	MSFT	Stock	50.95	50.95	50.82	50.83	23337.0
2016-07-05 09:30:00	MSFT	Stock	50.83	51.12	50.74	51.005	3865972.0
2016-07-05 10:00:00	MSFT	Stock	51.005	51.195	50.94	51.05	2234929.0
2016-07-05 10:30:00	MSFT	Stock	51.05	51.14	50.92	50.99	1358578.0
2016-07-05 11:00:00	MSFT	Stock	50.99	51.07	50.83	51.03	1606493.0
2016-07-05 11:30:00	MSFT	Stock	51.03	51.07	50.94	51.015	1081914.0
2016-07-05 12:00:00	MSFT	Stock	51.015	51.11	50.982	51.05	1031201.0
2016-07-05 12:30:00	MSFT	Stock	51.06	51.08	50.91	50.97	992075.0
2016-07-05 13:00:00	MSFT	Stock	50.98	51.02	50.885	50.96	817979.0
2016-07-05 13:30:00	MSFT	Stock	50.95	50.995	50.84	50.94	789845.0
2016-07-05 14:00:00	MSFT	Stock	50.935	51.025	50.871	50.9	704715.0
2016-07-05 14:30:00	MSFT	Stock	50.9	50.96	50.83	50.95	855080.0

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

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